Fundamentals of Relational Database Management Systems (Studies in Computational Intelligence)

Fundamentals of Relational Database Management Systems (Studies in Computational Intelligence), 9783540483977 (3540483977), Springer, 2007

Information is a valuable resource to an organization. Computer software provides an efficient means of processing information, and database systems are becoming increasingly common means by which it is possible to store and retrieve information in an effective manner. This book provides comprehensive coverage of fundamentals of database management system. This book is for those who wish a better understanding of relational data modeling, its purpose, its nature, and the standards used in creating relational data model. Relational databases are the most popular database management systems in the world and are supported by a variety of vendor implementations.

Majority of the practical tasks in industry require applying relatively not complex algorithms to huge amounts of well-structured data. The efficiency of the application depends on the quality of data organization. Advances in database technology and processing offer opportunities for using information flexibility and efficiently when data is organized and stored in relational structures. The relational DBMS is a success in the commercial market place with respect to business data processing and related applications. This success is a result of cost effective application development combined with high data consistency. The success has led to the use of relational DBMS technology in other application environments requesting its traditional virtues, while at the same time adding new requirements.

SQL is the standard computer language used to communicate with relational database management systems. Chapter 4 gives an introduction to SQL with illustrative examples. The limitations of SQL and how to overcome that limitations using PL/SQL are discussed in Chap. 5.

The current trends in hardware like RAID technology made relational DBMSs to support high transmission rates, very high availability, and a soft real-time transaction a cost effective possibility. The basics of RAID technology, different levels of RAID are discussed in this book.

Comments

Amazing Books

CCSP SNPA Official Exam Certification Guide (3rd Edition)

Cisco Press, 2006

CCSP SNPA Exam Certification Guide, Third Edition, is an excellent self-study resource for
the CCSP SNPA exam. Passing the exam validates the knowledge and ability to configure,
operate, and manage Cisco PIX 500 Series Security Appliances and Cisco ASA 5500 Series
Adaptive Security Appliances. It is one of several exams required to...

Mastering Apache Spark

Packt Publishing, 2015

Gain expertise in processing and storing data by using advanced techniques with Apache Spark

About This Book

Explore the integration of Apache Spark with third party applications such as H20, Databricks and Titan

Evaluate how Cassandra and Hbase can be used for storage

An...

Captain Bligh's Portable Nightmare: From the Bounty to Safety?4,162 Miles across the Pacific in a Rowing Boat

Skyhorse Publishing, 2019

At dawn on April 28, 1789, Captain William Bligh and eighteen men from HMS Bounty were herded onto a twenty-three-foot launch and abandoned in the middle of the Pacific Ocean. Thus began their extraordinary journey to Java. Covering 4,162 miles, the small boat was battered by continuous storms, and the men on board suffered crippling...

C++ GUI Programming with Qt 3 (Bruce Peren's Open Source)

Prentice Hall, 2004

The first official Trolltech guide to Qt 3.2 programming!

Straight from Trolltech, this book covers all you need to build industrial-strength applications with Qt 3.2.x and C++--applications that run natively on Windows, Linux/Unix, Mac OS X, and embedded Linux with no source code changes! The book teaches solid Qt programming practices; it is...

R for SAS and SPSS Users (Statistics and Computing)

Springer, 2011

While SAS and SPSS have many things in common, R is very different. My goal in writing this book is to help you translate what you know about SAS or SPSS into a working knowledge of R as quickly and easily as possible. I point out how they differ using terminology with which you are familiar, and show you which add-on packages will...

Business Creativity: Breaking the Invisible Barriers

Palgrave Macmillan, 2005

Many companies and organizations have found it difficult to develop creative skills. The authors argue that while individuals have inherent creativity there are a number of assassins or barriers that block individual creative development. This bold new approach to creativity enhancement will focus upon how to remove barriers and create...