data model


Also found in: Dictionary, Thesaurus, Medical, Legal, Financial, Acronyms, Wikipedia.

data model

(database)
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].

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.)
References in periodicals archive ?
Open data model systems are not just about technological solutions, but also about supporting and facilitating workflows.
The data model supports using a data table with numerous lookup tables--which is cool.
CMQS is the abstract layer where we specify queries against the specific data model to extract data.
The first part of Section 3 discusses the basic concept of linking the topological data model based on IndoorGML, omnidirectional images, and a POI representing facilities for indoor patrol services.
An adequate approach to define such a standard would be based on the object-oriented data model (Aberer, 1995).
More importantly, it also makes the data sets eligible for the Data Model.
Key words: Bioinformatics, Conceptual data model, Biological data, Central dogma.
The topologically enabled multi-scale data model proposed in this paper integrates the concepts of object-oriented data modeling presented earlier in order to automate the comparison of polygon (or raster) layers.
PODS has been working with the International Pipeline and Offshore Contractors Association (IPLOCA) for more than a year to identify recommended additions to the PODS Data Model for capturing important data associated with design and construction phases of pipeline projects.
In a second step, we studied a hurdle Poisson data model (see Mullahy 1986) because the standard count-data model may not suffice to capture the excess counts of countries that won no medals at all.
TELECOMWORLDWIRE-May 22, 2012-Oracle announces TM Forum-certified Oracle Communications Data Model 11.3.1(C)1994-2012 M2 COMMUNICATIONS http://www.m2.com
The Emirates e-Government hosted a meeting between the Data Model Dictionary initiative team and experts from Gulf Business Machines (GBM), the region's leading IT solutions and service provider, and IBM's representative in the Gulf Region.