CN110737709B - Formula model generation method based on visual editing system - Google Patents
Formula model generation method based on visual editing system Download PDFInfo
- Publication number
- CN110737709B CN110737709B CN201910900453.2A CN201910900453A CN110737709B CN 110737709 B CN110737709 B CN 110737709B CN 201910900453 A CN201910900453 A CN 201910900453A CN 110737709 B CN110737709 B CN 110737709B
- Authority
- CN
- China
- Prior art keywords
- formula
- data
- database
- field
- defining
- 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/25—Integrating or interfacing systems involving database management systems
- G06F16/254—Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
-
- 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
-
- 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/2291—User-Defined Types; Storage management thereof
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)
- Software Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a formula model generation method based on a visual editing system, and relates to the technical field of visual editing. The invention comprises making formula library; defining formula reference rules; integrating the heterogeneous data sources into a data model corresponding to the database by using Java service; extracting data in the data model into a database; customizing the field by using a formula editor; and the rear-end Java server maps the received custom fields into corresponding data records in the database and acquires the data records according to the SQL query language. According to the method, by defining a formula and a formula reference rule, a Java service is utilized to integrate a heterogeneous data source into a data model corresponding to a database, and then the database is used as an analyzer to analyze the formula; the processing capacity of different data sources is enhanced, the expandability of the formula is enhanced, and the data processing performance is improved.
Description
Technical Field
The invention belongs to the technical field of visual editing, and particularly relates to a formula model generation method based on a visual editing system.
Background
Formulas in the existing graphical interface are all made through an editor and a parser, and the parser depends on the grammar of the language, such as Java, javascript, python and the like. Because of the variety of data sources, the related databases, the non-related databases, the text files, the APIs, and the like, and the languages corresponding to different data sources are inconsistent, the parser depending on the data source is too complicated, and if a brand-new parsing rule is developed to support such a variety of data, the project is too complicated and the extensibility is not strong.
The BI system is a set of visual editing system for rapidly generating a data analysis interface through dragging. The design mode of the BI visualization interface is as follows: the method comprises the steps of taking a canvas as a carrier, dragging various chart cards on the canvas by a user, configuring data and style attributes of the cards, and finally rendering an analysis interface meeting the requirements of the user.
When the data attribute of the card is configured, if the native field can not meet the requirement, 2 types can be solved, wherein the first type is to modify a data model and add the required field; the second is to customize a field whose valid range is limited to the card. If the required range of use is wide, the first scheme can be used; if only the card is acted upon, a second scheme may be selected; the custom field is formed by combining various function functions and fields.
Disclosure of Invention
The invention aims to provide a formula model generation method based on a visual editing system, which integrates a heterogeneous data source into a data model corresponding to a database by defining a formula and a formula reference rule and utilizing Java service, and then utilizes the database as an analyzer to analyze the formula; the processing capacity of different data sources is enhanced, the expandability of the formula is enhanced, and the data processing performance is improved.
In order to solve the technical problems, the invention is realized by the following technical scheme:
the invention relates to a formula model generation method based on a visual editing system, which comprises the following steps:
s00: making a formula library comprising basic mathematical operation, aggregation operation, character string operation, logic operation and date and time operation;
s01: defining a formula reference rule: if the native field is referenced in the formula, then the native field is referenced with [ ]; if the character string constant is quoted in the formula, then quoted by' is used;
s02: integrating the heterogeneous data sources into a data model corresponding to the database by using Java service; extracting data in the data model into a database;
s03: customizing the field by using a formula editor;
s04: and the rear-end Java server maps the received custom fields into corresponding data records in the database and acquires the data records according to the SQL query language.
Preferably, the library of formulas in S00 is embodied as the following table content:
preferably, if the required formula is not in the formula library, the formula is customized and stored in the formula library; the process of customizing the database is as follows:
and (3) modifying a data model mode: adding the required field into the existing data model;
the field self-defining mode is as follows: a field is defined within the card.
Preferably, the data model refers to integrating different data contents into a new set according to business needs in a certain association manner; the card refers to the bearing range of one component; the native field refers to a field present in a data model; the custom field refers to a field which is not present in the data model and is added by the user as required.
Preferably, the data sources in S02 include: mysql, sqlserver, oracle, postgreSQL, excel, CSV, RESTful API, mongoDB.
The invention has the following beneficial effects:
1. according to the method, by defining a formula and a formula reference rule, a Java service is utilized to integrate a heterologous data source into a data model corresponding to a database, and then the database is used as an analyzer to analyze the formula; the processing capacity of different data sources is enhanced, the expandability of the formula is enhanced, and the data processing performance is improved;
2. if the needed formula is not in the formula library, the formula can be customized by modifying the data model mode and the custom field mode and stored in the formula library; the expansibility is strong, and the data processing capability is improved.
Of course, it is not necessary for any product to practice the invention to achieve all of the above-described advantages at the same time.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings used in the description of the embodiments will be briefly introduced below, and it is obvious that the drawings in the following description are only some embodiments of the present invention, and it is obvious for those skilled in the art that other drawings can be obtained according to the drawings without creative efforts.
FIG. 1 is a flow chart of a method for generating a formula model based on a visual editing system according to the present invention;
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.
Referring to fig. 1, the present invention is a method for generating a formula model based on a visual editing system, including the following steps:
s00: making a formula library comprising basic mathematical operation, aggregation operation, character string operation, logic operation and date and time operation;
s01: defining formula reference rules: if the native field is referenced in the formula, the native field is referenced by [ ]; if the character string constant is quoted in the formula, the quoting is used';
s02: integrating the heterogeneous data sources into a data model corresponding to the database by using Java service; extracting data in the data model into a database;
s03: customizing the field by using a formula editor;
s04: and the rear-end Java server maps the received custom fields into corresponding data records in the database and acquires the data records according to the SQL query language.
Wherein, the formula library in S00 is specified by the following table contents:
if the needed formula is not in the formula library, self-defining the formula and storing the formula in the formula library; the process of customizing the database is as follows:
and (3) modifying a data model mode: adding the required field into the existing data model;
the field self-defining mode is as follows: fields are defined within the card.
The data model refers to integrating different data contents into a new set according to business requirements in a certain association mode; card refers to the carrying range of a component; native fields refer to fields that exist in the data model; custom fields refer to fields that are not present in the data model that the user adds as needed.
Wherein, the data source in S02 includes: mysql, sqlserver, oracle, postgreSQL, excel, CSV, RESTful API, mongoDB.
It should be noted that, in the above system embodiment, each included unit is only divided according to functional logic, but is not limited to the above division as long as the corresponding function can be implemented; in addition, the specific names of the functional units are only for the convenience of distinguishing from each other, and are not used for limiting the protection scope of the present invention.
In addition, it is understood by those skilled in the art that all or part of the steps in the method for implementing the embodiments described above may be implemented by a program instructing associated hardware, and the corresponding program may be stored in a computer-readable storage medium.
The preferred embodiments of the invention disclosed above are intended to be illustrative only. The preferred embodiments are not intended to be exhaustive or to limit the invention to the precise embodiments disclosed. Obviously, many modifications and variations are possible in light of the above teaching. The embodiments were chosen and described in order to best explain the principles of the invention and the practical application, to thereby enable others skilled in the art to best utilize the invention. The invention is limited only by the claims and their full scope and equivalents.
Claims (3)
1. The formula model generation method based on the visual editing system is characterized by comprising the following steps of:
s00: making a formula library comprising basic mathematical operation, aggregation operation, character string operation, logic operation and date and time operation;
s01: defining formula reference rules: if the native field is referenced in the formula, the native field is referenced by [ ]; if the character string constant is quoted in the formula, then quoted by' is used;
s02: integrating the heterogeneous data sources into a data model corresponding to the database by using Java service; extracting data in a data model into a database, wherein the data model integrates different data contents into a new set according to a certain association mode according to business needs;
if the needed formula is not in the formula library, self-defining the formula and storing the formula in the formula library; the self-defining formula process is as follows:
and (3) modifying a data model mode: adding the required field into the existing data model;
the field self-defining mode is as follows: defining a character in a card, wherein the card refers to the bearing range of one component; the native fields refer to fields that exist in the data model; the custom field does not exist in the data model, and is added by a user as required;
s03: customizing the field by using a formula editor;
s04: and the rear-end Java server maps the received custom fields into corresponding data records in the database and acquires the data records according to the SQL query language.
2. The method for generating a formula model based on a visual editing system according to claim 1, wherein the formula library in S00 is specified by the following table contents:
3. the method for generating a formula model based on a visual editing system according to claim 1, wherein the data source in S02 comprises: mysql, sqlserver, oracle, postgreSQL, excel, CSV, RESTful API, mongoDB.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910900453.2A CN110737709B (en) | 2019-09-23 | 2019-09-23 | Formula model generation method based on visual editing system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910900453.2A CN110737709B (en) | 2019-09-23 | 2019-09-23 | Formula model generation method based on visual editing system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110737709A CN110737709A (en) | 2020-01-31 |
| CN110737709B true CN110737709B (en) | 2022-10-28 |
Family
ID=69269453
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910900453.2A Active CN110737709B (en) | 2019-09-23 | 2019-09-23 | Formula model generation method based on visual editing system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110737709B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113672211A (en) * | 2021-08-10 | 2021-11-19 | 山西省通信管理局 | Method and device for performing big data analysis and visual development on heterogeneous multi-data source |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101714157A (en) * | 2009-09-29 | 2010-05-26 | 金蝶软件（中国）有限公司 | Method, device and heterogeneous database system for generating heterogeneous database report |
| CN104484156A (en) * | 2014-12-16 | 2015-04-01 | 用友软件股份有限公司 | Editing method for multilingual formula, editing system for multilingual formula and editor for multilingual formula |
| CN106227896A (en) * | 2016-08-28 | 2016-12-14 | 杭州合众数据技术有限公司 | A kind of big data visualization fractional analysis method |
| CN106372152A (en) * | 2016-08-30 | 2017-02-01 | 西安美林数据技术股份有限公司 | Online form developing system |
| US20180357273A1 (en) * | 2017-06-07 | 2018-12-13 | Sap Se | Data model extension generation |
| CN110134685A (en) * | 2019-05-06 | 2019-08-16 | 武汉中岩测控技术有限公司 | A kind of monitoring method and system based on big data field automatic Mosaic algorithm |
-
2019
- 2019-09-23 CN CN201910900453.2A patent/CN110737709B/en active Active
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101714157A (en) * | 2009-09-29 | 2010-05-26 | 金蝶软件（中国）有限公司 | Method, device and heterogeneous database system for generating heterogeneous database report |
| CN104484156A (en) * | 2014-12-16 | 2015-04-01 | 用友软件股份有限公司 | Editing method for multilingual formula, editing system for multilingual formula and editor for multilingual formula |
| CN106227896A (en) * | 2016-08-28 | 2016-12-14 | 杭州合众数据技术有限公司 | A kind of big data visualization fractional analysis method |
| CN106372152A (en) * | 2016-08-30 | 2017-02-01 | 西安美林数据技术股份有限公司 | Online form developing system |
| US20180357273A1 (en) * | 2017-06-07 | 2018-12-13 | Sap Se | Data model extension generation |
| CN110134685A (en) * | 2019-05-06 | 2019-08-16 | 武汉中岩测控技术有限公司 | A kind of monitoring method and system based on big data field automatic Mosaic algorithm |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110737709A (en) | 2020-01-31 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US7783971B2 (en) | Graphic object themes | |
| CN105511873B (en) | User interface control display method and device | |
| US11366856B2 (en) | System and method for updating target schema of graph model | |
| CN111538743B (en) | SQL-based data blood relationship analysis method and system | |
| US7849147B2 (en) | Method and apparatus for summarization of threads in electronic mail | |
| CN109471619A (en) | Mybatis code generating method, device and terminal | |
| CN114510611A (en) | Method and device for constructing metadata blood relationship atlas and related equipment | |
| CN111708805A (en) | Data query method and device, electronic equipment and storage medium | |
| CN110737709B (en) | Formula model generation method based on visual editing system | |
| CN110955801B (en) | Knowledge graph analysis method and system for cognos report indexes | |
| CN108763202A (en) | Method, apparatus, equipment and the readable storage medium storing program for executing of the sensitive text of identification | |
| CN109542418B (en) | Service code generation method and computer terminal | |
| CN110597821A (en) | Method and device for changing database table structure | |
| CN115794869A (en) | Implementation method and device for visual construction and generation of semantic query | |
| US20080263070A1 (en) | Common drawing objects | |
| CN112883044B (en) | Data processing method and device for database and computer readable medium | |
| CN115905353A (en) | Associated data export and import method, device, equipment and storage medium | |
| CN115934716A (en) | Method for importing Excel table data into database based on metadata definition and implementation | |
| Coddington | Aggregation and journalism | |
| CN113778421A (en) | Method and equipment for generating service code | |
| CN113656454A (en) | Comprehensive supervision modeling statistical method, device, terminal and storage medium | |
| CN112052234A (en) | Service data processing method and device, storage medium and electronic device | |
| CN111444194A (en) | Method, device and equipment for clearing indexes in block chain type account book | |
| CN114553954B (en) | Information pushing method, nonvolatile storage medium and electronic equipment | |
| CN114756554B (en) | Data query processing method based on MyBatis framework |
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 |