Database Development and Management (Foundations of Database by Lee Chao

By Lee Chao

state-of-the-art database pros needs to know the way to use database structures to enterprise methods and the way to advance database platforms for either company intelligence and Web-based applications.

Database improvement and administration explains all points of database layout, entry, implementation, program improvement, and administration, in addition to info research for enterprise intelligence. This self-contained textual content provides scholars hands-on initiatives required for professionally constructing and coping with databases. It offers precise guide through an easy-to-follow, step by step case-based strategy.

Following an advent to database parts, the publication makes use of case reviews to demonstrate the modeling technique, covers desk constructions and normalization, and analyzes the transformation of an information version to a relational database. It explains using SQL in handling database items and in querying databases, then discusses Transact-SQL and the perspectives, indexes, and cursors that bridge databases and their applications.

The booklet examines 3 significant data-accessing thoughts, after which exhibits tips on how to advance refined purposes established upon the cloth incorporated in prior chapters. It explores using databases in community environments, and information the a number of initiatives dealt with through database directors (DBAs).

The textual content additionally discusses the web Analytical Processing (OLAP) process, facts warehousing, and different research instruments that aid company intelligence and determination making. It concludes with a assessment of knowledge mining.

Show description

Read or Download Database Development and Management (Foundations of Database Design) PDF

Similar storage & retrieval books

Information Retrieval Architecture and Algorithms

This article offers a theoretical and sensible exam of the newest advancements in info Retrieval and their program to current structures. by means of beginning with a useful dialogue of what's wanted for a knowledge process, the reader can take hold of the scope of data retrieval difficulties and realize the instruments to unravel them.

Recommender Systems (Iste)

Acclaimed through quite a few content material structures (books, song, video clips) and public sale websites on-line, advice platforms are key parts of electronic recommendations. If improvement used to be initially meant for the functionality of data platforms, the problems at the moment are hugely moved on logical optimization of the buyer dating, with the most aim to maximise power revenues.

Oracle Database Upgrade, Migration & Transformation Tips & Techniques (Database & ERP - OMG)

A pragmatic roadmap for database improve, migration, and transformation This Oracle Press consultant offers top practices for migrating among diverse working platforms and systems, remodeling present databases to take advantage of diversified garage or company platforms, and upgrading databases from one free up to the following.

Social Informatics: 9th International Conference, SocInfo 2017, Oxford, UK, September 13-15, 2017, Proceedings, Part I (Lecture Notes in Computer Science)

The two-volume set LNCS 10539 and 10540 constitutes the court cases of the ninth foreign convention on Social Informatics, SocInfo 2017, held in  Oxford, united kingdom, in September 2017. The 37 complete papers and forty three poster papers offered during this quantity have been conscientiously reviewed and chosen from 142 submissions.

Additional info for Database Development and Management (Foundations of Database Design)

Sample text

Download PDF sample

Rated 4.10 of 5 – based on 28 votes