Topic 02 : Database & DBMS

100 %
0 %
Information about Topic 02 : Database & DBMS

Published on November 26, 2013

Author: PradipKharbuja


TOPIC 2 : DATABASES & DBMS Er. Pradip Kharbuja

Metadata  Metadata is data about data.  It is the way in which the database keeps information about its own structure.  Metadata is stored in the data dictionary.

Metadata Name Student Name Type Character Length 50 Student ID Number 8 Date of Birth Date 8 Description Student’s name Unique identification number for a student Student’s date of birth in the format ’01.01.80’

Metadata in MS Access

Metadata in Oracle SQL SQL> DESC emp Name Null? ------------------------------- -------EMPNO NOT NULL ENAME JOB MGR HIREDATE SAL COMM DEPTNO SQL> Type ---NUMBER(4) VARCHAR2(10) VARCHAR2(9) NUMBER(4) DATE NUMBER(7,2) NUMBER(7,2) NUMBER(2)

Metadata in SQL Server

Metadata Column Name Datatypes 1. 2. 3. 4. 5. VARCHAR TEXT INTEGER DECIMAL DATE Type Length NULL

Activity  Define metadata for data about the following: Students in a college database College Examination Books in a library system Holidays booked by a person at a workplace Shopping Mart  Try to think about what data needs to be kept - will it be a character, date or number?

Two-File Processing System Customer File User Customer Processing System Customer File Rental File User Rental Processing System Rental File

Two-File Processing System  The example used is of a car rental system.  One system processes CUSTOMER data, and the other processes RENTAL data.  Each of the files and the applications that use them are totally separate.  Although this is an improvement over older manual systems, there are a number of problems.

Problems in Two-File Processing System 1. Data are separated and isolated. 2. Data are often duplicated. 3. Problem of Data integrity 4. Application programs are dependent on file formats. 5. Files are often incompatible with one another. 6. It is difficult to represent data in a user’s perspective.

Basic Structure of a Database User Customer Processing Application User Rental Processing Application DBMS User Other Application Database

Database System in Detail User Customer Processing Application DBMS serves as intermediary between user and the database by translating user requests into the complex code required to fulfill those requests. Application Requests Data User Rental Processing Application METADATA Application Requests DATA Data Application Requests DBMS User Other Application Data Database Management System Application programs might be written in a programming Language, such as Visual Basic or C++, or it might be created through a DBMS utility e.g. Access’s forms wizard. Database

Features of the Database Approach 1. Integrated data 2. Reduced data duplication 3. Program/data independence 4. Easier representation of users’ perspectives 5. Database systems are self-describing

Common Applications 1. Forms 2. Reports 3. Web-applications 4. Batch processes

DBMS – Architecture • The DBMS is the software that handles all the interactions between applications and the database. • Paul Benyon-Davis provides a useful way of looking at the structure of the DBMS itself i.e. DBMS Architecture. • 3 layers 1. Kernel 2. Toolkit 3. Interface

Kernel, Interface and Toolkit DBMS Toolkit Interface DBMS Kernel Database

Kernel, Interface and Toolkit 1. Kernel  Central engine, which operates most of the core data management functions 2. Toolkit  The tools and applications that interact with the end-users.  These might be provided as part of the DBMS product or as separate piece of software. 3. Interface  It handles the interaction between the toolkit and the kernel

DBMS Functions 1. CRUD functions 2. Data dictionary 3. Transaction management 4. Concurrency control 5. Recovery 6. Authorization 7. Data integrity 8. Administration utilities

Advantages of DBMS  Control of data redundancy  Improved data integrity or Data consistency  Sharing of data  Improved security  Enforcement of standards  Improved data accessibility and responsiveness  Improved maintenance  Increased concurrency  Improved backup and recovery services

Disadvantages of DBMS  Complexity  Size  Cost of DBMSs  Additional hardware costs  Cost of conversion  Performance

Data Models  Hierarchical  Network  Relational  Object-oriented  Deductive  Post-relational


Add a comment

Related presentations

Related pages

DBMS_STATS - Oracle Help Center

140 DBMS_STATS. With the DBMS_STATS package you can view and modify optimizer statistics gathered for database objects.
Read more

One database to rule them all? | DBMS 2 : DataBase ...

One database to rule them all? Perhaps the single toughest question in all database technology is: Which different purposes can a single data store serve ...
Read more

Database Directory

CHOOSE A TOPIC. Business ... Database Directory. Submit Content ... DBMS. DB2 (79) Informix (8) Open Source DBMS (32) Oracle (15) Sybase (8) Development.
Read more

Ask Tom "how to use dbms_stats.gather_databse_stats"

... 3 begin 4 dbms_stats.gather_database_stats ... i cover this topic in chapter 6 with ... at "SYS.DBMS_STATS", line 7788 December 02, 2005 ...
Read more

Execute permission should be revoked from PUBLIC for ...

DBMS_LOB: allows users access to files stored outside the database. DBMS_SQL: ... Oracle Database 11g Instance STIG: 2014-04-02: Details. Check Text ...
Read more

database management system (DBMS) | computing |

Database management system (DBMS), System for quick search and retrieval of information from a database. The DBMS determines how data are stored and retrieved.
Read more

Research Topics - Computer Science and Computer ...

Research Topics - [Natural ... DBMS, middleware and several other areas ... Research Topic #5: Other TBD. Database Area.
Read more


Oracle 10gR2 Recovery Catalog database Oracle 10gR2 ... connected to recovery catalog database PL/SQL package RMAN.DBMS_RCVCAT version in ...
Read more