System, method and article of manufacture for fast mapping from a propertied document management system to a relational database

A computer program embodied on a computer readable medium for mapping properties of a document to a relational database, comprising:

• (a) a code segment that provides a database having a plurality of tables relating to a plurality property groups, wherein each property group has a set of properties associated therewith;
• (b) a code segment that creates one or more documents having zero or more properties;
• (c) a code segment that determines which of the property groups apply to the one or more documents;
• (d) a code segment that maps the properties of the one or more documents to those tables in the database which include a property group that has been determined to apply to the one or more documents;
• and
• (e) a code segment that dynamically alters the mapping of the properties to the tables of the database.

A system for mapping properties of a document to a relational database, comprising:

• (a) logic that provides a database having a plurality of tables relating to a plurality property groups, wherein each property group has a set of properties associated therewith, wherein property groups having at least one common property with one another are grouped into a common table in the database, property groups having no common properties are grouped into separate tables in the database;
• (b) logic that a document having zero or more properties;
• (c) logic that determines which of the property groups apply to the document;
• (d) logic that maps the properties of the document to those tables in the database which include a property group that has been determined to apply to the document;
• and
• (e) logic that dynamically alters the mapping of the properties.