Databases

Data Architecture

The data architecture defines the data along with the schemas, integration, transformations, storage, and workflow required to enable the analytical requirements of the information architecture.

Database Design

Database Design is a collection of processes that facilitate the designing, development, implementation and maintenance of enterprise data management systems. 

Database development

Database development is a process of designing, implementing, and maintaining a database system & this process is an important aspect of database engineering. 

Data Pipeline

Data Pipeline is a broader term that encompasses ETL as a subset. It refers to a system for moving data from one system to another.

DB2

A family of relational database management system products from IBM that serve different operating system platforms. It is a full-featured, high-performance database engine capable of handling large quantities of data and concurrently serving many users.

Dbf

DataBase File is a file format extension used by database software. Has features for data storage and manipulation. The .dbf format is supported by a number of database products.

DBMS

The database management system is the software that interacts with end users, applications, and the database itself to capture and analyze the data.

Dolt

Dolt is an open-source relational database management system (RDBMS) that combines the familiar interface of a SQL database with the versioning and collaboration features of a version control system like Git. It allows users to version control their databases, making it possible to track changes, revert to previous states, and collaborate on databases in a manner similar to how developers work on code.

DynamoDB

A fully managed NoSQL database service in the key-value format offered by Amazon.com as part of the Amazon Web Services package. It provides fast and predictable performance with scalability.

EnterpriseDB

An enterprise-class RDBMS that supports update-intensive, high-volume applications. Built on PostgreSQL.

Event Store

The functional database with Complex Event Processing in JavaScript. Stores the data as a series of immutable events over time, making it easy to build event-sourced applications.

Fauna

Fauna is a globally distributed, serverless, and transactional NoSQL database. It's designed to provide a flexible and scalable data storage solution for modern applications. Fauna DB is used in various applications, including web and mobile applications, gaming, e-commerce, financial services, and more. It's particularly well-suited for applications that require a globally distributed database with strong consistency guarantees.

Firebird

A SQL relational database management system that runs on Linux, Windows, and a variety of Unix platforms. A single Firebird server can process several hundred independent databases, each with multiple user connections.

GraphDB

Semantic Graph Database. Provides the core infrastructure for solutions where modelling agility, data integration, relationship exploration and cross-enterprise data publishing and consumption are important.

Google Compute Engine

Google's Infrastructure-as-a-Service (IaaS) virtual machine offering. Enables users to use virtual machines in the Cloud as server resources instead of acquiring and managing server hardware.

HANA

High-Performance Analytic Appliance is an in-memory database used to store and retrieve data as requested by the apps. It also performs advanced analytics (predictive/streaming analytics, text search, etc.).

InfluxDB

A time series database written in Go and optimized for fast, high-availability storage and retrieval of time series data in fields such as operations monitoring, application metrics, Internet of Things sensor data, and real-time analytics. It also has support for processing data from Graphite.

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.