CN107229672A - 一种针对SolrCloud的大数据SQL查询方法及*** - Google Patents
一种针对SolrCloud的大数据SQL查询方法及*** Download PDFInfo
- Publication number
- CN107229672A CN107229672A CN201710261610.0A CN201710261610A CN107229672A CN 107229672 A CN107229672 A CN 107229672A CN 201710261610 A CN201710261610 A CN 201710261610A CN 107229672 A CN107229672 A CN 107229672A
- Authority
- CN
- China
- Prior art keywords
- query
- solr
- sql
- solrcloud
- page
- 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.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 25
- 238000013507 mapping Methods 0.000 claims abstract description 11
- 238000005457 optimization Methods 0.000 claims description 28
- 238000013519 translation Methods 0.000 claims description 18
- 238000004458 analytical method Methods 0.000 claims description 15
- 238000001914 filtration Methods 0.000 claims description 5
- 230000007246 mechanism Effects 0.000 claims description 5
- 230000002452 interceptive effect Effects 0.000 description 6
- 239000008186 active pharmaceutical agent Substances 0.000 description 5
- 230000008569 process Effects 0.000 description 5
- 238000013461 design Methods 0.000 description 4
- 230000006870 function Effects 0.000 description 4
- 230000004048 modification Effects 0.000 description 4
- 238000004364 calculation method Methods 0.000 description 3
- 238000010586 diagram Methods 0.000 description 3
- 230000003139 buffering effect Effects 0.000 description 2
- 238000004519 manufacturing process Methods 0.000 description 2
- 238000013508 migration Methods 0.000 description 2
- 230000005012 migration Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 229910021532 Calcite Inorganic materials 0.000 description 1
- OYPRJOBELJOOCE-UHFFFAOYSA-N Calcium Chemical compound [Ca] OYPRJOBELJOOCE-UHFFFAOYSA-N 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 229910052791 calcium Inorganic materials 0.000 description 1
- 239000011575 calcium Substances 0.000 description 1
- 238000010276 construction Methods 0.000 description 1
- 230000001419 dependent effect Effects 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 238000005538 encapsulation Methods 0.000 description 1
- 239000002360 explosive Substances 0.000 description 1
- 230000009191 jumping Effects 0.000 description 1
- 238000012423 maintenance Methods 0.000 description 1
- 238000007726 management method Methods 0.000 description 1
- 238000002360 preparation method Methods 0.000 description 1
- 238000012545 processing Methods 0.000 description 1
- 238000012216 screening Methods 0.000 description 1
- 238000007493 shaping process Methods 0.000 description 1
- 238000003860 storage Methods 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 238000012360 testing method 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/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
-
- 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/242—Query formulation
- G06F16/2423—Interactive query statement specification based on a database schema
-
- 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/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computing Systems (AREA)
- Mathematical Physics (AREA)
- Computational Linguistics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Description
Claims (10)
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201710261610.0A CN107229672A (zh) | 2017-04-20 | 2017-04-20 | 一种针对SolrCloud的大数据SQL查询方法及*** |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201710261610.0A CN107229672A (zh) | 2017-04-20 | 2017-04-20 | 一种针对SolrCloud的大数据SQL查询方法及*** |
Publications (1)
Publication Number | Publication Date |
---|---|
CN107229672A true CN107229672A (zh) | 2017-10-03 |
Family
ID=59933128
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201710261610.0A Pending CN107229672A (zh) | 2017-04-20 | 2017-04-20 | 一种针对SolrCloud的大数据SQL查询方法及*** |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN107229672A (zh) |
Cited By (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN109241085A (zh) * | 2018-09-20 | 2019-01-18 | 潘丽华 | 一种针对SolrCloud的大数据SQL查询方法 |
CN110109892A (zh) * | 2018-01-25 | 2019-08-09 | 杭州海康威视数字技术股份有限公司 | 一种数据迁移方法、装置及电子设备 |
CN110232106A (zh) * | 2019-04-26 | 2019-09-13 | 安徽四创电子股份有限公司 | 一种基于MongoDB和Solr的海量数据存储及快速检索方法 |
Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102426612A (zh) * | 2012-01-13 | 2012-04-25 | 广州从兴电子开发有限公司 | 条件对象查询方法及*** |
CN103544211A (zh) * | 2013-09-04 | 2014-01-29 | 广东全通教育股份有限公司 | 一种将对象转化为sql语句的通用查询***及方法 |
CN105224633A (zh) * | 2015-09-24 | 2016-01-06 | 北京锐安科技有限公司 | 基于SQL语言的solr查询方法及装置 |
-
2017
- 2017-04-20 CN CN201710261610.0A patent/CN107229672A/zh active Pending
Patent Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102426612A (zh) * | 2012-01-13 | 2012-04-25 | 广州从兴电子开发有限公司 | 条件对象查询方法及*** |
CN103544211A (zh) * | 2013-09-04 | 2014-01-29 | 广东全通教育股份有限公司 | 一种将对象转化为sql语句的通用查询***及方法 |
CN105224633A (zh) * | 2015-09-24 | 2016-01-06 | 北京锐安科技有限公司 | 基于SQL语言的solr查询方法及装置 |
Non-Patent Citations (1)
Title |
---|
GREENWOLF: "solr-sql是针对solrcloud封装的sql编程接口", 《HTTPS://JAVA.CTOLIB.COM/SOLR-SQL.HTML》 * |
Cited By (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN110109892A (zh) * | 2018-01-25 | 2019-08-09 | 杭州海康威视数字技术股份有限公司 | 一种数据迁移方法、装置及电子设备 |
CN110109892B (zh) * | 2018-01-25 | 2021-09-10 | 杭州海康威视数字技术股份有限公司 | 一种数据迁移方法、装置及电子设备 |
CN109241085A (zh) * | 2018-09-20 | 2019-01-18 | 潘丽华 | 一种针对SolrCloud的大数据SQL查询方法 |
CN109241085B (zh) * | 2018-09-20 | 2022-06-21 | 郴州职业技术学院 | 一种针对SolrCloud的大数据SQL查询方法 |
CN110232106A (zh) * | 2019-04-26 | 2019-09-13 | 安徽四创电子股份有限公司 | 一种基于MongoDB和Solr的海量数据存储及快速检索方法 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN106934062B (zh) | 一种查询elasticsearch的实现方法及*** | |
US9430494B2 (en) | Spatial data cartridge for event processing systems | |
US7539669B2 (en) | Methods and systems for providing guided navigation | |
CN105989150B (zh) | 一种基于大数据环境的数据查询方法及装置 | |
CN109426725B (zh) | 数据脱敏方法、设备及计算机可读存储介质 | |
US8838527B2 (en) | Virtual environment spanning desktop and cloud | |
US10210203B2 (en) | Query translation for searching complex structures of objects | |
US6691122B1 (en) | Methods, systems, and computer program products for compiling information into information categories using an expert system | |
US9824128B1 (en) | System for performing single query searches of heterogeneous and dispersed databases | |
WO2004012057A3 (en) | Method and system of unifying data | |
JP2007249785A (ja) | コンパイルプログラム、仮想データベースリモートアクセス用プログラムの製造方法、及び仮想データベースのリモートアクセス方法 | |
US20060200452A1 (en) | Method for translating syntax of patent information search | |
CN109947770A (zh) | 一种数据库查询方法、终端设备及存储介质 | |
CN107229672A (zh) | 一种针对SolrCloud的大数据SQL查询方法及*** | |
CN1689298A (zh) | 用于自主计算的合成服务 | |
US9373093B2 (en) | Gateway service manager for business object applications | |
CN114065765A (zh) | 结合ai和rpa的武器装备文本处理方法、装置及电子设备 | |
CN113297251A (zh) | 多源数据检索方法、装置、设备及存储介质 | |
EP3014472B1 (en) | Generating a logical representation from a physical flow | |
Zou et al. | From a stream of relational queries to distributed stream processing | |
US10140335B2 (en) | Calculation scenarios with extended semantic nodes | |
WO2023033847A1 (en) | System and method of fetching data from an external program | |
Marathe et al. | Integrating the Orca Optimizer into MySQL. | |
CN105183736A (zh) | 网络设备配置及状态信息的整合搜索***及方法 | |
Telang et al. | Information integration across heterogeneous sources: Where do we stand and how to proceed? |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
TA01 | Transfer of patent application right |
Effective date of registration: 20180910 Address after: 510000 903-907 room of 901 room 901, 105 Whampoa Road, Whampoa, Guangdong Applicant after: Zhongke wisdom water transportation technology innovation (Guangzhou) Co.,Ltd. Address before: 100190 South four street, Zhongguancun, Haidian District, Beijing, 4 Applicant before: Computer Network Information Center, Chinese Academy of Sciences |
|
TA01 | Transfer of patent application right | ||
CB02 | Change of applicant information |
Address after: 510000 903-907 room of 901 room 901, 105 Whampoa Road, Whampoa, Guangdong Applicant after: Zhongke Intelligent Transportation Technology (Guangzhou) Co.,Ltd. Address before: 510000 903-907 room of 901 room 901, 105 Whampoa Road, Whampoa, Guangdong Applicant before: Zhongke wisdom water transportation technology innovation (Guangzhou) Co.,Ltd. |
|
CB02 | Change of applicant information | ||
TA01 | Transfer of patent application right |
Effective date of registration: 20200422 Address after: 100190 No. four, 4 South Street, Haidian District, Beijing, Zhongguancun Applicant after: Computer Network Information Center, Chinese Academy of Sciences Address before: 510000 903-907 room of 901 room 901, 105 Whampoa Road, Whampoa, Guangdong Applicant before: Zhongke Intelligent Transportation Technology (Guangzhou) Co.,Ltd. |
|
TA01 | Transfer of patent application right | ||
WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20171003 |
|
WD01 | Invention patent application deemed withdrawn after publication |