Home | Computers
A collection of related data stored in one or more computerized files in a manner that can be accessed by users or computer programs via a database management system. A software system that facilitates the creation and maintenance and use of an electronic database. Traditional databases are organized by fields, records, and files. A field is a single piece of information; a record is one complete set of fields; and a file is a collection of records. For example, a telephone book is analogous to a file. It contains a list of records, each of which consists of three fields: name, address, and telephone number. Database management system is system software used to manage the organization, storage, access, security and integrity of data in a structured database. To access information from a database, you need a database management system This is a collection of programs that enables you to enter, organize, and select data in a database. Database management systems are usually categorized according to the database model that they support. The data model tends to determine the query languages that are available to access the database. There are different types of DBMS System Relational Database Management Systems Network Database Management Systems Hierarchical Database Management Systems Relational Database Management Systems The most widely commonly used type of DBMS today is the Relational Database Management Systems. Some Data Base Management Systems can be accessed directly using programming languages such as COBOL while others provide their own programming language for interacting with the database. Many DBMS applications also provide reporting and query tools to view data in the database. Database design is the process of organizing this data into related record types. The DBMS that is chosen is the one that can support the organization's data structure while efficiently processing the transaction volume. Relational Database Management Systems Relational databases do not link records together physically, but the design of the records must provide a common field, such as account number, to allow for matching. Often, the fields used for matching are indexed in order to speed up the process. Network Database Management Systems The network model tends to store records with links to other records. Associations are tracked via "pointers". These pointers can be node numbers or disk addresses. Most network databases tend to also include some form of hierarchical model. In network databases, a record type can have multiple owners. Hierarchical Database Management Systems In a hierarchical model, data is organized into a tree-like structure, implying a single upward link in each node to describe the nesting, and a sort field to keep the records in a particular order in each same-level list. Relational Database Management Systems Relational databases do not link records together physically, but the design of the records must provide a common field, such as account number, to allow for matching. Often, the fields used for matching are indexed in order to speed up the process Following are some Database Product which are popular. 4D ADABAS Alpha Five Apache Derby Java, also known as IBM Cloudscape and Sun Java DB BerkeleyDB CSQL dBase FileMaker Firebird database server Hsqldb IBM DB2 IBM IMS IBM UniVerse Informix Ingres Interbase MaxDB Microsoft Access Microsoft SQL Server Model 204 MySQL Nomad Objectivity/DB OpenOffice.org Base OpenLink Virtuoso Oracle Database Paradox PostgreSQL ScimoreDB Superbase Sybase Visual FoxPro Teradata RDM Embedded Be careful when choosing a product thoug. There are many similar products choosing a reputable company and getting feedback from existing customers is a wise decision.
Article Source: http://www.articletap.com
Discover more about computers and eusing free registry cleaner from his website. He shares some of his things he learned in 10 years experience.
Please Rate this Article
5 out of 54 out of 53 out of 52 out of 51 out of 5
Not yet Rated
