dbTalk Databases Forums  

Amazon's "Simple" Database

comp.databases.theory comp.databases.theory


Discuss Amazon's "Simple" Database in the comp.databases.theory forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
JOG
 
Posts: n/a

Default Amazon's "Simple" Database - 12-18-2007 , 05:34 AM






Just wondered if anyone had seen this:

http://www.regdeveloper.co.uk/2007/1...azon_simpledb/

While in principle a globally accessible database sounds like a great
idea, closer reading yields...

"Unlike MySQL, Oracle, DB2 or SQL Server, SimpleDB is not a relational
database server. It is based on the concept of items and attributes.
Two things distinguish it from most relational database managers: 1.
Attributes can have more than one value. 2. Each item can have
different attributes."

Er... Is anyone hearing the letters EAV being raised above google
headquarters in big flashing lights?


Reply With Quote
  #2  
Old   
David Cressey
 
Posts: n/a

Default Re: Amazon's "Simple" Database - 12-18-2007 , 05:52 AM







"JOG" <jog (AT) cs (DOT) nott.ac.uk> wrote


Quote:
While in principle a globally accessible database sounds like a great
idea, closer reading yields...
I wonder. Is it really a "globally accessible database" that is the holy
grail here?
Or is it something more like a "universally accepted data sublanguage"?

The thing that makes XML attractive to some people is not that it would be a
good basis on which to build a dtabase, but that it seems convenient for
data exchange. I shudder at the idea of XML becoming the universal data
sublanguage, but it sure is growing by leaps and bounds.





Reply With Quote
  #3  
Old   
Bob Badour
 
Posts: n/a

Default Re: Amazon's "Simple" Database - 12-18-2007 , 05:53 AM



JOG wrote:

Quote:
Just wondered if anyone had seen this:

http://www.regdeveloper.co.uk/2007/1...azon_simpledb/

While in principle a globally accessible database sounds like a great
idea, closer reading yields...

"Unlike MySQL, Oracle, DB2 or SQL Server, SimpleDB is not a relational
database server. It is based on the concept of items and attributes.
Two things distinguish it from most relational database managers: 1.
Attributes can have more than one value. 2. Each item can have
different attributes."

Er... Is anyone hearing the letters EAV being raised above google
headquarters in big flashing lights?
Why google headquarters? I thought we were talking about Amazon's
SimpleDB not Google's BigTable. http://labs.google.com/papers/bigtable.html


Reply With Quote
  #4  
Old   
Roy Hann
 
Posts: n/a

Default Re: Amazon's "Simple" Database - 12-18-2007 , 06:12 AM



"David Cressey" <cressey73 (AT) verizon (DOT) net> wrote


Quote:
The thing that makes XML attractive to some people is not that it would be
a
good basis on which to build a dtabase, but that it seems convenient for
data exchange.
Is XML actually attractive to significant numbers of people? It seems to me
that no one wants to admit they know little or nothing about it, but they
keep hearing about it and fear they'll seem ignorant and out of touch if
they don't claim to want to use it too. Being in with the in-crowd is what
is attractive; as it always is.

I've got a couple of customers who have found out the hard way that parsing
gargantuan XML documents can kill the biggest systems. Presented with the
option of using schema-based transformation or switching to files of
fixed-width fields they both opted to abandon XML entirely and are delighted
with their new fixed-width field files. Bizarrely, one was using XML to
move data between two machines running identical software.

Awareness of database theory is almost non-existent. Is it hard to believe
that awareness of other technical subjects is equally dire, or worse?

Roy




Reply With Quote
  #5  
Old   
JOG
 
Posts: n/a

Default Re: Amazon's "Simple" Database - 12-18-2007 , 06:55 AM



On Dec 18, 11:53 am, Bob Badour <bbad... (AT) pei (DOT) sympatico.ca> wrote:
Quote:
JOG wrote:
Just wondered if anyone had seen this:

http://www.regdeveloper.co.uk/2007/1...azon_simpledb/

While in principle a globally accessible database sounds like a great
idea, closer reading yields...

"Unlike MySQL, Oracle, DB2 or SQL Server, SimpleDB is not a relational
database server. It is based on the concept of items and attributes.
Two things distinguish it from most relational database managers: 1.
Attributes can have more than one value. 2. Each item can have
different attributes."

Er... Is anyone hearing the letters EAV being raised above google
headquarters in big flashing lights?

Why google headquarters? I thought we were talking about Amazon's
SimpleDB not Google's BigTable.http://labs.google.com/papers/bigtable.html
Now there's a freudian slip on my part if ever I saw one...


Reply With Quote
  #6  
Old   
David Cressey
 
Posts: n/a

Default Re: Amazon's "Simple" Database - 12-18-2007 , 08:03 AM




"JOG" <jog (AT) cs (DOT) nott.ac.uk> wrote

Quote:
On Dec 18, 11:53 am, Bob Badour <bbad... (AT) pei (DOT) sympatico.ca> wrote:
JOG wrote:
Just wondered if anyone had seen this:

http://www.regdeveloper.co.uk/2007/1...azon_simpledb/

While in principle a globally accessible database sounds like a great
idea, closer reading yields...

"Unlike MySQL, Oracle, DB2 or SQL Server, SimpleDB is not a relational
database server. It is based on the concept of items and attributes.
Two things distinguish it from most relational database managers: 1.
Attributes can have more than one value. 2. Each item can have
different attributes."

Er... Is anyone hearing the letters EAV being raised above google
headquarters in big flashing lights?

Why google headquarters? I thought we were talking about Amazon's
SimpleDB not Google's
BigTable.http://labs.google.com/papers/bigtable.html

Now there's a freudian slip on my part if ever I saw one...
I read the comments at the end. At least two commentators said "smells like
xxx" (where xxx is something rde you might do to your nose). I don't want
to mention the actual name for fear of conjuring up an evil spirit.




Reply With Quote
  #7  
Old   
Tegiri Nenashi
 
Posts: n/a

Default Re: Amazon's "Simple" Database - 12-18-2007 , 11:33 AM



On Dec 18, 4:12 am, "Roy Hann" <specia... (AT) processed (DOT) almost.meat>
wrote:
Quote:
I've got a couple of customers who have found out the hard way that parsing
gargantuan XML documents can kill the biggest systems. Presented with the
option of using schema-based transformation or switching to files of
fixed-width fields they both opted to abandon XML entirely and are delighted
with their new fixed-width field files.
Or use XML-complient structure:

<comma_separated_doc>
a,b,c,d
e,f,g,h
....
</comma_separated_doc>

It is much funnier read on the dailywtf.com, but I'm unable to recover
the reference:-)


Reply With Quote
  #8  
Old   
Sampo Syreeni
 
Posts: n/a

Default Re: Amazon's "Simple" Database - 12-19-2007 , 08:38 AM



On 2007-12-18, Roy Hann wrote:

Quote:
The thing that makes XML attractive to some people is not that it
would be a good basis on which to build a dtabase, but that it seems
convenient for data exchange.

Is XML actually attractive to significant numbers of people?
I'd divide the answer into two. For the original use SGML/XML and
related markup languages (like HTML) were meant for, i.e. markup of
running text compatible with plain text editors, they still hold quite a
lot of value.

The match for data is much weaker. The only real value I can find in XML
there is that currently we don't really have a commonly accepted and
implemented format in which to serialize datasets. At least serializing
in-transit ones into a metaformat that all the other people use gives us
some minimal sharing of tools, like parsers, browsers and APIs.
Sometimes we even get to the point of serializing to a proper, shared,
concrete format (say vCal or RSS), so that the compatibility runs
deeper.

But of course that is not how most people use XML; they use it for
everything. Then Bad Things Happen: using XML implies inserting an extra
layer of complexity into your system. Its textual encoding entails
bloat. The rich hierarchical structure which serves text so well invites
all of the usual data modelling mistakes. People worry too much about
the metaformat to lay the proper groundwork for the actual formats. Data
ends up being locked up inside a serialization, when we'd really like
random access. Tying applications to a serialization, i.e. a physical
data format, makes data independence impossible to achieve. And of
course the rest of the big picture, like data language design,
transactional guarantees and integrity still haven't been solved, so
that everybody ends up cooking their own and more often than not getting
it horribly wrong. The list goes on.

XML has its uses. Unfortunately the hype causes people to misapply it.
--
Sampo Syreeni, aka decoy - mailto:decoy (AT) iki (DOT) fi, tel:+358-50-5756111
student/math+cs/helsinki university, http://www.iki.fi/~decoy/front
openpgp: 050985C2/025E D175 ABE5 027C 9494 EEB0 E090 8BA9 0509 85C2


Reply With Quote
  #9  
Old   
Anne & Lynn Wheeler
 
Posts: n/a

Default Re: Amazon's "Simple" Database - 12-19-2007 , 09:55 AM




Sampo Syreeni <decoy (AT) iki (DOT) fi> writes:
Quote:
I'd divide the answer into two. For the original use SGML/XML and
related markup languages (like HTML) were meant for, i.e. markup of
running text compatible with plain text editors, they still hold quite
a lot of value.
i.e. SGML was originally GML before becoming "standard gml" with
ISO standard. GML
http://www.garlic.com/~lynn/subtopic.html#sgml

was invented at the science center in '69
http://www.garlic.com/~lynn/subtopic.html#545tech

(G, M, and L, are the inventors initial motivated requirement for
acronym with those letters) ... at the time, somewhat motivated by the
need for use in legal documents.
http://xml.coverpages.org/sgmlhist0.html

science center was also responsible for virtual machine implementation
and a lot of timesharing and interactive related applications.

the original documentation formater developed at the science center was
called *script*, used "dot" formating commands ... somewhat similar
to earlier implementation done for ctss
http://en.wikipedia.org/wiki/RUNOFF
and
http://mit.edu/Saltzer/www/publications/CC-244.html

aka some of the ctss people went to the science center on 4th flr of 545
tech sq and some went to multics on 5th flr.

the initial "gml" implementation was done by adding gml tags to script
document formater.

cern was also a large virtual machine implementation ... using various
applications ... including a script clone written by univ. of waterloo.
this talks about evolution from sgml into html:
http://infomesh.net/html/history/early

the first webserver outside of europe was on the virtual machine
system at slac (slac and cern shared a lot of software)
http://www.slac.stanford.edu/history.../history.shtml

the science center's virtual machine implementation was also
used at sjr for the original relational/sql implementation
http://www.garlic.com/~lynn/subtopic.html#systemr


Reply With Quote
  #10  
Old   
Lon Stowell
 
Posts: n/a

Default Re: Amazon's "Simple" Database - 12-21-2007 , 07:56 PM



Anne & Lynn Wheeler wrote:
Quote:
Sampo Syreeni <decoy (AT) iki (DOT) fi> writes:
I'd divide the answer into two. For the original use SGML/XML and
related markup languages (like HTML) were meant for, i.e. markup of
running text compatible with plain text editors, they still hold quite
a lot of value.

i.e. SGML was originally GML before becoming "standard gml" with
ISO standard. GML
http://www.garlic.com/~lynn/subtopic.html#sgml

was invented at the science center in '69
http://www.garlic.com/~lynn/subtopic.html#545tech

(G, M, and L, are the inventors initial motivated requirement for
acronym with those letters) ... at the time, somewhat motivated by the
need for use in legal documents.
http://xml.coverpages.org/sgmlhist0.html
Ah, I get misty eyed reading about GML, SGML and remembering SNADS,
DISOSS and the Common Suppository.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.