The Global Paleomagnetic Database de Jo Lock

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

Jo Lock

M.W. McElhinny

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.

Citește tot Restrânge

	Preț	Express
Paperback (1)	617^.00 lei 6-8 săpt.
SPRINGER NETHERLANDS – 25 sep 2012	617^.00 lei 6-8 săpt.
Hardback (1)	628^.57 lei 6-8 săpt.
SPRINGER NETHERLANDS – 31 iul 1991	628^.57 lei 6-8 săpt.

Preț

Express

Paperback (1)

617^.00 lei 6-8 săpt.

SPRINGER NETHERLANDS – 25 sep 2012

617^.00 lei 6-8 săpt.

Hardback (1)

628^.57 lei 6-8 săpt.

SPRINGER NETHERLANDS – 31 iul 1991

628^.57 lei 6-8 săpt.

Cuprins

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.