CN104484392A - 数据库查询语句生成方法及装置 - Google Patents
数据库查询语句生成方法及装置 Download PDFInfo
- Publication number
- CN104484392A CN104484392A CN201410770798.8A CN201410770798A CN104484392A CN 104484392 A CN104484392 A CN 104484392A CN 201410770798 A CN201410770798 A CN 201410770798A CN 104484392 A CN104484392 A CN 104484392A
- Authority
- CN
- China
- Prior art keywords
- template
- statement
- query
- transformed
- database
- 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.)
- Granted
Links
- 238000000034 method Methods 0.000 title claims abstract description 57
- 230000014509 gene expression Effects 0.000 claims abstract description 101
- 238000006243 chemical reaction Methods 0.000 claims abstract description 58
- 230000009466 transformation Effects 0.000 claims description 65
- 230000001131 transforming effect Effects 0.000 claims description 8
- 230000000694 effects Effects 0.000 abstract description 5
- 230000008569 process Effects 0.000 description 12
- 238000010586 diagram Methods 0.000 description 5
- 238000012545 processing Methods 0.000 description 5
- 238000010168 coupling process Methods 0.000 description 3
- 238000005859 coupling reaction Methods 0.000 description 3
- 238000004891 communication Methods 0.000 description 2
- 230000008878 coupling Effects 0.000 description 2
- 238000005538 encapsulation Methods 0.000 description 2
- 230000006870 function Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000005457 optimization Methods 0.000 description 2
- 238000003860 storage Methods 0.000 description 2
- 238000004458 analytical method Methods 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 238000009434 installation Methods 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 229920002755 poly(epichlorohydrin) Polymers 0.000 description 1
- 230000001360 synchronised effect Effects 0.000 description 1
- 238000013519 translation Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2453—Query optimisation
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2452—Query translation
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Description
Claims (10)
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201410770798.8A CN104484392B (zh) | 2014-12-11 | 2014-12-11 | 数据库查询语句生成方法及装置 |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201410770798.8A CN104484392B (zh) | 2014-12-11 | 2014-12-11 | 数据库查询语句生成方法及装置 |
Publications (2)
Publication Number | Publication Date |
---|---|
CN104484392A true CN104484392A (zh) | 2015-04-01 |
CN104484392B CN104484392B (zh) | 2018-02-02 |
Family
ID=52758933
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201410770798.8A Active CN104484392B (zh) | 2014-12-11 | 2014-12-11 | 数据库查询语句生成方法及装置 |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN104484392B (zh) |
Cited By (7)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN104899291A (zh) * | 2015-06-05 | 2015-09-09 | 北京京东尚科信息技术有限公司 | 关系型数据库的多维分析的方法及装置 |
CN107229628A (zh) * | 2016-03-23 | 2017-10-03 | 中兴通讯股份有限公司 | 分布式数据库预处理的方法及装置 |
CN111125159A (zh) * | 2019-12-24 | 2020-05-08 | 亚信科技(中国)有限公司 | 一种数据统计的方法及装置 |
CN113051287A (zh) * | 2021-06-01 | 2021-06-29 | 北京达佳互联信息技术有限公司 | 查询语句的生成方法、装置、设备和存储介质 |
CN113434529A (zh) * | 2021-06-22 | 2021-09-24 | 青岛海尔科技有限公司 | 业务数据查询方法、装置、存储介质、处理器及电子设备 |
CN115510289A (zh) * | 2022-09-22 | 2022-12-23 | 中电金信软件有限公司 | 一种数据立方体配置方法、装置、电子设备及存储介质 |
CN117251473A (zh) * | 2023-11-20 | 2023-12-19 | 摩斯智联科技有限公司 | 车辆数据查询分析方法、系统、装置和存储介质 |
Citations (8)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101556602A (zh) * | 2009-04-08 | 2009-10-14 | 王珊 | 一种基于差分表的内存OLAP What-if分析方法 |
CN101706810A (zh) * | 2009-11-23 | 2010-05-12 | 北京中创信测科技股份有限公司 | 一种数据库查询方法及装置 |
CN101710273A (zh) * | 2009-10-28 | 2010-05-19 | 金蝶软件(中国)有限公司 | 联机分析处理服务器中多维查询语句的解析方法和装置 |
CN102193922A (zh) * | 2010-03-04 | 2011-09-21 | 杭州华三通信技术有限公司 | 一种对数据库进行访问的方法和装置 |
CN102682118A (zh) * | 2012-05-15 | 2012-09-19 | 北京久其软件股份有限公司 | 一种多维数据模型访问方法及装置 |
CN103164222A (zh) * | 2013-02-25 | 2013-06-19 | 用友软件股份有限公司 | 多维建模系统和多维建模方法 |
CN103488475A (zh) * | 2013-09-02 | 2014-01-01 | 用友软件股份有限公司 | 多维数据分析系统和多维数据分析方法 |
US20140032588A1 (en) * | 2012-07-29 | 2014-01-30 | Sergiy GETMANETS | Systems And Methods For Providing A Simplified Application Programming Interface For Converting From Two-Dimensional Query Languages Into Multi-Dimensional Query Languages To Query Multi-Dimensional Data Sources And MDX Servers |
-
2014
- 2014-12-11 CN CN201410770798.8A patent/CN104484392B/zh active Active
Patent Citations (8)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101556602A (zh) * | 2009-04-08 | 2009-10-14 | 王珊 | 一种基于差分表的内存OLAP What-if分析方法 |
CN101710273A (zh) * | 2009-10-28 | 2010-05-19 | 金蝶软件(中国)有限公司 | 联机分析处理服务器中多维查询语句的解析方法和装置 |
CN101706810A (zh) * | 2009-11-23 | 2010-05-12 | 北京中创信测科技股份有限公司 | 一种数据库查询方法及装置 |
CN102193922A (zh) * | 2010-03-04 | 2011-09-21 | 杭州华三通信技术有限公司 | 一种对数据库进行访问的方法和装置 |
CN102682118A (zh) * | 2012-05-15 | 2012-09-19 | 北京久其软件股份有限公司 | 一种多维数据模型访问方法及装置 |
US20140032588A1 (en) * | 2012-07-29 | 2014-01-30 | Sergiy GETMANETS | Systems And Methods For Providing A Simplified Application Programming Interface For Converting From Two-Dimensional Query Languages Into Multi-Dimensional Query Languages To Query Multi-Dimensional Data Sources And MDX Servers |
CN103164222A (zh) * | 2013-02-25 | 2013-06-19 | 用友软件股份有限公司 | 多维建模系统和多维建模方法 |
CN103488475A (zh) * | 2013-09-02 | 2014-01-01 | 用友软件股份有限公司 | 多维数据分析系统和多维数据分析方法 |
Cited By (11)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN104899291A (zh) * | 2015-06-05 | 2015-09-09 | 北京京东尚科信息技术有限公司 | 关系型数据库的多维分析的方法及装置 |
CN104899291B (zh) * | 2015-06-05 | 2018-05-04 | 北京京东尚科信息技术有限公司 | 关系型数据库的多维分析的方法及装置 |
CN107229628A (zh) * | 2016-03-23 | 2017-10-03 | 中兴通讯股份有限公司 | 分布式数据库预处理的方法及装置 |
CN111125159A (zh) * | 2019-12-24 | 2020-05-08 | 亚信科技(中国)有限公司 | 一种数据统计的方法及装置 |
CN113051287A (zh) * | 2021-06-01 | 2021-06-29 | 北京达佳互联信息技术有限公司 | 查询语句的生成方法、装置、设备和存储介质 |
CN113051287B (zh) * | 2021-06-01 | 2021-08-20 | 北京达佳互联信息技术有限公司 | 查询语句的生成方法、装置、设备和存储介质 |
CN113434529A (zh) * | 2021-06-22 | 2021-09-24 | 青岛海尔科技有限公司 | 业务数据查询方法、装置、存储介质、处理器及电子设备 |
CN113434529B (zh) * | 2021-06-22 | 2023-06-16 | 青岛海尔科技有限公司 | 业务数据查询方法、装置、存储介质、处理器及电子设备 |
CN115510289A (zh) * | 2022-09-22 | 2022-12-23 | 中电金信软件有限公司 | 一种数据立方体配置方法、装置、电子设备及存储介质 |
CN117251473A (zh) * | 2023-11-20 | 2023-12-19 | 摩斯智联科技有限公司 | 车辆数据查询分析方法、系统、装置和存储介质 |
CN117251473B (zh) * | 2023-11-20 | 2024-03-15 | 摩斯智联科技有限公司 | 车辆数据查询分析方法、系统、装置和存储介质 |
Also Published As
Publication number | Publication date |
---|---|
CN104484392B (zh) | 2018-02-02 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN104484392A (zh) | 数据库查询语句生成方法及装置 | |
US11423082B2 (en) | Methods and apparatus for subgraph matching in big data analysis | |
US10289700B2 (en) | Method for dynamically matching images with content items based on keywords in response to search queries | |
Stefanowski et al. | Carrot 2 and language properties in web search results clustering | |
Yagoubi et al. | Massively distributed time series indexing and querying | |
US8560531B2 (en) | Search tool that utilizes scientific metadata matched against user-entered parameters | |
US10467307B1 (en) | Grouping of item data using seed expansion | |
Nabli et al. | Efficient cloud service discovery approach based on LDA topic modeling | |
KR20170023022A (ko) | 코드 추천 기법 | |
CN102479252A (zh) | 查询语句转换装置及查询语句转换方法 | |
CN101055585A (zh) | 文档聚类系统和方法 | |
US10235387B2 (en) | Method for selecting images for matching with content based on metadata of images and content in real-time in response to search queries | |
US9721000B2 (en) | Generating and using a customized index | |
US10275472B2 (en) | Method for categorizing images to be associated with content items based on keywords of search queries | |
CN104965918B (zh) | 一种基于查询关键词的搜索方法和装置 | |
CN108427686A (zh) | 文本数据查询方法及装置 | |
CN104462430A (zh) | 关系型数据库的数据处理方法及装置 | |
CN103077254A (zh) | 网页获取方法和装置 | |
WO2017040209A1 (en) | Data preparation for data mining | |
CN114139040A (zh) | 一种数据存储及查询方法、装置、设备及可读存储介质 | |
CN111143400B (zh) | 一种全栈式检索方法、系统、引擎及电子设备 | |
JP6311000B1 (ja) | 生成装置、生成方法、及び生成プログラム | |
Su et al. | Supporting correlation analysis on scientific datasets in parallel and distributed settings | |
US10394913B1 (en) | Distributed grouping of large-scale data sets | |
De Vries et al. | Parallel streaming signature em-tree: A clustering algorithm for web scale applications |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
GR01 | Patent grant | ||
GR01 | Patent grant | ||
PE01 | Entry into force of the registration of the contract for pledge of patent right |
Denomination of invention: Method and device for generating database query statement Effective date of registration: 20190531 Granted publication date: 20180202 Pledgee: Shenzhen Black Horse World Investment Consulting Co.,Ltd. Pledgor: BEIJING GRIDSUM TECHNOLOGY Co.,Ltd. Registration number: 2019990000503 |
|
PE01 | Entry into force of the registration of the contract for pledge of patent right | ||
CP02 | Change in the address of a patent holder |
Address after: 100083 No. 401, 4th Floor, Haitai Building, 229 North Fourth Ring Road, Haidian District, Beijing Patentee after: BEIJING GRIDSUM TECHNOLOGY Co.,Ltd. Address before: 100086 Beijing city Haidian District Shuangyushu Area No. 76 Zhichun Road cuigongfandian 8 layer A Patentee before: BEIJING GRIDSUM TECHNOLOGY Co.,Ltd. |
|
CP02 | Change in the address of a patent holder | ||
PP01 | Preservation of patent right |
Effective date of registration: 20240604 Granted publication date: 20180202 |
|
PP01 | Preservation of patent right |