Sign Up | Sign In
Ask Questions & Get Answers at ibibo sawaal
Home Seperator Ask Question Seperator Answer Questions Seperator My Q&A Seperator Categories

What is a Database system?  

Asked in Computers & Accessories at 6:47 PM on November 12, 2008

Tags: database system

Report abuse
sudhir arora
sudhir arora

A collection of programs that enables you to store, modify, and extract information from a database. There are many different types of DBMSs, ranging from small systems that run on personal computers to huge systems that run on mainframes. The following are examples of database applications:
# computerized library systems

* automated teller machines

# flight reservation systems

* computerized parts inventory systems

From a technical standpoint, DBMSs can differ widely. The terms relational, network, flat, and hierarchical all refer to the way a DBMS organizes information internally. The internal organization can affect how quickly and flexibly you can extract information.

Requests for information from a database are made in the form of a query, which is a stylized question. For example, the query

SELECT ALL WHERE NAME = "SMITH" AND AGE > 35

requests all records in which the NAME field is SMITH and the AGE field is greater than 35. The set of rules for constructing queries is known as a query language. Different DBMSs support different query languages, although there is a semi-standardized query language called SQL (structured query language). Sophisticated languages for managing database systems are called fourth-generation languages, or 4GLs for short.

The information from a database can be presented in a variety of formats. Most DBMSs include a report writer program that enables you to output data in the form of a report. Many DBMSs also include a graphics component that enables you to output information in the form of graphs and charts.

Answered by Point at 8:31 AM on November 13, 2008

Report Abuse |  Rate this : 00
Point
Point

A database management system (DBMS) is a computer software designed for the purpose of managing databases. DBMSes may use any of a variety of data models, such as the network model or relational model. The role of a DBMS in a larger system is to allow other software, or users, to store and retrieve data in a structured way.

A "Database Management System" is a software that defines a database, stores the data, supports a query language, produces reports, and create data entry screens.

A DBMS is a complex set of software programs that controls the organization, storage, management, and retrieval of data in a database. DBMS are categorized according to their data structures or types. It is a set of prewritten programs that are used to store, update and retrieve a Database. The DBMS accepts requests for data from the application program and instructs the operating system to transfer the appropriate data. When a DBMS is used, information systems can be changed much more easily as the organization's information requirements change. New categories of data can be added to the database without disruption to the existing system.

Organizations may use one kind of DBMS for daily transaction processing and then move the detail onto another computer that uses another DBMS better suited for random inquiries and analysis. Overall systems design decisions are performed by data administrators and systems analysts. Detailed database design is performed by database administrators.

Database servers are specially designed computers that hold the actual databases and run only the DBMS and related software. Database servers are usually multiprocessor computers, with RAID disk arrays used for stable storage. Connected to one or more servers via a high-speed channel, hardware database accelerators are also used in large volume transaction processing environments. DBMSs are found at the heart of most database applications. Sometimes DBMSs are built around a private multitasking kernel with built-in networking support although nowadays these functions are left to the operating system.

Answered by Nagendra at 7:02 PM on November 12, 2008

Report Abuse |  Rate this : 00
Nagendra
Nagendra

The database and DBMS software together is called as Database system.

Answered by M P at 6:49 PM on November 12, 2008

Report Abuse |  Rate this : 00
M P
M P

Related Search

 

define the cods rule?

Hi,The Codds 12 rules are a set of thirteen rules that tell what is required from a database management system in order for it to be considered relational, i.e., an RDBMS :Rule 0: The system must qualify as relational, as a database, and as a management system.For a system to qualify as a relational database management system RDBMS, that system must use its relational facilities exclusively

Posted in Computers & Technology by blogger01 at 12:53 PM on May 23, 2008
Tags define, rule

what is RDBMS?

well, RDBMS stands for Relational Database Management System.RDBMS store the data into collection of tables, which might be related by common fields database table columns. RDBMS also provide it will be extracted from the database.An important feature of relational systems is that a single database can be spread across several tables. This differs from flat-file databases, in which each database is self

Posted in Computers & Technology by blogger01 at 12:53 PM on May 23, 2008
Tags rdbms

define the cods rule?

Rule 0: The system must qualify as relational, as a database, and as a management system.For a system to qualify as a relational database management system RDBMS, that system must use its relational system in order for it to be considered relational, i.e., an RDBMSThe rulesRule 0: The system must qualify as relational, as a database, and as a management system. For a system to qualify as a relational

Posted in Computers & Technology by Sharad Singh at 9:14 PM on May 15, 2008
Tags define, rule

what is Java JDBC?

Database Connectivity ODBC. Many legacy C and Perl programs use ODBC to connect to data sources. ODBC consolidated much of the commonality between database management systems. JDBC builds on this feature legacy C and Perl programs use ODBC to connect to data sources. ODBC consolidated much of the commonality between database management systems. JDBC builds on this feature, and increases the level

Posted in Computers & Technology by Fazil at 3:49 PM on June 22, 2008
Tags java jdbc

Which is better career option? .net or java or dba?

database is a collection of information thats related to a particular function or purpose. In its simplest form, your contact information kept in a file on your system is a database. We will not dwell much issues, i.e. problems, requirements, etc.Performance Monitoring and TuningA DBA must make sure databases are fast and responsive. A slow response database is usually indicative of poor system performance

Posted in Computers & Technology by Aryan Gusain at 2:11 PM on June 19, 2008
Tags career, option, java, dba

what is RDBMS?

A relational database management system RDBMS is a database management system DBMS that is based on the relational model as introduced by E. F. Codd. Relational databases are the most common kind of database in use today assuming one does not count a file system as a database. [citation needed...]A short definition of a RDBMS may be a DBMS in which data is stored in the form of tables

Posted in Computers & Technology by Sharad Singh at 9:15 PM on May 15, 2008
Tags rdbms

what is SQL

and management of data in relational database management systems RDBMS, database schema creation and modification, and database object access control management.[1...][2...]SQL is a standard interactive. This version, initially called SEQUEL, was designed to manipulate and retrieve data stored in IBMs original relational database product, System R. The SQL language was later formally standardized by the American

Posted in Computers & Technology by shashi verma at 9:30 PM on May 03, 2008
Tags sql

what is the difference amongSQL,SQL PlUS,ORACLE nd PLSQL?

in the early 1970s. This version, initially called SEQUEL, was designed to manipulate and retrieve data stored in IBMs original relational database product, System R. The SQL language was later formally management systems RDBMS, database schema creation and modification, and database object access control management.[1...][2...]SQL is a standard interactive and programming language for querying and modifying

Posted in Computers & Technology by tanu priya at 7:34 PM on July 05, 2008
Tags difference

What is DBMS ?

A database management system DBMS is computer software designed for the purpose of managing databases based on a variety of data models.A DBMS is a complex set of software programs that controls are left to the operating system....A DBMS can be defined as-A database management system DBMS, sometimes just called a database manager, is a program that lets one or more computer users create and access

Posted in Computers & Technology by Arjun at 12:07 AM on October 02, 2008
Tags dbms

WHT IS SYSTEM SOFTWARE?

System software is a Programs that used to control the computer and develop and run application programs. It includes operating systems, TP monitors, network operating systems and database managers, database manager and interpreter are considered system software. The applications and interactive DBMS query and edit would be considered application software....well, System software is a Programs that used

Posted in Computers & Technology by saurabh at 4:47 AM on October 03, 2008
Tags system software

Which book would i prefer for OS and DBMS?

well, "Fundamentals of Database system" by ELMASRI, NAVATHE, SOMAYAJULU, GUPTHA.Database Management Systems Hardcover by Raghu Ramakrishnan Author, Johannes Gehrke AuthorJava Database..."Fundamentals of Database system" by ELMASRI, NAVATHE, SOMAYAJULU, GUPTHA.Database Management Systems Hardcover by Raghu Ramakrishnan Author, Johannes Gehrke AuthorJava Database Programming with JDBC; Coriolis Group

Posted in Computers & Technology by Naina Naina at 6:01 PM on July 04, 2008
Tags book name

What is database administrator ?

or performs all activities related to maintaining a successful database environment. Responsibilities include designing, implementing, and maintaining the database system; establishing policies and procedures pertaining to the management, security, maintenance, and use of the database management system; and training employees in database management and use. A DBA is expected to stay abreast of emerging technologies

Posted in Computers & Technology by Priya Raman at 10:32 PM on September 06, 2008
Tags database, administrator
More such questions »

Similar Questions

More such questions »
Left Ads
© 2006 - 2013 ibibo Web Pvt Ltd. All rights reserved.