CN105740374A - Distributed memory based three-dimensional platform data fuzzy query method - Google Patents

Distributed memory based three-dimensional platform data fuzzy query method Download PDF

Info

Publication number
CN105740374A
CN105740374A CN201610055495.7A CN201610055495A CN105740374A CN 105740374 A CN105740374 A CN 105740374A CN 201610055495 A CN201610055495 A CN 201610055495A CN 105740374 A CN105740374 A CN 105740374A
Authority
CN
China
Prior art keywords
distributed memory
circuit
power station
initial consonant
query method
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
CN201610055495.7A
Other languages
Chinese (zh)
Other versions
CN105740374B (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.)
SHANGHAI SHINE ENERGY INFO-TECH Co Ltd
State Grid Shanghai Electric Power Co Ltd
Original Assignee
SHANGHAI SHINE ENERGY INFO-TECH Co Ltd
State Grid Shanghai Electric Power 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 SHANGHAI SHINE ENERGY INFO-TECH Co Ltd, State Grid Shanghai Electric Power Co Ltd filed Critical SHANGHAI SHINE ENERGY INFO-TECH Co Ltd
Priority to CN201610055495.7A priority Critical patent/CN105740374B/en
Publication of CN105740374A publication Critical patent/CN105740374A/en
Application granted granted Critical
Publication of CN105740374B publication Critical patent/CN105740374B/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/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/245Query processing
    • G06F16/2458Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
    • G06F16/2468Fuzzy queries

Landscapes

  • Engineering & Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • Theoretical Computer Science (AREA)
  • Fuzzy Systems (AREA)
  • Mathematical Physics (AREA)
  • Software Systems (AREA)
  • Probability & Statistics with Applications (AREA)
  • Computational Linguistics (AREA)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Automation & Control Theory (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The invention relates to a distributed memory based three-dimensional platform data fuzzy query method. The method comprises the steps of 1) loading a retrieval keyword and analyzing the loaded retrieval keyword into an initial sequence and a digital sequence; 2) according to the initial sequence and the digital sequence, performing retrieval in an index module to obtain a plurality of id sets, and obtaining intersections of all the id sets; 3) judging whether the intersections of all the id sets are empty sets or not, if yes, performing the step 4), and if not, performing the step 5); 4) prompting that the keyword is wrong and the re-input is required; and 5) according to ids in the intersections, querying and reading corresponding model data in a distributed memory system. Compared with the prior art, the method has the advantages of high memory utilization efficiency, good query experience and the like.

Description

Three-dimensional platform data fuzzy query method based on distributed memory
Technical field
The present invention relates to a kind of data query technique, especially relate to a kind of three-dimensional platform data fuzzy query method based on distributed memory.
Background technology
Under virtual reality and big data environment, utilize traditional data base, access mass data, there is performance bottleneck, so can cause that image can not be displayed in the outut device of client in time.For ensureing in the stipulated time, from mass data, inquire the data wanted, the distributed memory that we introduce.Existing memory scheme is in data buffer storage to the internal memory of server, although this method implements fairly simple, it can be difficult to ensure the concordance of the data of internal memory and data base, so, client passes through fuzzy query, it is difficult to ensure correctness and the integrity of data.It is data cached that this method is introduced into distributed memory, to solve access performance bottleneck.Certainly, simply simple next data cached with distributed memory, also there will be the situation that the data of internal memory and data base are inconsistent.We not only to consider the problem of data access speed, also to ensure the correctness of data simultaneously.
Summary of the invention
Defect that the purpose of the present invention is contemplated to overcome above-mentioned prior art to exist and a kind of three-dimensional platform data fuzzy query method based on distributed memory is provided.
The purpose of the present invention can be achieved through the following technical solutions:
A kind of three-dimensional platform data fuzzy query method based on distributed memory, including step:
1) it is loaded into search key, and the search key being loaded onto resolves to initial consonant sequence and Serial No.;
2) obtain multiple id set according to initial consonant sequence and Serial No. are retrieved in index module, and obtain all id intersection of sets collection;
3) judge that whether all id intersection of sets integrate as empty set, if it has, then perform step 4), if it has not, then perform step 5);
4) prompting key word mistake, it is desirable to re-enter;
5) in distributed memory system, the model data of correspondence is inquired about and reads according to the id in occuring simultaneously.
In distributed memory system, first set up a vang and draw, then pass through index, obtain all id satisfied condition, further according to id, inquire data, so, in ideal conditions, by an original database access, become the access of three internal memories, it is possible to improve inquiry velocity.
Described step 1) specifically include step:
11) it is loaded into search key, and extracts the initial consonant of all of which Chinese character, and form initial consonant sequence;
12) judge whether search key exists numeral, if it has, then perform step 13), if it has not, be then parsed;
13) extract all of numeral, and form Serial No..
Described step 2) specifically include step:
21) an id set is obtained according to each initial consonant in initial consonant sequence, particularly as follows: index obtains containing the power station of this initial consonant or the id that circuit is corresponding in all titles in index module;
22) an id set is obtained according to each numeral in Serial No., particularly as follows: index obtains containing the power station of this numeral or the id that circuit is corresponding in all titles in index module;
23) all of id set is sought common ground.
Described step 5) specifically include step:
51) title of the power station corresponding for all id in common factor or circuit is shown to user, user after selecting, it may be judged whether model data can be inquired, if it has, then perform step 52), if it has not, then perform step 53);
52) power station chosen according to user or the id of circuit inquire about the model data of correspondence in distributed memory system;
53) power station chosen according to user or the id of circuit inquire about the account information and model data that obtain power station or circuit in data base, and store the model data obtained in distributed memory system according to the id in account information.
Described account information includes power station or the id of circuit, title, electric pressure and affiliated unit.
A kind of three-dimensional platform data fuzzy query method based on distributed memory according to claim 4, it is characterised in that described step 51) in the sort by of title of power station or circuit be: the number of times that the model data of this power station or circuit is read.
Described sort by is particularly as follows: the number of times that is read within the setting time of the model data of this power station or circuit.
Compared with prior art, the invention have the advantages that
1) under three-dimensional platform, fuzzy query is carried out according to initial consonant sequence and Serial No., when client uses phonetic initial consonant to carry out fuzzy query facility information or other three-dimensional related datas to server time, utilize distributed memory can improve inquiry velocity so that client says that scene renders faster.
2) distributed memory is utilized can to promote the access speed of data, simultaneously, decrease the access pressure of server, reduce period of reservation of number, data are made to be timely fed back to client, promote Consumer's Experience sense, under the environment that some are real-time, utilize distributed memory can also ensure the real-time of data.
3) by the reading times of corresponding model data, the title of power station or circuit is ranked up, it is possible to improve Consumer's Experience.
4) data in distributed memory system preserve according to being read number of times, improve internal memory utilization ratio.
5) method that we adopt is, in distributed memory, first found an id index, this index is made up of a series of set, by this index, the all id satisfied condition can be found, because that index is only deposited is id, the space occupied is not as big, so all data in data base all can be established index.Then, all of inquiry of client, it is all first pass through this index to find the id of correspondence, inquires about data again through id.
Accompanying drawing explanation
Fig. 1 is the key step schematic flow sheet of the present invention.
Detailed description of the invention
Below in conjunction with the drawings and specific embodiments, the present invention is described in detail.The present embodiment is carried out premised on technical solution of the present invention, gives detailed embodiment and concrete operating process, but protection scope of the present invention is not limited to following embodiment.
During the invention process, it is necessary to pre-build index module, the coding according to Chinese character, go for initial consonant corresponding to ASCII.It is exist in unicode double-byte encodings mode in operating condition due to Chinese character, the corresponding integer of each Chinese character, determine initial consonant corresponding to ASCII according to chinese character international code GB2312-80 rule.
Each initial consonants all and numeral all corresponding one group of id, these id are the title power station that comprises this initial consonant or numeral or the id that circuit is corresponding, for instance id corresponding for initial consonant C includes, and in title, the initial consonant of any one Chinese character is the power station of C or id corresponding to circuit
A kind of three-dimensional platform data fuzzy query method based on distributed memory, as it is shown in figure 1, include step:
1) it is loaded into search key, and the search key being loaded onto resolves to initial consonant sequence and Serial No., specifically includes step:
11) it is loaded into search key, and extracts the initial consonant of all of which Chinese character, and form initial consonant sequence;
12) judge whether search key exists numeral, if it has, then perform step 13), if it has not, be then parsed;
13) extract all of numeral, and form Serial No..
2) obtain multiple id set according to initial consonant sequence and Serial No. are retrieved in index module, and obtain all id intersection of sets collection, specifically include step:
21) an id set is obtained according to each initial consonant in initial consonant sequence, particularly as follows: index obtains containing the power station of this initial consonant or the id that circuit is corresponding in all titles in index module;
22) an id set is obtained according to each numeral in Serial No., particularly as follows: index obtains containing the power station of this numeral or the id that circuit is corresponding in all titles in index module;
23) all of id set is sought common ground.
3) judge that whether all id intersection of sets integrate as empty set, if it has, then perform step 4), if it has not, then perform step 5);
4) prompting key word mistake, it is desirable to re-enter;
5) in distributed memory system, inquire about and read the model data of correspondence according to the id in occuring simultaneously, specifically include step:
51) title of the power station corresponding for all id in common factor or circuit is shown to user, user after selecting, it may be judged whether model data can be inquired, if it has, then perform step 52), if it has not, then perform step 53);
52) power station chosen according to user or the id of circuit inquire about the model data of correspondence in distributed memory system;
53) power station chosen according to user or the id of circuit inquire about the account information and model data that obtain power station or circuit in data base, and in distributed memory system, the model data obtained is stored according to the id in account information, wherein, account information includes power station or the id of circuit, title, electric pressure and affiliated unit.
Step 51) in the sort by of title of power station or circuit be: the number of times that the model data of this power station or circuit is read, particularly as follows: the number of times that the model data of this power station or circuit is read within the setting time.The statistics of reading times is included in the reading times in distributed memory system and the reading times in data base.

Claims (7)

1. the three-dimensional platform data fuzzy query method based on distributed memory, it is characterised in that include step:
1) it is loaded into search key, and the search key being loaded onto resolves to initial consonant sequence and Serial No.;
2) obtain multiple id set according to initial consonant sequence and Serial No. are retrieved in index module, and obtain all id intersection of sets collection;
3) judge that whether all id intersection of sets integrate as empty set, if it has, then perform step 4), if it has not, then perform step 5);
4) prompting key word mistake, it is desirable to re-enter;
5) in distributed memory system, the model data of correspondence is inquired about and reads according to the id in occuring simultaneously.
2. a kind of three-dimensional platform data fuzzy query method based on distributed memory according to claim 1, it is characterised in that described step 1) specifically include step:
11) it is loaded into search key, and extracts the initial consonant of all of which Chinese character, and form initial consonant sequence;
12) judge whether search key exists numeral, if it has, then perform step 13), if it has not, be then parsed;
13) extract all of numeral, and form Serial No..
3. a kind of three-dimensional platform data fuzzy query method based on distributed memory according to claim 1, it is characterised in that described step 2) specifically include step:
21) an id set is obtained according to each initial consonant in initial consonant sequence, particularly as follows: index obtains containing the power station of this initial consonant or the id that circuit is corresponding in all titles in index module;
22) an id set is obtained according to each numeral in Serial No., particularly as follows: index obtains containing the power station of this numeral or the id that circuit is corresponding in all titles in index module;
23) all of id set is sought common ground.
4. a kind of three-dimensional platform data fuzzy query method based on distributed memory according to claim 1, it is characterised in that described step 5) specifically include step:
51) title of the power station corresponding for all id in common factor or circuit is shown to user, user after selecting, it may be judged whether model data can be inquired, if it has, then perform step 52), if it has not, then perform step 53);
52) power station chosen according to user or the id of circuit inquire about the model data of correspondence in distributed memory system;
53) power station chosen according to user or the id of circuit inquire about the account information and model data that obtain power station or circuit in data base, and store the model data obtained in distributed memory system according to the id in account information.
5. a kind of three-dimensional platform data fuzzy query method based on distributed memory according to claim 4, it is characterised in that described account information includes power station or the id of circuit, title, electric pressure and affiliated unit.
6. a kind of three-dimensional platform data fuzzy query method based on distributed memory according to claim 4, it is characterised in that described step 51) in the sort by of title of power station or circuit be: the number of times that the model data of this power station or circuit is read.
7. a kind of three-dimensional platform data fuzzy query method based on distributed memory according to claim 6, it is characterised in that described sort by is particularly as follows: the number of times that is read within the setting time of the model data of this power station or circuit.
CN201610055495.7A 2016-01-27 2016-01-27 Three-dimensional platform data fuzzy query method based on distributed memory Active CN105740374B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201610055495.7A CN105740374B (en) 2016-01-27 2016-01-27 Three-dimensional platform data fuzzy query method based on distributed memory

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201610055495.7A CN105740374B (en) 2016-01-27 2016-01-27 Three-dimensional platform data fuzzy query method based on distributed memory

Publications (2)

Publication Number Publication Date
CN105740374A true CN105740374A (en) 2016-07-06
CN105740374B CN105740374B (en) 2019-11-08

Family

ID=56246609

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201610055495.7A Active CN105740374B (en) 2016-01-27 2016-01-27 Three-dimensional platform data fuzzy query method based on distributed memory

Country Status (1)

Country Link
CN (1) CN105740374B (en)

Cited By (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN106372177A (en) * 2016-08-30 2017-02-01 东华大学 Query expansion method supporting correlated query and fuzzy grouping of mixed data type
CN106920011A (en) * 2017-03-06 2017-07-04 冠生园(集团)有限公司 A kind of intelligent stroke planning method
CN106934002A (en) * 2017-03-06 2017-07-07 冠生园(集团)有限公司 A kind of search key digitizes analytic method and engine

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20080256057A1 (en) * 2007-04-12 2008-10-16 Soren Riise Optimizing a query using fuzzy matching
CN102291615A (en) * 2011-08-31 2011-12-21 深圳市佳创视讯技术股份有限公司 Television program precision searching and detail viewing device and method based on one-way network
CN103389976A (en) * 2012-05-07 2013-11-13 宇龙计算机通信科技(深圳)有限公司 Searching method and searching system for terminal
CN104731922A (en) * 2015-03-26 2015-06-24 江苏物联网研究发展中心 System and method for rapidly retrieving structural data based on distributed type database HBase

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20080256057A1 (en) * 2007-04-12 2008-10-16 Soren Riise Optimizing a query using fuzzy matching
CN102291615A (en) * 2011-08-31 2011-12-21 深圳市佳创视讯技术股份有限公司 Television program precision searching and detail viewing device and method based on one-way network
CN103389976A (en) * 2012-05-07 2013-11-13 宇龙计算机通信科技(深圳)有限公司 Searching method and searching system for terminal
CN104731922A (en) * 2015-03-26 2015-06-24 江苏物联网研究发展中心 System and method for rapidly retrieving structural data based on distributed type database HBase

Cited By (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN106372177A (en) * 2016-08-30 2017-02-01 东华大学 Query expansion method supporting correlated query and fuzzy grouping of mixed data type
CN106920011A (en) * 2017-03-06 2017-07-04 冠生园(集团)有限公司 A kind of intelligent stroke planning method
CN106934002A (en) * 2017-03-06 2017-07-07 冠生园(集团)有限公司 A kind of search key digitizes analytic method and engine
CN106934002B (en) * 2017-03-06 2020-07-07 冠生园(集团)有限公司 Search keyword digitalized analysis method and engine
CN106920011B (en) * 2017-03-06 2021-04-06 冠生园(集团)有限公司 Intelligent travel planning method

Also Published As

Publication number Publication date
CN105740374B (en) 2019-11-08

Similar Documents

Publication Publication Date Title
CN102915299B (en) Word segmentation method and device
CN102156751B (en) Method and device for extracting video fingerprint
US20110106805A1 (en) Method and system for searching multilingual documents
CN103136228A (en) Image search method and image search device
CN103810168A (en) Search application method, device and terminal
CN108509569A (en) Generation method, device, electronic equipment and the storage medium of enterprise's portrait
CN101882163A (en) Fuzzy Chinese address geographic evaluation method based on matching rule
CN110399568A (en) Information search method, device, terminal and storage medium
CN101727502A (en) Data query method, data query device and data query system
CN102867049B (en) Chinese PINYIN quick word segmentation method based on word search tree
CN102567423B (en) Method and system for associated search of poetry
CN101561725B (en) Method and system of fast handwriting input
CN107463711A (en) A kind of tag match method and device of data
CN104899340A (en) IETM technical information fragment retrieval device and retrieval method based on smallest fragment
CN102930048A (en) Data abundance automatically found by semanteme and using reference and visual data
CN100462978C (en) Image searching method and system
CN105740374A (en) Distributed memory based three-dimensional platform data fuzzy query method
CN112836487A (en) Automatic comment method and device, computer equipment and storage medium
CN111078952B (en) Cross-modal variable-length hash retrieval method based on hierarchical structure
CN106886517A (en) Business site selecting method, device and system
CN103152633A (en) Method and device for identifying key word
CN116662583A (en) Text generation method, place retrieval method and related devices
CN104156364B (en) Map search result shows method and apparatus
CN107609143B (en) Fragment information storage method of distributed real-time memory database
CN102073682A (en) Code mode-based document data recovering system and quick recovering method thereof

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