Global Dictionary for Database Management Systems

    公开(公告)号:US20210117413A1

    公开(公告)日:2021-04-22

    申请号:US17133037

    申请日:2020-12-23

    Applicant: SAP SE

    Inventor: Toni Fabijancic

    Abstract: A global dictionary is described that corresponds to a database or table stored across multiple partitions. The global dictionary can be used to identify which partitions of the database contain records that are relevant to a user's query on the database. The global dictionary is made up of variable tables. Each variable table corresponds to a column of the database. A given variable table includes value tables where each value table corresponds to a defined value that has been assigned to a record in the database. A value table can include a list of partitions that contain a record having the related defined value.

    Shared database dictionaries
    2.
    发明授权

    公开(公告)号:US10311029B2

    公开(公告)日:2019-06-04

    申请号:US15397961

    申请日:2017-01-04

    Applicant: SAP SE

    Abstract: A system includes determination of a match between a first table column of a plurality of table columns of database tables and a second table column of the plurality of table columns, determination, based on stored metadata, of a first data dictionary associated with the first table column and a second data dictionary associated with the second table column, merging of the first data dictionary and the second data dictionary to generate a merged data dictionary, and modification of the stored metadata to associate the first data dictionary with the merged data dictionary and to associate the second data dictionary with the merged data dictionary.

    AUTOMATED SYSTEM DATA MIGRATION
    3.
    发明申请

    公开(公告)号:US20190108223A1

    公开(公告)日:2019-04-11

    申请号:US15728226

    申请日:2017-10-09

    Applicant: SAP SE

    Abstract: Technologies are provided for capturing information during a data migration and to use the captured information to generate data migration artefacts that can be used in subsequent data migrations. Artificial intelligence techniques can be used to analyze the captured data migration information and to generate a data migration model that can be used to create the data migration artefacts. Changes made to the data migration artefacts can be tracked and used to train the data migration model. Additionally or alternatively, during execution of the subsequent data migration, additional data migration information can be captured and used to train the data migration model. The captured data migration activity can include data access operations such as data transactions, system log activity, and/or source code for one or more data migration programs and/or scripts. Computer system version information can be detected and different migration artefacts can be created for different computer system versions.

    SHARED DATABASE DICTIONARIES
    4.
    发明申请

    公开(公告)号:US20180189331A1

    公开(公告)日:2018-07-05

    申请号:US15397961

    申请日:2017-01-04

    Applicant: SAP SE

    CPC classification number: G06F17/30294 G06F17/30339

    Abstract: A system includes determination of a match between a first table column of a plurality of table columns of database tables and a second table column of the plurality of table columns, determination, based on stored metadata, of a first data dictionary associated with the first table column and a second data dictionary associated with the second table column, merging of the first data dictionary and the second data dictionary to generate a merged data dictionary, and modification of the stored metadata to associate the first data dictionary with the merged data dictionary and to associate the second data dictionary with the merged data dictionary.

    Cross-System Configuration Checks
    5.
    发明公开

    公开(公告)号:US20230350747A1

    公开(公告)日:2023-11-02

    申请号:US17730560

    申请日:2022-04-27

    Applicant: SAP SE

    CPC classification number: G06F11/08 G06F16/902 G06F11/1658 G06F16/258

    Abstract: Embodiments perform configuration checking between data types of table fields, in order to determine mismatches therebetween. A configuration check request including a parameter identifying a system is received. A first data type is retrieved based upon the parameter. The first data type is compared with a second, different retrieved data type to determine a mismatch. In some embodiments the first data type and the second data type may be retrieved from different systems, with the mismatch revealing inter-system inconsistency. According to certain embodiments, the first data type and the second data type may be retrieved from a same system, with the mismatch revealing intra-system inconsistency. A configuration check report is generated from the mismatch and communicated to a user, for use in proactively correcting inconsistency. Embodiments may also retrieve values of the data types, as part of value help functionality.

    Global dictionary for database management systems

    公开(公告)号:US11514039B2

    公开(公告)日:2022-11-29

    申请号:US17133037

    申请日:2020-12-23

    Applicant: SAP SE

    Inventor: Toni Fabijancic

    Abstract: A global dictionary is described that corresponds to a database or table stored across multiple partitions. The global dictionary can be used to identify which partitions of the database contain records that are relevant to a user's query on the database. The global dictionary is made up of variable tables. Each variable table corresponds to a column of the database. A given variable table includes value tables where each value table corresponds to a defined value that has been assigned to a record in the database. A value table can include a list of partitions that contain a record having the related defined value.

    Generation of automated data migration model

    公开(公告)号:US11269822B2

    公开(公告)日:2022-03-08

    申请号:US15728226

    申请日:2017-10-09

    Applicant: SAP SE

    Abstract: Technologies are provided for capturing information during a data migration and to use the captured information to generate data migration artefacts that can be used in subsequent data migrations. Artificial intelligence techniques can be used to analyze the captured data migration information and to generate a data migration model that can be used to create the data migration artefacts. Changes made to the data migration artefacts can be tracked and used to train the data migration model. Additionally or alternatively, during execution of the subsequent data migration, additional data migration information can be captured and used to train the data migration model. The captured data migration activity can include data access operations such as data transactions, system log activity, and/or source code for one or more data migration programs and/or scripts. Computer system version information can be detected and different migration artefacts can be created for different computer system versions.

    INTEGRATED UNIVERSAL FILE CONVERTER
    8.
    发明申请

    公开(公告)号:US20190266255A1

    公开(公告)日:2019-08-29

    申请号:US15903800

    申请日:2018-02-23

    Applicant: SAP SE

    Abstract: Universal, automatic file conversion may be provided by a universal file conversion system or application. An input file may be received by the universal file conversion system. An input file type for the input file and a recipient of the input file may be determined. Programs available to the recipient for accessing a file may be determined. A target file type accessible to the recipient may be determined for converting the input file. A sequence of file conversions to convert the input file to the target file type may be determined. The input file may be converted to the target file type based on the sequence of file conversions. The converted file may be provided to the recipient. The recipient may return the converted file, and the converted file may be automatically converted back to the original input file type and provided to the original source of the input file.

    Global dictionary for database management systems

    公开(公告)号:US11514040B2

    公开(公告)日:2022-11-29

    申请号:US17133077

    申请日:2020-12-23

    Applicant: SAP SE

    Inventor: Toni Fabijancic

    Abstract: A global dictionary is described that corresponds to a database or table stored across multiple partitions. The global dictionary can be used to identify which partitions of the database contain records that are relevant to a user's query on the database. The global dictionary is made up of variable tables. Each variable table corresponds to a column of the database. A given variable table includes value tables where each value table corresponds to a defined value that has been assigned to a record in the database. A value table can include a list of partitions that contain a record having the related defined value.

    Automated root cause detection using data flow analysis

    公开(公告)号:US10452515B2

    公开(公告)日:2019-10-22

    申请号:US15615057

    申请日:2017-06-06

    Applicant: SAP SE

    Abstract: Disclosed herein are system, method, and computer program product embodiments for error root cause detection. An embodiment operates by a computer implemented method that includes receiving, by at least one processor, a request to determine a root cause of an error associated with a code and executing a first execution path and a second execution path, where the first and second execution paths correspond to the code. The method further includes determining whether a difference between first data generated by the execution of the first execution path and second data generated by the execution of the second execution path affects the error associated with the code. The method also includes identifying a code component that contributed to the difference between the first data and the second data, if the difference between the first data and the second data affects the error associated with the code.

Patent Agency Ranking