PATENT CLAIM ANALYSIS

Application Number: 16050172
Application Type: Utility
Filing Date: 2018-07
Publication Date: 2018-12
Patent Classification: ["726", "022000"]

Abstract:
Securing invocation of stored procedures is provided herein. A first database management system (DBMS) can include a first database with first tables, a first user management module configured to manage privileges of database users (DB-users) of the first DBMS, and at least one first stored procedure. A second DBMS can include a second database with second tables, a second user management module configured to manage privileges of DB-users of the second DBMS, and at least one second stored procedure, the at least one second stored procedure configured to perform a computational task in the second DBMS. A synchronization mapping can map at least a portion of the first tables to respective ones of the second tables. Thus, a transfer of data of at least some of the first tables to the respective ones of the second tables in accordance with the synchronization-mapping can be performed.

Claim (Index 1):
A system, comprising:\n a first database management system (DBMS) comprising:\n a processor, \n a memory, \n a first database with a plurality of first tables, \n a first user management module configured to manage and check privileges of database users (DB-users) of the first DBMS, and \n at least one first stored procedure; \n a second DBMS comprising: \n a second database with a plurality of second tables, \n a second user management module configured to manage and check privileges of DB-users of the second DBMS, and \n at least one second stored procedure, \n the at least one second stored procedure configured to perform a computational task in the second DBMS; and \n a synchronization mapping configured to map at least a portion of the first tables to respective ones of the second tables, the system being configured for transferring data of at least some of the first tables to the respective ones of the second tables in accordance with the synchronization-mapping, wherein names of the one or more of the plurality of first tables acting as the input or output tables of the at least one first stored procedure are specified in a request as parameter values to be used as input parameters for the at least one first stored procedure or specified in the code of the at least one first stored procedure, wherein the system is configured to:\n install a describe stored procedure in the second DBMS, the describe stored procedure being a non-trusted stored procedure; \n create the second DB-user in the second DBMS, the second DB-user not having access to any one of the second tables and being permitted to call the describe stored procedure; \n call the describe stored procedure to provide parameter values of the request as input for the describe stored procedure; \n parse, via the describe stored procedure, the provided parameter values; \n output a list of the identified first table names and corresponding roles as an input or output table in a generic syntax; and \n transfer the list and the corresponding roles from the second DBMS to the first DBMS to enable the first DBMS or the at least one first stored procedure to identify the privilege information of the first DB-user with respect to the one or more of the plurality of first tables.

Metadata:
- Claim Count in Document: 50.0
- Percentile: 95.0
- Lexical Diversity: 2.85714
- Patent Class: 726.0
- Transitional Phrase Type: open
- Component Type: 1
- Foreign Priority: True
- Related Applications: ['16050209', '14951936', '15270301', '14715662', '15398956']

Analysis Scores:
- 35 USC 101 Eligibility (BERT): 0.3050301089113089
- 35 USC 102 Novelty (BERT): 0.5188646324326323
- Combined Prediction Score: 0.3264135612634412
- Mean Citation Score: 267.980234
- Max Citation Score: 348.0476
- Similarity Product: 346.5721768213511

Labels:
- Claim Label 101: 1
- Claim Label 102: 1
- Claim Label 103: 1
- Claim Label 112: 1
- Combined Label: 1
- Label 101 Adjusted: 1

Dataset: test