Questions tagged [voltdb]

VoltDB is an in-memory database designed by several well-known database system researchers, including Michael Stonebraker. It is an ACID-compliant RDBMS which uses a shared nothing architecture. It includes both enterprise and community editions. VoltDB implements the design of the academic H-Store project.

VoltDB is a NewSQL relational database that supports SQL access from within pre-compiled Java stored procedures. The unit of transaction is the stored procedure, which is Java interspersed with SQL. VoltDB relies on horizontal partitioning down to the individual hardware thread to scale, k-safety (synchronous replication) to provide high availability, and a combination of continuous snapshots and command logging for durability (crash recovery).

VoltDB is designed to take full advantage of the modern computing environment:

  • VoltDB uses in-memory storage to maximize throughput, avoiding costly disk access.
  • Further performance gains are achieved by serializing all data access, avoiding many of the time- consuming functions of traditional databases such as locking, latching, and maintaining transaction logs.
  • Scalability, reliability, and high availability are achieved through clustering and replication across multiple servers and server farms.
156 questions
1
vote
0 answers

Why use voltsql, there is an error Couldn't find log4j configuration file

After I installed voltsql successfully, the following error occurred while executing voltsql [whz@izbp16d6c3ttl701mgdkc7z voltdb]$ ./bin/voltsql > SHOW tables; …
zhouzx
  • 11
  • 3
1
vote
1 answer

inserting list of values in voltdb

Am using volt db and need to insert list of values like shown below field1 | field2 | field3 | field4 foo | bar | baz | value one foo | bar | baz | value two foo | bar | baz | value four foo | bar | baz | value…
recursion
  • 354
  • 6
  • 11
1
vote
1 answer

Why allow dirty read when it happens network partition in VoltDB?

I am PhD student in Seoul National University. My name is Seokwon Choi. I impressed research paper(Analysis for network partition fault). I hope to present this paper with my lab member at lab seminar time. However, I read your research paper and …
1
vote
1 answer

Loading VoltDB procedures via Java classes with InProcessVoltDBServer

I am trying to load VoltDB Java procedures from methods and classes via jar with the following statement: InProcessVoltDBServer volt = new InProcessVoltDBServer(); volt.runDDLFromString("load classes StoredProcs.jar;"); After running the jar file…
Marko Jovanov
  • 418
  • 10
  • 25
1
vote
1 answer

VoltDB pass execute multiple inserts in one invoke, C++ API

I currently have a model where a large number of inserts need to be done (not at startup) on the same table. For the time being I am preparing the insert values set inside the C++ code and then calling the insert stored procedure…
Marty
  • 116
  • 1
  • 10
1
vote
0 answers

Voltdb C++ Async Invoke Requests

I'm using below piece of code which takes about 8 microseconds per transaction. voltdb::Procedure procedure("test.Insert", parameterTypes); voltdb::InvocationResponse response; voltdb::ParameterSet* params = procedure.params(); int trans =…
qasim
  • 11
  • 1
1
vote
1 answer

VoltDB Kafka importer

I am currently using VoltDB kafka importer to import data from multiple kafka topics. I am facing performance issue with the loader. I read the VoltDB documentation but unable to find how to fine tune the importer. How can specify specific partition…
Arjun
  • 41
  • 4
1
vote
1 answer

Why VoltDB choose Red-Black Tree as index structure?

As I can see from the source code: enum TableIndexType { BALANCED_TREE_INDEX = 1, HASH_TABLE_INDEX = 2, BTREE_INDEX = 3, // unused COVERING_CELL_INDEX = 4 }; VoltDB mainly use BALANCED_TREE_INDEX as index…
sel-fish
  • 4,308
  • 2
  • 20
  • 39
1
vote
1 answer

How can I create triggers in VoltDB using the C# client?

How can I create triggers within a stored procedure in VoltDB? I am using the C# VoltDB client. Is the callback in voltdb.procedures.wrap() the same as creating triggers?
Cenoy
  • 21
  • 1
1
vote
1 answer

In VoltDB, How to store NULL in column when i pass empty string as parameter?

Currently, When I pass an empty string in VoltDB Stored Procedure parameter, It stores as an empty string. Is there any way to store NULL when I pass an empty string as a parameter(Just Like Oracle)?
c.sankhala
  • 850
  • 13
  • 27
1
vote
1 answer

ClientConfig.setHeavyweight - Volt Network 1 & Volt Reaper Thread

In ClientConfig Javaoc says that the client will use Runtime.coresAvailable / 2 (let's say N = cores / 2), that means that must be N Volt Network Threads and N Volt Reaper Threads ? Or N/2 "Volt Network Threads and N/2 Volt Reaper Threads ?
aamadeo
  • 347
  • 4
  • 10
1
vote
1 answer

Voltdb init encountered an unrecoverable error and is exiting

I followed the official documents about voltdb, but encounter a error when using voltdb init --config=deployment.xml init voltdb configure file. and the error is ERROR: Deployment information could not be obtained from cluster node or…
Ckll
  • 17
  • 4
1
vote
1 answer

Run VoltDB stored procedures at regular interval from VoltDB

Is there any way to execute VoltDB stored procedures at regular interval or schedule store procedure to run at a specific time? I am exploring VotlDB to shift out product from RDBMS to VotlDB. Out produce written in java. Most of the query can be…
1
vote
1 answer

exec StoredProcedure passing Array of Integers?

I have a stored procedure which has .. WHERE something IN ? ..... I can't find any documentation on how to call this procedure using "exec" I tried all combinations exec bestThumbs ([[324622 ,321235]]); Invalid parameter count for procedure:…
Gotys
  • 1,371
  • 2
  • 13
  • 22
1
vote
1 answer

How to design a big scale VoltDB cluser with dozens of nodes and hundreds of partitions?

If I have 32 phsical servers which have 32 cores CPU and 128G memory inside, I want to build a VoltDB cluster with all of those 32 servers with K-Safefy=2 and 32 partitions in each server, so we will get VoltDB cluster with 256 available partitions…
Simon Gao
  • 11
  • 2
1 2
3
10 11