CN103279498A - Method for quickly querying infrared spectrogram based on composition condition - Google Patents
Method for quickly querying infrared spectrogram based on composition condition Download PDFInfo
- Publication number
- CN103279498A CN103279498A CN2013101663500A CN201310166350A CN103279498A CN 103279498 A CN103279498 A CN 103279498A CN 2013101663500 A CN2013101663500 A CN 2013101663500A CN 201310166350 A CN201310166350 A CN 201310166350A CN 103279498 A CN103279498 A CN 103279498A
- Authority
- CN
- China
- Prior art keywords
- inquiry
- querying
- query
- infared spectrum
- condition
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
A method for quickly querying an infrared spectrogram based on a composition condition includes the following steps: step A, a main query is conducted in an infrared spectrogram data base, and level-to-level management is conducted on the infrared spectrogram data base; step B, a retrieval data condition is further limited on the data which are queried in the step A, and a relatively complex query is decomposed into several simple single queries; step C, an ultimate matching parameter to be queried is set for the data which are queried in the step B, and a query result is obtained quickly. In the step A, the main query condition of the infrared spectrogram data base comprises the steps of affiliation bureau querying, operation and maintenance station querying and voltage class querying. In the step B, the single query condition comprises the steps of transformer substation querying, device type querying and defect state querying. In the step C, the ultimate matching parameter of the data base comprises a device name, a process state and a work type. The problem of quick querying of the infrared spectrogram in the data base can be solved, and the demand for quick querying of the infrared spectrogram is met.
Description
Technical field
What the present invention relates to is a kind of infared spectrum method for quickly querying based on combination condition, is mainly used in 110kv and above transformer station and the infrared data library management of transmission line of electricity.
Background technology
At present, constituent parts is all carried out infrared measurement of temperature work in the system of Utilities Electric Co., because the data volume of the infrared data that obtains is huge, the filing arrangement of data is also very difficult, can only divide file to preserve management according to time or region, can not realize the inquiry of quick hommization and call; And because the name management is lack of standardization, filing and retrieval and inquisition are difficult to classify.
Along with the continuous attention of Utilities Electric Co. for the infrared data library management, the collecting work of the infrared image of each power office carries out under the guidance of state net Utilities Electric Co. smoothly at present, and there is part city office to finish the infrared image acquisition work of whole 500kv, 220kv power transmission and transforming equipment, and to these infrared images that collects, progressively carried out the management of database.
But, because the objective aspects power equipment spreads all over the world, number of devices and model are very various again, the picture format difference of each infrared gear producer on the other hand, and the data volume of infrared figure is very huge, so how to carry out fast to the infrared data of going into database retrieval and inquisition is a problem that urgency is to be solved.
Summary of the invention
The objective of the invention is to the deficiency that the customer service prior art exists, and provide a kind of mainly be for the fast query problem that solves specific infrared picture in the database, based on the infared spectrum method for quickly querying of combination condition.
The objective of the invention is to finish by following technical solution, described infared spectrum method for quickly querying may further comprise the steps:
Steps A is led inquiry in the infared spectrum database, the infared spectrum database is carried out differentiated control;
Step B, the data to after the A step inquiry further limit the data retrieved condition, are several simple individual events inquiries with the query decomposition of more complicated;
Step C, to the data after the inquiry of B step, the final matching parameter that setting will be inquired about obtains Query Result fast.
In the described steps A, office's inquiry under the condition of infared spectrum database master inquiry comprises, the inquiry of O﹠M station and electric pressure inquiry; Among the described step B, the individual event querying condition comprises: transformer station's inquiry, device type inquiry and defect state inquiry; Among the described step C, the final matching parameter of database comprises device name, flow state and job category.
Described steps A, step B, step C filter after individual event is selected step by step, demonstrate Query Result successively, or do not demonstrate Query Result successively, but directly demonstrate final query result.
Among the described step C, wherein said final matching parameter also comprises the matching parameter setting of the start and end time of discovery time.
Any one query term in described A, B, three steps of C all can be used as unique querying condition, carries out the individual event inquiry of key word, and does not carry out query composition.
The present invention mainly is the fast query problem that solves specific infrared picture in the database; In the prior art, when querying condition increased, the situation of Query Result will increase with 2 Nth power, and therefore as the situation of infared spectrum inquiry, when the query composition condition surpassed 8, it is very big that the size of code of program can become.Therefore, the present invention can solve the problem of database mid infrared spectrum fast query, satisfies the demand of infrared spectrum fast query.
Description of drawings
Fig. 1 is query interface layout of the present invention.
Fig. 2 is mathematics retrieval model tabulation of the present invention.
Fig. 3 is retrieval stream tabulation of the present invention.
Embodiment
Below in conjunction with drawings and Examples the present invention is done detailed introduction: the infared spectrum method for quickly querying based on combination condition of the present invention, it may further comprise the steps:
Steps A is led inquiry in the infared spectrum database, the infared spectrum database is carried out differentiated control;
Step B, the data to after the A step inquiry further limit the data retrieved condition, are several simple individual events inquiries with the query decomposition of more complicated;
Step C, to the data after the inquiry of B step, the final matching parameter that setting will be inquired about obtains Query Result fast.
In the described steps A, office's inquiry under the condition of infared spectrum database master inquiry comprises, the inquiry of O﹠M station and electric pressure inquiry; Among the described step B, the individual event querying condition comprises: transformer station's inquiry, device type inquiry and defect state inquiry; Among the described step C, the final matching parameter of database comprises device name, flow state and job category.
Described steps A, step B, step C filter after individual event is selected step by step, demonstrate Query Result successively, or do not demonstrate Query Result successively, but directly demonstrate final query result.
Among the described step C, wherein said final matching parameter also comprises the matching parameter setting of the start and end time of discovery time.
Any one query term in described A, B, three steps of C all can be used as unique querying condition, carries out the individual event inquiry of key word, and does not carry out query composition.
Embodiment 1: Fig. 1 is the query interface layout that demonstrates as the infared spectrum method for quickly querying of the combination condition of each embodiment of the present invention.Inquiry layout Figure 100 shown in Figure 1 has: main query term 201, restriction retrieval and inquisition item 202, final matching parameter 203, Query Result 204.
Restriction retrieval and inquisition item 202 has comprised transformer station, device type, defect state.Screening querying condition as second level.
Below introduce the process of inquiry.Many conditions of database query composition refers to the inquiry of a plurality of combination conditions.Storage gets more and more in the database because the continuous expansion of quantity of information, data are recorded in, and for obtaining of specific record, often can't accurately locate by a condition, usually needs the combination of 2 above querying conditions to screen the data recording that satisfies condition.Utilize the inquiry as 4 of ADO.NET database access technology shell realizations and above combination condition, this method is the selection situation according to combo box, by the dynamic generated query condition of program code, utilize the data control among the ADO.NET to carry out inquiry then, its deficiency is the decision logic confusion, does not possess versatility.Enumerative technique and function method are generally adopted in the inquiry of data in the database, enumerative technique is to enumerate all situations one by one, this method is more suitable at combination condition, but when querying condition increases, the situation of enumerating inquiry will increase with 2 Nth power, therefore as the situation of infared spectrum inquiry, when the query composition condition surpassed 8, it is very big that the size of code of program can become.Function method refers to construct querying condition by the querying condition constructed fuction of write specialized, and this method generally need be used database table, how to use in the Dynamic Definition data dictionary.Function method is subjected to the data type of database list item to want consistent restriction, and generally to require the logical relation before each subquery condition be well-determined, so also not exclusively be applicable to the fast query of infared spectrum.And use the combination condition query pattern just can overcome the above problems.The realization of query composition need comprise two or more select statement, after screening layer by layer, returns the result set of inquiry.Sql like language realizes that the method for query composition is to carry out main inquiry and subquery, and subquery is the inquiry among another inquiry, and the combining form of this inquiry is also referred to as nested query.Subquery is used for returning the data of using in main inquiry, and further restriction herein specifically can be referring to Fig. 3 with the data retrieved condition. and as can be seen, subquery is that the query decomposition with more complicated is several simple individual events inquiries.Its workflow is: at first carry out inner inquiry, the result that it checks out is shown, uses as querying condition or the operand of external inquiry but pass to external inquiry, and external inquiry depends on the result of evaluation of subquery.When using subquery to realize query composition, subquery also can be the pattern of multilayer nest.
Below introduce theoretical foundation.As shown in Figure 2.Generally speaking, the information inquiry model has comprised set theory, theory of algebras and theory of probability three major types.And set theory has comprised boolean's model, fuzzy set model, boolean's model of expansion; Comprised vector space model in the theory of algebras, descriptor vector spatial model, recessive semantic indexing and neural network; Probability model, language model, inference network and belief network have been comprised in the theory of probability.And the infared spectrum method for quickly querying of combination condition is a kind of correction that belongs to the pagerank algorithm in the theory of probability.
As shown in Figure 3, with the attribute of each infared spectrum as a point, with the infared spectrum screening conditions of each rank (the having same alike result) group as a directed edge, the contact between the point has represented the level contact between the attribute, and the contact between the group has represented the process of screening layer by layer.
Its core formula is:
PR(∝)=(1-d)+d(PR(T1)/C(T1)+…PR(Tn)/C(Tn))+h
Wherein: PR (∝): the screening rank of attribute ∝;
PR(T1): the screening rank of attribute T1, the corresponding infared spectrum of attribute T1;
C(T): the infared spectrum quantity of attribute T1 association;
D: ratio of damping, value is between 0 ~ 1;
H: matching parameter.
The full content of present embodiment more than is described, in addition, those skilled in the art can easily expect other advantages and change.Therefore, the present invention on its wider meaning, do not limit with here shown in and described detail and representational embodiment.Therefore, can under situation about not breaking away from by the spirit or scope of claims and the defined general inventive concept of equivalent thereof, carry out various changes.
Claims (5)
1. infared spectrum method for quickly querying based on combination condition is characterized in that described infared spectrum method for quickly querying may further comprise the steps:
Steps A is led inquiry in the infared spectrum database, the infared spectrum database is carried out differentiated control;
Step B, the data to after the A step inquiry further limit the data retrieved condition, are several simple individual events inquiries with the query decomposition of more complicated;
Step C, to the data after the inquiry of B step, the final matching parameter that setting will be inquired about obtains Query Result fast.
2. the infared spectrum method for quickly querying based on combination condition according to claim 1 is characterized in that in the described steps A, office's inquiry under the condition of infared spectrum database master inquiry comprises, the inquiry of O﹠M station and electric pressure inquiry; Among the described step B, the individual event querying condition comprises: transformer station's inquiry, device type inquiry and defect state inquiry; Among the described step C, the final matching parameter of database comprises device name, flow state and job category.
3. the infared spectrum method for quickly querying based on combination condition according to claim 1 and 2, it is characterized in that described steps A, step B, step C are after individual event is selected, filter step by step, demonstrate Query Result successively, or do not demonstrate Query Result successively, but directly demonstrate final query result.
4. the infared spectrum method for quickly querying based on combination condition according to claim 1 and 2 is characterized in that among the described step C, wherein said final matching parameter also comprises the matching parameter setting of the start and end time of discovery time.
5. the infared spectrum method for quickly querying based on combination condition according to claim 1 and 2, it is characterized in that any one query term in described A, B, three steps of C, all can be used as unique querying condition, carry out the individual event inquiry of key word, and do not carry out query composition.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2013101663500A CN103279498A (en) | 2013-05-08 | 2013-05-08 | Method for quickly querying infrared spectrogram based on composition condition |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2013101663500A CN103279498A (en) | 2013-05-08 | 2013-05-08 | Method for quickly querying infrared spectrogram based on composition condition |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN103279498A true CN103279498A (en) | 2013-09-04 |
Family
ID=49062018
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2013101663500A Pending CN103279498A (en) | 2013-05-08 | 2013-05-08 | Method for quickly querying infrared spectrogram based on composition condition |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103279498A (en) |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101137985A (en) * | 2005-03-10 | 2008-03-05 | 雅虎公司 | Reranking and increasing the relevance of the results of searches |
| CN102081669A (en) * | 2011-01-24 | 2011-06-01 | 哈尔滨工业大学 | Hierarchical retrieval method for multi-source remote sensing resource heterogeneous databases |
| CN102521270A (en) * | 2010-11-22 | 2012-06-27 | 微软公司 | Decomposable ranking for efficient precomputing |
-
2013
- 2013-05-08 CN CN2013101663500A patent/CN103279498A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101137985A (en) * | 2005-03-10 | 2008-03-05 | 雅虎公司 | Reranking and increasing the relevance of the results of searches |
| CN102521270A (en) * | 2010-11-22 | 2012-06-27 | 微软公司 | Decomposable ranking for efficient precomputing |
| CN102081669A (en) * | 2011-01-24 | 2011-06-01 | 哈尔滨工业大学 | Hierarchical retrieval method for multi-source remote sensing resource heterogeneous databases |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106960037B (en) | A kind of distributed index the resources integration and share method across intranet and extranet | |
| US10860632B2 (en) | Information query method and device | |
| CN103970887B (en) | A kind of information flow display system and method based on GIS power distribution network figures | |
| CN105138526B (en) | For automatically generating the method and system of Semantic mapping for relevant database | |
| Laflaquiere et al. | Trace-based framework for experience management and engineering | |
| CN110869920A (en) | Multi-dimensional industrial knowledge graph | |
| CN103136260A (en) | Method and device for applying filtration factor assessment in optimization of access path in database | |
| EP3545372B1 (en) | Building management system having knowledge base | |
| CN112445889A (en) | Method for storing data and retrieving data and related equipment | |
| Chen et al. | A big data analysis and application platform for civil aircraft health management | |
| DE102019007354A1 (en) | NARRATION SYSTEM FOR INTERACTIVE DASHBOARDS | |
| CN107491476A (en) | A kind of data model translation and query analysis method suitable for a variety of big data management systems | |
| US10838970B2 (en) | Data analysis system and method | |
| CN115617776A (en) | Data management system and method | |
| KR20200082051A (en) | System for managing ontology data of power grid | |
| JP2008181296A (en) | Image retrieval method and image retrieval program | |
| CN109471957A (en) | A kind of metadata conversion method and device based on unified label | |
| CN116450908B (en) | Self-service data analysis method and device based on data lake and electronic equipment | |
| CN103279498A (en) | Method for quickly querying infrared spectrogram based on composition condition | |
| CN115937881A (en) | Method for automatically identifying content of knowledge graph construction standard form | |
| CN110826845A (en) | Multidimensional combination cost allocation device and method | |
| CN115329145A (en) | Physical relationship-based power transformation simulation information knowledge graph construction and retrieval method | |
| CN1977269A (en) | Externalization of coil structure patterns | |
| Hoerster et al. | BIM based classification of building performance data for advanced analysis | |
| CN109508345A (en) | Database index querying method based on automobile VIN search |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| ASS | Succession or assignment of patent right |
Owner name: JIAXING POWER SUPPLY COMPANY, STATE GRID ZHEJIANG Effective date: 20140109 Owner name: STATE ELECTRIC NET CROP. Free format text: FORMER OWNER: JIAXING ELECTRIC POWER BUREAU Effective date: 20140109 |
|
| C41 | Transfer of patent application or patent right or utility model | ||
| COR | Change of bibliographic data |
Free format text: CORRECT: ADDRESS; FROM: 314000 JIAXING, ZHEJIANG PROVINCE TO: 100031 XICHENG, BEIJING |
|
| TA01 | Transfer of patent application right |
Effective date of registration: 20140109 Address after: 100031 Xicheng District West Chang'an Avenue, No. 86, Beijing Applicant after: State Grid Corporation of China Applicant after: Jiaxing Power Supply Company, State Grid Zhejiang Electronic Power Company Address before: Jiaxing City, Zhejiang province 314000 North Road No. 99 Applicant before: Jiaxing Electric Power Bureau |
|
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20130904 |
|
| RJ01 | Rejection of invention patent application after publication |