[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]
Subject: RE: [ubl-dev] UBL and a functional SQL schema
We find the UBL schema's extremely complicated, the thought of modeling them in a relational database makes me want to run screaming into the night. We store the UBL as XML in a CLOB/BLOB column and then choose a few key reference fields to extract into relational tables for us to do look ups. This allows us to find the xml, extract it and then work with it. This works for us for literally millions of records a week. -----Original Message----- From: Tim McGrath [mailto:tmcgrath@portcomm.com.au] Sent: Thursday, 24 February 2005 4:07 PM To: alex black Cc: Chin Chee-Kai; ubl-dev@lists.oasis-open.org Subject: Re: [ubl-dev] UBL and a functional SQL schema maybe i am missing something here but if i were trying to create a database for storing information taken from UBL documents, i would start by building tables and attributes based on the UBL document component model. This is the relational model used to create all the hierarchical document assembly models (and their XML schemas). In the component model each object class is a table/entity and every attribute is an attribute/column. there is no need to re-engineer a relational model from the UBL document schemas. in fact if someone where to develop a set of SQL naming and design rules for UBL then these SQL/rdbms schemas could be built automatically from the UBL models (similar to how the XML schemas are built). alex black wrote: >> Are you looking for the RDBMS table schema, or are you >> looking for the program codes to update the database >> (which would assume that the former exists)? >> Tel: +65-6820-2979 >> Fax: +65-6743-7875 >> Email: cheekai@SoftML.Net >> http://SoftML.Net/ > > > I'm looking for a schema that someone has done based on UBL 1.0. > > If someone has some great little open source app and would like a > contributor - and it's PHP or python - great, but the schema as a > starter is what I'm looking for. > > Of course, I can design my own, but no point doing it if someone else > has gone to the trouble. Also - in thinking about implementations > throughout the world - that is the natural question of any experienced > pro who is building a system for a client: where's the SQL file > (schema) as a starting point so I can store this stuff in a set of > tables? XML Databases aren't production ready, and what limited > looking I've done at XQuery shows it to be.. good but not really > "there". Also if I'm doing anything else that related to the UBL docs > it's nice to have a DB :) > > thanks for any advice! > > _alex > > -- regards tim mcgrath phone: +618 93352228 postal: po box 1289 fremantle western australia 6160 DOCUMENT ENGINEERING: Analyzing and Designing Documents for Business Informatics and Web Services (coming soon from MIT Press) http://mitpress.mit.edu/catalog/item/default.asp?sid=632C40AB-4E94-4930-A94E -22FF8CA5641F&ttype=2&tid=10476
[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]