Invention Grant
US08572108B2 Method and system for specifying, preparing and using parameterized database queries
有权
用于指定,准备和使用参数化数据库查询的方法和系统
- Patent Title: Method and system for specifying, preparing and using parameterized database queries
- Patent Title (中): 用于指定,准备和使用参数化数据库查询的方法和系统
-
Application No.: US13542497Application Date: 2012-07-05
-
Publication No.: US08572108B2Publication Date: 2013-10-29
- Inventor: Joseph Wong
- Applicant: Joseph Wong
- Applicant Address: IE Dublin
- Assignee: Business Objects Software Ltd.
- Current Assignee: Business Objects Software Ltd.
- Current Assignee Address: IE Dublin
- Agency: Schwegman Lundberg & Woessner, P.A.
- Main IPC: G06F7/00
- IPC: G06F7/00 ; G06F17/30

Abstract:
A representative parameterized query in a second database query language is generated from a parameterized query in first database query language. By randomly generating a query in the first database query language, translating this query into the second database query language, and then identifying locations of relevant parameters in the translated query, parameter placeholders can then be substituted at the identified locations to provide a parameterized query in the second database query language. A representative parameterized query in the second database query language can be selected by randomly generating multiple parameterized queries and applying statistical methods including Monte Carlo methods.
Public/Granted literature
- US20130066890A1 METHOD AND SYSTEM FOR SPECIFYING, PREPARING AND USING PARAMETERIZED DATABASE QUERIES Public/Granted day:2013-03-14
Information query