System and method for reporting multiple objects in enterprise content management

摘要

Systems and methods for multi-object reporting in a content management system. A report type definition may define which objects are involved and how they are related. A report execution engine may generate a multi-object query language statement to translate the report type definition into query language. A query language execution engine may break the query language statement down into separate single pieces. A cost optimization engine may determine if it is cost efficient to join the objects. An indexed access execution engine may extract unique IDs of the objects and join the unique IDs to generate an index. A Lucene based search engine may be accessed according to the index, and the response is post processed to generate a multi-object report.

主权项

1. A computer-implemented method for reporting multiple objects in a content management system, the method comprising:
storing a plurality of objects in a storage device; receiving a report type definition which defines a first object and a second object and a relationship between the first and second objects; generating a multi-object query language statement for the report type definition; dissecting the multi-object query language statement into a first query and a second query, wherein the first query corresponds to the first object, and the second query corresponds to the second object; generating an indexed access query definition for the first and second queries; and extracting ID of the first object corresponding to the first query in the indexed access query definition and ID of the second object corresponding to the second query in the indexed access query definition.