Concise Guide to Databases: A Practical Introduction (Undergraduate Topics in Computer Science)

This easy-to-read textbook/reference offers a finished creation to databases, commencing with a concise heritage of databases and of information as an organisational asset. As relational database administration platforms are not any longer the one database resolution, the ebook takes a much wider view of database expertise, encompassing mammoth info, NoSQL, item and object-relational and in-memory databases. The textual content additionally examines the problems of scalability, availability, functionality and safeguard encountered while development and operating a database within the actual international. subject matters and contours: offers overview and dialogue questions on the finish of every bankruptcy, as well as skill-building, hands-on routines; introduces the elemental thoughts and applied sciences in database platforms, putting those in an historical context; describes the demanding situations confronted by way of database pros; reports using numerous database kinds in company environments; discusses components for extra study inside of this fast-moving area.

Show description

Quick preview of Concise Guide to Databases: A Practical Introduction (Undergraduate Topics in Computer Science) PDF

Similar Computer Science books

Web Services, Service-Oriented Architectures, and Cloud Computing, Second Edition: The Savvy Manager's Guide (The Savvy Manager's Guides)

Net prone, Service-Oriented Architectures, and Cloud Computing is a jargon-free, hugely illustrated rationalization of ways to leverage the speedily multiplying prone on hand on the web. the way forward for company depends on software program brokers, cellular units, private and non-private clouds, sizeable facts, and different hugely attached expertise.

Software Engineering: Architecture-driven Software Development

Software program Engineering: Architecture-driven software program improvement is the 1st complete advisor to the underlying abilities embodied within the IEEE's software program Engineering physique of data (SWEBOK) average. criteria professional Richard Schmidt explains the conventional software program engineering practices famous for constructing tasks for presidency or company structures.

Platform Ecosystems: Aligning Architecture, Governance, and Strategy

Platform Ecosystems is a hands-on advisor that provides an entire roadmap for designing and orchestrating brilliant software program platform ecosystems. in contrast to software program items which are controlled, the evolution of ecosystems and their myriad individuals needs to be orchestrated via a considerate alignment of structure and governance.

Additional resources for Concise Guide to Databases: A Practical Introduction (Undergraduate Topics in Computer Science)

Show sample text content

10 company Takeovers 10 1. eleven The demanding situations of Multi nationwide Operations eleven 1. 12 the information Asset 12 1. thirteen digital garage thirteen 1. 14 giant information 15 1. 15 resources in the Cloud sixteen 1. sixteen info, information in every single place 17 1. 17 precis 18 1. 18 workouts 18 1. 18. 1 assessment Questions 18 1. 18. 2 crew paintings examine actions 19 References 19 2 A historical past of Databases 21 2. 1 creation 21 2. 2 The electronic Age 21 2. three Sequential platforms 22 2. four Random entry 23 2. five Origins of Modern Databases 24 2. 6 Transaction Processing and ACID 25 2. 7 Two-Phase dedicate 26 2. eight Hierarchical Databases 27 2. nine community Databases 27 2. 10 Relational Databases 28 2. eleven item orientated Databases 30 2. 12 info Warehouse 30 2. thirteen The Gartner Hype Cycle 32 2. 14 sizeable information 33 2. 15 info in the Cloud 33 2. sixteen the necessity for Speed 34 2. 17 In-Memory Database 34 2. 18 NoSQL 35 2. 19 Spatial Databases 35 2. 20 Databases on Personal desktops 36 2. 21 allotted Databases 36 2. 22 XML 37 2. 23 Temporal Databases 38 2. 24 precis 39 2. 25 workouts 39 2. 25. 1 evaluation Questions 39 2. 25. 2 staff paintings learn actions 39 References forty three actual garage and Distribution forty-one three. 1 the basic construction Block forty-one three. 2 total Database structure forty two three. 2. 1 In-Memory constructions forty two three. 2. 2 jogging via a Straightforward learn forty three three. 2. three Server tactics forty five three. 2. four everlasting constructions forty six three. three info garage forty seven three. three. 1 Row Chaining and Migration fifty two three. three. 2 Non-relational Databases fifty two three. four How Logical information buildings Map to Physical fifty two three. five regulate, Redo and Undo fifty two three. 6 Log and hint documents fifty four three. 7 phases of Start-up and Shutdown fifty four three. eight Locking fifty seven three. nine relocating information fifty eight three. 10 Import and Export 60 three. 10. 1 information is necessary sixty one three. eleven disbursed Databases sixty one three. 12 precis sixty four three. thirteen assessment Questions sixty four three. 14 team paintings examine actions sixty four References sixty five half II Database varieties four Relational Databases sixty nine four. 1 Origins sixty nine four. 2 Normalisation 70 four. 2. 1 First general shape (1NF) seventy one four. three moment basic shape (2NF) seventy two four. four 3rd general shape (3NF) seventy three four. five past 3rd basic shape seventy five four. 6 Entity Modelling seventy six four. 7 Use Case Modelling seventy six four. eight extra Modelling innovations eighty two four. nine Notation eighty three four. 10 changing a Design into a Relational Database eighty five four. eleven labored instance 87 four. 12 Create the Tables 87 four. thirteen CRUDing 89 four. 14 Populate the Tables ninety four. 15 Retrieve information ninety four. sixteen Joins ninety one four. 17 extra advanced info Retrieval ninety three four. 18 replace and DELETE ninety four four. 19 overview Questions ninety five four. 20 crew paintings learn task ninety five References ninety six five NoSQL Databases ninety seven five. 1 Databases and the Web ninety seven five. 2 The NoSQL move ninety eight five. 2. 1 what's intended by NoSQL? a hundred five. three transformations in Philosophy a hundred and one five. four essentially to be had, tender country, finally constant (BASE) 103 five. five Column-Based technique 103 five. 6 Examples of Column-Based utilizing Cassandra 104 five. 6. 1 Cassandra’s uncomplicated construction Blocks 106 five. 6. 2 info assets 107 five. 6. three Getting all started 107 five. 6. four growing the Column kinfolk a hundred and ten five. 6. five putting facts 112 five. 6. 6 Retrieving info 112 five. 6. 7 Deleting information and elimination buildings 114 five.

Download PDF sample

Rated 4.53 of 5 – based on 12 votes