CN104408180A - Stored data inquiring method and device - Google Patents

Stored data inquiring method and device Download PDF

Info

Publication number
CN104408180A
CN104408180A CN201410778974.2A CN201410778974A CN104408180A CN 104408180 A CN104408180 A CN 104408180A CN 201410778974 A CN201410778974 A CN 201410778974A CN 104408180 A CN104408180 A CN 104408180A
Authority
CN
China
Prior art keywords
data
indication information
data line
checked
index
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
Application number
CN201410778974.2A
Other languages
Chinese (zh)
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.)
Beijing Gridsum Technology Co Ltd
Original Assignee
Beijing Gridsum Technology 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 Beijing Gridsum Technology Co Ltd filed Critical Beijing Gridsum Technology Co Ltd
Priority to CN201410778974.2A priority Critical patent/CN104408180A/en
Publication of CN104408180A publication Critical patent/CN104408180A/en
Pending legal-status Critical Current

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/10File systems; File servers
    • G06F16/14Details of searching files based on file metadata
    • G06F16/148File search processing

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Library & Information Science (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

The invention discloses a stored data inquiring method and device. The stored data inquiring method includes acquiring index information to be inquired with the index data corresponding to the index information stored in a data sheet in a data memory; acquiring an inquiry parameter of the index information to be inquired; inquiring the index data corresponding to the index information according to the inquiry parameter. The method and device solves the problem in the relevant art that the inquiry logic of the inquiry mode of the stored data is complex.

Description

The querying method of internal storage data and device
Technical field
The present invention relates to internet arena, in particular to a kind of querying method and device of internal storage data.
Background technology
At present, the general technological development real-time system adopting object-oriented, like this, all objects are finally all stored in internal memory.If need to inquire about real time data, then need to retrieve these objects from internal memory.In real-time system, can be each index definition class usually, such as; for once access (Page View, referred to as the PV) index of the page, be also; for page browsing number index, can be its definition class PV class, concrete definition be as shown in table 1:
Table 1
(Uniform Resource Locator, referred to as URL) URL dimension
City City dimension
Province Province dimension
Browser Browser dimension
Value PV value
Each client can as a visitor, and for independent visitor's number (Unique Visitor, referred to as UV) index, can be equally also its definition class UV class, concrete definition be as shown in table 2:
Table 2
URL URL dimension
City City dimension
SearchEngine Search engine dimension
Social Social media dimension
Value UV value
When real-time system is run, the corresponding data of different index is saved in the set of class object corresponding in internal memory, such as, the corresponding data of PV is saved in the set of PV class object corresponding in internal memory, and the corresponding data of UV is saved in the set of UV class object corresponding in internal memory.Like this, during data query, just can retrieve from the set of these class objects.
During enforcement, if need inquiry to specify the corresponding data of index in specified dimension, then need the class object set first finding this index corresponding, retrieve each object in this set more successively, whether the property value then detecting each object corresponding in this specified dimension exists, if exist, then use this property value and desired value gather.
Such as, when inquiring about PV number in URL dimension of PV index, need first to find the set of PV class object, travel through each URL in the set of whole PV class object again, check the PVValue of the property value of each URL and correspondence thereof (namely, PV value), and the PV value of all identical URL is gathered.Such as, during UV number in query search engine dimension, need first to find the set of UV class object, travel through each search engine in the set of whole UV class object again, check the UV Value of the property value of each search engine and correspondence thereof (namely, UV value), and the PV value of all identical search engines is gathered
Although the inquiry mode of above-mentioned internal storage data also can realize query function, there is following shortcoming:
(1) if need interpolation New Set, then need first for this New Set defines a class, then create the set of class object for this class.Because the corresponding relation of index and dimension is complicated, and most of attribute of these index classes is repetitions, therefore, if want the problem that the mode by inheriting avoids attribute to re-define, the layer of structure of these index classes then can be caused again very complicated, and usually comprise dozens or even hundreds of index and dimension in real-time system, make the mode inherited be difficult to realize.
(2), when using dimension inquiry achievement data, need the different property value retrieving each object, and need to do branch process to each attribute.Like this, if need increase new dimension, then need amendment inquiry code, add new process branch; If need deletion new dimension, then also need amendment inquiry code, delete and process branch accordingly.
Therefore, the inquiry mode query logic of the above-mentioned internal storage data of correlation technique is quite complicated.
For the problem that the query logic of the inquiry mode of internal storage data in correlation technique is quite complicated, at present effective solution is not yet proposed.
Summary of the invention
Fundamental purpose of the present invention is the querying method and the device that provide a kind of internal storage data, with the problem that the query logic solving the inquiry mode of internal storage data in correlation technique is quite complicated.
To achieve these goals, according to an aspect of the present invention, a kind of querying method of internal storage data is provided.The method comprises: obtain indication information to be checked, and the achievement data corresponding with These parameters information is stored in the tables of data in internal memory; Obtain the query argument of above-mentioned indication information to be checked; And in above-mentioned tables of data, inquire about the above-mentioned achievement data corresponding with These parameters information according to above-mentioned query argument.
Further, above-mentioned query argument comprises dimensional parameter, above-mentioned tables of data comprises one or more data line, inquires about the above-mentioned achievement data corresponding with These parameters information and comprises: travel through each data line in one or more data line above-mentioned according to above-mentioned dimensional parameter according to above-mentioned query argument in above-mentioned tables of data; And the above-mentioned achievement data corresponding with These parameters information is inquired about in above-mentioned each data line.
Further, above-mentioned each data line comprises a data dictionary, inquires about the above-mentioned achievement data corresponding with These parameters information and comprises: obtain the above-mentioned data dictionary in above-mentioned each data line in above-mentioned each data line; Detect the key assignments that whether there is above-mentioned dimensional parameter in the above-mentioned data dictionary in above-mentioned each data line; And if there is the above-mentioned key assignments of above-mentioned dimensional parameter in the above-mentioned data dictionary detecting in above-mentioned each data line, then determine the above-mentioned achievement data corresponding with These parameters information according to above-mentioned key assignments.
Further, above-mentioned indication information to be checked is obtained by expandable mark language XML document definition, and before obtaining indication information to be checked, above-mentioned querying method also comprises: in above-mentioned XML file, revise above-mentioned indication information to be checked.
Further, above-mentioned tables of data is created in the following manner: detect above-mentioned XML file and whether be loaded; And if detect that above-mentioned XML file is loaded, then create corresponding database table for the index corresponding to above-mentioned indication information to be checked.
To achieve these goals, according to a further aspect in the invention, a kind of inquiry unit of internal storage data is provided.This device comprises: the first acquiring unit, and for obtaining indication information to be checked, the achievement data corresponding with These parameters information is stored in the tables of data in internal memory; Second acquisition unit, for obtaining the query argument of above-mentioned indication information to be checked; And query unit, for inquiring about the above-mentioned achievement data corresponding with These parameters information according to above-mentioned query argument in above-mentioned tables of data.
Further, above-mentioned query argument comprises dimensional parameter, and above-mentioned tables of data comprises one or more data line, and above-mentioned query unit comprises: spider module, for traveling through each data line in one or more data line above-mentioned according to above-mentioned dimensional parameter; And enquiry module, for inquiring about the above-mentioned achievement data corresponding with These parameters information in above-mentioned each data line.
Further, above-mentioned each data line comprises a data dictionary, and above-mentioned enquiry module comprises: obtain submodule, for obtaining the above-mentioned data dictionary in above-mentioned each data line; Detection sub-module, for detecting the key assignments that whether there is above-mentioned dimensional parameter in the above-mentioned data dictionary in above-mentioned each data line; And determine submodule, if for detecting the above-mentioned key assignments that there is above-mentioned dimensional parameter in the above-mentioned data dictionary in above-mentioned each data line, then determine the above-mentioned achievement data corresponding with These parameters information according to above-mentioned key assignments.
Further, above-mentioned indication information to be checked is obtained by expandable mark language XML document definition, before obtaining indication information to be checked, above-mentioned inquiry unit also comprises: amendment unit, for revising above-mentioned indication information to be checked in above-mentioned XML file.
Whether further, said apparatus also comprises: creating unit, and for creating above-mentioned tables of data in the following manner, above-mentioned creating unit comprises: detection module, be loaded for detecting above-mentioned XML file; And creation module, for when detecting that above-mentioned XML file is loaded, for the index corresponding to above-mentioned indication information to be checked creates corresponding database table.
By the present invention, adopt and obtain indication information to be checked, the achievement data corresponding with indication information is stored in the tables of data in internal memory; Obtain the query argument of indication information to be checked; And in tables of data, inquire about the achievement data corresponding with indication information according to query argument, the problem that the query logic solving the inquiry mode of internal storage data in correlation technique is quite complicated, and then the effect of query logic reaching the inquiry mode simplifying internal storage data.
Accompanying drawing explanation
The accompanying drawing forming a application's part is used to provide a further understanding of the present invention, and schematic description and description of the present invention, for explaining the present invention, does not form inappropriate limitation of the present invention.In the accompanying drawings:
Fig. 1 is the process flow diagram of the querying method of internal storage data according to the embodiment of the present invention; And
Fig. 2 is the schematic diagram of the inquiry unit of internal storage data according to the embodiment of the present invention.
Embodiment
It should be noted that, when not conflicting, the embodiment in the application and the feature in embodiment can combine mutually.Below with reference to the accompanying drawings and describe the present invention in detail in conjunction with the embodiments.
The application's scheme is understood better in order to make those skilled in the art person, below in conjunction with the accompanying drawing in the embodiment of the present application, technical scheme in the embodiment of the present application is clearly and completely described, obviously, described embodiment is only the embodiment of the application's part, instead of whole embodiments.Based on the embodiment in the application, those of ordinary skill in the art are not making the every other embodiment obtained under creative work prerequisite, all should belong to the scope of the application's protection.
It should be noted that, term " first ", " second " etc. in the instructions of the application and claims and above-mentioned accompanying drawing are for distinguishing similar object, and need not be used for describing specific order or precedence.Should be appreciated that the data used like this can be exchanged, in the appropriate case so that the embodiment of the application described herein.In addition, term " comprises " and " having " and their any distortion, intention is to cover not exclusive comprising, such as, contain those steps or unit that the process of series of steps or unit, method, system, product or equipment is not necessarily limited to clearly list, but can comprise clearly do not list or for intrinsic other step of these processes, method, product or equipment or unit.
Index, can carry out the value of aminated polyepichlorohydrin, aminated polyepichlorohydrin can comprise: summation, average, counting etc., and such as, PV number is an index, and it can use summation to be polymerized; Mean residence time is an index, and it can use and on average be polymerized.
The once access of the page, (Page View, referred to as PV), is a PV.
Independent visitor's number, (Unique Visitor, referred to as UV), each client can as a visitor.
Dimension, checks the different angles of index, and such as, browser is a dimension, can from this dimension of browser inquiry PV number, that is, which browser user uses check the page, and the page number of times using these browsers to check.
Member, Member, some angles are a Member, and such as, browser is a dimension, and IE browser, Chrome browser are a Member of this browser dimension.
According to embodiments of the invention, provide a kind of querying method of internal storage data.The querying method of this internal storage data may operate on computer-processing equipment.
Fig. 1 is the process flow diagram of the querying method of internal storage data according to the embodiment of the present invention.As shown in Figure 1, the method comprises following step S102 to step S106:
Step S102, obtains indication information to be checked.
Indication information to be checked is the indication information that user wants to inquire about, and also, specify the information of index, these indication informations can be all information relevant to index, do not limit at this.Such as, for index PV, the indication information corresponding with index PV can comprise multiple, such as PV number.It should be noted that, the achievement data corresponding with indication information is stored in the tables of data in internal memory.
In embodiments of the present invention, tables of data is database table, and each tables of data can comprise multiple data line and multiple data rows.Wherein, the corresponding data of the corresponding index of each data line, concrete, each data line can title, the dictionary of a corresponding index, and also, such data line may be used for storing all data relevant to this index.The corresponding index of each data rows or a dimension, concrete, each data line can the corresponding title of an index or the title of a dimension, and also, such data rows may be used for storing all data relevant to this index or dimension.
Step S104, obtains the query argument of indication information to be checked.
It should be noted that, query argument can be each inquiry dimension, such as, when the inquiry index of specifying is PV, then PV can be just aforesaid Query Information, the query argument of PV can be each dimension of PV, and such as, each dimension can be URL dimension, city dimension, province dimension and browser dimension etc.
Step S106, inquires about the achievement data corresponding with indication information according to query argument in tables of data.
Particularly, can according to query argument and tables of data, and carry out the dictionary in data query table in each data line according to the data line of tables of data and the above-mentioned definition of data rows, be store data with the form of key-value pair because dictionary is actual, therefore can inquire about the achievement data corresponding with indication information in these dictionaries.
Pass through the embodiment of the present invention, mode by tables of data audit memory data due to what adopt, and this inquiry mode is revising index (comprising: add index, delete index and adjustment index) without the need to revising existing code and existing query logic, more add without the need to the index separately for amendment, delete or revise and process branch accordingly, therefore reach the effect of the query logic of the inquiry mode simplifying internal storage data.
Preferably, in embodiments of the present invention, query argument comprises dimensional parameter, and tables of data can comprise one or more data line, and step S106 inquires about the achievement data corresponding with indication information according to query argument and can comprise in tables of data:
S2, travels through each data line in one or more data line according to dimensional parameter, also, and can according to all data lines in dimensional parameter ergodic data table.
S4, the achievement data that inquiry is corresponding with indication information in each data line.
During enforcement, can pre-define each data line DataRow class of tables of data, wherein, each DataRow class represents data line, and its structure is as shown in table 3:
Table 3
Wherein, Cells represents the title of data line, and Dictionary<string, object> represent dictionary, and string represents index or dimension, and object represents object, with string one_to_one corresponding.Such as, when string represents index PV, object can represent the PV number corresponding with index PV; Such as, when string represents URL dimension, object can represent the PV number in this URL dimension, etc.
Correspondingly, during enforcement, can pre-define tables of data DataTable type, each DataTable stores all data of an index, and its structure is as shown in table 4:
Table 4
Columns String gathers Comprise which row
Rows DataRow gathers Comprise which row
Wherein, Columns represents data rows, and it is the set of string, and string represents index or dimension; Rows represents data line, and it is the set of DataRow, and the structure of DataRow, with above-mentioned, does not repeat them here.
Further preferably, in embodiments of the present invention, each data line can comprise a data dictionary, and S4 inquires about the achievement data corresponding with indication information and can comprise in each data line:
S6, obtains the data dictionary in each data line;
S8, detects the key assignments that whether there is dimensional parameter in the data dictionary in each data line; And
S10, if detect the key assignments that there is dimensional parameter in the data dictionary in each data line, then determines the achievement data corresponding with indication information according to key assignments.
Such as, during enforcement, first check which index is the index needing inquiry be, the tables of data DataTable corresponding with this index is found again in internal memory, and then check that what want to inquire about is which dimension of this index, then search each data line DataRow in this DataTable successively, and detect in each DataRow the data whether existed about this index in this dimension, namely check the dictionary in the DataRow of Cells, judge the key assignments that whether there is this dimension in this dictionary.If existed, then use this key assignments of this dimension to obtain corresponding property value, that is, the member of this dimension, and use this key assignments of this index to obtain corresponding Value value, namely this refers to target value.Finally, the member got and desired value are gathered, and using summarized results as the Query Result of specifying the achievement data of index in specified dimension.
Preferably, in embodiments of the present invention, indication information to be checked can be obtained by extend markup language (ExtensibleMarkup Language, referred to as XML) document definition, before step S102 obtains indication information to be checked, this querying method can also comprise:
S12, revises indication information to be checked in XML file.
It should be noted that, when implementing, can add XML file, this XML file may be used for the inquiry index that definition tables of data comprises, and such as, can be defined by following program:
<?xml version="1.0"encoding="utf-8"?>
<Metrics>
<Metric ID="Pv"/>
<Metric ID="Uv"/>
<Metric ID="Event"/>
<Metric ID="Target"/>
</Metrics>
By XML file above, the indexs such as PV, UV, Event and Target can be defined, if need to revise indication information to be checked, then directly can revise XML file, such as, if delete PV index, then can directly " <Metric ID=" Pv "/> " be deleted.
By the embodiment of the present invention, without the need to creating a class for each index, and only need to add each Index element in XML file.Further, without the need to writing corresponding branch statement for each dimension, and new dimension need only be added in XML file, therefore without the need to revising existing code.Corresponding index and dimension is added owing to adopting the mode of XML file, therefore all indexs and dimension can use same set of processing logic, thus without the need to doing special process for each index or dimension, like this, not only code is easier to safeguard, and make system logic more succinct, meanwhile, extendability is better.
Further preferably, in embodiments of the present invention, tables of data can be created in the following manner:
Whether S14, detect XML file and be loaded; And
S16, if detect that XML file is loaded, then creates corresponding database table for the index corresponding to indication information to be checked.
When implementing, if real-time system starts, then load XML file above, and for create a DataTable for each index.And when real-time system is normally run, each index and dimension (relevant dimension thereof, as URL can as the relevant dimension of PV) related data, the DataRow in DataTable can be used to store, key (namely, aforesaid string) be index name or dimension name, value (that is, aforesaid object) is desired value or dimension member.
It should be noted that, can perform in the computer system of such as one group of computer executable instructions in the step shown in the process flow diagram of accompanying drawing, and, although show logical order in flow charts, but in some cases, can be different from the step shown or described by order execution herein.
According to embodiments of the invention, provide a kind of inquiry unit of internal storage data.It should be noted that, the querying method of the internal storage data that the embodiment of the present invention provides can be performed by the inquiry unit of the internal storage data of the embodiment of the present invention, and the inquiry unit of the internal storage data of the embodiment of the present invention also may be used for the querying method of the internal storage data performing the embodiment of the present invention.
Fig. 2 is the schematic diagram of the inquiry unit of internal storage data according to the embodiment of the present invention.As shown in Figure 2, this device comprises: the first acquiring unit 10, second acquisition unit 20 and query unit 30.
First acquiring unit 10 is for obtaining indication information to be checked, and the achievement data corresponding with indication information is stored in the tables of data in internal memory.
Indication information to be checked is the indication information that user wants to inquire about, and also, specify the information of index, these indication informations can be all information relevant to index, do not limit at this.Such as, for index PV, the indication information corresponding with index PV can comprise multiple, such as PV number.It should be noted that, the achievement data corresponding with indication information is stored in the tables of data in internal memory.
In embodiments of the present invention, tables of data is database table, and each tables of data can comprise multiple data line and multiple data rows.Wherein, the corresponding data of the corresponding index of each data line, concrete, each data line can title, the dictionary of a corresponding index, and also, such data line may be used for storing all data relevant to this index.The corresponding index of each data rows or a dimension, concrete, each data line can the corresponding title of an index or the title of a dimension, and also, such data rows may be used for storing all data relevant to this index or dimension.
Second acquisition unit 20 is for obtaining the query argument of indication information to be checked.
It should be noted that, query argument can be each inquiry dimension, such as, when the inquiry index of specifying is PV, then PV can be just aforesaid Query Information, the query argument of PV can be each dimension of PV, and such as, each dimension can be URL dimension, city dimension, province dimension and browser dimension etc.
Query unit 30 for inquiring about the achievement data corresponding with indication information according to query argument in tables of data.
Particularly, can according to query argument and tables of data, and carry out the dictionary in data query table in each data line according to the data line of tables of data and the above-mentioned definition of data rows, be store data with the form of key-value pair because dictionary is actual, therefore can inquire about the achievement data corresponding with indication information in these dictionaries.
Pass through the embodiment of the present invention, mode by tables of data audit memory data due to what adopt, and this inquiry mode is revising index (comprising: add index, delete index and adjustment index) without the need to revising existing code and existing query logic, more add without the need to the index separately for amendment, delete or revise and process branch accordingly, therefore reach the effect of the query logic of the inquiry mode simplifying internal storage data.
Preferably, in embodiments of the present invention, query argument can comprise dimensional parameter, and tables of data can comprise one or more data line, and query unit can comprise: spider module and enquiry module.Spider module is used for each data line traveled through according to dimensional parameter in one or more data line; And enquiry module is used for the achievement data that inquiry is corresponding with indication information in each data line.
During enforcement, can pre-define each data line DataRow class of tables of data, wherein, each DataRow class represents data line, and its structure is as shown in table 3.Wherein, Cells represents the title of data line, and Dictionary<string, object> represent dictionary, and string represents index or dimension, and object represents object, with string one_to_one corresponding.Such as, when string represents index PV, object can represent the PV number corresponding with index PV; Such as, when string represents URL dimension, object can represent the PV number in this URL dimension, etc.
Correspondingly, during enforcement, can pre-define tables of data DataTable type, each DataTable stores all data of an index, and its structure is as shown in table 4.Wherein, Columns represents data rows, and it is the set of string, and string represents index or dimension; Rows represents data line, and it is the set of DataRow, and the structure of DataRow, with above-mentioned, does not repeat them here.
Further preferably, in embodiments of the present invention, each data line can comprise a data dictionary, and enquiry module can comprise: obtain submodule, detection sub-module and determine submodule.Obtain submodule for obtaining the data dictionary in each data line; Whether detection sub-module exists the key assignments of dimensional parameter in the data dictionary in each data line for detecting; And if determine that submodule is for detecting the key assignments that there is dimensional parameter in the data dictionary in each data line, then determine the achievement data corresponding with indication information according to key assignments.
Such as, during enforcement, first check which index is the index needing inquiry be, the tables of data DataTable corresponding with this index is found again in internal memory, and then check that what want to inquire about is which dimension of this index, then search each data line DataRow in this DataTable successively, and detect in each DataRow the data whether existed about this index in this dimension, namely check the dictionary in the DataRow of Cells, judge the key assignments that whether there is this dimension in this dictionary.If existed, then use this key assignments of this dimension to obtain corresponding property value, that is, the member of this dimension, and use this key assignments of this index to obtain corresponding Value value, namely this refers to target value.Finally, the member got and desired value are gathered, and using summarized results as the Query Result of specifying the achievement data of index in specified dimension.
Preferably, in embodiments of the present invention, indication information to be checked can be obtained by expandable mark language XML document definition, and before obtaining indication information to be checked, this inquiry unit can also comprise: amendment unit.Amendment unit is used in XML file, revise indication information to be checked.
It should be noted that, when implementing, can add XML file, this XML file may be used for the inquiry index that definition tables of data comprises, and such as, can be defined by following program:
<?xml version="1.0"encoding="utf-8"?>
<Metrics>
<Metric ID="Pv"/>
<Metric ID="Uv"/>
<Metric ID="Event"/>
<Metric ID="Target"/>
</Metrics>
By XML file above, the indexs such as PV, UV, Event and Target can be defined, if need to revise indication information to be checked, then directly can revise XML file, such as, if delete PV index, then can directly " <Metric ID=" Pv "/> " be deleted.
By the embodiment of the present invention, without the need to creating a class for each index, and only need to add each Index element in XML file.Further, without the need to writing corresponding branch statement for each dimension, and new dimension need only be added in XML file, therefore without the need to revising existing code.Corresponding index and dimension is added owing to adopting the mode of XML file, therefore all indexs and dimension can use same set of processing logic, thus without the need to doing special process for each index or dimension, like this, not only code is easier to safeguard, and make system logic more succinct, meanwhile, extendability is better.
Further preferably, in embodiments of the present invention, this device can also comprise: creating unit.Creating unit is used for creating tables of data in the following manner, and this creating unit can comprise: detection module and creation module.Whether detection module is loaded for detecting XML file; And creation module is used for when detecting that XML file is loaded, for the index corresponding to indication information to be checked creates corresponding database table.
When implementing, if real-time system starts, then load XML file above, and for create a DataTable for each index.And when real-time system is normally run, each index and dimension (relevant dimension thereof, as URL can as the relevant dimension of PV) related data, the DataRow in DataTable can be used to store, key (namely, aforesaid string) be index name or dimension name, value (that is, aforesaid object) is desired value or dimension member.
Obviously, those skilled in the art should be understood that, above-mentioned of the present invention each module or each step can realize with general calculation element, they can concentrate on single calculation element, or be distributed on network that multiple calculation element forms, alternatively, they can realize with the executable program code of calculation element, thus, they can be stored and be performed by calculation element in the storage device, or they are made into each integrated circuit modules respectively, or the multiple module in them or step are made into single integrated circuit module to realize.Like this, the present invention is not restricted to any specific hardware and software combination.
The foregoing is only the preferred embodiments of the present invention, be not limited to the present invention, for a person skilled in the art, the present invention can have various modifications and variations.Within the spirit and principles in the present invention all, any amendment done, equivalent replacement, improvement etc., all should be included within protection scope of the present invention.

Claims (10)

1. a querying method for internal storage data, is characterized in that, comprising:
Obtain indication information to be checked, the achievement data corresponding with described indication information is stored in the tables of data in internal memory;
Obtain the query argument of described indication information to be checked; And
In described tables of data, described corresponding with described indication information achievement data is inquired about according to described query argument.
2. the querying method of internal storage data according to claim 1, it is characterized in that, described query argument comprises dimensional parameter, described tables of data comprises one or more data line, inquires about the described achievement data corresponding with described indication information comprise according to described query argument in described tables of data:
According to each data line in described dimensional parameter traversal one or more data line described; And
The achievement data that inquiry is described corresponding with described indication information in described each data line.
3. the querying method of internal storage data according to claim 2, is characterized in that, described each data line comprises a data dictionary, and in described each data line, the described achievement data corresponding with described indication information of inquiry comprises:
Obtain the described data dictionary in described each data line;
Detect the key assignments that whether there is described dimensional parameter in the described data dictionary in described each data line; And
If detect the described key assignments that there is described dimensional parameter in the described data dictionary in described each data line, then determine described corresponding with described indication information achievement data according to described key assignments.
4. the querying method of internal storage data according to claim 1, is characterized in that, described indication information to be checked is obtained by expandable mark language XML document definition, and before obtaining indication information to be checked, described querying method also comprises:
Described indication information to be checked is revised in described XML file.
5. the querying method of internal storage data according to claim 4, is characterized in that, creates described tables of data in the following manner:
Detect described XML file whether to be loaded; And
If detect that described XML file is loaded, then create corresponding database table for the index corresponding to described indication information to be checked.
6. an inquiry unit for internal storage data, is characterized in that, comprising:
First acquiring unit, for obtaining indication information to be checked, the achievement data corresponding with described indication information is stored in the tables of data in internal memory;
Second acquisition unit, for obtaining the query argument of described indication information to be checked; And
Query unit, for inquiring about described corresponding with described indication information achievement data in described tables of data according to described query argument.
7. the inquiry unit of internal storage data according to claim 6, is characterized in that, described query argument comprises dimensional parameter, and described tables of data comprises one or more data line, and described query unit comprises:
Spider module, for each data line in one or more data line according to described dimensional parameter traversal; And
Enquiry module, for the achievement data that inquiry in described each data line is described corresponding with described indication information.
8. the inquiry unit of internal storage data according to claim 7, is characterized in that, described each data line comprises a data dictionary, and described enquiry module comprises:
Obtain submodule, for obtaining the described data dictionary in described each data line;
Detection sub-module, for detecting the key assignments that whether there is described dimensional parameter in the described data dictionary in described each data line; And
Determining submodule, if for detecting the described key assignments that there is described dimensional parameter in the described data dictionary in described each data line, then determining described corresponding with described indication information achievement data according to described key assignments.
9. the inquiry unit of internal storage data according to claim 6, is characterized in that, described indication information to be checked is obtained by expandable mark language XML document definition, and before obtaining indication information to be checked, described inquiry unit also comprises:
Amendment unit, for revising described indication information to be checked in described XML file.
10. the inquiry unit of internal storage data according to claim 9, is characterized in that, described device also comprises: creating unit, and for creating described tables of data in the following manner, described creating unit comprises:
Whether detection module, be loaded for detecting described XML file; And
Creation module, for when detecting that described XML file is loaded, for the index corresponding to described indication information to be checked creates corresponding database table.
CN201410778974.2A 2014-12-15 2014-12-15 Stored data inquiring method and device Pending CN104408180A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201410778974.2A CN104408180A (en) 2014-12-15 2014-12-15 Stored data inquiring method and device

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201410778974.2A CN104408180A (en) 2014-12-15 2014-12-15 Stored data inquiring method and device

Publications (1)

Publication Number Publication Date
CN104408180A true CN104408180A (en) 2015-03-11

Family

ID=52645811

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201410778974.2A Pending CN104408180A (en) 2014-12-15 2014-12-15 Stored data inquiring method and device

Country Status (1)

Country Link
CN (1) CN104408180A (en)

Cited By (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN106326249A (en) * 2015-06-23 2017-01-11 中兴通讯股份有限公司 Data integration processing method and device
CN106933904A (en) * 2015-12-31 2017-07-07 北京国双科技有限公司 The filter method and device of data
CN106933914A (en) * 2015-12-31 2017-07-07 北京国双科技有限公司 The data processing method and device of many tables of data
CN106933902A (en) * 2015-12-31 2017-07-07 北京国双科技有限公司 Querying method and device that data multidimensional degree is freely dissected
CN107015987A (en) * 2016-01-27 2017-08-04 阿里巴巴集团控股有限公司 A kind of method and apparatus for updating and searching for database
CN107291745A (en) * 2016-03-31 2017-10-24 阿里巴巴集团控股有限公司 The management method and device of a kind of data target
CN107679218A (en) * 2017-10-17 2018-02-09 九州通医疗信息科技(武汉)有限公司 Searching method and device based on internal memory
CN108153776A (en) * 2016-12-05 2018-06-12 北京国双科技有限公司 Data query method and device

Citations (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101329685A (en) * 2008-07-30 2008-12-24 烽火通信科技股份有限公司 Implementing method of memory database on household gateway
CN101388045A (en) * 2008-11-05 2009-03-18 北京中创信测科技股份有限公司 Method and device for data statistics
CN101777079A (en) * 2010-03-11 2010-07-14 浙江鸿程计算机系统有限公司 System structural frame for fast generating electronic report forms and realization method thereof
CN102298598A (en) * 2010-06-23 2011-12-28 潘晓梅 Method and device for analyzing patent information
CN102346765A (en) * 2011-09-16 2012-02-08 大唐移动通信设备有限公司 Method and device for querying memory data
CN103136335A (en) * 2013-01-31 2013-06-05 北京千分点信息科技有限公司 Data control method based on data platforms
US20140280172A1 (en) * 2013-03-13 2014-09-18 Nice-Systems Ltd. System and method for distributed categorization

Patent Citations (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101329685A (en) * 2008-07-30 2008-12-24 烽火通信科技股份有限公司 Implementing method of memory database on household gateway
CN101388045A (en) * 2008-11-05 2009-03-18 北京中创信测科技股份有限公司 Method and device for data statistics
CN101777079A (en) * 2010-03-11 2010-07-14 浙江鸿程计算机系统有限公司 System structural frame for fast generating electronic report forms and realization method thereof
CN102298598A (en) * 2010-06-23 2011-12-28 潘晓梅 Method and device for analyzing patent information
CN102346765A (en) * 2011-09-16 2012-02-08 大唐移动通信设备有限公司 Method and device for querying memory data
CN103136335A (en) * 2013-01-31 2013-06-05 北京千分点信息科技有限公司 Data control method based on data platforms
US20140280172A1 (en) * 2013-03-13 2014-09-18 Nice-Systems Ltd. System and method for distributed categorization

Cited By (12)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN106326249A (en) * 2015-06-23 2017-01-11 中兴通讯股份有限公司 Data integration processing method and device
CN106326249B (en) * 2015-06-23 2021-08-03 中兴通讯股份有限公司 Data integration processing method and device
CN106933904A (en) * 2015-12-31 2017-07-07 北京国双科技有限公司 The filter method and device of data
CN106933914A (en) * 2015-12-31 2017-07-07 北京国双科技有限公司 The data processing method and device of many tables of data
CN106933902A (en) * 2015-12-31 2017-07-07 北京国双科技有限公司 Querying method and device that data multidimensional degree is freely dissected
CN106933904B (en) * 2015-12-31 2019-12-03 北京国双科技有限公司 The filter method and device of data
CN106933902B (en) * 2015-12-31 2020-02-07 北京国双科技有限公司 Data multidimensional free analysis query method and device
CN107015987A (en) * 2016-01-27 2017-08-04 阿里巴巴集团控股有限公司 A kind of method and apparatus for updating and searching for database
CN107015987B (en) * 2016-01-27 2020-08-04 菜鸟智能物流控股有限公司 Method and equipment for updating and searching database
CN107291745A (en) * 2016-03-31 2017-10-24 阿里巴巴集团控股有限公司 The management method and device of a kind of data target
CN108153776A (en) * 2016-12-05 2018-06-12 北京国双科技有限公司 Data query method and device
CN107679218A (en) * 2017-10-17 2018-02-09 九州通医疗信息科技(武汉)有限公司 Searching method and device based on internal memory

Similar Documents

Publication Publication Date Title
CN104408180A (en) Stored data inquiring method and device
US11314823B2 (en) Method and apparatus for expanding query
Kumar et al. Twitter data analytics
US8626798B2 (en) Processing of categorized product information
US8527451B2 (en) Business semantic network build
US20110282861A1 (en) Extracting higher-order knowledge from structured data
CN103246664B (en) Web search method and apparatus
US20110231386A1 (en) Indexing and searching employing virtual documents
CN103729362A (en) Method and device for determining navigation content
CN103605848A (en) Method and device for analyzing paths
CN102855309A (en) Information recommendation method and device based on user behavior associated analysis
CN104199969A (en) Webpage data analysis method and device
CN111224923B (en) Detection method, device and system for counterfeit websites
CN104699837A (en) Method, device and server for selecting illustrated pictures of web pages
CN105224555A (en) A kind of methods, devices and systems of search
CN103605744A (en) Method and device for analyzing website searching engine traffic data
US8914416B2 (en) Semantics graphs for enterprise communication networks
US8468163B2 (en) Ontology system providing enhanced search capability with ranking of results
CN104391958A (en) Correlation detection method and device for web page search keywords
US8630992B1 (en) URL rank variability determination
CN110472125B (en) Multistage page cascading crawling method and equipment based on web crawler
CN110825976B (en) Website page detection method and device, electronic equipment and medium
CN105159899A (en) Searching method and searching device
Fattore et al. Measuring structural dissimilarity between finite partial orders
Jasani et al. Analyzing Different Web Crawling Methods

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
RJ01 Rejection of invention patent application after publication

Application publication date: 20150311

RJ01 Rejection of invention patent application after publication