Jump to content United States-English
HP.com Home Products and Services Support and Drivers Solutions How to Buy
» Contact HP
More options
HP.com home
 ALLBASE/SQL Database Administration Guide: HP 3000 MPE/iX Computer Systems

Chapter 2 Logical Design
» 

Technical documentation

Complete book in PDF
» Feedback
Content starts here

 » Table of Contents

 » Index

spacerspacerspacer
spacer
spacer
  		 
 

Table of Contents

Identifying the Data for Tables
Normalizing the Data
First Normal Form
Second Normal Form
Third Normal Form
Arranging Data in Tables
Defining Tables
Defining Columns
Designing Views
Designing Indexes
Determining Index Keys
Determining Index Type
Designing Hash Structures
Understanding the Hash Function
Choosing Hash Keys
Choosing the Number of Primary Pages
Designing Integrity Constraints
Defining Security Levels
Authority Types
Special Authorities
Owner Authority
Table and View Authorities
RUN Authority
EXECUTE Authority
Space Authorities
Defining Authorization Groups
Defining Classes
Defining the DBEnvironment Scope

An ALLBASE/SQL database is defined both logically and physically. Logically, an ALLBASE/SQL database is one or more tables or views with the same owner. This chapter will give guidelines on how to design the logical structure of a relational database and to use ALLBASE/SQL table, view, and index definition features to meet the needs of users and applications. The logical design process lets you create efficient databases so that your applications will perform smoothly and be easy to maintain and support. The process consists of several distinct steps:

  • Identifying the data for tables

  • Normalizing the data

  • Arranging data in tables

  • Designing views

  • Designing indexes

  • Designing hash structures

  • Designing integrity constraints

  • Defining security levels

  • Defining the DBEnvironment scope

The following sections describe each of these steps using the sample DBEnvironment PartsDBE as an illustration.



System Administration for ALLBASE/SQL
  		 


Identifying the Data for Tables  
Printable version
Privacy statement Using this site means you accept its terms Feedback to webmaster
© Hewlett-Packard Development Company, L.P.