Method for generating upgrade SQL (Structured Query Language) file of relational database
The invention discloses a relational database upgrading SQL (Structured Query Language) file generation method, which is characterized by comprising the following steps of: 1, data configuration: matching and configuring database and data table information, and selecting a range of exported data in...
Gespeichert in:
| Hauptverfasser: | , , , , , , |
|---|---|
| Format: | Patent |
| Sprache: | chi ; 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 | LIAO YONGFEI DI BOWEN DONG TUNAN XIE YUSHEN CHANG LEI LI GUOHUA ZHANG SHUO |
| description | The invention discloses a relational database upgrading SQL (Structured Query Language) file generation method, which is characterized by comprising the following steps of: 1, data configuration: matching and configuring database and data table information, and selecting a range of exported data in a data table; step 2, file extraction: extracting the structural data and the initialized data of the database obtained in the step 1 into an SQL (Structured Query Language) file; and step 3, file comparison: comparing the data structures and the initialized data in the two SQL files obtained in the step 2, and converting the SQL files into upgrading SQL files. According to the method, errors possibly caused by manual recording of database designers and difficulty brought by database reconstruction are avoided, the problem that the database is not updated in time is fundamentally solved, and the probability of problems occurring during software upgrading is reduced.
本发明公开了一种关系型数据库升级SQL文件生成方法，其特征在于，包括以下步骤：步骤一数据配置，匹配 |
| format | Patent |
| fullrecord | <record><control><sourceid>epo_EVB</sourceid><recordid>TN_cdi_epo_espacenet_CN118410058A</recordid><sourceformat>XML</sourceformat><sourcesystem>PC</sourcesystem><sourcerecordid>CN118410058A</sourcerecordid><originalsourceid>FETCH-epo_espacenet_CN118410058A3</originalsourceid><addsrcrecordid>eNqNjbEKwjAURbs4iPoPz00HoUWFrlIUhyqUujiVZ3MTCyEJr8ng39vBD3A6yzmcefa8Ib69Iu2FDByE4-AMpWCEFahtatq0UVIfk0BRkyAfqtmZxAZb0oMFeU0CO4XesSXFkV88YpnNNNsRqx8X2fpyflTXHYLvMAbup13sqntRlIciz4_laf-P8wVzwznR</addsrcrecordid><sourcetype>Open Access Repository</sourcetype><iscdi>true</iscdi><recordtype>patent</recordtype></control><display><type>patent</type><title>Method for generating upgrade SQL (Structured Query Language) file of relational database</title><source>esp@cenet</source><creator>LIAO YONGFEI ; DI BOWEN ; DONG TUNAN ; XIE YUSHEN ; CHANG LEI ; LI GUOHUA ; ZHANG SHUO</creator><creatorcontrib>LIAO YONGFEI ; DI BOWEN ; DONG TUNAN ; XIE YUSHEN ; CHANG LEI ; LI GUOHUA ; ZHANG SHUO</creatorcontrib><description>The invention discloses a relational database upgrading SQL (Structured Query Language) file generation method, which is characterized by comprising the following steps of: 1, data configuration: matching and configuring database and data table information, and selecting a range of exported data in a data table; step 2, file extraction: extracting the structural data and the initialized data of the database obtained in the step 1 into an SQL (Structured Query Language) file; and step 3, file comparison: comparing the data structures and the initialized data in the two SQL files obtained in the step 2, and converting the SQL files into upgrading SQL files. According to the method, errors possibly caused by manual recording of database designers and difficulty brought by database reconstruction are avoided, the problem that the database is not updated in time is fundamentally solved, and the probability of problems occurring during software upgrading is reduced.
本发明公开了一种关系型数据库升级SQL文件生成方法，其特征在于，包括以下步骤：步骤一数据配置，匹配</description><language>chi ; eng</language><subject>CALCULATING ; COMPUTING ; COUNTING ; ELECTRIC DIGITAL DATA PROCESSING ; PHYSICS</subject><creationdate>2024</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=20240730&DB=EPODOC&CC=CN&NR=118410058A$$EHTML$$P50$$Gepo$$Hfree_for_read</linktohtml><link.rule.ids>230,308,776,881,25542,76289</link.rule.ids><linktorsrc>$$Uhttps://worldwide.espacenet.com/publicationDetails/biblio?FT=D&date=20240730&DB=EPODOC&CC=CN&NR=118410058A$$EView_record_in_European_Patent_Office$$FView_record_in_$$GEuropean_Patent_Office$$Hfree_for_read</linktorsrc></links><search><creatorcontrib>LIAO YONGFEI</creatorcontrib><creatorcontrib>DI BOWEN</creatorcontrib><creatorcontrib>DONG TUNAN</creatorcontrib><creatorcontrib>XIE YUSHEN</creatorcontrib><creatorcontrib>CHANG LEI</creatorcontrib><creatorcontrib>LI GUOHUA</creatorcontrib><creatorcontrib>ZHANG SHUO</creatorcontrib><title>Method for generating upgrade SQL (Structured Query Language) file of relational database</title><description>The invention discloses a relational database upgrading SQL (Structured Query Language) file generation method, which is characterized by comprising the following steps of: 1, data configuration: matching and configuring database and data table information, and selecting a range of exported data in a data table; step 2, file extraction: extracting the structural data and the initialized data of the database obtained in the step 1 into an SQL (Structured Query Language) file; and step 3, file comparison: comparing the data structures and the initialized data in the two SQL files obtained in the step 2, and converting the SQL files into upgrading SQL files. According to the method, errors possibly caused by manual recording of database designers and difficulty brought by database reconstruction are avoided, the problem that the database is not updated in time is fundamentally solved, and the probability of problems occurring during software upgrading is reduced.
本发明公开了一种关系型数据库升级SQL文件生成方法，其特征在于，包括以下步骤：步骤一数据配置，匹配</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>2024</creationdate><recordtype>patent</recordtype><sourceid>EVB</sourceid><recordid>eNqNjbEKwjAURbs4iPoPz00HoUWFrlIUhyqUujiVZ3MTCyEJr8ng39vBD3A6yzmcefa8Ib69Iu2FDByE4-AMpWCEFahtatq0UVIfk0BRkyAfqtmZxAZb0oMFeU0CO4XesSXFkV88YpnNNNsRqx8X2fpyflTXHYLvMAbup13sqntRlIciz4_laf-P8wVzwznR</recordid><startdate>20240730</startdate><enddate>20240730</enddate><creator>LIAO YONGFEI</creator><creator>DI BOWEN</creator><creator>DONG TUNAN</creator><creator>XIE YUSHEN</creator><creator>CHANG LEI</creator><creator>LI GUOHUA</creator><creator>ZHANG SHUO</creator><scope>EVB</scope></search><sort><creationdate>20240730</creationdate><title>Method for generating upgrade SQL (Structured Query Language) file of relational database</title><author>LIAO YONGFEI ; DI BOWEN ; DONG TUNAN ; XIE YUSHEN ; CHANG LEI ; LI GUOHUA ; ZHANG SHUO</author></sort><facets><frbrtype>5</frbrtype><frbrgroupid>cdi_FETCH-epo_espacenet_CN118410058A3</frbrgroupid><rsrctype>patents</rsrctype><prefilter>patents</prefilter><language>chi ; eng</language><creationdate>2024</creationdate><topic>CALCULATING</topic><topic>COMPUTING</topic><topic>COUNTING</topic><topic>ELECTRIC DIGITAL DATA PROCESSING</topic><topic>PHYSICS</topic><toplevel>online_resources</toplevel><creatorcontrib>LIAO YONGFEI</creatorcontrib><creatorcontrib>DI BOWEN</creatorcontrib><creatorcontrib>DONG TUNAN</creatorcontrib><creatorcontrib>XIE YUSHEN</creatorcontrib><creatorcontrib>CHANG LEI</creatorcontrib><creatorcontrib>LI GUOHUA</creatorcontrib><creatorcontrib>ZHANG SHUO</creatorcontrib><collection>esp@cenet</collection></facets><delivery><delcategory>Remote Search Resource</delcategory><fulltext>fulltext_linktorsrc</fulltext></delivery><addata><au>LIAO YONGFEI</au><au>DI BOWEN</au><au>DONG TUNAN</au><au>XIE YUSHEN</au><au>CHANG LEI</au><au>LI GUOHUA</au><au>ZHANG SHUO</au><format>patent</format><genre>patent</genre><ristype>GEN</ristype><title>Method for generating upgrade SQL (Structured Query Language) file of relational database</title><date>2024-07-30</date><risdate>2024</risdate><abstract>The invention discloses a relational database upgrading SQL (Structured Query Language) file generation method, which is characterized by comprising the following steps of: 1, data configuration: matching and configuring database and data table information, and selecting a range of exported data in a data table; step 2, file extraction: extracting the structural data and the initialized data of the database obtained in the step 1 into an SQL (Structured Query Language) file; and step 3, file comparison: comparing the data structures and the initialized data in the two SQL files obtained in the step 2, and converting the SQL files into upgrading SQL files. According to the method, errors possibly caused by manual recording of database designers and difficulty brought by database reconstruction are avoided, the problem that the database is not updated in time is fundamentally solved, and the probability of problems occurring during software upgrading is reduced.
本发明公开了一种关系型数据库升级SQL文件生成方法，其特征在于，包括以下步骤：步骤一数据配置，匹配</abstract><oa>free_for_read</oa></addata></record> |
| fulltext | fulltext_linktorsrc |
| identifier | |
| ispartof | |
| issn | |
| language | chi ; eng |
| recordid | cdi_epo_espacenet_CN118410058A |
| source | esp@cenet |
| subjects | CALCULATING COMPUTING COUNTING ELECTRIC DIGITAL DATA PROCESSING PHYSICS |
| title | Method for generating upgrade SQL (Structured Query Language) file of relational database |
| url | https://sfx.bib-bvb.de/sfx_tum?ctx_ver=Z39.88-2004&ctx_enc=info:ofi/enc:UTF-8&ctx_tim=2025-02-08T04%3A52%3A46IST&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=LIAO%20YONGFEI&rft.date=2024-07-30&rft_id=info:doi/&rft_dat=%3Cepo_EVB%3ECN118410058A%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 |