The Data modeling and design or data modeling and design is the procedure of documenting the design of a complex software system as an easy-to-understand diagram., using text and symbols to represent the way data should flow. The diagram can be used as a blueprint for the creation of new software or for the reengineering of a legacy application.
Within data management, a set of specifications is needed to structure and organize relational data. This function is called data model and design.
In function of Data modeling and design descends to a lower level in the structure it is in organize data, reaching the level of databaseA database is an organized set of information that allows you to store, Manage and retrieve data efficiently. Used in various applications, from enterprise systems to online platforms, Databases can be relational or non-relational. Proper design is critical to optimizing performance and ensuring information integrity, thus facilitating informed decision-making in different contexts..... Unlike the function of data architecture, which is global and describes how the data is structured and how the company understands it; in this function, model and design, is already going into detail in the done in itself, being therefore much more specific.
Model and design
The function is deployed in two processes that must be developed jointly and which are:
- Modeling: it is the task of structuring and organizing the data. The data model is a diagram that uses text and symbols, and is used for represent not only data, but also their relationships. Corresponds to logical design.
- Design: it is convert logical data model to physical design, make it come true, transform it into something tangible.
The objective pursued with this tool is be able to use data as a resource.
Data modelers often use multiple models to view the same data and make sure all processes have been identified, entities, relationships and data flows. There are several different approaches to data modeling, including:
Traditionally, data models have been created during the analysis and design phases of a project to ensure that the requirements of a new application are fully understood. A data model can be thought of as a flow chart illustrating the relationships between data. Even though capturing all possible relationships in a data model can take a long time, it is an important step that should not be rushed. Physical data models, Well-documented conceptual and logic enable stakeholders to identify bugs and make changes before any programming code has been written. .
