Back to results
US 10,650,028 B2Granted
Relational database instruction validation
Assigneesalesforce.com, inc.
InventorsJesse Collins, Xuerong Tang
Life of this patent
Estimating the term…
Abstract
In an example, a database system may be configured to validate relational database instructions using a plurality of validators. In some examples, validation may be pre-production for relational database instructions based on simulated user inputs and/or file, such as plan files (e.g., PL/SQL (procedural language/structured query language) files). In some examples, validation may be in production for relational database instructions based on system views of a database engine.
Claims24
A database system, comprising:
- a processing system;
- and
- a memory device coupled to the processing system and including instructions stored thereon that, in response to execution by the processing system, are operable to:
- at a scheduled time, access a current system view of a relational database;
- extract a relational database instruction from the current system view;
- determine whether the extracted relational database instruction corresponds to any relational database instructions of any previously accessed system views of the relational database;
- based on a result of the determination, analyze the extracted relational database instruction by inputting the extracted relational database instruction into a validation module;
- wherein the validation module includes validators configured to parse structured query language text into a parse tree to identify elements in the parse tree, the validators further configured to employ rule-based validation responsive to identification of the elements in the parse tree and with respect to the elements, wherein the rule-based validation is based on requirements of a database engine of the relational database;
- and
- store a result of the analysis in a memory device.
7 more elements
A method, comprising:
- accessing a current system view of a relational database;
- extracting a relational database instruction from the current system view;
- determining whether the extracted relational database instruction corresponds to any relational database instructions of any previously accessed system views of the relational database;
- based on a result of the determining, analyzing the extracted relational database instruction by inputting the extracted relational database instruction into a validation module, including:
- parsing structured query language text into a parse tree to identify elements in the parse tree;
- and
- employing rule-based validation responsive to identification of the elements in the parse tree and with respect to the elements, wherein the rule-based validation is based on requirements of a database engine of the relational database;
- and
- storing a result of the analyzing in a memory device.
6 more elements
Dependencies are inferred from the claim text.