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 called registry.
Sometimes you need to delete files from the computer but a reference of the non-existent file remains in the registry. These can lead to your computer getting slower and slower. One thing you can do is to check the registry with registry cleaner and clean unneeded files.
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
No comments:
Post a Comment