Databases

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.

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.

RDS

Relational Database Service is a web service that simplifies setting up, operating, and scaling a relational database in the cloud. The service provides economical and scalable use of resources while simultaneously automating time-consuming administrative tasks.

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.

Development by Synergize.digital

Sign up for updates
straight to your inbox