US 12,067,015 B2
Technique for accessing archive data stored in relational databases through the SAP archive information system
Maximilian Ralph Peter von und zu Liechtenstein, Douglas (IM); and Peter Rudolf Schoenenberger, Kreuzlingen (CH)
Assigned to Business Mobile AG, Kreuzlingen (CH)
Filed by Business Mobile AG, Kreuzlingen (CH)
Filed on Jan. 10, 2022, as Appl. No. 17/572,515.
Application 17/572,515 is a continuation of application No. 17/063,134, filed on Oct. 5, 2020, granted, now 11,222,021.
Prior Publication US 2022/0318251 A1, Oct. 6, 2022
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 16/24 (2019.01); G06F 16/22 (2019.01); G06F 16/242 (2019.01); G06F 16/2455 (2019.01); G06F 16/28 (2019.01)
CPC G06F 16/24561 (2019.01) [G06F 16/22 (2019.01); G06F 16/2433 (2019.01); G06F 16/24552 (2019.01); G06F 16/284 (2019.01)] 6 Claims
OG exemplary drawing
 
1. A computer-implemented method for performing a joint serial-access and relational-access archive search through a single interface, the method comprising:
receiving a search request for archive objects, wherein said archive objects are instances of an archiving object, wherein an archiving object is a business object which comprises a plurality of tables linked to a single header table and wherein said business object is linked to an archive infostructure, wherein an archive infostructure is a structure which comprises a primary key, an identifier for an archive file and an offset within said archive file;
sending a first query to a database, wherein said first query comprises said search request and wherein said query is a relational query, wherein said first query comprises one or more keys from said archive infostructure, and wherein said first query is targeted at a database table and wherein said database table is a header table of said archive infostructure;
sending a second query to an archive index, wherein said second query comprises said search request and wherein said archive index is a table wherein said table comprises one or more rows of said archive infostructure; and
filling an in-memory table with results of said first query and with results of said second query, wherein said in-memory table is a table of said archive infostructure.