Concise Guide To Databases

This easy-to-read textbook/reference presents a comprehensive introduction to databases, opening with a concise history of databases and of data as an organisational asset. As relational database management systems are no longer the only database solution, the book takes a wider view of database technology, encompassing big data, NoSQL, object and object-relational and in-memory databases. The text also examines the issues of scalability, availability, performance and security encountered when building and running a database in the real world. Topics and features: presents review and discussion questions at the end of each chapter, in addition to skill-building, hands-on exercises; introduces the fundamental concepts and technologies in database systems, placing these in an historic context; describes the challenges faced by database professionals; reviews the use of a variety of database types in business environments; discusses areas for further research within this fast-moving domain.

Modern businesses depend on data for their very survival, creating a need for sophisticated databases and database technologies to help store, organise and transport their valuable data. This updated and expanded, easy-to-read textbook/reference presents a comprehensive introduction to databases, opening with a concise history of databases and of data as an organisational asset. As relational database management systems are no longer the only database solution, the book takes a wider view of database technology, encompassing big data, NoSQL, object and object-relational, and in-memory databases. Presenting both theoretical and practical elements, the new edition also examines the issues of scalability, availability, performance and security encountered when building and running a database in the real world. Topics and features: Presents review and discussion questions at the end of each chapter, in addition to skill-building, hands-on exercises Provides new material on database adaptiveness, integration, and efficiency in relation to data growth Introduces a range of commercial databases and encourages the reader to experiment with these in an associated learning environment Reviews use of a variety of databases in business environments, including numerous examples Discusses areas for further research within this fast-moving domain With its learning-by-doing approach, supported by both theoretical and practical examples, this clearly-structured textbook will be of great value to advanced undergraduate and postgraduate students of computer science, software engineering, and information technology. Practising database professionals and application developers will also find the book an ideal reference that addresses today's business needs. Konstantinos Domdouzis is senior lecturer in the Communication and Computing Research Centre at Sheffield Hallam University, UK. Peter Lake (now retired) was formerly course leader for the Oracle IT&M MSc and the IT Professional MSc at Sheffield Hallam University. Paul Crowther (now retired) was formerly head of postgraduatetaught programmes in the Faculty of Arts, Computing, Engineering and Sciences at Sheffield Hallam University.

Modern businesses depend on data for their very survival, creating a need for sophisticated databases and database technologies to help store, organise and transport their valuable data. This updated and expanded, easy-to-read textbook/reference presents a comprehensive introduction to databases, opening with a concise history of databases and of data as an organisational asset. As relational database management systems are no longer the only database solution, the book takes a wider view of database technology, encompassing big data, NoSQL, object and object-relational, and in-memory databases. Presenting both theoretical and practical elements, the new edition also examines the issues of scalability, availability, performance and security encountered when building and running a database in the real world. Topics and features: Presents review and discussion questions at the end of each chapter, in addition to skill-building, hands-on exercises Provides new material on database adaptiveness, integration, and efficiency in relation to data growth Introduces a range of commercial databases and encourages the reader to experiment with these in an associated learning environment Reviews use of a variety of databases in business environments, including numerous examples Discusses areas for further research within this fast-moving domain With its learning-by-doing approach, supported by both theoretical and practical examples, this clearly-structured textbook will be of great value to advanced undergraduate and postgraduate students of computer science, software engineering, and information technology. Practising database professionals and application developers will also find the book an ideal reference that addresses today's business needs.

Want to learn about databases without the tedium? With its unique combination of Japanese-style comics and serious educational content, The Manga Guide to Databases is just the book for you. Princess Ruruna is stressed out. With the king and queen away, she has to manage the Kingdom of Kod's humongous fruit-selling empire. Overseas departments, scads of inventory, conflicting prices, and so many customers! It's all such a confusing mess. But a mysterious book and a helpful fairy promise to solve her organizational problems—with the practical magic of databases. In The Manga Guide to Databases, Tico the fairy teaches the Princess how to simplify her data management. We follow along as they design a relational database, understand the entity-relationship model, perform basic database operations, and delve into more advanced topics. Once the Princess is familiar with transactions and basic SQL statements, she can keep her data timely and accurate for the entire kingdom. Finally, Tico explains ways to make the database more efficient and secure, and they discuss methods for concurrency and replication. Examples and exercises (with answer keys) help you learn, and an appendix of frequently used SQL statements gives the tools you need to create and maintain full-featured databases. (Of course, it wouldn't be a royal kingdom without some drama, so read on to find out who gets the girl—the arrogant prince or the humble servant.) This EduManga book is a translation of a bestselling series in Japan, co-published with Ohmsha, Ltd., of Tokyo, Japan.

This concise guide sheds light on the principles behind the relational model, which underlies all database products in wide use today. It goes beyond the hype to give you a clear view of the technology -- a view that's not influenced by any vendor or product. Suitable for experienced database developers and designers.

Provides a clear and concise description of each online database; evaluates strengths and weaknesses; provides information on span and update frequency of data; typical search costs; CD-ROM and internet availability and offers tips and advice that will allow the reader to use each resource to greatest advantage.

When it comes to choosing, using, and maintaining a database, understanding its internals is essential. But with so many distributed databases and tools available today, it’s often difficult to understand what each one offers and how they differ. With this practical guide, Alex Petrov guides developers through the concepts behind modern database and storage engine internals. Throughout the book, you’ll explore relevant material gleaned from numerous books, papers, blog posts, and the source code of several open source databases. These resources are listed at the end of parts one and two. You’ll discover that the most significant distinctions among many modern databases reside in subsystems that determine how storage is organized and how data is distributed. This book examines: Storage engines: Explore storage classification and taxonomy, and dive into B-Tree-based and immutable Log Structured storage engines, with differences and use-cases for each Storage building blocks: Learn how database files are organized to build efficient storage, using auxiliary data structures such as Page Cache, Buffer Pool and Write-Ahead Log Distributed systems: Learn step-by-step how nodes and processes connect and build complex communication patterns Database clusters: Which consistency models are commonly used by modern databases and how distributed storage systems achieve consistency

This flexible text can serve as the basis of a course in information literacy or as a supplemental text or basic research guide in any course. Both a students' textbook and an instructional reference for educators, this brief but information-rich text teaches students what information literacy is and why it's such an important skill to develop. Authors Scott Lanning and Caitlin Gerrity concentrate on developing skills and behaviors that positively impact the information literacy process. They teach such skills as evaluating and using information and behaviors like exploring, analyzing, and creating. Updated to incorporate the new AASL standards, this third edition of Concise Guide to Information Literacy includes new information on the value of curiosity and choice in the research process, offers a new model of the research process (the Reflective Inquiry Model), and updates the Decision Points Information Seeking Model that describes how student researchers choose to use the information they've found. This book has proven to be invaluable for high school and college students learning about information literacy and librarians and teachers in upper high school and community college settings.