Database design technologies

Database evolution
Tasks solved using databases
database management system
Life cycle of database projects
Database development technology
Conceptual design and modeling
Logical design and normalization
Features of physical storage and data indexation rules
Multipoling access and transactions management
data security
The book discusses the role and place of databases in modern information systems, the basic functions and architecture of the DBMS, the organization of multi -user access to data, ensuring data integrity, transaction management, physical storage of relationships, the main features of commercially successful models are discussed data. The life cycle of databases, the design of the relational databases on the conceptual, logical and physical stages, the basic constructions used in SQL-oriented DBMSs are considered.
The responsibilities of personnel designing and co-providing database, users" requirements for the database, features of the design of the customer application user interface, the possibility of interactive analytical analytical processing of the OLAP data, data safety and methods of counteracting threats, the requirements of GOST for database documentation.
Much attention is paid to the prospects for the development of databases, the transition from centralized to distributed data storage methods, object-oriented and document-oriented data model are discussed. The capabilities of the XML language are presented to work with poorly constructed data.
The book is focused on teachers and students of IT specialties, as well as to beginner developers of the database