DBMS: Definition, Creation, Querying, Update, and Administration of Databases

Topics: Database, SQL, Database management system Pages: 3 (870 words) Published: October 30, 2013
A database is an organized collection of data. The data are typically organized to model relevant aspects of reality in a way that supports processes requiring this information. For example, modeling the availability of rooms in hotels in a way that supports finding a hotel with vacancies. Database management systems (DBMSs) are specially designed applications that interact with the user, other applications, and the database itself to capture and analyze data. A general-purpose database management system (DBMS) is a software system designed to allow the definition, creation, querying, update, and administration of databases. Well-known DBMSs include :

My Sql
Posgre SQL
Microsoft SQL Server
SAP
dBASE
Foxpro
IBM DB2
LibreOffice Base
File maker Pro
A database is not generally portable across different DBMS, but different DBMSs can by using standards such as SQL and ODBC or JDBC to allow a single application to work with more than one database.

Formally, the term "database" refers to the data itself and supporting data structures. Databases are created to operate large quantities of information by inputting, storing, retrieving, and managing that information. Databases are set up so that one set of software programs provides all users with access to all the data. A "database management system" (DBMS) is a suite of computer software providing the interface between users and a database or databases. Because they are so closely related, the term "database" when used casually often refers to both a DBMS and the data it manipulates. Outside the world of professional information technology, the term database is sometimes used casually to refer to any collection of data (perhaps a spreadsheet, maybe even a card index). This article is concerned only with databases where the size and usage requirements necessitate use of a database management system. The interactions catered for by most existing DBMS fall into four main groups: •Data definition. Defining...
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • DBMS Essay
  • Dbm/380 Database Concepts Essay
  • Relational Database Management System (Dbms) Essay
  • Is Concentration : Database Administration Essay
  • Database Environment Essay
  • Essay about Administration
  • Database Essay
  • Essay about DBMS

Become a StudyMode Member

Sign Up - It's Free