The Global Paleomagnetic Database: Design, Installation and Use with ORACLE

by Jo Lock (Editor), M.W. McElhinny (Editor)

Overview

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 and Software Recommendation for ORACLE 328 1. 1. For a Fully IBM Compatible Personal Computer (PC) 328 1. 2. For an Apple Macintosh PC 329 1. 3. Recommendations 330 2. ORACLE RDBMS Software Used By the GPMDB 331 2. 1. A Brief Description of the ORACLE RDBMS 331 2. 2. SQL *Plus under MS-DOS 333 2. 3. SQL *Forms under MS-DOS 336 2. 4. SQL *Menu under MS-DOS 338 2. 5. The . CRT File 339 III. DATABASE INSTALLATION AND MAINTENANCE 1. The Role of the Database Administrator 340 2. Preparing Your PC for the Installation of ORACLE RDBMS 340 2. 1. ORACLE RDBMS for MS-DOS and Extended Memory 340 2. 2. Setting up MS-DOS for ORACLE 342 3. Installing the ORACLE RDBMS 347 3. 1. ORACLE Directory Structure 347 3. 2. Installing the ORACLE RDBMS for MS-DOS 348 3. 3. Step by Step ORACLE RDBMS Installation Instructions 348 4. System Preparation and Loading the Global Paleomagnetic Da- base 353 4. 1. System Preparation 353 4. 2. Installing the Global Paleomagnetic Database 356 4. 3. Loading the Custombuilt Files 358 v SUI\. IJ\IARY vi 5. Database Administrative Tasks 363 5. 1.

Product Details

ISBN-13:	9789401055802
Publisher:	Springer Netherlands
Publication date:	09/25/2012
Edition description:	Softcover reprint of the original 1st ed. 1991
Pages:	175
Product dimensions:	6.10(w) x 9.25(h) x 0.02(d)

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.