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