Storing persistent data in a database is somewhat of an art. The database must be designed in such a way as to be flexible enough to accommodate changing business needs.Designing data storage involves defining the relationship between different data subject areas and their attributes. The organization of this persistent data is called the data model which is a blueprint for database implementation.

The data model can be represented by using Entity Relationship Diagrams (ERDs) or Unified Modeling Language (UML). The data model can be developed based on reverse or forward engineering methods. Forward engineering is derived from business and requirements analysis. There are many tools available to create data models. Popular examples include ERWIN Data Modeler, Sybase Power Designer, Oracle Designer, Smart Draw, Visio and Rational Rose.

A & S Database Consulting Inc. helps the enterprise to design and model in the form of traditional (Simple Schema), data mart (Subject Schema) and data warehousing (Star Schema) methodology.