|
|
|
History of The DataBase
Management System
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
|
|
 |
"Thank you! My computer had fatal error
messages and was freezing up.
My brother recommended I try RegCure. I used the free scan and found
363 errors. Using RegCure fixed my PC and has it running like brand
new!"
— Yorgi S. Seattle, WA
|
|
