CN107609076A - A kind of Report Customization method and apparatus based on database data - Google Patents
A kind of Report Customization method and apparatus based on database data Download PDFInfo
- Publication number
- CN107609076A CN107609076A CN201710784978.5A CN201710784978A CN107609076A CN 107609076 A CN107609076 A CN 107609076A CN 201710784978 A CN201710784978 A CN 201710784978A CN 107609076 A CN107609076 A CN 107609076A
- Authority
- CN
- China
- Prior art keywords
- data
- database
- read
- report
- template
- 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
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Include the invention discloses a kind of Report Customization method and apparatus based on database data, the step of this method：Database information to be read is configured, database is established and reads passage；Required according to default digital independent, define statement form, and form report form template；Data in specified timing node reads corresponding list item from database, and be added in corresponding report form template.By means of the invention it is possible to which automatic obtain specifies data from database, report tableau format is defined using the form of coordinate, reading speed is fast, and analysis is accurate, improves Report Customization efficiency, reduces the duplication of labour.
Description
Technical field
The present invention relates to database technical field, more particularly to a kind of Report Customization method based on database data and
Device.
Background technology
At present, data analysis has turned into action necessary to big conglomerate, by analyzing substantial amounts of data, determines future
Developments.But the means of data analysis at present also rest on and manually collect, count and calculate analysis, in face of huge
Data volume is, it is necessary to consume substantial amounts of manpower and financial resources.
These information data substantial amounts, data structure is complicated, and workload when collection is arranged and calculated is huge, in the time
In the case of short, task urgency, data statistics work often takes most manpower and time, while manual calculation is easily made
It is inaccurate into analysis, influence the fairness and science of data analysis.In the prior art, by connecting database, from number
According to storehouse import needed for data analyzed, but the often total data in database table entry being introduced into, it is desired nonetheless to spend
Great effort carries out manual analysis.
The content of the invention
The present invention solves the technical problem of providing a kind of Report Customization method and apparatus based on database data,
It can automatically be obtained from database and specify data, report tableau format is defined using the form of coordinate, reading speed is fast, analysis
Accurately, Report Customization efficiency is improved, reduces the duplication of labour.
To solve technical problem, one aspect of the present invention is：A kind of report based on database data is provided
Table method for customizing, include the step of this method：Database information to be read is configured, database is established and reads passage；According to pre-
If digital independent requirement, define statement form, and form report form template；Phase is read from database in specified timing node
The data in list item are answered, and are added in corresponding report form template.
To solve technical problem, one aspect of the present invention is：A kind of report based on database data is provided
Table customizing device, including：Configuration module, for configuring database information to be read, establish database and read passage；Define mould
Block, for being required according to default digital independent, statement form is defined, and form report form template；Read module, for specifying
Timing node data in corresponding list item are read from database, and in report form template corresponding to being added to.
It is different from prior art, includes the step of Report Customization method of the invention based on database data：Configuration is treated
The database information of reading, establish database and read passage；Required according to default digital independent, define statement form, and shape
Into report form template；Data in specified timing node reads corresponding list item from database, and it is added to corresponding form
In template.By means of the invention it is possible to which automatic obtain specifies data from database, the lattice of form are defined using the form of coordinate
Formula, reading speed is fast, and analysis is accurate, improves Report Customization efficiency, reduces the duplication of labour.
Brief description of the drawings
Fig. 1 is a kind of schematic flow sheet of Report Customization method based on database data provided by the invention；
Fig. 2 is that configuration connects showing for database in a kind of Report Customization method based on database data provided by the invention
Expectation；
Fig. 3 is the time that data are read in configuration in a kind of Report Customization method based on database data provided by the invention
The signal table of information；
Fig. 4 is the control interface that data are read in a kind of Report Customization method based on database data provided by the invention
Schematic diagram.
Embodiment
Many details are elaborated in the following description in order to fully understand the present invention.But the present invention can be with
Much it is different from other manner described here to implement, those skilled in the art can be in the situation without prejudice to intension of the present invention
Under do similar popularization, therefore the present invention is not limited to the specific embodiments disclosed below.
Secondly, the present invention is described in detail using schematic diagram, when the embodiment of the present invention is described in detail, for purposes of illustration only, institute
It is example to state schematic diagram, and it should not limit the scope of protection of the invention herein.
With enterprise system constantly improve, particularly Utilities Electric Co., its internal all departments report making demand is more and more,
It is related to a large amount of basic datas, including continuous data, substation data, transmission line of electricity data, distribution data, EMS system data
Deng, diversification database data form, manually customization will expend a large amount of manpower and materials, and many duplications of labour, get half the result with twice the effort, be
Solution basic data obtains, the problem of report customization, backstage acquisition multivariate data storehouse (including metering, transformer station, transmission line of electricity
According to databases such as, distribution, EMS systems), automatic customization generation form.After software is installed, can quickly it be obtained in intra-office office computer
Report data is taken, a pair of multi-modes are converted into by one-to-one pattern, improve Report Customization efficiency, reduce the duplication of labour.
Refering to Fig. 1, Fig. 1 is a kind of flow signal of Report Customization method based on database data provided by the invention
Figure.The step of this method, includes：
S110：Database information to be read is configured, database is established and reads passage.
The database of reading data is determined first.Enterprises are provided with multiple different databases, to store difference
The data of type.And during certain report customization of reality, be actually subjected to read is probably one of them or a few numbers
According to a or several part of list item in storehouse, and the data read are also likely to be the finger in whole list item, or one or more list items
Determine the data of ranks.Therefore, before report customization, it is necessary first to it is determined that reading the database of data.Need are customized according to enterprise
Ask, only can obtain data from a certain list item of a certain database, can also be obtained from multiple list items of a certain database
Data, data can also be obtained from multiple list items of multiple databases.When obtaining data from a database, it is necessary to set
Put associated databases information.
During configuration database, the link information of configuration database first.Specific link information comprises at least database
IP address, SID, port numbers, username and password, after above- mentioned information is provided with, you can be connected to corresponding database.If
It is as shown in Figure 2 to put mode.When needing to obtain data from multiple databases, multiple connected modes as shown in Figure 2 need to be configured, point
The IP address of database, SID, port numbers, username and password Dui Ying not filled in.Meanwhile when also needing the exclusive rights of configuration database
Between information.Read access time information comprises at least time started and end time.The configuration of temporal information is as shown in Figure 3.Configure
Cheng Hou, you can be connected to database and carry out digital independent.
S120：Required according to default digital independent, define statement form, and form report form template.
After the connection of database is provided with, also need to define statement form.In the present invention, by specified database
Specific data position, also need to set the deposit position of the data read, i.e. form.In the present embodiment, form leads to
Often it is excel forms, by setting gauge outfit, table name and domain name in excel forms, is realized by software by the finger in database
Determine the specified location in the data transfer to form of type.Form is formed after importing data to form.If subsequently there is phase
With the form of demand, then by the report generation report form template, and stored., can subsequently when making the form of same type
Directly import data in the report form template.
The template name and template file title of form are set first, form is set as template, subsequently can be used directly
Template, import data in report form template.The report data requirement gathered as needed, define domain name and table name, wherein table
Name and domain name are the titles of the first row and first row in any list item of database, specifically, the use stored in such as database
Family list, its table name are the user basic informations such as user's name, and domain name is user's sequence number.By limiting table name and domain name,
The data of the particular location in list item can accurately be specified.By specifying table name and domain name, you can obtain accurate corresponding data.
Additionally want reading database list item title, the time interval of data acquisition and read data rising in the table entry
Beginning position and final position.Meanwhile also need to set data processing method, data processing method is comprised at least to specified time interval
The data of interior reading carry out taking maximin or average value.
S130：Data in specified timing node reads corresponding list item from database, and it is added to corresponding report
In table template.
By Microsoft Visual Basic 6.0, the programming software such as matlab2014a, can be achieved in database
Specified data imported into according to abovementioned steps in the Excel forms specified.An interface is provided, the interface may be disposed at Excel
In form, linking between button and corresponding operating is set, can such as set timing information, implementation status etc. is consulted, such as Fig. 4 institutes
Show.
With reference to Microsoft excel form friendliness interface reporting systems, the data of database are directly read,
Only need the label (table name, domain name) in interpolation data storehouse, it is possible to the easily desired data of export.
This method supports multitype database, such as：Oracle、Sybase、MS SQL Server、DB2、MySQL、MS
Access etc..
Large-scale data in enterprise, the data volume of thousands of bars is often had in single form, is checked line by line
Data are unrealistic and taken very much, and the data of different types of user care or the angle of analyze data are also different,
Therefore user's selection each qualified data are helped by data filtering and screening, largely data is browsed so as to save
Time, avoid some useless work.Process provides wall scroll part, combination condition, concatenation condition and hazy condition to form
In data carry out filtering screening.
This method provides diversified data interaction formula analysis ability for decision-making level's form, and policymaker can not only a mesh
The analysis business development trend being clear, moreover it is possible to report data is operated in a manner of interactive, carries out deep, thorough business diagnosis.
Conventional interactive mode includes：Data mining, in-depth, sequence, URL redirect, the linkage of chart form, dynamic table, file catalogue
Deng.Assisted without any IT, form can be completed and create and distribute work, completing Report layouts with intuitively pulling mode sets
Meter, without grasping the ins and outs such as SQL, meets many-sided demand such as data mining, printing and export, is easy to design professional
Report layouts.
It is different from prior art, includes the step of Report Customization method of the invention based on database data：Configuration is treated
The database information of reading, establish database and read passage；Required according to default digital independent, define statement form, and shape
Into report form template；Data in specified timing node reads corresponding list item from database, and it is added to corresponding form
In template.By means of the invention it is possible to which automatic obtain specifies data from database, the lattice of form are defined using the form of coordinate
Formula, reading speed is fast, and analysis is accurate, improves Report Customization efficiency, reduces the duplication of labour.
In addition, present invention also offers a kind of Report Customization device based on database data.The device includes：
Configuration module, for configuring database information to be read, establish database and read passage.
Configuration module includes database dispensing unit and read access time dispensing unit.Wherein, database configuration of described dispensing unit
The link information of database.Specific link information comprises at least the IP address of database, SID, port numbers, user name and close
Code, after above- mentioned information is provided with, you can be connected to corresponding database.Set-up mode is as shown in Figure 2.When needing from multiple
Database obtain data when, multiple connected modes as shown in Figure 2 need to be configured, respectively correspond to fill in database IP address,
SID, port numbers, username and password.Meanwhile read access time dispensing unit is used for the exclusive rights temporal information of configuration database.Read
Temporal information is taken to comprise at least time started and end time.The configuration of temporal information is as shown in Figure 3.After the completion of configuration, you can
It is connected to database and carries out digital independent.
In addition, configuration module also includes data processing method setting unit, for setting data processing method, wherein, number
Comprised at least according to processing mode and the data read in specified time interval are carried out taking maximin or average value.The configuration
Module be additionally operable to set whether timing read data, and timing read data at the beginning of between and the end time.
Definition module, for being required according to default digital independent, statement form is defined, and form report form template.
Definition module includes template definition unit and list item definition unit.
List item definition unit also needs to set depositing for the data read by the specific data position in specified database
Put position, i.e. form.In the present embodiment, form is excel forms, by set the gauge outfit in excel forms, table name and
Domain name, realized by software by the specified location in the data transfer of the specified type in database to form.Import data to
Form is formed after to form.If subsequently there is the form of same requirements, by the report generation report form template, and deposited
Storage.Subsequently when making the form of same type, can directly it import data in the report form template.
Template definition unit sets the template name and template file title of form, and form is set as into template, subsequently may be used
Template is directly used, is imported data in report form template.The report data requirement gathered as needed, define domain name and table
Name, wherein table name and domain name are the titles of the first row and first row in any list item of database, specifically, in such as database
The user list of storage, its table name are the user basic informations such as user's name, and domain name is user's sequence number.By limiting table name
And domain name, you can the data of the particular location in accurate specified list item.By specifying table name and domain name, you can obtain accurate corresponding
Data.
Read module, for the data during corresponding list item is read from database in specified timing node, and it is added to
In corresponding report form template.
Read module the programming software such as matlab2014a, is realized number by Microsoft Visual Basic 6.0
It is imported into according to the specified data in storehouse in the Excel forms specified.One interface is provided, the interface may be disposed in Excel forms,
Linking between setting button and corresponding operating, timing information can be such as set, consult implementation status etc., as shown in Figure 4.
With reference to Microsoft excel form friendliness interface reporting systems, the data of database are directly read,
Only need the label (table name, domain name) in interpolation data storehouse, it is possible to the easily desired data of export.
Prior art is different from, the Report Customization device of the invention based on database data includes：Configuration module, it is used for
Database information to be read is configured, database is established and reads passage；Definition module, for being wanted according to default digital independent
Ask, define statement form, and form report form template；Read module, for reading phase from database in specified timing node
The data in list item are answered, and are added in corresponding report form template.By means of the invention it is possible to automatic obtain is specified from database
Data, report tableau format is defined using the form of coordinate, reading speed is fast, and analysis is accurate, improves Report Customization efficiency, reduces
The duplication of labour.
Although the present invention is disclosed as above with preferred embodiment, it is not for limiting the present invention, any this area
Technical staff without departing from the spirit and scope of the present invention, may be by the methods and technical content of the announcement to this hair
Bright technical scheme makes possible variation and modification, therefore, every content without departing from technical solution of the present invention, according to the present invention
Any simple modifications, equivalents, and modifications made to above example of technical spirit, belong to technical solution of the present invention
Protection domain.
Claims (10)
- A kind of 1. Report Customization method based on database data, it is characterised in that including：Configure database letter to be read Breath, establish database and read passage；Required according to default digital independent, define statement form, and form report form template；In specified timing node from data The data in corresponding list item are read in storehouse, and are added in corresponding report form template.
- 2. the Report Customization method according to claim 1 based on database data, it is characterised in that to be read configuring Database information the step of in, including step：The link information of configuration database；Wherein, the link information comprises at least IP address, SID, port numbers, username and password；The read access time information of configuration database data；Wherein, the read access time information comprises at least time started and end Time.
- 3. the Report Customization method according to claim 1 based on database data, it is characterised in that defining form lattice In the step of formula, including step：The template file title of form, template name are set；The database table entry title read is set, between the time of data acquisition Every and read data original position in the table entry and final position.
- 4. the Report Customization method according to claim 3 based on database data, it is characterised in that data processing is set Mode, wherein, the data processing method comprises at least to carry out taking maximin to the data read in specified time interval Or average value.
- 5. the Report Customization method according to claim 3 based on database data, it is characterised in that whether regularly to set Read data, and set timing read data at the beginning of between and the end time.
- A kind of 6. Report Customization device based on database data, it is characterised in that including：Configuration module, for configuring database information to be read, establish database and read passage；Definition module, for basis Default digital independent requirement, defines statement form, and form report form template；Read module, in specified timing node The data in corresponding list item are read from database, and are added in corresponding report form template.
- 7. the Report Customization device according to claim 6 based on database data, it is characterised in that the configuration module Including：Database dispensing unit, the link information for configuration database；Wherein, the link information comprise at least IP address, SID, port numbers, username and password；Read access time dispensing unit, the read access time information for configuration database data；Wherein, the read access time information is extremely Include time started and end time less.
- 8. the Report Customization device according to claim 6 based on database data, it is characterised in that the definition module Including：Template definition unit, for setting the template file title of form, template name；List item definition unit, for setting the database table entry title read, the time interval and reading data of data acquisition Original position in the table entry and final position.
- 9. the Report Customization device according to claim 8 based on database data, it is characterised in that the configuration module Also include：Data processing method setting unit, for setting data processing method, wherein, the data processing method comprise at least pair The data read in specified time interval carry out taking maximin or average value.
- 10. the Report Customization device according to claim 8 based on database data, it is characterised in that the configuration mould Block be additionally operable to set whether timing read data, and timing read data at the beginning of between and the end time.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710784978.5A CN107609076A (en) | 2017-08-29 | 2017-08-29 | A kind of Report Customization method and apparatus based on database data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710784978.5A CN107609076A (en) | 2017-08-29 | 2017-08-29 | A kind of Report Customization method and apparatus based on database data |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN107609076A true CN107609076A (en) | 2018-01-19 |
Family
ID=61057335
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710784978.5A Pending CN107609076A (en) | 2017-08-29 | 2017-08-29 | A kind of Report Customization method and apparatus based on database data |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107609076A (en) |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101908040A (en) * | 2010-07-01 | 2010-12-08 | 千乡万才科技(中国)有限公司 | Data report system |
| CN102368261A (en) * | 2011-10-14 | 2012-03-07 | 成都勤智数码科技有限公司 | Expandable running maintenance report generation method |
| US20120089562A1 (en) * | 2010-10-04 | 2012-04-12 | Sempras Software, Inc. | Methods and Apparatus for Integrated Management of Structured Data From Various Sources and Having Various Formats |
| CN104866599A (en) * | 2015-06-01 | 2015-08-26 | 北京京东尚科信息技术有限公司 | Production method and system of visual report |
-
2017
- 2017-08-29 CN CN201710784978.5A patent/CN107609076A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101908040A (en) * | 2010-07-01 | 2010-12-08 | 千乡万才科技(中国)有限公司 | Data report system |
| US20120089562A1 (en) * | 2010-10-04 | 2012-04-12 | Sempras Software, Inc. | Methods and Apparatus for Integrated Management of Structured Data From Various Sources and Having Various Formats |
| CN102368261A (en) * | 2011-10-14 | 2012-03-07 | 成都勤智数码科技有限公司 | Expandable running maintenance report generation method |
| CN104866599A (en) * | 2015-06-01 | 2015-08-26 | 北京京东尚科信息技术有限公司 | Production method and system of visual report |
Non-Patent Citations (1)
| Title |
|---|
| 胡佐等: "基于模板技术的智能报表系统的设计与实现", 《电力信息化》 * |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US8086955B2 (en) | Methods and apparatus for modifying process control data | |
| CN110399420A (en) | A kind of deriving method, electronic equipment and the medium of configurableization Excel format | |
| CN104407576A (en) | Realization method for general type production and manufacturing unit and control system thereof | |
| CN104123227A (en) | Method for automatically generating testing cases | |
| CN109254901B (en) | A kind of Monitoring Indexes method and system | |
| CN102279848A (en) | Method and device for generating report template | |
| CN112463151B (en) | Visual page construction method based on data source | |
| CN108564336A (en) | The identification of power transformation installing engineering construction drawing drawing and budgetary technique and system | |
| CN102270261A (en) | Design method for intelligent transformer station model based on CAD (Computer-Aided Design) graph and model integration | |
| CN103927185A (en) | Network topology modeling device based on energy management and guiding method thereof | |
| CN113642299A (en) | One-key generation method based on power grid statistical form | |
| CN108170855B (en) | CityGML and IFC data unified query and data extraction method | |
| CN107067161B (en) | Automatic checking implementation system and method for information point table in smart power grid | |
| CN109408494B (en) | Model production record generation method based on form self-defining function | |
| CN105305619B (en) | A kind of three distant collocation methods and device based on power distribution automation | |
| CN114513410A (en) | Method and system for equipment to rapidly access Internet of things platform | |
| CN110188434A (en) | A kind of framework method of Distribution system design platform | |
| CN109472015A (en) | Model production resume based on Worksheet self-defining function generate system | |
| CN109656997A (en) | Industry internet big data service platform system and method for servicing | |
| CN111401023B (en) | Report generation method, report generation device, server and storage medium | |
| CN107609076A (en) | A kind of Report Customization method and apparatus based on database data | |
| CN115599382A (en) | Automatic Sar architecture based code automatic generation tool and method | |
| CN113407172B (en) | Distribution cloud master station-based automatic platform area graph display system and method | |
| CN103809973A (en) | Graphic control interface design system and graphic control interface design operation method thereof | |
| CN112884349A (en) | Stock technical index display method, device and system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20180119 |
|
| WD01 | Invention patent application deemed withdrawn after publication |