Social Icons

21 March 2011

Data modeling

Data modeling is the process of creating a data model by applying formal data model descriptions using data modeling techniques.

In other words Data modeling can be defined as a method used to define and analyze data requirements needed to support the business processes of an organization.

Conceptual, logical and physical schemes :
  • Conceptual schema: This consists of entity classes, representing kinds of things of significance in the domain, and relationships assertions about associations between pairs of entity classes. A conceptual schema specifies the kinds of facts or propositions that can be expressed using the model.
  • Logical schema:  This consists of descriptions of tables and columns, object oriented classes, and XML tags, among other things.
  • Physical schema: describes the physical means by which data are stored. This is concerned with partitions, CPUs, table spaces, and the like.
Modeling methodologies :

Data models represent information areas of interest. While there are many ways to create data models, But only two modeling methodologies standard  top-down and bottom-up are used in real time environment :

  • Bottom-up models : are often the result of a reengineering effort. They usually start with existing data structures forms, fields on application screens, or reports. These models are usually physical, application-specific, and incomplete from an enterprise perspective. They may not promote data sharing, especially if they are built without reference to other parts of the organization.
  • Top-down logical data models, on the other hand, are created in an abstract way by getting information from people who know the subject area. A system may not implement all the entities in a logical model, but the model serves as a reference point or template.

2 comments:

  1. this is very nice and informative article. informatica training, informatica online training, informatica training in bangalore, informatica online training in bangalore
    informatica training, informatica online training, informatica training in bangalore, informatica online training in bangalore

    ReplyDelete