Cover Image
Read Now

The Global Paleomagnetic Database Design, Installation and Use with ORACLE

Document Syntax Xl I. DATABASE DESIGN 1. Relational Databases 317 2. Choice of Database Management System 318 3. Design of the Global Paleomagnetic Database 319 3. 1. ORACLE Design 319 3. 2. Compact Database - ABASE 321 4. Aspects of Data Entry 326 II. ORACLE HARDWARE AND SOFTWARE 1. Sytem Hardware...

Full description

Bibliographic Details
Other Authors: Lock, Jo (Editor), McElhinny, M.W. (Editor)
Format: eBook
Language:English
Published: Dordrecht Springer Netherlands 1991, 1991
Edition:1st ed. 1991
Subjects:
Geophysics
Online Access:
Collection: Springer Book Archives -2004 - Collection details see MPG.ReNa
Table of Contents:
  • Summary
  • I. Database Design
  • 1. Relational Databases
  • 2. Choice of Database Management System
  • 3. Design of the Global Paleomagnetic Database
  • 4. Aspects of Data Entry
  • II. Oracle Hardware and Software
  • 1. Sytem Hardware and Software Recommendation for ORACLE
  • 2. ORACLE RDBMS Software Used By the GPMDB
  • III. Database Installation and Maintenance
  • 1. The Role of the Database Administrator
  • 2. Preparing Your PC for the Installation of ORACLE RDBMS
  • 3. Installing the ORACLE RDBMS
  • 4. System Preparation and Loading the Global Paleomagnetic Database
  • 5. Database Administrative Tasks
  • 6. Backing Up and Restoring Your Database
  • 7. Factors Affecting ORACLE Performance
  • IV. Database Queries with SQL*Menu and SQL*Forms
  • 1. SQL*Menu with the Global Paleomagnetic Database
  • 2. Running SQL*Forms (RUNFORM)
  • 3. SQL*Forms Designer (SQLFORMS)
  • 4. ORACLE for Macintosh with HyperCard
  • V. Database Queries With SQL*Plus
  • 1. The ORACLE Database System
  • 2. Introduction to SQL*Plus
  • 3. Developing More Complex SQL Commands
  • 4. SQL*Plus Commands
  • 5. More Advanced SQL Queries
  • 6. Using SQL*Plus Commands to Operate on Your Own Data
  • References
  • Acknowledgements
  • Appendices
  • Appendix 1 — Table and View Descripions
  • 1.1. List of Tables and Views in the GPMDB
  • 1.2. Description of Tables in the GPMDB
  • 1.3. List of the Views in the GPMDB
  • 1.4. Description of Tables in the Compact Database — ABASE
  • Appendix 2 — View Code
  • 1. SQL Statements Used to Create the GPMDB Views
  • 1.1. View ALLCAGE
  • 1.2. View PRICAGE
  • 1.3. View RSLTALL
  • 1.4. View RSLTPRI
  • Appendix 3 — Custombuilt .SQL Command File Code

Similar Items