Using Oracle to build decision support systems /
Series: seriesPublication details: QED Information sciences Estados Unidos 1989Edition: 1ERA EDICIONDescription: series ilustraciones, tablas, graficas 27cmISBN:- 0-89435-356-X
| Item type | Current library | Call number | Copy number | Status | Date due | Barcode | |
|---|---|---|---|---|---|---|---|
Libro
|
CI Gustavo A. Madero 2 | LCC | 1 | Available |
EDITORIAL
QED Information sciences
ISBN
0-89435-356-X
Preface vii
Chapter 1 The Effective DSS/ORACLE Environment 1
The Different Environments 2
The Effective DSS Environment-In Summary
23
Questions
23
Chapter 2 Effective DSS/ORACLE Systems-The Issues
25
Accuracy and Credibility of Data
26
Timeliness, Ease of Access of Data
34
Cost of Processing 38
Questions 41
Chapter 3 An Architecture for Effective DSS/ORACLE
Systems 43
The Evolution of the Architecture 44
Some Examples
77
In Summary 84
Questions 85
Chapter 4 Operational Data/External Data in Support of the DSS/ORACLE Environment 89
Input/Output 90
The System of Record
96
In Summary 99
Questions 99
Chapter 5 Atomic Level DSS/ORACLE Data
101
Continous Data 104
106 Event Discrete Data
Periodic Discrete Atomic Data
Refreshing the Atomic Data 108
108
Accessing Data 111
Purging Atomic Data 113
Subject Orientation of Atomic Level Data
114
Supporting Technology 115
Summarized Atomic Data
116
Different Levels of Atomic Data
116
In Summary 118
Questions
118
Chapter 6 Departmental, Individual Level Data in the DSS/ORACLE Environment
Archival Data-DSS Processing
126
121
In Summary 135
Questions 135
Chapter 7 Projection Data/Projection Processing in the DSS/
ORACLE Environment
137
Historical Data 137
Projection Data 138
One-Way/Two-Way Street 140
Controlling Uncontrolled Data
141
In Summary
146
Questions
146
Chapter 8 Migration to the DSS/ORACLE Architecture
147
The Production Environment 147
The Data Model 149
ERD to DSS 151
System of Record
154
Migration Steps 170
The Agents of Change 172
In Summary
172
Questions
173
Chapter 9 Design Approaches/Techniques for the DSS/ORACLE
Environment 175
Design Techniques
176
In Summary 189
Questions
190
Basic Data Base Design 2
Summary 16
Questions 16
Chapter 2 ORACLE-More Basics 21
Keys 21
Clustering Data 22
I/Os 24
Programs/SQL 26
Online/Batch Processing 27
Utilities 27
Relationships 28
Operational/Decision Support Environments 32
Some ORACLE Terminology/Components 33
Summary 33
Questions 33
ORACLE-ORACLE Corporation's database manager-is a powerful piece of software that has many capabilities. ORACLE can be used in the production environment and in the DSS environment. A previous work-ORACLE: BUILDING HIGH PERFORMANCE ONLINE SYS-TEMS, QED, 1989-explored ORACLE and high-performance, high-availability systems. This book explores ORACLE in the end-user, DSS environment.
As in the case of using ORACLE to build production systems, building DSS systems begins with understanding and establishing the DSS environment. Simply taking the technology of ORACLE and building DSS systems without understanding the larger issues of the DSS environment is a prescription for disaster.
The DSS environment is typified by free-form access and usage of data, high flexibility of data structures, the ability to construct sys-tems quickly, and so forth. In short, the DSS environment supports heuristic, nonrepetitive processing on which decisions about the man-agement of the company are made. But unlocking the promise of the DSS/ORACLE environment requires a thorough grounding in the is-sues of the DSS environment.
Ingeniería en Tecnologías de la Información y Comunicación
There are no comments on this title.
Click on an image to view it in the image viewer
