CN110737709A - Formula model method based on visual editing system - Google Patents
Formula model method based on visual editing system Download PDFInfo
- Publication number
- CN110737709A CN110737709A CN201910900453.2A CN201910900453A CN110737709A CN 110737709 A CN110737709 A CN 110737709A CN 201910900453 A CN201910900453 A CN 201910900453A CN 110737709 A CN110737709 A CN 110737709A
- Authority
- CN
- China
- Prior art keywords
- formula
- data
- database
- field
- model
- 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/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 method based on a visual editing system, and relates to the technical field of visual editing. The invention includes making formula base; 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 method based on a visual editing system.
Background
The blocks of the parser are all dependent on the grammar of the language, such as Java, Javascript, Python and the like, because of more types of data sources, related databases, non-related databases, text files, APIs and the like, the languages corresponding to different data sources are not , the parser dependent on the data sources is too complicated, and if brand new parsing rules are developed to support the data of the types, the project is too complicated and the expansibility is not strong.
As shown in FIG. 2, the BI system is visual editing systems for rapidly generating data analysis interfaces through dragging, and the design mode of the BI visual interfaces is that a user drags various chart cards on a canvas by taking the canvas as a carrier, configures data and style attributes of the cards, and finally renders analysis interfaces meeting the requirements of the user.
When configuring the data attribute of the card, if the original field can not satisfy the requirement, there are 2 kinds of solutions, is modifying the data model and adding the required field, and the second is self-defining fields, the valid range of the field is limited to the card, if the required range of use is , the scheme can be used, if only acting on the card, the second scheme can be selected, as shown in fig. 3, the self-defining field is formed by combining various function functions and fields.
Disclosure of Invention
The invention aims to provide a formula model 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 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 formula reference rules: 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 formula library in S00 is embodied as the following table content:
preferably, if the needed 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 the integration of different data contents into new sets according to business needs in an associated manner specified by , the cards refer to the bearing ranges of components, the native fields refer to the fields existing in the data model, and the custom fields refer to the fields which are not existing in the data model and are added by users according to needs.
Preferably, the data source in S02 includes: 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 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;
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 that achieve all of the above-described advantages at the same time for any product that embodies the invention.
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 embodiments of the present invention, and it is obvious for those skilled in the art to obtain other drawings without creative efforts.
FIG. 1 is a flow chart of a visual editing system based formula model method of the present invention;
FIG. 2 is a schematic diagram of a visual editing system interface in the background art of the present invention;
FIG. 3 is a diagram illustrating custom fields in the background of the invention.
Detailed Description
The technical solutions in the embodiments of the present invention will be described clearly and completely with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only partial embodiments of of the present invention, rather than all embodiments.
Referring to fig. 1, the present invention is a formula model method 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, 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.
The formula library in S00 is embodied as the following table content:
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: a field is defined within the card.
The data model refers to integrating different data contents into new sets according to business needs in an associated mode determined by , the card refers to the bearing range of components, the native field refers to a field existing in the data model, and the custom field refers to a field which is not existing in the data model and is added by a user as required.
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, specific names of the functional units are only for convenience of distinguishing from each other, and are not used for limiting the protection scope of the present invention.
In addition, those skilled in the art will appreciate that all or part of the steps in the method for implementing the embodiments described above can be implemented by relevant hardware instructed by a program, and the corresponding program can be stored in 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 (5)
1. The formula model method based on the visual editing system is characterized by comprising 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, 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.
2. The method of claim 1, wherein the formula library in S00 is embodied as the following table contents:
3. the visual editing system based formula model method of claim 2, wherein 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.
4. The visual editing system-based formula model method of claim 3, wherein the data model refers to the integration of different data contents into new sets according to business needs in an -specified association manner, the card refers to the bearing range of components, the native fields refer to the fields existing in the data model, and the custom fields refer to the fields which are not existing in the data model and are added by users according to needs.
5. The visual editing system based formula model method of 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 true CN110737709A (en) | 2020-01-31 |
| CN110737709B 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) |
Cited By (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 |
Cited By (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 |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110737709B (en) | 2022-10-28 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11194793B1 (en) | Dynamically materialized views for sheets based data | |
| US7783971B2 (en) | Graphic object themes | |
| US11755606B2 (en) | Dynamically updated data sheets using row links | |
| CN105511873B (en) | User interface control display method and device | |
| US20060248039A1 (en) | Sharing of full text index entries across application boundaries | |
| CN104881275A (en) | Electronic spreadsheet generating method and device | |
| US20190147100A1 (en) | Method and apparatus for establishing intelligent question answering repository, and intelligent question answering method | |
| CN114328981B (en) | Knowledge graph establishing and data acquiring method and device based on mode mapping | |
| CN110737709B (en) | Formula model generation method based on visual editing system | |
| WO2018226255A1 (en) | Functional equivalence of tuples and edges in graph databases | |
| CN115934716A (en) | Method for importing Excel table data into database based on metadata definition and implementation | |
| CN112988796B (en) | System and method for system data retrieval | |
| CN113723047A (en) | Map construction method, device and medium based on legal document | |
| CN113157964A (en) | Method and device for searching data set through voice and electronic equipment | |
| CN112883044A (en) | Data processing method and device for database and computer readable medium | |
| CN112052234A (en) | Service data processing method and device, storage medium and electronic device | |
| CN113688176A (en) | Data query method and data query device | |
| CN114756554B (en) | Data query processing method based on MyBatis framework | |
| CN110580332A (en) | method, system, electronic device and storage medium for automatically writing product information | |
| CN112836477B (en) | Method and device for generating code annotation document, electronic equipment and storage medium | |
| CN114553954B (en) | Information pushing method, nonvolatile storage medium and electronic equipment | |
| CN115525376A (en) | Data display management method, device, storage medium and system | |
| CN117668625A (en) | Tag set generation method and device and electronic equipment | |
| Березуцкая | SQLITE MAIN COMMANDS AND THEIR COMPARISON TO SQL FOR AN ANDROID APP | |
| CN117725083A (en) | Method and system for generating SQL sentence, electronic equipment and query method |
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 |