database and relative
  • Introduction
  • database
  • SQL
  • different kinds of Database
  • JDBC
  • oracle
  • MySQL
  • hibernate1
  • JavaPersistence:HibernateandJPAFundamentals0
  • keys
  • NoSQL DB
Powered by GitBook
On this page
  • 1. Oracle:
  • 2. Microsoft SQL Server
  • 3. MySQL
  • 4. IBM DB2
  • 5. NoSQL
  • 5.1 MongoDB
  • 5.2 DynamoDB
  • 6. Sybase

Was this helpful?

different kinds of Database

PreviousSQLNextJDBC

Last updated 5 years ago

Was this helpful?

1. Oracle:

Oracle Database(commonly referred to as Oracle RDBMS or simply as Oracle) is an object-relational database management system product.

latest stable release: 12c

Type: ORDBMS

PL/SQL: Procedural Language/Structured Query Language

PL/SQL includes procedural language elements such as and . It allows declaration of constants and , procedures and functions, types and variables of those types, and triggers. It can handle (runtime errors). are supported involving the use of PL/SQL collections.

2. Microsoft SQL Server

Microsoft SQL Server is a developed by .

stable release: SQL server 2016

3. MySQL

MySql is an (RDBMS).

two different editions: the open source MySQL Community Server and the proprietary .

4. IBM DB2

5. NoSQL

A NoSQL database provides a mechanism for storage and retrieval of data that is modeled in means other than the tabular relations used in relational databases. NoSQL databases are increasingly used in big data and real-time web applications. NoSQL systems are also sometimes called "Not only SQL" to emphasize that they may support SQL like query languages.

5.1 MongoDB

MongoDB is a free and open-source cross-platform document-oriented database program. Classified as a NoSQL database program, MongoDB uses JSON-like documents with schemas.

5.2 DynamoDB

Amazon DynamoDB is a fully managed proprietary NoSQL database services that is offered by Amazon.com as part of the Amazon Web Services portfolio.

6. Sybase

IBM Db2 contains products developed by . These products all support the , but in recent years some products have been extended to support features and non-relational structures like JSON and XML.

Sybase was an and services company that produced software to manage and analyze information in . Sybase was acquired by in 2010; SAP ceased using the Sybase name in 2014.

conditions
loops
variables
exceptions
Arrays
relational database management system
Microsoft
open-source
relational database management system
Enterprise Server
database server
IBM
relational model
object-relational
enterprise software
relational databases
SAP