SimpleDB query by attribute name

Question

I don't know if this is possible or not with simpledb. I am trying to use following a type of simplified data structure.

• Each element has several name / value pairs (the name here is the attribute name) for example

  item1
    serial_num → value
  item2
    serial_num → value

• so many elements are in the domain and there are several such domains.

I want to request something like:

select * from domain where attribute-name = 'serial number'

To get all the items associated with one serial number, through multiple items and domains; Is it possible?

My second question is about using a combination of fields as element names.

for example in the above structure,

Foo_datetime
            serial -> value

Foo1_datetime
            serial -> value

And then I would request elements between a specific datetime range and perticular Foo or Foo1? sort of

 select * from domain where itemname = 'Foo' and itemname > datetime and itemname < datetime.

Answer 1

, , , , , * "select serial_num", . SimpleDB SQL. . . , . , , .

, . "itemName()" . , , :

select * from domain where itemName() between 'Foodatetime1' and 'Foodatetime2'

1 2 .

Answer 2

Mocky : SimpleDB / . , 2010-1-22, ISO 8601.