Wednesday, November 3, 2021

Oracle Analytics Cloud uses Oracle Database In-Memory for faster results

Oracle Analytics Cloud uses Oracle Database In-Memory for faster results.

This blog post by Bret Grinslade Senior Product Director at Oracle highlights this exciting new announcement by Oracle Analytics Cloud.

Here is a brief summary.
  • In Oracle Analytics Cloud, the new in-memory engine provides Automatic Caching, which is in-turn built on Oracle Database In-Memory.
  • Built on Exadata and the advanced Oracle Database query engine, Automatic Caching for datasets offers query performance improvements without any changes to existing customer datasets.
  • In-Memory is very helpful for larger datasets or datasets with complex calculations.
  • The new caching engine is available in Oracle Analytics Cloud in Oracle Cloud Infrastructure (OCI).
  • Some of the best performance improvements are for more complex scenarios e.g. Datasets with multiple users using shared workbooks see query performance improving as more queries are run.
  • Users can noticeably observe the most performance benefits when employing complex filters and calculations. 
  • These performance benefits now come with the same security and ease-of-use that, you get with an Oracle Analytics Cloud dataset.
  • The best part of this new combination is that customers already have it.
  • Starting with Release 6.1, all customers using Oracle Analytics Cloud on OCI Gen2 have been automatically upgraded: You can continue to use datasets with Automatic Caching, and when the data is reloaded, it will use in-memory technology.
Enjoy this blog post announcing this exciting new combination now available for Oracle Analytics Cloud.

Cheers.

No comments:

Post a Comment