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

Schema concept in VoltDB

I am not very sure, but seems in VoltDB, there is no such concept like "Schema" in MySQL, which is a logical database instance, so can group logically related tables and stored procedures etc together. Any idea why it is so?
David
  • 420
  • 2
  • 5
  • 18
0
votes
1 answer

VoltDB does not support transaction?

I am connecting to a VoltDB enterprise instance through JDBC driver. However, it does not support transaction control. When I call conn.commit or rollback, it throwsjava.sql.SQLFeatureNotSupportedException. Any thoughts?
David
  • 420
  • 2
  • 5
  • 18
0
votes
1 answer

VoltDB - decimal values have too many zeroes

when I try to add a decimal value to a column in voltdb, it always adds extra zeroes to the decimal. The column type is DECIMAL, which equates to Java's BigDecimal type. Even if I format the BigDecimal value in java to a two decimal place…
Alan Smith
  • 1,069
  • 4
  • 19
  • 23
0
votes
1 answer

VOLTDB ERROR: USER ABORT

I am using voltdb-5.0.2 and starting database as voltdb create --zookeeper portno I have loaded a procedure from java class in voltdb.The procedure takes arguments - tableName , columnName and integer value . This is the error on sqlcmd line - when…
0
votes
1 answer

Does VoltDB compress data on disk?

I am curious whether VoltDB compresses the data on disk/at rest. If it does, what is the algorithm used and are there options for 3rd party compression methods (e.g. a loss permitted proprietary video stream compression algorithm)?
Arthur
  • 1,441
  • 1
  • 13
  • 17
0
votes
2 answers

Why is data loading to voltdb slow?

What is the fastest way to load data into voltdb. I'm using the recommended command: csvloader in the form: $ csvloader helloworld -f languages.csv but the loading time is very long. Why is it slow?
ady
  • 1,108
  • 13
  • 19
0
votes
1 answer

Error while trying to run an andhoc insert query using voltQueueSQLExperimental

I am getting an error while trying to execute a dynamic insert query in volt db using the voltQueueSQLExperimental() function. The SQL is fine as i ran it separately on the volt web studio. The error is as follows: Error: VOLTDB ERROR: USER ABORT…
Nikhil Titus
  • 244
  • 1
  • 3
  • 8
0
votes
1 answer

Getting an error after running a select query in a stored procedure in voltdb

I am getting a run time error when I run a select query in Volt DB stored procedure. When I run the select query in volt DB web studio everything is fine. The error is as follows: Error: VOLTDB ERROR: UNEXPECTED FAILURE: java.lang.RuntimeException:…
Nikhil Titus
  • 244
  • 1
  • 3
  • 8
0
votes
1 answer

creating table in volt-db using jdbc

Is it possible to create a table in voltdb in memory database after it is started I am trying to create a table in volt-db using JDBC getting java.sql.SQLException: Invalid SQL statement type. below is my program String driver =…
Count
  • 1,395
  • 2
  • 19
  • 40
0
votes
1 answer

Migrating from Oracle to VoltDB

We are migrating from Oracle to VoltDB, should we put all the business logic (the migrated stored procedures) inside the database? Is that the best practice for maximum performance?
chila
  • 2,372
  • 1
  • 16
  • 33
0
votes
2 answers

VoltDB voter resultSet has columns but no rows

The VoltDB package has an example setup called 'voter.' I'm running that on the server and trying to work with it in Java. I am able to create a ResultSet with Statement.executeQuery and "SELECT * FROM voter;" it has the correct columns…
Lateral
  • 41
  • 6
0
votes
1 answer

how to make a array query in voltDB?

Is it possible to have an array column in voltDB or to query a nested array in json type column? For exapmle is it possible to do a query: Find rows where array contains a value. In other words array [1,2,3,4] array [2,3,4,5] array [3,4,5,6] And…
twboc
  • 1,452
  • 13
  • 17
0
votes
2 answers

Do voltDB or NuoDB need ElasticSearch?

Currently I am working in a project that use PostgreSQL + ElasticSearch. However I recently found VoltDB, and I was wondering if we still need ElasticSearch for doing searches with VoltDB. If I am ok, elasticSearch get the data from PostgreSQL of…
Luis Vargas
  • 2,466
  • 2
  • 15
  • 32
0
votes
2 answers

how to start voltDB on runtime

currently I start voltDB by terminal command I want to know that, is there any option for start voltDB on runtime by using JSON interface or PHP . Thank you
M_A_K
  • 378
  • 3
  • 16
0
votes
1 answer

Installation VoltDB on MAC

Can anyone help me for installation voltDB on MAC system i am trying to install it using instruction but get error Cannot find config.m4. Make sure that you run '/usr/bin/phpize' in the top level source directory of the module I spent a couple of…
M_A_K
  • 378
  • 3
  • 16
1 2 3
10
11