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

CHAPTER27

MySQL

27.1 INTRODUCTION

MySQL is an Open Source SQL database management system developed by MySQL AB Sweden, founded by David Axmark, Allan Larsson and Michael “Monty” Widenius. MySQL is developed, distributed and supported by MySQL AB. MySQL AB is a commercial company, founded by the MySQL developers. It is a second generation Open Source company that unites Open Source values and methodology with a successful business model.

MySQL Server was originally developed to handle large databases much faster than existing solutions and has been successfully used in highly demanding production environments for several years. Although under constant development, MySQL Server today offers a rich and useful set of functions. Its connectivity, ...