view · edit · sidebar · attach · print · history

<< DatenBeschrieb | Index | >>

Export ChDe.xls and http://ch.oddb.org

The proposed architecture for comparing prices between ch.oddb.org and de.oddb.org is to create a standalone read-only service, which provides remote-access (from within the local network) to the data in ch.oddb.org in a separate process.

                          +--------------------------------------------+
                          |                                            |
+-------------+  +------------------+  +---------------------+  +-------------+
| ch.oddb.org |  | readonly-service |--| export-job chde.xls |  | de.oddb.org |
+-------------+  +------------------+  +---------------------+  +-------------+
       |                  |                        |                   |
+-----------------------------------+  +--------------------------------------+
|            postgres db            |  |              postgres db             |
|           "oddb_dot_org"          |  |                 "oddb"               |
+-----------------------------------+  +--------------------------------------+

replacing the current architecture, which looks like this:

         +------------------------------------------+
         |                                          |
+----------------+  +---------------------+  +-------------+
|  ch.oddb.org   |--| export-job chde.xls |  | de.oddb.org |
+----------------+  +---------------------+  +-------------+
         |                    |                   |
+----------------+  +--------------------------------------+
|  postgres db   |  |              postgres db             |
| "oddb_dot_org" |  |                 "oddb"               |
+----------------+  +--------------------------------------+

Aus meiner Sicht haben wir zu keinem Zeitpunkt menschlich lesbare Daten - Excel ist binär, dann sind die Daten als (binäre) Ruby-Objekte im Memory, dann werden sie serialisiert und in die DB geschrieben - in binärer Form.

Marshalling and unmarshalling of Data can be found here: http://en.wikipedia.org/wiki/Serialization#Ruby

view · edit · sidebar · attach · print · history
Page last modified on January 27, 2012, at 05:08 PM