Descriptive Database and Sql Essay

855 WordsMay 16, 20154 Pages
In today’s society a database is used for various tasks in the business world. In this essay, I plan on describing a database, features, tools, common uses and how they can positively make an impact. A database is a collection of data that can be formatted or organized so that a computer program can quickly select preferred items. This could be something as straightforward as a list of names in alphabetical order or an ascending list of numeric stock codes. The secret to the successful use of database technology is the way in which data or information is structured to enable efficient processing. Like I mentioned earlier a database is an organized collection of data or information so that it can be easily accessed, updated or manipulated. Database management system or (DBMS), is software that manages database on a computer. It is a software system that uses a standard method of cataloging, retrieving, and running queries on data. The DBMS manages (non-geographic) incoming data, organizes it, and provides ways for the data to be altered or extracted by users or other programs. Software includes Eg. Microsoft access, MySQL, oracle etc… That’s the difference when it comes to comparing the two. The Relational Database Management Systems (RDBMS) is a software system which can be used to represents data in the form of tables. RDBMS will use SQL2 as Queries language. Object Oriented Database Management Systems (OODBMS) is a software system, which can be used to represent the data in the form of objects. This DBMS will use OQL as a Query language. Last is Object Relational Database Management Systems(ORDBMS) is a DBMS which will represents some part of the data in the form of tables and some other part of the data in the form of objects. This management system will use SQL3 as a Query Language; it is a combination of SQL2 and OQL. DBMS is vital to

More about Descriptive Database and Sql Essay

Open Document