Database systems - new edition changed and extended

This is a new edition - significantly modified and extended - of the manual published by the Scientific and Technical Publishers in 1998.
The book is devoted to modern database technology and creation of database systems. It can be included in the classic textbook positions due to both layout and content. The lecture is conducted with a focus on modeling real organizations. This aspect makes the book attractive and distinguishes it from others - more theoretical.
The author explains the basic features of database systems. Presents data models. He discusses two main elements of modern client database management systems: the interface and the toolkit, as well as the main element of modern server management systems from the server side, i.e. its core. It describes two basic standards: SQL3 and ODMG. He discusses the stages of the design and implementation of database systems, as well as the methods used in them. It explains what database planning and administration is all about. It presents new applications of databases, namely data warehouses, OLAP analytical applications and internet databases.
The book is written very easily, and its substantive value is raised by aptly selected examples, sets of exercises with answers and a glossary of concepts. After reading it, the reader will be pleased to find that many problems in the field of databases are much simpler and easier than previously thought.

Table of Contents

Preface to the second edition

Part 1: Basics

1. Data bases as abstract machines
2. Basic concepts
3. Data bases and information systems
4.Entering data management

Part 2: Data models

5.Regular data model
6. Classical data models
7. The object data model
8.Deductive data model
9. Auxiliary data model

Part 3: Database management systems (DBMS) - interface and toolkit

10. DBMS interface - SQL language
11. A set of DBMS tools
12.Set of DBMS tools - application development tools
13.The DBMS toolkit - database administration tools

Lot 4: Database management systems - kernel

14. Data management
15. Access mechanisms
16. Managing transactions
17.Other functions of the DBMS kernel

Part 5: Database management systems - commercial standards and systems

18. Relational DBMS
19. ODMG object model
20.Microsoft Access
21.DBMS ORACLE
22. DBMS O2

Part 6: Creating databases

23.Normalizacja
24.Djagrams of entity relationships
25. Object modeling
26. Physical database design
27. Implementation of the database

Part 7: Planning and administering database systems

28.Strategic data planning
29. Administering data
30. Administering the database

Lot 8: Trends and features in database technology

31. Dissolved databases
32.Równoległość
33. Multimedia data

Part 9: Database applications

34. Data warehouse
35. On-line analytic processing (OLAP)
36. Data exploration
37. Database internet applications

Examples of solutions
Dictionary and index