Databases

NoSQL

An approach to database design with a key-value store, document store, graph format for data and that differ significantly from the models used in traditional relational databases with access to data by means of SQL.

NoSQL databases

Cassandra, MongoDB, Berkeley DB, Redis, Riak, CouchDB, DynamoDB, OrientDB, Neo4j, ArangoDB, Titan, Hbase, Aerospike

Object-related mapping (ORM)

Object-Relational Mapping is a technology that allows you to convert incompatible types of models into OOP, in particular, between data storage and programming objects.ORM is used to simplify the process of storing objects in a relational database and retrieving them.

Oracle Database

An object-relational database management system produced by Oracle Corporation. Designed for enterprise grid computing. It is a flexible and cost effective way to manage information and applications.

ORD

An object-relational database (ORD) combines the features of both relational databases and object-oriented programming. This increases the ability to sort through and locate files within these databases faster. By assigning these data types to your files, you can better filter them through the database.

OTBI

Oracle Transactional Business Intelligence. Used for Fusion Apps. Organizes reportable data objects into functional subject areas that business users can relate to. Provides tools for complex customizations.

OrientDB

A NoSQL database, written in Java. OrientDB supports multiple models, such as key/value, document, graph and object models, with relationships managed as in a graph database. It is very quick to install, supports web technologies and can be deployed in a cloud (e.g., Microsoft Azure and CenturyLink Cloud).

Percona DB

A database management system that is meant to replace MySQL. It offers everything in MySQL but includes additional tools for diagnostics, performance enhancement, and DB administrators/developers.

PervasiveSQL

A versatile data management solution that combines high performance, powerful integration into applications, and low operating costs in a powerful, flexible and scalable mechanism.

PL/SQL

Procedural Language / Structured Query Language is a procedural language extension to SQL that allows programmers to write code in a procedural format. It is embedded in the Oracle Database (since version 6), along with SQL itself and Java.

PostGIS

A software that adds support for geographic features to the PostgreSQL relational database. PostGIS is developed in accordance with the Simple Features for SQL specification from the Open Geospatial Consortium (OGC).

PostgreSQL

An object-relational database management system (ORDBMS), the most developed of open database systems in the world and is a real alternative to commercial databases.

Presto

An SQL database query engine for running analytical queries on large volumes of data, from gigabytes to petabytes of information. It integrates with databases, such as Apache Hive, Cassandra or relational databases, tunning the queries where the data is stored.

Primary Key

A column or a set of columns that uniquely identifies each row in the table. A primary key must contain unique values. If the primary key consists of multiple columns, the combination of values in these columns must be unique.

RDBMS

Relational Database Management System is a program that lets you create, update, and administer a relational database. Most relational database management systems use SQL to access the database.

Database migration

Database migration — means moving your data from one platform to another.

Redis

REmote DIctionary Server is a non-relational high-performance database. Redis stores all data in memory, access to data is carried out by the key. This approach provides performance that is tens of times higher than the performance of relational databases, and also simplifies data partitioning.

Redshift

An Internet hosting service and data warehouse product which is a part of the larger cloud-computing platform Amazon Web Services. It is built on technology of MPP. It can analyze your data using standard SQL and your available BI tools.

Relational DB

MySQL, Oracle, Access, MS SQL Server (mostly for Microsoft stack), PostgreSQL, SQLite.

RethinkDB

A document-oriented database for storing JSON documents. It is useful for applications with real-time data feeds. An app can benefit from RethinkDB, for example, when streaming analytics is involved, for multiplayer gaming apps, in real-time marketplace and collaborative web apps.

Riak

A distributed NoSQL key-value database, provides high availability, fault tolerance, operational simplicity, and scalability, commonly used case in storing large amounts of log data.

ETL (Extract, Transform and Load)

Refers to a process in database usage and in data warehousing. It includes three stages: data extraction from homogeneous/heterogeneous data sources, its storage and transformation into the proper format or structure for the purposes of analysis, and data loading into the final target.

RocksDB

A high performance embedded database written in C++, can be used to persistently store keys and values. It is a fork of LevelDB which was then optimized to exploit many central processing unit (CPU) cores, and make efficient use of fast storage.

SAP MaxDB

A free relational database management system from SAP AG. It is ANSI SQL-92 compliant and is a good alternative to expensive database management systems for medium and large server configurations. It offers built-in features for self-administration and managing complex objects. It is available for Windows, Linux and Unix.

Snowflake

Data warehouse for the Cloud provided as SaaS. Uses a new SQL database engine with a unique architecture designed for the cloud.