CN104484392B - 数据库查询语句生成方法及装置 - Google Patents
数据库查询语句生成方法及装置 Download PDFInfo
- Publication number
- CN104484392B CN104484392B CN201410770798.8A CN201410770798A CN104484392B CN 104484392 B CN104484392 B CN 104484392B CN 201410770798 A CN201410770798 A CN 201410770798A CN 104484392 B CN104484392 B CN 104484392B
- Authority
- CN
- China
- Prior art keywords
- template
- sentence
- database
- transformed
- inquiry operation
- 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 51
- 230000014509 gene expression Effects 0.000 claims abstract description 94
- 238000006243 chemical reaction Methods 0.000 claims abstract description 89
- 230000009466 transformation Effects 0.000 claims abstract description 65
- 230000004048 modification Effects 0.000 claims description 6
- 238000012986 modification Methods 0.000 claims description 6
- 230000000694 effects Effects 0.000 abstract description 5
- 230000008569 process Effects 0.000 description 7
- 238000010168 coupling process Methods 0.000 description 3
- 238000005859 coupling reaction Methods 0.000 description 3
- 238000003860 storage Methods 0.000 description 3
- 238000004891 communication Methods 0.000 description 2
- 230000008878 coupling Effects 0.000 description 2
- 238000010586 diagram Methods 0.000 description 2
- 238000005538 encapsulation Methods 0.000 description 2
- 230000006870 function Effects 0.000 description 2
- 238000005457 optimization Methods 0.000 description 2
- 230000009467 reduction Effects 0.000 description 2
- 238000004458 analytical method Methods 0.000 description 1
- 230000006399 behavior 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
- 230000006911 nucleation Effects 0.000 description 1
- 238000010899 nucleation Methods 0.000 description 1
- 229920002755 poly(epichlorohydrin) Polymers 0.000 description 1
- 230000001360 synchronised effect Effects 0.000 description 1
- 238000004148 unit process 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 (8)
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 CN104484392A (zh) | 2015-04-01 |
CN104484392B true 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) |
Families Citing this family (7)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN104899291B (zh) * | 2015-06-05 | 2018-05-04 | 北京京东尚科信息技术有限公司 | 关系型数据库的多维分析的方法及装置 |
CN107229628B (zh) * | 2016-03-23 | 2022-02-01 | 金篆信科有限责任公司 | 分布式数据库预处理的方法及装置 |
CN111125159A (zh) * | 2019-12-24 | 2020-05-08 | 亚信科技(中国)有限公司 | 一种数据统计的方法及装置 |
CN113051287B (zh) * | 2021-06-01 | 2021-08-20 | 北京达佳互联信息技术有限公司 | 查询语句的生成方法、装置、设备和存储介质 |
CN113434529B (zh) * | 2021-06-22 | 2023-06-16 | 青岛海尔科技有限公司 | 业务数据查询方法、装置、存储介质、处理器及电子设备 |
CN115510289B (zh) * | 2022-09-22 | 2023-04-25 | 中电金信软件有限公司 | 一种数据立方体配置方法、装置、电子设备及存储介质 |
CN117251473B (zh) * | 2023-11-20 | 2024-03-15 | 摩斯智联科技有限公司 | 车辆数据查询分析方法、***、装置和存储介质 |
Citations (7)
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 | 用友软件股份有限公司 | 多维数据分析***和多维数据分析方法 |
Family Cites Families (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US9355143B2 (en) * | 2012-07-29 | 2016-05-31 | 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 (7)
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 | 北京久其软件股份有限公司 | 一种多维数据模型访问方法及装置 |
CN103164222A (zh) * | 2013-02-25 | 2013-06-19 | 用友软件股份有限公司 | 多维建模***和多维建模方法 |
CN103488475A (zh) * | 2013-09-02 | 2014-01-01 | 用友软件股份有限公司 | 多维数据分析***和多维数据分析方法 |
Also Published As
Publication number | Publication date |
---|---|
CN104484392A (zh) | 2015-04-01 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN104484392B (zh) | 数据库查询语句生成方法及装置 | |
EP3005168B1 (en) | Natural language search results for intent queries | |
US9424351B2 (en) | Hybrid-distribution model for search engine indexes | |
Stefanowski et al. | Carrot 2 and language properties in web search results clustering | |
JP7225229B2 (ja) | 情報推薦方法及び装置、電子機器 | |
CN109002516A (zh) | 一种搜索方法及装置 | |
CN108897761A (zh) | 一种聚簇存储方法及装置 | |
JP2010541092A5 (zh) | ||
CN103942712A (zh) | 基于产品相似度的电子商务推荐***及其方法 | |
CN104462429B (zh) | 数据库查询语句的生成方法及装置 | |
CN105630881A (zh) | 一种rdf的数据存储方法和查询方法 | |
CN104462430A (zh) | 关系型数据库的数据处理方法及装置 | |
CN108399213B (zh) | 一种面向用户个人文件的聚类方法及*** | |
CN105069077A (zh) | 搜索方法及装置 | |
US20120130984A1 (en) | Dynamic query master agent for query execution | |
CN109885651A (zh) | 一种问题推送方法和装置 | |
CN103365923A (zh) | 用于评估数据库的分区方案的方法和装置 | |
JP5552981B2 (ja) | 索引方法、検索方法、及びその記憶媒体 | |
Su et al. | Supporting correlation analysis on scientific datasets in parallel and distributed settings | |
CN106294784B (zh) | 资源搜索方法及装置 | |
CN102043846A (zh) | 一种基于遗传算法的搜索方法及装置 | |
Zhao et al. | A search result ranking algorithm based on web pages and tags clustering | |
CN115099309A (zh) | 一种为图数据的存储和索引设计代价评估模型的方法 | |
Lu et al. | Genderpredictor: a method to predict gender of customers from e-commerce website | |
CN104765835B (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 | ||
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 |