CN104217011A - Method and device for inquiring HBase secondary index table - Google Patents

Method and device for inquiring HBase secondary index table Download PDF

Info

Publication number
CN104217011A
CN104217011A CN201410483879.XA CN201410483879A CN104217011A CN 104217011 A CN104217011 A CN 104217011A CN 201410483879 A CN201410483879 A CN 201410483879A CN 104217011 A CN104217011 A CN 104217011A
Authority
CN
China
Prior art keywords
hbase
secondary index
index table
value
rowkey
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
Application number
CN201410483879.XA
Other languages
Chinese (zh)
Other versions
CN104217011B (en
Inventor
刘璧怡
郭美思
吴楠
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Inspur Beijing Electronic Information Industry Co Ltd
Original Assignee
Inspur Beijing Electronic Information Industry Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Inspur Beijing Electronic Information Industry Co Ltd filed Critical Inspur Beijing Electronic Information Industry Co Ltd
Priority to CN201410483879.XA priority Critical patent/CN104217011B/en
Publication of CN104217011A publication Critical patent/CN104217011A/en
Application granted granted Critical
Publication of CN104217011B publication Critical patent/CN104217011B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/30Information retrieval; Database structures therefor; File system structures therefor of unstructured textual data
    • G06F16/33Querying
    • G06F16/3331Query processing
    • G06F16/334Query execution
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/30Information retrieval; Database structures therefor; File system structures therefor of unstructured textual data
    • G06F16/31Indexing; Data structures therefor; Storage structures
    • G06F16/316Indexing structures

Abstract

The invention provides a method and a device for inquiring an HBase secondary index table. The method comprises the steps of judging whether an HBase source table has a corresponding secondary index table or not, and inquiring a column attribute value of the HBase source table through the secondary index table; establishing the secondary index table corresponding to the HBase source table according to column family information, column information and the column attribute value of the HBase source table and a corresponding Rowkey in the HBase source table if the HBase source table does not have the corresponding secondary index table, and synchronizing data of the HBase source table into the corresponding secondary index table; synchronizing data inserting operation or data deleting operation of the HBase source table into the corresponding secondary index table if the HBase source table has the corresponding secondary index table. According to the method and the device, provided by the invention, the quick inquiring on all recorded information in the column attribute value can be realized, and the purpose of high-efficiency inquiring can be achieved.

Description

The querying method of HBase secondary index table and device
Technical field
The present invention relates to technical field of data processing, particularly relate to a kind of querying method and device of HBase secondary index table.
Background technology
In the epoch of data high-speed development, distributed system becomes very important role.Under the background that large data develop, distributed type assemblies, distributed data base, distributed file system all becomes the focus paid close attention to by people.Under this power trend, Hadoop cluster becomes more ripe distributed system.Distributed data base HBase is constantly perfect in the Hadoop ecosystem, HBase is different from traditional database, it is a database being applicable to unstructured data and storing, there is high scalability, row store, scalable, the feature that can read and write large data in real time, therefore used by a lot of major company, HBase is according to there being the sweetly disposition of good ease for use and key assignments to be welcome widely.
In the inquiry of HBase table, HBase is mainly inquired about by Rowkey, filter can also be utilized to carry out filtering out the information of specific row to meet the demand of user when needing, but HBase does not provide the function going out eligible record according to the property value fast query arranging certain row in race simultaneously.
Summary of the invention
In order to solve the problems of the technologies described above, the invention provides a kind of querying method and device of HBase secondary index table, all recorded informations in certain Column Properties value in fast query HBase table can be realized, thus improve search efficiency.
In order to reach the object of the invention, the invention provides a kind of querying method of HBase secondary index table, comprising: judge whether HBase source table has corresponding secondary index table, by property value in the row of secondary index table inquiry HBase table; If no, according to Rowkey corresponding in the row race information in the table of HBase source, column information, Column Properties value and HBase source table, create and show corresponding secondary index table with HBase source, and the data of synchronous HBase source table are in the secondary index table of correspondence; If had, the data inserting operation of synchronous HBase source table or deletion data operation are in the secondary index table of correspondence.
Further, by property value in the row of described secondary index table inquiry HBase table, comprising: by whole records of property value in the row of secondary index table inquiry HBase table.
Further, according to the row race information in the table of HBase source, column information, the Rowkey that Column Properties value and HBase source are corresponding in showing, create and show corresponding secondary index table with HBase source, and the data of synchronous HBase source table are in the secondary index table of correspondence, comprise: according to the row race information in the table of HBase source, column information, the Rowkey that Column Properties value and HBase source are corresponding in showing, utilize Rowkey and the property value of the secondary index table of revertrow function and Map function creation HBase source table correspondence, and the data of synchronous HBase source table are in the Rowkey and property value of the secondary index table of correspondence.
Further, according to Rowkey corresponding in the row race information in the table of HBase source, column information, Column Properties value and HBase source table, create and show corresponding secondary index table with HBase source, and the data of synchronous HBase source table are in the secondary index table of correspondence, comprise: utilize revertrow function, according to Rowkey corresponding in the row race information in the table of HBase source, column information, Column Properties value and HBase source table, the Rowkey of secondary index table is set; Utilize Map function, according to ImmutableBytesWritable key parameter and Result value parameter, extract Rowkey and the value value in the table of HBase source, travel through each KeyValue and obtain Rowkey in corresponding secondary index table, and the property value of secondary index table is set according to the Rowkey of HBase source table and Column Properties value; In Map function, call revertrow function, the rreturn value Rowkey of revertrow function is preserved, and according to the newly-built Put object of rreturn value Rowkey, for newly-built Put object adds corresponding property value; Use ImmutableBytesWritable object encapsulation, use Context.write event memory.
Further, the data inserting operation of synchronous HBase source table or deletion data operation, in the secondary index table of correspondence, comprising: the parameter increasing the title of secondary index table corresponding to HBase source table in Put function or Delete function; When carrying out data inserting operation or deletion data operation to HBase source table, extract Rowkey and the value value inserted or delete data, Rowkey and the Value value of secondary index table is set according to Rowkey and the Value value extracted; According to the parameter of the title of the secondary index table of HBase source table correspondence, Rowkey and the Value value of the secondary index table of setting is carried out update or deletion action.
An inquiry unit for HBase secondary index table, comprising: judge module, for judging whether HBase source table has corresponding secondary index table, by property value in the row of described secondary index table inquiry HBase table; Creation module, for according to Rowkey corresponding in the row race information in the table of HBase source, column information, Column Properties value and HBase source table, creates and shows corresponding secondary index table with HBase source; Synchronization module, for the data of synchronous HBase source table in the secondary index table of correspondence; The data inserting operation of synchronous HBase source table or deletion data operation are in the secondary index table of correspondence.
Compared with prior art, the present invention includes: judge whether HBase source table has corresponding secondary index table, by property value in the row of secondary index table inquiry HBase table; If no, according to Rowkey corresponding in the row race information in the table of HBase source, column information, Column Properties value and HBase source table, create and show corresponding secondary index table with HBase source, and the data of synchronous HBase source table are in the secondary index table of correspondence; If had, the data inserting operation of synchronous HBase source table or deletion data operation are in the secondary index table of correspondence.The present invention creates and shows corresponding secondary index table with HBase source, and the data of synchronous HBase source table are in the secondary index table of correspondence, the all recorded informations in fast query Column Properties value can be realized by this secondary index table, reach the object of high-level efficiency inquiry.
Accompanying drawing explanation
Fig. 1 is the configuration diagram that the present invention is based on the inquiry of HBase secondary index table.
Fig. 2 is the schematic flow sheet of the querying method of HBase secondary index table of the present invention.
Fig. 3 is the structural representation of the inquiry unit of HBase secondary index table of the present invention.
Embodiment
Below in conjunction with accompanying drawing, the present invention is described in further detail.By these exemplifying embodiments of enough detailed description, those skilled in the art are made to put into practice the present invention.Without departing from the spirit and scope in the present invention, can to implement to make logic, realize and other change.
In the present invention, need to dispose distributed type assemblies environment, such as, this distributed type assemblies environment has 3 nodes, and the configuration of each node is 96G internal memory, and 12 core, hard disk is 12*1T.
Fig. 1 is the configuration diagram that the present invention is based on the inquiry of HBase secondary index table.HBase source table is set up in HBase client, User Table as illustrated in the drawing, also the corresponding secondary index table setting up correspondence, Index Table as illustrated in the drawing, wherein in secondary index table, Rowkey is formed according to corresponding Rowkey in the row race information in the table of HBase source, column information, Column Properties value and HBase source table, and property value corresponding in secondary index table is that in the table of HBase source, Rowkey and Column Properties value are formed.
Fig. 2 is the schematic flow sheet of the querying method of HBase secondary index table of the present invention, as shown in Figure 2, specifically can comprise:
Step 21, judges whether HBase source table has corresponding secondary index table, if do not had, enters step 22; If had, enter step 23.
In this step, HBase client judges whether HBase source table has corresponding secondary index table, the function of this secondary index table is whole records of property value in the row that can realize fast query HBase table, according to the highly-parallel performance of Distributed Architecture there is good time efficiency to during secondary index table handling, set up corresponding secondary index table according to HBase source table, the operation checking the property value meeting a certain row can be made to realize fast and the performance of inquiry can be improved.
Step 22, according to Rowkey corresponding in the row race information in the table of HBase source, column information, Column Properties value and HBase source table, create and show corresponding secondary index table with HBase source, and the data of synchronous HBase source table are in the secondary index table of correspondence, enter step 23.
In this step, according to Rowkey corresponding in the row race information in the table of HBase source, column information, Column Properties value and HBase source table, utilize Rowkey and the property value of the secondary index table of revertrow function and Map function creation HBase source table correspondence, and the data of synchronous HBase source table are in the Rowkey and property value of the secondary index table of correspondence.
Particularly, utilize revertrow function, according to Rowkey corresponding in the row race information in the table of HBase source, column information, Column Properties value and HBase source table, the Rowkey of secondary index table is set.
Utilize Map function, according to ImmutableBytesWritable key parameter and Result value parameter, extract Rowkey and the value value in the table of HBase source, travel through each KeyValue and obtain Rowkey in corresponding secondary index table, and the property value of secondary index table is set according to the Rowkey of HBase source table and Column Properties value.
Revertrow function is called in Map function, the rreturn value Rowkey of revertrow function is preserved, and according to the newly-built Put object of this rreturn value Rowkey, the Put object newly-built for this adds corresponding property value, and this property value is the Rowkey of HBase source table and the combination of Column Properties value that extract.Use ImmutableBytesWritable object encapsulation, use Context.write event memory.
In secondary index table, Rowkey is formed according to corresponding Rowkey in the row race information in the table of HBase source, column information, Column Properties value and HBase source table, property value corresponding in secondary index table is that the value of Rowkey and Column Properties in the table of HBase source is formed, such structure can ensure when inquiring about the record meeting certain Column Properties value in the table of HBase source, operation can realize fast and can improve the performance of inquiry, and can ensure that consistance is shown in data in secondary index table and HBase source.
Step 23, if insert (Put) data manipulation or deletion (Delete) data manipulation to HBase source table, the data inserting operation of synchronous HBase source table or deletion data operation are in the secondary index table of correspondence.
In this step, after corresponding secondary index table is shown in establishment and synchronous HBase source, the operation of HBase source table being inserted or being deleted data may be had, therefore, when carrying out data inserting operation or deletion data operation to HBase source table, need the data inserted according to Put function or Delete function or delete in corresponding secondary index table.
Particularly, in Put function or Delete function, increase the parameter of the title of secondary index table corresponding to HBase source table.When carrying out data inserting operation or deletion data operation to HBase source table, extracting Rowkey and the value value of this insertion or deletion data, Rowkey and the Value value of secondary index table is set according to Rowkey and the Value value extracted.According to the parameter of the title of the secondary index table of HBase source table correspondence, Rowkey and the Value value of the secondary index table of setting is carried out update or deletion action.So, can ensure that consistance is shown in data in secondary index table and HBase source.
The present invention creates and shows corresponding secondary index table with HBase source, and the data of synchronous HBase source table are in the secondary index table of correspondence, the all recorded informations in fast query Column Properties value can be realized by this secondary index table, reach the object of high-level efficiency inquiry.
Fig. 3 is the structural representation of the inquiry unit of HBase secondary index table of the present invention, as shown in Figure 3, specifically can comprise:
Judge module, for judging whether HBase source table has corresponding secondary index table;
Creation module, for according to Rowkey corresponding in the row race information in the table of HBase source, column information, Column Properties value and HBase source table, creates and shows corresponding secondary index table with HBase source;
Synchronization module, for the data of synchronous HBase source table in the secondary index table of correspondence; The data inserting operation of synchronous HBase source table or deletion data operation are in the secondary index table of correspondence.
The inquiry unit of HBase secondary index table is corresponding with the querying method of HBase secondary index table, therefore, details that what the inquiry unit of HBase secondary index table was concrete realize can referring to the querying method of HBase secondary index table, be not repeated herein.
The secondary index table that the present invention creates and synchronous HBase source table is corresponding, can realize all recorded informations in fast query Column Properties value by this secondary index table, reaches the object of high-level efficiency inquiry.
Be to be understood that, although this instructions is described according to embodiment, but not each embodiment only comprises an independently technical scheme, this narrating mode of instructions is only for clarity sake, those skilled in the art should by instructions integrally, technical scheme in each embodiment also through appropriately combined, can form other embodiments that it will be appreciated by those skilled in the art that.
A series of detailed description listed is above only illustrating for feasibility embodiment of the present invention; they are not for limiting the scope of the invention, all do not depart from equivalent implementations that skill of the present invention spirit does or change all should be included within protection scope of the present invention.

Claims (10)

1. a querying method for HBase secondary index table, is characterized in that, comprising:
Judge whether HBase source table has corresponding secondary index table, by property value in the row of described secondary index table inquiry HBase table;
If no, according to Rowkey corresponding in the row race information in the table of HBase source, column information, Column Properties value and HBase source table, create and show corresponding secondary index table with HBase source, and the data of synchronous HBase source table are in the secondary index table of correspondence;
If had, the data inserting operation of synchronous HBase source table or deletion data operation are in the secondary index table of correspondence.
2. the querying method of HBase secondary index table according to claim 1, is characterized in that, described by property value in the row of described secondary index table inquiry HBase table, comprising:
By whole records of property value in the row of described secondary index table inquiry HBase table.
3. the querying method of HBase secondary index table according to claim 1, it is characterized in that, described according to Rowkey corresponding in the row race information in the table of HBase source, column information, Column Properties value and HBase source table, create and show corresponding secondary index table with HBase source, and the data of synchronous HBase source table are in the secondary index table of correspondence, comprising:
According to Rowkey corresponding in the row race information in the table of HBase source, column information, Column Properties value and HBase source table, utilize Rowkey and the property value of the secondary index table of revertrow function and Map function creation HBase source table correspondence, and the data of synchronous HBase source table are in the Rowkey and property value of the secondary index table of correspondence.
4. the querying method of the HBase secondary index table according to claim 1 or 3, it is characterized in that, described according to Rowkey corresponding in the row race information in the table of HBase source, column information, Column Properties value and HBase source table, create and show corresponding secondary index table with HBase source, and the data of synchronous HBase source table are in the secondary index table of correspondence, comprising:
Utilize revertrow function, according to Rowkey corresponding in the row race information in the table of HBase source, column information, Column Properties value and HBase source table, the Rowkey of secondary index table is set;
Utilize Map function, according to ImmutableBytesWritable key parameter and Result value parameter, extract Rowkey and the value value in the table of HBase source, travel through each KeyValue and obtain Rowkey in corresponding secondary index table, and the property value of secondary index table is set according to the Rowkey of HBase source table and Column Properties value;
In Map function, call revertrow function, the rreturn value Rowkey of revertrow function is preserved, and according to the newly-built Put object of rreturn value Rowkey, for newly-built Put object adds corresponding property value;
Use ImmutableBytesWritable object encapsulation, use Context.write event memory.
5. the querying method of HBase secondary index table according to claim 1, is characterized in that, the data inserting operation of described synchronous HBase source table or deletion data operation, in the secondary index table of correspondence, comprising:
The parameter of the title of secondary index table corresponding to HBase source table is increased in Put function or Delete function;
When carrying out data inserting operation or deletion data operation to HBase source table, extract Rowkey and the value value inserted or delete data, Rowkey and the Value value of secondary index table is set according to Rowkey and the Value value extracted;
According to the parameter of the title of the secondary index table of HBase source table correspondence, Rowkey and the Value value of the secondary index table of setting is carried out update or deletion action.
6. an inquiry unit for HBase secondary index table, is characterized in that, comprising:
Judge module, for judging whether HBase source table has corresponding secondary index table, by property value in the row of described secondary index table inquiry HBase table;
Creation module, for according to Rowkey corresponding in the row race information in the table of HBase source, column information, Column Properties value and HBase source table, creates and shows corresponding secondary index table with HBase source;
Synchronization module, for the data of synchronous HBase source table in the secondary index table of correspondence; The data inserting operation of synchronous HBase source table or deletion data operation are in the secondary index table of correspondence.
7. the inquiry unit of HBase secondary index table according to claim 6, is characterized in that, described judge module specifically for: by whole records of property value in the row of described secondary index table inquiry HBase table.
8. the inquiry unit of HBase secondary index table according to claim 6, it is characterized in that, described creation module specifically for: according to Rowkey corresponding in the row race information in the table of HBase source, column information, Column Properties value and HBase source table, utilize Rowkey and the property value of revertrow function and secondary index table corresponding to Map function creation HBase source table.
9. the inquiry unit of HBase secondary index table according to claim 8, is characterized in that, described creation module utilizes Rowkey and the property value of the secondary index table of revertrow function and Map function creation HBase source table correspondence, is specially:
Described creation module utilizes revertrow function, according to Rowkey corresponding in the row race information in the table of HBase source, column information, Column Properties value and HBase source table, arranges the Rowkey of secondary index table; Utilize Map function, according to ImmutableBytesWritable key parameter and Result value parameter, extract Rowkey and the value value in the table of HBase source, travel through each KeyValue and obtain Rowkey in corresponding secondary index table, and the property value of secondary index table is set according to the Rowkey of HBase source table and Column Properties value; In Map function, call revertrow function, the rreturn value Rowkey of revertrow function is preserved, and according to the newly-built Put object of rreturn value Rowkey, for newly-built Put object adds corresponding property value; Use ImmutableBytesWritable object encapsulation, use Context.write event memory.
10. the inquiry unit of HBase secondary index table according to claim 6, it is characterized in that, the data inserting operation of described synchronization module synchronous HBase source table or deletion data operation, in the secondary index table of correspondence, are specially: the parameter increasing the title of secondary index table corresponding to HBase source table in Put function or Delete function; When carrying out data inserting operation or deletion data operation to HBase source table, extract Rowkey and the value value inserted or delete data, Rowkey and the Value value of secondary index table is set according to Rowkey and the Value value extracted; According to the parameter of the title of the secondary index table of HBase source table correspondence, Rowkey and the Value value of the secondary index table of setting is carried out update or deletion action.
CN201410483879.XA 2014-09-19 2014-09-19 The querying method and device of HBase secondary index tables Active CN104217011B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201410483879.XA CN104217011B (en) 2014-09-19 2014-09-19 The querying method and device of HBase secondary index tables

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201410483879.XA CN104217011B (en) 2014-09-19 2014-09-19 The querying method and device of HBase secondary index tables

Publications (2)

Publication Number Publication Date
CN104217011A true CN104217011A (en) 2014-12-17
CN104217011B CN104217011B (en) 2017-08-25

Family

ID=52098501

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201410483879.XA Active CN104217011B (en) 2014-09-19 2014-09-19 The querying method and device of HBase secondary index tables

Country Status (1)

Country Link
CN (1) CN104217011B (en)

Cited By (10)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN104834688A (en) * 2015-04-20 2015-08-12 北京奇艺世纪科技有限公司 Secondary index establishment method and device
CN105069151A (en) * 2015-08-24 2015-11-18 用友网络科技股份有限公司 HBase secondary index construction apparatus and method
CN105404676A (en) * 2015-11-20 2016-03-16 中国科学院计算技术研究所 HBase secondary index updating method and system based on HFile
CN105426437A (en) * 2015-11-05 2016-03-23 西安翔迅科技有限责任公司 HBase-based storage method of intelligent transportation field checkpost data
CN106383860A (en) * 2016-08-31 2017-02-08 无锡雅座在线科技发展有限公司 Data query method and apparatus
CN106503243A (en) * 2016-11-08 2017-03-15 国网山东省电力公司电力科学研究院 Electric power big data querying method and system based on HBase secondary indexs
CN105404676B (en) * 2015-11-20 2018-08-31 中国科学院计算技术研究所 A kind of HBase secondary indexs update method and system based on HFile
CN108667929A (en) * 2018-05-08 2018-10-16 浪潮软件集团有限公司 Method for synchronizing data to elastic search based on HBase coprocessor
CN109063186A (en) * 2018-08-27 2018-12-21 郑州云海信息技术有限公司 A kind of General query method and relevant apparatus
CN110659328A (en) * 2019-08-30 2020-01-07 中国人民财产保险股份有限公司 Data query method, device, equipment and computer readable storage medium

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102193917A (en) * 2010-03-01 2011-09-21 中国移动通信集团公司 Method and device for processing and querying data
CN102314503A (en) * 2011-09-01 2012-01-11 浪潮(北京)电子信息产业有限公司 Indexing method
US20130282668A1 (en) * 2012-04-20 2013-10-24 Cloudera, Inc. Automatic repair of corrupt hbases

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102193917A (en) * 2010-03-01 2011-09-21 中国移动通信集团公司 Method and device for processing and querying data
CN102314503A (en) * 2011-09-01 2012-01-11 浪潮(北京)电子信息产业有限公司 Indexing method
US20130282668A1 (en) * 2012-04-20 2013-10-24 Cloudera, Inc. Automatic repair of corrupt hbases

Non-Patent Citations (2)

* Cited by examiner, † Cited by third party
Title
刘家志: "基于Hadoop架构和多级索引技术的医学影像存储检索系统研究", 《万方数据》 *
卓海艺: "基于HBase的海量数据实时查询系统设计与实现", 《中国优秀硕士论文全文数据库 信息科技辑》 *

Cited By (12)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN104834688A (en) * 2015-04-20 2015-08-12 北京奇艺世纪科技有限公司 Secondary index establishment method and device
CN105069151A (en) * 2015-08-24 2015-11-18 用友网络科技股份有限公司 HBase secondary index construction apparatus and method
CN105426437A (en) * 2015-11-05 2016-03-23 西安翔迅科技有限责任公司 HBase-based storage method of intelligent transportation field checkpost data
CN105404676A (en) * 2015-11-20 2016-03-16 中国科学院计算技术研究所 HBase secondary index updating method and system based on HFile
CN105404676B (en) * 2015-11-20 2018-08-31 中国科学院计算技术研究所 A kind of HBase secondary indexs update method and system based on HFile
CN106383860A (en) * 2016-08-31 2017-02-08 无锡雅座在线科技发展有限公司 Data query method and apparatus
CN106503243A (en) * 2016-11-08 2017-03-15 国网山东省电力公司电力科学研究院 Electric power big data querying method and system based on HBase secondary indexs
CN106503243B (en) * 2016-11-08 2019-08-06 国网山东省电力公司电力科学研究院 Electric power big data querying method based on HBase secondary index
CN108667929A (en) * 2018-05-08 2018-10-16 浪潮软件集团有限公司 Method for synchronizing data to elastic search based on HBase coprocessor
CN109063186A (en) * 2018-08-27 2018-12-21 郑州云海信息技术有限公司 A kind of General query method and relevant apparatus
CN110659328A (en) * 2019-08-30 2020-01-07 中国人民财产保险股份有限公司 Data query method, device, equipment and computer readable storage medium
CN110659328B (en) * 2019-08-30 2022-04-29 中国人民财产保险股份有限公司 Data query method, device, equipment and computer readable storage medium

Also Published As

Publication number Publication date
CN104217011B (en) 2017-08-25

Similar Documents

Publication Publication Date Title
CN104217011A (en) Method and device for inquiring HBase secondary index table
CN105701098B (en) The method and apparatus for generating index for the table in database
CN103167172B (en) Integration method and system for variety of chat records
CN111190904B (en) Method and device for hybrid storage of graph-relational database
CN107807932B (en) Hierarchical data management method and system based on path enumeration
CN102906751A (en) Method and device for data storage and data query
EP2778953A1 (en) Encoded-search database device, method for adding and deleting data for encoded search, and addition/deletion program
CN109726177A (en) A kind of mass file subregion indexing means based on HBase
CN102508913A (en) Cloud computing system with data cube storage index structure
CN106250393A (en) The short text understanding method of a kind of knowledge based collection of illustrative plates and device
CN103345521A (en) Method and device for processing key values in hash table database
CN102622434A (en) Data storage method, data searching method and device
CN106250552A (en) Search engine results page is assembled WEB page
CN106326040B (en) Snapshot metadata management method and device
CN106294886A (en) A kind of method and system of full dose extracted data from HBase
CN103744952A (en) Method and system for implementing multi-table property of NoSQL database
JP6752547B2 (en) Database management method and database management system
CN107273368A (en) Mass data storage management method, device and data-storage system
CN103207916B (en) The method and apparatus of metadata processing
CN102262633A (en) Structural data safe retrieving method oriented to full text retrieval
CN108984626B (en) Data processing method and device and server
CN102685222B (en) A kind of cloud SRM device for electric power system
CN103678041A (en) Incremental backup method and system
CN102622361B (en) Method for querying database
CN103365960A (en) Off-line searching method of structured data of electric power multistage dispatching management

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