CN104991975B - The data query method and its system of power business system - Google Patents
The data query method and its system of power business system Download PDFInfo
- Publication number
- CN104991975B CN104991975B CN201510466486.2A CN201510466486A CN104991975B CN 104991975 B CN104991975 B CN 104991975B CN 201510466486 A CN201510466486 A CN 201510466486A CN 104991975 B CN104991975 B CN 104991975B
- Authority
- CN
- China
- Prior art keywords
- database
- business system
- data
- power business
- 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.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 21
- 238000012216 screening Methods 0.000 claims description 12
- 238000005457 optimization Methods 0.000 claims description 3
- 230000010354 integration Effects 0.000 description 6
- 239000006185 dispersion Substances 0.000 description 4
- 241001269238 Data Species 0.000 description 3
- 230000008901 benefit Effects 0.000 description 3
- 230000008859 change Effects 0.000 description 3
- 238000010586 diagram Methods 0.000 description 3
- 235000013399 edible fruits Nutrition 0.000 description 3
- 238000004519 manufacturing process Methods 0.000 description 3
- 238000001914 filtration Methods 0.000 description 2
- 238000004891 communication Methods 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
- 238000011161 development Methods 0.000 description 1
- 230000007246 mechanism Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification 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
A kind of the data query method and its system of power business system, comprising: 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 the database table, the link information of the database of each power business system is configured；Using the main external key of the database table of each power business system as Correlation Criteria, the incidence relation of the database table of each power business system is configured；The data query conditions for obtaining input obtain the database information for meeting each power business system of the data query conditions according to the incidence relation；The database of corresponding power business system is connected according to the corresponding link information, obtains data result collection, and the data result collection is shown.Can the data to multiple operation systems carry out simultaneously scanning for inquiring, and uniformly show user, it is more convenient.
Description
Technical field
The present invention relates to the technical fields of power business system, more particularly to a kind of data query of power business system
Method and a kind of data query system of power business system.
Background technique
In the actual operation of electric system, there is miscellaneous operation system, the moment is all a large amount of real-time in generation
Data, and require to submit corresponding report, such as daily paper, weekly, monthly magazine, quarterly report, annual report etc. at regular intervals.By right
Data collected are summed up, are statisticallyd analyze in a certain period of time, and report can be multi-level by the operating status of system, more
Angle is reflected to user.
Existing business model needs to inquire certain category information, needs to log in different systems and repeatedly scans for, across multiple
Platform carries out information retrieval, intuitively can not carry out full dose to information needed and intuitively show, can not accurately and efficiently believe result
Breath is integrated, this has been resulted in, and information feedback timeliness is poor, and polling cycle is long, causes to the real work of user larger
It influences.
Typically now power supply company, each province operates in consolidated network, but since each city-level power supply company information system is logical
Normal respective stand-alone development, this just causes very big difficulty to when carrying out communication contact between company, city and provincial company.
The difficulty is mainly manifested in due to there is multiple data sources, not can guarantee the consistency of data；Because data are dispersed in
In multiple subsystems, comprehensive inquiry is than relatively difficult to achieve；Since entire electric power structure and administrative mechanism change constantly, no
Disconnected to increase, change some statistical indicators, statistical report form must make corresponding change, and existing each subsystem cannot it is simple,
Information integration is promptly carried out, the data that the different department of some key indexes offers again may be conflicting, this is in very great Cheng
Operation control efficiency is affected on degree.
Summary of the invention
Based on this, a kind of data query method for being designed to provide power business system of the embodiment of the present invention and its it is
System, can the data to multiple operation systems carry out simultaneously scanning for inquiring, and uniformly show user, it is more convenient.
In order to achieve the above objectives, the embodiment of the present invention uses following technical scheme:
A kind of data query method of power business system, comprising the following steps:
The database information of each power business system is registered, by the database information of each power business system
It is recorded in database table；
According to the database information in the database table, the connection letter of the database of each power business system is configured
Breath；
Using the main external key of the database table of each power business system as Correlation Criteria, each power business system is configured
Database table incidence relation；
The data query conditions for obtaining input meet each of the data query conditions according to incidence relation acquisition
The database information of power business system；
The database of corresponding power business system is connected according to the corresponding link information, obtains data result collection,
And the data result collection is shown.
A kind of data query system of power business system, comprising:
Information logging modle is registered for the database information to each power business system, by each electric power industry
The database information of business system is recorded in database table；
Configuration module is connected, for configuring each power business system according to the database information in the database table
Database link information；
Associated configuration module, for matching using the main external key of the database table of each power business system as Correlation Criteria
Set the incidence relation of the database table of each power business system；
Enquiry module meets the data according to incidence relation acquisition for obtaining the data query conditions of input
The database information of each power business system of querying condition connects corresponding electric power industry according to the corresponding link information
The database of business system obtains data result collection；
Display module, for the data result collection to be shown.
According to the scheme of embodiment present invention as described above, first to the database information of each power business system into
Row registration, the database information of each power business system is recorded in database table, according to the number in the database table
According to library information, the link information of the database of each power business system is configured, then with the data of each power business system
The main external key of library table configures the incidence relation of the database table of each power business system as Correlation Criteria, carries out in user
When data query, the data query conditions of input are obtained, the data query conditions are met according to incidence relation acquisition
The database information of each power business system, and corresponding power business system is connected according to the corresponding link information
Database obtains data result collection, and the data result collection is shown.
Therefore, it is capable of providing a kind of data sheet inquiry deriving method across multiple power business systems, before solving
The problems such as each power business system data disunity, manual integration low efficiency, production efficiency is effectively raised, is guaranteed simultaneously
The accuracy of data, timeliness.The problem of different inter-system datas of effective solution are single, dispersion, while well disappearing
In addition to " information island " phenomenon of each system, the working efficiency of power business personnel is improved.
The data interconnection between two or more power business systems is supported to inquire, using between different power business systems
Each power business system is associated binding by main external key incidence relation in database table, is looked into according to incidence relation and accordingly
Inquiry condition generates corresponding structured query sentence, yet further can also carry out conditional filtering to query result, obtain data
As a result it arranges.The output page is configured simultaneously, such as grouping, sequence, classification page output condition, inquiry knot can flexibly be added
Fruit is shown in a manner of class excel.
In order to which Utilities Electric Co. wins economic benefit and social benefit, can the original each power business system of integrated optimization and
It is able to satisfy the integrated information integration platform of current and future demand, can be provided for each operation system Data Integration and report form statistics good
Good support.
Detailed description of the invention
Fig. 1 is the flow diagram of the data query method of power business system in one embodiment of the invention；
Fig. 2 is the structural schematic diagram of the data query system of power business system in one embodiment of the invention.
Specific embodiment
To make the objectives, technical solutions, and advantages of the present invention more comprehensible, with reference to the accompanying drawings and embodiments, to this
Invention is described in further detail.It should be appreciated that the specific embodiments described herein are only used to explain the present invention,
And the scope of protection of the present invention is not limited.
The flow diagram of the data query method of power business system in one embodiment is shown in Fig. 1.
The data query method of the power business system, comprising the following steps:
S102 registers the database information of each power business system, by the data of each power business system
Library information is recorded in database table；
S104 configures the company of the database of each power business system according to the database information in the database table
Connect information；
S106 configures each electric power industry using the main external key of the database table of each power business system as Correlation Criteria
The incidence relation of the database table of business system；
S108 obtains the data query conditions of input, meets the data query conditions according to incidence relation acquisition
Each power business system database information；
S110 connects the database of corresponding power business system according to the corresponding link information, obtains data knot
Fruit collection, and the data result collection is shown.
The database information of each power business system is registered, by the database information of each power business system
It is recorded in database table, according to the database information in the database table, configures the database of each power business system
Link information configure each electric power then using the main external key of the database table of each power business system as Correlation Criteria
The incidence relation of the database table of operation system obtains the data query conditions of input when user carries out data query, according to
The incidence relation obtains the database information for meeting each power business system of the data query conditions, and according to correspondence
The link information connect the database of corresponding power business system, obtain data result collection, and by the data result
Collection is shown.
Therefore, it is capable of providing a kind of data sheet inquiry deriving method across multiple power business systems, before solving
The problems such as each power business system data disunity, manual integration low efficiency, production efficiency is effectively raised, is guaranteed simultaneously
The accuracy of data, timeliness.The problem of different inter-system datas of effective solution are single, dispersion, while well disappearing
In addition to " information island " phenomenon of each system, the working efficiency of power business personnel is improved.
Wherein, for step S102, the step of configuration for data source parameter, firstly, each power business system presses business
Type, ground level region are separately runed and are disposed, each system may use different database software, it is common as oracle,
Mysql etc., different database software need to configure corresponding database-driven in implementation process, therefore, in this step,
It needs the database information to each power business system to register when first, the database of each power business system is believed
Breath is recorded in database table.That is, the database software of different power business systems is configured and is registered, in database table
The middle database software information for recording each power business system and using.
The number of each power business system is configured according to the database information in the database table for step S104
According to the link information in library；
The database linkage information of each power business system can include: server address, port, user name and close
Code.
In this step, according to the database information recorded in step s 102, the data of each power business system are configured
Library link information, such as server address, port, user name, password are prepared to connect each power business system.
For step S106, using the main external key of the database table of each power business system as Correlation Criteria, configuration is each
The incidence relation of the database table of a power business system；
By can accurately configure not using the main external key of the database table of each power business system as Correlation Criteria
With the incidence relation of the database table of power business system, incidence relation is using the main external key of table as Correlation Criteria.It can match every time
Set multiple tables in two libraries of association；If multiple libraries continue to be associated with, the first secondary association can be considered as to a result set library, again
Repeat selection correlation inquiry；Corresponding SQL statement is produced according to configured incidence relation.
For step S108, the data query conditions of input are obtained, the data are met according to incidence relation acquisition
The database information of each power business system of querying condition；
By above-mentioned incidence relation, multiple database tables that are mutually related can be inquired according to a data query conditions,
To obtain the database information to a power business system, keep query result more comprehensive.
In one embodiment, the data query conditions for obtaining input meet described according to incidence relation acquisition
The step of database linkage information of each power business system of data query conditions includes:
Firstly, the data format of querying condition according to the input data, obtains the database with the pattern matched
Link information；
Then, according to the incidence relation of the database table, inquiry has incidence relation with the matched database
Relational database link information.
By the data format of the data query conditions of input, the data format and which electric power can be quickly determined
The data format of operation system matches, and then determines its link information, further according to above-mentioned incidence relation, obtains associated electric power
The link information of the database of operation system, so that it may the link information for quickly determining each relevant database, thus quickly
Corresponding database is connected, efficiency data query is improved.
For step S110, the database of corresponding power business system is connected according to the corresponding link information, is obtained
Access is shown according to result set, and by the data result collection.
In one embodiment, the database of corresponding power business system is connected according to the corresponding link information,
Obtain data result collection the step of include:
Querying condition and the incidence relation according to the input data generate the database of corresponding power business system
SQL query statement；
Corresponding SQL query statement is sent to the database of corresponding power business system, obtains each database
Query result；
Data result collection is generated according to the query result of each database.
By the above-mentioned means, rapidly generating the SQL query of the database of each power business system according to querying condition
The SQL query statement is sent to the data of corresponding power business system by sentence by corresponding database linkage information
Library obtains the query result of each database, and the query result of each database is integrated into data result collection, unified table
Show the query result of each database.
Further, it after the step of obtaining data result collection, can comprise the further steps of:
According to the querying condition of attachment, the data result collection is screened, the data result collection after being screened；
According to the requirement of output report, output result configuration is carried out to the data result collection after the screening.
By the above-mentioned means, the data result collection to generation is screened according to preset condition, operator can basis
It itself needs that screening conditions are arranged, to obtain the output result for being more in line with self-demand.
The output result configuration can include: column, setting grouping and sort criteria that screening report needs etc..
After configuration association relationship, the data result got integrates as two database tables corresponding in incidence relation
All data can increase the querying condition of screening, such as the screening to the time according to the actual conditions of each power business system,
More accurately obtain result set.
By the result set of screening, output result configuration can be carried out to result set field, according to the report of each operator
Demand, the column that screening report needs, the conditions such as setting grouping, sequence obtain screening with the report data that postpones.
After getting final report data, typesetting setting is carried out to exhibition method, is ranked up point from the column got
Group setting, obtains the report of output.
Using this method, multiservice system data disunity in electric system, data dispersion, the degree of coupling can effectively solve
Low problem improves the working efficiency of Utilities Electric Co.s at different levels.
The data interconnection between two or more power business systems is supported to inquire, using between different power business systems
Main external key incidence relation binds each power business system in database table, inquires item according to incidence relation and accordingly
Part generates corresponding structured query sentence (SQL), then carries out conditional filtering to query result, obtains data result column.Simultaneously
The report output page is configured, such as grouping, sequence, classification page output condition can flexibly be added, query result is with class
Excel mode is shown.
By the data source of each power business system configured, while it being connected to each power business system database, and
According to configured every incidence relation, quickly data are inquired, classified, are integrated, according to the customized report of user
Pattern is exported, result form is quickly generated.
It can be a kind of data query technique of cross-system, number different from the past independently of any power business system
According to only source individual system.The data query and export between multiple power business systems are supported simultaneously, and can be made by oneself according to user
The statement form of justice is exported.It once configures, the characteristic being run multiple times, after database connects source, incidence relation determines, only
Need to suitably be screened according to condition can be obtained configured data result and is exported, convenient and efficient.
Referring to FIG. 2, the present invention also provides a kind of data query systems of power business system, comprising:
Information logging modle 10 is registered for the database information to each power business system, by each electric power
The database information of operation system is recorded in database table；
Configuration module 20 is connected, for configuring each power business system according to the database information in the database table
The link information of the database of system；
Associated configuration module 30, for 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；
Enquiry module 40 meets the number according to incidence relation acquisition for obtaining the data query conditions of input
According to the database information of each power business system of querying condition, corresponding electric power is connected according to the corresponding link information
The database of operation system obtains data result collection；
Display module 50, for the data result collection to be shown.
The database information of each power business system is registered, by the database information of each power business system
It is recorded in database table, according to the database information in the database table, configures the database of each power business system
Link information configure each electric power then using the main external key of the database table of each power business system as Correlation Criteria
The incidence relation of the database table of operation system obtains the data query conditions of input when user carries out data query, according to
The incidence relation obtains the database information for meeting each power business system of the data query conditions, and according to correspondence
The link information connect the database of corresponding power business system, obtain data result collection, and by the data result
Collection is shown.
Therefore, it is capable of providing a kind of data sheet inquiry deriving method across multiple power business systems, before solving
The problems such as each power business system data disunity, manual integration low efficiency, production efficiency is effectively raised, is guaranteed simultaneously
The accuracy of data, timeliness.The problem of different inter-system datas of effective solution are single, dispersion, while well disappearing
In addition to " information island " phenomenon of each system, the working efficiency of power business personnel is improved.
In one embodiment, the database linkage information includes: server address, port, username and password.
In one embodiment, the data format of the enquiry module 40 querying condition according to the input data, obtain with
The database linkage information of the pattern matched, and according to the incidence relation of the database table, inquiry and the matching
Database have incidence relation Relational database link information.
In one embodiment, the enquiry module 40 querying condition and the incidence relation according to the input data,
Corresponding SQL query statement is sent to corresponding electric power by the SQL query statement for generating the database of corresponding power business system
The database of operation system obtains the query result of each database, generates data knot according to the query result of each database
Fruit collection.
It in one embodiment, further comprise query optimization module, for the querying condition according to attachment, to the number
It is screened according to result set, the data result collection after being screened, according to the requirement of output report, to the data after the screening
Result set carries out output result configuration.
In one embodiment, the output result configuration includes: the column for screening report and needing, setting grouping and sequence item
Part.
Each technical characteristic of embodiment described above can be combined arbitrarily, for simplicity of description, not to above-mentioned reality
It applies all possible combination of each technical characteristic in example to be all described, as long as however, the combination of these technical characteristics is not deposited
In contradiction, all should be considered as described in this specification.
The embodiments described above only express several embodiments of the present invention, and the description thereof is more specific and detailed, but simultaneously
It cannot therefore be construed as limiting the scope of the patent.It should be pointed out that coming for those of ordinary skill in the art
It says, without departing from the inventive concept of the premise, various modifications and improvements can be made, these belong to protection of the invention
Range.Therefore, the scope of protection of the patent of the invention shall be subject to the appended claims.
Claims (8)
1. a kind of data query method of power business system, which 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 the database table, the link information of the database of each power business system is configured；
Using the main external key of the database table of each power business system as Correlation Criteria, the number of each power business system is configured
According to the incidence relation of library table；
The data query conditions for obtaining input obtain each electric power for meeting the data query conditions according to the incidence relation
The database information of operation system；
The database of corresponding power business system is connected according to the corresponding link information, obtains data result collection, and will
The data result collection is shown；
The data query conditions for obtaining input obtain each electric power for meeting the data query conditions according to the incidence relation
The step of database information of operation system includes:
The data format of querying condition according to the input data obtains the database linkage information with the pattern matched；
According to the incidence relation of the database table, inquiry has the Relational database of incidence relation with the matched database
Link information；
The step of connecting the database of corresponding power business system according to the corresponding link information, obtaining data result collection
Include:
Querying condition and the incidence relation according to the input data generate the SQL of the database of corresponding power business system
Query statement；
Corresponding SQL query statement is sent to the database of corresponding power business system, obtains the inquiry of each database
As a result；
Data result collection is generated according to the query result of each database.
2. the data query method of power business system according to claim 1, which is characterized in that configure each electric power industry
The database linkage information of business system includes:
Server address, port, username and password.
3. according to claim 1 to the data query method of power business system described in 2 any one, which is characterized in that obtain
Access further comprises according to the step of result set:
According to the querying condition of attachment, the data result collection is screened, the data result collection after being screened；
According to the requirement of output report, output result configuration is carried out to the data result collection after the screening.
4. the data query method of power business system according to claim 3, which is characterized in that the output result is matched
It sets and includes:
Screen column, setting grouping and sort criteria that report needs.
5. a kind of data query system of power business system characterized by comprising
Information logging modle is registered for the database information to each power business system, by each power business system
The database information of system is recorded in database table；
Configuration module is connected, for configuring the number of each power business system according to the database information in the database table
According to the link information in library；
Associated configuration module, for using the main external key of the database table of each power business system as Correlation Criteria, configuration to be each
The incidence relation of the database table of a power business system；
Enquiry module meets the data query according to incidence relation acquisition for obtaining the data query conditions of input
The database information of each power business system of condition connects corresponding power business system according to the corresponding link information
The database of system obtains data result collection；
Display module, for the data result collection to be shown；
The enquiry module is further used for: the data format of querying condition according to the input data, obtains and the data lattice
The matched database linkage information of formula；
According to the incidence relation of the database table, inquiry has the Relational database of incidence relation with the matched database
Link information；
The enquiry module querying condition and the incidence relation according to the input data, generate corresponding power business system
Database SQL query statement, corresponding SQL query statement is sent to the database of corresponding power business system, is obtained
The query result for obtaining each database generates data result collection according to the query result of each database.
6. the data query system of power business system according to claim 5, which is characterized in that the database connection
Information includes: server address, port, username and password.
7. according to the data query system of the described in any item power business systems of claim 5 to 6, which is characterized in that into one
Step includes that query optimization module screens the data result collection, after being screened for the querying condition according to attachment
Data result collection output result configuration is carried out to the data result collection after the screening according to the requirement of output report.
8. the data query system of power business system according to claim 7, which is characterized in that the output result is matched
It sets and includes:
Screen column, setting grouping and sort criteria that report needs.
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 CN104991975A (en) | 2015-10-21 |
| CN104991975B true 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) |
Families Citing this family (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 |
| 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 |
| CN107944050A (en) * | 2017-12-21 | 2018-04-20 | 国网山西省电力公司晋城供电公司 | A kind of electric power system data managing method and system based on big data |
| 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 |
| CN109376177B (en) * | 2018-09-30 | 2021-11-02 | 国网宁夏电力有限公司中卫供电公司 | Data drilling analysis method |
| 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 |
| CN112989171B (en) * | 2021-03-26 | 2024-08-30 | 广东电网有限责任公司 | Data query method, device, equipment and medium |
| CN115357602B (en) * | 2022-10-19 | 2023-03-24 | 广东电网有限责任公司佛山供电局 | Method and system for acquiring operation and maintenance work data requirements of transformer substation |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101477526A (en) * | 2008-12-31 | 2009-07-08 | 中兴通讯股份有限公司 | Method and system for implementing statistical forms customization |
| 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 |
Family Cites Families (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101751479B (en) * | 2010-01-27 | 2012-07-25 | 北京东方灵盾科技有限公司 | Similarity matching system for prescription information of traditional medicine patents and matching method thereof |
| US10417611B2 (en) * | 2010-05-18 | 2019-09-17 | Salesforce.Com, Inc. | Methods and systems for providing multiple column custom indexes in a multi-tenant database environment |
-
2015
- 2015-07-30 CN CN201510466486.2A patent/CN104991975B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101477526A (en) * | 2008-12-31 | 2009-07-08 | 中兴通讯股份有限公司 | Method and system for implementing statistical forms customization |
| 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 |
|---|
| "异构系统数据共享的研究与实现";倪燕;《中国优秀硕士学位论文全文数据库信息科技辑》;20071115(第5期);第21页第5段,第31页第2-5段,第43页第4段,第45页第2-3段,第46页第4段,第47页第3-7段 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN104991975A (en) | 2015-10-21 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104991975B (en) | The data query method and its system of power business system | |
| AU2021204978B2 (en) | Using an object model of heterogeneous data to facilitate building data visualizations | |
| CN105224631B (en) | The method built the system of the open cloud of industry and work out XBRL financial statement | |
| US20190164231A1 (en) | Xbrl-based intelligent financial cloud platform system, construction method and business implementation method thereof | |
| CN109409678B (en) | Efficient multifunctional technical standard information system applied to power grid | |
| CN103631969A (en) | Generation method and device of report data | |
| CN104200402A (en) | Publishing method and system of source data of multiple data sources in power grid | |
| CN104572597A (en) | Automatic word analysis report generation method and device | |
| CN102279848A (en) | Method and device for generating report template | |
| CN203165012U (en) | Laboratory sample storage location management system | |
| CN109684616A (en) | Dynamic statement formula assembles the method and system made a report on | |
| US20140181151A1 (en) | Query of multiple unjoined views | |
| 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 | |
| CN109885571A (en) | A kind of material data duplicate checking method and system based on configurable rule | |
| CN115617776A (en) | Data management system and method | |
| CN109582286A (en) | Data standard method of calibration and its device based on Freemarker technology | |
| CN108199862A (en) | A kind of operation system, which reports an error, manages system and method | |
| CN103473305A (en) | Method and system for performing decision-making process show in statistic analysis | |
| CN109558194A (en) | One-stop universal industry reports visualization tool | |
| CN111125045B (en) | Lightweight ETL processing platform | |
| CN103886448A (en) | Paperless network office system | |
| CN204650522U (en) | A kind of PDM product data management system | |
| CN105373996A (en) | Modeling system based on approval data | |
| CN110782106A (en) | Enterprise business process management system |
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 |