Databases

You can use the unlimited database on your server and can use any database on it.

A database is a systematic collection of data. They support electronic storage and manipulation of data. Databases make data management easy. Computer databases typically contain aggregations of data records or files, containing information about sales transactions or interactions with specific customers.

Let us discuss a database example: An online telephone directory uses a database to store data of people, phone numbers, and other contact details. Your electricity service provider uses a database to manage billing, client-related issues, handle fault data, etc.

Types of Databases

Distributed Database- A distributed database is a collection of multiple interconnected databases, which are spread physically across various locations that communicate via a computer network.

Relational Database- A relational database is a type of database that stores and provides access to data points that are related to one another. Relational databases are based on the relational model, an intuitive, straightforward way of representing data in tables. In a relational database, each row in the table is a record with a unique ID called the key. The columns of the table hold attributes of the data, and each record usually has a value for each attribute, making it easy to establish the relationships among data points.

Object- Oriented Database- The object-oriented database model ties related packages together. In other words, a data set and all its attributes are combined with an object. In this way, all of the information is directly available. Instead of distributing everything across different tables, then, the data can be retrieved in one package. Alongside the attributes, methods are also stored in the objects. This is where the databases’ proximity to object-oriented programming languages becomes clear. As in programming, each object has certain activities that it can carry out.

Centralized Database- A centralized database is stored at a single location such as a mainframe computer. It is maintained and modified from that location only and usually accessed using an internet connection such as a LAN or WAN. The centralized database is used by organizations such as colleges, companies, banks etc.

Open-Source Database- Open source databases are free community databases with the source code available to the general public to use, and may be modified or used in their original design. Popular examples of open source databases include MySQL, PostgreSQL and Mongo DB.

Cloud Database- A cloud database is a database that typically runs on a cloud computing platform, and access to the database is provided as-a-service. Database services take care of scalability and high availability of the database. Database services make the underlying software-stack transparent to the user.

Data Warehouse- A data warehouse is a large collection of business data used to help an organization make decisions. The concept of the data warehouse has existed since the 1980s, when it was developed to help transition data from merely powering operations to fueling decision support systems that reveal business intelligence.

NoSQL Database- NoSQL Database is a non-relational Data Management System, that does not require a fixed schema. It avoids joins, and is easy to scale. The major purpose of using a NoSQL database is for distributed data stores with humongous data storage needs. NoSQL is used for Big data and real-time web apps. For example, companies like Twitter, Facebook and Google collect terabytes of user data every single day.

Graph Database- Graph databases are purpose-built to store and navigate relationships. Relationships are first-class citizens in graph databases, and most of the value of graph databases is derived from these relationships. Graph databases use nodes to store data entities, and edges to store relationships between entities. An edge always has a start node, end node, type, and direction, and an edge can describe parent-child relationships, actions, ownership, and the like. There is no limit to the number and kind of relationships a node can have.

OLTP Database- OLTP (Online Transactional Processing) is a category of data processing that is focused on transaction-oriented tasks. OLTP typically involves inserting, updating, and/or deleting small amounts of data in a database. OLTP mainly deals with large numbers of transactions by a large number of users.

Personal Database- Personal databases are typically small database management systems designed to be used by only one person to organize information (see our guide to data terminology for more information on what databases are and how they work).

Multimodal Database- A multimodal database is a data processing platform that supports multiple data models, which define the parameters for how the information in a database is organized and arranged. Being able to incorporate multiple models into a single database lets information technology (IT) teams and other users meet various application requirements without needing to deploy different database systems.

Document/JSON Database- A document database is a type of no relational database that is designed to store and query data as JSON-like documents. Document databases make it easier for developers to store and query data in a database by using the same document-model format they use in their application code.

Hierarchical- A hierarchical database model is a data model in which the data are organized into a tree-like structure. The data are stored as records which are connected to one another through links. A record is a collection of fields, with each field containing only one value.

Network DBMS- Network database management systems (Network DBMSs) are based on a network data model that allows each record to have multiple parents and multiple child records. A network database allows flexible relationship model between entities.The result is a faster data access, search, and navigation.

Add a Comment