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
2
votes
1 answer

Is there a jooq dialect for VoltDB

Is there a dialect for voltdb? This will definitely help in producing dynamic sql for testing perposes.
Luke101
  • 63,072
  • 85
  • 231
  • 359
2
votes
1 answer

Is there way to run raw SQL in voltdb python driver(voltdb-client-python)?

I try to work with voltdb and it's python driver I can create a procedure in voltdb and call it with VoltProcedure. Smth like: volt_procedure = VoltProcedure(volt, "Proc_name", [VoltConnection.VOLTTYPE_STRING]) result =…
Myroslav Hryshyn
  • 716
  • 7
  • 18
2
votes
2 answers

Exporting data from volt to kafka

We are trying to do a POC where we try to export data from a volt db table to kafka below is the steps I followed:- Step1:- prepared the deployment.xml to enable the export to kafka
2
votes
2 answers

Java- read data from voltdb with native procedure

I'm trying to read data from a VoltDB database with Java. Now, it can be done using result sets from SQL statements, but there should (I'm told) be another way of doing it, native to VoltDB, similarly to how data is written to a VoltDB database…
Lateral
  • 41
  • 6
2
votes
2 answers

Using MySQL alongside NewSQL?

Is it possible to use a NewSQL platform such as VoltDB along side MySQL? The website which will be making use of this a is social based website where people are constantly posting items and comments etc. I like the fact that VoltDB will be very…
JonathanBristow
  • 1,066
  • 2
  • 13
  • 36
2
votes
2 answers

voltDB on window

I am looking to set up VoltDB on the Windows platform. Has anyone implemented it previously? Please share your experience. If there is any issue with installing on the Windows platform, please help me understand how to implement it on the Linux…
M_A_K
  • 378
  • 3
  • 16
2
votes
2 answers

What's the best way to store a bi-dimensional sparse array (2d sparse matrix) ? How much size will it have in VoltDB?

Question one: Are there specialized databases to store dense and sparse matrices ? I googled but didn't find any... The matrix in question is huge (10^5 by 10^5) but it's sparse, which means that most of its values are zeros and I only need to store…
João Pinto Jerónimo
  • 9,586
  • 15
  • 62
  • 86
1
vote
2 answers

How do you create a sql query of dynamic fields using a final string in VoltDB?

I want to create a sql query of dynamic fields that are decided at runtime, such as: SELECT some, random, field FROM table WHERE id = ? Because there is a restriction that you must declare an instance variable SQLStmt: public final SQLStmt sql =…
Some Noob Student
  • 14,186
  • 13
  • 65
  • 103
1
vote
0 answers

Add data without primary keys to a table with csvloader [voltdb]

I want to upload data without primary keys to the database with csvloader. csvloader SalesChannels -f data/SalesChannels.csv -skip 1 -r ./logs --update When I do this, I get the following error message. The number of failed rows exceeds the…
CriXson
  • 11
  • 2
1
vote
0 answers

VoltDB cluster eating all RAM

I've setup a 3 machine VoltDB cluster with more or less default settings. However there seems to be a constant problem with voltdb eating up all of the RAM heap and not freeing it. The heap size is recommended 2GB. Things that I think might be bad…
Tiki Raga
  • 11
  • 1
1
vote
0 answers

VoltDB : How to implement IN operator in Java?

In our project, we used voltdb stored procedure for any operations. In such cases we want to implement IN operator where we can pass any number of parameters in a String array and IN operator accept that array and based on that query will be fire…
Deep Dalsania
  • 375
  • 3
  • 8
  • 22
1
vote
0 answers

How to make fast bulk Inserts in VoltDB with Python

I have a database named "filecards" with six columns: card_id INT NOT NULL UNIQUE, question VARCHAR(500), answer VARCHAR(500), creation_time INT NOT NULL, interval_time INT NOT…
wileni
  • 25
  • 7
1
vote
1 answer

How to write mocks for VoltDb table and VoltDb results using mockito framework?

I need to write test cases for VoltDb procedures using mockito framework . The database returns as array of tables from which I need to get the table using index number and then iterate rows to get values from columns . So if I could get a sample on…
1
vote
1 answer

How to limit the memory used by voltdb

I didn't see any properties for limiting the size of memory used by voltdb,when I config voltdb, so I want to ask: Can I config the max size of memory used by voltdb? If I can, how to config?Where is the configuration file? Can voltdb work in mixed…
Xu Zhenxue
  • 15
  • 4
1
vote
1 answer

Can I execute a partitioned procedure in all partitions (using@GetPartitionKeys) from the SQL terminal?

I need to execute a one-time task to update all rows in a large database. I want to do this as quickly as possible. Each row needs to be read, have a value in a column modified by an algorithm, and then updated with the transformed value. I have…
1
2
3
10 11