Databases

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.

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.

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 ++.

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.

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, DynamoDBOrientDB, 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.

Development by Synergize.digital

Sign up for updates
straight to your inbox