CN102073640B - Sql语句的检测方法、***及服务器 - Google Patents
Sql语句的检测方法、***及服务器 Download PDFInfo
- Publication number
- CN102073640B CN102073640B CN 200910221882 CN200910221882A CN102073640B CN 102073640 B CN102073640 B CN 102073640B CN 200910221882 CN200910221882 CN 200910221882 CN 200910221882 A CN200910221882 A CN 200910221882A CN 102073640 B CN102073640 B CN 102073640B
- Authority
- CN
- China
- Prior art keywords
- sql
- changed
- sql statement
- file
- matching
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 34
- 238000012360 testing method Methods 0.000 title abstract 4
- 230000008859 change Effects 0.000 claims abstract description 34
- 238000004458 analytical method Methods 0.000 claims abstract description 16
- 238000001514 detection method Methods 0.000 claims description 84
- 230000014509 gene expression Effects 0.000 claims description 25
- 238000006243 chemical reaction Methods 0.000 claims description 7
- 230000008569 process Effects 0.000 description 9
- 238000010586 diagram Methods 0.000 description 7
- 230000006870 function Effects 0.000 description 5
- 238000013500 data storage Methods 0.000 description 2
- 238000012217 deletion Methods 0.000 description 1
- 230000037430 deletion Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 230000001788 irregular Effects 0.000 description 1
- 238000007726 management method Methods 0.000 description 1
- 230000005055 memory storage Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000000750 progressive effect Effects 0.000 description 1
Images
Landscapes
- Debugging And Monitoring (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Description
Claims (20)
Priority Applications (2)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN 200910221882 CN102073640B (zh) | 2009-11-19 | 2009-11-19 | Sql语句的检测方法、***及服务器 |
HK11107092.9A HK1153000A1 (en) | 2009-11-19 | 2011-07-08 | Checking method, system and server for sql sentence sql |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN 200910221882 CN102073640B (zh) | 2009-11-19 | 2009-11-19 | Sql语句的检测方法、***及服务器 |
Publications (2)
Publication Number | Publication Date |
---|---|
CN102073640A CN102073640A (zh) | 2011-05-25 |
CN102073640B true CN102073640B (zh) | 2013-12-18 |
Family
ID=44032184
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN 200910221882 Active CN102073640B (zh) | 2009-11-19 | 2009-11-19 | Sql语句的检测方法、***及服务器 |
Country Status (2)
Country | Link |
---|---|
CN (1) | CN102073640B (zh) |
HK (1) | HK1153000A1 (zh) |
Families Citing this family (17)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN103577319A (zh) * | 2012-08-07 | 2014-02-12 | 腾讯科技(深圳)有限公司 | 源代码文件检测方法及装置、文件发布*** |
CN104679646B (zh) * | 2013-11-29 | 2018-02-06 | 阿里巴巴集团控股有限公司 | 一种用于检测sql代码缺陷的方法和装置 |
CN105335403B (zh) * | 2014-07-23 | 2020-02-14 | 华为技术有限公司 | 数据库访问方法及装置、数据库*** |
CN104391995A (zh) * | 2014-12-15 | 2015-03-04 | 北京趣拿软件科技有限公司 | 一种sql语句审核的方法、数据库运维的方法及*** |
CN104809254A (zh) * | 2015-05-19 | 2015-07-29 | 郑州悉知信息技术有限公司 | 一种数据查询方法及装置 |
CN106503019A (zh) * | 2015-09-08 | 2017-03-15 | 中兴通讯股份有限公司 | 一种获取数据库变更信息的方法和装置 |
CN106682098A (zh) * | 2016-12-01 | 2017-05-17 | 无线生活(杭州)信息科技有限公司 | 一种dml处理方法及装置 |
CN108319620A (zh) * | 2017-01-18 | 2018-07-24 | 北京京东尚科信息技术有限公司 | 一种防止数据库索引错乱的方法、***、装置及存储介质 |
CN107341110B (zh) * | 2017-07-11 | 2020-01-07 | 浪潮软件集团有限公司 | 一种软件测试定位补丁修改及影响范围的工具及实现方法 |
CN107844425A (zh) * | 2017-11-16 | 2018-03-27 | 中国银行股份有限公司 | 一种数据库语句检查方法和装置 |
CN108984612B (zh) * | 2018-06-12 | 2024-02-02 | 中国平安人寿保险股份有限公司 | 目标sql语句的获取方法、装置、计算机设备及存储介质 |
CN110716912B (zh) * | 2018-07-12 | 2021-09-28 | 马上消费金融股份有限公司 | 一种sql性能检测方法及服务器 |
CN109753513A (zh) * | 2018-12-19 | 2019-05-14 | 国网新疆电力有限公司电力科学研究院 | 一种基于正则表达式匹配的输变配台帐核查方法及*** |
CN110134737B (zh) * | 2019-05-20 | 2021-02-26 | 中国铁道科学研究院集团有限公司 | 数据变化监听方法及装置、电子设备和计算机可读存储介质 |
CN111857721B (zh) * | 2020-03-30 | 2021-09-17 | 马上消费金融股份有限公司 | Sql语句的验证方法、数据获取方法、设备及存储装置 |
CN114896269A (zh) * | 2022-05-31 | 2022-08-12 | 北京达佳互联信息技术有限公司 | 结构化查询语句检测方法、装置、电子设备及存储介质 |
CN117331963B (zh) * | 2023-11-28 | 2024-03-08 | 恒生电子股份有限公司 | 数据访问处理方法、装置、电子设备及存储介质 |
Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101187888A (zh) * | 2007-12-11 | 2008-05-28 | 浪潮电子信息产业股份有限公司 | 一种异构环境中复制数据库数据的方法 |
CN101267357A (zh) * | 2007-03-13 | 2008-09-17 | 北京启明星辰信息技术有限公司 | 一种sql注入攻击检测方法及*** |
CN101526947A (zh) * | 2009-04-23 | 2009-09-09 | 山东中创软件商用中间件股份有限公司 | 应用正则表达式防sql注入技术 |
-
2009
- 2009-11-19 CN CN 200910221882 patent/CN102073640B/zh active Active
-
2011
- 2011-07-08 HK HK11107092.9A patent/HK1153000A1/xx unknown
Patent Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101267357A (zh) * | 2007-03-13 | 2008-09-17 | 北京启明星辰信息技术有限公司 | 一种sql注入攻击检测方法及*** |
CN101187888A (zh) * | 2007-12-11 | 2008-05-28 | 浪潮电子信息产业股份有限公司 | 一种异构环境中复制数据库数据的方法 |
CN101526947A (zh) * | 2009-04-23 | 2009-09-09 | 山东中创软件商用中间件股份有限公司 | 应用正则表达式防sql注入技术 |
Also Published As
Publication number | Publication date |
---|---|
HK1153000A1 (en) | 2012-03-16 |
CN102073640A (zh) | 2011-05-25 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN102073640B (zh) | Sql语句的检测方法、***及服务器 | |
US11163731B1 (en) | Autobuild log anomaly detection methods and systems | |
US10339038B1 (en) | Method and system for generating production data pattern driven test data | |
US20200372007A1 (en) | Trace and span sampling and analysis for instrumented software | |
US9679021B2 (en) | Parallel transactional-statistics collection for improving operation of a DBMS optimizer module | |
US8924373B2 (en) | Query plans with parameter markers in place of object identifiers | |
CN110795455A (zh) | 依赖关系解析方法、电子装置、计算机设备及可读存储介质 | |
CN106407360B (zh) | 一种数据的处理方法及装置 | |
US20060129609A1 (en) | Database synchronization using change log | |
GB2574282A (en) | Data consistency verification method and system minimizing load of original database | |
CN112182025A (zh) | 日志分析方法、装置、设备与计算机可读存储介质 | |
CN112527620A (zh) | 数据库性能分析方法及装置、电子设备、介质、产品 | |
US10003492B2 (en) | Systems and methods for managing data related to network elements from multiple sources | |
US8666972B2 (en) | System and method for content management and determination of search conditions | |
US11657050B1 (en) | Data reconciliation for big data environments | |
US9600505B2 (en) | Code optimization based on customer logs | |
CN114282260A (zh) | 审核执行ClickhouseDDLSQL语义语法的方法及装置 | |
CN114090457A (zh) | 数据库存储过程的测试方法、装置、处理设备及介质 | |
CN112799963A (zh) | 测试应用程序的至少一个应用程序接口的方法和测试*** | |
CN117033410A (zh) | 一种数据的血缘关系的管理方法和*** | |
CN117131027A (zh) | 数据质量检测方法、装置、终端设备以及存储介质 | |
CN117745437A (zh) | 一种用于年金业务的规则校验及配置方法 | |
CN116975392A (zh) | 运维信息推荐方法及*** | |
CN117648339A (zh) | 一种数据探查方法、装置、服务器及存储介质 | |
CN114116784A (zh) | 数据库请求评估方法、装置、可读存储介质及电子设备 |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
REG | Reference to a national code |
Ref country code: HK Ref legal event code: DE Ref document number: 1153000 Country of ref document: HK |
|
C14 | Grant of patent or utility model | ||
GR01 | Patent grant | ||
REG | Reference to a national code |
Ref country code: HK Ref legal event code: GR Ref document number: 1153000 Country of ref document: HK |
|
TR01 | Transfer of patent right | ||
TR01 | Transfer of patent right |
Effective date of registration: 20191216 Address after: P.O. Box 31119, grand exhibition hall, hibiscus street, 802 West Bay Road, Grand Cayman, British Cayman Islands Patentee after: Innovative advanced technology Co., Ltd Address before: Cayman Islands Grand Cayman capital building, a four storey No. 847 mailbox Patentee before: Alibaba Group Holding Co., Ltd. |