RUN-TIME SQL LANGUAGE TRANSLATION
A method, system, and computer program product for database application migration. The method commences upon executing a foreign application, the foreign application emits SQL statements of a foreign SQL dialect that is incompatible with the SQL dialect of a native database system. The system config...
Gespeichert in:
| Hauptverfasser: | , , , , |
|---|---|
| Format: | Patent |
| Sprache: | eng |
| Schlagworte: | |
| 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 | RICE KRISTOPHER O'NEILL DERMOT MCGILLIN BARRY IYER CHANDRASEKHARAN PANG ROBERT |
| description | A method, system, and computer program product for database application migration. The method commences upon executing a foreign application, the foreign application emits SQL statements of a foreign SQL dialect that is incompatible with the SQL dialect of a native database system. The system configures a communication session to intercept the foreign SQL statements before the foreign SQL statements are received by the SQL parser of the native database system; and, while the foreign application is waiting for query results, the system translates the foreign dialect query statements into native SQL compatible with the native database system. The method further performs translating a return code from the native database system into a return code compatible with the foreign application. Configuring the database session connection comprises establishing a translation profile to translate foreign dialect SQL into native SQL, and to translate native SQL query return codes into foreign dialect return codes. |
| format | Patent |
| fullrecord | <record><control><sourceid>epo_EVB</sourceid><recordid>TN_cdi_epo_espacenet_US2014280259A1</recordid><sourceformat>XML</sourceformat><sourcesystem>PC</sourcesystem><sourcerecordid>US2014280259A1</sourcerecordid><originalsourceid>FETCH-epo_espacenet_US2014280259A13</originalsourceid><addsrcrecordid>eNrjZFAMCvXTDfH0dVUIDvRR8HH0cw91dHdVCAly9Av2cQzx9PfjYWBNS8wpTuWF0twMym6uIc4euqkF-fGpxQWJyal5qSXxocFGBoYmRhYGRqaWjobGxKkCAKb4IzI</addsrcrecordid><sourcetype>Open Access Repository</sourcetype><iscdi>true</iscdi><recordtype>patent</recordtype></control><display><type>patent</type><title>RUN-TIME SQL LANGUAGE TRANSLATION</title><source>esp@cenet</source><creator>RICE KRISTOPHER ; O'NEILL DERMOT ; MCGILLIN BARRY ; IYER CHANDRASEKHARAN ; PANG ROBERT</creator><creatorcontrib>RICE KRISTOPHER ; O'NEILL DERMOT ; MCGILLIN BARRY ; IYER CHANDRASEKHARAN ; PANG ROBERT</creatorcontrib><description>A method, system, and computer program product for database application migration. The method commences upon executing a foreign application, the foreign application emits SQL statements of a foreign SQL dialect that is incompatible with the SQL dialect of a native database system. The system configures a communication session to intercept the foreign SQL statements before the foreign SQL statements are received by the SQL parser of the native database system; and, while the foreign application is waiting for query results, the system translates the foreign dialect query statements into native SQL compatible with the native database system. The method further performs translating a return code from the native database system into a return code compatible with the foreign application. Configuring the database session connection comprises establishing a translation profile to translate foreign dialect SQL into native SQL, and to translate native SQL query return codes into foreign dialect return codes.</description><language>eng</language><subject>CALCULATING ; COMPUTING ; COUNTING ; ELECTRIC DIGITAL DATA PROCESSING ; PHYSICS</subject><creationdate>2014</creationdate><oa>free_for_read</oa><woscitedreferencessubscribed>false</woscitedreferencessubscribed></display><links><openurl>$$Topenurl_article</openurl><openurlfulltext>$$Topenurlfull_article</openurlfulltext><thumbnail>$$Tsyndetics_thumb_exl</thumbnail><linktohtml>$$Uhttps://worldwide.espacenet.com/publicationDetails/biblio?FT=D&date=20140918&DB=EPODOC&CC=US&NR=2014280259A1$$EHTML$$P50$$Gepo$$Hfree_for_read</linktohtml><link.rule.ids>230,308,776,881,25542,76516</link.rule.ids><linktorsrc>$$Uhttps://worldwide.espacenet.com/publicationDetails/biblio?FT=D&date=20140918&DB=EPODOC&CC=US&NR=2014280259A1$$EView_record_in_European_Patent_Office$$FView_record_in_$$GEuropean_Patent_Office$$Hfree_for_read</linktorsrc></links><search><creatorcontrib>RICE KRISTOPHER</creatorcontrib><creatorcontrib>O'NEILL DERMOT</creatorcontrib><creatorcontrib>MCGILLIN BARRY</creatorcontrib><creatorcontrib>IYER CHANDRASEKHARAN</creatorcontrib><creatorcontrib>PANG ROBERT</creatorcontrib><title>RUN-TIME SQL LANGUAGE TRANSLATION</title><description>A method, system, and computer program product for database application migration. The method commences upon executing a foreign application, the foreign application emits SQL statements of a foreign SQL dialect that is incompatible with the SQL dialect of a native database system. The system configures a communication session to intercept the foreign SQL statements before the foreign SQL statements are received by the SQL parser of the native database system; and, while the foreign application is waiting for query results, the system translates the foreign dialect query statements into native SQL compatible with the native database system. The method further performs translating a return code from the native database system into a return code compatible with the foreign application. Configuring the database session connection comprises establishing a translation profile to translate foreign dialect SQL into native SQL, and to translate native SQL query return codes into foreign dialect return codes.</description><subject>CALCULATING</subject><subject>COMPUTING</subject><subject>COUNTING</subject><subject>ELECTRIC DIGITAL DATA PROCESSING</subject><subject>PHYSICS</subject><fulltext>true</fulltext><rsrctype>patent</rsrctype><creationdate>2014</creationdate><recordtype>patent</recordtype><sourceid>EVB</sourceid><recordid>eNrjZFAMCvXTDfH0dVUIDvRR8HH0cw91dHdVCAly9Av2cQzx9PfjYWBNS8wpTuWF0twMym6uIc4euqkF-fGpxQWJyal5qSXxocFGBoYmRhYGRqaWjobGxKkCAKb4IzI</recordid><startdate>20140918</startdate><enddate>20140918</enddate><creator>RICE KRISTOPHER</creator><creator>O'NEILL DERMOT</creator><creator>MCGILLIN BARRY</creator><creator>IYER CHANDRASEKHARAN</creator><creator>PANG ROBERT</creator><scope>EVB</scope></search><sort><creationdate>20140918</creationdate><title>RUN-TIME SQL LANGUAGE TRANSLATION</title><author>RICE KRISTOPHER ; O'NEILL DERMOT ; MCGILLIN BARRY ; IYER CHANDRASEKHARAN ; PANG ROBERT</author></sort><facets><frbrtype>5</frbrtype><frbrgroupid>cdi_FETCH-epo_espacenet_US2014280259A13</frbrgroupid><rsrctype>patents</rsrctype><prefilter>patents</prefilter><language>eng</language><creationdate>2014</creationdate><topic>CALCULATING</topic><topic>COMPUTING</topic><topic>COUNTING</topic><topic>ELECTRIC DIGITAL DATA PROCESSING</topic><topic>PHYSICS</topic><toplevel>online_resources</toplevel><creatorcontrib>RICE KRISTOPHER</creatorcontrib><creatorcontrib>O'NEILL DERMOT</creatorcontrib><creatorcontrib>MCGILLIN BARRY</creatorcontrib><creatorcontrib>IYER CHANDRASEKHARAN</creatorcontrib><creatorcontrib>PANG ROBERT</creatorcontrib><collection>esp@cenet</collection></facets><delivery><delcategory>Remote Search Resource</delcategory><fulltext>fulltext_linktorsrc</fulltext></delivery><addata><au>RICE KRISTOPHER</au><au>O'NEILL DERMOT</au><au>MCGILLIN BARRY</au><au>IYER CHANDRASEKHARAN</au><au>PANG ROBERT</au><format>patent</format><genre>patent</genre><ristype>GEN</ristype><title>RUN-TIME SQL LANGUAGE TRANSLATION</title><date>2014-09-18</date><risdate>2014</risdate><abstract>A method, system, and computer program product for database application migration. The method commences upon executing a foreign application, the foreign application emits SQL statements of a foreign SQL dialect that is incompatible with the SQL dialect of a native database system. The system configures a communication session to intercept the foreign SQL statements before the foreign SQL statements are received by the SQL parser of the native database system; and, while the foreign application is waiting for query results, the system translates the foreign dialect query statements into native SQL compatible with the native database system. The method further performs translating a return code from the native database system into a return code compatible with the foreign application. Configuring the database session connection comprises establishing a translation profile to translate foreign dialect SQL into native SQL, and to translate native SQL query return codes into foreign dialect return codes.</abstract><oa>free_for_read</oa></addata></record> |
| fulltext | fulltext_linktorsrc |
| identifier | |
| ispartof | |
| issn | |
| language | eng |
| recordid | cdi_epo_espacenet_US2014280259A1 |
| source | esp@cenet |
| subjects | CALCULATING COMPUTING COUNTING ELECTRIC DIGITAL DATA PROCESSING PHYSICS |
| title | RUN-TIME SQL LANGUAGE TRANSLATION |
| url | https://sfx.bib-bvb.de/sfx_tum?ctx_ver=Z39.88-2004&ctx_enc=info:ofi/enc:UTF-8&ctx_tim=2025-02-14T13%3A15%3A58IST&url_ver=Z39.88-2004&url_ctx_fmt=infofi/fmt:kev:mtx:ctx&rfr_id=info:sid/primo.exlibrisgroup.com:primo3-Article-epo_EVB&rft_val_fmt=info:ofi/fmt:kev:mtx:patent&rft.genre=patent&rft.au=RICE%20KRISTOPHER&rft.date=2014-09-18&rft_id=info:doi/&rft_dat=%3Cepo_EVB%3EUS2014280259A1%3C/epo_EVB%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 |