Mapping non-relational database objects into a relational database model
AssigneeBusiness Objects Software Ltd.
InventorsXiaohui Xue, Mokrane Amzal, Mythili Gopalakrishnan
Life of this patent
Estimating the term…
Abstract
According to some embodiments, information may be received about a non-relational database object, such as an InfoSet, InfoSet query, or Advanced Business Application Programming (“ABAP”) function for an enterprise resource planning system. The non-relational database object may then be mapped into a relational database model, such as a model associated with a business intelligence platform. As a result, Structured Query Language (“SQL”) inputs from a business intelligence platform may be used create reports based on information in an enterprise resource planning system.
Claims20
A computer implemented method, the method comprising:
- receiving information about a non-relational database object having a plurality of import parameters and a plurality of export parameters, wherein the non-relational database object represents an Advanced Business Application Programming (“ABAP”) function;
- and
- mapping the ABAP function into a relational database model by:
- flattening at least one multi-field import parameter into a set of single-field import parameters,
- flattening at least one multi-field export parameter into a set of single-field export parameters, and
- creating a first table containing a column for:
- (i) each import parameter, including the set of single-field import parameters, (ii) each export parameter, including the set of single-field export parameters, and (iii) an attribute identifier.
A system comprising:
- an interface to receive a structured query language input associated with a non-relational data source from an end user;
- and
- a structured query language engine, coupled to the interface, to:
- (i) translate the input into calls to the non-relational data source based at least in part on a querying object type associated with the input, and (ii) forward the translated calls to the non-relational data source.
A non-transitory, computer-readable medium storing program code executable by a computer processor to perform a method, wherein execution of the code causes the computer processor to:
- receive information about a non-relational database object having a plurality of fields, wherein the non-relational database object represents one of an InfoSet or an InfoSet query;
- create a table associated with the non-relational database object;
- and
- map the non-relational database object into a relational database model by mapping each field to an input column of the table.
Dependencies are inferred from the claim text.