Solutions for Networked Databases (eBook)

How to Move from Heterogeneous Structures to Federated Concepts

Dimitris N. Chorafas, Heinrich Steinmann (Autoren)

eBook Download: PDF

2014 | 1. Auflage
350 Seiten
Elsevier Science (Verlag)
978-1-4832-1750-5 (ISBN)

Infos

Solutions for Networked Databases: How to Move from Heterogeneous Structures to Federated Concepts reviews developments in standards and ad hoc solutions aimed at providing cross-database connectivity for networked databases. The emphasis is on how to move from heterogeneous structures to federated concepts. The advent of the multidatabase is discussed, along with schemata, dictionaries, and protocols. Applications with federated databases are also considered. Comprised of 18 chapters, this book begins with an introduction to database and knowledge bank concepts; reliability and availability characteristics; and the synergy necessary to create and sustain federated databases. Centralized and distributed databases are then compared, and the different ways of managing distributed databases are outlined. Subsequent chapters focus on the importance of treating the networked database as a corporate resource; the use of schemata to solve cross-database problems; the Information Resource Dictionary System; and application programming interface and remote data access. A solution to heterogeneous distributed databases, the Data Access Integrated Services (DAIS), is described. This monograph is written for specialists in computers and communications.

Dr Chorafas has served on the faculty of the Catholic University of America and as visiting professor at Washington State University, George Washington University, University of Vermont, University of Florida, and Georgia Institute of Technology. Also, the University of Alberta, Technical University of Karlsruhe, Ecole d'Etudes Industrielles de l'Universit‚ de GenŠve, Ecole Polytechnic F‚d‚rale de Lausanne, Polish Academy of Sciences and Russian Academy of Sciences. More than 8,000 banking, industrial and government executives have participated in his seminars in the United States, England, Germany, Italy, other European countries, Asia and Latin America.Financial institutions which sought his assistance include the Union Bank of Switzerland, Bank Vontobel, CEDEL, the Bank of Scotland, Credit Agricole, ™sterreichische L„nderbank (Bank Austria), First Austrian Bank, Commerzbank, Dresdner Bank, Demir Bank, Mid-Med Bank, Banca Nazionale dell'Agricoltura, Istituto Bancario Italiano, Credito Commerciale and Banca Provinciale Lombarda.Dr Chorafas is the author of 161 books, translated into several languages.

Inhalt

Front Cover 1
Solutions 
4 
Copyright Page 5
Table of Contents 6
PREFACE 12
ACKNOWLEDGMENTS 16
PART I: Advent of the Multidatabase 30
Chapter 1. Developing a Corporate Database Concept 32
1.1 Introduction 32
1.2 Fundamental Notions for the 1990s 33
1.3 What Is the Sense of Database Operations? 36
1.4 The Concept of Corporate Databases and 
38 
1.5 Information Solutions in a Knowledge Society 41
1.6 The Reliability of Large Databases 43
1.7 Networked Databases and Reliability Measures 45
1.8 Fault Tolerance Means Availability 48
Chapter 2. Distributed versus Centralized Database Solutions 51
2.1 Introduction 51
2.2 The Increasing Complexity of Database Applications 52
2.3 Is Cultural Change a Prerequisite? 55
2.4 Distributing the Information Elements 57
2.5 Standards for Data 
59 
2.6 Adopting an Open Architecture 62
2.7 Open Architectures and Interface Standa 65
Chapter 3. Managing the Networked Database 68
3.1 Introduction 68
3.2 The Need for Distributed Databases 69
3.3 The Growing Challenge of Long Transactions 71
3.4 Design Principles with Distributed Databases 73
3.5 A Two-Tier System: Common Denominator and 
76 
3.6 Distributed Data Management Beyond the Simple 
79 
3.7 What Is the Added Value of Message Passing? 83
Chapter 4. Treating the Networked Database as a Corporate 
86 
4.1 Introduction 86
4.2 Optimizing Our Database Perspectives and Action 
88 
4.3 Evolving Goals in a Dynamic Organization 90
4.4 Avoiding the Beaten Path and the Data Propagator 92
4.5 New or Old Database Technology? 95
4.6 Multidatabase Requirements with Networked 
97 
4.7 Beyond the Simplest Multidatabase Links 99
Chapter 5. Computer 
102 
5.1 Introduction 102
5.2 New Areas of Expertise for Database Professionals 103
5.3 The Sense of Object-Oriented Solutions 106
5.4 Toward Integrated Databases 108
5.5 Preparing for Database Mining 111
5.6 Visualization Policies with Databases 113
5.7 Cultural Change in Database Management 116
5.8 Understanding Database Contents and Requirements 118
PART II: Schemata, Dictionaries, and Protocols 122
Chapter 6. Schemata, Metaphors, and Distributed Databases 124
6.1 Introduction 124
6.2 External Schema and Global Schema 125
6.3 Alleviating the Problems of Heterogeneity through Export 
129 
6.4 Driving for Schema Compatibility through Object 
131 
6.5 Metaphors and User Profiles 134
6.6 Enduser Control with External Schemata 138
Chapter 7. Can We Solve Cross-Database Problems through 
141 
7.1 Introduction 141
7.2 Multidatabase Approaches during the Last Decade 142
7.3 Reflecting on the Major Classes of Cross-Database 
144 
7.4 Capitalizing on the Use of Schemata 146
7.5 How Far Can Message Passing Go? 149
7.6 Proceeding with Schema Integration 152
7.7 The Semantics of Schema Integration 154
Chapter 8. The Increasingly Sophisticated Data Dictionary 158
8.1 Introduction 158
8.2 Evolving Nature of a Data Dictionary 159
8.3 Looking at the Data Dictionary from a Systems Viewpoint 163
8.4 The Japanese Electronic Dictionary 166
8.5 Word and Concept Dictionaries 169
8.6 Placing Emphasis on Reusable Software 173
Chapter 9. Information Resource Dictionary System (IRDS) 176
9.1 Introduction 176
9.2 A Reference Model That Might Become Repository 
177 
9.3 Basic Notions about IRDS 181
9.4 A Four-Layered Approach to IRDS Architecture 183
9.5 Handling Entity Names 186
9.6 Customizing and Maintaining IRDS 189
9.7 Adding to IRDS Capabilities 192
Chapter 10. ANSI SQL and the SQL Access Group 196
10.1 Introduction 196
10.2 A Family of SQL Standards 197
10.3 Standardization Efforts with the Relational Model 200
10.4 The Complex Task of Database Access 203
10.5 Interoperability and Portability 206
10.6 Dynamic versus Static SQL 209
10.7 The Open SQL Version 211
Chapter 11. Application Programming Interface, Formats and 
214 
11.1 Introduction 214
11.2 Gateways and Database Tools 215
11.3 Working toward a Standard API 218
11.4 Heterogeneous Database Implementation and the API 
221 
11.5 Formats and Protocols (FAP) 223
11.6 Implementing the Remote Data Access Protocol 225
PART III: Applications with Federated Databases 228
Chapter 12. IBM's Distributed Relational Data 
230 
12.1 Introduction 230
12.2 The Philosophy of a Cross-Database Solution 231
12.3 A Predominantly Centralized Perspective? 235
12.4 Operating under DRDA and EDA/SQL 237
12.5 DRDA and the Information Warehouse 240
12.6 Differences between DRDA and RDA 243
Chapter 13. Development of the DataLens Concept and Its 
247 
13.1 Introduction 247
13.2 Putting in Practice a Multidatabase Access Scheme 248
13.3 The 1-2-3 Database Engine: A Partner of DataLens 250
13.4 Application Programming Interface 252
13.5 The Layered Architecture of DataLens 254
13.6 Services Rendered by the DataLens Drivers 256
13.7 Mechanics of the Driver's Interconnection 259
13.8 Implementation Opportunities with DataLens 
261 
Chapter 14. The California Intelligent Database 
264 
14.1 Introduction 264
14.2 Employing the Concept of the Export Schema 265
14.3 Targeting CALIDA-88 267
14.4 Query, Schema, and Language Performance 270
14.5 Data Level Solutions through CALIDA 272
14.6 Estimator and Optimizer Functions 274
14.7 Lessons to Be Learned from the CALIDA Experience 277
14.8 Using Federated Database Principles 279
Chapter 15. The Data Access Integrated Services (DAIS) as a 
282 
15.1 Introduction 282
15.2 The Development of a DAIS Architecture 284
15.3 Approaches to Effective Data Sharing and Modeling 285
15.4 Preserving the Consistency of Networked Databases 287
15.5 Accessing and Using Distributed Information 
289 
15.6 Mapping DAIS into the ISO/OSI Infrastructure 292
15.7 Data Mappers and Schema Mappers 295
15.8 EPRI and the Implementation of DAIS 296
15.9 Integrative Corporate Solutions 298
Chapter 16. Multi vendor Integration Architecture and the 
301 
16.1 Introduction 301
16.2 Pillars of Multivendor Integration Architecture (MIA) by 
303 
16.3 Version 1 and the Implementation Timetable 305
16.4 Specifications for Technical Interconnection 307
16.5 A New Concept in Establishing Computers and 
308 
16.6 Reconsidering Our Applications and Their Database 
312 
Chapter 17. The Development of Software-Oriented 
315 
17.1 Introduction 315
17.2 Normalizing the Application Software for Portability 316
17.3 Upper and Lower Level Protocols 319
17.4 Placing 
321 
17.5 System 
323 
17.6 Support for Agile Human Interfaces 325
17.7 A System Design Guide 327
Chapter 18. Common Goals to Be Reached by MIA and the SQL 
329 
18.1 Introduction 329
18.2 Choosing Operating Systems and Establishing Their 
330 
18.3 A Time for Critical Decisions 332
18.4 Programming Languages and Industry Practices 
333 
18.5 Networking Computer Resources and Application 
335 
18.6 A Timetable for the Implementation of Integrative 
339 
INDEX 344

Produkt-Details

• Erscheint lt. Verlag: 10.5.2014
• Sprache: englisch
• Themenwelt: Mathematik / Informatik ► Informatik ► Theorie / Studium
• ISBN-10: 1-4832-1750-7 / 1483217507
• ISBN-13: 978-1-4832-1750-5 / 9781483217505