Conclusion - Databases: design


The first part of the textbook is focused on the consideration of the design and modeling of databases at the conceptual, logical and physical levels of representation. Knowledge and understanding of the technologies studied in the textbook gives huge opportunities to create effective information systems that apply databases. Starting to consider the subject area for the purpose of building an information system, the developer regularly addresses the issue of structuring information that should be processed in the information system. While the modeling of business processes of the subject area is focused on the consideration of material flows, if we talk about the implementation of information traffic with the help of a database, the alignment of information structures in the form of business elements with information structures that are represented by objects or documents of the domain allows us to create conceptual presentation of data. But, in order that this can be done in the most effective way, it is important to know the terminology and understand the concepts of databases, considered at the level of the information system and domain, which was presented in Ch. 1 of this textbook

Building the conceptual model of the database and focusing on its further implementation in the information system at the program level, the developers are constructing a logical model using methods of normalizing relations based on technologies and laws developed by E. Codd. You can manually build a database, but the use of specialized tools greatly simplifies this process, allowing not only to conduct some normalization procedures, but also to describe in detail each element of the model that will subsequently be represented by database objects.

The first part of the tutorial gives enough detailed guidance on how to use the two most common tools on the market, in conjunction with the implementation of approaches to the organization of the database development process. These approaches implement two views on the database design process, where one (documented) approach is based on a classical domain study in terms of document structures used in the subject area, but not taking into account the characteristics of undocumented information that are often necessary for the most efficient work with data . The second (object) approach is based on the understanding that any domain document contains information about certain tangible and intangible objects of the domain, information about which must be presented in the database and processed in the information system. Given the need for data processing, the object approach, when building a database model, is based not only on document structures, but also on those information needs that are formulated by customers.

Chapter 2 of the textbook just gives information on how to approach the analysis of the subject area in order to build complexes of information structures for the subsequent modeling of the database, and gl. 3 provides sufficient information for studying the ways and methods of using various tools, including the transitions between the levels of database modeling.

In Ch. 4 and 5, the basic rules and technologies of the processes of constructing the logical and physical models of databases were formulated using the possibilities of normalizing relations and relationships, as well as the possibilities of building models using tools. In addition, in Ch. 5, as part of the process of modeling the physical model of the database, the issues of link integrity organization are considered, the implementation of which allows creating a database that the information stored in it will not be inconsistent and can always be accessed using presentation tools data processing.

One of the unique technologies formulated in Ch. 5, is the simulation of the implementation of data processing procedures. Previously, these processes were represented by block diagrams of algorithms, but these models are not oriented to work with databases. The described technologies exhaustively show how to model the processes of sampling and data processing at the level of representations, stored procedures and triggers.

Further consideration of the process of database development represents the study of technologies for implementing data structures in DBMS and program logic for sampling and processing data for the purpose of building highly efficient information systems.

Also We Can Offer!

Other services that we offer

If you don’t see the necessary subject, paper type, or topic in our list of available services and examples, don’t worry! We have a number of other academic disciplines to suit the needs of anyone who visits this website looking for help.

How to ...

We made your life easier with putting together a big number of articles and guidelines on how to plan and write different types of assignments (Essay, Research Paper, Dissertation etc)