CN113515550B - Method for associating and screening data between applications/systems - Google Patents
Method for associating and screening data between applications/systems Download PDFInfo
- Publication number
- CN113515550B CN113515550B CN202110400319.3A CN202110400319A CN113515550B CN 113515550 B CN113515550 B CN 113515550B CN 202110400319 A CN202110400319 A CN 202110400319A CN 113515550 B CN113515550 B CN 113515550B
- Authority
- CN
- China
- Prior art keywords
- data
- screening
- service
- association
- systems
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
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
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Software Systems (AREA)
- User Interface Of Digital Computer (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a method for associating 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 beneficial effects of the invention are as follows: 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 number No > =200 in different tables. Such a query statement may be written without the user having a database language base.
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;
saves and sends 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 values of the data-associated form controls 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 of cross-application/system data cooperation and data isolated island in the prior art; by implementing the technical scheme of the invention, data can be screened and correlated according to set conditions by data among different applications/systems, 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 as used in the following description, the terms "front", "back", "left", "right", "upper" and "lower" 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 by using natural language, the form analyzes a user screening requirement and converts the user screening requirement into a screening formula that can be recognized by different applications/systems to perform data association screening, and finally, a result obtained from different applications/systems is converted into recognizable information to be displayed to a user, where the form includes Request Service, recognservice, 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), all configuration information (data association configuration) in the form is packaged and maintained in the formZone Service, all value changes of form components are monitored, and a data association automatic association result can be realized 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.
Values of form controls-data saved by form controls (text entry boxes, radio boxes, positioning fields) in the form engine that are either user-entered or automatically obtained.
The method comprises a setting part and an executing part:
the setting part mainly comprises a RequestService, 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 parsing: 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 accurately matching the Attribute obtained by semantic analysis with the existing field title of the form, and performing fuzzy matching again if the matching result is not obtained by 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 the form, the formZone Service monitors a change event of the form, and a handleontrolvaluechanges method in the formZone Service dynamically judges 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, acquiring dynamic variables in the association rules, wherein the dynamic variables are used for combining and assembling into query parameters: if the value associated with the data needs to be updated, the getModelsRelationData method is called in the value Detector Service, and the value of the form control which needs to be depended on is updated according to the current data associated field and 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 through 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" input 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' is 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 the 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 database in the use case can be different databases among different applications or databases among different systems.
It should be noted that the above-mentioned embodiments are only preferred embodiments of the present invention, and should not be construed as limiting the present invention, and any modifications, equivalents, improvements and the like made within the spirit and principle of the present invention should be included in the protection scope of the present invention.
Claims (4)
1. A method for associating 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, the form comprises Request Service, recognit Service, filter Service, formZone Service and Value Detector Service, wherein the Request Service is used for managing interface requests, the RecognService is used for carrying out voice recognition and semantic recognition on screening adjustment, the Filter Service is used for assembling the screening conditions, the FormZone Service is used for monitoring form change events and triggering form component updating, and the Value Detector Service is used for executing form component updating;
the method comprises a setting part and an executing part; the setting part is used for setting screening and association rules and comprises a RequestService, a Recognit Service and a Filter Service; the execution part is used for carrying out automatic triggering of the associated action and form control assignment; the execution part comprises a RequestService, a FormZone Service and a Value Detector Service;
the setting part comprises the following specific steps: acquiring an associable application;
setting a target application;
setting an association screening rule;
checking configuration integrity;
storing and sending the request;
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.
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 specific steps of actively updating the values of the data-associated form controls are as follows: obtaining dynamic variations in association rules
An amount;
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 value needs to be updated, 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 CN113515550A (en) | 2021-10-19 |
CN113515550B true 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 (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN103631570A (en) * | 2012-08-21 | 2014-03-12 | 镇江雅迅软件有限责任公司 | Form self-definition method |
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 |
Family Cites Families (6)
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 |
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) |
CN104239473B (en) * | 2014-09-03 | 2017-06-30 | 陈飞 | The device and method of data cross-system disposal is carried out based on natural language industry knowledge base |
CN109241259B (en) * | 2018-08-24 | 2021-01-05 | 国网江苏省电力有限公司苏州供电分公司 | ER model-based natural language query method, device and system |
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 (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN103631570A (en) * | 2012-08-21 | 2014-03-12 | 镇江雅迅软件有限责任公司 | Form self-definition method |
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 |
Also Published As
Publication number | Publication date |
---|---|
CN113515550A (en) | 2021-10-19 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US11645345B2 (en) | Systems and methods for issue tracking systems | |
US7373351B2 (en) | Generic search engine framework | |
US7788590B2 (en) | Lightweight reference user interface | |
US7958131B2 (en) | Method for data management and data rendering for disparate data types | |
KR100861860B1 (en) | Dynamic prosody adjustment for voice-rendering synthesized data | |
US8271107B2 (en) | Controlling audio operation for data management and data rendering | |
JP2522898B2 (en) | Dynamic customization method and graphic resource editor | |
CN108959631B (en) | Method and device for querying information | |
US20070061712A1 (en) | Management and rendering of calendar data | |
US20030060896A9 (en) | Software, devices and methods facilitating execution of server-side applications at mobile devices | |
US20070061132A1 (en) | Dynamically generating a voice navigable menu for synthesized data | |
US20070061371A1 (en) | Data customization for data of disparate data types | |
US20070168194A1 (en) | Scheduling audio modalities for data management and data rendering | |
US20070100872A1 (en) | Dynamic creation of user interfaces for data management and data rendering | |
JP5192634B2 (en) | Declaration order report parameterization | |
CN111158795A (en) | Report generation method, device, medium and electronic equipment | |
JP2019207648A (en) | Interactive business assistance system | |
US20110252049A1 (en) | Function execution using sql | |
CN109313563A (en) | A kind of collecting method, apparatus and system | |
US20080270445A1 (en) | Method for automating variables in end-user programming system | |
EP2924565A1 (en) | Web-application-launch application programming interface | |
CN113515550B (en) | Method for associating and screening data between applications/systems | |
CN116048515A (en) | Virtual scene editing method, device, equipment and readable storage medium | |
US10642629B2 (en) | Web-application-launch application programming interfaces | |
US11811712B2 (en) | Conversational natural language interfaces for data analysis |
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 |