Database Principles


Book Description

Practical and easy to understand Database Principles: Fundamentals of Design, Implementation, and Management, 10/e, International Edition gives readers a solid foundation in database design and implementation. Filled with visual aids such as diagrams, illustrations, and tables, this market-leading book provides in-depth coverage of database design, demonstrating that the key to successful database implementation is in proper design of databases to fit within a larger strategic view of the data environment. Renowned for its clear, straightforward writing style, the tenth edition has been thoroughly updated to include hot topics such as green computing/sustainability for modern data centers, the role of redundant relationships, and examples of web-database connectivity and code security. In addition, new review questions, problem sets, and cases have been added throughout the book so that readers have multiple opportunities to test their understanding and develop real and useful design skills.




Principles of Database Management


Book Description

Introductory, theory-practice balanced text teaching the fundamentals of databases to advanced undergraduates or graduate students in information systems or computer science.




Principles of Distributed Database Systems


Book Description

This third edition of a classic textbook can be used to teach at the senior undergraduate and graduate levels. The material concentrates on fundamental theories as well as techniques and algorithms. The advent of the Internet and the World Wide Web, and, more recently, the emergence of cloud computing and streaming data applications, has forced a renewal of interest in distributed and parallel data management, while, at the same time, requiring a rethinking of some of the traditional techniques. This book covers the breadth and depth of this re-emerging field. The coverage consists of two parts. The first part discusses the fundamental principles of distributed data management and includes distribution design, data integration, distributed query processing and optimization, distributed transaction management, and replication. The second part focuses on more advanced topics and includes discussion of parallel database systems, distributed object management, peer-to-peer data management, web data management, data stream systems, and cloud computing. New in this Edition: • New chapters, covering database replication, database integration, multidatabase query processing, peer-to-peer data management, and web data management. • Coverage of emerging topics such as data streams and cloud computing • Extensive revisions and updates based on years of class testing and feedback Ancillary teaching materials are available.




Database Tuning


Book Description

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




Access Database Design & Programming


Book Description

For programmers who prefer content to frills, this guide has succinct and straightforward information for putting Access to its full, individually tailored use.




Principles of Data-base Management


Book Description

Textbook on principles of computer data base management - covers data organization, data base software, (incl. Languages), data protection, confidentiality and privacy, information quality, management information systems, technical aspects, etc. Bibliography pp. 341 to 344, diagrams, flow charts and glossary.




Oracle Database Principles


Book Description

This text describes the major components of Oracle such as SQL Plus, PL/SQL, indexing, security and integrity, and distributed databases. Underlying principles are also described in the book, and there are chapters on the objectives of database systems and on the relational model.




Database Principles and Technologies – Based on Huawei GaussDB


Book Description

This open access book contains eight chapters that deal with database technologies, including the development history of database, database fundamentals, introduction to SQL syntax, classification of SQL syntax, database security fundamentals, database development environment, database design fundamentals, and the application of Huawei’s cloud database product GaussDB database. This book can be used as a textbook for database courses in colleges and universities, and is also suitable as a reference book for the HCIA-GaussDB V1.5 certification examination. The Huawei GaussDB (for MySQL) used in the book is a Huawei cloud-based high-performance, highly applicable relational database that fully supports the syntax and functionality of the open source database MySQL. All the experiments in this book can be run on this database platform. As the world’s leading provider of ICT (information and communication technology) infrastructure and smart terminals, Huawei’s products range from digital data communication, cyber security, wireless technology, data storage, cloud computing, and smart computing to artificial intelligence.




Principle Advancements in Database Management Technologies: New Applications and Frameworks


Book Description

Significant progression and usage of Internet innovations has caused a need for streamlining past, present, and future database technologies. Principle Advancements in Database Management Technologies: New Applications and Frameworks presents exemplary research in a variety of areas related to database development, technology, and use. This authoritative reference source presents innovative approaches by leading international experts to serve as the primary database management source for researchers, practitioners, and academicians.




Database Design: Know It All


Book Description

This book brings all of the elements of database design together in a single volume, saving the reader the time and expense of making multiple purchases. It consolidates both introductory and advanced topics, thereby covering the gamut of database design methodology ? from ER and UML techniques, to conceptual data modeling and table transformation, to storing XML and querying moving objects databases. The proposed book expertly combines the finest database design material from the Morgan Kaufmann portfolio. Individual chapters are derived from a select group of MK books authored by the best and brightest in the field. These chapters are combined into one comprehensive volume in a way that allows it to be used as a reference work for those interested in new and developing aspects of database design. This book represents a quick and efficient way to unite valuable content from leading database design experts, thereby creating a definitive, one-stop-shopping opportunity for customers to receive the information they would otherwise need to round up from separate sources. - Chapters contributed by various recognized experts in the field let the reader remain up to date and fully informed from multiple viewpoints. - Details multiple relational models and modeling languages, enhancing the reader's technical expertise and familiarity with design-related requirements specification. - Coverage of both theory and practice brings all of the elements of database design together in a single volume, saving the reader the time and expense of making multiple purchases.