Databases

InterBase

A cross-platform database management system originally developed by Borland, which supports most of the known platforms: Windows, Linux, Unix, Solaris, Mac OS, etc. It is often used in embedded military and special-purpose systems.

JSONB

Datatype which converts text-format JSON object into a binary format. It removes unnecessary white spaces and duplicate keys and sorts the keys. Because of these pre-processing, JSONB consumes more spaces and processing power than JSON.

Key-Value Database

A type of nonrelational database that uses a simple key-value method to store data. A key-value database stores data as a collection of key-value pairs in which a key serves as a unique identifier.

Liquibase

A database-independent library created for tracking and managing database changes, mainly in an agile software development environment. Often used as a database migration management system.

Magic keywords for DBA

Stored procedures, triggers, replication, performance optimization, clustering, back-up, deadlocks, tuning, configuration.

MariaDB

A relational database with an extensible architecture, it has replaced MySQL in many places thanks to being quicker, more open and vibrant, having more storage engines, more transparent security releases, better performance, etc.

Master Data Management

Master Data Management (MDM) is a comprehensive approach and set of technologies used to manage the critical data of an organization. It provides, with data integration, a single, consistent, accurate version of master data, which is stored in a central repository. This ensures that various departments in an organization rely on the same data for their operations. MDM streamlines data sharing among personnel and departments.

 

 
 
 
 
 

MemSQL

A SQL database managing system that is used for transactions and analytics, it also combines data warehouse and streaming workloads. It compiles Structured Query Language into machine code, via termed code generation.

MongoDB

A document-oriented database management system that does not require a description of the table schema. It is classified as NoSQL, uses JSON-like documents and a database schema. Written in C ++.

Multi-database systems

A multi-database system, also known as a polyglot database system, is a type of database management system (DBMS) that allows an application to use multiple types of databases simultaneously. This means that different parts of an application can interact with different databases based on the specific requirements of the data being managed.

MS Access

A database management system that helps to store large amounts of information for reference, reporting and analysis. Thanks to the built-in VBA language, in the Access itself you can write applications that work with databases.

MS SQL Server

A relational database management system developed by Microsoft. It is built for the basic function of storing and retrieving data as required by other applications, both GUI and command based software.

MySQL

An relational database management system based on SQL, associated with web-based applications and online publishing, runs on Linux, UNIX, Windows and other platforms.

Navicat

A series of database management and development tools for MySQL, MariaDB, MongoDB, Oracle, SQLite, PostgreSQL, and Microsoft SQL Server. Supports database connections through SSH and HTTP Tunnels. Offers comprehensive data format support for data migration.

Neo4j

A graphical database management system with open source code, implemented in Java. Neo4j has all the characteristics of databases, including compliance with ACID, maintaining clustering and recovery from a system failure.

NewSQL

NewSQL is a term used to describe a category of modern relational database management systems (RDBMS) that aim to combine the benefits of traditional SQL databases with the scalability and performance characteristics of NoSQL databases. These databases are designed to address the limitations of traditional relational databases when it comes to handling large-scale, distributed, and high-throughput workloads.

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.

Sign up for updates
straight to your inbox