CN109508338A - Data sheet correlating method and device - Google Patents
Data sheet correlating method and device Download PDFInfo
- Publication number
- CN109508338A CN109508338A CN201811405654.7A CN201811405654A CN109508338A CN 109508338 A CN109508338 A CN 109508338A CN 201811405654 A CN201811405654 A CN 201811405654A CN 109508338 A CN109508338 A CN 109508338A
- Authority
- CN
- China
- Prior art keywords
- data
- sheet
- checked
- data sheet
- report
- 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
The embodiment of the present application provides a kind of data sheet correlating method and device, by responding the association request being associated to each database, the corresponding data source of each database is created in memory computing engines according to each wide area information server type, and it is parsed by each data source of the memory computing engines to creation, obtain the corresponding database information of each data source, the data sheet to be checked in each data source is then obtained according to the corresponding database information of each data source, each data sheet to be checked is finally read into progress report association in same region of memory, each data sheet to be checked after generating association.It so, it is possible to carry out different types of data source unified access and correlation inquiry, greatly reduce workload and the operating time of user, improve the efficiency of management.
Description
Technical field
This application involves field of computer technology, in particular to a kind of data sheet correlating method and device.
Background technique
Currently, each data sheet only under same data source can be just associated, needing to different types of
When table data in data source are associated management, since data are from different data sources, for computer equipment
For, it often requires to use the connection client that each data source provides and is individually accessed, be not available a connection to multiple
Data source is carried out while being accessed, and can not be also associated the data in different data sources in primary connection.Therefore, traditional
Access mode, need user successively to compare the data of each data source in their own needs, then manual operation obtain from
The report content that oneself needs, it is not only cumbersome, but also when data volume is very big, bring workload and time cost
It is high.
Summary of the invention
In order to overcome above-mentioned deficiency in the prior art, the application's is designed to provide a kind of data sheet correlating method
And device, to solve or improve the above problem.
To achieve the goals above, the embodiment of the present application the technical solution adopted is as follows:
In a first aspect, the embodiment of the present application provides a kind of data sheet correlating method, it is applied to electronic equipment, the method
Include:
The association request being associated to each database is responded, according to each wide area information server type in memory meter
It calculates in engine and creates the corresponding data source of each database；
It is parsed by each data source of the memory computing engines to creation, obtains the corresponding number of each data source
According to library information；
The data sheet to be checked in each data source is obtained according to the corresponding database information of each data source；
Each data sheet to be checked is read into progress report association in same region of memory, it is each after generating association
A data sheet to be checked.
Optionally, described that each data sheet to be checked is read into progress report association in same region of memory, it is raw
After the step of each data sheet to be checked after association, the method also includes:
The data correlation relation between each data sheet to be checked according to user configuration information, after configuration association；
Data correlation is carried out to each data sheet to be checked according to the data correlation relation of configuration, generates target data
Report.
Optionally, described according to user configuration information, the number between each data sheet to be checked after configuration association
The step of according to incidence relation, comprising:
From being obtained in the user configuration information for needing in each data sheet and other data sheets carry out data
Associated each first data items；
Obtain each first data item in each first data items and other data sheets in each data sheet
There are the second data items of mapping relations between mesh；
According in each data sheet each first data items and the second data items configuration association
The data correlation relation between each data sheet to be checked afterwards.
Optionally, the data correlation relation according to configuration carries out data correlation to each data sheet to be checked,
The step of generating target data report, comprising:
Uniform data report is generated based on second data items, and by the data information under second data items
It injects in the uniform data report；
Data information under first data items each in each data sheet be injected into uniform data report
The corresponding position of data information under second data items, to generate target data report.
Optionally, described to respond the association request being associated to each database, according to each wide area information server
Type creates the step of each database corresponding data source in memory computing engines, comprising:
The association request being associated to each database is responded, detects each wide area information server type, wherein institute
Stating type of database includes EXCEL, Oracle, MySQL, Postgresql, Sybase IQ, Cassandra, HBase, Hive
In at least two；
The corresponding data source of each database is created in memory computing engines according to each wide area information server type.
Second aspect, the embodiment of the present application also provide a kind of data sheet associated apparatus, are applied to electronic equipment, the dress
It sets and includes:
Creation module, for responding the association request being associated to each database, according to the data of each database
Library type creates the corresponding data source of each database in memory computing engines；
Parsing module obtains each for being parsed by each data source of the memory computing engines to creation
The corresponding database information of data source；
Module is obtained, it is to be checked in each data source for being obtained according to the corresponding database information of each data source
Data sheet；
Report relating module, for each data sheet to be checked to be read progress report pass in same region of memory
Connection, each data sheet to be checked after generating association.
The third aspect, the embodiment of the present application also provide a kind of readable storage medium storing program for executing, are stored thereon with computer program, described
Computer program, which is performed, realizes above-mentioned data sheet correlating method.
In terms of existing technologies, the application has the advantages that
The embodiment of the present application provides a kind of data sheet correlating method and device, is closed by response to each database
The association request of connection creates the corresponding number of each database according to each wide area information server type in memory computing engines
It is parsed according to source, and by each data source of the memory computing engines to creation, obtains the corresponding number of each data source
According to library information, the datagram to be checked in each data source is then obtained according to the corresponding database information of each data source
Each data sheet to be checked is finally read progress report association in same region of memory by table, each after generating association
A data sheet to be checked.It so, it is possible to carry out different types of data source unified access and correlation inquiry, greatly reduce
The workload of user and operating time improve the efficiency of management.
Detailed description of the invention
Technical solution in ord to more clearly illustrate embodiments of the present application, below will be to needed in the embodiment attached
Figure is briefly described, it should be understood that the following drawings illustrates only some embodiments of the application, therefore is not construed as pair
The restriction of range for those of ordinary skill in the art without creative efforts, can also be according to this
A little attached drawings obtain other relevant attached drawings.
Fig. 1 is one of the flow diagram of data sheet correlating method provided by the embodiments of the present application；
Fig. 2 is the two of the flow diagram of data sheet correlating method provided by the embodiments of the present application；
Fig. 3 is one of the functional block diagram of data sheet associated apparatus provided by the embodiments of the present application；
Fig. 4 is the two of the functional block diagram of data sheet associated apparatus provided by the embodiments of the present application；
Fig. 5 is that the structure of the electronic equipment provided by the embodiments of the present application for realizing above-mentioned data sheet correlating method is shown
Meaning block diagram.
Specific embodiment
Below in conjunction with the attached drawing in the embodiment of the present application, technical solutions in the embodiments of the present application carries out clear, complete
Site preparation description, it is clear that described embodiment is some embodiments of the present application, instead of all the embodiments.Usually herein
The component of the embodiment of the present application described and illustrated in place's attached drawing can be arranged and be designed with a variety of different configurations.
Therefore, the detailed description of the embodiments herein provided in the accompanying drawings is not intended to limit below claimed
Scope of the present application, but be merely representative of the selected embodiment of the application.Based on the embodiment in the application, this field is common
Technical staff's all other embodiment obtained without creative labor belongs to the application protection
Range.
It should also be noted that similar label and letter indicate similar terms in following attached drawing, therefore, once a certain Xiang Yi
It is defined in a attached drawing, does not then need that it is further defined and explained in subsequent attached drawing.
Referring to Fig. 1, being a kind of flow diagram of data sheet correlating method provided by the embodiments of the present application, should say
Bright, data sheet correlating method provided by the embodiments of the present application is not limitation with Fig. 2 and specific order below.This method
Detailed process it is as follows:
Step S210 responds the association request being associated to each database, according to each wide area information server class
Type creates the corresponding data source of each database in memory computing engines.
In one embodiment, each number can be detected by responding the association request being associated to each database
According to the type of database in library, wherein the type of database can be selected according to actual design demand, such as may include
At least two in EXCEL, Oracle, MySQL, Postgresql, Sybase IQ, Cassandra, HBase, Hive.Then
The corresponding data source of each database is created in memory computing engines according to each wide area information server type.For example, such as
EXCEL, Oracle, MySQL are associated by fruit, then EXCEL, Oracle, MySQL are respectively created in memory computing engines
Corresponding data source.
Step S220 is parsed by each data source of the memory computing engines to creation, obtains each data
The corresponding database information in source.
Step S230 obtains the data to be checked in each data source according to the corresponding database information of each data source
Report.
In the present embodiment, the memory computing engines can be made to find each data source pair by parsing each data source
The database information answered, and find the data sheet of actual queries.
Each data sheet to be checked is read progress report association in same region of memory, generated by step S240
Each data sheet to be checked after association.
In the present embodiment, call memory computing engines read each data sheet to be checked in same region of memory
Report association is carried out, each data sheet to be checked after generating association, each datagram to be checked after being associated at this time
Table can be used a connection and each data sheet to be checked carried out while being accessed, thus by each in different data sources
The data of a data sheet to be checked are associated.It so, it is possible to carry out different types of data source unified access and pass
Joint investigation is ask, and workload and the operating time of user are greatly reduced, and improves the efficiency of management.
Further, referring to Fig. 2, after step S240, the data sheet correlating method can also include such as
Lower step:
Step S250, the data between each data sheet to be checked according to user configuration information, after configuration association
Incidence relation.
In the present embodiment, it can be needed and other numbers from obtaining to be directed in each data sheet in the user configuration information
According to report carry out data correlation each first data items, and obtain each first data items in each data sheet with
There are the second data items of mapping relations between each first data items in other data sheets, finally according to described every
Each number to be checked after each first data items and the second data items configuration association in a data sheet
According to the data correlation relation between report.
Step S260 carries out data correlation to each data sheet to be checked according to the data correlation relation of configuration, raw
At target data report.
In the present embodiment, uniform data report can be generated based on second data items, and by second data
Data information under project injects in the uniform data report, and will be under the first data items each in each data sheet
Data information carries out the corresponding position for the data information being injected under the second data items described in uniform data report, with life
At target data report.
For example, the data sheet B under data source A existing for certain company under data sheet A and data source B, data sheet A are
The order information of each client, data sheet B are the customer information of each client, in order information and customer information with it is each
The Customer ID of client is corresponding.At this point it is possible to need to carry out the first number of data correlation in configuration data report A with data sheet B
It is order information according to project, needs to carry out the first data items of data correlation in data sheet B with data sheet A for client's letter
Breath, and configuring between customer information and order information there are the second data items of mapping relations is Customer ID, it at this time then can be with
Incidence relation based on Customer ID as data sheet A and data sheet B, then by the number under data sheet A and data sheet B
It is believed that breath carries out data correlation, data sheet C is obtained, data sheet C is the customer information of each client and corresponding orders
Single information.And in the prior art, it is unable to intercommunication between the data source A without data correlation and data source B, can only manually grasp
Make, the customer information under the order information and data source B under data source A is subjected to manual association storage.
Further, referring to Fig. 3, the embodiment of the present application also provides a kind of data sheet associated apparatus 200, the datagram
Table associated apparatus 200 may include:
Creation module 210, for responding the association request being associated to each database, according to the number of each database
The corresponding data source of each database is created in memory computing engines according to library type；
Parsing module 220 obtains every for being parsed by each data source of the memory computing engines to creation
The corresponding database information of a data source；
Module 23 is obtained, it is to be checked in each data source for being obtained according to the corresponding database information of each data source
Data sheet；
Report relating module 240 is reported for reading each data sheet to be checked in same region of memory
Table association, each data sheet to be checked after generating association.
Optionally, referring to Fig. 4, described device can also include:
Configuration module 250, for according to user configuration information, between each data sheet to be checked after configuration association
Data correlation relation；
Report generation module 260, for being carried out according to the data correlation relation of configuration to each data sheet to be checked
Data correlation generates target data report.
Optionally, the configuration module 250, specifically can be used for:
From being obtained in the user configuration information for needing in each data sheet and other data sheets carry out data
Associated each first data items；
Obtain each first data item in each first data items and other data sheets in each data sheet
There are the second data items of mapping relations between mesh；
According in each data sheet each first data items and the second data items configuration association
The data correlation relation between each data sheet to be checked afterwards.
Optionally, the report generation module 260, specifically can be used for:
Uniform data report is generated based on second data items, and by the data information under second data items
It injects in the uniform data report；
Data information under first data items each in each data sheet be injected into uniform data report
The corresponding position of data information under second data items, to generate target data report.
Optionally, the creation module 210, specific G are used for:
The association request being associated to each database is responded, detects each wide area information server type, wherein institute
Stating type of database includes EXCEL, Oracle, MySQL, Postgresql, Sybase IQ, Cassandra, HBase, Hive
In at least two；
The corresponding data source of each database is created in memory computing engines according to each wide area information server type.
It is understood that the concrete operation method of each functional module in the present embodiment can refer to above method embodiment
The detailed description of middle corresponding steps, it is no longer repeated herein.
Further, referring to Fig. 5, being the electronics provided by the embodiments of the present application for above-mentioned data sheet correlating method
The structural schematic block diagram of equipment 100.In the present embodiment, the electronic equipment 100 can be made general total wire body by bus 110
Architecture is realized.According to the concrete application of electronic equipment 100 and overall design constraints condition, bus 110 may include any
The interconnection bus and bridge joint of quantity.Together by various circuit connections, these circuits include processor 120, storage Jie to bus 110
Matter 130 and bus interface 140.Optionally, electronic equipment 100 can be used bus interface 140 by network adapter 150 it is equal via
Bus 110 connects.Network adapter 150 can be used for realizing the signal processing function of physical layer in electronic equipment 100, and pass through day
Line realizes sending and receiving for radiofrequency signal.User interface 160 can connect external equipment, such as: keyboard, display, mouse
Or control stick etc..Bus 110 can also connect various other circuits, such as timing source, peripheral equipment, voltage regulator or function
Rate manages circuit etc., these circuits are known in the art, therefore are no longer described in detail.
It can replace, electronic equipment 100 may also be configured to generic processing system, such as be commonly referred to as chip, the general place
Reason system includes: to provide the one or more microprocessors of processing function, and provide at least part of of storage medium 130
External memory, it is all these all to be linked together by external bus architecture and other support circuits.
Alternatively, following realize can be used in electronic equipment 100: having processor 120, bus interface 140, user
The ASIC (specific integrated circuit) of interface 160；And it is integrated at least part of the storage medium 130 in one single chip, or
Following realize can be used in person, electronic equipment 100: one or more FPGA (field programmable gate array), PLD are (programmable
Logical device), controller, state machine, gate logic, discrete hardware components, any other suitable circuit or be able to carry out this
Any combination of the circuit of various functions described in application in the whole text.
Wherein, processor 120 is responsible for management bus 110 and general processing (is stored on storage medium 130 including executing
Software).One or more general processors and/or application specific processor can be used to realize in processor 120.Processor 120
Example includes microprocessor, microcontroller, dsp processor and the other circuits for being able to carry out software.It should be by software broadly
It is construed to indicate instruction, data or any combination thereof, regardless of being called it as software, firmware, middleware, microcode, hard
Part description language or other.
Storage medium 130 is illustrated as separating with processor 120 in Fig. 5, however, those skilled in the art be easy to it is bright
White, storage medium 130 or its arbitrary portion can be located at except electronic equipment 100.For example, storage medium 130 may include
Transmission line, the carrier waveform modulated with data, and/or the computer product that separates with radio node, these media can be with
It is accessed by processor 120 by bus interface 140.Alternatively, storage medium 130 or its arbitrary portion can integrate everywhere
It manages in device 120, for example, it may be cache and/or general register.
Above-described embodiment can be performed in the processor 120, specifically, can store in the storage medium 130 described
Data sheet associated apparatus 200, the processor 120 can be used for executing the data sheet associated apparatus 200.
Further, the embodiment of the present application also provides a kind of nonvolatile computer storage media, the computer is deposited
Storage media is stored with computer executable instructions, which can be performed the number in above-mentioned any means embodiment
According to report correlating method.
In conclusion the embodiment of the present application provides a kind of data sheet correlating method and device, by responding to each number
The association request being associated according to library creates each data according to each wide area information server type in memory computing engines
The corresponding data source in library, and parsed by each data source of the memory computing engines to creation, obtain each data
The corresponding database information in source is then obtained according to the corresponding database information of each data source to be checked in each data source
Data sheet, each data sheet to be checked is finally read into same region of memory progress report association, generates and closes
Each data sheet to be checked after connection.It so, it is possible to carry out different types of data source unified access and correlation inquiry,
Workload and the operating time of user are greatly reduced, the efficiency of management is improved.
In embodiment provided herein, it should be understood that disclosed device and method, it can also be by other
Mode realize.Device and method embodiment described above is only schematical, for example, flow chart and frame in attached drawing
Figure shows the system frame in the cards of the system of multiple embodiments according to the application, method and computer program product
Structure, function and operation.In this regard, each box in flowchart or block diagram can represent a module, section or code
A part, a part of the module, section or code includes one or more for implementing the specified logical function
Executable instruction.It should also be noted that function marked in the box can also be with not in some implementations as replacement
It is same as the sequence marked in attached drawing generation.For example, two continuous boxes can actually be basically executed in parallel, they have
When can also execute in the opposite order, this depends on the function involved.It is also noted that in block diagram and or flow chart
Each box and the box in block diagram and or flow chart combination, can function or movement as defined in executing it is dedicated
Hardware based system realize, or can realize using a combination of dedicated hardware and computer instructions.
In addition, each functional module in each embodiment of the application can integrate one independent portion of formation together
Point, it is also possible to modules individualism, an independent part can also be integrated to form with two or more modules.
It can replace, can be realized wholly or partly by software, hardware, firmware or any combination thereof.When
When using software realization, can entirely or partly it realize in the form of a computer program product.The computer program product
Including one or more computer instructions.It is all or part of when loading on computers and executing the computer program instructions
Ground is generated according to process or function described in the embodiment of the present application.The computer can be general purpose computer, special purpose computer,
Computer network or other programmable devices.The computer instruction may be stored in a computer readable storage medium, or
Person is transmitted from a computer readable storage medium to another computer readable storage medium, for example, the computer instruction
Wired (such as coaxial cable, optical fiber, digital subscriber can be passed through from a web-site, computer, server or data center
Line (DSL)) or wireless (such as infrared, wireless, microwave etc.) mode to another web-site, computer, server or data
It is transmitted at center.The computer readable storage medium can be any usable medium that computer can access and either wrap
The data storage devices such as electronic equipment, server, the data center integrated containing one or more usable mediums.The usable medium
It can be magnetic medium, (for example, floppy disk, hard disk, tape), optical medium (for example, DVD) or semiconductor medium (such as solid-state
Hard disk Solid State Disk (SSD)) etc..
It should be noted that, in this document, term " including ", " including " or its any other variant are intended to non-row
Its property includes, so that the process, method, article or equipment for including a series of elements not only includes those elements, and
And further include the other elements being not explicitly listed, or further include for this process, method, article or equipment institute it is intrinsic
Element.In the absence of more restrictions, the element limited by sentence " including one ... ", it is not excluded that including institute
State in the process, method, article or equipment of element that there is also other identical elements.
It is obvious to a person skilled in the art that the application is not limited to the details of above-mentioned exemplary embodiment, Er Qie
In the case where without departing substantially from spirit herein or essential characteristic, the application can be realized in other specific forms.Therefore, no matter
From the point of view of which point, the present embodiments are to be considered as illustrative and not restrictive, and scope of the present application is by appended power
Benefit requires rather than above description limits, it is intended that all by what is fallen within the meaning and scope of the equivalent elements of the claims
Variation is included in the application.Any reference signs in the claims should not be construed as limiting the involved claims.
Claims (10)
1. a kind of data sheet correlating method, which is characterized in that be applied to electronic equipment, which comprises
The association request being associated to each database is responded, is drawn according to each wide area information server type in memory calculating
Hold up the corresponding data source of the middle each database of creation；
It is parsed by each data source of the memory computing engines to creation, obtains the corresponding database of each data source
Information；
The data sheet to be checked in each data source is obtained according to the corresponding database information of each data source；
Each data sheet to be checked is read into same region of memory progress report association, after generating association it is each to
The data sheet of inquiry.
2. data sheet correlating method according to claim 1, which is characterized in that described by each datagram to be checked
The step of table reads in same region of memory progress report association, each data sheet to be checked after generating association it
Afterwards, the method also includes:
The data correlation relation between each data sheet to be checked according to user configuration information, after configuration association；
Data correlation is carried out to each data sheet to be checked according to the data correlation relation of configuration, generates target data report
Table.
3. data sheet correlating method according to claim 2, which is characterized in that it is described according to user configuration information, match
The step of setting the data correlation relation between each data sheet to be checked after being associated with, comprising:
From being obtained in the user configuration information for needing in each data sheet and other data sheets carry out data correlation
Each first data items；
Obtain each first data items in each data sheet and each first data items in other data sheets it
Between there are the second data items of mapping relations；
According in each data sheet each first data items and the second data items configuration association after
Data correlation relation between each data sheet to be checked.
4. data sheet correlating method according to claim 3, which is characterized in that described to be closed according to the data correlation of configuration
It is the step of carrying out data correlation to each data sheet to be checked, generate target data report, comprising:
Uniform data report is generated based on second data items, and the data information under second data items is injected
In the uniform data report；
Data information under first data items each in each data sheet be injected into described in uniform data report
The corresponding position of data information under second data items, to generate target data report.
5. data sheet correlating method according to claim 1, which is characterized in that the response carries out each database
It is corresponding to create each database according to each wide area information server type in memory computing engines for associated association request
The step of data source, comprising:
The association request being associated to each database is responded, detects each wide area information server type, wherein the number
It include EXCEL, in Oracle, MySQL, Postgresql, Sybase IQ, Cassandra, HBase, Hive according to library type
At least two；
The corresponding data source of each database is created in memory computing engines according to each wide area information server type.
6. a kind of data sheet associated apparatus, which is characterized in that be applied to electronic equipment, described device includes:
Creation module, for responding the association request being associated to each database, according to each wide area information server class
Type creates the corresponding data source of each database in memory computing engines；
Parsing module obtains each data for parsing by each data source of the memory computing engines to creation
The corresponding database information in source；
Module is obtained, for obtaining the data to be checked in each data source according to the corresponding database information of each data source
Report；
Report relating module, for each data sheet to be checked to be read progress report association in same region of memory,
Each data sheet to be checked after generating association.
7. data sheet associated apparatus according to claim 6, which is characterized in that described device further include:
Configuration module, for the data between each data sheet to be checked according to user configuration information, after configuration association
Incidence relation；
Report generation module, for carrying out data pass to each data sheet to be checked according to the data correlation relation of configuration
Connection generates target data report.
8. data sheet associated apparatus according to claim 7, which is characterized in that the configuration module is specifically used for:
From being obtained in the user configuration information for needing in each data sheet and other data sheets carry out data correlation
Each first data items；
Obtain each first data items in each data sheet and each first data items in other data sheets it
Between there are the second data items of mapping relations；
According in each data sheet each first data items and the second data items configuration association after
Data correlation relation between each data sheet to be checked.
9. data sheet associated apparatus according to claim 8, which is characterized in that the report generation module is specific to use
In:
Uniform data report is generated based on second data items, and the data information under second data items is injected
In the uniform data report；
Data information under first data items each in each data sheet be injected into described in uniform data report
The corresponding position of data information under second data items, to generate target data report.
10. data sheet associated apparatus according to claim 6, which is characterized in that the creation module is specifically used for:
The association request being associated to each database is responded, detects each wide area information server type, wherein the number
It include EXCEL, in Oracle, MySQL, Postgresql, Sybase IQ, Cassandra, HBase, Hive according to library type
At least two；
The corresponding data source of each database is created in memory computing engines according to each wide area information server type.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811405654.7A CN109508338A (en) | 2018-11-23 | 2018-11-23 | Data sheet correlating method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811405654.7A CN109508338A (en) | 2018-11-23 | 2018-11-23 | Data sheet correlating method and device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN109508338A true CN109508338A (en) | 2019-03-22 |
Family
ID=65750048
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811405654.7A Pending CN109508338A (en) | 2018-11-23 | 2018-11-23 | Data sheet correlating method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109508338A (en) |
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110489442A (en) * | 2019-08-22 | 2019-11-22 | 行吟信息科技（上海）有限公司 | A kind of data query method and system |
| CN111026759A (en) * | 2019-12-11 | 2020-04-17 | 中盈优创资讯科技有限公司 | Hbase-based report generation method and device |
| CN111552712A (en) * | 2020-04-30 | 2020-08-18 | 中国平安财产保险股份有限公司 | Report data extraction method and device and computer equipment |
| CN111752956A (en) * | 2019-03-26 | 2020-10-09 | 华为技术有限公司 | Entity association change method and device and electronic equipment |
| CN113268481A (en) * | 2021-03-19 | 2021-08-17 | 广州天越电子科技有限公司 | Method for realizing custom association of report data |
| CN113722324A (en) * | 2021-08-30 | 2021-11-30 | 平安国际智慧城市科技股份有限公司 | Report generation method and device based on artificial intelligence, electronic equipment and medium |
| CN113722353A (en) * | 2021-08-31 | 2021-11-30 | 平安国际智慧城市科技股份有限公司 | Multi-source data query method, device, equipment and computer readable storage medium |
| CN114064716A (en) * | 2021-10-29 | 2022-02-18 | 北京市农林科学院信息技术研究中心 | Metadata-based WEB report automatic generation method and device |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20070282804A1 (en) * | 2006-05-31 | 2007-12-06 | Business Objects, S.A. | Apparatus and method for extracting database information from a report |
| CN106528750A (en) * | 2016-10-28 | 2017-03-22 | 无锡雅座在线科技发展有限公司 | Data extracting method and device |
| CN106997393A (en) * | 2017-04-10 | 2017-08-01 | 深圳乐信软件技术有限公司 | Data query method, device, server and storage medium |
| CN107480252A (en) * | 2017-08-14 | 2017-12-15 | 浪潮软件股份有限公司 | A kind of data query method, client, service end and system |
| CN107748752A (en) * | 2017-09-05 | 2018-03-02 | 新智云数据服务有限公司 | A kind of data processing method and device |
| CN108733724A (en) * | 2017-04-24 | 2018-11-02 | 北京京东尚科信息技术有限公司 | One kind is across the real-time connection method of heterogeneous data source and device |
-
2018
- 2018-11-23 CN CN201811405654.7A patent/CN109508338A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20070282804A1 (en) * | 2006-05-31 | 2007-12-06 | Business Objects, S.A. | Apparatus and method for extracting database information from a report |
| CN106528750A (en) * | 2016-10-28 | 2017-03-22 | 无锡雅座在线科技发展有限公司 | Data extracting method and device |
| CN106997393A (en) * | 2017-04-10 | 2017-08-01 | 深圳乐信软件技术有限公司 | Data query method, device, server and storage medium |
| CN108733724A (en) * | 2017-04-24 | 2018-11-02 | 北京京东尚科信息技术有限公司 | One kind is across the real-time connection method of heterogeneous data source and device |
| CN107480252A (en) * | 2017-08-14 | 2017-12-15 | 浪潮软件股份有限公司 | A kind of data query method, client, service end and system |
| CN107748752A (en) * | 2017-09-05 | 2018-03-02 | 新智云数据服务有限公司 | A kind of data processing method and device |
Cited By (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111752956A (en) * | 2019-03-26 | 2020-10-09 | 华为技术有限公司 | Entity association change method and device and electronic equipment |
| CN111752956B (en) * | 2019-03-26 | 2023-12-08 | 华为技术有限公司 | Entity association change method and device and electronic equipment |
| CN110489442A (en) * | 2019-08-22 | 2019-11-22 | 行吟信息科技（上海）有限公司 | A kind of data query method and system |
| CN111026759A (en) * | 2019-12-11 | 2020-04-17 | 中盈优创资讯科技有限公司 | Hbase-based report generation method and device |
| CN111026759B (en) * | 2019-12-11 | 2024-03-12 | 中盈优创资讯科技有限公司 | Report generation method and device based on Hbase |
| CN111552712A (en) * | 2020-04-30 | 2020-08-18 | 中国平安财产保险股份有限公司 | Report data extraction method and device and computer equipment |
| CN113268481A (en) * | 2021-03-19 | 2021-08-17 | 广州天越电子科技有限公司 | Method for realizing custom association of report data |
| CN113722324A (en) * | 2021-08-30 | 2021-11-30 | 平安国际智慧城市科技股份有限公司 | Report generation method and device based on artificial intelligence, electronic equipment and medium |
| CN113722324B (en) * | 2021-08-30 | 2023-08-18 | 深圳平安智慧医健科技有限公司 | Report generation method and device based on artificial intelligence, electronic equipment and medium |
| CN113722353A (en) * | 2021-08-31 | 2021-11-30 | 平安国际智慧城市科技股份有限公司 | Multi-source data query method, device, equipment and computer readable storage medium |
| CN114064716A (en) * | 2021-10-29 | 2022-02-18 | 北京市农林科学院信息技术研究中心 | Metadata-based WEB report automatic generation method and device |
| CN114064716B (en) * | 2021-10-29 | 2023-10-20 | 北京市农林科学院信息技术研究中心 | Metadata-based automatic WEB report generation method and device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109508338A (en) | Data sheet correlating method and device | |
| CN108536761B (en) | Report data query method and server | |
| US10318551B2 (en) | Reporting and summarizing metrics in sparse relationships on an OLTP database | |
| US9460188B2 (en) | Data warehouse compatibility | |
| US20200137162A1 (en) | Cloud resource provisioning using blueprint chaining | |
| CN109766097A (en) | UI generation method, device, electronic equipment and computer readable storage medium | |
| US8577848B2 (en) | Converting two-tier resource mapping to one-tier resource mapping | |
| CN108595316A (en) | Life cycle management method, manager, equipment and the medium of Distributed Application | |
| US20130046798A1 (en) | Method and apparatus for visualization of infrastructure using a non-relational graph data store | |
| US20140379632A1 (en) | Smarter big data processing using collaborative map reduce frameworks | |
| CN114049927A (en) | Disease data processing method and device, electronic equipment and readable medium | |
| CN109656986A (en) | A kind of householder method that business datum summarizes, device and electronic equipment | |
| US20170140032A1 (en) | Method & apparatus for asynchroinzed de-serialization of e-r model in a huge data trunk | |
| US20170286471A1 (en) | Methods and apparatuses for enterprise revision-based auditing of database management systems | |
| CN109522332A (en) | Customer profile data merging method, device, equipment and readable storage medium storing program for executing | |
| CN109711190A (en) | Tables of data batch authorization method and device | |
| EP2965492A1 (en) | Selection of data storage settings for an application | |
| CN109614088A (en) | Form component generation method and device | |
| CN108509529A (en) | Data page sort method, device and readable storage medium storing program for executing | |
| CN108304591A (en) | A kind of method for customizing of label, system and terminal device | |
| CN109543169A (en) | Report processing method and device | |
| CN105045918A (en) | Mutual comparison device for any tables of two databases and mutual comparison method of for any tables of two databases | |
| CN110472127A (en) | A kind of data query method and system | |
| CN107832347B (en) | Data dimension reduction method and system and electronic equipment | |
| US11609924B2 (en) | Database query execution on multiple databases |
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 | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20190322 |