Data-Base (DBMS)

Data-Base (DBMS)

A database is an organized collection of structured information, or data, typically stored electronically in a computer system. A database is usually controlled by a database management system (DBMS). ... The data can then be easily accessed, managed, modified, updated, controlled, and organized

Type of Data-Base:

1.     Structured Data-base (RDBMS)

2.     Unstructured Data-base (Non- RDBMS)

Structured Data-base:

The term structured data refers to data that resides in a fixed field within a file or record. Structured data is typically stored in a relational database (RDBMS). ... Typical examples of Excel, Google Sheets, SQL, customer data, phone records, transaction history

Some RDMS Tools:

·        Microsoft SQL Server

·        Oracle Database

·        MySQL

·        IBM Db2

·        Amazon Relational Database Service (RDS)

·        PostgreSQL

·        SAP HANA

·        Amazon Aurora

·        IBM Informix

·        MariaDB

·        SQLite

·        Teradata Vantage

·        Azure SQL Database

·        Oracle Database Express Edition (XE)

·        InterSystems IRIS

·        SAP HEC (HANA Enterprise Cloud)

·        SAP SQL Anywhere

·        Firebird

·        Percona Server

Unstructured Data-base:

Structured data is data that has been organized into a formatted repository, typically a database, so that its elements can be made addressable for more effective processing and analysis. ... Typical examples of Text data, social media comments, phone calls transcriptions, various logs files, images, audio, video

Some Non-RDMS Tools:

·        Couchbase

·        NoSQL

·        IBM Cloud Databases

·        MongoDB

·        IBM Cloudant

·        Amazon DynamoDB

·        Cassandra

·        HBase

·        Neo4j

·        Cache

·        Amazon ElastiCache

·        Oracle Berkeley DB

·        Google Cloud Datastore

·        Matisse

·        Amazon Neptune

·        TIBCO Graph Database

·        BigTable (Google)