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

How to create a relation on VoltDB using python client?

VoltDB provides a python client to allow user to interact with database in python. https://github.com/VoltDB/voltdb-client-python However, I could not figure out how to create a relation through python. The sample scripts only contain "SELECT" and…
Mark Jin
  • 2,616
  • 3
  • 25
  • 37
0
votes
1 answer

How to prevent the default primary key indexing is from being used in VoltDB?

For VoltDB, while creating the table, I am using primary key to prevent content violation. This creates primary key index automatically which is a balance tree. I have also create Hash index for the tables and I want to use hash index and not to use…
kadsank
  • 311
  • 7
  • 20
0
votes
1 answer

How to implement transactions in VoltDB?

VoltDB is in memory and ACID compliant database. How we can implement transactions in this database. Please suggest.
Kapil Yadav
  • 650
  • 1
  • 5
  • 29
0
votes
2 answers

Javascript - Querying VoltDB api with fetch

I'm trying to query a VoltDB using its api: const url = 'http://server:8080/api/1.0/' const queryParam = encodeURIComponent('select * from table') const queryURL = url +…
aamadeo
  • 347
  • 4
  • 10
0
votes
1 answer

VoltDB is exhausting the RAM while loading the data

I am trying to load the database tables into VoltDB database using csvloader utility of VoltDB. When I am trying to load one table of size 5GB, Voltdb eats the RAM so fast that free RAM become 200 MB from 55 GB, then the VoltDB process gets killed…
kadsank
  • 311
  • 7
  • 20
0
votes
1 answer

How do I get partition id from java stored procedure in voltdb

I am having a single partitioned java stored procedure in Voltdb. I need to get the partition id of the current partition in which the procedure is running. How do I get that within the procedure?
Shamith Kumar
  • 13
  • 1
  • 3
0
votes
1 answer

Performance measurement for VoltDB RDBMS

I want to measure the performance of VoltDB RDBMS against TPCC queries. I have tried some VoltDB system procedures like @Statistics, @SystemCatalog, but I am looking for CPU and memory utilization percentage. Where do I get these performance…
kadsank
  • 311
  • 7
  • 20
0
votes
2 answers

Schema and call flow in Voltdb

what is the format of schema when we create a new table using Voltdb? I'm a newbie. I have researched for a while and read the explanation in this https://docs.voltdb.com/UsingVoltDB/ChapDesignSchema.php Please give me more detal about the schema…
theasker228
  • 153
  • 1
  • 3
  • 9
0
votes
1 answer

Efficient DB solution for system task tracking

I'm currently working on a data tracking system. The system is a multiprocess application written in Python and working in the following manner: every S seconds it selects the N most appropriate tasks from the database (currently Postgres) and…
Severogor
  • 33
  • 5
0
votes
1 answer

Does the community edition of VoltDB support snapshot and recovery?

VoltDB's web site shows that the community edition supports full ACID (which includes the D for durability) but it doesn't look like it supports the crash recovery which seems related to the command logging. Is there a different in the 'D' part of…
litao
  • 3
  • 3
0
votes
1 answer

Split a column into two columns based on filter value in query

Is it possible to split a column into the two columns when executing query based on filter value. For example, given database schema x varchar a integer b 0,1 I can execute a query select x , sum(a) as asum from t group by x That will end up with …
Lol4t0
  • 12,444
  • 4
  • 29
  • 65
0
votes
1 answer

Sqoop export data from voltdb

I'm trying to import data into hive from a votldb table, here is the command I'm using sqoop import --connect jdbc:voltdb://: --driver org.voltdb.jdbc.Driver --password --username --table
MikA
  • 5,184
  • 5
  • 33
  • 42
0
votes
2 answers

Couchbase or VoltDB for billion monitoring data storage and analysis?

I have a distributed monitoring system that collects and gathers monitoring data like CPU utilization, database performance metrics, network performance into a backend store. Other applications need to consume these data like real-time…
nntp
  • 43
  • 1
  • 5
0
votes
1 answer

Minimal configuration for VoltDB to be able to show durability and HA

My exposure to NoSQL or NewSQL/NeoSQL database servers is extremely limited, only theoretical. I've worked with traditional RDBMSs (like MySQL, Postgres) and directory-server (OpenLDAP), with and without replication. My application stack is based on…
bdutta74
  • 2,798
  • 3
  • 31
  • 54
0
votes
1 answer

Fail to export from voltdb to kafka

VoltDB is enterprise 5.1.2 Kafka is 2.9.2-0.8.1.1, also tried 2.10-0.8.2.1 VoltDB is at 192.168.56.101 Kafka is at 192.168.56.102 Here is my deployment configuration for VoltDB:
David
  • 420
  • 2
  • 5
  • 18