Series in Retrieval
Books in Retrieval
A Complete Guide to DB2 Universal Database
DB2 Universal Database (UDB) supports many different types of applications, on many different kinds of data, in many different software and hardware environments. This book provides a complete guide to DB2 UDB Version 5 in all its aspects, including the interfaces that support end users, application developers, and database administrators. It is complementary to the IBM product documentation, providing a clear and informal explanation of how the features of DB2 were intended to be used. It is an extensive revision of the author's earlier book, Using the New DB2: IBM's Object-Relational Database System . Offers complete and self-contained information, and does not assume prior knowledge of DB2, SQL, or relational database concepts Covers elementary principles of database management as well as the advanced features of UDB, including recursive queries, constraints, triggers, user-defined datatypes, stored procedures, parallel databases, and graphical tools for database administration Includes dozens of practical tips that will save readers many hours of work in developing database applications
Atomic Transactions
This book develops a theory for transactions that provides practical solutions for system developers, focusing on the interface between the user and the database that executes transactions. Atomic transactions are a useful abstraction for programming concurrent and distributed data processing systems. Presents many important algorithms which provide maximum concurrency for transaction processing without sacrificing data integrity. The authors include a well-developed data processing case study to help readers understand transaction processing algorithms more clearly. The book offers conceptual tools for the design of new algorithms, and for devising variations on the familiar algorithms presented in the discussions. Whether your background is in the development of practical systems or formal methods, this book will offer you a new way to view distributed systems.
Building an Object-Oriented Database System
Modern database and software system technology must respond to a wide variety of needs. Advanced applications such as office automation, CAD, or software engineering have new requirements in design environments, transaction mechanisms, and data types. This comprehensive volume by designers, implementors and users covers all aspects of building an object-oriented software system from data model through system implementation, interfaces, and applications. Utilizing techniques from databases, object-oriented languages, programming environments, and user interfaces, O2 is a landmark object-oriented database system representing a new generation of database technology. This guide will help researchers, database designers, and users to assess the nature and potential of object-oriented technology for themselves.
Component Database Systems
Component Database Systems is a collection of invited chapters by the researchers making the most influential contributions in the database industry's trend toward componentization This book represents the sometimes-divergent, sometimes-convergent approaches taken by leading database vendors as they seek to establish commercially viable componentization strategies. Together, these contributions form the first book devoted entirely to the technical and architectural design of component-based database systems. In addition to detailing the current state of their research, the authors also take up many of the issues affecting the likely future directions of component databases. If you have a stake in the evolution of any of today's leading database systems, this book will make fascinating reading. It will also help prepare you for the technology that is likely to become widely available over the next several years. * Is comprised of contributions from the field's most highly respected researchers, including key figures at IBM, Oracle, Informix, Microsoft, and POET. * Represents the entire spectrum of approaches taken by leading software companies working on DBMS componentization strategies. * Covers component-focused architectures, methods for hooking components into an overall system, and support for component development. * Examines the component technologies that are most valuable to Web-based and multimedia databases. * Presents a thorough classification and overview of component database systems.
Data Modeling Essentials(With: Graham Witt)
Data Modeling Essentials, Third Edition provides expert tutelage for data modelers, business analysts and systems designers at all levels. Beginning with the basics, this book provides a thorough grounding in theory before guiding the reader through the various stages of applied data modeling and database design. Later chapters address advanced subjects, including business rules, data warehousing, enterprise-wide modeling and data management. The third edition of this popular book retains its distinctive hallmarks of readability and usefulness, but has been given significantly expanded coverage and reorganized for greater reader comprehension. Authored by two leaders in the field, Data Modeling Essentials, Third Edition is the ideal reference for professionals and students looking for a real-world perspective. · Thorough coverage of the fundamentals and relevant theory. · Recognition and support for the creative side of the process. · Expanded coverage of applied data modeling includes new chapters on logical and physical database design. · New material describing a powerful technique for model verification. · Unique coverage of the practical and human aspects of modeling, such as working with business specialists, managing change, and resolving conflict. UML diagrams now available! Click here to view a book review by Steve Hoberman!
Data Quality
Data Quality: The Accuracy Dimension is about assessing the quality of corporate data and improving its accuracy using the data profiling method. Corporate data is increasingly important as companies continue to find new ways to use it. Likewise, improving the accuracy of data in information systems is fast becoming a major goal as companies realize how much it affects their bottom line. Data profiling is a new technology that supports and enhances the accuracy of databases throughout major IT shops. Jack Olson explains data profiling and shows how it fits into the larger picture of data quality. * Provides an accessible, enjoyable introduction to the subject of data accuracy, peppered with real-world anecdotes. * Provides a framework for data profiling with a discussion of analytical tools appropriate for assessing data accuracy. * Is written by one of the original developers of data profiling technology. * Is a must-read for any data management staff, IT management staff, and CIOs of companies with data assets.
Data on the Web
The Web is causing a revolution in how we represent, retrieve, and process information Its growth has given us a universally accessible database, but in the form of a largely unorganized collection of documents. This is changing, thanks to the simultaneous emergence of new ways of representing data: from within the Web community, XML; and from within the database community, semistructured data. The convergence of these two approaches has rendered them nearly identical. Now, there is a concerted effort to develop effective techniques for retrieving and processing both kinds of data. Data on the Web is the only comprehensive, up-to-date examination of these rapidly evolving retrieval and processing strategies, which are of critical importance for almost all Web- and data-intensive enterprises. This book offers detailed solutions to a wide range of practical problems while equipping you with a keen understanding of the fundamental issues including data models, query languages, and schemas involved in their design, implementation, and optimization. You'll find it to be compelling reading, whether your interest is that of a practitioner involved in a database-driven Web enterprise or a researcher in computer science or related field. Provides an in-depth look at XML and other technologies for publishing structured documents on the Web Examines recently developed methods for querying and updating structured Web documents and semistructured data, including XML-QL and XSL Looks deeper into the convergence of Web and database approaches to semistructured data presentation and querying Details practical examples of how these techniques are already being applied—and how they will be used in the near future Teaches sound techniques for writing queries over Web data, describing loose schemas over partially structured data, and implementing and optimizing queries on semistructured data
Database Design for Smarties
Whether building a relational, object-relational, or object-oriented database, database developers are increasingly relying on an object-oriented design approach as the best way to meet user needs and performance criteria. This book teaches you how to use the Unified Modeling Language-the official standard of the Object Management Group-to develop and implement the best possible design for your database. Inside, the author leads you step by step through the design process, from requirements analysis to schema generation. You'll learn to express stakeholder needs in UML use cases and actor diagrams, to translate UML entities into database components, and to transform the resulting design into relational, object-relational, and object-oriented schemas for all major DBMS products. Teaches you everything you need to know to design, build, and test databases using an OO model Shows you how to use UML, the accepted standard for database design according to OO principles Explains how to transform your design into a conceptual schema for relational, object-relational, and object-oriented DBMSs Offers practical examples of design for Oracle, SQL Server, Sybase, Informix, Object Design, POET, and other database management systems Focuses heavily on re-using design patterns for maximum productivity and teaches you how to certify completed designs for re-use
Database Modeling and Design: 3rd Edition
This new edition of Database Modeling & Design continues to focus on the techniques for relational database design introduced in previous editions, starting with the entity-relationship (ER) approach for data requirements specification and conceptual modeling. Author Toby Teorey then looks ahead to the common properties in data modeling and operations shared among the relational model and advanced database technologies such as the object-oriented, temporal, and multimedia models. A full chapter is devoted to database design techniques for data warehousing and online analytical processing (OLAP). Teorey covers the database life cycle from requirements analysis and logical design to physical design for local, distributed, and multidatabases. The discussion of basic principles is supplemented with a common, running example: a company personnel and project database based on real-life experiences and classroom testing. Written for both the novice and the professional database designer, this book is the essential resource for database modeling, including the building of standard SQL data definitions. The design rules set forth in this book are applicable to any SQL-based system, including IBM DB2, Oracle V8.0, Informix IDS-UDO, Microsoft Access, Microsoft SQL Server, and Sybase Adaptive Server Enterprise. * Continued focus on relational model * Integration of information about data warehouse and OLAP, plus other advanced database technologies, including object oriented, multimedia, and temporal database * Discussion of basic principles is supplemented by examples based on real life cases
Database Modeling and Design: 5th Edition
Database Modeling and Design, Fifth Edition, focuses on techniques for database design in relational database systems. This extensively revised fifth edition features clear explanations, lots of terrific examples and an illustrative case, and practical advice, with design rules that are applicable to any SQL-based system. The common examples are based on real-life experiences and have been thoroughly class-tested. This book is immediately useful to anyone tasked with the creation of data models for the integration of large-scale enterprise data. It is ideal for a stand-alone data management course focused on logical database design, or a supplement to an introductory text for introductory database management. - In-depth detail and plenty of real-world, practical examples throughout - Loaded with design rules and illustrative case studies that are applicable to any SQL, UML, or XML-based system - Immediately useful to anyone tasked with the creation of data models for the integration of large-scale enterprise data
Database Modeling with Microsoft® Visio for Enterprise Architects
This book is for database designers and database administrators using Visio, which is the database component of Microsoft's Visual Studio .NET for Enterprise Architects suite, also included in MSDN subscriptions. This is the only guide to this product that tells DBAs how to get their job done. Although primarily focused on tool features, the book also provides an introduction to data modeling, and includes practical advice on managing database projects. The principal author was the program manager of VEA's database modeling solutions. · Explains how to model databases with Microsoft® Visio for Enterprise Architects (VEA), focusing on tool features.· Provides a platform-independent introduction to data modeling using both Object Role Modeling (ORM) and Entity Relationship Modeling (ERM), and includes practical advice on managing database projects.· Additional ORM models, course notes, and add-ins available online.
Database Transaction Models for Advanced Applications
This collection offers the reader a broad survey of the role of transaction processing in advanced computer applications. It contains an introduction to traditional transaction technology, and comprehensive descriptions of commercial systems and research projects. This volume will help anyone interested in keeping up with database applications and the potential for transaction processing systems to address the needs of OLTP, CAD, CASE, computer aided publishing, heterogeneous databases, active databases, communications, systems and other areas. For researchers, managers, software developers, professionals in the data processing fields, or anyone interested in a coherent overview of this new and fast growing area of computer science.