Written by a team of Informix insiders, there's never been a more complete, authoritative guide to Informix database/data warehouse design and implementation. This book teaches all you need to know to design, implement, and manage an Informix database or data warehouse. Walk through building data models illustrating each key approach to database design; then learn how to use Informix SQL to implement and manage your databaes. The book also includes extensive coverage of constructing, deploying, and administering a data warehouse -- including how to maximize data quality. For all Informix database professionals, and for managers and technical professionals considering implementing a data warehouse with Informix technologies.
Muu info
Written by a team of Informix insiders, there's never been a more complete, authoritative guide to Informix database/data warehouse design and implementation. This book teaches all you need to know to design, implement, and manage an Informix database or data warehouse. Walk through building data models illustrating each key approach to database design; then learn how to use Informix SQL to implement and manage your databaes. The book also includes extensive coverage of constructing, deploying, and administering a data warehouse -- including how to maximize data quality. For all Informix database professionals, and for managers and technical professionals considering implementing a data warehouse with Informix technologies.
(NOTE: Each chapter begins with In This
Chapter.)I. BASICS OF DATABASE
DESIGN AND IMPLEMENTATION.
1. Planning a Database.
Choosing a Data Model for Your Database. Using ANSI-Compliant Databases.
Designating a Database as ANSI Compliant. Determining If an Existing Database
Is ANSI Compliant. Differences between ANSI-Compliant and Non-ANSI-Compliant
Databases. Using a Customized Language Environment for Your Database.
2. Building a Relational Data Model.
Why Build a Data Model. Overview of the Entity-Relationship Data Model.
Identifying and Defining Principal Data Objects. Discovering Entities.
Defining the Relationships. Identifying Attributes. Diagramming Data Objects.
Reading E-R Diagrams. Telephone-Directory Example. Translating E-R Data
Objects into Relational Constructs. Defining Tables, Rows, and Columns.
Determining Keys for Tables. Resolving Relationships. Resolving m:n
Relationships. Resolving Other Special Relationships. Normalizing a Data
Model. First Normal Form. Second Normal Form. Third Normal Form. Summary of
Normalization Rules.
3. Choosing Data Types.
Defining the Domains. Data Types. Null Values. Default Values. Check
Constraints.
4. Implementing a Relational Data Model.
Creating the Database. Using CREATE DATABASE. Using CREATE TABLE. Creating a
Fragmented Table. Using CREATE INDEX. Using Synonyms with Table Names. Using
Synonym Chains. Using Command Scripts. Populating the Tables.
II. MANAGING DATABASES.
5. Table Fragmentation Strategies.
What Is Fragmentation? Enhanced Fragmentation for Enterprise Decision Server.
Why Use Fragmentation? Whose Responsibility Is Fragmentation? Fragmentation
and Logging. Distribution Schemes for Table Fragmentation. Expression-Based
Distribution Scheme. Round-Robin Distribution Scheme. Range Distribution
Scheme. System-Defined Hash Distribution Scheme. Hybrid Distribution Scheme.
Eliminating Fragments from a Search. Creating a Fragmented Table. Creating a
New Fragmented Table. Rowids in a Fragmented Table. Creating a Fragmented
Table from Nonfragmented Tables. Fragmenting Smart Large Objects. Modifying
Fragmentation Strategies. Using the INIT Clause to Reinitialize a
Fragmentation Scheme. Using the INIT Clause to Change From Hash to Hybrid
Fragmentation. Using the MODIFY Clause to Modify an Existing Fragmentation
Strategy. Using ATTACH and DETACH Clauses to Modify an Existing Fragmentation
Strategy. Using the ADD Clause to Add a Fragment. Using the DROP Clause to
Drop a Fragment. Fragmenting Temporary Tables. Fragmenting Temporary Tables
with Enterprise Decision Server. Fragmentation of Table Indexes. Attached
Indexes. Detached Indexes. Rowids. Accessing Data Stored in Fragmented
Tables. Using Primary Keys Instead of Rowids. Creating a Rowid Column in a
Fragmented Table. Granting and Revoking Privileges from Fragments.
6. Granting and Limiting Access to Your Database.
Controlling Access to Databases. Granting Privileges. Database-Level
Privileges. Ownership Rights. Table-Level Privilege. Column-Level Privileges.
Type-Level Privileges. Routine-Level Privileges. Language Privileges.
Automating Privileges. Using SPL Routines to Control Access to Data.
Restricting Data Reads. Restricting Changes to Data. Monitoring Changes to
Data. Restricting Object Creation. Using Views. Creating Views. Modifying
with a View. Privileges and Views. Privileges When Creating a View.
Privileges When Using a View.
III. OBJECT-RELATIONAL DATABASES.
7. Creating and Using Extended Data Types in Dynamic Server.
User-Defined Data Types. Opaque Data Types. Distinct Data Types. Smart Large
Objects. BLOB Data Type. CLOB Data type. Using Smart Large Objects. Copying
Smart Large Objects. Complex Data Types. Collection Data Types. Named Row
Types. Unnamed Row Types.
8. Understanding Type and Table Inheritance in Dynamic Server.
What Is Inheritance? Type Inheritance. Defining a Type Hierarchy. Overloading
Routines for Types in a Type Hierarchy. Inheritance and Type
Substitutability. Dropping Named Row Types from a Type Hierarchy. Table
Inheritance. The Relationship between Type and Table Hierarchies. Defining a
Table Hierarchy. Inheritance of Table Behavior in a Table Hierarchy.
Modifying Table Behavior in a Table Hierarchy. SERIAL Types in a Table
Hierarchy. Adding a New Table to a Table Hierarchy. Dropping a Table in a
Table Hierarchy. Altering the Structure of a Table in a Table Hierarchy.
Querying Tables in a Table Hierarchy. Creating a View on a Table in a Table
Hierarchy.
9. Creating and Using User-Defined Casts in Dynamic Server.
What Is a Cast? Creating User-Defined Casts. Invoking Casts. Restrictions on
User-Defined Casts. Casting Row Types. Casting between Named and Unnamed Row
Types. Casting between Unnamed Row Types. Casting between Named Row Types.
Row-Type Conversions that Require Explicit Casts on Fields. Casting
Individual Fields of a Row Type. Casting Collection Data Types. Restrictions
on Collection-Type Conversions. Converting between Collections with Different
Element Types. Converting Relational Data to a MULTISET Collection. Casting
Distinct Data Types. Using Explicit Casts with Distinct Types. Casting
between a Distinct Type and Its Source Type. Casting to Smart Large Objects.
Creating Cast Functions for User-Defined Casts. An Example of Casting between
Named Row Types. An Example of Casting between Distinct Data Types.
Multilevel Casting.
IV. DIMENSIONAL DATABASES.
10. Building a Dimensional Data Model.
Overview of Data Warehousing. Why Build a Dimensional Database? What is
Dimensional Data? Concepts of Dimensional Data Modeling. The Fact Table.
Dimensions of the Data Model. Building a Dimensional Data Model. Choosing a
Business Process. Summary of a Business Process. Determining the Granularity
of the Fact Table. Identifying the Dimensions and Hierarchies. Choosing the
Measures for the Fact Table. Resisting Normalization. Choosing the Attributes
for the Dimension Tables. Handling Common Dimensional Data-Modeling Problems.
Minimizing the Number of Attributes in a Dimension Table. Handling Dimensions
That Occasionally Change. Using the Snowflake Schema.
11. Implementing a Dimensional Database.
Implementing the sales_demo Dimensional Database. Using CREATE DATABASE.
Using CREATE TABLE for the Dimension and Fact Tables. Mapping Data from Data
Sources to the Database. Loading Data into the Dimensional Database. Creating
the sales_demo Database. Testing the Dimensional Database. Logging and
Nonlogging Tables in Enterprise Decision Server. Choosing Table Types.
Switching between Table Types. Indexes for Data-Warehousing Environments.
Using GK Indexes in a Data-Warehousing Environment.
Index.
Informix Software
