Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2007-12-18
2007-12-18
Vital, Pierre (Department: 2169)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000
Reexamination Certificate
active
10959737
ABSTRACT:
To efficiently process a parameterized query against a relational database in a streaming transaction processing system, the transaction stream is treated as a sequence of multi-record “chunks” and a single “quasi-batch” query is executed for each chunk. A specific table in the database holds the parameter values obtained from each transaction and the parameters are bound to the rest of the query by using a database join. Another embodiment uses a framework that automates the technique by accepting the parameterized query, identifying inputs and outputs, reading the stream for the parameter values and building the parameter table, converting the parameterized query into an equivalent query that contains a join against the parameter table, performing the equivalent query and inserting the resulting query values into the stream.
REFERENCES:
patent: 6560606 (2003-05-01), Young
patent: 6782394 (2004-08-01), Landeck et al.
patent: 6934727 (2005-08-01), Berkowitz et al.
Hanlon et al. “Publish/Subscribe in NonStop SQL: Transactional Streams in a Relational Context”, Data Engineering, 2004, pp. 821-824.
Bei et al. “A Direct Method of Data Exchange Between XML and Relational Database”, Information Technology Interfaces, 2004, vol. 1, pp. 127-132.
Garcia et al. “Microsoft SQL Server TM 2000 Administrator's Companion”, Microsoft Press, Sep. 27, 2000, Chapter 21 and 22.
“XML—Extensibe Markup Language”, Wikipedia, the free encyclopedia.
Hanlon et al. “Publish/Subscribe in NonStop SQL : Transactional Streams in a Relational Context”, Data Engineering, 2004, pp. 821-824.
Bei et al. “A Direct Method of Data Exchange Between XML and Relational Database”, Information Technology Interfaces, 2004, vol. 1, pp. 127-132.
Garcia et al. “Microsoft SQL Server TM 2000 Administrator's Companion”, Microsoft Press, Sep. 27, 2000, Chapter 21 and 22.
“XML—Extensible Markup Language”, Wikipedia, the free encyclopedia, last updated 2007.
Choi Yuk
Law Offices of Paul E. Kudirka
Metra tech
Vital Pierre
LandOfFree
Method and apparatus for efficiently processing queries in a... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Method and apparatus for efficiently processing queries in a..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and apparatus for efficiently processing queries in a... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-3861360