Post by account_disabled on Feb 20, 2024 20:08:22 GMT 10
Data modeling is understood as the process of designing and creating data models intended to serve in a specific information system. A complex and variable process depending on the organizational needs and established corporate objectives, and which involves both IT solution developers (areas, departments or professionals external to the company) and potential users of the business information system. gi_home_2 Data modeling : recommendations and process phases Data modeling seeks, as we mentioned at the beginning, to create standardized data models that must be put at the service of the corporate information system. Therefore, before starting this process, some recommendations should be taken into account that are practically universally applicable to all types of models that data modeling gives rise to.
Among these recommendations, it is worth highlighting those that refer to the usefulness of this process, which we can summarize as follows: Data modeling must serve all parties and agents involved in the organization's information system to better understand and make more appropriate use of the data integrated in the created model. Therefore, this process must start from the vision of data as resources and assets for the business, trying to design and create the most optimal models possible USA Student Phone Number List to get the most out of them. You must take into account the creation of repositories and data warehouses (following the model resulting from the process, of course) as one of your most immediate objectives. Having explained these basic recommendations and now prepared to face a data modeling process , we must take into account that (like any other process) this must run through different stages, specifically 3 , all of them necessary. Some phases that give rise, in turn, to different models, which we can specify as follows: Conceptual data model is : it is basically a set of technical specifications on the data model to be created that include, among others, the requirements expressed by the parties involved.
It is the first model resulting from the process, and as expected it handles data related to the structure and design of the data warehouses . Logical data model : the conceptual model must be translated into data structures that can be implemented in data warehouses ; Therefore, the requirements that these structures must meet must be specified. The set of these requirements is known as a logical model. Physical data model : the transformation of the logical model into a properly structured and organized database gives rise to the physical model, the final result of the data modeling process. Each of these models can be interpreted, respectively, as a scheme of rules on the data ( conceptual scheme ), as a description of the meaning of the different elements that will make up the database: tables, columns... (logical scheme), or as the relationship of the media and physical resources that will be used to store the data physical schema.