Fundamentals of database systems

Sample

Stephanie Cammarata ... [et al

This report describes the RAND Metadata Management System (RMMS), a system that manages metadata--definitional and descriptional information about databases, simulation models, and procedures--for relational databases such as those maintained in INGRES. Many of these databases have little documentation or other descriptional information to accompany them, making it difficult for users to understand the definitions, abbreviations, acronyms, and descriptions of the data elements stored and maintained in a database management system. The authors developed the RMMS with five major goals in mind: (1) provide complete, thorough, and standard database documentation; (2) record and manage information about different versions of each database; (3) maintain a history of the changes made to database tables, schema, or data values; (4) facilitate deriving databases for input to simulation models and for sharing among models; and (5) standardize the names of data elements that are conceptually the same but named differently or are named the same but are conceptually different. This report should be of help to users of other relational databases who would like to develop a similar metadata repository for their own set of databases.

Sample

Ching-chih Chen, Peter Hernon

The purpose of this book is to provide readers with the fundamentals of numeric databases and draw attention to them, their value, and utility to libraries and information centers. The public needs access to information which does not always appear in print format. Libraries and information centers must be aware of these resources, and recognize that they are essential information sources for a growing number of subjects. Subjects where the use of large sets of statistical data is becoming common are particularly important. This book is aimed at those readers wanting an introduction to many facets of the subject.

Sample

Jeffrey D. Ullman

1. The material on optimization has been expanded, by including a discussion of the System R approach to optimization, tableau-based methods, and optimization in the distributed environment. 2. There is a discussion of universal relation systems, which are relational database systems that support a user view that looks like a single relation. 3. Concurrency control by "optimistic," or timestamp-based methods has been introduced. 4. Distributed systems are covered, both for optimization issues and concurrency control. 5. A discussion of data structures for range queries appears. 6. There is an introduction to generalized dependencies and their inference. The second edition was prepared using Don Knuth's TEX typesetting system.

Sample

Michael Lee, Mike Mansfield

"Perfect companion to any SQL Server 2008 book, providing fast, accurate answers on the spot for millions of IT professionals System and database administrators, IT consultants, and database application developers often need quick answers and practical solutions for SQL Server issues. This convenient guide offers you quick referencing for the product and database topics you need most. If you're an IT administrator looking for the essentials in the day-to-day tasks of administering SQL Server 2008, you'll appreciate this book's design for providing quick and easy look up of solutions and tables, lists, and step-by-step instructions for answers on the spot. SQL Server 2008 Instant Administration Reference is a guide that you want to keep within reach. SQL Server is Microsoft's bestselling database manager; the 2008 version offers enhanced security and high availability, encouraging users to upgrade Features thumb tabs, secondary and tertiary tables of contents, and special heading treatments to provide quick and easy lookup, as well as quick-reference tables and lists to provide answers on the spot Covers installing, configuring, managing, and maintaining SQL Server; optimizing server performance; and troubleshooting SQL Server 2008 Administration Instant Reference answers the questions you encounter most often in your daily work"--Provided by publisher.