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

VoltProcedure.call()--TypeError: an interger is required for Python2.7 Decimal datatype

Here is my code: from voltdbclient import * from decimal import * client = FastSerializer("s7biapp26", 21212) proc = VoltProcedure(client, "test2_insert", [FastSerializer.VOLTTYPE_DECIMAL]) proc.call([Decimal(129)]) client.close() This code can…
Ckll
  • 17
  • 4
0
votes
1 answer

Data and Index Storage in Voltdb

Sorry for beginner question, but I was wondering how is data and indexes stored in voltdb? I've read a lot of documentation and papers from voltdb about how tables are partitioned and replicated and stored at the high level, but how does VoltDB…
0
votes
1 answer

Logging inside a VoltProcedure

I want to log some infos from inside my VoltProcedures but there is no logger in the VoltProcedure abstract class. I found this question explaining that the best way is to insert data into that table. The answer is from 2015 so I wondered if there…
sid802
  • 315
  • 2
  • 18
0
votes
1 answer

why the default delete and update procedure of voltdb on specified table not work

I use the default procedure generated by voltdb to update the below table, schema: create table sys_sec_user_org_role( user_id bigint not null, org_id integer not…
S.Richard
  • 25
  • 3
0
votes
1 answer

VoltDB - Writing your own client or using JSON HTTP Interface

I am a bit confused in how should I perform my operation using VoltDB. There are two choice - Run VoltDB server, create a connection from the client and call your required procedure. JSON HTTP Interface provided by the VoltDB itself. I have…
Suresh Prajapati
  • 3,991
  • 5
  • 26
  • 38
0
votes
0 answers

Converting Voltdb data to dataset in spark

I wrote a code which will directly load the data from mysql to dataset format Dataset sourceDataView = spark.read().format("jdbc") .option("url", url).option("driver", driver) .option("dbtable",…
0
votes
1 answer

Execute voltdb query from nodejs client

I am trying to develop voltdb client in nodejs and have gone through voltdb-client-nodejs. The code very well explains how to call stored-procedures from nodejs client. However, I would like to know how can I run simple insert/read query without…
Suresh Prajapati
  • 3,991
  • 5
  • 26
  • 38
0
votes
1 answer

What is the equivalent query for 'NOT IN' in Volt DB?

What is the equivalent query for 'NOT IN' in Volt DB?
0
votes
1 answer

Buildfile:build.xml does not exist

I have installed Ant as i could use ant -version where it shows Apache Ant(TM) version 1.10.1 compiled on February 2 2017.i use Ubuntu 16.04 ,After I decompress voltdb,modify environment variables ,in terminal,import Ant.then the problem…
zhaofanqi
  • 1
  • 1
0
votes
1 answer

Why not publish the voltdb.jar to maven repo?

I only found that the voltdb client in the maven repo, but not fount the voltdb which contains the VoltProcedure. It will be hard for me to manage the dependencies with maven, gradle or other tools. Is there any deep reason for that? voltdb guys.
Angle Tom
  • 1,060
  • 1
  • 11
  • 29
0
votes
1 answer

Voltdb node failed when the RAM is about 10G

I am trying to use voltdb. The capacity of the vm is 16U with 32G RAM. But I specified the xmx with 6G. The node failed when I trying to dump data into the voltdb. I calculated the size of the data following the official document. it is about 500M.…
Angle Tom
  • 1,060
  • 1
  • 11
  • 29
0
votes
3 answers

does performance of an in-memory database depend on whether it is written in c++ or java

We are trying to find an in-memory database with index support that we can use for our application. We are looking at Aerospike, Apache Ignite, Geode, Voltdb. There is not much to distinguish and every one claims to be fast and have great community…
Tuco
  • 712
  • 2
  • 8
  • 20
0
votes
1 answer

Custom importer for binary encoding

Thanks voldDb for providing amazing in-memory capabilities, and fast view of live streaming data using stream and view. I am trying to build my custom importer which can use to stream binary data directly to the voltdb procedures. I have created…
nishant pathak
  • 342
  • 1
  • 4
  • 17
0
votes
2 answers

Voltdb - Kafka Importer - Change delimiter used to import

I have a kafka topic delimited by ";" and I want to import to a voltdb table. I did not find in the official documentation anything about change the delimiter. The Kafka Importer (https://docs.voltdb.com/UsingVoltDB/exportimportkafka.php), give me…
0
votes
2 answers

How to save tables permanently in voltdb community edition?

I am using volt db community edition and I am creating the tables in volt db database. Once I restart the server all tables stored in database are deleted. How to save the tables permanently in volt db database using command line?
Nayaz JH
  • 27
  • 1
  • 6