Introduction of Database

July 17, 2016 by Arti Khedkar

Filed under Database

Last modified October 21, 2016

 Introduction of Database

            Connection of Database is more important in programs. Because of that the storing of all data is possible.   So for that purpose we can use database in programs.

SQL is a standard language for accessing databases. Our SQL tutorial will teach you how to use SQL to access and manipulate data in:  SQL Server , Oracle, MS-Access ,MYSQL, Sybase, DB2, and other database systems.

 

What is Database:-

            A database is a collection of DATA. So that it can easily be accessed, managed, and updated. Traditional databases are organized by records, fields 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.

DB1

Database

       

 

 Examples:

  • Phone book
  • Address book
  • Census Bureau data

  

 Types of Database:

              1.Relational Database:

This is the used by most of all the different types of databases. In this, the data in a relational database is stored in various data tables. All the tables are related to each other through several key field.

rdb

Relational Database

 

 2. Analytic Database:

Analytic databases are primarily static, read-only databases which store archived, historical data used for analysis.

103554_951689

Analytic Database

 

  1. Operatinal Database:

In inventory management, purchases, transactions and financials .An organization generates a huge amount of data daily. Think of things such as inventory management, financials, transactions and Purchases.

odb

Operational Database

 4.  Hierarchical Database

The Hierarchical Database Model defines hierarchically-arranged data. This visualizing an upside down like a family structure. In this family, the top most called the parent node and the below them called child node.

 

hdb

Hierarchical Database

 

5. End-User Database

There is a variety of database available at the Work point of all the end users of any organization. Each workstation is like a small database in itself which includes data in spreadsheets, presentations, word files, note pads and downloaded files. All like that  small databases form a different  database called the end-user database.

External Database

External Database

  1. 5. External Database

    External Database software manages information gathered fordifferent individuals or organizations. External databases are only used by Admin. The Internet Movie Database is one of the examples of an external database.

 

edb1

External Database

 

 

Drivers of Database :

 

  1. JDBC: Java Database Connectivity

 JDBC is a Database driver  used for java Application connection purpose. Abbreviation of JDBC is Java Database Connectivity. For connections of each and every program have different JDBC drivers. There are 4 types of JDBC …

 

  • JDBC-ODBC bridge driver
  • Native-API driver (partially java driver)
  • Network Protocol driver (fully java driver)
  • Thin driver (fully java driver)

 

  1. ODBC: Open Database Connectivity

    ODBC driver is used for almost all database connectivity. Abbreviation od ODBC is Open Database Connectivity.

 

  1. NET:

It is used to connect the any database with managed provider.

  1. MS-Access:

It is used to provide data from front-end to back-end of program from storing data in proper manner.

 

  1. OLDB:

This Database driver supports both pulling data from the database and pushing data into the report from an ADO recordset.

 

         6.CDO:

This Database driver supports pushing data into a report from a CDO recordset only; it will not pull data on its own. Use the Crystal Data Object library to populate a CDO recordset.

Leave a Comment