CN103810152A - Visualized formula editor - Google Patents
Visualized formula editor Download PDFInfo
- Publication number
- CN103810152A CN103810152A CN201310556994.0A CN201310556994A CN103810152A CN 103810152 A CN103810152 A CN 103810152A CN 201310556994 A CN201310556994 A CN 201310556994A CN 103810152 A CN103810152 A CN 103810152A
- Authority
- CN
- China
- Prior art keywords
- formula
- equation editing
- module
- editor
- equation
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a visualized formula editor which comprises a formula resource management module, a formula edition module and a formula operation module, wherein the formula resource management module is used for managing system data required to be used in formula edition; the formula edition module is used for accessing the system data from the formula resource management module and performing formula edition on the accessed system data; and the formula operation module is used for executing overall operation on edited formula. The visualized formula editor is suitable for a current enterprise office information system, correlation factors in the formula are configured to be accessed from the information system, and manual data search cost and influence on data authenticity are reduced; the formula provides storage and loading of status data, that is, the formula editor provides functions of storage of the current edited formula and loading of next time opening; the formula editor further provides a calculation function, and when the formula editor sets the formula and assigns correlated variable factors, the formula editor can calculate the result of the current formula; and the formula editor further provides a translation function, so that the application range of the formula editor is broadened.
Description
Technical field
The present invention relates to electronic information and technical field of data processing, be specifically related to the visual equation editing device under information system.
Background technology
Now the realization of formula application is mainly contained to two kinds of modes, one is to complete for every kind of formula customized development code, and a kind of is the configuration that exploitation formula configuration interface completes formula.
One, customized development method:
For the method for different formulas customized development code, be exactly the formula requirement according to demand, customize realization by the mode of writing code, the code of a corresponding a set of customization of formula.Clearly, the method cost of development is higher, and very flexible, if there is the demand of formula variation just need to rewrite code.This mode can only be applicable to the information system project that formula is less, demand is stable in actual applications.
Two, exploitation formula configuration interface:
The formula configuration interface of conventional art exploitation, can only arrange for simple formula.The performance constraint that formula arranges is more, is inconvenient to peek and calculate, and performance user directly perceived not in interface experiences bad.And formula configuration feature is had relatively high expectations to configuration personnel, be mainly used in formula relatively simple, the information system of maintenance work is set by special messenger.
Summary of the invention
The invention provides a kind of visual equation editing device, can coordinate with existing information system, by peeking, reduce the cost of artificial data search and the impact on data validity from information system, can further carry out the analysis and calculation of formula, and formula is translated simultaneously.Object of the present invention is realized by following technical scheme:
A kind of visual equation editing device, comprising: formula resource management module, needs for managing equation editing the system data of using; Equation editing module, for formula resource management module is got to system data, and carries out equation editing to got system data; And formula manipulation module, carry out integrated operation for the formula to having edited.
As concrete technical scheme, described equation editing module comprises: peek control, for getting from formula resource management module the system data that formula need to be used; Function region control, for providing the option of function of correlation formula; Sign field control, for providing the option of correlation formula symbol; Accessorial Tools Storage control, for providing the option of common tool of equation editing; Equation editing panel control, provides the editing area of formula, for the system data of selection, function and formula symbol being assembled into formula and showing.
As concrete technical scheme, described formula manipulation module comprises: formula storage unit, for the good formula sequence of equation editing device module inediting is turned to unified indicating language xml, then deposits this xml file in database; Equation editing exits unit, carries out and exits operation for the formula to equation editing module editor; Formula loading unit, for first take the xml character string of the serializing of formula from described database, then shows in equation editing module by the mode loading formula of unserializing.
As further technical scheme, described formula manipulation module also comprises: formula verification unit, for storing verification rule, check the rationality of the formula after editor according to verification rule simultaneously, and prompting.
As further technical scheme, described formula verification unit and the interlock of formula storage unit automatically triggered formula verification unit formula are first carried out to verification before formula cell stores formula.
As concrete technical scheme, described formula manipulation module also comprises: formula computing unit, being used for is formula syntax tree by the formula analysis of equation editing module inediting, then start to carry out computing from bottom Zhi Jiedian, and operation result is upwards passed to father node carry out computing, so circulation, until reach top mode and just calculated the net result of formula.
As further technical scheme, described formula manipulation module also comprises: formula translation unit, and for the formula structure of equation editing module inediting is turned to tree, in tree, each node is translated separately, then gather by tree structure, form final cypher text.
As further technical scheme, described formula translation unit is bilingual by formula translation, and one is to be translated as standard database query statement SQL, and one is to be translated as java code.
Beneficial effect of the present invention is: be applicable to the information system of current enterprise office, the correlation factor in formula is configured to peek from information system, reduces the cost of artificial data search and the impact on data validity; Formula itself provides preservation and the loading of status data, and equation editing device provides preservation and the next function of loading of opening when pre-editing formula; This equation editing device also provides computing function, and when setting formula with equation editing device, after correlated variables factor assignment, this equation editing device can calculate the result of current formula; This equation editing device also provides interpretative function, has expanded its usable range.
Accompanying drawing explanation
The main body of the visual equation editing device that Fig. 1 provides for the embodiment of the present invention forms block diagram.
The formation block diagram of equation editing module in the visual equation editing device that Fig. 2 provides for the embodiment of the present invention.
The formation block diagram of formula manipulation module in the visual equation editing device that Fig. 3 provides for the embodiment of the present invention.
The exemplary plot at the main interface of operation of the visual equation editing device that Fig. 4 provides for the embodiment of the present invention.
Embodiment
For making object, technical scheme and the advantage of the embodiment of the present invention clearer, below in conjunction with the accompanying drawing in the embodiment of the present invention, the technical scheme in the embodiment of the present invention is clearly and completely described.Obviously, described embodiment is the present invention's part embodiment, rather than whole embodiment.Based on the embodiment in the present invention, the every other embodiment that those of ordinary skills obtain under the prerequisite of not making creative work, belongs to the scope that the present invention discloses.
As shown in Figure 1, the visual equation editing device that the present embodiment provides comprises: formula resource management module, equation editing module, formula manipulation module.Describe function, structure and the principle of work of above-mentioned each module in detail below in conjunction with each accompanying drawing:
One, formula resource management module:
Formula resource management module, needs for managing all formula the system data of using, and comprises business datum, context data.Business datum is obtained by the Business Entity setting of system, as order, voucher, contract etc.; Context data is as the login tissue of current system, current month, time etc.The metadata information of these data record data in formula resource management module, shows by tree-like structure.In equation editing device, can directly resource selected in resource management module be pulled in formula by the mode pulling.Ask for an interview resource-area, Fig. 4 left side.
User needs first in formula resource management module, to specify the business datum of needs inquiry before establishment formula, for example, the formula of contract completion rate need to be set, and just need in formula resource management module, introduce business datum contract, order, credential information.The context data of formula is due to relatively stable, so equation editing device is built-in.As current login tissue, current month, time etc.
Two, equation editing module:
Shown in Fig. 2, equation editing module is used for formula resource management module to get system data, and got system data is carried out to equation editing; It comprises: peek control, function region control, sign field control, Accessorial Tools Storage control and equation editing panel control.Specific as follows:
Peek control for getting from formula resource management module the system data that formula need to be used, can be pulled in formula from the resource tree on the left side.Related data in formula can also typing voluntarily in the constant input frame of editing machine.
Function region control provides the option of the function of correlation formula, as mathematical function is asked the end, exponentiation, asked absolute value etc.; Text function is asked text size, intercepts text, is converted to small letter etc.; Date function is asked the time, increases January, is asked the moon elementary; Statistical function summation, ask variance, minimize etc.
Sign field control provides the option of correlation formula symbol, as add, subtract, multiplication and division, bracket, be greater than, be less than, with or, condition judgment, equal, be not equal to, comprise, do not comprise, branch, condition etc.
Accessorial Tools Storage control provides the option of the common tool in equation editing, and common tool comprises shearing, copy, paste, cancel and recovery etc.
Equation editing panel control provides the editing area of formula, for the system data of selection, function and formula symbol being assembled into formula and showing.In equation editing panel, can carry out equation editing by modes such as keyboard shortcut, mouse pull.In equation editing district can according to the concrete various formula of demand flexible configuration as: multiple evolution, multiple divisor, parantheses, square, branch, function be nested etc.
Three, formula manipulation module:
Shown in Fig. 3, formula manipulation module is for carrying out integrated operation to the formula of having edited; It comprises: formula storage unit, equation editing exit unit, formula loading unit, formula verification unit, formula computing unit, formula translation unit.As detailed below:
Formula storage unit, for the good formula sequence of equation editing device module inediting is turned to unified indicating language xml, then deposits this xml file in database.Equation editing exits unit and carries out and exit operation for the formula to equation editing module editor.
Formula loading unit, for first take the xml character string of the serializing of formula from database, is then shown in equation editing module by the mode loading formula of unserializing.To the formula of having preserved, user can select formula data to pass to equation editing device, the state of equation editing device when reducing equation editing at that time, and again edit this formula.
Formula verification unit is used for storing verification rule, and checks the rationality of the formula after editor according to verification rule, and prompting.This formula verification unit can link with formula storage unit, before formula cell stores formula, automatically triggers formula verification unit this formula is first carried out to verification.
It is formula syntax tree by the formula analysis of equation editing module inediting that formula computing unit is used for, then start to carry out computing from bottom Zhi Jiedian, and operation result is upwards passed to father node carry out computing, so circulation, until reach top mode and just calculated the net result of formula.
Formula calculates needs the requirement of each business function in conjunction with its business datum, and the calculating interface that directly calls equation editing device just can calculate formula, obtains result of calculation.
Formula translation unit is for turning to tree by the formula structure of equation editing module inediting, and in tree, each node is translated separately, then gathers by tree structure, forms final cypher text.The formula translation that the present embodiment provides is mainly translated as bilingual, and one is to be translated as standard database query statement SQL, and one is to be translated as java code.Perhaps, it is not to utilize this equation editing device directly to calculate later that user sets formula, and need in the time of the development environment of oneself or data base querying, calculate.If need to be in the environment of java computing formula, can select current formula translation is java code; If in the time of relational data library inquiry computing formula, can be stsndard SQL statement by current formula translation.
Claims (8)
1. a visual equation editing device, is characterized in that, comprising: formula resource management module, needs for managing equation editing the system data of using; Equation editing module, for formula resource management module is got to system data, and carries out equation editing to got system data; And formula manipulation module, carry out integrated operation for the formula to having edited.
2. visual equation editing device according to claim 1, is characterized in that, described equation editing module comprises: peek control, for getting from formula resource management module the system data that formula need to be used; Function region control, for providing the option of function of correlation formula; Sign field control, for providing the option of correlation formula symbol; Accessorial Tools Storage control, for providing the option of common tool of equation editing; Equation editing panel control, provides the editing area of formula, for the system data of selection, function and formula symbol being assembled into formula and showing.
3. visual equation editing device according to claim 1 and 2, it is characterized in that, described formula manipulation module comprises: formula storage unit, for the good formula sequence of equation editing device module inediting is turned to unified indicating language xml, then deposits this xml file in database; Equation editing exits unit, carries out and exits operation for the formula to equation editing module editor; Formula loading unit, for first take the xml character string of the serializing of formula from described database, then shows in equation editing module by the mode loading formula of unserializing.
4. visual equation editing device according to claim 3, is characterized in that, described formula manipulation module also comprises: formula verification unit, for storing verification rule, check the rationality of the formula after editor according to verification rule simultaneously, and prompting.
5. visual equation editing device according to claim 4, is characterized in that, described formula verification unit and the interlock of formula storage unit automatically triggered formula verification unit formula is first carried out to verification before formula cell stores formula.
6. visual equation editing device according to claim 3, it is characterized in that, described formula manipulation module also comprises: formula computing unit, being used for is formula syntax tree by the formula analysis of equation editing module inediting, then start to carry out computing from bottom Zhi Jiedian, and operation result is upwards passed to father node carry out computing, so circulation, until reach top mode and just calculated the net result of formula.
7. visual equation editing device according to claim 3, it is characterized in that, described formula manipulation module also comprises: formula translation unit, for the formula structure of equation editing module inediting is turned to tree, in tree, each node is translated separately, then gather by tree structure, form final cypher text.
8. visual equation editing device according to claim 7, is characterized in that, described formula translation unit is bilingual by formula translation, and one is to be translated as standard database query statement SQL, and one is to be translated as java code.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310556994.0A CN103810152A (en) | 2013-11-11 | 2013-11-11 | Visualized formula editor |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310556994.0A CN103810152A (en) | 2013-11-11 | 2013-11-11 | Visualized formula editor |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN103810152A true CN103810152A (en) | 2014-05-21 |
Family
ID=50706939
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201310556994.0A Pending CN103810152A (en) | 2013-11-11 | 2013-11-11 | Visualized formula editor |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103810152A (en) |
Cited By (16)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104102468A (en) * | 2014-07-23 | 2014-10-15 | 中国电子科技集团公司第四十一研究所 | Network analyzer formula editor and data graphic display method and device thereof |
| CN104346555A (en) * | 2014-10-31 | 2015-02-11 | 深圳市东信时代信息技术有限公司 | Salary calculation formula editing and verifying system and method |
| CN104573977A (en) * | 2015-01-24 | 2015-04-29 | 武钢集团昆明钢铁股份有限公司 | Quality data management system and method |
| CN105045575A (en) * | 2015-06-29 | 2015-11-11 | 国家电网公司 | Formula editing method and formula editing apparatus |
| CN106202020A (en) * | 2016-07-15 | 2016-12-07 | 北京道亨时代科技有限公司 | A kind of method of load case combination calculation equation editing |
| CN106528518A (en) * | 2016-11-28 | 2017-03-22 | 陕西理工学院 | WEB-based mathematical formula editing system and method |
| CN104715408B (en) * | 2015-03-19 | 2017-11-07 | 烟台海颐软件股份有限公司 | A kind of electricity transaction the Visual Implementation method based on clearing unit |
| CN109543170A (en) * | 2018-11-26 | 2019-03-29 | 深圳开立生物医疗科技股份有限公司 | Equation editing method, ultrasonic device and storage medium based on ultrasonic device |
| CN109582349A (en) * | 2018-12-05 | 2019-04-05 | 深圳开立生物医疗科技股份有限公司 | Setting method and device, the measurement method and device of measure equation |
| CN112036141A (en) * | 2020-09-01 | 2020-12-04 | 金蝶软件（中国）有限公司 | Calculation formula configuration method, data processing device and computer storage medium |
| CN112394976A (en) * | 2020-10-16 | 2021-02-23 | 深圳市科漫达智能管理科技有限公司 | Formula self-defining configuration method and related device |
| CN113159630A (en) * | 2021-05-13 | 2021-07-23 | 北京三维天地科技股份有限公司 | Method for maintaining calculation formula in laboratory information management system |
| CN113885961A (en) * | 2021-10-09 | 2022-01-04 | 上海得帆信息技术有限公司 | Method for visually realizing formula rules of aPaaS platform |
| CN114404963A (en) * | 2021-12-13 | 2022-04-29 | 杭州闪电玩网络科技有限公司 | Method, system, apparatus and medium for game value processing |
| CN115081393A (en) * | 2022-07-19 | 2022-09-20 | 上海中汇亿达金融信息技术有限公司 | Method for real-time assembling and displaying characters by expression |
| CN115935698A (en) * | 2022-12-30 | 2023-04-07 | 南京维拓科技股份有限公司 | Calculation method for design parameters in industrial design process |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1494019A (en) * | 2003-02-24 | 2004-05-05 | 上海同济启明星科技发展有限公司 | Method of realizing formula editing, calculating, managing on PDA |
| CN1553377A (en) * | 2003-05-26 | 2004-12-08 | 珠海金山软件股份有限公司 | System and method for scientific formula visual edit |
| CN101236552A (en) * | 2007-02-02 | 2008-08-06 | 国家人口计生委科学技术研究所 | Formula editing device, system and method |
| CN101377768A (en) * | 2008-09-09 | 2009-03-04 | 金蝶软件（中国）有限公司 | Method and system for calculating salary |
| CN101714133A (en) * | 2009-11-18 | 2010-05-26 | 佛山市数苑科技信息有限公司 | WEB-based mathematical formula editing system and method |
| CN101944082A (en) * | 2010-09-10 | 2011-01-12 | 中国恩菲工程技术有限公司 | Excel-like report processing method |
| CN102054130A (en) * | 2010-12-31 | 2011-05-11 | 江苏省电力公司 | System for visual configuration of power formula |
| EP2423829A1 (en) * | 2005-03-31 | 2012-02-29 | Microsoft Corporation | Scrollable and re-sizeable formula bar |
-
2013
- 2013-11-11 CN CN201310556994.0A patent/CN103810152A/en active Pending
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1494019A (en) * | 2003-02-24 | 2004-05-05 | 上海同济启明星科技发展有限公司 | Method of realizing formula editing, calculating, managing on PDA |
| CN1553377A (en) * | 2003-05-26 | 2004-12-08 | 珠海金山软件股份有限公司 | System and method for scientific formula visual edit |
| EP2423829A1 (en) * | 2005-03-31 | 2012-02-29 | Microsoft Corporation | Scrollable and re-sizeable formula bar |
| CN101236552A (en) * | 2007-02-02 | 2008-08-06 | 国家人口计生委科学技术研究所 | Formula editing device, system and method |
| CN101377768A (en) * | 2008-09-09 | 2009-03-04 | 金蝶软件（中国）有限公司 | Method and system for calculating salary |
| CN101714133A (en) * | 2009-11-18 | 2010-05-26 | 佛山市数苑科技信息有限公司 | WEB-based mathematical formula editing system and method |
| CN101944082A (en) * | 2010-09-10 | 2011-01-12 | 中国恩菲工程技术有限公司 | Excel-like report processing method |
| CN102054130A (en) * | 2010-12-31 | 2011-05-11 | 江苏省电力公司 | System for visual configuration of power formula |
Cited By (20)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104102468A (en) * | 2014-07-23 | 2014-10-15 | 中国电子科技集团公司第四十一研究所 | Network analyzer formula editor and data graphic display method and device thereof |
| CN104346555A (en) * | 2014-10-31 | 2015-02-11 | 深圳市东信时代信息技术有限公司 | Salary calculation formula editing and verifying system and method |
| CN104573977A (en) * | 2015-01-24 | 2015-04-29 | 武钢集团昆明钢铁股份有限公司 | Quality data management system and method |
| CN104715408B (en) * | 2015-03-19 | 2017-11-07 | 烟台海颐软件股份有限公司 | A kind of electricity transaction the Visual Implementation method based on clearing unit |
| CN105045575A (en) * | 2015-06-29 | 2015-11-11 | 国家电网公司 | Formula editing method and formula editing apparatus |
| CN106202020A (en) * | 2016-07-15 | 2016-12-07 | 北京道亨时代科技有限公司 | A kind of method of load case combination calculation equation editing |
| CN106528518A (en) * | 2016-11-28 | 2017-03-22 | 陕西理工学院 | WEB-based mathematical formula editing system and method |
| CN109543170B (en) * | 2018-11-26 | 2023-07-07 | 深圳开立生物医疗科技股份有限公司 | Formula editing method based on ultrasonic equipment, ultrasonic equipment and storage medium |
| CN109543170A (en) * | 2018-11-26 | 2019-03-29 | 深圳开立生物医疗科技股份有限公司 | Equation editing method, ultrasonic device and storage medium based on ultrasonic device |
| CN109582349A (en) * | 2018-12-05 | 2019-04-05 | 深圳开立生物医疗科技股份有限公司 | Setting method and device, the measurement method and device of measure equation |
| CN112036141A (en) * | 2020-09-01 | 2020-12-04 | 金蝶软件（中国）有限公司 | Calculation formula configuration method, data processing device and computer storage medium |
| CN112394976A (en) * | 2020-10-16 | 2021-02-23 | 深圳市科漫达智能管理科技有限公司 | Formula self-defining configuration method and related device |
| CN113159630B (en) * | 2021-05-13 | 2021-11-23 | 北京三维天地科技股份有限公司 | Method for maintaining calculation formula in laboratory information management system |
| CN113159630A (en) * | 2021-05-13 | 2021-07-23 | 北京三维天地科技股份有限公司 | Method for maintaining calculation formula in laboratory information management system |
| CN113885961A (en) * | 2021-10-09 | 2022-01-04 | 上海得帆信息技术有限公司 | Method for visually realizing formula rules of aPaaS platform |
| CN113885961B (en) * | 2021-10-09 | 2024-07-26 | 上海得帆信息技术有限公司 | Method for realizing visualization of formula rule of aPaaS platform |
| CN114404963A (en) * | 2021-12-13 | 2022-04-29 | 杭州闪电玩网络科技有限公司 | Method, system, apparatus and medium for game value processing |
| CN115081393A (en) * | 2022-07-19 | 2022-09-20 | 上海中汇亿达金融信息技术有限公司 | Method for real-time assembling and displaying characters by expression |
| CN115081393B (en) * | 2022-07-19 | 2023-09-15 | 上海中汇亿达金融信息技术有限公司 | Method for real-time assembling text display of expressions |
| CN115935698A (en) * | 2022-12-30 | 2023-04-07 | 南京维拓科技股份有限公司 | Calculation method for design parameters in industrial design process |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103810152A (en) | Visualized formula editor | |
| US11514033B2 (en) | System for providing dynamic linked panels in user interface | |
| CN102915237B (en) | The method and system of rewrite data quality rule is required according to user application | |
| KR102330547B1 (en) | Building reports | |
| US20070130113A1 (en) | Method and system for navigation and visualization of data in relational and/or multidimensional databases | |
| CN107844299A (en) | Method for implementing Web application development tool | |
| US9746932B2 (en) | Gesture inferred vocabulary bindings | |
| US9646004B2 (en) | Hierarchical database report generation with automated query generation for placeholders | |
| CN104699742A (en) | Extreme visualization enabling extension for large data sets | |
| CN105487864A (en) | Method and device for automatically generating code | |
| CN104133772A (en) | Automatic test data generation method | |
| US10296505B2 (en) | Framework for joining datasets | |
| RU2010114245A (en) | GENERAL MODEL EDITING SYSTEM | |
| US20210232374A1 (en) | Integrated System for Designing a User Interface | |
| US20080263142A1 (en) | Meta Data Driven User Interface System and Method | |
| CN112527373A (en) | Visual platform expanding method based on operation integrated management center service | |
| CN109213480B (en) | Method, storage medium, equipment and system for developing background management page | |
| US20110179397A1 (en) | Systems and methods for metamodel transformation | |
| US9280361B2 (en) | Methods and systems for a real time transformation of declarative model and layout into interactive, digital, multi device forms | |
| CN108090205A (en) | A kind of army rear service data system for unified management based on J2EE | |
| US10203841B2 (en) | In place creation of objects | |
| CN115794967B (en) | Method and device for synchronously generating relation data mapping and semantic ontology | |
| Schuler et al. | Rule-based generation of mobile user interfaces | |
| CN115705375A (en) | Tree component rendering method and device | |
| Mou et al. | Visual orchestration and autonomous execution of distributed and heterogeneous computational biology pipelines |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20140521 |
|
| RJ01 | Rejection of invention patent application after publication |