skip to content
Informix guide to designing databases and data warehouses. Preview this item
ClosePreview this item

Informix guide to designing databases and data warehouses.

Author: Informix Software, Inc.
Publisher: Upper Saddle River, N.J. : Prentice Hall PTR ; London : Prentice-Hall International (UK), ©2000.
Edition/Format:   Print book : EnglishView all editions and formats



(not yet rated) 0 with reviews - Be the first.

More like this

Find a copy in the library

&AllPage.SpinnerRetrieving; Finding libraries that hold this item...


Additional Physical Format: Online version:
Informix guide to designing databases and data warehouses.
Upper Saddle River, N.J. : Prentice Hall PTR ; London : Prentice-Hall International (UK), ©2000
Document Type: Book
All Authors / Contributors: Informix Software, Inc.
ISBN: 0130161675 9780130161673
OCLC Number: 42406909
Notes: "Informix Software"--Cover and spine.
Includes index.
Description: 1 volume (various pagings) : illustrations ; 24 cm
Contents: (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.


User-contributed reviews
Retrieving GoodReads reviews...
Retrieving DOGObooks reviews...


Be the first.

Similar Items

Confirm this request

You may have already requested this item. Please select Ok if you would like to proceed with this request anyway.

Linked Data

Primary Entity

<> # Informix guide to designing databases and data warehouses.
    a schema:Book, schema:CreativeWork ;
    library:oclcnum "42406909" ;
    library:placeOfPublication <> ;
    library:placeOfPublication <> ; # London
    library:placeOfPublication <> ; # Upper Saddle River, N.J.
    schema:about <> ;
    schema:about <> ; # Data warehousing
    schema:about <> ; # Database design
    schema:about <> ; # INFORMIX Dynamic server.
    schema:about <> ; # INFORMIX Dynamic server.
    schema:bookFormat bgn:PrintBook ;
    schema:contributor <> ; # Informix Software, Inc.
    schema:copyrightYear "2000" ;
    schema:datePublished "2000" ;
    schema:exampleOfWork <> ;
    schema:inLanguage "en" ;
    schema:isSimilarTo <> ;
    schema:name "Informix guide to designing databases and data warehouses."@en ;
    schema:productID "42406909" ;
    schema:publication <> ;
    schema:publisher <> ; # Prentice Hall PTR
    schema:publisher <> ; # Prentice-Hall International (UK)
    schema:workExample <> ;
    umbel:isLike <> ;
    wdrs:describedby <> ;

Related Entities

<> # London
    a schema:Place ;
    schema:name "London" ;

<> # Prentice-Hall International (UK)
    a bgn:Agent ;
    schema:name "Prentice-Hall International (UK)" ;

<> # Prentice Hall PTR
    a bgn:Agent ;
    schema:name "Prentice Hall PTR" ;

<> # INFORMIX Dynamic server.
    a schema:CreativeWork ;
    schema:name "INFORMIX Dynamic server." ;

<> # Upper Saddle River, N.J.
    a schema:Place ;
    schema:name "Upper Saddle River, N.J." ;

<> # INFORMIX Dynamic server.
    a schema:CreativeWork ;
    schema:name "INFORMIX Dynamic server." ;

<> # Data warehousing
    a schema:Intangible ;
    schema:name "Data warehousing"@en ;

<> # Database design
    a schema:Intangible ;
    schema:name "Database design"@en ;

<> # Informix Software, Inc.
    a schema:Organization ;
    schema:name "Informix Software, Inc." ;

    a schema:ProductModel ;
    schema:isbn "0130161675" ;
    schema:isbn "9780130161673" ;

    a schema:CreativeWork ;
    rdfs:label "Informix guide to designing databases and data warehouses." ;
    schema:description "Online version:" ;
    schema:isSimilarTo <> ; # Informix guide to designing databases and data warehouses.

Content-negotiable representations

Close Window

Please sign in to WorldCat 

Don't have an account? You can easily create a free account.