Computer consulting services for database development

Optimal staffing for an IT department is not constant. As the workload, depending on the number of projects and lifecycle stage, changes so does the number of engineers required. Many tasks and deliverables qualify for outsourcing, giving you a fixed time and cost estimate.

• Jayzed Data Models can temporary enforce your team in these peaks (hourly contract).

• Jayzed Data Models develops custom software at your location or at our own facilities (fixed price contract).

  ---

We provide support and leadership in the complete database development lifecycle, ranging from requirement analysis construction of the database to programming the DB access layer. [Jurgen Ziemer, Data Architect]

Business Analysis

This important phase leads to the Requirement Definition. Business Analysis requires teamwork with your domain experts: Industry Professionals, (End-) Users, Management, IT-Personnel ...
Jayzed Data Models has conducted analysis in Financial, Ticketing / Accounting and Media Industry.  

Data Modeling

The established Business Rules according to your requirements will then be represented in a concise data model. I have 8 years industry experience developing database models on Silverrun, ERWIN or your tool of choice. Automatic schema generation will deploy multiple platforms like MS-SQLServer, Informix, Oracle or your designated target systems.

Data Reconciliation & Derivation

These techniques apply not only to Data Warehouses. Reconciliation is the process of importing your legacy information into the new database. Derivation employs sophisticated tools and queries to do just the opposite - denormalizing and preparing data for your Decision Support and Reporting applications.

SQL, Stored Procedure/Trigger programming

Structured Query Language is still the most powerful tool for data presentation and manipulation. I have 10 years Industry experience in SQL programming. Stored Procedures enable the architect to place data related logic at one and only one place - the database itself. Triggers take referential integrity a step further, adding constrains that can not be defined in schema DDL.

Database interface programming

Finally Jayzed Data Models provides the interface to your new database. For maximum flexibility the interface may be ODBC based having a well defined set of access functions/classes or a table/view representation in your productivity tool. I have 10 years industry experience developing client /server solutions.