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

By Paul Crowther, Peter Lake

Smooth companies depend upon information for his or her very survival, making a desire for stylish databases and database applied sciences to assist shop, organise and delivery their necessary data.

This easy-to-read textbook/reference provides a accomplished advent to databases, establishing with a concise historical past of databases and of knowledge as an organisational asset. As relational database administration platforms aren't any longer the one database resolution, the publication takes a much wider view of database expertise, encompassing monstrous info, NoSQL, item and object-relational, and in-memory databases. The textual content additionally examines the problems of scalability, availability, functionality and protection encountered whilst construction and operating a database within the genuine world.

Topics and features:

* provides evaluate and dialogue questions on the finish of every bankruptcy, as well as skill-building, hands-on exercises
* Introduces the elemental thoughts and applied sciences in database structures, putting those in an ancient context
* Describes the demanding situations confronted via database professionals
* stories using a number of database forms in enterprise environments
* Discusses parts for extra examine inside of this fast-moving domain
* indicates a constitution for a possible college path within the preface

With its learning-by-doing process, supported via either theoretical and useful examples, this clearly-structured textbook should be of serious price to complicated undergraduate and postgraduate scholars of laptop technology, software program engineering, and data know-how. practicing database pros and alertness builders also will locate the e-book an excellent reference that addresses today's enterprise wishes.

Show description

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

Best databases books

Multimedia Information Retrieval: Content-Based Information Retrieval from Large Text and Audio Databases

Multimedia details Retrieval: Content-Based info Retrievalfrom huge textual content and Audio Databases addresses the long run desire for classy seek innovations that would be required to discover proper details in huge electronic information repositories, comparable to electronic libraries and different multimedia databases.

Big Data Analytics. From Strategic Planning to Enterprise Integration with Tools, Techniques, No: SQL, and Graph

Mammoth info Analytics will support managers in supplying an summary of the drivers for introducing mammoth info expertise into the association and for realizing the categories of commercial difficulties most fitted to important facts analytics strategies, figuring out the price drivers and advantages, strategic making plans, constructing a pilot, and at last making plans to combine again into creation in the company.

Microsoft Access 2010 Step by Step

Event studying made easy-and fast educate your self the right way to construct database options with entry 2010. With step-by-step, you put the pace-building and working towards the talents you would like, simply if you want them! themes contain construction an entry database from scratch or from templates; publishing your database to the internet; replacing information with different databases and Microsoft workplace files; developing data-entry varieties; utilizing filters and queries; designing studies; utilizing conditional formatting; fighting information corruption and unauthorized entry; and different middle subject matters.

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

Example text

Chap. 3 Brandeis W, Samuel Warren S (1890) The right to privacy. Harvard Law Rev 4(5). html, last accessed 12/06/2013 Lawson P (1993) The East India Company: a history. Longman, London London Stock Exchange (2013) Our history. htm, last accessed 22/06/2013 McKinsey and Company (2011) Big data: the next frontier for innovation, competition, and productivity. com/insights/business_technology/big_data_the_next_frontier_ for_innovation, last accessed 22/06/2013 National Archives (2013) Dissolution of the monasteries 1536–1540.

Since only one program could be loaded and run at a time with these systems demand for computer time grew rapidly. As well as data processing time was needed to develop, compile and test new computer programmes. Ultimately many computer systems were being scheduled for up to 24 hours a day, 7 days a week. There were also very strict rules on tape storage so if a master tape were corrupted it could be recreated by using archived old masters and the transaction tapes. If there were any issues with one of the transactions, it would not be processed, but would be copied to an exception file on another tape.

12 Data Warehouse 31 Fig. 6 Star schema A data warehouse is a central repository of data in an organisation storing historical data and being constantly added to by current transactions. The data can be analysed to produce trend reports. It can also be analysed using data mining techniques for generating strategic information. Unlike data in a relational database, data in a data warehouse is organised in a de-normalised format. There are three main formats: • Star schema: tables are either fact tables which record data about specific events such as a sales transaction and dimension tables which information relating to the attributes in the fact table (Fig.

Download PDF sample

Rated 4.09 of 5 – based on 11 votes