Database Design and Implementation Second Edition

This textbook examines database systems from the viewpoint of a software developer. This perspective makes it possible to investigate why database systems are the way they are. It is of course important to be able to write queries, but it is equally impor

  • PDF / 15,372,790 Bytes
  • 468 Pages / 439.42 x 666.14 pts Page_size
  • 73 Downloads / 282 Views

DOWNLOAD

REPORT


Edward Sciore

Database Design and Implementation Second Edition

Data-Centric Systems and Applications Series editors Michael J. Carey Stefano Ceri Editorial Board Members Anastasia Ailamaki Shivnath Babu Philip A. Bernstein Johann-Christoph Freytag Alon Halevy Jiawei Han Donald Kossmann Gerhard Weikum Kyu-Young Whang Jeffrey Xu Yu

More information about this series at http://www.springer.com/series/5258

Edward Sciore

Database Design and Implementation Second Edition

Edward Sciore Boston College Chestnut Hill, MA, USA

ISSN 2197-9723 ISSN 2197-974X (electronic) Data-Centric Systems and Applications ISBN 978-3-030-33835-0 ISBN 978-3-030-33836-7 (eBook) https://doi.org/10.1007/978-3-030-33836-7 The first edition of this book was published by John Wiley & Sons, Inc. © Springer Nature Switzerland AG 2020 This work is subject to copyright. All rights are reserved by the Publisher, whether the whole or part of the material is concerned, specifically the rights of translation, reprinting, reuse of illustrations, recitation, broadcasting, reproduction on microfilms or in any other physical way, and transmission or information storage and retrieval, electronic adaptation, computer software, or by similar or dissimilar methodology now known or hereafter developed. The use of general descriptive names, registered names, trademarks, service marks, etc. in this publication does not imply, even in the absence of a specific statement, that such names are exempt from the relevant protective laws and regulations and therefore free for general use. The publisher, the authors, and the editors are safe to assume that the advice and information in this book are believed to be true and accurate at the date of publication. Neither the publisher nor the authors or the editors give a warranty, expressed or implied, with respect to the material contained herein or for any errors or omissions that may have been made. The publisher remains neutral with regard to jurisdictional claims in published maps and institutional affiliations. This Springer imprint is published by the registered company Springer Nature Switzerland AG. The registered company address is: Gewerbestrasse 11, 6330 Cham, Switzerland

Preface

A database system is a common, visible tool in the corporate world—employees frequently interact directly with database systems to submit data or create reports. Database systems are also common, but invisible, as components of software systems. For example, consider an e-commerce website that uses a server-side database to hold customer, product, and sales information. Or consider a GPS navigation system that uses an embedded database to manage the road maps. In both of these examples, the presence of the database system is hidden from the user; the application code performs all of the database interaction. From the point of view of a software developer, learning to use a database directly is rather mundane, because modern database systems contain sophisticated front ends that make the creation of queries and reports straightforwar