Michael, > >> 1. Incorporate the data exchange fields within the Object tables >> (certificate, csr, ca_certificate etc). > > This is a real problem because you must alter the database for every > node which you add too the hierarchy. The problem is that some database > has limits related to columns and the total size of a column. > > The major issue is that I don't like dynamic database schemas. A > database schema should not depend on changes of the content.
I was not thinking of a dynamic schema, I was thinking of something like this... Each Object table would have a field "Exchange" the field would initially be populated as "0000000000" (in this example there are 10 nodes represented by each digit). If the record had been exported to node 1 then the Exchange field would be modified to "0000000001". Where "1" means exported. When the Node 1 returns the data exchange file and it says that it has received the record, the data exchange routine could modify the record to "0000000002" where "2" means imported to node. If we then get the CA to export to node 2, the record would be modified to "0000000012". I am sure there is a better way than this method, but there must be a simple way to get the field in the single record without the table structure dynamically changing. What do you think ? >> 4. The data exchange routine only then needs a single query (per object >> type) to determin if an export is required, rather then the cross table >> query. > > The design from yesterday needs only a single query too. Only the > maintenance command needs more time and the maintenance command is no > longer needed (after your idea from yesterday). Yes, true. > None of both, it is more a question of personal preference - dynamic > schema vs. statical schema and more rows. hopefully a better method than the one described above would overcome the need for a dynamic schema, extra tables and more rows... Chris... ------------------------------------------------------- SF.Net email is sponsored by: Discover Easy Linux Migration Strategies from IBM. Find simple to follow Roadmaps, straightforward articles, informative Webcasts and more! Get everything you need to get up to speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click _______________________________________________ OpenCA-Devel mailing list OpenCA-Devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/openca-devel
