TY  - GEN
AU  - W. H. Inmon
TI  - Using Oracle to build decision support systems
T2  - series
SN  - 0-89435-356-X
PY  - 1989///
CY  - Estados Unidos 
PB  - QED Information sciences
KW  - Ingeniería en tecnologias de la información y comunicaciones
N1  - 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; Ingeniería en Tecnologías de la Información y Comunicación
N2  - 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
ER  -