What is it?
P-Store is a simple read-optimized database system. The command line tool
pstore implements two commands:
cat. The former can be used to
convert a CSV file into a P-Store database and the latter can be used to
examine contents of the database.
The design of this system is loosely based on C-Store which is another Open Source read-optimized database. The main idea is to store tabular data in column-order to improve read performance for special purpose workloads.
P-Store is in very early stages so don't expect a whole lot from it.
How can I try it out?
The first step is to create a database file. You can import a CSV file into a P-Store database with the following command:
$ pstore import dataset.csv dataset.out
After that, you can use the
pstore cat command to look into the imported
$ pstore cat dataset.out
pstore import --append you can append more data into a P-Store database:
$ pstore import --append moredata.csv dataset.out
Running the integration tests
When you have both Ruby 1.9 and Bundler, install P-Store's dependencies:
$ bundle install
Then run the integration tests:
$ make check
Java Native Interface
P-Store provides an API for the Java programming language. To build the JNI API
of the P-Store you will need to set
JAVA_HOME enviroment variable.
For example on Mac OS X: