Integrate Key Components
High Quality Database
A good data model is always adequate the business and at the same time it is well designed from a formal point like normalisation/de-normalization techniques. The model has to be created and supported using modelling tools for self-documenting and easiness of extensions and understanding.
Minimising and centralising of data control points using descriptive methods like database constraints and server procedures provide an essential improvement of the data quality eliminating incompleteness and discrepancies of the data rule checks. It accelerates data processing and reduces the application code.
Well-tuning database instance brings a lot to the database quality providing as fast as possible data access and/or data modification. Instance tuning focuses on potential database performance bottlenecks that can be different for each type of the database application (OLTP, OLAP, DSS, mixed type).
Although in many aspects SQL performance is pre-defined by the data model - logical design intends the best data navigation and physical design suggests the fastest access to the data, it can be substantially refined applying SQL tuning techniques that pay attention for the particular SQL running conditions.
ROI of your software
Data modelling theory has being successfully evolved during the last three
decades giving practical recommendations for a good data design.
Data modelling tools as Erwin, Embarcadero, Oracle SQL Data Modeller
provide a strict engineering approach to design and support a proper data back-end structure in the database with "self-documenting" features providing design diagrams, metadata reports, version support and generation of DDL scripts.
Server side declarative & procedure centralized data control/processing have been delivered by main database vendors since beginning of 90’s. Oracle database, since Oracle 7 (1992), has primary, unique, foreign key and check constraints imposed on the data and server PL/SQL procedures running within the database server engine.
Database and server procedure tuning tools like Oracle Enterprise Manager with Tuning Pack and HPROF provide efficient way to detect and fix instance, SQL and PL/SQL code performance issues.
Low quality of database devaluates IT investments and it can be extremely costly
due possible damage of vital enterprise data or a bad data access.
Database quality is like a house basement and if it’s not good enough there is
no much worth for the house at all including the expensive house decoration.
Our long practical experience of back-end data development shows that a number of companies miss essence of the database quality with the reasons spotted from the practice:
Reach High Quality
Protect IT Investments