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

Unable to upload data even after partitioning in VoltDB

We are trying to upload 80 GB of data in 2 host servers each with 48 GB RAM(in total 96GB). We have partitioned table too. But even after partitioning, we are able to upload data only upto 10 GB. In VMC interface, we checked the size worksheet. The…
1
vote
1 answer

Error on VoltDB: HTTP service unable to bind to port 8080. Exiting

I use a mac. And I installed VoltDB and compile CREATE sentence but, the error "HTTP service unable to bind to port 8080. Exiting." has occurred. My installed flow is below: brew install voltdb vim users.sql -> CREATE TABLE users ( user_id…
tbt
  • 399
  • 3
  • 16
1
vote
1 answer

How to load csv file into voltDB?

I'm very new to voltDB, how to load CSV file into voltDB table? I tried this command: (sqlcmd> csvloader testing -f '/home/ex.csv';) ..but I receive the following error: Unexpected Ad Hoc Planning Error: java.lang.RuntimeException: Error …
user8731721
1
vote
1 answer

How to setUp environment in eclipse to create VoltDB Stored Procedure?

I have read about VoltDB and its stored procedure(java) from its website(quick good documentation). I want to create java Stored Procedure and started with jar (voltdbclient-7.7.jar from maven) but there are some files missing to compile the stored…
c.sankhala
  • 850
  • 13
  • 27
1
vote
1 answer

@AdHoc procedure not executing multiple statements

I am unable to run tow SQL queries in a single transaction. Here is my query: DROP TABLE DevicePing IF EXISTS; CREATE TABLE DevicePing (DeviceId INTEGER ,RideId BIGINT ,Latitude FLOAT ,Longitude FLOAT ,Speed FLOAT ,Bearing FLOAT ,Angle FLOAT…
Suresh Prajapati
  • 3,991
  • 5
  • 26
  • 38
1
vote
1 answer

Is Voltdb supported by Ruby on Rails?

Can I use Voltdb with Ruby on Rails?
Pranoti
  • 11
  • 1
  • 4
1
vote
1 answer

Which data structures are used in voltdb

In Voltdb, which data structures are used to store data when we make a query? For example, with query insert into <> value(X,X,X), How the is data actually stored in the memory.
theasker228
  • 153
  • 1
  • 3
  • 9
1
vote
1 answer

Are voltdb default procedures partitioned?

Voltdb creates set of default procedures on tables with primary keys (like HELLO_WORLD.insert, HELLO_WORLD.upsert, HELLO_WORLD.delete etc). Are these procedures partitioned if my HELLO_WORLD table is partitioned? . I couldn't find any documentation…
Shamith Kumar
  • 13
  • 1
  • 3
1
vote
1 answer

Accessing VoltDB from Python

Hi all I need to write a custom script in Python which will fetch data from one server and insert to another physical server even DB may be different like one will be Netezza other one will be Postgres/VoltDB .Everything is working fine except the…
Anoop R
  • 545
  • 3
  • 8
  • 19
1
vote
1 answer

VoltDB or MongoDB for short time data storage?

I have a requirement to store some huge collection of data just until I consume it. For example, I download a file(a csv probably, which can be some hundreds of MB) and store its contents in a db. After the whole file's written to db, another…
Shashank
  • 297
  • 3
  • 13
1
vote
1 answer

VoltDB Timeout for createConnection

Below is a simple code snippet that shows how to connect to a VoltDB server. ClientConfig clientConfig = new ClientConfig(); Client client = ClientFactory.createClient(clientConfig); String server =…
David
  • 420
  • 2
  • 5
  • 18
1
vote
2 answers

how can I list all procedures in voltdb?

I want to find that what procedure I have defined before, so how can I list all procedures in voltdb? which cmd should I use?
roger
  • 9,063
  • 20
  • 72
  • 119
1
vote
1 answer

Does VoltDB use compression?

I reckon that VoltDB uses compression but I'm not sure about that. Mike Stonebraker, who is the main creator of VoltDB, used to work on Vertica, which uses compression heavily. I heard about a case when somebody loaded a few GB of sequential…
ady
  • 1,108
  • 13
  • 19
1
vote
1 answer

Debugging VOLT DB Stored Procedure

I have voltdb installed in a remote machine. I would like to know how I can debug a stored procedure I write. To be specific I would like to see the values of different variables at different points of time. Is there any logging mechanism or…
Nikhil Titus
  • 244
  • 1
  • 3
  • 8
1
vote
1 answer

Enterprise Data warehouse with NOSQL /Hadoop - "NO RDBMS"

Are there any EDW (enterprise data warehouse) systems designed using NOSQL/Hadoop solution ? I know there are PDW systems(MS PDW polybase, Greenplum hawq etc) which connect to HDFS sub-systems. These are proprietary hardware and software solutions…