Information Modeling Research And Usage Base Relational Database

The topic of the thesis is about how to create the information modeling base in the relational database, including how to choose the design methods and the design modeling in every single stage, as well as the relation mappings between the products in different stages, and how to transfer the patterns, etc. It also introduces the investigation and research on the concurrency control in database, which includes the methods and principles of the three kinds of concurrency controls.Firstly, it introduces the base principle, data description modeling, three staging hierarchy structure theory about database, the brief introduction of the database design process modeling, and the concurrency control theory and achieve methods in database design process; the information N-tire layer and schema, then introduce the three modeling, ORM modeling, E-R modeling and UML modeling.Secondly, it introduces how to make an information modeling in a real project, how to design the database layout in the beginning, and how to analysis the business rules and business objects in database. It also describes the analysis model with DFD and DD; and transfer the ORM modeling to relation modeling in logical stage; in the end transfer the product come from the previous stage to physical modeling, and add the necessary views and indexes to optimize the performance in database.In the end, it introduces the concurrency control in real project, including the achievement and the born and erase of"dirty timestamp", etc.The related research in this thesis is based on a real project. So when I finish this topic, I'm sure I will get a clearer comprehension about what is the information modeling, and how to design a base relational database, as well as how to design a database structure and the concurrency control concept in database design.