Home > Resource Center > Whitepaper: Model Behavior – An Introduction to Data Models

Whitepaper: Model Behavior – An Introduction to Data Models

A data model organizes data elements and standardizes their relation to each other and the properties of real-world entities. E.F. Codd introduced the relational database model in 1970, which uses tables to make databases independent of other software applications. Database normalization is the process of structuring a relational database to reduce data redundancy and improve data integrity.

Some data models are more generalized than the relational model and are sometimes known as post-relational models. A star schema is one such model and is the most common data model used in data warehouses. Star schemas are unnormalized and consist of at least one fact table that references any number of dimension tables.

This paper discusses two of the most common database models, a normalized relational database and unnormalized star schema, each of which has its advantages.

Register to read the full whitepaper.

The reCAPTCHA was invalid. try it again.
By registering, you confirm that you agree to the processing of your personal data by Embarcadero, Inc. d.b.a ER/Studio as described in the Privacy Statement. ER/Studio is part of the Idera group and may share your information with its parent company Idera, Inc., and its affiliates. For further details on how your data is used, stored, and shared, please review our Privacy Statement.
Aligning complex data environments with business goals for over 30 years.
Copyright © 2024 Idera, Inc.