Dynamically Joined Fast Search Views for Business Objects

• US 20120030189A1
• Filed: 07/30/2010
• Published: 02/02/2012
• Est. Priority Date: 07/30/2010
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP SE
• Inventors: Vossen, Oliver, Müller, Martin, Wintel, Maic
• Granted Patent: US 9,053,151 B2
• Time in Patent Office: Days
• US Class Current: 707/711
• CPC Class Codes: G06F 16/2445 Data retrieval commands; View definitions
• CPC Class Codes: G06F 16/2456 Join operations
• CPC Class Codes: G06F 16/24561 Intermediate data storage techniques for performance improvement

Abstract

According to some embodiments, an anchor transactional view may be defined for at least one business object data structure. The anchor transactional may have a plurality of anchor fields, each anchor field representing a data source and being associated with a field of an anchor search view. An indication of at least one extension field to the anchor search view may be received. The anchor search view and at least one extension field may represent, for example, a virtual fast search infrastructure view. Responsive to the received indication of the at least one extension field, an additional view may be dynamically joined at runtime to the anchor transactional view. The additional view may have at least one additional field, and each additional field may be associated with one of the extension fields.

Claims

1. A computer implemented method, comprising:

defining an anchor transactional view for at least one business object data structure, the anchor transactional view having a plurality of anchor fields, each anchor field representing a data source and being associated with a field of an anchor search view;

receiving an indication of at least one extension field to the anchor search view, the anchor search view and at least one extension field representing a virtual fast search infrastructure view; and

responsive to the received indication of the at least one extension field, dynamically joining at runtime an additional view to the anchor transactional view, the additional view having at least one additional field, wherein each additional field is associated with one of the extension fields.

2. The method of claim 1, wherein the additional view comprises a master data view.

3. The method of claim 1, wherein a plurality of master data views are dynamically joined at runtime to the anchor transactional view.

4. The method of claim 1, further comprising:

passing a list of views and respective join conditions to a view execution interface at runtime.

5. The method of claim 1, further comprising:

directly calculating join paths for all of the extension fields at run time.

8. The method of claim 1, further comprising:

dynamically creating an in-memory logical index on a search engine at runtime in response to an initialization call;

creating a result data structure; and

passing the result data structure as a data reference.

9. The method of claim 8, further comprising:

including the result data structure in a call to a dynamic join execution, wherein the call further includes at least one of;

(i) a selection condition, (ii) sorting criteria, or (iii) constrain parameters.

10. The method of claim 9, further comprising:

generating a report based at least in part on information in the result data structure.

11. The method of claim 1, further comprising:

for each of the extension fields, dynamically defining, at run time, an alias to reference the extension field.

7. The method of claim 6, further comprising:

determining via a caching mechanism whether or not the join paths have already been calculated and stored into a buffer such that multiple calls to the same dynamically joined view will not result in re-calculation of join paths.

12. A computer-readable medium storing program code executable by a computer to:

define an anchor transactional view for at least one business object data structure, the anchor transactional view having a plurality of anchor fields, each anchor field representing a data source and being associated with a field of an anchor search view;

receive an indication of at least one extension field to the anchor search view, the anchor search view and at least one extension field representing a virtual fast search infrastructure view; and

responsive to the received indication of the at least one extension field, dynamically join at runtime an additional view to the anchor transactional view, the additional view having at least one additional field, wherein each additional field is associated with one of the extension fields.

13. The medium of claim 12, wherein the additional view comprises a master data view.

14. The medium of claim 12, wherein a plurality of master data views are dynamically joined at runtime to the anchor transactional view.

15. The medium of claim 12, further comprising:

passing a list of views and respective join conditions to a view execution interface at runtime.

16. A system associated with an anchor transactional view for at least one business object data structure, the anchor transactional view having a plurality of anchor fields, each anchor field representing a data source and being associated with a field of an anchor search view, comprising:

an enterprise service infrastructure;

a fast search infrastructure in communication with the enterprise service infrastructure, wherein the fast search infrastructure is to;

receive an indication of at least one extension field to the anchor search view, the anchor search view and at least one extension field representing a virtual fast search infrastructure view, and

dynamically join at runtime an additional view to the anchor transactional view, the additional view having at least one additional field, wherein each additional field is associated with one of the extension fields; and

a search engine in communication with the fast search infrastructure to execute a search in accordance with the dynamically joined views and to output a search result.

17. The system of claim 16, wherein the additional view comprises a master data view.

18. The system of claim 17, wherein a plurality of master data views are dynamically joined at runtime to the anchor transactional view.

19. The system of claim 16, wherein join paths for all of the extension fields are dynamically calculated at run time.

20. The system of claim 19, further comprising:

a caching mechanism to determine whether or not the join paths have already been calculated and stored into a buffer such that multiple calls to the same dynamically joined view will not result in re-calculation of join paths.

21. The system of claim 16, wherein an in-memory logical index is dynamically created on said search engine at runtime in response to an initialization call.

22. The system of claim 16, wherein an alias is dynamically defined for each of the extension fields at run time to reference the extension field.