# US 2012/0084319 A1 · Master data management database asset as a web service > Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt - Number: US 2012/0084319 A1 - Document ID: US20120084319A1 - Status: Published application - Kind: A1 - Application number: 13/250,716 - Filed: 2011-09-30 - Published: 2012-04-05 - Earliest claimed: 2010-09-30 - Assignees: Teradata US, Inc. - Inventors: NEELESH V. BANSODE; THOMAS K. RYAN; SHASHANK SHEKHAR - Web page: https://patentgrep.com/patent/US20120084319A1 ## CPC - G06F 16/252: {between a Database Management System and a front-end application} - G06F 16/21: Design, administration or maintenance of databases - G06Q 10/0633: Workflow analysis - G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N) - G06Q: INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR ## Abstract A method, system, apparatus, and article of manufacture is configured to expose a database asset as a web service. A relational database management system (RDBMS) that stores information is executed in a computer system. As part of a process and framework, a series of business rules and process workflows are maintained that manage data that resides in RDBMS tables. A rule is created that contains an application programming interface definition with predefined input and output for exposing the database asset as the web service. The rule is exposed as the web service. The web service is used to invoke a database operation based on the database asset, and to output a result. ## Claims ### Claim 1 A computer-implemented method for exposing a database asset as a web service, comprising: (a) executing a relational database management system (RDBMS) that stores information in a computer system; (b) maintaining, as part of a process and framework, a series of business rules and process workflows to manage data that resides in one or more RDBMS tables; (c) creating, via the process and framework, a rule that contains an application programming interface (API) definition with predefined input and output for exposing the database asset from the RDBMS as the web service; (d) exposing, via the process and framework, the rule as the web service; and (e) utilizing, via the process and framework, the web service to invoke a database operation based on the database asset, and to output a result. ### Claim 2 (depends on 1) The method of claim 1, wherein the creating comprises selecting the database asset from the RDBMS to be exposed as the web service by receiving user input. ### Claim 3 (depends on 1) The method of claim 1 wherein the database asset comprises a query. ### Claim 4 (depends on 3) The method of claim 3 further comprising providing a managed query user interface to define the query and a parameter for the query. ### Claim 5 (depends on 4) The method of claim 4 wherein the managed query user interface limits exposed functionality to provide security. ### Claim 6 (depends on 1) The method of claim 1 wherein the database asset comprises a stored procedure and the predefined input comprises received input that defines parameters for a name of the stored procedure and input/output parameters. ### Claim 7 (depends on 1) The method of claim 1 wherein the output is in extensible markup language (XML) format. ### Claim 8 (depends on 1) The method of claim 1 wherein the web service is used to invoke the database operation by: converting a request received via the web service into a readable format; a rule engine performing the database operation using the request to obtain the result; the rule engine converting the result to a client format; and outputting the client format to a client. ### Claim 9 An apparatus for exposing a database asset as a web service, comprising: (a) a relational database management system (RDBMS) executing in a computer system; (b) a master data management system configured to maintain, as part of a process and framework, a series of business rules and process workflows to manage data that resides in one or more tables in the RDBMS; (c) a rule, that has been created as via the process and framework, wherein: (i) the rule contains an application programming interface (API) definition with predefined input and output for exposing the database asset from the RDBMS as the web service; (ii) the rule is exposed, via the process and framework, as the web service; and (iii) the web service is utilized, via the process and framework, to invoke a database operation based on the database asset, and to output a result. ### Claim 10 (depends on 9) The apparatus of claim 9, wherein the rule is created by selecting the database asset from the RDBMS to be exposed as the web service by receiving user input. ### Claim 11 (depends on 9) The apparatus of claim 9 wherein the database asset comprises a query. ### Claim 12 (depends on 11) The apparatus of claim 11 further comprising a managed query user interface that is used to define the query and a parameter for the query. ### Claim 13 (depends on 12) The apparatus of claim 12 wherein the managed query user interface limits exposed functionality to provide security. ### Claim 14 (depends on 9) The apparatus of claim 9 wherein the database asset comprises a stored procedure and the predefined input comprises received input that defines parameters for a name of the stored procedure and input/output parameters. ### Claim 15 (depends on 9) The apparatus of claim 9 wherein the output is in extensible markup language (XML) format. ### Claim 16 (depends on 9) The apparatus of claim 9 wherein the web service is used to invoke the database operation by: converting a request received via the web service into a readable format; a rule engine performing the database operation using the request to obtain the result; the rule engine converting the result to a client format; and outputting the client format to a client.