Data modeling
|
|
In information system design, data modeling is the analysis and design of the information in the system, concentrating on the logical entities and the logical dependencies between these entities. Data modeling is an abstraction activity in that the details of the values of individual data observations are ignored in favor of the structure, relationships, names and formats of the data of interest, although a list of valid values is frequently recorded. It is by the data model that definitions of what the data means is related to the data structures.
While a common term for this activity is "data analysis" the activity actually has more in common with the ideas and methods of synthesis (putting things together) than it does in the original meaning of the term analysis (taking things apart). This is because the activity strives to bring the data structures of interest together in a cohesive, inseparable, whole by eliminating unnecessary data redundancies and relating data structures by relationships.
In the early phases of a software development project, emphasis will be on the design of a conceptual data model. This can be detailed into a logical data model sometimes called a functional data model. In later stages, this model may be translated into physical data model.
Several techniques have been developed for the design of a data models. Most noticeable are:
- RM/T
- Bachman diagrams
- Entity-relationship diagrams
- Object Role Modeling (ORM) or NIAM
- Object-relationship modeling
See Also
- Abstraction (computer science)
- Be sure to look for the Data Modelers joke on the Lightbulb jokes entry.
External links
- Data Modelling Tools (http://www.databaseanswers.com/modelling_tools.htm) from DatabaseAnswers.com