000 04273 a2200265 4500
008 250318s########|||||||||||||||||||||||#d
020 _a0-89435-356-X
040 _aGAMADERO2
_bspa
_cGAMADERO2
100 _aW. H. Inmon
245 _aUsing Oracle to build decision support systems /
250 _a1ERA EDICION
260 _bQED Information sciences
_aEstados Unidos
_c1989
300 _aseries
_bilustraciones, tablas, graficas
_c27cm
490 0 _aseries
504 _aEDITORIAL QED Information sciences ISBN 0-89435-356-X
505 _a 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
520 _aORACLE-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.
526 _aIngeniería en Tecnologías de la Información y Comunicación
650 0 _aIngeniería en tecnologias de la información y comunicaciones
_9585
942 _cLIB
_2ddc
_e1ERA EDICION
945 _a1
_badmin
_c1261
_dJenny Viridiana Quiroz Linares
999 _c2073
_d2073