book

Database Systems: Concepts, Design and Applications, 2nd Edition

by Shio Kumar Singh

August 2011

Intermediate to advanced

944 pages

27h 31m

English

Pearson India

Read now

Unlock full access

ACKNOWLEDGEMENTS
ACKNOWLEDGEMENTS

1.1 INTRODUCTION1.2 BASIC CONCEPTS AND DEFINITIONS1.3 DATA DICTIONARY1.4 DATABASE1.5 DATABASE SYSTEM1.6 DATA ADMINISTRATOR (DA)1.7 DATABASE ADMINISTRATOR (DBA)1.8 FILE-ORIENTED SYSTEM VERSUS DATABASE SYSTEM1.9 HISTORICAL PERSPECTIVE OF DATABASE SYSTEMS1.10 DATABASE LANGUAGE1.11 TRANSACTION MANAGEMENTREVIEW QUESTIONSSTATE TRUE/FALSETICK (√) THE APPROPRIATE ANSWERFILL IN THE BLANKS
2.1 INTRODUCTION2.2 SCHEMAS, SUBSCHEMA AND INSTANCES2.3 THREE-LEVEL ANSI-SPARC DATA BASE ARCHITECTURE2.4 DATA INDEPENDENCE2.5 MAPPINGS2.6 STRUCTURE, COMPONENTS, AND FUNCTIONS OF DBMS2.7 DATA MODELS2.8 TYPES OF DATABASE SYSTEMSREVIEW QUESTIONSSTATE TRUE/FALSETICK (√) THE APPROPRIATE ANSWERFILL IN THE BLANKS
3.1 INTRODUCTION3.2 PHYSICAL STORAGE MEDIA3.3 RAID TECHNOLOGY3.4 BASIC CONCEPT OF FILES3.5 FILE ORGANISATION3.6 INDEXINGREVIEW QUESTIONSSTATE TRUE/FALSETICK (√) THE APPROPRIATE ANSWERFILL IN THE BLANKS
4.1 INTRODUCTION4.2 HISTORICAL PERSPECTIVE OF RELATIONAL MODEL4.3 STRUCTURE OF RELATIONAL DATABASE4.4 RELATIONAL ALGEBRA4.5 RELATIONAL CALCULUSREVIEW QUESTIONSSTATE TRUE/FALSETICK (√) THE APPROPRIATE ANSWERFILL IN THE BLANKS
5.1 INTRODUCTION5.2 CODD'S RULES5.3 INFORMATION SYSTEM BASED LANGUAGE (ISBL)5.4 QUERY LANGUAGE (QUEL)5.5 STRUCTURES QUERY LANGUAGE (SQL)5.6 EMBEDDED STRUCTURED QUERY LANGUAGE (SQL)5.7 QUERY-BY-EXAMPLE (QBE)REVIEW QUESTIONSSTATE TRUE/FALSETICK (√) THE APPROPRIATE ANSWERFILL IN THE BLANKS
6.1 INTRODUCTION6.2 BASIC E-R CONCEPTS6.3 CONVERSION OF E-R MODEL INTO RELATIONS6.4 PROBLEMS WITH E-R MODELS6.5 E-R DIAGRAM SYMBOLSREVIEW QUESTIONSSTATE TRUE/FALSETICK (√) THE APPROPRIATE ANSWERFILL IN THE BLANKS
7.1 INTRODUCTION7.2 SUPERCLASS AND SUBCLASS ENTITY TYPES7.3 SPECIALISATION AND GENERALISATION7.4 CATEGORISATION7.5 EXAMPLE OF EER DIAGRAMREVIEW QUESTIONSSTATE TRUE/FALSETICK (√) THE APPROPRIATE ANSWERFILL IN THE BLANKS
8.1 INTRODUCTION8.2 SOFTWARE DEVELOPMENT LIFE CYCLE (SDLC)8.3 DATABASE DEVELOPMENT LIFE CYCLE8.4 AUTOMATED DESIGN TOOLSREVIEW QUESTIONSSTATE TRUE/FALSETICK (√) THE APPROPRIATE ANSWERFILL IN THE BLANKS
9.1 INTRODUCTION9.2 FUNCTIONAL DEPENDENCY (FD)9.3 DECOMPOSITIONREVIEW QUESTIONSSTATE TRUE/FALSETICK (√) THE APPROPRIATE ANSWERFILL IN THE BLANKS
10.1 INTRODUCTION10.2 NORMALIZATION10.3 NORMAL FORMS10.4 BOYCE-CODD NORMAL FORM (BCNF)10.5 MULTI-VALUED DEPENDENCIES (MVD) AND FOURTH NORMAL FORM (4NF)10.6 JOIN DEPENDENCIES AND FIFTH NORMAL FORM (5NF)REVIEW QUESTIONSSTATE TRUE/FALSETICK (√) THE APPROPRIATE ANSWERFILL IN THE BLANKS
11.1 INTRODUCTION11.2 QUERY PROCESSING11.3 SYNTAX ANALYSER11.4 QUERY DECOMPOSITION11.5 QUERY OPTIMIZATION11.6 COST ESTIMATION IN QUERY OPTIMIZATION11.7 PIPELINING AND MATERIALIZATION11.8 STRUCTURE OF QUERY EVALUATION PLANSREVIEW QUESTIONSSTATE TRUE/FALSETICK (√) THE APPROPRIATE ANSWERFILL IN THE BLANKS
12.1 INTRODUCTION12.2 TRANSACTION CONCEPTS12.3 CONCURRENCY CONTROL12.4 LOCKING METHODS FOR CONCURRENCY CONTROL12.5 TIMESTAMP METHODS FOR CONCURRENCY CONTROL12.6 OPTIMISTIC METHODS FOR CONCURRENCY CONTROLREVIEW QUESTIONSSTATE TRUE/FALSETICK (√) THE APPROPRIATE ANSWERFILL IN THE BLANKS
13.1 INTRODUCTION13.2 DATABASE RECOVERY CONCEPTS13.3 TYPES OF DATABASE FAILURES13.4 TYPES OF DATABASE RECOVERY13.5 RECOVERY TECHNIQUES13.6 BUFFER MANAGEMENTREVIEW QUESTIONSSTATE TRUE/FALSETICK (√) THE APPROPRIATE ANSWERFILL IN THE BLANKS
14.1 INTRODUCTION14.2 GOALS OF DATABASE SECURITY14.3 DISCRETIONARY ACCESS CONTROL14.4 MANDATORY ACCESS CONTROL14.5 FIREWALLS14.6 STATISTICAL DATABASE SECURITY14.7 DATA ENCRYPTIONREVIEW QUESTIONSSTATE TRUE/FALSETICK (√) THE APPROPRIATE ANSWERFILL IN THE BLANKS
15.1 INTRODUCTION15.2 OBJECT-ORIENTED DATA MODEL (OODM)15.3 CONCEPT OF OBJECT-ORIENTED DATABASE (OODB)15.4 OBJECT-ORIENTED DBMS (OODBMS)15.5 OBJECT DATA MANAGEMENT GROUP (ODMG) AND OBJECT-ORIENTED LANGUAGESREVIEW QUESTIONSSTATE TRUE/FALSETICK (√) THE APPROPRIATE ANSWERFILL IN THE BLANKS
16.1 INTRODUCTION16.2 HISTORY OF OBJECT-RELATIONAL DBMS (ORDBMS)16.3 ORDBMS QUERY LANGUAGE (SQL3)16.4 ORDBMS DESIGNREVIEW QUESTIONSSTATE TRUE/FALSETICK (√) THE APPROPRIATE ANSWERFILL IN THE BLANKS
17.1 INTRODUCTION17.2 PARALLEL DATABASES17.3 ARCHITECTURE OF PARALLEL DATABASES17.4 KEY ELEMENTS OF PARALLEL DATABASE PROCESSING17.5 QUERY PARALLELISMREVIEW QUESTIONSSTATE TRUE/FALSETICK (√) THE APPROPRIATE ANSWERFILL IN THE BLANKS
18.1 INTRODUCTION18.2 DISTRIBUTED DATABASES18.3 ARCHITECTURE OF DISTRIBUTED DATABASES18.4 DISTRIBUTED DATABASE SYSTEM (DDBS) DESIGN18.5 DISTRIBUTED QUERY PROCESSING18.6 CONCURRENCY CONTROL IN DISTRIBUTED DATABASES18.7 RECOVERY CONTROL IN DISTRIBUTED DATABASESREVIEW QUESTIONSSTATE TRUE/FALSETICK (√) THE APPROPRIATE ANSWERFILL IN THE BLANKS
19.1 INTRODUCTION19.2 HISTORY OF DECISION SUPPORT SYSTEM (DSS)19.3 DEFINITION OF DECISION SUPPORT SYSTEM19.4 OPERATIONAL DATA VERSUS DSS DATAREVIEW QUESTIONSSTATE TRUE/FALSETICK (√) THE APPROPRIATE ANSWERFILL IN THE BLANKS
20.1 INTRODUCTION20.2 DATA WAREHOUSING20.3 DATA WAREHOUSE ARCHITECTURE20.4 DATA MININGREVIEW QUESTIONSSTATE TRUE/FALSETICK (√) THE APPROPRIATE ANSWERFILL IN THE BLANKS
21.1 INTRODUCTION21.2 INTERNET DATABSES21.3 DIGITAL LIBRARIES21.4 MULTIMEDIA DATABASES21.5 MOBILE DATABASES21.6 SPATIAL DATABASES21.7 CLUSTERING-BASED DISASTER-PROOF DATABASESREVIEW QUESTIONSSTATE TRUE/FALSETICK (√) THE APPROPRIATE ANSWERFILL IN THE BLANKS
22.1 INTRODUCTION22.2 DATABASE DESIGN FOR RETAIL BANKING22.3 DATABASE DESIGN FOR AN ANCILLARY MANUFACTURING SYSTEM22.4 DATABASE DESIGN FOR AN ANUAL RATE CONTRACT SYSTEM22.5 DATABASE DESIGN OF TECHNICAL TRAINING INSTITUTE22.6 DATABASE DESIGN OF AN INTERNET BOOKSHOP22.7 DATABASE DESIGN FOR CUSTOMER ORDER WAREHOUSEREVIEW QUESTIONS
23.1 INTRODUCTION23.2 DB2 PRODUCTS23.3 DB2 UNIVERSAL DATABASE (UDB)23.4 INSTALLATION PREREQUISITE FOR DB2 UNIVERSAL DATABASE SERVER23.5 INSTALLATION PREREQUSITE FOR DB2 CLIENTS23.6 INSTALLATION AND CONFIGURATION OF DB2 UNIVERSAL DATABASE SERVERREVIEW QUESTIONSSTATE TRUE/FALSETICK (√) THE APPROPRIATE ANSWERFILL IN THE BLANKS
24.1 INTRODUCTION24.2 HISTORY OF ORACLE24.3 ORACLE FEATURES24.4 SQL*PLUS24.5 ORACLE'S DATA DICTIONARY24.6 ORACLE SYSTEM ARCHITECTURE24.7 INSTALLATION OF ORACLE 9iREVIEW QUESTIONSSTATE TRUE/FALSETICK (√) THE APPROPRIATE ANSWERFILL IN THE BLANKS
25.1 INTRODUCTION25.2 MICROSOFT SQL SERVER SETUP25.3 STORED PROCEDURES IN SQL SERVER25.4 INSTALLING MICROSOFT SQL SERVER 200025.5 DATABASE OPERATION WITH MICROSOFT SQL SERVERREVIEW QUESTIONSSTATE TRUE/FALSETICK (√) THE APPROPRIATE ANSWERFILL IN THE BLANKS
26.1 INTRODUCTION26.2 AN ACCESS DATABASE26.3 DATABASE OPERATION IN MICROSOFT ACCESS26.4 FEATURES OF MICROSOFT ACCESSREVIEW QUESTIONSSTATE TRUE/FALSETICK (√) THE APPROPRIATE ANSWERFILL IN THE BLANKS
27.1 INTRODUCTION27.2 AN OVERVIEW OF MySQL27.3 PHP–AN INTRODUCTION27.4 MYSQL DATABASE27.5 INSTALLING MySQL ON WINDOWSREVIEW QUESTIONSSTATE TRUE/FALSETICK (√) THE APPROPRIATE ANSWERFILL IN THE BLANKS
28.1 Introduction28.2 TERADATA TECHNOLOGY28.3 TERADATA TOOLS AND UTILITIES28.4 TERADATA RDBMS28.5 TERADATA CLIENT SOFTWARE28.6 INSTALLATION AND CONFIGURATION OF TERADATA28.7 INSTALLATION OF TERADATA TOOLS AND UTILITIES SOFTWARE28.8 BASIC TERADATA QUERY (BTEQ)28.9 OPEN DATABASE CONNECTIVITY (ODBC) APPLICATION DEVELOPMENTREVIEW QUESTIONSSTATE TRUE/FALSETICK (√) THE APPROPRIATE ANSWERFILL IN THE BLANKS

Content preview from Database Systems: Concepts, Design and Applications, 2nd Edition

CHAPTER17

Parallel Database Systems

17.1 INTRODUCTION

The architecture of a database system is greatly influenced by the underlying computer system on which the database system runs. Database systems can be centraled, parallel or distributed. In the preceding chapters, we introduced concepts of centralised database management systems (for example, hierarchical, networking, relational, object-oriented and object-relational) that are based on the single central processing unit (CPU) or computer architecture. In this architecture, all the data is maintained at a single site (or computer system) and assumed that the processing of individual transactions is essentially by sequential. But today, a single CPU based computer architecture is not capable ...