CN101963993A - Method for fast searching database sheet table record - Google Patents
Method for fast searching database sheet table record Download PDFInfo
- Publication number
- CN101963993A CN101963993A CN 201010514250 CN201010514250A CN101963993A CN 101963993 A CN101963993 A CN 101963993A CN 201010514250 CN201010514250 CN 201010514250 CN 201010514250 A CN201010514250 A CN 201010514250A CN 101963993 A CN101963993 A CN 101963993A
- Authority
- CN
- China
- Prior art keywords
- data
- query
- database
- list table
- query result
- 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
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Description
Claims (7)
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201010514250A CN101963993B (en) | 2010-10-21 | 2010-10-21 | Method for fast searching database sheet table record |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201010514250A CN101963993B (en) | 2010-10-21 | 2010-10-21 | Method for fast searching database sheet table record |
Publications (2)
Publication Number | Publication Date |
---|---|
CN101963993A true CN101963993A (en) | 2011-02-02 |
CN101963993B CN101963993B (en) | 2012-08-29 |
Family
ID=43516866
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201010514250A Expired - Fee Related CN101963993B (en) | 2010-10-21 | 2010-10-21 | Method for fast searching database sheet table record |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN101963993B (en) |
Cited By (7)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN103345468A (en) * | 2013-05-13 | 2013-10-09 | 中国科学技术大学 | Building material thermal physics performance database system based on solar building |
WO2013168058A1 (en) * | 2012-05-07 | 2013-11-14 | International Business Machines Corporation | Optimizing queries using predicate mappers |
CN105550271A (en) * | 2015-12-10 | 2016-05-04 | 成都广达新网科技股份有限公司 | Memory database query method and device based on key value pairs |
CN106156162A (en) * | 2015-04-15 | 2016-11-23 | 阿里巴巴集团控股有限公司 | Data base querying amount statistical method and equipment |
CN107133300A (en) * | 2017-04-27 | 2017-09-05 | 福建中金在线信息科技有限公司 | A kind of data query method and device |
CN112416924A (en) * | 2019-08-22 | 2021-02-26 | 富泰华工业(深圳)有限公司 | Data synchronous query method and device, computer device and storage medium |
CN113282607A (en) * | 2021-06-02 | 2021-08-20 | 山东健康医疗大数据有限公司 | Optimized query method for database |
Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20050065925A1 (en) * | 2003-09-23 | 2005-03-24 | Salesforce.Com, Inc. | Query optimization in a multi-tenant database system |
CN101021874A (en) * | 2007-03-21 | 2007-08-22 | 金蝶软件(中国)有限公司 | Method and apparatus for optimizing request to poll SQL |
CN101093493A (en) * | 2006-06-23 | 2007-12-26 | 国际商业机器公司 | Speech conversion method for database inquiry, converter, and database inquiry system |
-
2010
- 2010-10-21 CN CN201010514250A patent/CN101963993B/en not_active Expired - Fee Related
Patent Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20050065925A1 (en) * | 2003-09-23 | 2005-03-24 | Salesforce.Com, Inc. | Query optimization in a multi-tenant database system |
CN101093493A (en) * | 2006-06-23 | 2007-12-26 | 国际商业机器公司 | Speech conversion method for database inquiry, converter, and database inquiry system |
CN101021874A (en) * | 2007-03-21 | 2007-08-22 | 金蝶软件(中国)有限公司 | Method and apparatus for optimizing request to poll SQL |
Non-Patent Citations (2)
Title |
---|
《现代电子技术》 20100430 张敏 SQL查询语句优化研究 第152-153,156页 1-7 , 第4期 2 * |
《科技资讯》 20100930 赵红雨 浅谈数据库查询优化方法 第18页 1-7 , 第9期 2 * |
Cited By (10)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
WO2013168058A1 (en) * | 2012-05-07 | 2013-11-14 | International Business Machines Corporation | Optimizing queries using predicate mappers |
US8812491B2 (en) | 2012-05-07 | 2014-08-19 | International Business Machines Corporation | Optimizing queries using predicate mappers |
CN103345468A (en) * | 2013-05-13 | 2013-10-09 | 中国科学技术大学 | Building material thermal physics performance database system based on solar building |
CN103345468B (en) * | 2013-05-13 | 2017-03-29 | 中国科学技术大学 | A kind of construction material thermal physical property data storehouse system based on solar building |
CN106156162A (en) * | 2015-04-15 | 2016-11-23 | 阿里巴巴集团控股有限公司 | Data base querying amount statistical method and equipment |
CN105550271A (en) * | 2015-12-10 | 2016-05-04 | 成都广达新网科技股份有限公司 | Memory database query method and device based on key value pairs |
CN105550271B (en) * | 2015-12-10 | 2018-12-25 | 成都广达新网科技股份有限公司 | A kind of memory database querying method and device based on key-value pair |
CN107133300A (en) * | 2017-04-27 | 2017-09-05 | 福建中金在线信息科技有限公司 | A kind of data query method and device |
CN112416924A (en) * | 2019-08-22 | 2021-02-26 | 富泰华工业(深圳)有限公司 | Data synchronous query method and device, computer device and storage medium |
CN113282607A (en) * | 2021-06-02 | 2021-08-20 | 山东健康医疗大数据有限公司 | Optimized query method for database |
Also Published As
Publication number | Publication date |
---|---|
CN101963993B (en) | 2012-08-29 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN108874971B (en) | Tool and method applied to mass tagged entity data storage | |
CN111459985B (en) | Identification information processing method and device | |
CN101963993B (en) | Method for fast searching database sheet table record | |
CN104536904B (en) | A kind of method of data management, equipment and system | |
CN100468402C (en) | Sort data storage and split catalog inquiry method based on catalog tree | |
CN103631909B (en) | System and method for combined processing of large-scale structured and unstructured data | |
CN107491487B (en) | Full-text database architecture and bitmap index creation and data query method, server and medium | |
CN102930060B (en) | A kind of method of database quick indexing and device | |
US20070124277A1 (en) | Index and Method for Extending and Querying Index | |
CN110109910A (en) | Data processing method and system, electronic equipment and computer readable storage medium | |
CN106528847A (en) | Multi-dimensional processing method and system for massive data | |
CN101452487B (en) | Data loading method and system, and data loading unit | |
CN103902698A (en) | Data storage system and data storage method | |
CN103577440A (en) | Data processing method and device in non-relational database | |
CN101727502A (en) | Data query method, data query device and data query system | |
CN101196900A (en) | Information searching method based on metadata | |
CN104111955A (en) | Combined inquiring method oriented to Hbase database | |
CN104239377A (en) | Platform-crossing data retrieval method and device | |
CN104123366A (en) | Search method and server | |
US9626401B1 (en) | Systems and methods for high-speed searching and filtering of large datasets | |
CN104391908B (en) | Multiple key indexing means based on local sensitivity Hash on a kind of figure | |
CN105630934A (en) | Data statistic method and system | |
CN107609151A (en) | The method that XBRL instance documents caching is realized based on Redis | |
CN103473324A (en) | Multi-dimensional service attribute retrieving device and method based on unstructured data storage | |
CN101408882B (en) | Method and system for searching authorization document |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
C14 | Grant of patent or utility model | ||
GR01 | Patent grant | ||
C41 | Transfer of patent application or patent right or utility model | ||
CB03 | Change of inventor or designer information |
Inventor after: Liu Zhen Inventor after: Sun Min Inventor after: Zhang Xiaofei Inventor after: Qian Ping Inventor after: Luo Yong Inventor after: Liu Wangchun Inventor after: Huang Dongdong Inventor after: Huang Chunyan Inventor after: Zhou Jia Inventor before: Liu Zhen Inventor before: Sun Min Inventor before: Zhang Xiaofei Inventor before: Qian Ping |
|
COR | Change of bibliographic data | ||
TR01 | Transfer of patent right |
Effective date of registration: 20160620 Address after: 212003 Zhenjiang City, Jiangsu province dream Creek Road, No. 2 Patentee after: Jiangsu University of Science and Technology Patentee after: Nantong Power Supply Company, Jiangsu Electric Power Co., Ltd. Address before: 212003 Zhenjiang City, Jiangsu province dream Creek Road, No. 2 Patentee before: Jiangsu University of Science and Technology |
|
CF01 | Termination of patent right due to non-payment of annual fee | ||
CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20120829 Termination date: 20161021 |