CN104991975A - Data query method and system of electric power business systems - Google Patents
Data query method and system of electric power business systems Download PDFInfo
- Publication number
- CN104991975A CN104991975A CN201510466486.2A CN201510466486A CN104991975A CN 104991975 A CN104991975 A CN 104991975A CN 201510466486 A CN201510466486 A CN 201510466486A CN 104991975 A CN104991975 A CN 104991975A
- Authority
- CN
- China
- Prior art keywords
- database
- power business
- business system
- data
- information
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
- 238000000034 method Methods 0.000 title claims abstract description 23
- 238000012216 screening Methods 0.000 claims description 17
- 238000005457 optimization Methods 0.000 claims description 3
- 230000010354 integration Effects 0.000 description 6
- 230000032683 aging Effects 0.000 description 4
- 230000008901 benefit Effects 0.000 description 3
- 238000004519 manufacturing process Methods 0.000 description 3
- 230000008859 change Effects 0.000 description 2
- 238000001914 filtration Methods 0.000 description 2
- 241001269238 Data Species 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 230000001143 conditioned effect Effects 0.000 description 1
- 230000008878 coupling Effects 0.000 description 1
- 238000010168 coupling process Methods 0.000 description 1
- 238000005859 coupling reaction Methods 0.000 description 1
- 238000009795 derivation Methods 0.000 description 1
- 230000018109 developmental process Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 230000007246 mechanism Effects 0.000 description 1
- 230000008569 process Effects 0.000 description 1
- 230000003442 weekly effect Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
- G06F16/24553—Query execution of query operations
- G06F16/24554—Unary operations; Data partitioning operations
- G06F16/24556—Aggregation; Duplicate elimination
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2457—Query processing with adaptation to user needs
- G06F16/24578—Query processing with adaptation to user needs using ranking
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/248—Presentation of query results
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/06—Energy or water supply
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- Computational Linguistics (AREA)
- Business, Economics & Management (AREA)
- Economics (AREA)
- Health & Medical Sciences (AREA)
- Primary Health Care (AREA)
- Water Supply & Treatment (AREA)
- General Health & Medical Sciences (AREA)
- Human Resources & Organizations (AREA)
- Marketing (AREA)
- Public Health (AREA)
- Strategic Management (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Software Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention relates to a data query method and system of electric power business systems. The data query method includes the following steps that: the database information of the electric power business systems is registered, and the database information of the electric power business systems is recorded in database tables; connection information of the databases of the electric power business systems is configured according to the database information in the database tables; with the primary keys and foreign keys of the database tables of the electric power business systems adopted as related conditions, correlation relations of the database tables of the electric power business systems are configured; inputted data query conditions are acquired, the database information of electric power business systems which satisfies the data query conditions is acquired according to the correlation relations; the databases of corresponding electric power business systems are connected according to corresponding connection information, and a data result set can be obtained, and the data result set is displayed. With the data query method and system of the invention adopted, the data of a plurality of business systems can be queried simultaneously, and the data can be displayed for users in a unified manner, and therefore, great conveniences can be brought about.
Description
Technical field
The present invention relates to the technical field of power business system, particularly relate to a kind of data enquire method of power business system, and a kind of data query system of power business system.
Background technology
In the actual operation of electric system, there is miscellaneous operation system, the moment is all producing a large amount of real time datas, and just requires at set intervals to submit corresponding form to, such as daily paper, weekly, monthly magazine, quarterly report, annual report etc.By summing up the data gathered in the certain hour cycle, statistical study, form can be multi-level by the running status of system, multi-angle inform user.
Existing business model needs to inquire about certain category information, need to log in different systems repeatedly to search for, information retrieval is carried out across multiple platform, intuitively cannot carry out full dose to information needed to show intuitively, cannot integrate object information accurately and efficiently, it is ageing poor that this just causes information feed back, and polling cycle is long, causes considerable influence to the real work of user.
Electric company of general each province all operates in consolidated network now, but due to each city-level electric company infosystem respective stand-alone development usually, this just gives when carrying out communication contact between company of city and company of province and causes very large difficulty.
This difficulty is mainly manifested in owing to there being multiple Data Source, cannot ensure the consistance of data; Factor data is dispersed in multiple subsystem, the more difficult realization of comprehensive inquiry; Because whole electric power structure and administrative mechanism are constantly changing, continuous increase, change some statistical indicators, statistical report form must make corresponding change, and existing each subsystem simply, promptly can not carry out information integration, the data that the different department of some key indexs offers again may be conflicting, and this have impact on operation control efficiency to a great extent.
Summary of the invention
Based on this, the object of the embodiment of the present invention is the data enquire method and the system thereof that provide a kind of power business system, the search inquiry while that it can carrying out the data of multiple operation system, and unification shows user, more convenient.
For achieving the above object, the embodiment of the present invention by the following technical solutions:
A data enquire method for power business system, comprises the following steps:
The database information of each power business system is registered, the database information of each power business system is recorded in database table;
According to the database information in described database table, configure the link information of the database of each power business system;
Using the main external key of the database table of each power business system as Correlation Criteria, configure the incidence relation of the database table of each power business system;
Obtain the data query conditions of input, obtain the database information meeting each power business system of described data query conditions according to described incidence relation;
Connect the database of corresponding power business system according to the described link information of correspondence, obtain data result set, and described data result collection is shown.
A data query system for power business system, comprising:
Information logging modle, for registering the database information of each power business system, is recorded in database table by the database information of each power business system;
Connect configuration module, for according to the database information in described database table, configure the link information of the database of each power business system;
Associated configuration module, for using the main external key of the database table of each power business system as Correlation Criteria, configures the incidence relation of the database table of each power business system;
Enquiry module, for obtaining the data query conditions of input, obtain the database information meeting each power business system of described data query conditions according to described incidence relation, connect the database of corresponding power business system according to the described link information of correspondence, obtain data result set;
Display module, for showing described data result collection.
According to the scheme of the embodiment of the present invention as above, first the database information of each power business system is registered, the database information of each power business system is recorded in database table, according to the database information in described database table, configure the link information of the database of each power business system, then using the main external key of the database table of each power business system as Correlation Criteria, configure the incidence relation of the database table of each power business system, when user carries out data query, obtain the data query conditions of input, the database information meeting each power business system of described data query conditions is obtained according to described incidence relation, and the database of corresponding power business system is connected according to the described link information of correspondence, obtain data result set, and described data result collection is shown.
Therefore, a kind of data sheet across multiple power business system can be provided to inquire about deriving method, the problem such as each power business system data disunity before solving, manual integration efficiency are low, effectively raises production efficiency, ensure that the accuracy of data, ageing simultaneously.Effectively solve the problem that data between different system are single, disperse, well eliminate " information island " phenomenon of each system simultaneously, improve the work efficiency of power business personnel.
Support that the data interconnection between two or more power business system is inquired about, in utilizing different power business data among systems storehouse to show, each power business system is carried out association binding by main external key incidence relation, corresponding structured query sentence is generated according to incidence relation and corresponding querying condition, also can carry out conditional filtering to Query Result further again, obtain data result row.Be configured the output page, can add flexibly as page output conditions such as grouping, sequence, classification, Query Result is shown in class excel mode simultaneously.
In order to Utilities Electric Co. wins economic benefit and social benefit, can the original each power business system of integrated optimization, current and integrated information integration platform that is tomorrow requirement can be met again, good support can be provided for each operation system Data Integration and report form statistics.
Accompanying drawing explanation
Fig. 1 is the schematic flow sheet of the data enquire method of power business system in one embodiment of the invention;
Fig. 2 is the structural representation of the data query system of power business system in one embodiment of the invention.
Embodiment
For making object of the present invention, technical scheme and advantage clearly understand, below in conjunction with drawings and Examples, the present invention is described in further detail.Should be appreciated that embodiment described herein only in order to explain the present invention, do not limit protection scope of the present invention.
The schematic flow sheet of the data enquire method of power business system in an embodiment has been shown in Fig. 1.
The data enquire method of described power business system, comprises the following steps:
S102, registers the database information of each power business system, is recorded in database table by the database information of each power business system;
S104, according to the database information in described database table, configures the link information of the database of each power business system;
S106, using the main external key of the database table of each power business system as Correlation Criteria, configures the incidence relation of the database table of each power business system;
S108, obtains the data query conditions of input, obtains the database information meeting each power business system of described data query conditions according to described incidence relation;
S110, connects the database of corresponding power business system according to the described link information of correspondence, obtain data result set, and shown by described data result collection.
The database information of each power business system is registered, the database information of each power business system is recorded in database table, according to the database information in described database table, configure the link information of the database of each power business system, then using the main external key of the database table of each power business system as Correlation Criteria, configure the incidence relation of the database table of each power business system, when user carries out data query, obtain the data query conditions of input, the database information meeting each power business system of described data query conditions is obtained according to described incidence relation, and the database of corresponding power business system is connected according to the described link information of correspondence, obtain data result set, and described data result collection is shown.
Therefore, a kind of data sheet across multiple power business system can be provided to inquire about deriving method, the problem such as each power business system data disunity before solving, manual integration efficiency are low, effectively raises production efficiency, ensure that the accuracy of data, ageing simultaneously.Effectively solve the problem that data between different system are single, disperse, well eliminate " information island " phenomenon of each system simultaneously, improve the work efficiency of power business personnel.
Wherein, for step S102, for the step of data source parameter configuration, first, each power business system is by separately operation and the deployment of type of service, region region, each system may adopt different database software, common as oracle, mysql etc., database software different in implementation process need configure database-driven corresponding with it, therefore, in this step, need time first to register the database information of each power business system, the database information of each power business system is recorded in database table.That is, the database software of different power business system is configured and is registered, in database table, record the database software information that each power business system uses.
For step S104, according to the database information in described database table, configure the link information of the database of each power business system;
The database linkage information of each power business system described can comprise: server address, port, username and password.
In this step, according to the database information recorded in step s 102, configuring the database linkage information of each power business system, as server address, port, user name, password etc., preparing for connecting each power business system.
For step S106, using the main external key of the database table of each power business system as Correlation Criteria, configure the incidence relation of the database table of each power business system;
By using the main external key of the database table of each power business system as Correlation Criteria, can configure the incidence relation of the database table of different power business system exactly, incidence relation is using the main external key of table as Correlation Criteria.Multiple tables in each configurable association two storehouses; If association is continued in multiple storehouse, first time association can be considered as a result set storehouse, again repeat to select correlation inquiry; Corresponding SQL statement can be generated according to the incidence relation configured.
For step S108, obtain the data query conditions of input, obtain the database information meeting each power business system of described data query conditions according to described incidence relation;
By above-mentioned incidence relation, according to a data query conditions, multiple database table that is mutually related can be inquired about, thus obtain the database information to individual power business system, make Query Result more comprehensive.
In one embodiment, obtain the data query conditions of input, obtain according to described incidence relation the step meeting the database linkage information of each power business system of described data query conditions and comprise:
First, according to the data layout of the data query conditions of input, obtain the database linkage information with described pattern matched;
Then, according to the incidence relation of described database table, inquire about the Relational database link information with the described database mated with incidence relation.
By the data layout of the data query conditions of input, can determine that the data layout of described data layout and which power business system matches fast, then its link information is determined, again according to above-mentioned incidence relation, obtain the link information of the database of the power business system of association, just can determine the link information of each relevant database fast, thus connect corresponding database fast, improve efficiency data query.
For step S110, connect the database of corresponding power business system according to the described link information of correspondence, obtain data result set, and described data result collection is shown.
In one embodiment, connect the database of corresponding power business system according to the described link information of correspondence, the step obtaining data result set comprises:
According to the data query conditions of input, and described incidence relation, generate the SQL query statement of the database of corresponding power business system;
Corresponding SQL query statement is sent to the database of corresponding power business system, obtains the Query Result of each database;
Query Result according to each database generates data result collection.
By the way, the SQL query statement of the database of each power business system is generated rapidly according to querying condition, described SQL query statement is sent to the database of corresponding power business system by corresponding database linkage information, obtain the Query Result of each database, the Query Result of database described in each is integrated into data result collection, the Query Result of each database of unified representation.
Further, after the step obtaining data result set, also can comprise the following steps:
According to the querying condition of annex, described data result collection is screened, obtain the data result collection after screening;
According to the requirement of output report, Output rusults configuration is carried out to the data result collection after described screening.
By the way, screen according to pre-conditioned the data result collection generated, operating personnel can need to arrange screening conditions according to self, thus obtain the Output rusults more meeting self-demand.
Described Output rusults configuration can comprise: screen the row of form needs, setting grouping and sort criteria etc.
After configuration association relation, the data result got integrates all data as two database tables corresponding in incidence relation, according to the actual conditions of each power business system, can increase the querying condition of screening, as the screening etc. to the time, obtain result set more accurately.
Through the result set of screening, can carry out Output rusults configuration to result set field, according to the demand of the form of each operating personnel, the row that screening form needs, the conditions such as setting grouping, sequence, obtain the report data after screening configuration.
After getting final report data, typesetting setting is carried out to exhibition method, carry out sequence grouping from the row got and arrange, obtain the form exported.
Adopt this method, effectively can solve multiservice system data disunity in electric system, data scatter, problem that the degree of coupling is low, improve the work efficiency of Utilities Electric Co. at different levels.
Support that the data interconnection between two or more power business system is inquired about, in utilizing different power business data among systems storehouse to show, each power business system is bound by main external key incidence relation, corresponding structured query sentence (SQL) is generated according to incidence relation and corresponding querying condition, again conditional filtering is carried out to Query Result, obtain data result row.Be configured the report output page, can add flexibly as page output conditions such as grouping, sequence, classification, Query Result is shown in class excel mode simultaneously.
By the data source of each power business system of configuration, be connected to each power business system database simultaneously, and according to the every incidence relation configured, fast data inquired about, classify, integrate, according to user-defined report output pattern, generate result form fast.
It can, independent of any power business system, be a kind of data query technique of cross-system, and data different from the past are only originated individual system.Support the data query between multiple power business system and derivation simultaneously, and can export according to user-defined statement form.Once configure, the characteristic repeatedly run, after DataBase combining source, incidence relation are determined, only need suitably screen the data result that can obtain configuring according to condition and export, convenient and swift.
Please refer to Fig. 2, the present invention also provides a kind of data query system of power business system, comprising:
Information logging modle 10, for registering the database information of each power business system, is recorded in database table by the database information of each power business system;
Connect configuration module 20, for according to the database information in described database table, configure the link information of the database of each power business system;
Associated configuration module 30, for using the main external key of the database table of each power business system as Correlation Criteria, configures the incidence relation of the database table of each power business system;
Enquiry module 40, for obtaining the data query conditions of input, obtain the database information meeting each power business system of described data query conditions according to described incidence relation, connect the database of corresponding power business system according to the described link information of correspondence, obtain data result set;
Display module 50, for showing described data result collection.
The database information of each power business system is registered, the database information of each power business system is recorded in database table, according to the database information in described database table, configure the link information of the database of each power business system, then using the main external key of the database table of each power business system as Correlation Criteria, configure the incidence relation of the database table of each power business system, when user carries out data query, obtain the data query conditions of input, the database information meeting each power business system of described data query conditions is obtained according to described incidence relation, and the database of corresponding power business system is connected according to the described link information of correspondence, obtain data result set, and described data result collection is shown.
Therefore, a kind of data sheet across multiple power business system can be provided to inquire about deriving method, the problem such as each power business system data disunity before solving, manual integration efficiency are low, effectively raises production efficiency, ensure that the accuracy of data, ageing simultaneously.Effectively solve the problem that data between different system are single, disperse, well eliminate " information island " phenomenon of each system simultaneously, improve the work efficiency of power business personnel.
In one embodiment, described database linkage information comprises: server address, port, username and password.
In one embodiment, described enquiry module 40 is according to the data layout of the data query conditions of input, obtain the database linkage information with described pattern matched, and according to the incidence relation of described database table, inquiry and the described database mated have the Relational database link information of incidence relation.
In one embodiment, described enquiry module 40 is according to the data query conditions of input, and described incidence relation, generate the SQL query statement of the database of corresponding power business system, corresponding SQL query statement is sent to the database of corresponding power business system, obtain the Query Result of each database, the Query Result according to each database generates data result collection.
In one embodiment, comprise query optimization module further, for the querying condition according to annex, described data result collection is screened, obtain the data result collection after screening, according to the requirement of output report, Output rusults configuration is carried out to the data result collection after described screening.
In one embodiment, described Output rusults configuration comprises: row, the setting of screening form needs are divided into groups and sort criteria.
Each technical characteristic of the above embodiment can combine arbitrarily, for making description succinct, the all possible combination of each technical characteristic in above-described embodiment is not all described, but, as long as the combination of these technical characteristics does not exist contradiction, be all considered to be the scope that this instructions is recorded.
The above embodiment only have expressed several embodiment of the present invention, and it describes comparatively concrete and detailed, but can not therefore be construed as limiting the scope of the patent.It should be pointed out that for the person of ordinary skill of the art, without departing from the inventive concept of the premise, can also make some distortion and improvement, these all belong to protection scope of the present invention.Therefore, the protection domain of patent of the present invention should be as the criterion with claims.
Claims (10)
1. a data enquire method for power business system, is characterized in that, comprises the following steps:
The database information of each power business system is registered, the database information of each power business system is recorded in database table;
According to the database information in described database table, configure the link information of the database of each power business system;
Using the main external key of the database table of each power business system as Correlation Criteria, configure the incidence relation of the database table of each power business system;
Obtain the data query conditions of input, obtain the database information meeting each power business system of described data query conditions according to described incidence relation;
Connect the database of corresponding power business system according to the described link information of correspondence, obtain data result set, and described data result collection is shown.
2. the data enquire method of power business system according to claim 1, is characterized in that, the database linkage information configuring each power business system comprises:
Server address, port, username and password.
3. the data enquire method of power business system according to claim 1, is characterized in that, connects the database of corresponding power business system according to the described link information of correspondence, and the step obtaining data result set comprises:
According to the data query conditions of input, and described incidence relation, generate the SQL query statement of the database of corresponding power business system;
Corresponding SQL query statement is sent to the database of corresponding power business system, obtains the Query Result of each database;
Query Result according to each database generates data result collection.
4. the data enquire method of the power business system according to claims 1 to 3 any one, is characterized in that, the step obtaining data result set comprises further:
According to the querying condition of annex, described data result collection is screened, obtain the data result collection after screening;
According to the requirement of output report, Output rusults configuration is carried out to the data result collection after described screening.
5. the data enquire method of power business system according to claim 4, is characterized in that, described Output rusults configuration comprises:
The row that screening form needs, setting grouping and sort criteria.
6. a data query system for power business system, is characterized in that, comprising:
Information logging modle, for registering the database information of each power business system, is recorded in database table by the database information of each power business system;
Connect configuration module, for according to the database information in described database table, configure the link information of the database of each power business system;
Associated configuration module, for using the main external key of the database table of each power business system as Correlation Criteria, configures the incidence relation of the database table of each power business system;
Enquiry module, for obtaining the data query conditions of input, obtain the database information meeting each power business system of described data query conditions according to described incidence relation, connect the database of corresponding power business system according to the described link information of correspondence, obtain data result set;
Display module, for showing described data result collection.
7. the data query system of power business system according to claim 6, is characterized in that, described database linkage information comprises: server address, port, username and password.
8. the data query system of power business system according to claim 6, it is characterized in that, described enquiry module is according to the data query conditions of input, and described incidence relation, generate the SQL query statement of the database of corresponding power business system, corresponding SQL query statement is sent to the database of corresponding power business system, obtains the Query Result of each database, the Query Result according to each database generates data result collection.
9. the data query system of the power business system according to any one of claim 6 to 8, it is characterized in that, comprise query optimization module further, for the querying condition according to annex, described data result collection is screened, obtain the data result collection after screening, according to the requirement of output report, Output rusults configuration is carried out to the data result collection after described screening.
10. the data query system of power business system according to claim 9, is characterized in that, described Output rusults configuration comprises:
The row that screening form needs, setting grouping and sort criteria.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510466486.2A CN104991975B (en) | 2015-07-30 | 2015-07-30 | The data query method and its system of power business system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510466486.2A CN104991975B (en) | 2015-07-30 | 2015-07-30 | The data query method and its system of power business system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN104991975A true CN104991975A (en) | 2015-10-21 |
| CN104991975B CN104991975B (en) | 2019-03-22 |
Family
ID=54303790
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510466486.2A Active CN104991975B (en) | 2015-07-30 | 2015-07-30 | The data query method and its system of power business system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104991975B (en) |
Cited By (14)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105243480A (en) * | 2015-09-28 | 2016-01-13 | 国网浙江宁海县供电公司 | Data information management method, server and system |
| CN105574080A (en) * | 2015-12-07 | 2016-05-11 | 安徽继远软件有限公司 | Business significance-based unified data description method among multiple application systems |
| CN106528594A (en) * | 2016-09-20 | 2017-03-22 | 海信集团有限公司 | Downloaded file querying method and device |
| CN106933930A (en) * | 2015-12-31 | 2017-07-07 | 北京国双科技有限公司 | The method and apparatus for screening session |
| CN106933920A (en) * | 2015-12-31 | 2017-07-07 | 北京国双科技有限公司 | The screening technique and device of session |
| CN107944050A (en) * | 2017-12-21 | 2018-04-20 | 国网山西省电力公司晋城供电公司 | A kind of electric power system data managing method and system based on big data |
| CN108228611A (en) * | 2016-12-14 | 2018-06-29 | 平安科技（深圳）有限公司 | Document information copies method and apparatus |
| CN108595500A (en) * | 2018-03-18 | 2018-09-28 | 平安科技（深圳）有限公司 | Sound recordings management-control method, system, computer equipment and storage medium |
| CN108763308A (en) * | 2018-04-24 | 2018-11-06 | 北京首都机场动力能源有限公司 | A kind of supply station data check management method and system |
| CN109376177A (en) * | 2018-09-30 | 2019-02-22 | 国网宁夏电力有限公司中卫供电公司 | A kind of data mining analysis method |
| CN109885731A (en) * | 2018-12-29 | 2019-06-14 | 国网山东省电力公司博兴县供电公司 | A kind of power monitoring platform data information MAP matching process and system |
| CN110046153A (en) * | 2018-11-19 | 2019-07-23 | 阿里巴巴集团控股有限公司 | A kind of method, device and equipment of account fund verification |
| CN112989171A (en) * | 2021-03-26 | 2021-06-18 | 广东电网有限责任公司 | Data query method, device, equipment and medium |
| CN115357602A (en) * | 2022-10-19 | 2022-11-18 | 广东电网有限责任公司佛山供电局 | Method and system for acquiring operation and maintenance work data requirements of transformer substation |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101477526A (en) * | 2008-12-31 | 2009-07-08 | 中兴通讯股份有限公司 | Method and system for implementing statistical forms customization |
| CN101751479A (en) * | 2010-01-27 | 2010-06-23 | 北京东方灵盾科技有限公司 | Similarity matching system for prescription information of traditional medicine patents and matching method thereof |
| US20110289091A1 (en) * | 2010-05-18 | 2011-11-24 | Salesforce.Com, Inc. | Methods and Systems for Providing Multiple Column Custom Indexes In A Multi-Tenant Database Environment |
| CN102902777A (en) * | 2012-09-28 | 2013-01-30 | 用友软件股份有限公司 | Cross data source inquiry device and cross data source inquiry method |
| CN103488694A (en) * | 2013-09-02 | 2014-01-01 | 用友软件股份有限公司 | Business data inquiry device and business data inquiry method |
-
2015
- 2015-07-30 CN CN201510466486.2A patent/CN104991975B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101477526A (en) * | 2008-12-31 | 2009-07-08 | 中兴通讯股份有限公司 | Method and system for implementing statistical forms customization |
| CN101751479A (en) * | 2010-01-27 | 2010-06-23 | 北京东方灵盾科技有限公司 | Similarity matching system for prescription information of traditional medicine patents and matching method thereof |
| US20110289091A1 (en) * | 2010-05-18 | 2011-11-24 | Salesforce.Com, Inc. | Methods and Systems for Providing Multiple Column Custom Indexes In A Multi-Tenant Database Environment |
| CN102902777A (en) * | 2012-09-28 | 2013-01-30 | 用友软件股份有限公司 | Cross data source inquiry device and cross data source inquiry method |
| CN103488694A (en) * | 2013-09-02 | 2014-01-01 | 用友软件股份有限公司 | Business data inquiry device and business data inquiry method |
Non-Patent Citations (1)
| Title |
|---|
| 倪燕: ""异构***数据共享的研究与实现"", 《中国优秀硕士学位论文全文数据库信息科技辑》 * |
Cited By (19)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105243480A (en) * | 2015-09-28 | 2016-01-13 | 国网浙江宁海县供电公司 | Data information management method, server and system |
| CN105574080A (en) * | 2015-12-07 | 2016-05-11 | 安徽继远软件有限公司 | Business significance-based unified data description method among multiple application systems |
| CN106933930A (en) * | 2015-12-31 | 2017-07-07 | 北京国双科技有限公司 | The method and apparatus for screening session |
| CN106933920A (en) * | 2015-12-31 | 2017-07-07 | 北京国双科技有限公司 | The screening technique and device of session |
| CN106528594A (en) * | 2016-09-20 | 2017-03-22 | 海信集团有限公司 | Downloaded file querying method and device |
| CN108228611B (en) * | 2016-12-14 | 2020-08-18 | 平安科技（深圳）有限公司 | Document information copying method and device |
| CN108228611A (en) * | 2016-12-14 | 2018-06-29 | 平安科技（深圳）有限公司 | Document information copies method and apparatus |
| CN107944050A (en) * | 2017-12-21 | 2018-04-20 | 国网山西省电力公司晋城供电公司 | A kind of electric power system data managing method and system based on big data |
| CN108595500A (en) * | 2018-03-18 | 2018-09-28 | 平安科技（深圳）有限公司 | Sound recordings management-control method, system, computer equipment and storage medium |
| CN108595500B (en) * | 2018-03-18 | 2022-09-30 | 平安科技（深圳）有限公司 | Recording management and control method, system, computer equipment and storage medium |
| CN108763308A (en) * | 2018-04-24 | 2018-11-06 | 北京首都机场动力能源有限公司 | A kind of supply station data check management method and system |
| CN109376177A (en) * | 2018-09-30 | 2019-02-22 | 国网宁夏电力有限公司中卫供电公司 | A kind of data mining analysis method |
| CN109376177B (en) * | 2018-09-30 | 2021-11-02 | 国网宁夏电力有限公司中卫供电公司 | Data drilling analysis method |
| CN110046153A (en) * | 2018-11-19 | 2019-07-23 | 阿里巴巴集团控股有限公司 | A kind of method, device and equipment of account fund verification |
| CN110046153B (en) * | 2018-11-19 | 2023-09-05 | 创新先进技术有限公司 | Account fund checking method, device and equipment |
| CN109885731B (en) * | 2018-12-29 | 2021-06-15 | 国网山东省电力公司博兴县供电公司 | Data information mapping matching method and system for power monitoring platform |
| CN109885731A (en) * | 2018-12-29 | 2019-06-14 | 国网山东省电力公司博兴县供电公司 | A kind of power monitoring platform data information MAP matching process and system |
| CN112989171A (en) * | 2021-03-26 | 2021-06-18 | 广东电网有限责任公司 | Data query method, device, equipment and medium |
| CN115357602A (en) * | 2022-10-19 | 2022-11-18 | 广东电网有限责任公司佛山供电局 | Method and system for acquiring operation and maintenance work data requirements of transformer substation |
Also Published As
| Publication number | Publication date |
|---|---|
| CN104991975B (en) | 2019-03-22 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104991975A (en) | Data query method and system of electric power business systems | |
| AU2021204978B2 (en) | Using an object model of heterogeneous data to facilitate building data visualizations | |
| CN110618983B (en) | JSON document structure-based industrial big data multidimensional analysis and visualization method | |
| CN103631969B (en) | A kind of generation method and device of report data | |
| CN103605651A (en) | Data processing showing method based on on-line analytical processing (OLAP) multi-dimensional analysis | |
| CN105740333A (en) | Visual advertisement management platform, and implementation method thereof | |
| CN105488048A (en) | Data query method and device | |
| CN104778540A (en) | BOM (bill of material) management method and management system for building material equipment manufacturing | |
| CN102279848A (en) | Method and device for generating report template | |
| CN106777027B (en) | Large-scale parallel processing row-column mixed data storage device and storage and query method | |
| CN103019728A (en) | Effective complex report parsing engine and parsing method thereof | |
| CN102426587A (en) | Method for customizing and inquiring heterogeneous BOM (Bill of Materiel) based on complex product | |
| CN109684616A (en) | Dynamic statement formula assembles the method and system made a report on | |
| CN105046604A (en) | Patent information management system | |
| US20140181151A1 (en) | Query of multiple unjoined views | |
| CN103646100A (en) | Report data organization model | |
| CN104123422A (en) | Pre-manufacturing design method through database management system | |
| CN104899143A (en) | Software peer review system realizing device for providing DM (Data Mining) | |
| CN104462361B (en) | The method and apparatus of data in a kind of matched data table | |
| CN102708142A (en) | Method and system for acquiring background data through structured query language (SQL) custom-made template | |
| CN114218218A (en) | Data processing method, device and equipment based on data warehouse and storage medium | |
| CN103605528A (en) | Service development method and device | |
| CN103942266A (en) | Data analysis method capable of achieving self-defining of complex service computational logic on basis of OLAP | |
| CN108345646B (en) | Method for rapidly and automatically constructing multi-dimensional report by applying interception technology | |
| CN103473305A (en) | Method and system for performing decision-making process show in statistic analysis |
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 |