Baesens Bart - Principles of database management : the practical guide to storing, managing and analyzing big and small data

Principles of Database Management

The Practical Guide to Storing, Managing and Analyzing Big and Small Data

Principles of Database Management provides students with the comprehensive database management information to understand and apply the fundamental concepts of database design and modeling, database systems, data storage and the evolving world of data warehousing, governance and more. Designed for those studying database management for information management or computer science, this illustrated textbook has a well-balanced theorypractice focus and covers the essential topics, from established database technologies up to recent trends like Big Data, NoSQL and analytics. On-going case studies, drill-down boxes that reveal deeper insights on key topics, retention questions at the end of every section of a chapter, and connections boxes that show the relationship between concepts throughout the text are included to provide the practical tools to get started in database management.

Key features include:

• Full-color illustrations throughout the text.

• Extensive coverage of important trending topics, including data warehousing, business intelligence, data integration, data quality, data governance, Big Data and analytics.

• An online playground with diverse environments, including MySQL for querying; MongoDB; Neo4j Cypher; and a tree structure visualization environment.

• Hundreds of examples to illustrate and clarify the concepts discussed that can be reproduced on the books companion online playground.

• Case studies, review questions, problems and exercises in every chapter.

• Additional cases, problems and exercises in the appendix.

I havent seen an as up-to-date and comprehensive textbook for database management as this one in many years. Principles of Database Management combines a number of classical and recent topics concerning data modeling, relational databases, object-oriented databases, XML, distributed data management, NoSQL and Big Data in an unprecedented manner. The authors did a great job in stitching these topics into one coherent and compelling story that will serve as an ideal basis for teaching both introductory and advanced courses.

This is a very timely book with outstanding coverage of database topics and excellent treatment of database details. It not only gives very solid discussions of traditional topics such as data modeling and relational databases, but also contains refreshing contents on frontier topics such as XML databases, NoSQL databases, Big Data and analytics. For those reasons, this will be a good book for database professionals, who will keep using it for all stages of database studies and works.

This accessible, authoritative book introduces the reader the most important fundamental concepts of data management, while providing a practical view of recent advances. Both are essential for data professionals today.

This guide to big and small data management addresses both fundamental principles and practical deployment. It reviews a range of databases and their relevance for analytics. The book is useful to practitioners because it contains many case studies, links to open-source software, and a very useful abstraction of analytics that will help them choose solutions better. It is important to academics because it promotes database principles which are key to successful and sustainable data science.

This book covers everything you will need to teach in a database implementation and design class. With some chapters covering Big Data, analytic models/methods and NoSQL, it can keep our students up to date with these new technologies in data management-related topics.

Principles of Database Management

The Practical Guide to Storing, Managing and Analyzing Big and Small Data

Wilfried Lemahieu

KU Leuven, Belgium

Seppe vanden Broucke

KU Leuven, Belgium

Bart Baesens

KU Leuven, Belgium; University of Southampton, United Kingdom

University Printing House, Cambridge CB2 8BS, United Kingdom

One Liberty Plaza, 20th Floor, New York, NY 10006, USA

477 Williamstown Road, Port Melbourne, VIC 3207, Australia

314321, 3rd Floor, Plot 3, Splendor Forum, Jasola District Centre, New Delhi 110025, India

79 Anson Road, #0604/06, Singapore 079906

Cambridge University Press is part of the University of Cambridge.

It furthers the Universitys mission by disseminating knowledge in the pursuit of education, learning, and research at the highest international levels of excellence.

www.cambridge.org

Information on this title: www.cambridge.org/9781107186125

DOI: 10.1017/9781316888773

Wilfried Lemahieu, Seppe vanden Broucke, and Bart Baesens 2018

This publication is in copyright. Subject to statutory exception and to the provisions of relevant collective licensing agreements, no reproduction of any part may take place without the written permission of Cambridge University Press.

First published 2018

Printed and bound in Great Britain by Clays Ltd, Elcograf S.p.A.

A catalog record for this publication is available from the British Library.

Library of Congress Cataloging-in-Publication Data

Names: Lemahieu, Wilfried, 1970 author. | Broucke, Seppe vanden, 1986 author. | Baesens, Bart, author.

Title: Principles of database management : the practical guide to storing, managing and analyzing big and small data / Wilfried Lemahieu, Katholieke Universiteit Leuven, Belgium, Seppe vanden Broucke, Katholieke Universiteit Leuven, Belgium, Bart Baesens, Katholieke Universiteit Leuven, Belgium.

Description: First edition. | New York, NY : Cambridge University Press, 2018. | Includes bibliographical references and index.

Identifiers: LCCN 2018023251 | ISBN 9781107186125 (hardback : alk. paper)

Subjects: LCSH: Database management.

Classification: LCC QA76.9.D3 L454 2018 | DDC 005.74dc23

LC record available at https://lccn.loc.gov/2018023251

ISBN 978-1-107-18612-5 Hardback

Additional resources for this publication at www.cambridge.org/Lemahieu

Cambridge University Press has no responsibility for the persistence or accuracy of URLs for external or third-party internet websites referred to in this publication and does not guarantee that any content on such websites is, or will remain, accurate or appropriate.

Brief Contents

Contents

About the Authors