HP 3000 Manuals

Up and Running with ALLBASE/SQL

Table of Contents

 Up and Running with ALLBASE/SQL
   Up and Running with ALLBASE/SQL : COPYRIGHT NOTICE

   Ch 1.  Very Basic...
      What Is a Database?
      What Is a Relational Database?
          Rows and Columns
          Sample Database Table
          Data Types and Sizes
          Using Several Tables
      What Is SQL?
      What Is ALLBASE/SQL?
          SQLCore and DBCore
          ISQL
          ALLBASE/Query
          SQLUtil
          SQLGEN
          ALLBASE/4GL
          Preprocessors
          ALLBASE/Net
          ALLBASE/Turbo CONNECT
          Other Products
      What Is a DBEnvironment?
          The DBECon File
          DBEFiles
          DBEFileSets
          Databases
          Tables and Indexes
          System Catalog
          Log Files
      How Do I Create a DBEnvironment?
      How Do I Create a Database?
          Commands to Create Databases
      How Do I Access a Database?
          Queries and Other Data Manipulation
      How Do I Control Database Access?
      Where Can I Get Help with ALLBASE/SQL?

   Ch 2.  Looking at Data
      Understanding the Process
          A Small Sample Database
          How Will the Data Be Used?
      Distinguishing Entities and Attributes
          Listing Entities
          Listing Attributes
      Identifying Relationships between Entities
      Locating Distinguishing Key Items
      From Entities to Tables
      Creating the Table Design
          Data Type and Size
          Character Data
          NULL Values
          Modifying the Table Design
          Table Descriptions
      Defining Indexes
      Designing Database Security Schemes
      Estimating Table and Index Size
      Designing Applications
      Further Information...

   Ch 3.  Setting Up a Database with ISQL
      Running ISQL
      Creating a DBEnvironment
          DBECon File
          DBEFile0
          Log File
      Creating DBEFileSets
      Creating DBEFiles for Table and Index Data
          Committing Work
      Adding DBEFiles to DBEFileSets
      Creating Tables
          Creating the Albums Table
          Creating the Titles Table
      Entering Data into Tables
          Entering Data with the SQL INSERT Command
          Entering Data with the ISQL LOAD Command
             LOADing from an INTERNAL File
             LOADing from an EXTERNAL File
      Performing Queries
      Creating Views
      Granting Authorities
      Creating an Index
          Location of Tables and Indexes
      Examining the System Catalog
          Updating Statistics in the System Catalog
      In Review...

   Ch 4.  Practice with ALLBASE/SQL Using PartsDBE
      Setting up PartsDBE
          Using SQLSetup
             Creating PartsDBE
          Using Setup Scripts
             HP-UX Systems
             MPE XL Systems
          Looking at the Files Created for PartsDBE
             HP-UX Systems
             MPE XL Systems
      Examining PartsDBE
          Examining the Tables and Views
          View Definitions
          Using the INFO Command
          Examining Indexes
          Examining the Authority Structure
             Groups
             Table Authorities
          Column Authorizations
      Using the Preprocessors
          Sample Application Programs
          For HP-UX:
          For MPE XL:
      Examining Startup Parameters with SQLUtil
      Creating a Schema File with SQLGEN
      Purging PartsDBE

   Ch 5.  Comparing ALLBASE/SQL with TurboIMAGE
      Basic Structures
      Procedures for Starting Up
          Use of a Schema
          Root File versus DBECon File and System Catalog
          Data Files for Data sets versus DBEFiles for Tables
          Naming Conventions
      Tables and Indexes versus Data Sets
          Automatic Masters versus Indexes
          Manual Masters versus Hash Structures
          Master/Detail versus Referential Integrity
          Sort Items versus Indexes
      Mapping of Data Types
          Basic Mapping
          Compound Items
          Null Handling
      Differences in Security
          TurboIMAGE Security
          Granting and Revoking Authorities
          Defining ALLBASE/SQL Groups
          Defining Views in ALLBASE/SQL
      Differences in Accessing Databases
          Interactive Access
          Programmatic Access
          4GL
          Differences in Concurrency Control
          Locking Mechanisms
      Sample Mapping of a TurboIMAGE Database to an ALLBASE/SQL DBEnvironment
      Using ALLBASE/Turbo CONNECT

   Ch 6.  Glossary of Terms in ALLBASE/SQL
       Ch 6.  Glossary of Terms in ALLBASE/SQL (cont.)
          Ad Hoc Query
          Archive Logging
          Attribute
          Authority
          Authorization Group
          Base Table
          Class
          Clustering Index
          Column
          Column Authorization
          Column List
          Concurrency
          Constraint
          Cursor Stability (CS)
          Data Analysis
          Database
          Database Administrator (DBA)
          Database Design
          Data Control Language
          Data Definition
          Data Definition Language
          Data Manipulation
          Data Manipulation Language
          Data Type
          DBA Authority
          DBCore
          DBECon File
          DBECreator
          DBEFile
          DBEFileSet
          DBEnvironment
          DBEUserID
          Embedded SQL Program
          Entity
          Explicit Locking
          Expression
          Foreign Key
          Group
          Hash Structure
          Host Variable
          Implicit Locking
          Index
          Index Scan
          Integrity Constraint
          ISQL
          Isolation Level
          Join
          Key
          Key Column
          Key Value
          Locking
          Logging
          Message Catalog
          Message File
          Modified Source File
          Module
          Native Language
          Nonarchive Logging
          Normalization
          Object
          Optimizer
          Owner
          Predicate
          Preprocessor
          Primary Key
          Projection
          Query
          Query Language
          Query Result
          Read Committed (RC)
          Read Uncommitted (RU)
          Referential Constraint
          Relation
          Relational Operations
          Relationship
          Repeatable Read (RR)
          Result Table
          Rollback Recovery
          Rollforward Recovery
          Row
          Run Authority
          Schema
          Section
          Serial Scan
          Special Authority
          SQL
          SQLCore
          SQLGEN
          SQLMigrate
          SQLUtil
          Structured Query Language
          Subquery
          SYSTEM
          System Catalog
          System Table
          System View
          Table
          Table Authority
          Transaction
          Unique Constraint
          Unique Index
          Validation
          View

MPE/iX 5.0 Documentation