The rapidly increasing volume of information contained in relational databases places a strain on databases, performance, and maintainability: DBAs are under greater pressure than ever to optimize database structure for system performance and administration. Physical Database Design discusses the concept of how physical structures of databases affect performance, including specific examples, guidelines, and best and worst practices for a variety of DBMSs and configurations. Something as simple as improving the table index design has a profound impact on performance. Every form of relational database, such as Online Transaction Processing (OLTP), Enterprise Resource Management (ERP), Data Mining (DM), or Management Resource Planning (MRP), can be improved using the methods provided in the book. The first complete treatment on physical database design, written by the authors of the seminal, Database Modeling and Design: Logical Design, Fourth Edition Includes an introduction to the major concepts of physical database design as well as detailed examples, using methodologies and tools most popular for relational databases today: Oracle, DB2 (IBM), and SQL Server (Microsoft) Focuses on physical database design for exploiting B+tree indexing, clustered indexes, multidimensional clustering (MDC), range partitioning, shared nothing partitioning, shared disk data placement, materialized views, bitmap indexes, automated design tools, and more!

Time series data is of growing importance, especially with the rapid expansion of the Internet of Things. This concise guide shows you effective ways to collect, persist, and access large-scale time series data for analysis. You'll explore the theory behind time series databases and learn practical methods for implementing them. Authors Ted Dunning and Ellen Friedman provide a detailed examination of open source tools such as OpenTSDB and new modifications that greatly speed up data ingestion. You'll learn: A variety of time series use cases The advantages of NoSQL databases for large-scale time series data NoSQL table design for high-performance time series databases The benefits and limitations of OpenTSDB How to access data in OpenTSDB using R, Go, and Ruby How time series databases contribute to practical machine learning projects How to handle the added complexity of geo-temporal data For advice on analyzing time series data, check out Practical Machine Learning: A New Look at Anomaly Detection, also from Ted Dunning and Ellen Friedman.

Tuning your database for optimal performance means more than following a few short steps in a vendor-specific guide. For maximum improvement, you need a broad and deep knowledge of basic tuning principles, the ability to gather data in a systematic way, and the skill to make your system run faster. This is an art as well as a science, and Database Tuning: Principles, Experiments, and Troubleshooting Techniques will help you develop portable skills that will allow you to tune a wide variety of database systems on a multitude of hardware and operating systems. Further, these skills, combined with the scripts provided for validating results, are exactly what you need to evaluate competing database products and to choose the right one. Forward by Jim Gray, with invited chapters by Joe Celko and Alberto Lerner Includes industrial contributions by Bill McKenna (RedBrick/Informix), Hany Saleeb (Oracle), Tim Shetler (TimesTen), Judy Smith (Deutsche Bank), and Ron Yorita (IBM) Covers the entire system environment: hardware, operating system, transactions, indexes, queries, table design, and application analysis Contains experiments (scripts available on the author's site) to help you verify a system's effectiveness in your own environment Presents special topics, including data warehousing, Web support, main memory databases, specialized databases, and financial time series Describes performance-monitoring techniques that will help you recognize and troubleshoot problems

An Overview of Multidatabase Systems: Past and Present / Athman Bouguettaya, Boualem Benatallah, Ahmed Elmagarmid / - Local Autonomy and Its Effects on Multidatabase Systems / Ahmed Elmagarmid, Weimin Du, Rafi Ahmed / - Semantic Similarities Between Objects in Multiple Databases / Vipul Kashyap, Amit Sheth / - Resolution of Representational Diversity in Multidatabase Systems / Joachim Hammer, Dennis McLeod / - Schema Integration: Past, Present, and Future / Sudha Ram, V. Ramesh / - Schema and Language Translation / Bogdan Czejdo, Le Gruenwald / - Multidatabase Languages / Paolo Missier, Marek Rusinkiewicz, W. Jin / - Interdependent Database Systems / George Karabatis, Marek Rusinkiewicz, Amit Sheth / - Correctness Criteria and Concurrency Control / Panos K. Chrysanthis, Krithi Ramamritham / - Transaction Management in Multidatabase Systems: Current Technologies and Formalisms / Ken Barker, Ahmed Elmagarmid / - Transaction-Based Recovery / Jari Veijalainen. ...

Component Database Systems is a collection of invited chapters by the researchers making the most influential contributions in the database industry's trend toward componentization This book represents the sometimes-divergent, sometimes-convergent approaches taken by leading database vendors as they seek to establish commercially viable componentization strategies. Together, these contributions form the first book devoted entirely to the technical and architectural design of component-based database systems. In addition to detailing the current state of their research, the authors also take up many of the issues affecting the likely future directions of component databases. If you have a stake in the evolution of any of today's leading database systems, this book will make fascinating reading. It will also help prepare you for the technology that is likely to become widely available over the next several years. * Is comprised of contributions from the field's most highly respected researchers, including key figures at IBM, Oracle, Informix, Microsoft, and POET. * Represents the entire spectrum of approaches taken by leading software companies working on DBMS componentization strategies. * Covers component-focused architectures, methods for hooking components into an overall system, and support for component development. * Examines the component technologies that are most valuable to Web-based and multimedia databases. * Presents a thorough classification and overview of component database systems.

A breakthrough sourcebook to the challenges and solutions for mobile database systems This text enables readers to effectively manage mobile database systems (MDS) and data dissemination via wireless channels. The author explores the mobile communication platform and analyzes its use in the development of a distributed database management system. Workable solutions for key challenges in wireless information management are presented throughout the text. Following an introductory chapter that includes important milestones in the history and development of mobile data processing, the text provides the information, tools, and resources needed for MDS management, including: * Fundamentals of wireless communication * Location and handoff management * Fundamentals of conventional database management systems and why existing approaches are not adequate for mobile databases * Concurrency control mechanism schemes * Data processing and mobility * Management of transactions * Mobile database recovery schemes * Data dissemination via wireless channels Case studies and examples are used liberally to aid in the understanding and visualization of complex concepts. Various exercises enable readers to test their grasp of each topic before advancing in the text. Each chapter also concludes with a summary of key concepts as well as references for further study. Professionals in the mobile computing industry, particularly e-commerce, will find this text indispensable. With its extensive use of case studies, examples, and exercises, it is also highly recommended as a graduate-level textbook.

Database marketing is at the crossroads of technology, business strategy, and customer relationship management. Enabled by sophisticated information and communication systems, today’s organizations have the capacity to analyze customer data to inform and enhance every facet of the enterprise—from branding and promotion campaigns to supply chain management to employee training to new product development. Based on decades of collective research, teaching, and application in the field, the authors present the most comprehensive treatment to date of database marketing, integrating theory and practice. Presenting rigorous models, methodologies, and techniques (including data collection, field testing, and predictive modeling), and illustrating them through dozens of examples, the authors cover the full spectrum of principles and topics related to database marketing. "This is an excellent in-depth overview of both well-known and very recent topics in customer management models. It is an absolute must for marketers who want to enrich their knowledge on customer analytics." (Peter C. Verhoef, Professor of Marketing, Faculty of Economics and Business, University of Groningen) "A marvelous combination of relevance and sophisticated yet understandable analytical material. It should be a standard reference in the area for many years." (Don Lehmann, George E. Warren Professor of Business, Columbia Business School) "The title tells a lot about the book's approach—though the cover reads, "database," the content is mostly about customers and that's where the real-world action is. Most enjoyable is the comprehensive story – in case after case – which clearly explains what the analysis and concepts really mean. This is an essential read for those interested in database marketing, customer relationship management and customer optimization." (Richard Hochhauser, President and CEO, Harte-Hanks, Inc.) "In this tour de force of careful scholarship, the authors canvass the ever expanding literature on database marketing. This book will become an invaluable reference or text for anyone practicing, researching, teaching or studying the subject." (Edward C. Malthouse, Theodore R. and Annie Laurie Sills Associate Professor of Integrated Marketing Communications, Northwestern University)