Andy Rivenes
Reputation: 51
Is Oracle Database In-Memory an in-memory database?
Do I need to be able to fit my entire database in memory to us Oracle's Database In-Memory?
Upvotes: 1
Views: 50
Answers (1)
Andy Rivenes
Reputation: 51
No, you can selectively declare a subset of your database to be in-memory. Since Database In-Memory is targeted at analytic workloads it populates selected objects into an in-memory area in columnar format. This allows analytic queries to scan the columnar data much faster than in the row format.
Upvotes: 2
Related Questions
- difference between in-memory and embedded databases
- Is In-Memory a extra-cost option? (Oracle)
- Does SQL Server support in-memory database?
- Does an in-memory database also have a filesystem component?
- What's the difference between an In-memory database and relational database + NoSQL Database?
- Why would someone need an in-memory database?
- Storage capacity of in-memory database?
- OLAP vs In-Memory
- How in-memory databases persist data
- Justification of the need for an in-memory database