The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
16 views

Oracle In-Memory POPULATE_STATUS does not change to completed

I'm experimenting with the Oracle In-memory options for BI purposes, when I'm trying to populate one table to in-memory in the v$im_segments the POPULATE_STATUS does not change to completed, for other ...
0
votes
0answers
55 views

Options for fastest guaranteed writes to a SQLite Shared cache in memory database

I have a multi-threaded python process, and I am using SQLite to store data between the processes. The flow is as follows: Main process created named in memory database, and table within the ...
0
votes
0answers
36 views

MySQL MEMORY Engine vs NoSQL in-memory

I have a WebService that runs a hybrid functionality of Secure WebSockets and HTTPS REST API. Both functionalities translate the calls to the same under-the-hood generic calls, wherein the WebService ...
2
votes
2answers
430 views

Calculating RAM requirements for an in-memory database [closed]

In general, how much RAM does an in-memory database require? I would assume it requires enough RAM for: Operating system and general system services, plus DBMS, plus the entire database (same amount ...
1
vote
1answer
52 views

What is the disadvantage of maintaining both row and column table storage?

I just watched Oracle's In Memory database release. I can understand that removing a lot OLAP indexes accelerated the database a bit. But does that really mean maintaining 2 table storages doesn't ...
3
votes
1answer
687 views

Oracle TimesTen vs Oracle database in-memory

Oracle has recently announced its latest Oracle database in-memory feature in 12c. Oracle already had an in-memory database TimesTen and now I was wondering as to what the the differences between ...
5
votes
0answers
189 views

SQL Server 2014 In-Memory tables [closed]

For the past couple of weeks I sort of tested the new In-Memory thing in SQL Server 2014 (never worked with SQL Server 2012, jumped from 2008R2 straight to 2014, so if this new feature is present in ...
5
votes
1answer
333 views

SQL Server 2014 In Memory OLTP - Garbage Collection on Transaction Rollback

In SQL Server 2014, In Memory OLTP, What happens, if a transaction is rolled back and newly created version of row is no more required. Is it duty of garbage collector to remove even such type of rows ...
2
votes
0answers
236 views

In-memory database vs RAM-disk

In SQLite, are there any differences in performance/features/reliability/... between: 1) an in-memory database: rc = sqlite3_open("file::memory:", &db); 2) a database on a RAM-disk? The ...
3
votes
3answers
4k views

ALTER DATABASE statement not allowed within multi-statement transaction

I've downloaded the AdventureWorks based In-memory sample from here, and followed all the steps described in the accompanying doc. However, when I try to run the script in SQL Server Management ...
1
vote
3answers
166 views

in-memory SQL database system [closed]

In an application, I am using mysql's TEMPORARY TABLE. Since this application does not need permanent tables, I wonder if I can find an alternative RDMS designed for memory tables. I hope to find an ...
8
votes
3answers
905 views

What advantages does in-memory OLAP have over traditional systems with significant memory?

Do in-memory OLAP engines have advantages over the traditional OLAP engines backed by enough RAM to contain the entire cube(s)? For example, if I use a MOLAP engine (SSAS) and GB / TB of RAM where ...