CN112527868A - Data acquisition method, device, equipment and storage medium - Google Patents
Data acquisition method, device, equipment and storage medium Download PDFInfo
- Publication number
- CN112527868A CN112527868A CN202011541100.7A CN202011541100A CN112527868A CN 112527868 A CN112527868 A CN 112527868A CN 202011541100 A CN202011541100 A CN 202011541100A CN 112527868 A CN112527868 A CN 112527868A
- Authority
- CN
- China
- Prior art keywords
- data
- condition
- linkage
- component
- operation 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.)
- Pending
Links
- 238000003860 storage Methods 0.000 title claims abstract description 38
- 238000000034 method Methods 0.000 title claims abstract description 35
- 238000012216 screening Methods 0.000 claims abstract description 33
- 238000004590 computer program Methods 0.000 claims description 10
- 230000003993 interaction Effects 0.000 abstract description 8
- 238000001914 filtration Methods 0.000 description 48
- 238000005553 drilling Methods 0.000 description 15
- 238000010586 diagram Methods 0.000 description 10
- 230000006870 function Effects 0.000 description 10
- 230000007246 mechanism Effects 0.000 description 10
- 238000013515 script Methods 0.000 description 9
- 230000003287 optical effect Effects 0.000 description 8
- 230000001960 triggered effect Effects 0.000 description 7
- 230000009471 action Effects 0.000 description 6
- 238000012545 processing Methods 0.000 description 6
- 238000004458 analytical method Methods 0.000 description 5
- 238000004891 communication Methods 0.000 description 4
- 230000010354 integration Effects 0.000 description 4
- 230000006399 behavior Effects 0.000 description 3
- 238000013461 design Methods 0.000 description 3
- 238000011161 development Methods 0.000 description 3
- 230000002452 interceptive effect Effects 0.000 description 3
- 238000005065 mining Methods 0.000 description 3
- 239000013307 optical fiber Substances 0.000 description 3
- 238000003491 array Methods 0.000 description 2
- 238000012937 correction Methods 0.000 description 2
- 238000007405 data analysis Methods 0.000 description 2
- 230000000694 effects Effects 0.000 description 2
- 230000002093 peripheral effect Effects 0.000 description 2
- 230000000644 propagated effect Effects 0.000 description 2
- 239000004065 semiconductor Substances 0.000 description 2
- 238000013519 translation Methods 0.000 description 2
- 101150064138 MAP1 gene Proteins 0.000 description 1
- 241001074085 Scophthalmus aquosus Species 0.000 description 1
- 230000000712 assembly Effects 0.000 description 1
- 238000000429 assembly Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000013480 data collection Methods 0.000 description 1
- 238000007418 data mining Methods 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 230000035515 penetration Effects 0.000 description 1
- 238000002360 preparation method Methods 0.000 description 1
- 230000008707 rearrangement Effects 0.000 description 1
- 238000012163 sequencing technique Methods 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 238000012546 transfer Methods 0.000 description 1
Images
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/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2465—Query processing support for facilitating data mining operations in structured databases
-
- 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/24552—Database cache management
-
- 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
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F2216/00—Indexing scheme relating to additional aspects of information retrieval not explicitly covered by G06F16/00 and subgroups
- G06F2216/03—Data mining
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Computational Linguistics (AREA)
- Fuzzy Systems (AREA)
- Mathematical Physics (AREA)
- Probability & Statistics with Applications (AREA)
- Software Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a data acquisition method, a data acquisition device, data acquisition equipment and a storage medium. The method comprises the following steps: acquiring operation information input by a user; if the data linkage triggering condition is determined according to the operation information, determining a single condition or a combined condition of data linkage according to the operation information; generating a target data screening statement according to the relevant fields corresponding to the single condition or the combined condition; according to the technical scheme, the target data can be obtained from the cache region according to the target data screening statement, the data of a data page module can be provided for a data reader from a plurality of angles by data intelligent linkage, the data can be provided for richer data information by a data page module, the bottom layer logic configuration storage function of data retrieval page interaction can be realized through a set of flexible and universal data intelligent linkage interaction technical framework, the method can be applied to various complex interaction configuration scenes, the page interaction function of various front ends is realized, and different page experiences of a user are met.
Description
Technical Field
The embodiment of the invention relates to the technical field of computer processing, in particular to a data acquisition method, a data acquisition device, data acquisition equipment and a storage medium.
Background
In recent years, the economic development of China is rapid, and each enterprise and public institution generates a large amount of available data, wherein the data comprises the most basic data and the sorted statistical data. Through the data analysis, a decision maker can know the operation state of the current enterprise and adjust the found problems.
It is understood that most small and medium-sized enterprises are not fully aware of the importance of the data at present, and deep analysis is not performed on the collected data. Some enterprises that have started to pay attention to the availability of data are only aware of the importance of data for which there is no specific solution to how to show. For the data, some enterprises directly customize the data into a plurality of fixed visible reports through a software company. However, for decision makers of enterprises, their needs are changed, today, the decision makers may want to see the pipeline state of a company, tomorrow, the performance of a specific salesman, and the like, and it is difficult for the software company to quickly generate corresponding reports, and the software company needs to spend time knowing the business conditions and make corresponding reports according to the actual needs. Not only is expensive and has long cycle time, but also can not completely meet the requirements.
The user-defined report query condition, because the interface components of the input condition are arranged and defined by the user, and the linkage logic between the components is also defined by the user, the traditional report design logic can not be applied to the linkage logic design of the user-defined report condition.
Disclosure of Invention
Embodiments of the present invention provide a data acquisition method, an apparatus, a device, and a storage medium, so as to implement data mining analysis from multiple angles through data intelligent linkage, and provide richer data information to a data reader from a data page module, and implement a bottom-layer logic configuration storage function of data retrieval page interaction through a set of flexible and general data intelligent linkage interaction technical framework, and can be applied to various complex interaction configuration scenarios, implement various front-end page interaction functions, and meet different page experiences of a user.
In a first aspect, an embodiment of the present invention provides a data acquisition method, including:
acquiring operation information input by a user;
if the data linkage triggering condition is determined according to the operation information, determining a single condition or a combined condition of data linkage according to the operation information;
generating a target data screening statement according to the relevant fields corresponding to the single condition or the combined condition;
and acquiring target data from a cache region according to the target data screening statement.
In a second aspect, an embodiment of the present invention further provides a data obtaining apparatus, where the apparatus includes:
the first acquisition module is used for acquiring operation information input by a user;
the determining module is used for determining a single condition or a combined condition of data linkage according to the operation information if the condition for triggering the data linkage is determined according to the operation information;
the generating module is used for generating a target data screening statement according to the relevant fields corresponding to the single condition or the combined condition;
and the second acquisition module is used for acquiring the target data from the cache region according to the target data screening statement.
In a third aspect, an embodiment of the present invention further provides a computer device, including a memory, a processor, and a computer program stored on the memory and executable on the processor, where the processor executes the computer program to implement the data acquisition method according to any one of the embodiments of the present invention.
In a fourth aspect, the embodiment of the present invention further provides a computer-readable storage medium, on which a computer program is stored, where the computer program, when executed by a processor, implements the data obtaining method according to any one of the embodiments of the present invention.
The embodiment of the invention obtains the operation information input by the user; if the data linkage triggering condition is determined according to the operation information, determining a single condition or a combined condition of data linkage according to the operation information; generating a target data screening statement according to the relevant fields corresponding to the single condition or the combined condition; the target data are obtained from the cache region according to the target data screening statements, so that data from a data page module can be obtained through intelligent data linkage, and the richer data information can be provided for a data reader from a multi-angle mining analysis.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings needed to be used in the embodiments will be briefly described below, it should be understood that the following drawings only illustrate some embodiments of the present invention and therefore should not be considered as limiting the scope, and for those skilled in the art, other related drawings can be obtained according to the drawings without inventive efforts.
Fig. 1 is a flowchart of a data acquisition method according to a first embodiment of the present invention;
fig. 2 is a schematic structural diagram of a data acquisition apparatus according to a second embodiment of the present invention;
fig. 3 is a schematic structural diagram of a computer device in a third embodiment of the present invention.
Detailed Description
The present invention will be described in further detail with reference to the accompanying drawings and examples. It is to be understood that the specific embodiments described herein are merely illustrative of the invention and are not limiting of the invention. It should be further noted that, for the convenience of description, only some of the structures related to the present invention are shown in the drawings, not all of the structures.
It should be noted that: like reference numbers and letters refer to like items in the following figures, and thus, once an item is defined in one figure, it need not be further defined and explained in subsequent figures. Meanwhile, in the description of the present invention, the terms "first", "second", and the like are used only for distinguishing the description, and are not to be construed as indicating or implying relative importance.
Example one
Fig. 1 is a flowchart of a data obtaining method provided in an embodiment of the present invention, where this embodiment is applicable to a case of obtaining custom report data, and the method may be executed by a data obtaining apparatus in an embodiment of the present invention, where the apparatus may be implemented in a software and/or hardware manner, as shown in fig. 1, the method specifically includes the following steps:
and S110, acquiring the operation information input by the user.
Wherein, the operation information may include: the identification information of the clicked component may also include: the touch behavior of the user on the component may be, for example, a click operation, a double click operation, a gesture, or a voice input, which is not limited in this embodiment of the present invention.
And S120, if the triggering data linkage condition is determined according to the operation information, determining a single condition or a combined condition of data linkage according to the operation information.
The method for determining the trigger data linkage condition according to the operation information may be: presetting at least one target component linked and associated with a single condition and/or a combined condition; acquiring a first component corresponding to the operation information; and if the first component is a target component, acquiring linkage relation and linkage condition information corresponding to the target component.
For example, the manner of determining the single condition or the combined condition of the data linkage according to the operation information may be to set the linkage relationship and the linkage condition between the components by the linkage setting module; through linkage relation and linkage condition between linkage relation storage module memory component and the subassembly, the trigger mechanism of subassembly linkage includes: the linkage condition of single components and among the components and the linkage condition of a plurality of components.
And S130, generating a target data screening statement according to the relevant fields corresponding to the single condition or the combined condition.
The target data screening statement is an SQL statement, for example, the same data screening SQL script statement may be generated by a single condition or a combination condition corresponding to a related field.
And S140, acquiring the target data from the cache region according to the target data screening statement.
Illustratively, after the SQL script corresponding to the data set bound by the linkage component acquires data from the corresponding database, the data is stored in a system cache region or the data bound by the component is directly stored in the system cache region, and the system queries and screens the data in the current cache region through the SQL script statements generated in a unified manner to acquire the data displayed by the component.
Optionally, if the trigger data linkage condition is determined according to the operation information, determining a single condition or a combined condition of data linkage according to the operation information includes:
if the trigger data linkage condition is determined according to the operation information, acquiring linkage relation and linkage condition information corresponding to the operation information;
acquiring a condition linkage component corresponding to the linkage relation and a condition trigger component corresponding to the linkage condition information;
and determining a single condition or a combined condition of data linkage according to the condition triggering component and the condition linkage component.
Optionally, if the trigger data linkage condition is determined according to the operation information, acquiring the linkage relationship and the linkage condition information corresponding to the operation information includes:
setting at least one target component linked and associated by a single condition and/or a combined condition;
acquiring a first component corresponding to the operation information;
and if the first component is a target component, acquiring linkage relation and linkage condition information corresponding to the target component.
Optionally, obtaining the target data from the cache region according to the target data filtering statement includes:
acquiring an initial database statement corresponding to the condition triggering component;
acquiring initial data according to the initial database statement;
storing the initial data to a cache region;
and acquiring target data from the cache region according to the target data screening statement.
Optionally, after obtaining the target data from the cache region according to the target data filtering statement, the method further includes:
and storing the target data in a cache region.
Based on complex data of various different service platforms, various data reports need to be output, in order to save development cost and conveniently serve company data analysis, a user-defined report platform needs to be developed, and report data linkage is realized to be a report with soul.
For example, the data screening may be performed by: data is input through a filtering component of the report page, and a button (or other component for determining filtering) in the page is clicked to filter data of a related data component in the report page.
According to the specific implementation scheme, the components for realizing data filtering linkage at present comprise: the report form filtering system comprises a filtering component 1, a filtering component 2 and a filtering component 3, wherein the filtering component is a component for inputting filtering conditions on a report form page, such as a pull-down data selection component, a text entry component and the like.
Data display component of data linkage: for example bubble figure 1, data list 2.
The components for confirming the screening are button 1, button 2.
Click button 1, bubble figure 1 and data list 1 can be according to filtering component 1, carry out the data screening linkage with the filtering condition that filtering component 2 set up, the user needs to set up the filter of bubble figure 1 and data list 1, set up in the filter that certain data field filters through filtering component 1 in the subassembly, another data field filters through filtering component 2, and can set up more data fields simultaneously and filter through more filtering component conditions, the automatic filtering condition relation that sets up filtering component and data component of system. In the data linkage setting of the button 1, the data linkage of the setting button is influenced by the conditions of the filter assembly 1 and the filter assembly 2, and the influenced data assemblies are the bubble map 1 and the data list 1.
When a user reader refers to a report and needs to filter data, when the filter component 1, the filter component 2 or more filter components input filter conditions, a button is clicked, and the system can only carry out data filtering linkage on the bubble graph 1 and the data list 1 according to a preset filtering relation according to the conditions of the filter component 1 and the filter component 2.
Data drilling-up and drilling-down data linkage implementation: and drilling data, wherein the drilling comprises drilling up and drilling down. Suitable for one-dimensional tables, cross tables and charts. Penetration drilling is only applicable to the graphs.
1. Hierarchical arrangement: when a report is made, a hierarchy needs to be added to a dimension column of a data set, and the dimension column of metadata is dragged into a new hierarchy. The level relation among the data segments is determined by the arrangement sequence of the data dimensions under the hierarchical folder, the level of the data segments arranged above is the highest by default, and the data segments are analogized from bottom to top in sequence, so that the hierarchical relation of the data field time is established. When a user drags one field in the preset hierarchical relationship field into the component, the system automatically associates the fields of the upper and lower hierarchical relationships of the currently dragged field, and then the data can be drilled down and drilled up.
2. Drilling: the data drilling query of the next level can be performed on the data of the current data column, for example, specific data: the enterprise level is 0, A and B, and when drilling down, the enterprise data with the level of 0, A and B is automatically brought in;
the step of drilling down is to automatically add a data column with a level one level lower than the level of the data column, and if the data set has internal rating and different company names exist under the internal rating, the internal rating column is dragged into a data loading area, a one-dimensional table and a cross table, and when a plus sign is clicked in a diagram, data with a level one level lower than the level of the current data column is added in a bound window.
3. Drilling: drilling-up refers to performing automatic association query on the data of the current data column for the data of the previous level, such as specific data: enterprise data with levels 0, a, B, when drilling, data summarization is automatically performed with levels 0, a, B. The drilling-up is to automatically delete the data which is one level lower than the self level.
The self-defined report device provided by the embodiment of the invention comprises: the system comprises a component library storage module, a data source module, a data set module, a report making module and a report access link storage module, wherein the component library storage module: all types of components for the storage platform, such as third-party components or self-developed components, are put into the component library. A data source module: the user stores the data source link information established by the user, such as various databases can be connected. A data set module: the method is used for establishing different data sets according to the business report requirements by a storage user, wherein the data sets are obtained from various data sources and are associated or converted to a certain degree (the data sets can be obtained through a user-defined SQL script). A report making module: the method is used for storing all data sets and components for making reports and the association relationship among the data sets and the components. The report access link storage module: and the access link is used for storing the generated report.
The self-defined report device provided by the embodiment of the invention can also comprise: a relationship establishing module: the method is used for analyzing data to generate the relationship between the page and the component, and establishing the association relationship between the component and the data set field, the association relationship between the component and the component, the association relationship between the component, the data and the condition, and the like. A relationship judgment module: and when the front-end interactive operation trigger mechanism is received, the system judges and calls the corresponding relation model by trigger logic. The information display module: and carrying out interactive display on the front-end page data according to the operated interactive mechanism and the triggered relation model.
In one example, the implementation of data filtering includes: 1. when a user edits a report to make the report, dragging the component into a report editing area, binding a corresponding data set field with the component, recording the dragged component type by the system and naming the dragged component type by default (the user can modify the dragged component type), recording the binding relationship among the component, the data set field and the data set field by the system, setting a filter function for the property of the component of partial type, setting a filtering condition of the data bound by the component by the user, and setting data linkage of the current component influenced by the filtering condition of other filtering components.
For example, if the data column (business name) of the condition list component 1 in the attribute setting filter of the list component 1 is a parameter value of the text filter component 1, the linkage relationship between the list component 1 and the text filter component 1 can be realized. The system records the filtering relationship of the fields (business name fields) of the data set to which the current list component 1 is bound and the text filtering component 1. More filter component parameter values may be set as condition values by list component 1 in other fields of the data set to which it is bound. The data filtering condition of the list component 1 includes a parameter value of the text filtering component 1 (the so-called parameter value is a text value selected or input by a report viewer in the text filtering component 1 after a future report is generated), so that the system records the linkage relationship between the list component 1 and the text filtering component 1. Similarly, the system records the linkage relation among all the components in the report editing area.
In addition, a special component is provided, the attribute of the special component can set a component triggering event, for example, data linkage of related components of a report is triggered after clicking of a button, for example, the clicking triggering event of the button is set to be all or part of data components in the list component 1, the chart component 1 and the like in linkage relation with the filter component 1 and all or part of data components in the list component 2 in linkage relation with the filter component 2, and the like, and a user can set the filter component related to the button clicking triggering event and the data component related to the filter component according to a required production effect. The system records the button triggering event and comprises all selected filtering components and data components with linkage relation of the selected filtering components.
2. Data drilling: the user can carry out hierarchical management with the relevant dimension of data set before making the report, promptly according to the order of data brill with relevant dimension carry out the hierarchy sequencing adjustment, the hierarchy dimension order that the current data set of this record current preparation report was bored with this to the system, when boring the dimension of setting up and applying to the subassembly, the system can carry out the data effect that the data was bored from top to bottom according to the order that the data that sets up was bored in advance automatically, promptly: when a report is designed, when the dimensions are established into a top-bottom hierarchical relationship through dragging and pulling and the like, the system automatically records the hierarchical management of the dimensions, such as: one dimension is employee classification, after dragging the employee name list to the next level of the employee classification, a drill-down hierarchical relation of the employee classification to the employee name list is established, when displaying at the front end of the report, one of classification data in the employee classification is clicked, and the employee name list under the corresponding classification is automatically drill-down displayed.
3. Linkage setting: for user-specific data components, which may be set to be unaffected by the linkage, the system records the characteristics of those data components that are unaffected by the data linkage.
4. And (4) report storage: after the report is made, the system stores all component names of the current report, the data set bound by the components, the linkage relation among the components, the dimension and the dimension level of data drilling, the data components with the characteristics of being not influenced by linkage and other information, and the report connection is not generated by the currently made report.
5. And (4) report form lookup: when a user opens report connection, the system automatically loads all the pre-stored components of the current report, uses the recorded component binding data set fields for information display of the data components, and simultaneously uses the binding data set fields for information display of the filtering components if the filtering components previously bind the data sets.
And (3) data filtering: when a user inputs or selects a condition parameter value of the filtering component and triggers a filtering event, the system performs data filtering according to the filtering component and the data component which are related to the current triggering filtering event of the current report record, namely: and filtering the data which is associated with the filtering component and is not set by the data component which is not linked by the data and is associated with the filtering event according to the parameter value of the filtering component.
Data drilling: when a user clicks a certain component in the report and clicks the data column in the selected component as a dimension in a dimension level preset as data drilling, when the user operates to drill down, the system expands and displays all data of the data component which is not set with the dimension of the data set and is not linked by data and bound with the dimension of the data set according to the dimension of the next level; when the user operates to drill up, the system displays all the data of the data component which is not set by the data linkage and is bound with the dimension of the data set in the report in a convergence mode according to the dimension of the previous level.
In an example, an embodiment of the present invention provides a report component self-defining device, where the report component self-defining device includes: the system comprises a component library management module, a data collection management module, a report integration module, a linkage setting module, a linkage relation storage module and a linkage triggering mechanism.
Wherein, the component library management module: the method is used for integrated management of access development component packages, and meanwhile, the system generates component labels based on front-end display of the component packages.
A data set management module: the method is used for managing the data sets which can be called by the system, and can store the data stored by importing data files (such as EXCEL, CSV and the like) to the system (storing specific data), or can store the data to the system (storing statements for calling a service platform database or other databases) by using custom SQL scripts.
A report integration module: the report integration module is used for managing the relationship between the used components and the data sets of each report, for example, the report uses the components 1, 2 and 3, the components 1, 2 and 3 bind the data sets 1, 2 and 3, the report integration module also stores the information of the positions of the components, the sizes of the components displayed on the pages and the like, and also stores the data display conditions of the component bound data sets, for example, the data set bound by the components is data which meets a certain condition after the data set acquires data through SQL statements.
A linkage setting module: and the linkage relation and the linkage condition between the components are set.
A linkage relationship storage module: the triggering mechanism for storing linkage relation and linkage conditions among the components and linkage of the components comprises: the linkage condition of single components and among the components and the linkage condition of a plurality of components.
For example, it may be: the linkage of the combination of the text box 1, the drop-down box 2 and the button 1 is adopted, the linkage condition of the combination of the text box 1 and the drop-down box 2 is stored in the system, and the linkage relation of the data table 1 and the data table 2 triggered by the action of clicking the button 1 and screening the data table with other data components is realized through the text box 1 and the drop-down box 2.
A linkage trigger mechanism: when the system recognizes the front-end operation, it judges whether the current operation triggers the data linkage condition, if the condition is satisfied, the linkage relation and the linkage condition information of the linkage relation storage module are called through the operation action of the currently operated component, the condition trigger component and the condition linkage component in the linkage relation are identified, by obtaining the value of the condition trigger component, a single condition or a combined condition of data linkage is formed, the same data screening SQL script statement is generated by the corresponding related fields of the single condition or the combined condition, meanwhile, after the SQL script corresponding to the data set bound by the linkage component acquires data from the corresponding database, and the data in the current cache region is inquired and screened by the system through the uniformly generated SQL script statement, so that the data displayed by the component is obtained.
For example, it may be: and when the system identifies the triggering operation action of the drilling-up and drilling-down, the linkage condition and the linkage relationship of the linkage relationship storage module are called, the linkage data of the drilling-up and drilling-down is filtered and screened according to the logic, and similarly, one or more filtered components are stored by the system, the triggered component operation action is filtered, and the like.
Single conditions: that is, a single condition linkage can be triggered by a certain operation of a certain component, or a linkage of a combined condition is triggered based on a certain operation action of a certain component by data or conditions of a plurality of components.
Exemplary, also include: linkage relation storage module, linkage relation storage module are used for storing linkage relation and linkage condition between subassembly and the subassembly, the trigger mechanism of subassembly linkage includes: the linkage condition between single component and the component, the linkage condition of a plurality of component combinations, the trigger mechanism of component linkage includes: button clicks, filtering of filters, clicking of data lists, etc. trigger mechanisms. It should be noted that, when the report designer designs the report, the linkage relationship and the linkage condition between the components are stored.
In addition, still include: and the linkage setting module is used for setting linkage relation and linkage conditions among the components.
The triggering mechanism of the component linkage includes: the linkage condition of single components and among the components and the linkage condition of a plurality of components. For example, it may be: the linkage of the combination of the text box 1, the drop-down box 2 and the button 1 is adopted, the linkage condition of the combination of the text box 1 and the drop-down box 2 is stored in the system, and the linkage relation of the data table 1 and the data table 2 triggered by the action of clicking the button 1 and screening the data table with other data components is realized through the text box 1 and the drop-down box 2.
The report platform is customized, the called data set of each data version block of the report can be customized, and specifically, the report platform can be realized through a customized SQL script. The embodiment of the invention can realize the management of the related parameters of the assembly which can access data and optimize report forms in a self-defined way, and can drag in the data assembly according to report form requirements and expected report forms, and set the forms of the data presented in the assembly, and the data in the report forms has linkage, and the method specifically comprises the following steps: data screening, data drill-in and drill-out, and the like. According to the technical scheme of the embodiment, the operation information input by a user is acquired; if the data linkage triggering condition is determined according to the operation information, determining a single condition or a combined condition of data linkage according to the operation information; generating a target data screening statement according to the relevant fields corresponding to the single condition or the combined condition; the target data are obtained from the cache region according to the target data screening statements, so that data from a data page module can be obtained through intelligent data linkage, and the richer data information can be provided for a data reader from a multi-angle mining analysis.
Example two
Fig. 2 is a schematic structural diagram of a data acquisition apparatus according to a second embodiment of the present invention. The present embodiment may be applicable to the case of data acquisition, where the apparatus may be implemented in a software and/or hardware manner, and the apparatus may be integrated in any device that provides a data acquisition function, as shown in fig. 2, where the data acquisition apparatus specifically includes: a first acquisition module 210, a determination module 220, a generation module 230, and a second acquisition module 240.
The first obtaining module 210 is configured to obtain operation information input by a user;
a determining module 220, configured to determine a single condition or a combined condition of data linkage according to the operation information if the trigger data linkage condition is determined according to the operation information;
a generating module 230, configured to generate a target data filtering statement according to the relevant field corresponding to the single condition or the combined condition;
and a second obtaining module 240, configured to obtain the target data from the cache region according to the target data filtering statement.
Optionally, the determining module 220 is specifically configured to:
if the trigger data linkage condition is determined according to the operation information, acquiring linkage relation and linkage condition information corresponding to the operation information;
acquiring a condition linkage component corresponding to the linkage relation and a condition trigger component corresponding to the linkage condition information;
and determining a single condition or a combined condition of data linkage according to the condition triggering component and the condition linkage component.
Optionally, the determining module 220 is further configured to:
setting at least one target component linked and associated by a single condition and/or a combined condition;
acquiring a first component corresponding to the operation information;
and if the first component is a target component, acquiring linkage relation and linkage condition information corresponding to the target component.
The product can execute the method provided by any embodiment of the invention, and has corresponding functional modules and beneficial effects of the execution method.
According to the technical scheme of the embodiment, the operation information input by a user is acquired; if the data linkage triggering condition is determined according to the operation information, determining a single condition or a combined condition of data linkage according to the operation information; generating a target data screening statement according to the relevant fields corresponding to the single condition or the combined condition; the target data are obtained from the cache region according to the target data screening statements, so that data from a data page module can be obtained through intelligent data linkage, and the richer data information can be provided for a data reader from a multi-angle mining analysis.
EXAMPLE III
Fig. 3 is a schematic structural diagram of a computer device in a third embodiment of the present invention. FIG. 3 illustrates a block diagram of an exemplary computer device 12 suitable for use in implementing embodiments of the present invention. The computer device 12 shown in FIG. 3 is only an example and should not impose any limitation on the scope of use or functionality of embodiments of the present invention.
As shown in FIG. 3, computer device 12 is in the form of a general purpose computing device. The components of computer device 12 may include, but are not limited to: one or more processors or processing units 16, a system memory 28, and a bus 18 that couples various system components including the system memory 28 and the processing unit 16.
The system Memory 28 may include computer system readable media in the form of volatile Memory, such as Random Access Memory (RAM) 30 and/or cache Memory 32. Computer device 12 may further include other removable/non-removable, volatile/nonvolatile computer system storage media. By way of example only, storage system 34 may be used to read from and write to non-removable, nonvolatile magnetic media (not shown in FIG. 3, and commonly referred to as a "hard drive"). Although not shown in FIG. 3, a magnetic disk drive for reading from and writing to a removable, nonvolatile magnetic disk (e.g., a "floppy disk") and an optical disk drive for reading from or writing to a removable, nonvolatile optical disk (a Compact disk-Read Only Memory (CD-ROM)), Digital Video disk (DVD-ROM), or other optical media may be provided. In these cases, each drive may be connected to bus 18 by one or more data media interfaces. Memory 28 may include at least one program product having a set (e.g., at least one) of program modules that are configured to carry out the functions of embodiments of the invention.
A program/utility 40 having a set (at least one) of program modules 42 may be stored, for example, in memory 28, such program modules 42 including, but not limited to, an operating system, one or more application programs, other program modules, and program data, each of which examples or some combination thereof may comprise an implementation of a network environment. Program modules 42 generally carry out the functions and/or methodologies of the described embodiments of the invention.
The processing unit 16 executes various functional applications and data processing by executing programs stored in the system memory 28, for example, implementing a data acquisition method provided by an embodiment of the present invention:
acquiring operation information input by a user;
if the data linkage triggering condition is determined according to the operation information, determining a single condition or a combined condition of data linkage according to the operation information;
generating a target data screening statement according to the relevant fields corresponding to the single condition or the combined condition;
and acquiring target data from a cache region according to the target data screening statement.
Example four
A fourth embodiment of the present invention provides a computer-readable storage medium, on which a computer program is stored, where the computer program, when executed by a processor, implements the data obtaining method provided in all the embodiments of the present invention:
acquiring operation information input by a user;
if the data linkage triggering condition is determined according to the operation information, determining a single condition or a combined condition of data linkage according to the operation information;
generating a target data screening statement according to the relevant fields corresponding to the single condition or the combined condition;
and acquiring target data from a cache region according to the target data screening statement.
Any combination of one or more computer-readable media may be employed. The computer readable medium may be a computer readable signal medium or a computer readable storage medium or any combination of the two. A computer readable storage medium may be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination of the foregoing. More specific examples (a non-exhaustive list) of the computer readable storage medium would include the following: an electrical connection having one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In the context of this document, a computer readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device.
A computer readable signal medium may include a propagated data signal with computer readable program code embodied therein, for example, in baseband or as part of a carrier wave. Such a propagated data signal may take many forms, including, but not limited to, electro-magnetic, optical, or any suitable combination thereof. A computer readable signal medium may also be any computer readable medium that is not a computer readable storage medium and that can communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus, or device.
Program code embodied on a computer readable medium may be transmitted using any appropriate medium, including but not limited to wireless, wireline, optical fiber cable, RF, etc., or any suitable combination of the foregoing.
In some embodiments, the clients, servers may communicate using any currently known or future developed network Protocol, such as HTTP (Hyper Text Transfer Protocol), and may interconnect with any form or medium of digital data communication (e.g., a communications network). Examples of communication networks include a local area network ("LAN"), a wide area network ("WAN"), the Internet (e.g., the Internet), and peer-to-peer networks (e.g., ad hoc peer-to-peer networks), as well as any currently known or future developed network.
The computer readable medium may be embodied in the electronic device; or may exist separately without being assembled into the electronic device.
The computer readable medium carries one or more programs which, when executed by the electronic device, cause the electronic device to: receiving a source text input by a user, and translating the source text into a target text corresponding to a target language; acquiring historical correction behaviors of the user; and correcting the target text according to the historical correction behaviors to obtain a translation result, and pushing the translation result to a client where the user is located.
Computer program code for carrying out operations for aspects of the present invention may be written in any combination of one or more programming languages, including an object oriented programming language such as Java, Smalltalk, C + +, or the like, as well as conventional procedural programming languages, such as the "C" programming language or similar programming languages. The program code may execute entirely on the user's computer, partly on the user's computer, as a stand-alone software package, partly on the user's computer and partly on a remote computer or entirely on the remote computer or server. In the case of a remote computer, the remote computer may be connected to the user's computer through any type of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or the connection may be made to an external computer (for example, through the Internet using an Internet service provider).
The flowchart and block diagrams in the figures illustrate the architecture, functionality, and operation of possible implementations of systems, methods and computer program products according to various embodiments of the present disclosure. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of code, which comprises one or more executable instructions for implementing the specified logical function(s). It should also be noted that, in some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams and/or flowchart illustration, and combinations of blocks in the block diagrams and/or flowchart illustration, can be implemented by special purpose hardware-based systems which perform the specified functions or acts, or combinations of special purpose hardware and computer instructions.
The units described in the embodiments of the present disclosure may be implemented by software or hardware. Where the name of an element does not in some cases constitute a limitation on the element itself.
The functions described herein above may be performed, at least in part, by one or more hardware logic components. For example, without limitation, exemplary types of hardware logic components that may be used include: field Programmable Gate Arrays (FPGAs), Application Specific Integrated Circuits (ASICs), Application Specific Standard Products (ASSPs), systems on a chip (SOCs), Complex Programmable Logic Devices (CPLDs), and the like.
In the context of this disclosure, a machine-readable medium may be a tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device. The machine-readable medium may be a machine-readable signal medium or a machine-readable storage medium. A machine-readable medium may include, but is not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any suitable combination of the foregoing. More specific examples of a machine-readable storage medium would include an electrical connection based on one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.
It is to be noted that the foregoing is only illustrative of the preferred embodiments of the present invention and the technical principles employed. It will be understood by those skilled in the art that the present invention is not limited to the particular embodiments described herein, but is capable of various obvious changes, rearrangements and substitutions as will now become apparent to those skilled in the art without departing from the scope of the invention. Therefore, although the present invention has been described in greater detail by the above embodiments, the present invention is not limited to the above embodiments, and may include other equivalent embodiments without departing from the spirit of the present invention, and the scope of the present invention is determined by the scope of the appended claims.
Claims (10)
1. A method of data acquisition, comprising:
acquiring operation information input by a user;
if the data linkage triggering condition is determined according to the operation information, determining a single condition or a combined condition of data linkage according to the operation information;
generating a target data screening statement according to the relevant fields corresponding to the single condition or the combined condition;
and acquiring target data from a cache region according to the target data screening statement.
2. The method of claim 1, wherein if the condition for triggering data linkage is determined according to the operation information, determining a single condition or a combined condition for data linkage according to the operation information comprises:
if the trigger data linkage condition is determined according to the operation information, acquiring linkage relation and linkage condition information corresponding to the operation information;
acquiring a condition linkage component corresponding to the linkage relation and a condition trigger component corresponding to the linkage condition information;
and determining a single condition or a combined condition of data linkage according to the condition triggering component and the condition linkage component.
3. The method according to claim 2, wherein if the trigger data linkage condition is determined according to the operation information, acquiring linkage relation and linkage condition information corresponding to the operation information comprises:
setting at least one target component linked and associated by a single condition and/or a combined condition;
acquiring a first component corresponding to the operation information;
and if the first component is a target component, acquiring linkage relation and linkage condition information corresponding to the target component.
4. The method of claim 2, wherein obtaining target data from a cache according to the target data filter statement comprises:
acquiring an initial database statement corresponding to the condition triggering component;
acquiring initial data according to the initial database statement;
storing the initial data to a cache region;
and acquiring target data from the cache region according to the target data screening statement.
5. The method of claim 1, after retrieving target data from a cache according to the target data filter statement, further comprising:
and storing the target data in a cache region.
6. A data acquisition apparatus, comprising:
the first acquisition module is used for acquiring operation information input by a user;
the determining module is used for determining a single condition or a combined condition of data linkage according to the operation information if the condition for triggering the data linkage is determined according to the operation information;
the generating module is used for generating a target data screening statement according to the relevant fields corresponding to the single condition or the combined condition;
and the second acquisition module is used for acquiring the target data from the cache region according to the target data screening statement.
7. The apparatus of claim 6, wherein the determining module is specifically configured to:
if the trigger data linkage condition is determined according to the operation information, acquiring linkage relation and linkage condition information corresponding to the operation information;
acquiring a condition linkage component corresponding to the linkage relation and a condition trigger component corresponding to the linkage condition information;
and determining a single condition or a combined condition of data linkage according to the condition triggering component and the condition linkage component.
8. The apparatus of claim 7, wherein the determining module is further configured to:
setting at least one target component linked and associated by a single condition and/or a combined condition;
acquiring a first component corresponding to the operation information;
and if the first component is a target component, acquiring linkage relation and linkage condition information corresponding to the target component.
9. A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, characterized in that the processor implements the method according to any of claims 1-5 when executing the program.
10. A computer-readable storage medium, on which a computer program is stored which, when being executed by a processor, carries out the method according to any one of claims 1-5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011541100.7A CN112527868A (en) | 2020-12-23 | 2020-12-23 | Data acquisition method, device, equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011541100.7A CN112527868A (en) | 2020-12-23 | 2020-12-23 | Data acquisition method, device, equipment and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112527868A true CN112527868A (en) | 2021-03-19 |
Family
ID=74975992
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011541100.7A Pending CN112527868A (en) | 2020-12-23 | 2020-12-23 | Data acquisition method, device, equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112527868A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113779462A (en) * | 2021-09-09 | 2021-12-10 | 金蝶软件（中国）有限公司 | Image linkage method, device, equipment and storage medium |
Citations (18)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1588369A (en) * | 2004-09-06 | 2005-03-02 | 杭州恒生电子股份有限公司 | Relation type data base system and its search and report method |
| US7840600B1 (en) * | 2006-12-29 | 2010-11-23 | Izenda, LLC | Systems and methods for interactively creating, customizing, and executing reports over the internet |
| CN102024062A (en) * | 2011-01-06 | 2011-04-20 | 中国工商银行股份有限公司 | Device and method for realizing data dynamic cache |
| CN103399926A (en) * | 2013-08-05 | 2013-11-20 | 河海大学 | Water conservancy general survey data multidimensional analysis and service system and encapsulation and achieving method thereof |
| CN103473078A (en) * | 2013-09-30 | 2013-12-25 | 南京朗睿软件科技有限公司 | Method for generating report |
| CN104408170A (en) * | 2014-12-09 | 2015-03-11 | 广州大乘信息科技有限公司 | Business data analysis system |
| CN104424258A (en) * | 2013-08-28 | 2015-03-18 | 腾讯科技（深圳）有限公司 | Multidimensional data query method and system, query server and column storage server |
| CN104794113A (en) * | 2014-01-16 | 2015-07-22 | 中兴通讯股份有限公司 | Data processing method and device |
| WO2017070682A1 (en) * | 2015-10-24 | 2017-04-27 | Oracle International Corporation | Display of dynamic contextual pivot grid analytics |
| CN109086354A (en) * | 2018-07-17 | 2018-12-25 | 于果鑫 | A kind of big data analysis processing system based on extended node cluster |
| CN109189802A (en) * | 2018-08-13 | 2019-01-11 | 成都四方伟业软件股份有限公司 | Data processing method, device, electronic equipment and readable storage medium storing program for executing |
| CN109241049A (en) * | 2018-07-04 | 2019-01-18 | 杭州数云信息技术有限公司 | A kind of OLAP framework |
| US20190302969A1 (en) * | 2018-03-30 | 2019-10-03 | Salesforce.Com, Inc. | Global Filter |
| CN110941654A (en) * | 2019-11-25 | 2020-03-31 | 杭州晨鹰军泰科技有限公司 | Data query display system, method, device and medium based on configuration template |
| CN111552712A (en) * | 2020-04-30 | 2020-08-18 | 中国平安财产保险股份有限公司 | Report data extraction method and device and computer equipment |
| CN111831623A (en) * | 2020-05-29 | 2020-10-27 | 大数金科网络技术有限公司 | Configurable ad hoc query system and method |
| CN111881224A (en) * | 2020-08-06 | 2020-11-03 | 广东省信息工程有限公司 | Multidimensional data analysis method and system |
| CN112015423A (en) * | 2019-05-30 | 2020-12-01 | 北京奇虎科技有限公司 | Data processing system and method |
-
2020
- 2020-12-23 CN CN202011541100.7A patent/CN112527868A/en active Pending
Patent Citations (18)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1588369A (en) * | 2004-09-06 | 2005-03-02 | 杭州恒生电子股份有限公司 | Relation type data base system and its search and report method |
| US7840600B1 (en) * | 2006-12-29 | 2010-11-23 | Izenda, LLC | Systems and methods for interactively creating, customizing, and executing reports over the internet |
| CN102024062A (en) * | 2011-01-06 | 2011-04-20 | 中国工商银行股份有限公司 | Device and method for realizing data dynamic cache |
| CN103399926A (en) * | 2013-08-05 | 2013-11-20 | 河海大学 | Water conservancy general survey data multidimensional analysis and service system and encapsulation and achieving method thereof |
| CN104424258A (en) * | 2013-08-28 | 2015-03-18 | 腾讯科技（深圳）有限公司 | Multidimensional data query method and system, query server and column storage server |
| CN103473078A (en) * | 2013-09-30 | 2013-12-25 | 南京朗睿软件科技有限公司 | Method for generating report |
| CN104794113A (en) * | 2014-01-16 | 2015-07-22 | 中兴通讯股份有限公司 | Data processing method and device |
| CN104408170A (en) * | 2014-12-09 | 2015-03-11 | 广州大乘信息科技有限公司 | Business data analysis system |
| WO2017070682A1 (en) * | 2015-10-24 | 2017-04-27 | Oracle International Corporation | Display of dynamic contextual pivot grid analytics |
| US20190302969A1 (en) * | 2018-03-30 | 2019-10-03 | Salesforce.Com, Inc. | Global Filter |
| CN109241049A (en) * | 2018-07-04 | 2019-01-18 | 杭州数云信息技术有限公司 | A kind of OLAP framework |
| CN109086354A (en) * | 2018-07-17 | 2018-12-25 | 于果鑫 | A kind of big data analysis processing system based on extended node cluster |
| CN109189802A (en) * | 2018-08-13 | 2019-01-11 | 成都四方伟业软件股份有限公司 | Data processing method, device, electronic equipment and readable storage medium storing program for executing |
| CN112015423A (en) * | 2019-05-30 | 2020-12-01 | 北京奇虎科技有限公司 | Data processing system and method |
| CN110941654A (en) * | 2019-11-25 | 2020-03-31 | 杭州晨鹰军泰科技有限公司 | Data query display system, method, device and medium based on configuration template |
| CN111552712A (en) * | 2020-04-30 | 2020-08-18 | 中国平安财产保险股份有限公司 | Report data extraction method and device and computer equipment |
| CN111831623A (en) * | 2020-05-29 | 2020-10-27 | 大数金科网络技术有限公司 | Configurable ad hoc query system and method |
| CN111881224A (en) * | 2020-08-06 | 2020-11-03 | 广东省信息工程有限公司 | Multidimensional data analysis method and system |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113779462A (en) * | 2021-09-09 | 2021-12-10 | 金蝶软件（中国）有限公司 | Image linkage method, device, equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11797532B1 (en) | Dashboard display using panel templates | |
| US11513793B2 (en) | Systems and methods for providing an instant communication channel within integrated development environments | |
| US11263273B2 (en) | Systems and methods for graphical exploration of forensic data | |
| US11003645B1 (en) | Column lineage for resource dependency system and graphical user interface | |
| US8296311B2 (en) | Solution search for software support | |
| KR101002451B1 (en) | Computer searching with associations | |
| US10747952B2 (en) | Automatic creation and server push of multiple distinct drafts | |
| US20110040726A1 (en) | Layout Manager | |
| US10565221B2 (en) | Systems and methods for graphical exploration of forensic data | |
| US20150089403A1 (en) | Dynamic generation of user interface | |
| US8875057B2 (en) | Document management framework | |
| TWI682289B (en) | Mehtod, system and computer program product for obtaining data of specific interest to a user from one or more data storage locations | |
| US7818328B2 (en) | API for obtaining unambiguous representation of objects in a relational database | |
| JP2015146182A (en) | Extraction and report of electronic document using tagging analysis and/or logic custodian | |
| US11636162B2 (en) | Multi-database document search system architecture | |
| US8060484B2 (en) | Graphical user interface for data management | |
| CN112527868A (en) | Data acquisition method, device, equipment and storage medium | |
| US20160217218A1 (en) | Automatic Workflow For E-Discovery | |
| US10261663B2 (en) | Mandatory comment on action or modification | |
| US20130218893A1 (en) | Executing in-database data mining processes | |
| US20230111193A1 (en) | Uniform hierarchical view over diverse data formats | |
| US20230368104A1 (en) | Systems and methods for automation discovery recalculation using dynamic time window optimization | |
| CN113889211A (en) | Automatic electronic medical record form generation system | |
| CN115455928A (en) | Interactive exploration method of data report | |
| CN114817412A (en) | Multidimensional data visualization management method and device and storage medium |
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 |