data model definition of data model in the Free Online Encyclopedia.

data model

A description of the organization of a database. It is often created as an entity relationship diagram. Today's modeling tools allow the attributes and tables (fields and records) to be graphically created. The SQL code that defines the data structure (schema) in the database is automatically created from the visual representation. See entity relationship model.

Building an Entity Relationship Model

The Erwin modeling program from Logic Works, Princeton, NJ, stands for Entity Relationship for Windows. In this order processing example, the tables for customers and orders are drawn graphically, and Erwin turns the graph into the appropriate SQL code for the target database. (Example courtesy of Logic Works, Inc.)

(database)

data model - The product of the database design process which aims to identify and organize the required data logically and physically.

A data model says what information is to be contained in a database, how the information will be used, and how the items in the database will be related to each other.

For example, a data model might specify that a customer is represented by a customer name and credit card number and a product as a product code and price, and that there is a one-to-many relation between a customer and a product.

It can be difficult to change a database layout once code has been written and data inserted. A well thought-out data model reduces the need for such changes. Data modelling enhances application maintainability and future systems may re-use parts of existing models, which should lower development costs.

A data modelling language is a mathematical formalism with a notation for describing data structures and a set of operations used to manipulate and validate that data.

One of the most widely used methods for developing data models is the entity-relationship model. The relational model is the most widely used type of data model. Another example is NIAM.

["Principles of Database and Knowledge-Base Systems", J.D. Ullman, Volume I, Computer Science Press, 1988, p. 32].

Mentioned in	?		References in periodicals archive	?		Encyclopedia browser	?		Full browser	?
No references found	Summary A dimensional data model is often considered as a better option for data warehouse as compared to standard data model This is because a dimensional model has a number of data warehouse advantages Summary: A dimensional data model is often considered as a better option for data warehouse as compared to standard data model. Building a Dimensional Data Model for a Data Warehouse by Brian May / Computers and Internet community Additional content in the form of data mapping rules combined with the target data model help alleviate much of this pain. Lesson plan: insurers looking to leverage data assets discover ... by Saporito, Pat / Best's Review Developers need vendors to consistently look for creative ways to help simplify how they build and manage data models, databases and data warehouses so they can leverage the value of business information across increasingly complex environments," said Sean Graham, vice president, software engineering for Data Modeling at CA. CA ERWIN DATA MODELING SUITE NAMED TO SD TIMES 100 by Worldwide Databases	data library data line data line monitor data link Data Link Connection Identifier data link escape data link layer data link level data link protocol Data Link Provider Interface data loading data log data logger data logging data management Data Management Language data management program data manipulation data manipulation language data marshalling data mart data migration data miner data mining data mirroring data model data modeling data modelling data modem data module data move instruction data mover data name data network data organization data origination Data Output Data Over Cable Service Interface Specification Data Over Cable Systems Interface Specifications data packet Data Parallel Haskell data patch panel data path data pipe data plotter data portability data processing data processing center data processing inventory data processor data projector	Data Miniaturization Technology data mining data mining data mining data mining data mining Data Mining and Analysis Data Mining and Artificial Intelligence Data Mining and Bioinformatics Data Mining and Data Warehousing Data Mining and Informatics Research Group Data Mining and Information Retrieval Data Mining and Knowledge Discovery Data Mining and Machine Learning Data Mining and Web Intelligence Data Mining Extensions Data Mining for Actionable Knowledge Data Mining for Business Applications Data Mining in the Life Sciences Data Mining Institute Data Mining Lessons Learned Data Mining Query Language Data Mining Template Library Data Mining Using Matrices and Tensors Data mirroring Data Mode data mode control Data Mode Idle data model Data Model Working Group Data modeling Data Modeling and Analysis Group Data Modeling and Relational Database Design Data modelling data modem Data Modification Language Data Modulation Encoder data module Data Module Requirements List Data Monitor Tool Data Monitoring and Ethics Committee Data Monitoring Committee data move instruction data mover Data Multiplex System Data Multiplex Unit data multiplexer Data Multiplexing Network Data Munging with Perl data name Data Name Card Data Net Control Unit Data network Data network

Mentioned in

References in periodicals archive

Encyclopedia browser

Full browser

No references found

Summary A dimensional data model is often considered as a better option for data warehouse as compared to standard data model This is because a dimensional model has a number of data warehouse advantages Summary: A dimensional data model is often considered as a better option for data warehouse as compared to standard data model.

Building a Dimensional Data Model for a Data Warehouse by Brian May / Computers and Internet community

Additional content in the form of data mapping rules combined with the target data model help alleviate much of this pain.

Lesson plan: insurers looking to leverage data assets discover ... by Saporito, Pat / Best's Review

Developers need vendors to consistently look for creative ways to help simplify how they build and manage data models, databases and data warehouses so they can leverage the value of business information across increasingly complex environments," said Sean Graham, vice president, software engineering for Data Modeling at CA.

CA ERWIN DATA MODELING SUITE NAMED TO SD TIMES 100 by Worldwide Databases

Data Miniaturization Technology
data mining
data mining
data mining
data mining
data mining
Data Mining and Analysis
Data Mining and Artificial Intelligence
Data Mining and Bioinformatics
Data Mining and Data Warehousing
Data Mining and Informatics Research Group
Data Mining and Information Retrieval
Data Mining and Knowledge Discovery
Data Mining and Machine Learning
Data Mining and Web Intelligence
Data Mining Extensions
Data Mining for Actionable Knowledge
Data Mining for Business Applications
Data Mining in the Life Sciences
Data Mining Institute
Data Mining Lessons Learned
Data Mining Query Language
Data Mining Template Library
Data Mining Using Matrices and Tensors
Data mirroring
Data Mode
data mode control
Data Mode Idle

data model

Data Model Working Group
Data modeling
Data Modeling and Analysis Group
Data Modeling and Relational Database Design
Data modelling
data modem
Data Modification Language
Data Modulation Encoder
data module
Data Module Requirements List
Data Monitor Tool
Data Monitoring and Ethics Committee
Data Monitoring Committee
data move instruction
data mover
Data Multiplex System
Data Multiplex Unit
data multiplexer
Data Multiplexing Network
Data Munging with Perl
data name
Data Name Card
Data Net Control Unit
Data network
Data network