JSON: All content tagged as JSON in NoSQL databases and polyglot persistence
Thursday, 11 April 2013
PosgreSQL as a Schemaless Database
A very interesting set of slides from Christophe Pettus looking at the features in PosgreSQL that would allow one to use it as a document database:
- XML
- built-in type
- can handle very large documents (2GB)
- XPath support
- export functions
- no indexing, except defining custom ones using expression index
- hstore
- hierarchical storage type
- in contrib (not part of the core)
- custom functions (nb: very ugly syntax imo)
- GiST and GIN indexes (nb: I’ve posted in the past about PostgreSQL GiST and GIN Index Types)
- supports also expression indexes
- JSON
- built-in type starting with PostgreSQL 9.2
- validates JSON
- support expression indexing
- nothing else besides a lot of feature scheduled for
Christophe Pettus’s slides also include the results and some thoughts about a locally-run pseudo-benchmark against these engines and MongoDB.
You can see all the slides and download them after the break.
Original title and link: PosgreSQL as a Schemaless Database (©myNoSQL)
Monday, 1 October 2012
Google BigQuery Adds Support for JSON Import and Hierarchical Data
Besides performance and quota changes, Google BigQuery adds support for importing JSON data and nested/repeated fields:
If you’re using App Engine Datastore or other NoSQL databases, it’s likely you’re taking advantage of nested and repeated data in your data model. For example, a customer data entity might have multiple accounts, each storing a list of invoices. Now, instead of having to flatten that data, you can keep your data in a hierarchical format when you import to BigQuery.
Original title and link: Google BigQuery Adds Support for JSON Import and Hierarchical Data (©myNoSQL)
via: http://googleenterprise.blogspot.com/2012/10/google-bigquery-updates-faster-easier.html
JSONiq: The JSON Query Language
The long time reader William Candillon of 28msec send me a link to JSONiq - The JSON Query Language, a group initiative to bring XQuery-like queriability to JSON:
Our goal in the JSONiq group, is to put the maturity of XQuery to work with JSON data. JSONiq is an open extension of the XQuery data model and syntax to support JSON.
After reading and experimenting a bit with JSONiq my initial thought is that while it looks interesting, it feels like an XMLish complicated query language that doesn’t really reflect the simplicity and philosophy of JSON.
let $stats := db:find("stats")
for $access in $stats
group by $url := $access("url")
return {
"url": $url,
"avg": avg($access("response_time")),
"hits": count($access)
}What do you think?
Original title and link: JSONiq: The JSON Query Language (©myNoSQL)
Wednesday, 15 June 2011
Jaql: Query Language for JSON in IBM InfoSphere BigInsights
jaql was created and is used by IBM InfoSphere BigInsights—the IBM Apache Hadoop distribution:
Jaql’s query language was inspired by many programming and query languages that include: Lisp, SQL, XQuery, and PigLatin. Jaql is a functional, declarative query language that is designed to process large data sets. For parallelism, Jaql rewrites high-level queries when appropriate into a “low-level” query consisting of Map-Reduce jobs that are evaluated using the Apache Hadoop project. Interestingly, the query rewriter produces valid Jaql queries which illustrates a departure from the rigid, declarative-only approach (but with hints!) of most relational databases. Instead, developers can interact with the “low-level” queries if needed and can add in their own low-level functionality such as indexed access or hash-based joins that are missing from Map-Reduce platforms.
Original title and link: Jaql: Query Language for JSON in IBM InfoSphere BigInsights (NoSQL database©myNoSQL)
Wednesday, 23 February 2011
Pig Latin and JSON on Amazon Elastic Map Reduce
In order to not have to learn everything about setting up Hadoop and still have the ability to leverage the power of Hadoop’s distributed data processing framework and not have to learn how to write map reduce jobs and … (this could go on for a while so I’ll just stop here). For all these reasons, I choose to use Amazon’s Elastic Map infrastructure and Pig.
I will talk you through how I was able to do all this [take my log data stored on S3 (which is in compressed JSON format) and run queries against it] with a little help from the Pig community and a lot of late nights. I will also provide an example Pig script detailing a little about how I deal with my logs (which are admittedly slightly abnormal).
Sadly such an useful tool in the Hadoop ecosystem doesn’t make the headlines.
Original title and link: Pig Latin and JSON on Amazon Elastic Map Reduce (NoSQL databases © myNoSQL)
Monday, 22 November 2010
MongoDB Impressions
I’ve spent the past three days diving into MongoDB and jQuery. [ …] But the real attraction is the ability to work with syntax very similar to Javascript and JSON from client to server to database. Just better for my relatively weak, pan-fried brain.
Let’s not forget though, that MongoDB is BSON so you’ll need to go through a native driver. But there are other NoSQL databases that speak natively JSON (e.g. CouchDB) and that may not even need a server side component.
Original title and link: MongoDB Impressions (NoSQL databases © myNoSQL)
via: http://charliecrystle.com/2010/11/22/mongodb-impressions/
Wednesday, 28 July 2010
ColdFusion's Flawed JSON and NoSQL databases
It’s kind of difficult to understand why they cannot get JSON right:
Now the surprise: ColdFusion 9.0.1 says goodbye to the number format in JSON. All numbers in JSON will become strings once ColdFusion gets its hand on the data. There are no more numbers. 10 becomes “10”, 10.2 becomes “10.2” etc. Even though the patch notes stated that differently. And i still believe it was not Adobe’s intention to remove numbers but somehow this flawed implementation slipped in.
As the author puts it:
ColdFusion 9.0.1 is essentially disqualified to be used with NoSQL datastores where JSON is involved.
via: http://coldfusion.tcs.de/adobe-please-fix-coldfusion-serializejson/
