Skip site navigation (1) Skip section navigation (2)

Re: Major features for 9.1

From: Andrew Lardinois <lardinois(at)gmail(dot)com>
To: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: josh(at)agliodbs(dot)com, gilberto(dot)castillo(at)etecsa(dot)cu, peter_e(at)gmx(dot)net, pgsql-advocacy(at)postgresql(dot)org
Subject: Re: Major features for 9.1
Date: 2011-04-05 08:32:45
Message-ID: BANLkTimzX2TZOkFvKuHoyg=erUDQzZn25g@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-advocacy
I could go on finding random articles with some content about serialization
all night. Instead I had a peek at what some other databases have to say
about serialization / SSI:
SEARCHING MYSQL.COM ORACLE.COM COUCHDB
SSI                        X 60 X
SERIALIZATION                X lots 3
UPSERT                X lots X

>From oracle.com
http://labs.oracle.com/techrep/1996/smli_tr-96-57.pdf#search="SSI" see page
2, but this paper is titled
"Solaris MC File System Framework" which makes me think it is operating
system specific.

Regarding oracle on serialization, search results seem to be about specific
products, i.e. Oracle Pedigree, or just object oriented serialization. Not
database transactions specifically.

NoSQL...
There is a 'load a serialized object in hadoop' thread in hadoop
http://search-hadoop.com/?q=ssi

There is also an apache project called avro which is 'a data serialization
system'
http://avro.apache.org/
This does not seem to be a database specifically, but avro joined apache in
2009, so presumably has been around for pior to that.
It is worth noting that avro is built with JSON.

Seems like the the most confusion about serialization in the database would
come from Amazon, the cloud, and Amazon's simpledb in particular.
There is documentation that uses serialization:
"Policy -- the JSON serialization of the topic's access control policy" at:
http://docs.amazonwebservices.com/sns/latest/api/index.html?API_GetTopicAttributesResult.html

Should note too that the couchdb project uses native JSON serialization.

It is surprising how much JSON "an ideal data-interchange language" (from
json.org) turns up in other database technologies.
This sounds a lot more like XML to me than how relational database store and
manage data.

Valorizing knowledge capital,
Andrew Lardinois

In response to

pgsql-advocacy by date

Next:From: Oleg BartunovDate: 2011-04-05 09:36:28
Subject: Re: Major features for 9.1
Previous:From: Kevin GrittnerDate: 2011-04-04 21:56:53
Subject: Re: Major features for 9.1

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group