Database Theory and Systems

The book shows how to make the rich information content of bi-temporal data available to business users, while simplifying the design, maintenance and retrieval of that data. Metadata declarations eliminate the need to directly model temporal data. Temporal data maintenance is isolated in code that can be invoked to update bi-temporal data in any database and from any application program, across the enterprise. Anyone who can write queries against conventional data will be able to write queries against the bi-temporal data structures described in this book.

This book delivers a thorough discussion of the foundations of the relational model of database design along with a systematic treatment of the formal theory for the model.

Lessons from database research have been applied in academic fields ranging from bioinformatics to next-generation Internet architecture and in industrial uses including Web-based e-commerce and search engines. The core ideas in the field have become increasingly influential.

Written by three leading researchers in the field, this book provides in-depth coverage of the theory concerning the logical level of database management systems, including both classical and advanced topics:

Written by the originator of the relational model, this book covers the practical aspects of the design of relational databases. The author defines twelve rules that database management systems need to follow in order to be described as truly relational and then gives the motivation behind these rules. This book is a perfect resource for students and professionals in the field.

The book is intended for a second course in databases, but is an excellent reference for researchers in the field. The material covered includes relational algebra, functional dependencies, multivalued and join dependencies, normal forms, tableaux and the chase computation, representation theory, domain and tuple relational calculus, query modification, database semantics and null values, acyclic database schemes, template dependencies, and computed relations.

This book is about techniques for concurrency control and recovery. It covers techniques for centralized and distributed computer systems, and for single copy, multiversion, and replicated databases.

The book presents a conceptually complete coverage of indispensable topics that each MIS student should learn if that student takes only one database course. Database design and data modeling encompass the minimal set of topics addressing the core competency of knowledge students should acquire in the database area. The text, rich examples, and figures work together to cover material with a depth and precision that is not available in more introductory database books.

Practical and easy to understand, this book gives readers a solid foundation in database design and implementation. Filled with visual aids such as diagrams, illustrations, and tables, this market-leading book provides in-depth coverage of database design, demonstrating that the key to successful database implementation is in proper design of databases to fit within a larger strategic view of the data environment.

Learn the basics of relational database theory and other information models. This book discusses database logical and physical design, and introduces you to the SQL language. Practice with hands-on exercises! Read this free ebook to:

This book consists of a collection of exploratory essays on database management - more specifically, on issues arising from and related to The Third Manifesto, which is a proposal by the authors for a foundation for data and database management systems (DBMSs)

This is a book on database management that is based on an earlier book by the same authors, Foundation for Future Database Systems: The Third Manifesto. It can be seen as an abstract blueprint for the design of a DBMS and the language interface to such a DBMS.

This book covers database systems and database design concepts. It provides short, easy-to-read explanations of how to get database design right the first time. It also offers numerous examples to help you avoid the many pitfalls that entrap new and not-so-new database designers.

This book describes how to apply the business and technical approaches of Database Lifecycle Management (DLM) in order to make database change management processes more visible, predictable and measurable. We describe the DLM skills and methods that will support a continuous and incremental approach to database change, establish predictable delivery times and result in higher quality, more maintainable database applications.

Databases are not black boxes. Understand them by building your own from scratch!