Types Current Databases

Relational databases

Legacy databases

NoSQL databases

In-memory databases

Authors: Tania Geraldine Bonilla C. Diana Patricia Rey Cabra

APRIL 2018 EDITION N°01 Bogotå D.C | Colombia

Databases currently used in organizations and companies The databases are divided into four major categories: Relational, Inherited, In-Memory, and NoSQL. To this classic classification, it is necessary to add the advanced databases that are extension of the relational databases such as MPP databases and cache databases.

CONTENT Types Current Databases 1.1 Relational databases

1 ……

1.2 Legacy databases

2 ……

1.3 NoSQL databases

3 ……

In-memory databases

4 ……

In-memory databases

5 ……

1

Types current databases

1.1

Relational databases

The relational database management systems are based on relational data and today constitute the heart of most distributed platforms. Some examples of typical solutions are: Oracle Database 11g- recently, version 12c designed for the cloud-, IBM DB2, Microsoft SQL Server, SAP Sybase and MySQL has been presented.

Sqoop is a tool designed to transfer data

The big providers of relational databases are the classic ones: IBM, Oracle and Microsoft. SAP, since the introduction of its HANA product, is becoming not so much a typical provider of relational databases - which it already is, because I bought Sybase, a very well-known database manufacturer in 2010 - as an integrator of relational databases with its HANA platform, supported by an inmemory database. Google has also created its own relational database in the cloud, google cloud SQL, and is designed for the developers of its platform as a GAE service (Google App Engine).

between Hadoop and transactional databases. Sqoop can be used to import data from a relational database management system such as MySQL or Oracle into the Hadoop file management system, known as HDFS, and transform the data into MapReduce, which will then export the data back to the database.

RDBMS system. Sqoop automates most of these processes, relying on the database to describe the scheme of the data to be imported. Sqoop uses MapReduce to import export data that will provide operations in parallel as well as fault tolerance.

2

Sqoop allows massive data imports, with HDFS, Hive and HBase; it is developed in Java and uses MapReduce to transfer data in parallel. Work with direct connectors to improve performance, parallel databases. It works with direct connectors to improve performance, to databases such as MySQL, Oracle and SQL Server.

1.2

Legacy databases

A

s Soares (2012) states, legacy

database management systems are not necessarily associated with Big Data. However, it is highly probable that some types of Big Data will eventually reside in these environments, which manage large volumes of data. For example, Soares signals, the IBM db2 Analytics Accelerator for Z / OS enhances the hus, for example, IMS (Information IBM Netezza appliance to increase Management System) is a hierarchical database management system that works even query speeds against data warehouses located in IBM in the dorsal infrastructure of important mainframes. financial institutions and large organizations

T

around the world.

3

1.3

NoSQL databases

More information‌

NoSQL databases ("Not only SQL") are a category of database management systems that do not use SQL, as their main query language, these databases do not require fixed table schemas, and they do not support Join operations.

They are optimized for scalable read / write operations instead of pure consistency.

Likewise, they constitute an information ecosystem, and are becoming viable alternatives to relational databases for many applications. One of the most used, Cassandra, is used in: Twitter, Netflix, Cisco, RackSpace, OpenX, Ooyala.

A Cassandra cluster has 30 TB (terabytes of data distributed over 400 machines).

In-memory databases

1.4

4

In-memory database management systems rely on main or central memory for data storage. Compared with traditional database management systems that store data on disk, the "in-memory" databases are optimized in speed.

In practice these technologies are able to send all the information coming from a database to the main memory of the systems so that it can be processed much faster.

In this sense, they are becoming widely used tools sometimes essential - in the process and analysis of large volumes of in-memory data. SAP and Oracle, lately Microsoft, and SAS, IBM, and other large companies too, in that sector.

SAP and Oracle lead the market and compete strongly from two very different perspectives, taking advantage of its large network of customers throughout the world.

Microsoft, at the end of November 2012 announcement, with occasion of a database event, the presentation of technology Hekaton, technology "in-memory" ready to compete with the other players in this market.

The database ecosystem

Source: https://blogs.the451group.com/information_management/files/2011/04/Figures-Aslett_web.jpg

5

University Colegio Mayor de Cundinamarca

Information systems Information systems of the company - Joyanes Aguilar Chapter 10- NoSQL databases and in-memory (in-memory) / Hadoop

Authors Tania Geraldine Bonilla Candela Diana Patricia Rey Cabra

Types Current Databases