All You Need to Know About Data Warehousing and Data Modeling
Data Warehousing
The storing of the necessary information and data are important areas of concern for the organizations. The data warehousing process is made use of to manage as well as to present the required information in a manner, so that decision making becomes a quick affair. In other words, its work is related to the managing of all the necessary data into the database to ensure a hassle free decision making procedure.
A data warehouse is highly flexible in nature as it can be normalized as well as denormalized as per the needs of the enterprises. It can either be a multidimensional database, object database, relational database or other type of database. It usually includes various kinds of data that portray the scenario of the present business situation at a particular time.
The development of it requires the development of systems that would extort the data from the various operating systems. Its development also includes the set up of a warehouse database system. It thus allows easy and smooth access to data.
A data warehouse usually dwells on the main server of an enterprise. It lays stress on the seizing of the data from varied sources for the purpose of analysis and accessing. Applications related to it include web mining, data mining and decision support system.
Data Modeling
Data modeling refers to the activity of the analysis of the data objects, which are made use of in business or other fields. It also adverts to the analysis related to the recognizing of the relationship that exists between all the data objects.
The three styles of data model are, Conceptual Data Models, Logical Data Models and Physical Data Models. The Conceptual Data Models recognizes the robust relationships that exist between the various entities. The Logical Data Models is used for the description of data as to in what way they would be implemented in the database. A Physical Data Model provides a representation as to how the model would be created in the database.
Data models can also be categorized in two categories. These categories are object-based logical model and the record-based logical model. The former concentrates on the description of the data and the relationship that exists between all the data. The latter concentrates on the description of the data structure and the technical methods of access in the DBMS.
Data Warehousing and Data Modeling is both essential for smooth functional operations of an enterprise.
The storing of the necessary information and data are important areas of concern for the organizations. The data warehousing process is made use of to manage as well as to present the required information in a manner, so that decision making becomes a quick affair. In other words, its work is related to the managing of all the necessary data into the database to ensure a hassle free decision making procedure.
A data warehouse is highly flexible in nature as it can be normalized as well as denormalized as per the needs of the enterprises. It can either be a multidimensional database, object database, relational database or other type of database. It usually includes various kinds of data that portray the scenario of the present business situation at a particular time.
The development of it requires the development of systems that would extort the data from the various operating systems. Its development also includes the set up of a warehouse database system. It thus allows easy and smooth access to data.
A data warehouse usually dwells on the main server of an enterprise. It lays stress on the seizing of the data from varied sources for the purpose of analysis and accessing. Applications related to it include web mining, data mining and decision support system.
Data Modeling
Data modeling refers to the activity of the analysis of the data objects, which are made use of in business or other fields. It also adverts to the analysis related to the recognizing of the relationship that exists between all the data objects.
The three styles of data model are, Conceptual Data Models, Logical Data Models and Physical Data Models. The Conceptual Data Models recognizes the robust relationships that exist between the various entities. The Logical Data Models is used for the description of data as to in what way they would be implemented in the database. A Physical Data Model provides a representation as to how the model would be created in the database.
Data models can also be categorized in two categories. These categories are object-based logical model and the record-based logical model. The former concentrates on the description of the data and the relationship that exists between all the data. The latter concentrates on the description of the data structure and the technical methods of access in the DBMS.
Data Warehousing and Data Modeling is both essential for smooth functional operations of an enterprise.
Source...