Explain the components of database system in details., Database Management System

Assignment Help:

Explain the components of Database System in details.

Related Discussions:- Explain the components of database system in details.

Multiple column queries-syntax, Multiple column Queries: Syntax: ...

Multiple column Queries: Syntax: SELECT COLUMN1, COL2,...... FROM TABLE WHERE (COLUMN1, COL2, ...) IN (SELECT COLUMN1, COL2,.... FROM TABLE WHERE );

Concatenation operator-data manipulation language, Concatenation operator ...

Concatenation operator Example : Printing name and job as one string as column name employees: SELECT ENAME||JOB "EMPLOYEES" FROM EMP;

What is document scanning and imaging, What is document scanning and imagin...

What is document scanning and imaging? Document scanning and imaging, or digital archiving, is the method of scanning a document into a digital image to archive and retrieve a

Functional dependencies and normalization for relational dat, Consider the ...

Consider the 1ollowin8 relation: CAR SALE (Car_id, Option_type, Option_listprice, Sale_date, Option_discountedprice) This relation refers to options installed in cars (e.g., crui

Explain pipelining, Explain pipelining. Ans: In order to describ...

Explain pipelining. Ans: In order to describe pipelining in simple terms, think of it as breaking down processor functions into smaller and smaller parts. For instance,

Find out employee who draws salary more than average , Normal 0 ...

Normal 0 false false false EN-US X-NONE X-NONE

View of data, how to submit answers softcopy

how to submit answers softcopy

Marketing interface, as a customer service employee explain five measures y...

as a customer service employee explain five measures you would recommend to make even a displeased students patronize the school canteen

List the sql domain types, List the SQL domain Types? SQL supports the ...

List the SQL domain Types? SQL supports the following domain types. 1) Char(n) 2) varchar(n) 3) int 4) numeric(p,d) 5) float(n) 6) date.

Shared lock or read lock, Shared lock or Read Lock It is requested ...

Shared lock or Read Lock It is requested by a transaction that needs to just read the value of data item. A shared lock on a data item does not permit an exclusive lock

12/5/2013 4:25:50 AM A complete database system in an organization contains four *components*. a() Hardware: The hardware is a set of physical devices on which a database resides. It consists of one or additional computers, disk drives, CRT terminals, printers, tape drivers, connecting cables and so on. The computers used for processing the data in database may be mainframe, mini computers and personal computers. Mainframe and mini computers have usually been used on a stand-alone basis to support multiple users accessing a ordinary database. Personal computers are regularly used with stand-alone databases controlled and accessed by single user. Disk drivers are the key storage mechanism for databases. Desktop computers, CRT terminals and printers are used for entering and retrieving information from database. The success of database system has been a lot dependent on advances in hardware technology. A very large quantity of main memory and disk storage is necessary to keep and control a huge quantity of data stored in database. b() Software: A database system includes two kinds of software: 1()General Purpose database management software typically known as database management system (DBMS). 2()Application software that uses DBMS facilities to control the database to attain a specific business functions. Application software is normally written by programmers to solve specific company problem. It may be written in languages like COBOL or C or it may be written in a language supplied by DBMS like SQL. Application software utilizes the facilities of DBMS to way in and manipulate data in the database providing reports or documents needed for the information and processing needs of the company. The DBMS is system software alike to an operating system. It provides a lot of services to end users and programmers. DBMS usually provides most of the following services. a.1.) a central data definition and data control facility known as a data dictionary/directory or catalogue. b.2.) Data security and integrity mechanisms. c.3.) Concurrent data access for multiple users. d.4.) User-oriented data query, manipulation and reporting capabilities. e.5.) Programmer-oriented application system development capabilities.

12/5/2013 4:25:50 AM

A complete database system in an organization contains four components.

a() Hardware: The hardware is a set of physical devices on which a database resides. It consists of one or additional computers, disk drives, CRT terminals, printers, tape drivers, connecting cables and so on.

The computers used for processing the data in database may be mainframe, mini computers and personal computers. Mainframe and mini computers have usually been used on a stand-alone basis to support multiple users accessing a ordinary database. Personal computers are regularly used with stand-alone databases controlled and accessed by single user.
Disk drivers are the key storage mechanism for databases. Desktop computers, CRT terminals and printers are used for entering and retrieving information from database.

The success of database system has been a lot dependent on advances in hardware technology. A very large quantity of main memory and disk storage is necessary to keep and control a huge quantity of data stored in database.

b() Software: A database system includes two kinds of software:

1()General Purpose database management software typically known as database management system (DBMS).

2()Application software that uses DBMS facilities to control the database to attain a specific business functions.

Application software is normally written by programmers to solve specific company problem. It may be written in languages like COBOL or C or it may be written in a language supplied by DBMS like SQL. Application software utilizes the facilities of DBMS to way in and manipulate data in the database providing reports or documents needed for the information and processing needs of the company.

The DBMS is system software alike to an operating system. It provides a lot of services to end users and programmers.

DBMS usually provides most of the following services.

a.1.) a central data definition and data control facility known as a data dictionary/directory or catalogue.
b.2.) Data security and integrity mechanisms.
c.3.) Concurrent data access for multiple users.
d.4.) User-oriented data query, manipulation and reporting capabilities.
e.5.) Programmer-oriented application system development capabilities.

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages