Oracle and Sybase
Database Administration -
Analysis - Architecture
A badly-designed schema can make it impossible to resolve performance problems. It can make coding mistakes difficult to avoid, literally encouraging bugs in your application. Even a schema that is well-designed, but poorly implemented in the database, will lead to poor performance. And the best-designed and -implemented schema can still encourage buggy code and bad data if it is poorly understood by the development team.
Database design A well-designed schema captures all relevant data elements and business rules. And a poorly-designed schema can make for an application that is unfixably slow.
Call me in to determine what needs to go in the database, how it all fits together and the best way to implement these rules as a schema. Call me in to redesign or renormalize a badly-implemented schema and migrate to the new design. Or, call me in to integrate new data into an existing schema -- simply tacking on fields where they don't belong leads to major headaches in the long run.
Physical architecture Have a great schema but need to implement it? Proper placement of tables and properly selected and placed indexes can have a huge impact on performance. Call me in to get it done right.
ER diagrams The best schema is of little use if the development team doesn't understand it. Call me in to diagram an existing schema, quickly grasp the relationships and help developers make optimal use of the schema.
Server capacity planning Need to do some server capacity planning? I can help you determine your needs, size your memory and disks, and recommend hardware.
Contact me now to meet your database architecture needs.