0
943views
Explain different types of databases.
1 Answer
0
35views

WHAT IS DATA?

  • Data is a collection of a distinct small unit of information.
  • It can be used inavariety of forms like text, numbers, media, bytes, etc.
  • Data is information that can be translated intoaform for efficient movement and processing.

WHAT IS DATABASE?

•Collection of inter-related data

•organize data into table, schema, views, etc.

•large amount of information by storing, retrieving, and managing data.

•MySQL, Sybase, Oracle, MongoDB, Informix, PostgreSQL, SQL Server

TYPES OF DATABASES

•Centralized Database

•Distributed Database

•Relational Database

•NOSQL Database

•Cloud Database

•Object-oriented Databases

•Hierarchical Databases

•Network Databases

•Personal Database

•Operational Database

•Enterprise Database

CENTRALIZED DATABASE

  • STORES DATA AT A CENTRALIZED DATABASE SYSTEM
  • AUTHENTICATION PROCESS
    • EXAMPLE:CENTRAL LIBRARY

ADVANTAGES OF CENTRALIZED DATABASE

  • Decreased the risk of data management
  • Data consistency
  • Better data quality
  • Better data quality

DISADVANTAGES OF CENTRALIZED DATABASE

  • Centralized database is large
  • Centralized database is large
  • Server failure

DISTRIBUTED DATABASE

  • DATA IS DISTRIBUTED AMONG DIFFERENT
  • DATABASE SYSTEMS OF AN ORGANIZATION
    • EASY DATA ACCESS
  • EXAMPLE:APACHE CASSANDRA, HBASE, IGNITE

  • HOMOGENEOUS DISTRIBUTED DATABASE execute on the same operating system

  • HETEROGENEOUS DISTRIBUTED DATABASE execute on different operating systems
  • Modular development is possible inadistributed database

RELATIONAL DATABASE

  • STORES DATA IN THE FORM OF ROWS(TUPLE) AND COLUMNS(ATTRIBUTES)
  • USES SQL FOR STORING,
  • MANIPULATING, MAINTAINING THE DATA
  • EXAMPLE:MYSQL, MICROSOFT SQL SERVER, ORACLE

PROPERTIES OF RELATIONAL DATABASE

  • Atomicity:data operation will complete either with success or with failure
  • Consistency:value preservation
  • Isolation:data remain isolated
  • Durability:data change is permanent

NOSQL DATABASE

  • STORE WIDE RANGE OF DATA SETS
  • Key-value storage:stores every single item asa key
  • Document-oriented Database:store data as
  • JSON-like document
  • Graph Databases:stores vast amounts of data in agraph-like structure
  • Wide-column stores:data is stored in large columns

ADVANTAGES OF NOSQL DATABASE

  • Good productivity
  • Manage&handle large data sets
  • High scalability
  • Quick data acces

CLOUD DATABASE

  • DATA IS STORED INAVIRTUAL ENVIRONMENT AND EXECUTES OVER THE CLOUD COMPUTING

  • Amazon Web Services(AWS),

  • Microsoft Azure
  • Kamatera
  • PhonixNAP
  • ScienceSoft
  • Google Cloud SQL

OBJECT-ORIENTED DATABASES

  • OBJECT-BASED DATA MODEL APPROACH
  • DATA IS REPRESENTED AND STORED AS OBJECTS

HIERARCHICAL DATABASES

STORES DATA IN THE FORM OF PARENT-CHILDREN RELATIONSHIP NODES

1

NETWORK DATABASES

  • DATA IS CONNECTED IN THE FORM OF NODES
  • IT FOLLOWS NETWORK DATA MODEL
  • CAN FORM GENERALIZED GRAPH STRUCTURE

PERSONAL DATABASE

  • COLLECTS&STORES DATA ON THE USER'S SYSTEM
  • SIMPLE&EASY TO HANDLE
  • LESS STORAGE SPACE REQUIRED

OPERATIONAL DATABASE

  • CREATES AND UPDATES THE DATABASE IN REAL-TIME
  • EXECUTES&HANDLES DAILY DATA OPERATION
  • MANAGES PER DAY TRANSACTIONS

ENTERPRISE DATABASE

  • MANAGES MASSIVE AMOUNT OF DATA
  • IMPROVE EFFICIENCY
  • SUPPORTS MULTI PROCESSES
  • PARALLEL QUERY EXECUTION
Please log in to add an answer.