Introduction to Databases: From Biological to Spatio-Temporal

Description

Developments in modern computers and applications have resulted in a shift away from relational databases into a chaotic proliferation of specialized database systems. As many of these advanced databases are unable to communicate with each other, database interoperability and data integration have become important challenges. The search for a suitable common standard for the numerous varieties of current databases has generated renewed interest in extensions of relational databases, such as constraint databases. This unique, reader-friendly textbook/reference provides a comprehensive coverage of the field of databases. Introduction to Databases reveals a deep insight into the workings of numerous database systems, enabling readers to develop complex and rewarding database applications. Students will gain hands-on experience by following the suggested exercises, and are offered the support to begin their own research projects in database systems. The theory covered is complemented by a detailed examination of specific applications from a broad range of diverse areas. The text assumes as prerequisite only basic discrete mathematics, linear algebra, and programming knowledge. Topics and features: • Provides chapter-by-chapter descriptions of eleven different types of databases, and presents the MLPQ and the DISCO database systems that implement several different types of databases • Concludes each chapter with bibliographic notes and an extensive set of exercises • Examines database design, including advanced database application issues of database interoperability, data integration, interpolation and approximation, and prediction and data mining • Presents the MLPQ system, together with slides, solutions (for instructors), and other course aids at the supporting website: http://cse.unl.edu/~revesz • Covers topics on indexing methods, data visualization, the safety of queries, general evaluation algorithms, the efficient implementation of evaluation algorithms, and the complexity of the evaluation of different types of queries • Structured to allow for flexible course design, with courses suggested in the Preface An essential resource for advanced undergraduate students, even non-computer science students with little prior exposure to databases will find this a clear introduction to the theory, the various types of databases and their applications. Professional database experts will also find this a valuable reference. Dr. Peter Revesz is a professor in the Department of Computer Science and Engineering at the University of Nebraska-Lincoln and has held visiting appointments at, among other places, the IBM T.J. Watson Research Center, INRIA, and the Max Planck Institute for Computer Science. Other titles by this author include the successful Springer textbook Introduction to Constraint Databases. Front Matter....Pages i-xvii Data Models, Queries, Evaluation....Pages 1-6 Propositional Databases....Pages 7-14 Relational Databases....Pages 15-42 Constraint Databases....Pages 43-65 Temporal Databases....Pages 67-79 Geographic Databases....Pages 81-109 Moving Objects Databases....Pages 111-135 Image Databases....Pages 137-151 Constraint Objects Databases....Pages 153-178 Genome Databases....Pages 179-203 Set Databases....Pages 205-234 Constraint Deductive Databases....Pages 235-260 The MLPQ System....Pages 261-333 The DISCO System....Pages 335-349 Database Design....Pages 351-383 Interoperability....Pages 385-416 Data Integration....Pages 417-434 Interpolation and Approximation....Pages 435-483 Prediction and Data Mining....Pages 485-500 Indexing....Pages 501-535 Data Visualization....Pages 537-554 Safe Query Languages....Pages 555-570 Evaluation of Queries....Pages 571-620 Implementation Methods....Pages 621-653 Computational Complexity....Pages 655-683 Software Verification....Pages 685-699 Back Matter....Pages 701-753