JDBC: All content tagged as JDBC in NoSQL databases and polyglot persistence
Thursday, 31 January 2013
SQL Over HBase With Phoenix
Released by the Salesforce team, Phoenix adds a SQL layer on top of HBase and an almost complete JDBC driver.
Direct use of the HBase API, along with coprocessors and custom filters, results in performance on the order of milliseconds for small queries, or seconds for tens of millions of rows.
The project already has a page about the performance and the results are looking great. For a bullet list summary, check out James Taylor’s post.
Original title and link: SQL Over HBase With Phoenix (©myNoSQL)
Thursday, 24 May 2012
Using R With Cassandra Through JDBC or Hive
A short post by Jake Luciani listing 2 R modules—RJDBC module and RCassandra—that enable using R with Cassandra through either the JDBC or Hive drivers.
This is a good example of what I meant by designing products with openness and integration in mind.
Original title and link: Using R With Cassandra Through JDBC or Hive (©myNoSQL)
via: http://www.datastax.com/dev/blog/big-analytics-with-r-cassandra-and-hive
Tuesday, 20 December 2011
Neo4j Gets Experimental JDBC Driver
Neo4j getting a JDBC driver before MongoDB is a surprise[1]. Rickard Öberg:
When it comes to NOSQL databases, one of the key advantages is that they allow you to structure your data in a way that better resembles your domain, and also allows you to use query languages where you can express things that are either really awkward or slow with SQL. However, one of the advantages that relational databases have is that they can be accessed from lots of tools using JDBC, as a standard API. So what would happen if a NOSQL database, like Neo4j, also had a JDBC driver? I decided to find out!
If this catches up, the next step is adding a non-HTTP protocol to Neo4j server.
-
MongoDB is the NoSQL database with the richest querying model which resembles SQL. ↩
Original title and link: Neo4j Gets Experimental JDBC Driver (©myNoSQL)
via: http://rickardoberg.wordpress.com/2011/12/19/creating-a-jdbc-driver-for-neo4j/
