Home Core Competencies Technology Rates Resume Contact

Relational Database Implementation

Moving from a conceptual data design to a physical database implementation is a critical process, benefiting from both conceptual relational principles and extensive knowledge of database vendor-specific features.

Assistance can be provided with execution or verification of the following tasks.

Normalization: domain/key normal form (a sigificant refinement over 3NF) is the goal for most situations.

Primary key selection: relies on an understanding of the relative benefits of surrogate vs. candidate keys, the strengths & weaknessses of multipart keys.

Indexing: much basic indexing is rote, but the creation of multipart key indexes and the optimal order of keys (for example) must be based on an appreciate of application requirements.

Denormalization: an unpleasant reality for many system, performance and programming considerations sometimes make this a requirement.  Such data should always be maintained automatically via triggers if possible, and consistency maintained through non-primary key constraints wherever possible.

Referential Integrity declaration: sometimes regarded as an inconvenient luxury, declarative RI is the most important tool for guarding against application errors.

Security and authorization strategies: modern database offer an array of approaches to database object access control in addition to the traditional.

Hardware selection & utilization: performance and reliability can both be optimized by appropriate allocation of database files across available devices, and appropriate use of technologies such as RAID.

SQL Development >>>

© Copyright 2013 Max Stayner.  All rights reserved. max@rowcount.com Tel: (415) 738-7359