Databases

Database

A collection of information, which is organized in a such way that can be easily managed. Traditional databases are organized by fields, records, and files.

AWR

Stands for Automatic Workload Repository, a built-in repository in every Oracle Database, the Oracle DB makes a snapshot of all of its vital statistics and workload information and stores them in the AWR.

Berkeley DB

A software library that provides embedded database for key/value data with scalable high-performance data management services to applications, is NoSQL databases.

Big Table

A high performance, column-oriented data storage system from Google, is designed to handle large amounts of structured data associated with the company's Internet search and web services operations.

Cassandra

An open source distributed database management system; a type of NoSQL database that is used to handle large amounts of data.

CouchDB

An open source database that focuses on the ease of use, embracing the web, it is a NoSQL document store database, uses JSON to store data, JavaScript as its query language. It was developed by Apache software foundation. 

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

Stands for DataBase File, a file format extension used by database software. Has features for data storage and manipulation. Supported by a number of database products. 

DynamoDB

A fully managed NoSQL database service from Amazon that provides fast and predictable performance with scalability, it is cross-platform.

Firebird

An open source SQL relational database management system that runs on Linux, Windows, and a variety of Unix platforms.

HANA

Stands for the High-Performance Analytic Appliance. 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.).

HBase

An open-source distributed column-oriented database built on top of the Hadoop file system that provides quick random access to huge amounts of structured data. 

InterBase

A full-featured commercial RDBMS with small footprint, close to zero administration requirements, and multi-generational architecture, can be embed into software applications. 

Magic keywords for DBA

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

MariaDB

An open source 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. 

MongoDB

A cross-platform and open source document-oriented database, a kind of NoSQL database.Written in C++

MS Access

A Microsoft database management system that helps to store large amounts of information for reference, reporting and analysis.

MS SQL Server

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

MySQL

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

NoSQL databases

Cassandra, MongoDB, Berkeley DB, Redis, Riak, CouchDB, DynamoDB.

NoSQL

An approach to database design with a key-value store, document store, graph format for data, it means Not Only SQL, it's databases especially target large sets of distributed data.

Object-related mapping (ORM)

Programming technique that connects databases with object-oriented principles.

Oracle

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

ORD

Stands for Object-Relation Database. A database management system with an object-oriented database model.

PervasiveSQL

A database management system developed by Pervasive Software, used for embedded databases, it is optimized for embedding in applications, used in different types of packaged software apps.

Subscribe for updates