Concise Guide to Databases: A Practical Introduction by Paul Crowther, Peter Lake

By Paul Crowther, Peter Lake

Glossy companies depend upon facts for his or her very survival, making a want for classy databases and database applied sciences to aid shop, organise and shipping their priceless data.

This easy-to-read textbook/reference provides a accomplished advent to databases, beginning with a concise historical past of databases and of information as an organisational asset. As relational database administration structures are not any longer the single database answer, the publication takes a much wider view of database expertise, encompassing gigantic facts, NoSQL, item and object-relational, and in-memory databases. The textual content additionally examines the problems of scalability, availability, functionality and safety encountered while construction and working a database within the actual world.

Topics and features:

* offers evaluation and dialogue questions on the finish of every bankruptcy, as well as skill-building, hands-on exercises
* Introduces the basic strategies and applied sciences in database structures, putting those in an ancient context
* Describes the demanding situations confronted by means of database professionals
* reports using quite a few database forms in company environments
* Discusses components for extra study inside this fast-moving domain
* indicates a constitution for a possible college direction within the preface

With its learning-by-doing strategy, supported through either theoretical and useful examples, this clearly-structured textbook can be of significant price to complex undergraduate and postgraduate scholars of laptop technological know-how, software program engineering, and knowledge know-how. working towards database execs and alertness builders also will locate the ebook an excellent reference that addresses today's enterprise wishes.

Show description

Read Online or Download Concise Guide to Databases: A Practical Introduction (Undergraduate Topics in Computer Science) PDF

Similar databases books

Teradata RDBMS SQL/Data Dictionary Quick Reference

This ebook is a short reference for the SQL dialect supported via the Teradata Relational Database administration process. The booklet is usually a short connection with the supported facts description words for the Teradata RDBMS and the knowledge Dictionary. The viewers for this fast reference is all clients of Teradata SQL who desire quickly, non-detailed information regarding find out how to constitution a SQL assertion.

Access Forms & Reports For Dummies

Create queries that make kinds and studies helpful advance varieties to entry the knowledge you wish and make reviews that make experience! if you happen to idea you needed to use a spreadsheet application to provide reviews and varieties, wager what! entry can prove great-looking varieties and studies that truly exhibit what is going on together with your information -- in case you understand how to invite it properly.

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

Example text

68). Bady says that the baseline of our information environment has become a tendency towards total availability and recall—indefinitely storing and circulating everything. We often add to the circulation ourselves by agreeing to allow the sharing of our details. This is often in the ‘fine print’ of the terms and conditions of loyalty card application forms or when you set up an account with an on-line retailer. All this means that collecting standardizing, processing and selling vast pools of data has become big business—data as a true, tradable international organisational asset.

The two phases are the request phase and the commit phase. In the request phase a coordinating process sends a query to commit message to all other processes. The expected response is ‘YES’ otherwise the transaction aborts. In the commit phase the coordinator sends a message to the other processes which attempt to complete the commit (make changes permanent). If any one process fails, all processes will execute a rollback. Oracle, although calling it a two-phase commit has defined three phases: prepare, commit and forget which we will look at in more detail.

It is now feasible to store a database in a computer’s memory—in-memory databases which will be discussed in Chap. 8. This gives the advantages of very fast processing not limited by the input/output speed restrictions of disk drives. Disk backup is still required for backup and recovery operations. 14 Big Data Whenever you use a loyalty card, for example a Nectar card in Britain or a Wal-Mart card in the USA to gain points which can be used to purchase goods and services you also ‘give’ the card owner a lot of information about your buying habits.

Download PDF sample

Rated 4.47 of 5 – based on 4 votes