Apparatus, system, and method for efficiently supporting generic SQL data manipulation statements

Apparatus, system, and method for efficiently supporting generic SQL data manipulation statements

An apparatus, system, and method are disclosed for efficiently supporting generic SQL data manipulation statements. The method includes determining whether an SQL statement includes extended indicator parameters such as DEFAULT and UNASSIGNED indicators. The method further includes delaying an autho...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Hauptverfasser: Cotner, Curt L, Farrar, Christopher M, Miller, Robert T, Weihrauch, Maryela E
Format: Patent
Sprache:eng
Online-Zugang:Volltext bestellen
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
container_end_page
container_issue
container_start_page
container_title
container_volume
creator Cotner, Curt L
Farrar, Christopher M
Miller, Robert T
Weihrauch, Maryela E
description An apparatus, system, and method are disclosed for efficiently supporting generic SQL data manipulation statements. The method includes determining whether an SQL statement includes extended indicator parameters such as DEFAULT and UNASSIGNED indicators. The method further includes delaying an authorization check for an operation for an SQL statement using extended indicators, and bypassing an SQL exception where an otherwise unauthorized operation involves an UNASSIGNED variable. The method further includes bypassing a database operation such as a referential integrity check where a data change would induce the database operation, but the data change involves an UNASSIGNED variable. The method further includes modifying the SQL statement when the SQL statement involves an UNASSIGNED variable in a predicate clause, allowing the SQL statement to properly execute.
format Patent
fullrecord <record><control><sourceid>uspatents_EFH</sourceid><recordid>TN_cdi_uspatents_grants_07716213</recordid><sourceformat>XML</sourceformat><sourcesystem>PC</sourcesystem><sourcerecordid>07716213</sourcerecordid><originalsourceid>FETCH-uspatents_grants_077162133</originalsourceid><addsrcrecordid>eNqNzD0KAjEQhuE0FqLeYQ6wguuCW4soFjaivQybSQzkj8yk2NsbwQNYvc3zfUuFx5yxoFTugGcWCh1g1BBI3kmDSQXIGDc5iuJn4JpzKuKiBUuRipvgcb-BRkEIGF2uHsWlCCzYvtqI12ph0DNtfl0puJyfp-u2cm6miZct-M1uHPvDvh-GP8gH0SY-4g</addsrcrecordid><sourcetype>Open Access Repository</sourcetype><iscdi>true</iscdi><recordtype>patent</recordtype></control><display><type>patent</type><title>Apparatus, system, and method for efficiently supporting generic SQL data manipulation statements</title><source>USPTO Issued Patents</source><creator>Cotner, Curt L ; Farrar, Christopher M ; Miller, Robert T ; Weihrauch, Maryela E</creator><creatorcontrib>Cotner, Curt L ; Farrar, Christopher M ; Miller, Robert T ; Weihrauch, Maryela E ; International Business Machines Corporation</creatorcontrib><description>An apparatus, system, and method are disclosed for efficiently supporting generic SQL data manipulation statements. The method includes determining whether an SQL statement includes extended indicator parameters such as DEFAULT and UNASSIGNED indicators. The method further includes delaying an authorization check for an operation for an SQL statement using extended indicators, and bypassing an SQL exception where an otherwise unauthorized operation involves an UNASSIGNED variable. The method further includes bypassing a database operation such as a referential integrity check where a data change would induce the database operation, but the data change involves an UNASSIGNED variable. The method further includes modifying the SQL statement when the SQL statement involves an UNASSIGNED variable in a predicate clause, allowing the SQL statement to properly execute.</description><language>eng</language><creationdate>2010</creationdate><oa>free_for_read</oa><woscitedreferencessubscribed>false</woscitedreferencessubscribed></display><links><openurl>$$Topenurl_article</openurl><openurlfulltext>$$Topenurlfull_article</openurlfulltext><thumbnail>$$Tsyndetics_thumb_exl</thumbnail><linktopdf>$$Uhttps://image-ppubs.uspto.gov/dirsearch-public/print/downloadPdf/7716213$$EPDF$$P50$$Guspatents$$Hfree_for_read</linktopdf><link.rule.ids>230,308,780,802,885,64039</link.rule.ids><linktorsrc>$$Uhttps://image-ppubs.uspto.gov/dirsearch-public/print/downloadPdf/7716213$$EView_record_in_USPTO$$FView_record_in_$$GUSPTO$$Hfree_for_read</linktorsrc></links><search><creatorcontrib>Cotner, Curt L</creatorcontrib><creatorcontrib>Farrar, Christopher M</creatorcontrib><creatorcontrib>Miller, Robert T</creatorcontrib><creatorcontrib>Weihrauch, Maryela E</creatorcontrib><creatorcontrib>International Business Machines Corporation</creatorcontrib><title>Apparatus, system, and method for efficiently supporting generic SQL data manipulation statements</title><description>An apparatus, system, and method are disclosed for efficiently supporting generic SQL data manipulation statements. The method includes determining whether an SQL statement includes extended indicator parameters such as DEFAULT and UNASSIGNED indicators. The method further includes delaying an authorization check for an operation for an SQL statement using extended indicators, and bypassing an SQL exception where an otherwise unauthorized operation involves an UNASSIGNED variable. The method further includes bypassing a database operation such as a referential integrity check where a data change would induce the database operation, but the data change involves an UNASSIGNED variable. The method further includes modifying the SQL statement when the SQL statement involves an UNASSIGNED variable in a predicate clause, allowing the SQL statement to properly execute.</description><fulltext>true</fulltext><rsrctype>patent</rsrctype><creationdate>2010</creationdate><recordtype>patent</recordtype><sourceid>EFH</sourceid><recordid>eNqNzD0KAjEQhuE0FqLeYQ6wguuCW4soFjaivQybSQzkj8yk2NsbwQNYvc3zfUuFx5yxoFTugGcWCh1g1BBI3kmDSQXIGDc5iuJn4JpzKuKiBUuRipvgcb-BRkEIGF2uHsWlCCzYvtqI12ph0DNtfl0puJyfp-u2cm6miZct-M1uHPvDvh-GP8gH0SY-4g</recordid><startdate>20100511</startdate><enddate>20100511</enddate><creator>Cotner, Curt L</creator><creator>Farrar, Christopher M</creator><creator>Miller, Robert T</creator><creator>Weihrauch, Maryela E</creator><scope>EFH</scope></search><sort><creationdate>20100511</creationdate><title>Apparatus, system, and method for efficiently supporting generic SQL data manipulation statements</title><author>Cotner, Curt L ; Farrar, Christopher M ; Miller, Robert T ; Weihrauch, Maryela E</author></sort><facets><frbrtype>5</frbrtype><frbrgroupid>cdi_FETCH-uspatents_grants_077162133</frbrgroupid><rsrctype>patents</rsrctype><prefilter>patents</prefilter><language>eng</language><creationdate>2010</creationdate><toplevel>online_resources</toplevel><creatorcontrib>Cotner, Curt L</creatorcontrib><creatorcontrib>Farrar, Christopher M</creatorcontrib><creatorcontrib>Miller, Robert T</creatorcontrib><creatorcontrib>Weihrauch, Maryela E</creatorcontrib><creatorcontrib>International Business Machines Corporation</creatorcontrib><collection>USPTO Issued Patents</collection></facets><delivery><delcategory>Remote Search Resource</delcategory><fulltext>fulltext_linktorsrc</fulltext></delivery><addata><au>Cotner, Curt L</au><au>Farrar, Christopher M</au><au>Miller, Robert T</au><au>Weihrauch, Maryela E</au><aucorp>International Business Machines Corporation</aucorp><format>patent</format><genre>patent</genre><ristype>GEN</ristype><title>Apparatus, system, and method for efficiently supporting generic SQL data manipulation statements</title><date>2010-05-11</date><risdate>2010</risdate><abstract>An apparatus, system, and method are disclosed for efficiently supporting generic SQL data manipulation statements. The method includes determining whether an SQL statement includes extended indicator parameters such as DEFAULT and UNASSIGNED indicators. The method further includes delaying an authorization check for an operation for an SQL statement using extended indicators, and bypassing an SQL exception where an otherwise unauthorized operation involves an UNASSIGNED variable. The method further includes bypassing a database operation such as a referential integrity check where a data change would induce the database operation, but the data change involves an UNASSIGNED variable. The method further includes modifying the SQL statement when the SQL statement involves an UNASSIGNED variable in a predicate clause, allowing the SQL statement to properly execute.</abstract><oa>free_for_read</oa></addata></record>
fulltext fulltext_linktorsrc
identifier
ispartof
issn
language eng
recordid cdi_uspatents_grants_07716213
source USPTO Issued Patents
title Apparatus, system, and method for efficiently supporting generic SQL data manipulation statements
url https://sfx.bib-bvb.de/sfx_tum?ctx_ver=Z39.88-2004&ctx_enc=info:ofi/enc:UTF-8&ctx_tim=2024-12-28T14%3A02%3A45IST&url_ver=Z39.88-2004&url_ctx_fmt=infofi/fmt:kev:mtx:ctx&rfr_id=info:sid/primo.exlibrisgroup.com:primo3-Article-uspatents_EFH&rft_val_fmt=info:ofi/fmt:kev:mtx:patent&rft.genre=patent&rft.au=Cotner,%20Curt%20L&rft.aucorp=International%20Business%20Machines%20Corporation&rft.date=2010-05-11&rft_id=info:doi/&rft_dat=%3Cuspatents_EFH%3E07716213%3C/uspatents_EFH%3E%3Curl%3E%3C/url%3E&disable_directlink=true&sfx.directlink=off&sfx.report_link=0&rft_id=info:oai/&rft_id=info:pmid/&rfr_iscdi=true