Compare In-Memory Technology in Oracle, IBM and SQL Server – Part Three (Final)

By increasing the amount of data as well as the need for faster processing, database providers also have capabilities in their products. The In-Memory feature is one of these, and in the first and second parts of this series, we compared In-Memory to SQL Server and Oracle. In this article, which is the third part (final), we will examine this technology in IBM DB2 10.5 and compare it with SQL Server. Data Analysis with BLU Acceleration in IBM DB2 10.5 The IBM DB2 BLU Acceleration feature is available as an integrated In-Memory integration solution with IBM DB2 10.5 . This solution has several optimization processes, but…

Read More

Comparing In-Memory Technology in Oracle, IBM and SQL Server – Part II

comparison of In-Memory technology in a variety of databases examined the technology in Oracle’s databases and also compared it with SQL Server. Here are some other features we’ll look at. In-Memory Columnstore feature in Oracle 12c Oracle Corporation offers In-Memory Columnstore technology as an optional add-on with Oracle Database 12c for users. If this option is enabled for tables or table spaces, Oracle generates a copy of the subset of the data in the caching format as columnar storage. Thus, database administrators can only select the In-Memory data, which is very important in operational terms, and accelerate the analysis…

Read More

Comparison of In-Memory technology in Oracle, IBM and SQL Server – Part I

Currently, some organizations provide in-memory databases for a wide range of activities. This paper examines In-Memory technology in Oracle and IBM and SQL. The concept of In-Memory technology in the Oracle database In-Memory technology in the Oracle database is considered as a new option for the Oracle 12c database. In fact, this technology is considered as an Add-On option for the Oracle 12c database, and allows the company to provide its main interface software as an in-memory database. Oracle Database In-Memory can run on all platforms running on Oracle 12c. Oracle needs a separate product such as Oracle…

Read More

What is MongoDB? Introducing MongoDB Database

The MongoDB database is a robust, flexible and scalable database. This database has the ability to out-scale and many of the features of relational databases, such as indexing and query and storage domains. The MongoDB database has many of these features like built-in support for Map Reduce-style aggregation and Map Reduce-style aggregation. MongoDB was launched in 2007 by 10gen, and its first release was released in March 2010. This database actually stores data with a JSON structure and no specific Schema, rather than storing table data, such as relational or classical databases. This database is currently being used…

Read More

Introducing The CouchDB Database

  CouchDB is also a member of the NoSQL family, and it can be said that there are differences between families. CouchDB was first released in 2005, but it was owned by Apache in 2008. CouchDB, originally developed with the C ++ programming language, was later translated into Erlang in 2008. Like other members, this database is a documentary database that stores data in the document using the JSON format. This database began with the slogan “A database that accepts the concept of the Web”. You can read out the differences at a…

Read More