System and method for generating SQL using templates

Data processing: database and file management or data structures – Database and file access – Record – file – and data search and comparisons

Reexamination Certificate

Rate now

  [ 0.00 ] – not rated yet Voters 0   Comments 0

Details

C707S808000

Reexamination Certificate

active

07831614

ABSTRACT:
A method for generating a structured query language (SQL) script based on a template includes selecting one object from a plurality of objects in a data model. At least one instruction is selected based, at least in part, on a type of the selected object and, then, an associated template string is selected based on each selected instruction. At least a portion of a SQL script is automatically generated based on the one or more selected template strings.

REFERENCES:
patent: 5295256 (1994-03-01), Bapat
patent: 5640550 (1997-06-01), Coker
patent: 5649139 (1997-07-01), Weinreb et al.
patent: 5664173 (1997-09-01), Fast
patent: 5909678 (1999-06-01), Bergman et al.
patent: 6105043 (2000-08-01), Francisco et al.
patent: 6115703 (2000-09-01), Bireley et al.
patent: 6748374 (2004-06-01), Madan et al.
patent: 2002/0095397 (2002-07-01), Koskas
patent: 2003/0074651 (2003-04-01), Allison
patent: 2003/0225888 (2003-12-01), Wason
patent: 2004/0078359 (2004-04-01), Bolognese et al.
patent: 2004/0139061 (2004-07-01), Colossi et al.
patent: 2004/0205587 (2004-10-01), Draper
patent: 2005/0193269 (2005-09-01), Haswell et al.
“Sybase,”Sybase PowerDesigner 9.5 Highlights, 2 pages, <http://www.sybase.com/detail/printthis/1,6907,1016578,00.html>, visited Jul. 26, 2004.
European Patent Office Communication Pursuant to Article 94(3) EPC; Application No. 04 756 813.4-2201; Ref. 4503; Applicant: Computer Associates Think, Inc., Apr. 28, 2009.
“Programmable Syntax Macros”, by Daniel Weise and Roger Crew; Microsoft Research Laboratory; XP 000380808, Jun. 28, 1993.

LandOfFree

Say what you really think

Search LandOfFree.com for the USA inventors and patents. Rate them and share your experience with other people.

Rating

System and method for generating SQL using templates does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with System and method for generating SQL using templates, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and System and method for generating SQL using templates will most certainly appreciate the feedback.

Rate now

     

Profile ID: LFUS-PAI-O-4250090

  Search
All data on this website is collected from public sources. Our data reflects the most accurate information available at the time of publication.