Back to results
US 11,106,816 B2Granted
Database public interface
AssigneeSap SE
InventorsPeter Eberlein, Volker Driesen, Arne Harren
Life of this patent
Estimating the term…
Abstract
Methods, systems, and computer program products for accessing a database element are described. A local schema comprising a table link is created and the table link is used to access a database table via a persistency interface.
Claims15
A method for upgrading a first application, the method comprising:
- querying, using at least one of one or more hardware processors, a landscape directory for metadata associated with the first application, the first application having a first persistency stored at a first schema of a database system;
- determining, using at least one of the one or more hardware processors and the metadata, one or more dependent applications that are dependent on the first application, the one or more dependent applications comprising a second application having a second persistency stored at a second schema of the database system;
- determining, using at least one of the one or more hardware processors, one or more persistency interfaces for the first application that are used by the one or more dependent applications, wherein a first persistency interface of the one or more persistency interfaces comprises a first table link, the first table link comprising an updateable projection view of a first table of the first schema in the second schema;
- determining, using at least one of the one or more hardware processors, that a first version of the first schema is compatible with an upgraded version of the first schema at least in part by determining that an upgraded version of the first persistency interface associated with the upgraded version of the first schema can be accessed by the second application without revision to the second application;
- upgrading the first application to an upgraded first application configured to use the upgraded version of the first schema, the upgrading comprising modifying the first schema from the first version to the upgraded version of the first schema to generate an upgraded first schema at least in part by revising the first table;
- after upgrading the first application, receiving from the second application a request to perform an operation on the updatable projection view;
- and
- responsive to the request, executing the operation on the first table at the upgraded first schema using the first table link.
5 more elements
An apparatus for upgrading a first application, the apparatus comprising:
- one or more hardware processors;
- memory to store instructions that, when executed by the one or more hardware processors, perform operations comprising:
- querying a landscape directory for metadata associated with the first application, the first application having a first persistency stored at a first schema of a database system;
- determining, using the metadata, one or more dependent applications that are dependent on the first application, the one or more dependent applications comprising a second application having a second persistency stored at a second schema of the database system;
- determining one or more persistency interfaces defined for the first application that are used by the one or more dependent applications, wherein a first persistency interface of the one or more persistency interfaces comprises a first table link, the first table link comprising an updateable projection view of a first table of the first schema in the second schema;
- and
- determining that a first version of the first schema is compatible with an upgraded version of the first schema at least in part by determining that an upgraded version of the first persistency interface associated with the upgraded version of the first schema can be accessed by the second application without revision to the second application;
- upgrading the first application to an upgraded first application configured to use the upgraded version of the first schema, the upgrading comprising modifying the first schema from the first version to the upgraded version of the first schema to generate an upgraded first schema at least in part by revising the first table;
- after upgrading the first application, receiving from the second application a request to perform an operation on the updatable projection view;
- and
- responsive to the request, executing the operation on the first table at the upgraded first schema using the first table link.
8 more elements
A non-transitory machine-readable medium comprising instructions thereon that, when executed by one or more hardware processors, cause the one or more hardware processors to execution operations comprising:
- querying a landscape directory for metadata associated with a first application, the first application having a first persistency stored at a first schema of a database system;
- determining, use the metadata, one or more dependent applications that are dependent on the first application, the one or more dependent applications comprising a second application having a second persistency stored at a second schema of the database system;
- determining one or more persistency interfaces defined for the first application that are used by the one or more dependent applications, wherein a first persistency interface of the one or more persistency interfaces comprises a first table link;
- the first table link comprising an updateable projection view of a first table of the first schema in the second schema;
- determining that a an upgraded version of the first schema includes an upgraded first persistency interface that is compatible with the first persistency interface at least in part by determining that the upgraded version of the first persistency interface can be accessed by the second application without revision to the second application;
- and
- upgrading the first application to an upgraded first application configured to use the upgraded version of the first schema, the upgrading comprising modifying the first schema from the first version to the upgraded version of the first schema to generate an upgraded first schema at least in part by revising the first table;
- after updating the first application, receiving from the second application a request to perform an operation on the updatable projection view;
- and
- responsive to the request, executing the operation on the first table at the upgraded first schema using the first table link.
7 more elements
Dependencies are inferred from the claim text.