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

This easy-to-read textbook/reference provides a complete advent to databases, starting with a concise background of databases and of information as an organisational asset. As relational database administration structures are not any longer the single database answer, the ebook takes a much broader view of database expertise, encompassing massive 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 development and operating a database within the actual global. themes and lines: offers assessment and dialogue questions on the finish of every bankruptcy, as well as skill-building, hands-on routines; introduces the basic ideas and applied sciences in database structures, putting those in an ancient context; describes the demanding situations confronted through database pros; studies using numerous database varieties in company environments; discusses components for additional learn 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

PIC Robotics: A Beginner's Guide to Robotics Projects Using the PIC Micro

Here is every thing the robotics hobbyist must harness the ability of the PICMicro MCU! during this heavily-illustrated source, writer John Iovine offers plans and entire components lists for eleven easy-to-build robots each one with a PICMicro "brain. ” The expertly written insurance of the PIC simple desktop makes programming a snap -- and many enjoyable.

Measuring the User Experience: Collecting, Analyzing, and Presenting Usability Metrics (Interactive Technologies)

Successfully measuring the usability of any product calls for selecting the best metric, utilizing it, and successfully utilizing the knowledge it finds. Measuring the consumer adventure presents the 1st unmarried resource of useful details to allow usability pros and product builders to do exactly that.

Information Retrieval: Data Structures and Algorithms

Details retrieval is a sub-field of machine technology that bargains with the computerized garage and retrieval of files. offering the newest info retrieval innovations, this advisor discusses info Retrieval information buildings and algorithms, together with implementations in C. aimed toward software program engineers development platforms with ebook processing parts, it presents a descriptive and evaluative clarification of garage and retrieval structures, dossier buildings, time period and question operations, record operations and undefined.

The Art of Computer Programming, Volume 4A: Combinatorial Algorithms, Part 1

The paintings of desktop Programming, quantity 4A:  Combinatorial Algorithms, half 1   Knuth’s multivolume research of algorithms is widely known because the definitive description of classical desktop technological know-how. the 1st 3 volumes of this paintings have lengthy comprised a special and helpful source in programming idea and perform.

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

Show sample text content

Frequently a relational database is obvious by way of item orientated programmers as a unmarried continual item on which a few operations should be played. although there are a growing number of the explanation why this can be turning into a slender view. one of many first matters confronting databases is the increase of non-character (alphanumeric) info. more and more pictures, sound records, maps and video must be kept, manipulated and retrieved. Even conventional info is being checked out in alternative ways than by means of conventional desk joins. item orientated buildings similar to hierarchies, aggregation and tips are being brought. This has ended in a couple of strategies, but in addition to fragmentation of criteria. From the mid 1980’s a couple of item orientated database administration platforms (OODBMS) have been built yet by no means received traction within the wider company setting. They did turn into renowned in area of interest markets reminiscent of the geographic and engineering sectors the place there has been a necessity for graphical facts to be saved and manipulated. one of many great concerns with item orientated databases is, as pointed out making a commonplace. This used to be tried via the article info administration team (ODMG) which released 5 revisions to its usual. This team was once wound up in 2001. The functionality of ODMG has, been taken over by way of the thing administration workforce (OMG). even though there's speak of improvement of a 4th iteration usual for item databases, this has now not but occurred a topic with constructing item orientated platforms used to be lot of workmanship and platforms were constructed round relational databases and SQL had turn into, for greater or worse, the common question language. the second one method of item orientation for that reason was once to increase relational databases to include item orientated gains. those are referred to as item relational databases. they're manipulated by way of SQL instructions which were prolonged to house item constructions. Chapter 7 will glance intimately at either item and item Relational Databases. 2. 12 info Warehouse A problem with an operational database is that particular files inside it are always being up to date, for this reason it really is tricky to do an research in line with ancient information until you actively shop it. the concept that in the back of a knowledge warehouse is that it might shop info generated by means of assorted platforms within the company, not only transactions shape the database. this information can then be analysed and the result of the research used to make judgements and tell the strategic path of an business enterprise. info warehouses have already been pointed out in Chap. 1 the place they have been mentioned of their position of an organisational asset. the following we glance in short at a few of their technical information. A data warehouse is a crucial repository of knowledge in an enterprise storing old facts and being regularly extra to via present transactions. the information should be analysed to supply development reviews. it could even be analysed utilizing facts mining suggestions for producing strategic details. not like information in a relational database, info in an information warehouse is organised in a de-normalised structure.

Download PDF sample

Rated 4.81 of 5 – based on 33 votes