SQL: All content tagged as SQL in NoSQL databases and polyglot persistence
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.
Original title and link: SQL Over HBase With Phoenix ( ©myNoSQL)
Felix Lin sent me a link to the slides he presented at NoSQL Taiwan meetup. There are 105 of them!
The deck covers:
- how to build a simple social site using SQL
- what are the performance issues with SQL
- how to use the data structures in Redis for getting the same features
- how to solve the performance issues in SQL by using Redis
Check them up after the break:
Great decision flowchart created by Aaron Cordova to help answer the question: what tools should I use to process my data:
Original title and link: SQL or Hadoop: What Tools Should I Use to Process My Data? ( ©myNoSQL)
Inspired by the MongoDB MapReduce translated to SQL and Neo4j Cypher Querying for SQL People, MarkLogic’s Jason Hunter and Eric Bloch put together a page mapping SQL terms and queries to MarkLogix terms and XQuery queries respectively.
Here is how SQL statements translate to MarkLogic XQuery expressions: