Files Organize

A computer database is a structured collection of records or data that is stored in a computer system. A database relies upon software to organize the storage of data. In other words, the software models the database structure in what are known as database models (or data models). The model in most common use today is the relational model. Other models such as the hierarchical model and the network model use a more explicit representation of relationships

The program that manages the database is referred to as the database management system or DBMS. Among the most popular systems include Microsoft Access, Oracle, Microsoft SQL Server, MySQL, and File Maker. These databases are far more complex than a text file or a spreadsheet, as they have the ability to relate the records across different tables.

The flat (or table) model consists of a single, two-dimensional array of data elements, where all members of a given column are assumed to be similar values, and all members of a row are assumed to be related to one another. For instance, columns for name and password that might be used as a part of a system security database. Columns of the table often have a type associated with them, defining them as character data, date or time information, integers, or floating point numbers.

Another form of database is the spreadsheet similar to the format used in Microsoft Excel, for example. They organize data through a variety of means, either by arranging records by surname, first name or by alphabetic order, reverse-alphabetical, time of modification and so on. Because the items are not only arranged horizontally but also vertically, the records is easier to comprehend.

Data manipulation is yet another advantage of using a database. Extensive data manipulation facilities for creating, copying, moving, converting reformatting and validating application test data are essential for the efficient development of reliable DBMS. The same facilities are also essential in addressing failures in live systems, where it is imperative to find and fix production data errors with confidence and precision.

The most basic example of a database is the text file, and most ordinary computer users keep their database in text form; email addresses, a list of names and a list of telephone numbers can easily be kept in this small, uncomplicated file that can be opened and edited in all sorts of word processors, especially if you've saved your data in universally-accepted ASCII format. Sometimes, keeping databases simple instead of needlessly complicated is the best way to organize your files.

Article Source: http://www.search4allinfo.com

A program Database, or simply called a Database, is a collection of information and data stored in a program system.

Please Rate this Article

5 out of 54 out of 53 out of 52 out of 51 out of 5 

Not yet Rated