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

Concept and Review of Oracle NoSQL Database or ONDB – Part Two

In the first part of this article, the concept of Oracle NoSQL Database (or ONDB) and its architecture are explored. In this paper, the second part of this series of articles addresses some of the features of this technology, including Indexing and Table Data Model … we will pay. Table data model in ONDB The structure of the table data with the effect on the main concepts of the design of Schema, facilitates the process of modeling the data of the program. This model is at the forefront of the…

Read More