• Home
    • 2018
    • 2017
  • Oracle GoldenGate
    • Core Platform
    • Cloud Service
    • For Oracle DB
    • For Big Data
    • For MySQL
    • For DB2 z/OS
    • For DB2 LUW
    • For DB2 i
    • For Informix
    • For SQL Server
    • For Teradata
    • For AWS Aurora
    • Foundation Suite
    • Use Cases
  • Data Management
    • General
    • Big Data
    • Oracle Database
    • MySQL
    • MS SQL Server
    • IBM DB2
    • IBM Informix
    • Teradata
    • SAP ASE
  • Data Science
  • IT
    • IT Management
    • IT Technology
  • Reading
  • About
Jinyu's Blog
About Data, Database, Integration and IT 

Data Management

A database is a collection of "data." Databases now can store all kinds of data including structured data, semi/unstructured data and big data that has the nature of large volume, high velocity and mostly unstructured in nature. A Database Management System (DBMS) or Information Management System is a computer software where data are stored and processed.  

We typically categorize DBMS system into SQL and No-SQL database, which is based on how the data is stored and managed.  SQL Database refers to the relational databases where data are stored in relational models (invented by Edgar F. Codd in 1970 ). Relational storage model uses tables to store normalized data(single copy) and refers to data with referential relations. No-SQL Database usually stores data in file/documents format or hierarchical structure. The followings are some leading database management systems on the market: 
  • SQL Database: Oracle Database, IBM DB2 for z/OS, iSeries and LUW,  Microsoft SQL Server, MySQL Database (Maria DB, Percona DB, Aurora DB), IBM Informix, SAP Sybase, PostgreSQL,
  • No-SQL Database: Oracle NoSQL Database (formerly known as Berkeley DB), Mongo DB, Cassandra, HBase, MUMPS
​Database Management Systems
  • Oracle Database
  • IBM DB2
  • Microsoft SQL Server 
  • MySQL
  • IBM Informix 
  • SAP Sybase 
  • PostgreSQL 
  • Mongo DB 
  • Cassandra 
  • Hadoop Systems

What's New 

  • Data Management - Will Dataism Become the New Religion? (8/27/2017) New
  • Data Management - What is the Blockchain(8/21/2017) New
  • Data Management - Oracle Public Cloud Service's Service Level Agreement (5/8/2017)
  • Data Management - Oracle Database Cloud Service Rest APIs (5/2/2017)
Copyright © 2010-2027 Jinyu Wang.