This book provides the foundation and understanding necessary for proper design of databases for today's distributed and multi-database architectures. Introductory chapters help novices understand essential topics such as SQL, relational databases, transaction processing, and deadlock detection, while subsequent sections dealing with homogeneous, distributed databases, heterogeneous multi-databases, and federated databases enable readers to understand the complexities of distributed database design. Packed with over 200 illustrations, 50 equations, and two full chapters of examples.

Business data integration is a complex problem that must be solved when organizations change or enhance their internal structures. The goal of this book is to present a simple yet thorough resource that describes the challenges of business data integration and the solutions to these challenges such as schema integration, illustrated through an Operational Data Store (ODS) case study. The book contains three sections spanning ten chapters. Section I, Foundational Concepts, will provide you with the necessary basic concepts and discuss schema integration. Section II, Preparation and Design, introduces the case study and we will reverse engineer each of the data sources to create a set of data dictionary reports which will provide us with the meta data we need to apply the schema integration process. Section III, Physical Implementation, will present scripts to populate each of the source databases and spreadsheets and use reports to create Extract, Transform, and Load (ETL) specifications.