What is dimensional modeling?

Dimensional modeling is access to the design of a database that focuses on how people are likely to use a database, so it can be structured in a way that will support user questions. Although this technique is usually applied to electronic databases, it can also be used to organize a physical database such as a set of flat files. This requires some planning and anticipation, and in the case of a reworking of an existing database, the data setting process may take some time. The final result should be useful, flexible and powerful for users. The first are specific measures, numbers that can be collected, reported and organized. The second is a context that can be displayed in several dimensions. For example, in a chain of clothing stores, some dimensions may include sales numbers, orders entered for stocks, individual store numbers, etc. Hard numbers can be reported in different contexts according to this model.

essentially dimensional modeling creates a three -dimensional daA table with a connection that allows people to take data from anywhere in the database. The question could ask how many skirts were sold in the northwest area of ​​the chain operations in the third quarter of that year. The query requires a specific number and provides three dimensions for its contextualization. The resulting database search can provide this information if the dimensional modeling has been made correctly.

In the process of preparing a database of this nature, planners sit down and think about how people are likely to use a database and what questions they will probably be doing. This part of the dimensional modeling must also consider the future use of the database due to flexibility. If the database is too rigid, it will not be possible to introduce new information. As business grows and becomes more complex, it may be necessary to create a brand new database, costly process for society.

Databases to act as consultants. They can work with employees on the development of a database that will meet their needs and to give programmers a direction to allow them to formulate the backbone of the database. Creators can also think about problems such as storage needs, backup and other things that could affect the integrity of the database.