DATA MODELING
Relational
Relational Models are a top-down approach to data modeling, used to design operational and warehouse data into a standard set of business domains, entities, and attributes. Logical and physical Data Models present data schemas in graphical form, and illustrate the relationships between entities.
DATA MODELING
Logical
Logical Models normalize the requirements and Metadata that is identified and captured during business modeling. Logical models are developed independently of any specific platform which it can be implemented. The logical model becomes the framework for the Physical Model. More...
DATA MODELING
Physical
Physical Models translate and map logical models into a specific set of physical structures and characteristics. Physical models are technology dependent since the internals of each database management system are different. The physical model provides the requirements for Data Engineering. More...
DATA MODELING
Dimensional
Dimensional Models are a bottom-up approach to data modeling, popular in Business Intelligence (BI) and Data Analytics, where a common set of metrics (referred to as Facts) are first independently identified and modeled. The facts are then reused and aggregated across various business entities, segments, and time periods (referred to as Dimensions).
DATA MODELING
Metadata
Data Modeling generates and captures Structural Metadata, which are physical characteristics of data, such as table name, column name, and data type. Metadata replaces old-school business requirements and documentation. The Metadata Registry, also referred to as a Data Dictionary or Data Catalog, is a central location in an organization where metadata is defined, stored, maintained, and published. More...
DATA MODELING
Projects & Consulting
We specialize in Data Modeling. Take advantage of our insight and years of experience on your next project. We manage entire projects, subcontract, and consult. We don't do staff augmentation or W2. We work corp-to-corp, on either a fix-bid or cost-plus basis. We deliver innovative, cost effective solutions that will crush your requirements. More...
