Managing Time In Relational Databases

Download Managing Time In Relational Databases full books in PDF, epub, and Kindle. Read online Managing Time In Relational Databases ebook anywhere anytime directly on your device. Fast Download speed and no annoying ads. We cannot guarantee that every ebooks is available!

Managing Time in Relational Databases

Author : Tom Johnston
Publisher : Morgan Kaufmann
ISBN 13 : 0080963374
Total Pages : 502 pages
Book Rating : 4.0/5 (89 download)

DOWNLOAD NOW!

Book Synopsis Managing Time in Relational Databases by : Tom Johnston

Download or read book Managing Time in Relational Databases written by Tom Johnston and published by Morgan Kaufmann. This book was released on 2010-08-19 with total page 502 pages. Available in PDF, EPUB and Kindle. Book excerpt: Managing Time in Relational Databases: How to Design, Update and Query Temporal Data introduces basic concepts that will enable businesses to develop their own framework for managing temporal data. It discusses the management of uni-temporal and bi-temporal data in relational databases, so that they can be seamlessly accessed together with current data; the encapsulation of temporal data structures and processes; ways to implement temporal data management as an enterprise solution; and the internalization of pipeline datasets. The book is organized into three parts. Part 1 traces the history of temporal data management and presents a taxonomy of bi-temporal data management methods. Part 2 provides an introduction to Asserted Versioning, covering the origins of Asserted Versioning; core concepts of Asserted Versioning; the schema common to all asserted version tables, as well as the various diagrams and notations used in the rest of the book; and how the basic scenario works when the target of that activity is an asserted version table. Part 3 deals with designing, maintaining, and querying asserted version databases. It discusses the design of Asserted Versioning databases; temporal transactions; deferred assertions and other pipeline datasets; Allen relationships; and optimizing Asserted Versioning databases. - Integrates an enterprise-wide viewpoint with a strong conceptual model of temporal data management allowing for realistic implementation of database application development. - Provides a true practical guide to the different possible methods of time-oriented databases with techniques of using existing funtionality to solve real world problems within an enterprise data architecture environment. - Written by IT professionals for IT professionals, this book employs a heavily example-driven approach which reinforces learning by showing the results of puting the techniques discussed into practice.

Time and Relational Theory

Author : C.J. Date
Publisher : Morgan Kaufmann
ISBN 13 : 0128006757
Total Pages : 579 pages
Book Rating : 4.1/5 (28 download)

DOWNLOAD NOW!

Book Synopsis Time and Relational Theory by : C.J. Date

Download or read book Time and Relational Theory written by C.J. Date and published by Morgan Kaufmann. This book was released on 2014-08-13 with total page 579 pages. Available in PDF, EPUB and Kindle. Book excerpt: Time and Relational Theory provides an in-depth description of temporal database systems, which provide special facilities for storing, querying, and updating historical and future data. Traditionally, database management systems provide little or no special support for temporal data at all. This situation is changing because: - Cheap storage enables retention of large volumes of historical data in data warehouses - Users are now faced with temporal data problems, and need solutions - Temporal features have recently been incorporated into the SQL standard, and vendors have begun to add temporal support to their DBMS products Based on the groundbreaking text Temporal Data & the Relational Model (Morgan Kaufmann, 2002) and new research led by the authors, Time and Relational Theory is the only book to offer a complete overview of the functionality of a temporal DBMS. Expert authors Nikos Lorentzos, Hugh Darwen, and Chris Date describe an approach to temporal database management that is firmly rooted in classical relational theory and will stand the test of time. This book covers the SQL:2011 temporal extensions in depth and identifies and discusses the temporal functionality still missing from SQL. - Understand how the relational model provides an ideal basis for taming the complexities of temporal databases - Learn how to analyze and evaluate commercial temporal products with this timely and important information - Be able to use sound principles in designing and using temporal databases - Understand the temporal support recently added to SQL with coverage of the new SQL features in this unique, accurate, and authoritative reference - Appreciate the benefits of a truly relational approach to the problem with this clear, user friendly presentation

Temporal Data & the Relational Model

Author : C.J. Date
Publisher : Morgan Kaufmann
ISBN 13 : 1558608559
Total Pages : 449 pages
Book Rating : 4.5/5 (586 download)

DOWNLOAD NOW!

Book Synopsis Temporal Data & the Relational Model by : C.J. Date

Download or read book Temporal Data & the Relational Model written by C.J. Date and published by Morgan Kaufmann. This book was released on 2003 with total page 449 pages. Available in PDF, EPUB and Kindle. Book excerpt: A review of relational concepts -- An overview of Tutorial D -- Time and the database -- What is the problem? -- Intervals -- Operators on intervals -- The EXPAND and COLLAPSE operators -- The PACK and UNPACK operators -- Generalizing the relational operators -- Database design -- Integrity constraints 1 : candidate keys and related constraints -- Integrity constraints 2 : general constraints -- Database queries -- Database updates -- Stated times and logged times -- Point and interval types revisited.

Information Modeling and Relational Databases

Author : Terry Halpin
Publisher : Elsevier
ISBN 13 : 0443237913
Total Pages : 1086 pages
Book Rating : 4.4/5 (432 download)

DOWNLOAD NOW!

Book Synopsis Information Modeling and Relational Databases by : Terry Halpin

Download or read book Information Modeling and Relational Databases written by Terry Halpin and published by Elsevier. This book was released on 2024-07-22 with total page 1086 pages. Available in PDF, EPUB and Kindle. Book excerpt: Information Modeling and Relational Databases, Third Edition, provides an introduction to ORM (Object-Role Modeling) and much more. In fact, it is the only book to go beyond introductory coverage and provide all of the in-depth instruction you need to transform knowledge from domain experts into a sound database design. This book is intended for anyone with a stake in the accuracy and efficacy of databases: systems analysts, information modelers, database designers and administrators, and programmers. Dr. Terry Halpin and Dr. Tony Morgan, pioneers in the development of ORM, blend conceptual information with practical instruction that will let you begin using ORM effectively as soon as possible. The all-new Third Edition includes coverage of advances and improvements in ORM and UML, nominalization, relational mapping, SQL, XML, data interchange, NoSQL databases, ontological modeling, and post-relational databases. Supported by examples, exercises, and useful background information, the authors' step-by-step approach teaches you to develop a natural-language-based ORM model, and then, where needed, abstract ER and UML models from it. This book will quickly make you proficient in the modeling technique that is proving vital to the development of accurate and efficient databases that best meet real business objectives. "This book is an excellent introduction to both information modeling in ORM and relational databases. The book is very clearly written in a step-by-step manner and contains an abundance of well-chosen examples illuminating practice and theory in information modeling. I strongly recommend this book to anyone interested in conceptual modeling and databases." — Dr. Herman Balsters, Director of the Faculty of Industrial Engineering, University of Groningen, The Netherlands - Presents the most in-depth coverage of object-role modeling, including a thorough update of the book for the latest versions of ORM, ER, UML, OWL, and BPMN modeling. - Includes clear coverage of relational database concepts as well as the latest developments in SQL, XML, information modeling, data exchange, and schema transformation. - Case studies and a large number of class-tested exercises are provided for many topics. - Includes all-new chapters on data file formats and NoSQL databases.

Bitemporal Data

Author : Tom Johnston
Publisher : Newnes
ISBN 13 : 0124080553
Total Pages : 400 pages
Book Rating : 4.1/5 (24 download)

DOWNLOAD NOW!

Book Synopsis Bitemporal Data by : Tom Johnston

Download or read book Bitemporal Data written by Tom Johnston and published by Newnes. This book was released on 2014-08-19 with total page 400 pages. Available in PDF, EPUB and Kindle. Book excerpt: Bitemporal data has always been important. But it was not until 2011 that the ISO released a SQL standard that supported it. Currently, among major DBMS vendors, Oracle, IBM and Teradata now provide at least some bitemporal functionality in their flagship products. But to use these products effectively, someone in your IT organization needs to know more than how to code bitemporal SQL statements. Perhaps, in your organization, that person is you. To correctly interpret business requests for temporal data, to correctly specify requirements to your IT development staff, and to correctly design bitemporal databases and applications, someone in your enterprise needs a deep understanding of both the theory and the practice of managing bitemporal data. Someone also needs to understand what the future may bring in the way of additional temporal functionality, so their enterprise can plan for it. Perhaps, in your organization, that person is you. This is the book that will show the do-it-yourself IT professional how to design and build bitemporal databases and how to write bitemporal transactions and queries, and will show those who will direct the use of vendor-provided bitemporal DBMSs exactly what is going on "under the covers" of that software. - Explains the business value of bitemporal data in terms of the information that can be provided by bitemporal tables and not by any other form of temporal data, including history tables, version tables, snapshot tables, or slowly-changing dimensions - Provides an integrated account of the mathematics, logic, ontology and semantics of relational theory and relational databases, in terms of which current relational theory and practice can be seen as unnecessarily constrained to the management of nontemporal and incompletely temporal data - Explains how bitemporal tables can provide the time-variance and nonvolatility hitherto lacking in Inmon historical data warehouses - Explains how bitemporal dimensions can replace slowly-changing dimensions in Kimball star schemas, and why they should do so - Describes several extensions to the current theory and practice of bitemporal data, including the use of episodes, "whenever" temporal transactions and queries, and future transaction time - Points out a basic error in the ISO's bitemporal SQL standard, and warns practitioners against the use of that faulty functionality. Recommends six extensions to the ISO standard which will increase the business value of bitemporal data - Points towards a tritemporal future for bitemporal data, in which an Aristotelian ontology and a speech-act semantics support the direct management of the statements inscribed in the rows of relational tables, and add the ability to track the provenance of database content to existing bitemporal databases - This book also provides the background needed to become a business ontologist, and explains why an IT data management person, deeply familiar with corporate databases, is best suited to play that role. Perhaps, in your organization, that person is you

Developing Time-oriented Database Applications in SQL

Author : Richard T. Snodgrass
Publisher : Morgan Kaufmann
ISBN 13 :
Total Pages : 538 pages
Book Rating : 4.X/5 (4 download)

DOWNLOAD NOW!

Book Synopsis Developing Time-oriented Database Applications in SQL by : Richard T. Snodgrass

Download or read book Developing Time-oriented Database Applications in SQL written by Richard T. Snodgrass and published by Morgan Kaufmann. This book was released on 2000 with total page 538 pages. Available in PDF, EPUB and Kindle. Book excerpt: Whether you're a database designer, programmer, analyst, or manager, you've probably encountered some of the challenges-and experienced some of the frustrations-associated with time-varying data. Where do you turn to fix the problem and see that it doesn't happen again? In Developing Time-Oriented Database Applications in SQL, a leading SQL researcher teaches you effective techniques for designing and building database applications that must integrate past and current data. Written to meet a pervasive, enduring need, this book will be indispensible if you happen to be part of the flurry of activity leading up to Y2K. The enclosed CD-ROM contains all of the code fragments-implemented for Oracle8 Server, IBM DB2 Universal Database, Microsoft SQL Server, and other systems-and evaluation copies of the programs discussed in the book. * Offers incisive advice on recording temporal data using SQL data types, defining appropriate integrity constraints, updating temporal tables, and querying temporal tables with interactive and embedded SQL. * Provides case studies detailing real-world problems and solutions in areas such as event data, state-based data, partitioned data, and audit logs. * Contains over 400 code fragments with detailed explanations.

Fundamentals of Relational Database Management Systems

Author : S. Sumathi
Publisher : Springer Science & Business Media
ISBN 13 : 3540483977
Total Pages : 793 pages
Book Rating : 4.5/5 (44 download)

DOWNLOAD NOW!

Book Synopsis Fundamentals of Relational Database Management Systems by : S. Sumathi

Download or read book Fundamentals of Relational Database Management Systems written by S. Sumathi and published by Springer Science & Business Media. This book was released on 2007-02-13 with total page 793 pages. Available in PDF, EPUB and Kindle. Book excerpt: This book provides comprehensive coverage of fundamentals of database management system. It contains a detailed description on Relational Database Management System Concepts. There are a variety of solved examples and review questions with solutions. This book is for those who require a better understanding of relational data modeling, its purpose, its nature, and the standards used in creating relational data model.

Practical Issues in Database Management

Author : Fabian Pascal
Publisher : Addison-Wesley Professional
ISBN 13 :
Total Pages : 296 pages
Book Rating : 4.3/5 (91 download)

DOWNLOAD NOW!

Book Synopsis Practical Issues in Database Management by : Fabian Pascal

Download or read book Practical Issues in Database Management written by Fabian Pascal and published by Addison-Wesley Professional. This book was released on 2000 with total page 296 pages. Available in PDF, EPUB and Kindle. Book excerpt: The aim of this work is to provide a correct and up-to-date understanding of the practical aspects of crucial, yet little- understood core database issues. The author identifies fundamental concepts, principles, and techniques and assesses the treatment of those issues in SQL (both the standard and commercial implementations) and gives advice on how to deal with them. Topics covered include complex data types, missing information, data hierarchies, and quota queries. Annotation copyrighted by Book News, Inc., Portland, OR

Fundamentals of Relational Database Management Systems

Author : S. Sumathi
Publisher : Springer
ISBN 13 : 3540483993
Total Pages : 793 pages
Book Rating : 4.5/5 (44 download)

DOWNLOAD NOW!

Book Synopsis Fundamentals of Relational Database Management Systems by : S. Sumathi

Download or read book Fundamentals of Relational Database Management Systems written by S. Sumathi and published by Springer. This book was released on 2007-03-20 with total page 793 pages. Available in PDF, EPUB and Kindle. Book excerpt: This book provides comprehensive coverage of fundamentals of database management system. It contains a detailed description on Relational Database Management System Concepts. There are a variety of solved examples and review questions with solutions. This book is for those who require a better understanding of relational data modeling, its purpose, its nature, and the standards used in creating relational data model.

Real-Time & Stream Data Management

Author : Wolfram Wingerath
Publisher : Springer
ISBN 13 : 3030105555
Total Pages : 84 pages
Book Rating : 4.0/5 (31 download)

DOWNLOAD NOW!

Book Synopsis Real-Time & Stream Data Management by : Wolfram Wingerath

Download or read book Real-Time & Stream Data Management written by Wolfram Wingerath and published by Springer. This book was released on 2019-01-02 with total page 84 pages. Available in PDF, EPUB and Kindle. Book excerpt: While traditional databases excel at complex queries over historical data, they are inherently pull-based and therefore ill-equipped to push new information to clients. Systems for data stream management and processing, on the other hand, are natively pushoriented and thus facilitate reactive behavior. However, they do not retain data indefinitely and are therefore not able to answer historical queries. The book provides an overview over the different (push-based) mechanisms for data retrieval in each system class and the semantic differences between them. It also provides a comprehensive overview over the current state of the art in real-time databases. It sfirst includes an in-depth system survey of today's real-time databases: Firebase, Meteor, RethinkDB, Parse, Baqend, and others. Second, the high-level classification scheme illustrated above provides a gentle introduction into the system space of data management: Abstracting from the extreme system diversity in this field, it helps readers build a mental model of the available options.

Application of Decision Science in Business and Management

Author : Fausto Pedro García Márquez
Publisher : BoD – Books on Demand
ISBN 13 : 1838800999
Total Pages : 247 pages
Book Rating : 4.8/5 (388 download)

DOWNLOAD NOW!

Book Synopsis Application of Decision Science in Business and Management by : Fausto Pedro García Márquez

Download or read book Application of Decision Science in Business and Management written by Fausto Pedro García Márquez and published by BoD – Books on Demand. This book was released on 2020-03-04 with total page 247 pages. Available in PDF, EPUB and Kindle. Book excerpt: Application of Decision Science in Business and Management is a book where each chapter has been contributed by a different author(s). The chapters introduce and demonstrate a decision-making theory to practice case studies. It demonstrates key results for each sector with diverse real-world case studies. Theory is accompanied by relevant analysis techniques, with a progressive approach building from simple theory to complex and dynamic decisions with multiple data points, including big data, lot of data, etc. Computational techniques, dynamic analysis, probabilistic methods, and mathematical optimization techniques are expertly blended to support analysis of multi-criteria decision-making problems with defined constraints and requirements. The book provides an interface between the main disciplines of engineering/technology and the organizational, administrative, and planning abilities of decision making. It is complementary to other sub-disciplines such as economics, finance, marketing, decision and risk analysis, etc.

Developing Robust Date and Time Oriented Applications in Oracle Cloud

Author : Michal Kvet
Publisher : Packt Publishing Ltd
ISBN 13 : 1804619361
Total Pages : 464 pages
Book Rating : 4.8/5 (46 download)

DOWNLOAD NOW!

Book Synopsis Developing Robust Date and Time Oriented Applications in Oracle Cloud by : Michal Kvet

Download or read book Developing Robust Date and Time Oriented Applications in Oracle Cloud written by Michal Kvet and published by Packt Publishing Ltd. This book was released on 2023-05-12 with total page 464 pages. Available in PDF, EPUB and Kindle. Book excerpt: Create robust temporal solutions in Oracle Cloud and spread the solution worldwide by leveraging its regional properties and time zone synchronization Purchase of the print or Kindle book includes a free PDF eBook Key Features Migrate existing on-premises applications to the Oracle Cloud environment using data migration techniques Handle date and time values efficiently using Oracle database's available data types and duration modeling principles Apply temporal database models in real-world systems to ensure robustness, security, and performance Book Description Proper date and time management is critical for the development and reliability of Oracle Databases and cloud environments, which are among the most rapidly expanding technologies today. This knowledge can be applied to cloud technology, on premises, application development, and integration to emphasize regional settings, UTC coordination, or different time zones. This practical book focuses on code snippets and discusses the existing functionalities and limitations, along with covering data migration to the cloud by emphasizing the importance of proper date and time management. This book helps you understand the historical background and evolution of ANSI standards. You'll get to grips with data types, constructor principles, and existing functionalities, and focus on the limitations of regional parameters and time zones, which help in expanding business to other parts of the world. You'll also explore SQL injection threats, temporal database architecture, using Flashback Technology to reconstruct valid database images from the past, time zone management, and UTC synchronization across regions. By the end of this book, you'll be able to create and manage temporal systems, prevent SQL injection attacks, use existing functionalities and define your own robust solutions for date management, and apply time zone and region rules. What you will learn Explore the fundamentals and terms related to Oracle Cloud Infrastructure (OCI) and data migration Follow core principles and date and time element management supervised by ANSI standardization Discover the limitations of existing functionalities and conversion methods Build robust and secure temporal solutions that are resistant to SQL injection threats Understand time zone management and regional settings by focusing on regional and national conventions and approaches Use Flashback Technology to create temporal models in terms of historical and current states Who this book is for This book is for IT specialists, students, system developers, database administrators, and cloud integrators. With a hands-on approach, this book will help you to gain a comprehensive view of the issue of time processing and enable you to develop complex, robust applications that are usable and portable in any region.

Applications of Computational Intelligence in Biomedical Technology

Author : Radim Bris
Publisher : Springer
ISBN 13 : 3319191470
Total Pages : 255 pages
Book Rating : 4.3/5 (191 download)

DOWNLOAD NOW!

Book Synopsis Applications of Computational Intelligence in Biomedical Technology by : Radim Bris

Download or read book Applications of Computational Intelligence in Biomedical Technology written by Radim Bris and published by Springer. This book was released on 2015-06-25 with total page 255 pages. Available in PDF, EPUB and Kindle. Book excerpt: This book presents latest results and selected applications of Computational Intelligence in Biomedical Technologies. Most of contributions deal with problems of Biomedical and Medical Informatics, ranging from theoretical considerations to practical applications. Various aspects of development methods and algorithms in Biomedical and Medical Informatics as well as Algorithms for medical image processing, modeling methods are discussed. Individual contributions also cover medical decision making support, estimation of risks of treatments, reliability of medical systems, problems of practical clinical applications and many other topics. This book is intended for scientists interested in problems of Biomedical Technologies, for researchers and academic staff, for all dealing with Biomedical and Medical Informatics, as well as PhD students. Useful information is offered also to IT companies, developers of equipment and/or software for medicine and medical professionals.

Database Modeling and Design

Author : Toby J. Teorey
Publisher : Elsevier
ISBN 13 : 0123820219
Total Pages : 347 pages
Book Rating : 4.1/5 (238 download)

DOWNLOAD NOW!

Book Synopsis Database Modeling and Design by : Toby J. Teorey

Download or read book Database Modeling and Design written by Toby J. Teorey and published by Elsevier. This book was released on 2011-02-10 with total page 347 pages. Available in PDF, EPUB and Kindle. Book excerpt: 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

Joe Celko's SQL for Smarties

Author : Joe Celko
Publisher : Elsevier
ISBN 13 : 0123820235
Total Pages : 817 pages
Book Rating : 4.1/5 (238 download)

DOWNLOAD NOW!

Book Synopsis Joe Celko's SQL for Smarties by : Joe Celko

Download or read book Joe Celko's SQL for Smarties written by Joe Celko and published by Elsevier. This book was released on 2010-11-22 with total page 817 pages. Available in PDF, EPUB and Kindle. Book excerpt: Joe Celkos SQL for Smarties: Advanced SQL Programming offers tips and techniques in advanced programming. This book is the fourth edition and it consists of 39 chapters, starting with a comparison between databases and file systems. It covers transactions and currency control, schema level objects, locating data and schema numbers, base tables, and auxiliary tables. Furthermore, procedural, semi-procedural, and declarative programming are explored in this book. The book also presents the different normal forms in database normalization, including the first, second, third, fourth, fifth, elementary key, domain-key, and Boyce-Codd normal forms. It also offers practical hints for normalization and denormalization. The book discusses different data types, such as the numeric, temporal and character data types; the different predicates; and the simple and advanced SELECT statements. In addition, the book presents virtual tables, and it discusses data partitions in queries; grouping operations; simple aggregate functions; and descriptive statistics, matrices and graphs in SQL. The book concludes with a discussion about optimizing SQL. It will be of great value to SQL programmers. - Expert advice from a noted SQL authority and award-winning columnist who has given ten years service to the ANSI SQL standards committee - Teaches scores of advanced techniques that can be used with any product, in any SQL environment, whether it is an SQL 92 or SQL 2008 environment - Offers tips for working around deficiencies and gives insight into real-world challenges

Spatial Data and Intelligence

Author : Xiaofeng Meng
Publisher : Springer Nature
ISBN 13 : 3031329104
Total Pages : 274 pages
Book Rating : 4.0/5 (313 download)

DOWNLOAD NOW!

Book Synopsis Spatial Data and Intelligence by : Xiaofeng Meng

Download or read book Spatial Data and Intelligence written by Xiaofeng Meng and published by Springer Nature. This book was released on 2023-05-10 with total page 274 pages. Available in PDF, EPUB and Kindle. Book excerpt: This book constitutes the refereed proceedings of the 4th International Conference on Spatial Data and Intelligence, SpatialDI 2023, held in Nanchang, China, in April 13–15, 2023. The 18 full papers included in this book were carefully reviewed and selected from 68 submissions. They were organized in topical sections as follows: traffic management; visualization analysis; spatial big data analysis; spatiotemporal data mining; spatiotemporal data storage; and metaverse.

Relational Database Design Clearly Explained

Author : Jan L. Harrington
Publisher : Morgan Kaufmann
ISBN 13 : 9781558608207
Total Pages : 416 pages
Book Rating : 4.6/5 (82 download)

DOWNLOAD NOW!

Book Synopsis Relational Database Design Clearly Explained by : Jan L. Harrington

Download or read book Relational Database Design Clearly Explained written by Jan L. Harrington and published by Morgan Kaufmann. This book was released on 2002 with total page 416 pages. Available in PDF, EPUB and Kindle. Book excerpt: Fully revised and updated, Relational Database Design, Second Edition is the most lucid and effective introduction to relational database design available. Here, you'll find the conceptual and practical information you need to develop a design that ensures data accuracy and user satisfaction while optimizing performance, regardless of your experience level or choice of DBMS. Supporting the book's step-by-step instruction are three case studies illustrating the planning, analysis, and design steps involved in arriving at a sound design. These real-world examples include object-relational design techniques, which are addressed in greater detail in a new chapter devoted entirely to this timely subject. * Concepts you need to master to put the book's practical instruction to work. * Methods for tailoring your design to the environment in which the database will run and the uses to which it will be put. * Design approaches that ensure data accuracy and consistency. * Examples of how design can inhibit or boost database application performance. * Object-relational design techniques, benefits, and examples. * Instructions on how to choose and use a normalization technique. * Guidelines for understanding and applying Codd's rules. * Tools to implement a relational design using SQL. * Techniques for using CASE tools for database design.