Database and Types

on

 

Database and its Types:

  • According to "Martin Richard" in 1980's , "The database is the collection of interrelated data designed to meet the needs of multiple types of user and shared to an organization".
  • It is a large Collection of Data to insert, delete and update a record rapidly for various end user's.
Types of Database:
  1. Operational Database:
    1. It is also called SADB (Subject Area Data Base)
    2. It is need to store data for entire organization.
    3. An operational database is designed to run the day-to-day operations or transactions of your business.
    4. It is a Transaction Database, and production Database. For Example customer database, personal and Inventory Database etc.

  2. Analytical Database:
    1. In this Database all the store data and information are extracted from an Operational and External Database.
    2. Analytical databases store massive amounts of data that organizations use to gain insight into their business, customers and more
    3. consist the summarized data and information which is to most need to an organization and other end-users.
    4. It is a read-only system that stores historical data on business metrics such as sales performance and inventory levels
    5. It is also called Management Database/ Information Database. For Example Decision Support System.


  3. Data Warehouse:
    1. A data warehouse (DW or DWH), also known as an enterprise data warehouse (EDW), is a system used for reporting and data analysis and is considered a core component of business intelligence
    2. It is to store data from current and previous years- mean data extracted from the various Operational databases of an organization.
    3. The data stored in the warehouse is uploaded from the operational systems (such as marketing or sales)
    4. It can be integrated, Edited, Standardized by manager and other end-user of an organization.

  4. Distributed Database:
    1. A database is dispersed through an organization. 
    2. a Database is a local workgroup and department at regional office, branch office and other worksite.
    3. A distributed database (DDB) is "an integrated collection of databases that is physically distributed across sites in a computer network".
    4. A distributed database system (DDBS), the files must be structured, logically interrelated, and physically distributed across multiple sites.
    5. It will be work though Communication Link.

  5. End user Database:
    1. Our own personal Database is called End-user database.
    2. The end user is usually not concerned about the transaction or operations done at various levels and is only aware of the product which may be a software or an application.
    3. It will have a different variety of data files which is to be developed by end-users at their workstations. For Example collections of documents in spreadsheets, word processing and even uploading and downloading files.

  6. External Database:
    1. It provide by online services/ information.
    2. It will access very rapidly.
    3. It will available for a fee to end-user and organization from commercial information service.
    4. An external database is composed of an external collection of chained terms; these chains give you direct access to data that is not a part of your Prolog program. 
    5. The external database can be stored in any one of three locations: in a file, in memory, or in EMS-type expanded memory under DOS.

  7. Image & Multimedia Database:
    1. In this DB, it is to store data in a text, audio, video, sound form. For Example Electronic Encyclopedia are available on Disk form which is to store thousand of animated video along with thousands of pages of text.
    2. A Multimedia database (MMDB) is a collection of related for multimedia data. The multimedia data include one or more primary media data types such as text, images, graphic objects (including drawings, sketches and illustrations) animation sequences, audio and video.
  8. Text Database:
    1. It will to create a document and store electronically.
    2. A full-text database or a complete-text database is a database that contains the complete text of books, journals, magazines, newspapers or other kinds of textual documents.
For more update visit to site 

Comments

Post a Comment