CN113515550A - Method for associating and screening data between applications/systems - Google Patents
Method for associating and screening data between applications/systems Download PDFInfo
- Publication number
- CN113515550A CN113515550A CN202110400319.3A CN202110400319A CN113515550A CN 113515550 A CN113515550 A CN 113515550A CN 202110400319 A CN202110400319 A CN 202110400319A CN 113515550 A CN113515550 A CN 113515550A
- Authority
- CN
- China
- Prior art keywords
- data
- screening
- service
- applications
- association
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
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/2457—Query processing with adaptation to user needs
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
- G06F16/24564—Applying rules; Deductive queries
-
- 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
- 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/25—Integrating or interfacing systems involving database management systems
- G06F16/252—Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
-
- 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/25—Integrating or interfacing systems involving database management systems
- G06F16/258—Data format conversion from or to a database
Abstract
The invention provides a method for correlating and screening data between applications/systems, which is characterized by comprising the following steps: the user operation form carries out data screening by customizing screening conditions through a visual interface and using natural language, analyzes user screening requirements and converts the user screening requirements into screening formulas which can be identified by different applications/systems to carry out data association screening, and finally converts results obtained from the different applications/systems into identifiable information to be displayed to users, wherein the form comprises Request Service, Recognit Service, Filter Service, FormZone Service and Value Detector Service. The invention has the beneficial effects that: the problem of data isolated island is solved, the communication cost of cross-application/system data cooperation is reduced, data screening and association can be carried out on data among different applications/systems according to set conditions, and the method is convenient, rapid and easy to use.
Description
Technical Field
The invention relates to the field of data association and screening, in particular to a method for associating and screening data between applications/systems.
Background
The data are stored and maintained independently and are isolated from each other in different applications/systems; different applications/systems understand and define data according to own requirements, so that the same data are endowed with different meanings, and the communication cost of data cooperation across the applications/systems is increased. In the enterprise informatization process, solving the data island problem is a very important ring.
The traditional data screening or preprocessing is generally implemented by a computer language or a programming language in a visual interface or even a database command line at the bottom layer, for example, a database query statement is written in navicat to obtain all information of a commodity with a number No > -200 in different tables. Such a query statement may need to be written on a database language basis by the user.
Disclosure of Invention
In order to solve the above technical problem, the present invention discloses a method for associating and screening data between applications/systems, and the technical solution of the present invention is implemented as follows:
a method for correlating and screening data between applications/systems is characterized in that a user operation form carries out data screening by customizing screening conditions through a visual interface and using natural language, the form analyzes user screening requirements and converts the user screening requirements into screening formulas which can be identified by different applications/systems to carry out data correlation screening, and finally results obtained from different applications/systems are converted into identifiable information to be displayed to users, wherein the form comprises Request Service, Recognit Service, Filter Service, FormZone Service and Value Detector Service.
Preferably, the Recognit Service includes a speech recognition module and a text semantic parsing module.
Preferably, the value detector Service includes a data conversion, a data encapsulation, a data request, and a value update trigger.
Preferably, the method comprises a setting part and an executing part; the setting part is used for setting screening and association rules, and the executing part is used for carrying out automatic triggering of association actions and form control assignment.
Preferably, the specific steps of the setting part are as follows: acquiring an associable application;
setting a target application;
setting an association screening rule;
checking configuration integrity;
save and send the request.
Preferably, the specific steps of the execution part are as follows: a user operates the form;
analyzing the association rule and monitoring the form value change;
judging whether the associated data needs to be pulled, if not, not pulling, and if so, carrying out the next step;
and actively updating the value of the data association form control.
Preferably, the specific steps of actively updating the value of the data-associated form control are as follows: acquiring a dynamic variable in the association rule;
reading and analyzing the association rule;
converting data formats, and merging and assembling data;
providing a data request;
distributing the data query result to each data association field in the form;
analyzing a data query result;
and judging whether the updating value is needed, if so, updating the analysis result into the form, otherwise, not updating.
The technical scheme of the invention can solve the technical problems of overlarge communication cost across application/system data cooperation and data isolated island in the prior art; by implementing the technical scheme of the invention, data screening and association can be carried out on data among different applications/systems according to set conditions, so that the communication cost of cross-application/system data cooperation can be reduced, the problem of data isolated island is solved, and the method is convenient, quick and easy to use.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only one embodiment of the present invention, and for those skilled in the art, other drawings can be obtained according to the drawings without creative efforts.
In which like parts are designated by like reference numerals. It should be noted that the terms "front," "back," "left," "right," "upper" and "lower" used in the following description refer to directions in the drawings, and the terms "bottom" and "top," "inner" and "outer" refer to directions toward and away from, respectively, the geometric center of a particular component.
FIG. 1 is a flow chart of a setup section;
FIG. 2 is a flow chart of an implementation;
FIG. 3 is an interface for a user to customize the filter criteria.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
Examples
In a specific embodiment, as shown in fig. 1, fig. 2, and fig. 3, a method for associating and screening data between applications/systems is provided, where a user operation form defines a screening condition through a visual interface and performs data screening using a natural language, the form analyzes a user screening requirement and converts the user screening requirement into a screening formula recognizable by different applications/systems to perform data association screening, and finally, results obtained from different applications/systems are converted into recognizable information to be displayed to a user, where the form includes Request Service, recognt Service, Filter Service, FormZone Service, and Value Detector Service.
Request Service: managing the interface request;
recognit Service: carrying out voice recognition and semantic analysis on the screening conditions;
filter Service: assembling the screening conditions;
FormZone Service: monitoring a form change event and triggering form component updating;
value Detector Service: form component updates are performed.
formZone Service: each form provides an independent formZone Service (called zone hereinafter), and the formZone Service encapsulates and maintains all configuration information (data association configuration) in the form, monitors all value changes of form components, and can realize data association automatic association results on the basis of the configuration information.
value Detector Service Each form provides a value Detector Service (hereinafter referred to as a Detector) in addition to the formZone Service. The value Detector Service encapsulates a data conversion (value processor Service), a data encapsulation (value processor Service), a data request (getrietedvalue method) and a value update trigger (detectmodelvalueupdate method) shortcut operation method, so that the value of the form control can be actively and quickly updated.
Form control value-user entered or automatically acquired data saved in the form engine for the form controls (text entry box, radio box, location field).
The method comprises a setting part and an executing part:
the setting part mainly comprises a request Service, a Recognit Service and a Filter Service. Is used for setting screening and associated rules, 2 setting modes are provided: voice/text settings and visual operation settings. The setting part comprises the following specific steps:
1. acquiring an associable application: and acquiring all applications which can be associated by the user from the RequestService (the application range which can support selection comprises the existing data of the current form and other forms of the working area, and other system data which is pulled through a network request).
2. Setting a target application: the Select component provided by the open source library NG-ZORRO is used to provide a visualization way for the user to Select a target application from the associable applications.
3. Setting an association screening rule:
and 3.1, automatically analyzing the voice and the characters into a screening rule.
3.1.1 pronunciation, characters are input and are screened the rule: the user uploads the voice/input characters, and the voice/input characters are processed by Recognit Service to automatically generate a screening condition.
3.1.2 Speech recognition: the Recognit Service provides a voice recognition module, supports Chinese Mandarin and English, and converts audio input into text information by connecting with a scientific news fly 'voice transcription' AI.
3.1.3 semantic resolution: the Recognit Service provides a text semantic parsing module NaturalllanguaageAnalysismodule, and performs lexical matching on the transmitted text to obtain Attribute (fixed language).
3.1.4 automatically generating matching rules: and performing accurate matching on the Attribute obtained by semantic analysis and the existing field title of the form, and performing fuzzy matching again if the matching result is not obtained by the accurate matching. And assembling the matching result (containing the matched field title, field id, matching type and matching value) into a data structure of the matching rule required by the server, and adding the data structure into the form.
3.2, user-defined screening rules
3.2.1 obtaining variables that can participate in the screening: and obtaining variable fields which can participate in screening and matching in the current form and the target application.
3.2.2 the user sets the matching relationship between the value of the target application and the value of the current form in the popup window, and customizes the screening rule associated with the data, as shown in FIG. 3.
4. Checking the integrity of the configuration: data association must set the target application and target field to be usable.
5. And (3) storage: and sending a request, and storing the user setting to the server.
The execution part mainly comprises a RequestService, a FormZone Service and a Value Detector Service. Is used for carrying out automatic triggering of associated actions and form control assignment. The specific steps of the execution part are as follows:
6. after a user operates a form, formZone Service can monitor a change event of the form, and a handleControlValueChanges method in the formZone Service can dynamically judge whether the change causes data association. If necessary, a detectModelsValueUpdate method of the value Detector Service is called for data association.
7. Judging whether the associated data needs to be pulled: after the detectmodelvalueupdate is triggered, the method queries the incoming association configuration of models (form controls that need to detect whether values need to be automatically updated), and quickly determines whether values of the data-associated form controls need to be actively updated according to the relationship triggermap (relationship map) stored in the formZone Service.
8. And actively updating the value of the data association form control.
8.1, obtaining dynamic variables in the association rule, and combining and assembling the dynamic variables into query parameters: if the value associated with the data needs to be updated, the getModelsRelationsData method is called in the value Detector Service, and the value of the form control which needs to be depended on by the current data associated field is updated according to the associated configuration defined by the user.
And 8.2, converting the data format of the dynamic variable, merging and assembling the data into query parameters, namely constructing a service-side query parameter by using getModelsRelationsData, wherein the service-side query parameter comprises keyQueValues, queryQuestions, qlinkerValues and some form setting information and is used for sending the service-side query parameter to a service-side query database.
8.3, initiating a data request to a server, pulling the associated data: and sending the query parameters constructed by the getModelsRelationsData method in the value Detector Service to the light stream server through httpCient Service provided by an Angular frame, querying a data association result, and distributing the data association result queried by the server to each form control transmitted in the detectModlsValueUpdate, wherein each form control processes the value update of the form control.
8.4, updating of form control values: the form control converts the self-matching result read from the analyzed data query result into a value matched with the data structure of the form control by an answerValueToFormValue method in the value Detector Service, and updates the value into the control.
Use example:
the user wants to display the data meeting the filtering condition in the database of the current page.
a. The screening condition is to obtain the commodity name with price higher than the "price" entered on the current page in the database A.
b. The screening condition is to obtain the commodity name of the character string generated by MD5 encryption after splicing 3 attributes in database B, namely 'signature' equal to the current page 'name', 'commodity ID' and 'warehousing time'.
Firstly, right control parameters such as current user right, work area right and the like are transmitted, all visible database names are pulled from a server based on the access parameters and displayed in a visual interface, and a user only needs to select a database A/B as a data source in pull-down menu options as required; after a data source is selected, the system automatically acquires variable/field names which can be displayed in a target database, the variable/field names are displayed in a current form configuration page as options, and then the options are configured as screening conditions, for example, in combination with conditions a and b.
Taking condition a as an example: the user can directly input the screening condition described by the natural language in the input box, for example, the price is higher than the input commodity name, or click a button to input voice, and the voice is converted into text which is processed into the screening condition available for the system through the semantic analysis module.
Taking condition b as an example: in the conventional technology, because the screening condition is complex, a plurality of current form variables are used, and calculation such as encryption is required, relatively speaking, more complex data screening can be realized, but certain technical requirements can be met for users. In the invention, the Recognit Service can process the screening requirement into the screening condition available for the system by adopting partial natural language or language input.
It can be seen from the conditions a and b that the more complicated the conditions are, the more difficult the data interaction between the applications/systems of the enterprises is, but the method of the present invention can solve the problems, and the user does not need to have a certain technical basis, so the cost is lower, and the use is simpler.
Constructing a network request by using a getModelsRelationsData method according to conditions set by a user, inquiring data meeting the conditions from a server, reading parameters of a form control, judging whether the data are required to be updated according to the parameters, and finally displaying the data meeting the conditions on a current page. The databases in this use case may be different databases between different applications or databases between different systems.
It should be understood that the above-described embodiments are merely exemplary of the present invention, and are not intended to limit the present invention, and that any modification, equivalent replacement, or improvement made without departing from the spirit and principle of the present invention shall fall within the protection scope of the present invention.
Claims (7)
1. A method for correlating and screening data between applications/systems, comprising: the method comprises the steps that a user operation form carries out data screening through a visual interface user-defined screening condition and natural language, the form analyzes user screening requirements and converts the user screening requirements into a screening formula which can be identified by different applications/systems to carry out data association screening, and finally results obtained from the different applications/systems are converted into identifiable information to be displayed to a user, wherein the form comprises Request Service, Recognit Service, Filter Service, FormZone Service and Value Detector Service.
2. The method for associating and screening data between applications/systems according to claim 1, wherein: the Recognit Service comprises a voice recognition module and a text semantic analysis module.
3. A method for associating and screening data between applications/systems according to claim 2, wherein: the value Detector Service includes data conversion, data encapsulation, data request and value update triggers.
4. A method for associating and screening data between applications/systems according to claim 3, wherein: the method comprises a setting part and an executing part; the setting part is used for setting screening and association rules, and the executing part is used for carrying out automatic triggering of association actions and form control assignment.
5. The method for associating and screening data between applications/systems according to claim 4, wherein: the setting part comprises the following specific steps: acquiring an associable application;
setting a target application;
setting an association screening rule;
checking configuration integrity;
save and send the request.
6. The method for associating and screening data between applications/systems according to claim 5, wherein: the specific steps of the execution part are as follows: a user operates the form;
analyzing the association rule and monitoring the form value change;
judging whether the associated data needs to be pulled, if not, not pulling, and if so, carrying out the next step;
and actively updating the value of the data association form control.
7. The method for associating and screening data between applications/systems according to claim 6, wherein: the specific steps for actively updating the value of the data-associated form control are as follows: acquiring a dynamic variable in the association rule;
reading and analyzing the association rule;
converting data formats, and merging and assembling data;
providing a data request;
distributing the data query result to each data association field in the form;
analyzing a data query result;
and judging whether the updating value is needed, if so, updating the analysis result into the form, otherwise, not updating.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110400319.3A CN113515550B (en) | 2021-04-14 | 2021-04-14 | Method for associating and screening data between applications/systems |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110400319.3A CN113515550B (en) | 2021-04-14 | 2021-04-14 | Method for associating and screening data between applications/systems |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN113515550A true CN113515550A (en) | 2021-10-19 |
| CN113515550B CN113515550B (en) | 2023-01-03 |
Family
ID=78062351
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110400319.3A Active CN113515550B (en) | 2021-04-14 | 2021-04-14 | Method for associating and screening data between applications/systems |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113515550B (en) |
Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7240045B1 (en) * | 2001-07-24 | 2007-07-03 | Brightplanet Corporation | Automatic system for configuring to dynamic database search forms |
| CN103631570A (en) * | 2012-08-21 | 2014-03-12 | 镇江雅迅软件有限责任公司 | Form self-definition method |
| CN104239473A (en) * | 2014-09-03 | 2014-12-24 | 陈飞 | Device and method for data cross-system processing on basis of natural language industry knowledge base |
| US20160255139A1 (en) * | 2016-03-12 | 2016-09-01 | Yogesh Chunilal Rathod | Structured updated status, requests, user data & programming based presenting & accessing of connections or connectable users or entities and/or link(s) |
| CN107807913A (en) * | 2017-11-16 | 2018-03-16 | 金航数码科技有限责任公司 | A kind of form design system and method based on web |
| CN108154569A (en) * | 2017-12-27 | 2018-06-12 | 广州奥格智能科技有限公司 | A kind of inspection acquisition method based on object modelization configuration |
| CN109241259A (en) * | 2018-08-24 | 2019-01-18 | 国网江苏省电力有限公司苏州供电分公司 | Natural language querying method, apparatus and system based on ER model |
| CN110991191A (en) * | 2019-12-05 | 2020-04-10 | 南京品微智能科技有限公司 | Method for realizing flow self-definition based on natural semantic conversion |
| CN111737577A (en) * | 2020-06-22 | 2020-10-02 | 平安医疗健康管理股份有限公司 | Data query method, device, equipment and medium based on service platform |
-
2021
- 2021-04-14 CN CN202110400319.3A patent/CN113515550B/en active Active
Patent Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7240045B1 (en) * | 2001-07-24 | 2007-07-03 | Brightplanet Corporation | Automatic system for configuring to dynamic database search forms |
| CN103631570A (en) * | 2012-08-21 | 2014-03-12 | 镇江雅迅软件有限责任公司 | Form self-definition method |
| CN104239473A (en) * | 2014-09-03 | 2014-12-24 | 陈飞 | Device and method for data cross-system processing on basis of natural language industry knowledge base |
| US20160255139A1 (en) * | 2016-03-12 | 2016-09-01 | Yogesh Chunilal Rathod | Structured updated status, requests, user data & programming based presenting & accessing of connections or connectable users or entities and/or link(s) |
| CN107807913A (en) * | 2017-11-16 | 2018-03-16 | 金航数码科技有限责任公司 | A kind of form design system and method based on web |
| CN108154569A (en) * | 2017-12-27 | 2018-06-12 | 广州奥格智能科技有限公司 | A kind of inspection acquisition method based on object modelization configuration |
| CN109241259A (en) * | 2018-08-24 | 2019-01-18 | 国网江苏省电力有限公司苏州供电分公司 | Natural language querying method, apparatus and system based on ER model |
| CN110991191A (en) * | 2019-12-05 | 2020-04-10 | 南京品微智能科技有限公司 | Method for realizing flow self-definition based on natural semantic conversion |
| CN111737577A (en) * | 2020-06-22 | 2020-10-02 | 平安医疗健康管理股份有限公司 | Data query method, device, equipment and medium based on service platform |
Also Published As
| Publication number | Publication date |
|---|---|
| CN113515550B (en) | 2023-01-03 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11645345B2 (en) | Systems and methods for issue tracking systems | |
| US7788590B2 (en) | Lightweight reference user interface | |
| CN108959631B (en) | Method and device for querying information | |
| US7644065B2 (en) | Process of performing an index search | |
| US6502233B1 (en) | Automated help system for reference information | |
| JP2522898B2 (en) | Dynamic customization method and graphic resource editor | |
| CN110309006B (en) | Function calling method and device, terminal equipment and storage medium | |
| US11550853B2 (en) | Using natural language expressions to define data visualization calculations that span across multiple rows of data from a database | |
| US20110252049A1 (en) | Function execution using sql | |
| US7987446B2 (en) | Method for automating variables in end-user programming system | |
| CN113168645A (en) | Knowledge search system | |
| US7818328B2 (en) | API for obtaining unambiguous representation of objects in a relational database | |
| JP2019207648A (en) | Interactive business assistance system | |
| CN111897836A (en) | Search system, method and storage medium | |
| CN111382256B (en) | Information recommendation method and device | |
| US8701086B2 (en) | Simplifying analysis of software code used in software systems | |
| CN113515550B (en) | Method for associating and screening data between applications/systems | |
| EP2924565A1 (en) | Web-application-launch application programming interface | |
| CN116048515A (en) | Virtual scene editing method, device, equipment and readable storage medium | |
| US8924420B2 (en) | Creating logic using pre-built controls | |
| US10642629B2 (en) | Web-application-launch application programming interfaces | |
| US11811712B2 (en) | Conversational natural language interfaces for data analysis | |
| CN114610204B (en) | Auxiliary device and method for data processing, storage medium and electronic equipment | |
| US10691301B2 (en) | Polymorphic smart context-aware lists | |
| KR100419018B1 (en) | method for management of display information using XML |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |