CN101187929A - Formula definition assembly for flexible mathematical aiming at large data of database table - Google Patents
Formula definition assembly for flexible mathematical aiming at large data of database table Download PDFInfo
- Publication number
- CN101187929A CN101187929A CNA2007101150491A CN200710115049A CN101187929A CN 101187929 A CN101187929 A CN 101187929A CN A2007101150491 A CNA2007101150491 A CN A2007101150491A CN 200710115049 A CN200710115049 A CN 200710115049A CN 101187929 A CN101187929 A CN 101187929A
- Authority
- CN
- China
- Prior art keywords
- formula
- definition
- computing
- project
- dimension
- 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
Abstract
The invention provides a formula definition groupware for agile calculation aiming at mass data in a database table. The groupware is used for solving the problem that the mass data in the database table are needed to be performed with a certain calculation sometimes in the database application, the calculation needs different logical processes according to the different values of different fields of each record, and the logical processes are made randomly when in running according to different client requirements of users, considering that different clients can have different arithmetic logics and the arithmetic logics can change often, the groupware of the invention provides the convenient operation for the client attribute individuation set, as well as the alteration, the modification and the expansion of the arithmetic logics. The groupware also provides the setting of an arithmetic item, the coefficient definition of a one dimensional list, a two dimensional list and a multidimensional table, an operational formula definition, etc., thereby having the function for realizing strong logical independence, and facilitating the application to different systems without needing secondary exploitation.
Description
Technical field
The present invention relates to a kind of Computer Applied Technology, provide a kind of logical operation formula definition assembly specifically at a large amount of customizations in the database table.The programming that customization arithmetic logic class be provided of this assembly during use in the reduced data storehouse greatly improves the stability, extendability, ease for maintenance of the development efficiency used, product etc. greatly.
Background technology
At present, when needing the customization logic to carry out computing, generally be that the mode by formula definition realizes at database table.Though present most of formula definition all uses more flexible, and operate also more convenient, but most of formula definition function all can only be carried out formula operation at the fixedly record of fixed table usually, such as report definition function commonly used, general formula definition is that a cell at form is provided with the peek logic.When can not satisfying big data quantity, such formula definition upgrades demand.Upgrading demand when realizing big data quantity at present, is again to realize by write fixing SQL statement in program generally.When the client dynamically arranged arithmetic logic according to different situations when the client need be by program run, fixedly SQL can't realize this function.Even if some has realized the product of this function, also mostly be that function is simply inflexible, underaction and convenient, the user uses trouble at ordinary times, when user's request changes, or when having new system that this type of demand is arranged, all can cause to this type of function repeat write.
Summary of the invention
The purpose of this invention is to provide a kind of formula definition assembly that carries out flexible computing at mass data in the database table, this assembly is that fixing computing project is set in computer system, the user continues to define computational item on this basis, operational formula in the computational item can only be used fixedly project and the computational item that has existed, only on fixedly project and computational item, continue the corresponding coefficient accordingly of some peeks of definition one dimension table and project, definition bivariate table and multidimensional table comprise the project of two or more one dimension tables as dimension, define two-dimentional form and multidimensional form, fill in corresponding operation coefficient; Utilize computing project, one dimension table, bivariate table and multidimensional table calculated factor as formula definition, carry out the establishment of calculation expression and conditional expression, after formula definition finishes, system is converted to defined formula to describing formula automatically, and the one dimension table that occurs in the defined formula, bivariate table and multidimensional table launched, form analytic formula, during the formal computing of formula, read analytic formula and embed among the computing SQL, carry out final logical operation.
The invention has the beneficial effects as follows that this assembly comprises setting, one dimension table, bivariate table, the definition of multidimensional table coefficient, operational formula definition of computing project etc., and the graphical operation interface is provided.Design concept supports every client that formula operation tops such as needed computing project, one dimension table, bivariate table and multidimensional table system number are set separately.And the computing project of carrying out that can be convenient, flexible is according to demand expanded.This assembly function realizes that logical independence is strong, can conveniently be applied to needn't do secondary development in the different system.
Description of drawings
Fig. 1 is a system architecture diagram of the present invention;
Fig. 2 is Data Structure Design figure of the present invention;
Fig. 3 is a uml class design drawing of the present invention.
Embodiment
Assembly of the present invention can be realized each client's personal settings, according to the major key corresponding tables, with the application combination major key of invocation component outside, corresponds to the single major key of component internal and mates, and can improve the transplantability of assembly between different system.For the power of taking into account assembly and the dirigibility of using, the mechanism that component internal has adopted multiple formula state and deposited comprises formula, defined formula, the three kinds of states of analytic formula described, respectively the formula pattern of corresponding different times.Describing formula is the Chinese expression way of formula, makes things convenient for the user to understand the formula implication; When defined formula is the formula preservation, Chinese expression formula is replaced with the understandable item field title of program, make things convenient for the calculating mechanism solution formula; Analytic formula is meant launches the various computing projects in the defined formula, can directly use when making things convenient for computing machine that formula is carried out computing.
The entire system framed structure as shown in Figure 1, at first by the computing project of the built-in plurality of fixed of system, the user can continue to define computational item on this basis.Operational formula in the computational item can only be used built-in project and the computational item that has existed.On built-in project and computational item, can continue to define the one dimension table, i.e. the corresponding corresponding coefficient of some peeks of project.The project that bivariate table and multidimensional table comprise two or more one dimension tables defines two-dimentional form and multidimensional form as dimension, fills in corresponding operation coefficient.Utilize computing project, one dimension table, bivariate table and multidimensional table calculated factor as formula definition, carry out the establishment of calculation expression and conditional expression, after formula definition finishes, system can be converted to defined formula to describing formula automatically, and, form analytic formula with the one dimension table, bivariate table and the expansion of multidimensional table that occur in the defined formula.During the formal computing of formula, read analytic formula exactly and embed among the computing SQL, carry out final logical operation.
In order to support formula definition modes such as the customization of computing project flexibly, classification coefficient, interval coefficient, bivariate table coefficient, this formula definition assembly comprises following function point:
The formula project definition: the formula project definition is system's parameter of overall importance.The formula project comprises two parts: the built-in project of system, increase into when initial in system, and forbid revising after formal the use.The customization computational item, the client in use, according to different clients' individual demand, can self-defined some computational items.All computational items need be based upon on the existing built-in project foundation.
The one dimension table definition:
Formula definition: after the definition of computing project and various coefficient is finished, just can carry out the definition of multiple operational formula to the client by the formula definition function.Formula definition provides the graphic interface of being convenient to operate, and operation expression and conditional expression that the user only need make up own needs according to each the computing project and the operational symbol of interface display get final product.
Embodiment
Assembly of the present invention may further comprise the steps and content:
Multiple formula state and the mechanism of depositing comprise formula, defined formula, the three kinds of states of analytic formula described, respectively the formula pattern of corresponding different times.Describing formula is the Chinese expression way of formula, makes things convenient for the user to understand the formula implication; When defined formula is the formula preservation, Chinese expression formula is replaced with the understandable item field title of program, make things convenient for the calculating mechanism solution formula; Analytic formula is meant launches the various computing projects in the defined formula (comprising direct project, computational item, various coefficient definition etc.), can directly use when making things convenient for computing machine that formula is carried out computing.The quantity contrast relationship of formula is 1: 1 under three kinds of states: n (value of n will be seen the expansion situation of multidimensional table coefficient).
The one dimension table: for convenience of the user definition formula, assembly supports the mode of one dimension table, bivariate table and multidimensional table to carry out formula definition.
The one dimension table refers to some classification value of certain computing project, and corresponding different respectively coefficients participate in formula operation.One dimension table definition such as computing project " post " is as follows, the computing item is in formula definition: radix * coefficient (post), when the formula operation of reality, meeting is converted into corresponding coefficient value and participates in computing according to the different values of the post field of every record.(realization of this function realizes by the polymorphic mechanism of formula)
| Post | Coefficient |
| The |
1 |
| Manager | 1.5 |
| The general manager (GM) | 2 |
| …… |
Bivariate table refers to two two-dimentional forms of one dimension tables intersection composition, such as two dimensions is respectively " post " and " going into to take charge of the time limit ", bivariate table A is defined as follows: the computing item is in formula definition: radix * bivariate table (A), when the formula operation of reality, can be converted into corresponding coefficient value and participate in computing according to the post and the different values of going into to take charge of two fields of the time limit (going into to take charge of the time limit can be calculated field: current date deducts the time into department) of every record.(realization of this function realizes by the polymorphic mechanism of formula)
| The academic title | Go into to take charge of the time limit | Educational background | Coefficient |
| The employee | In 3 years | |
1 |
| The employee | In 3 years | The master | 1.2 |
| The |
3 to 5 years | Undergraduate course | 1.5 |
| The |
3 to 5 years | The master | 1.7 |
| The employee | More than 5 years | Undergraduate course | 2.0 |
| The employee | More than 5 years | The master | 2.2 |
| Manager | In 3 years | Undergraduate course | 2.5 |
| Manager | In 3 years | The master | 2.2 |
| |
3 to 5 years | Undergraduate course | 3.0 |
| |
3 to 5 years | The master | 3.2 |
| Manager | More than 5 years | Undergraduate course | 3.5 |
| Manager | More than 5 years | The master | 3.7 |
| … | … | … | … |
Externally provide primary clustering to comprise: to carry out increase, modification, deletion of formula etc. according to outside major key; Carry out duplicating and shifting of formula information according to outside major key; According to different data characteristics, obtain relevant formula information.Following assembly all has some overload function of different parameters:
SaveParam (): preserve the related operation project;
SaveFormula (): preserve correlation formula information;
DelFormula (): deletion correlation formula information;
GetParamList (): obtain relevant parameter list;
GetFormulaList (): obtain relevant formula tabulation;
CopyFormulas (): duplicate and the formula information of mobile appointment;
Express (): analytic formula.Be mainly used in the conversion between the formula different conditions.
Assembly of the present invention may be used in the financial relevant industries, such as bank, security, supplementary pension etc.With the supplementary pension is example, in supplementary pension account guard system, through regular meeting handle the paying the fees of some enterprise plan and personal plan, belong to, business such as payment.This type of business usually need be at several ten thousand even hundreds of thousands bar record, carry out different calculation process according to the different field attribute of each bar record.Assembly of the present invention is successful Application in several similar systems, and the quick exploitation under the prerequisite of guaranteeing both quality and quantity provides powerful technical support to system!
Claims (2)
1. carry out the formula definition assembly of flexible computing at mass data in the database table, it is characterized in that in computer system, being provided with fixing computing project, the user continues to define computational item on this basis, operational formula in the computational item can only be used fixedly project and the computational item that has existed, only on fixedly project and computational item, continue the corresponding coefficient accordingly of some peeks of definition one dimension table and project, definition bivariate table and multidimensional table comprise the project of two or more one dimension tables as dimension, define two-dimentional form and multidimensional form, fill in corresponding operation coefficient; Utilize computing project, one dimension table, bivariate table and multidimensional table calculated factor as formula definition, carry out the establishment of calculation expression and conditional expression, after formula definition finishes, system is converted to defined formula to describing formula automatically, and the one dimension table that occurs in the defined formula, bivariate table and multidimensional table launched, form analytic formula, during the formal computing of formula, read analytic formula and embed among the computing SQL, carry out final logical operation.
2. want 1 described formula definition assembly according to right, it is characterized in that assembly comprises following content:
1) major key corresponding tables: will call the combination major key of the applications of this assembly, and correspond to the single major key of component internal and mate, to improve the transplantability of assembly between different system;
2) polymorphic formula: for the power of taking into account assembly and the dirigibility of using, the multiple formula state of employing comprises formula, defined formula, the three kinds of states of analytic formula described, and three kinds of states are also deposited and the formula pattern of corresponding different times respectively;
The description formula is meant: formula is expressed in Chinese mode, makes things convenient for the user to understand the formula implication;
Defined formula is meant: when formula is preserved, Chinese expression formula is replaced with the understandable item field title of program, make things convenient for the calculating mechanism solution formula;
Analytic formula is meant: with the expansion of the direct project in the defined formula, computational item, the definition of various coefficient, directly use when making things convenient for computing machine that formula is carried out computing;
The quantity contrast relationship of formula is 1: 1 under three kinds of states: n, the expansion situation of the value representation multidimensional table coefficient of n;
3) one dimension table: for convenience of the user definition formula, assembly supports the mode of one dimension table, bivariate table and multidimensional table to carry out formula definition, and wherein the one dimension table refers to some classification value of certain computing project, and corresponding different respectively coefficients participate in formula operation;
Such as the one dimension table of computing project " post ", the computing item is in formula definition: radix * coefficient, and when the formula operation of reality, meeting is converted into corresponding coefficient value and participates in computing according to the different values of the post field of every record;
4) bivariate table refers to two two-dimentional forms of one dimension tables intersection composition, such as two dimensions is respectively " post " and " going into to take charge of the time limit ", bivariate table A is defined as follows: the computing item is in formula definition: radix * bivariate table (A), when the formula operation of reality, can be converted into corresponding coefficient value and participate in computing according to the post and the different values of going into to take charge of two fields of the time limit of every record.Going into to take charge of the time limit is calculated field: current date deducts the time into department;
5) the multidimensional table refers to surpass two one dimension tables intersections and forms the multidimensional form, the same bivariate table of principle:
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNA2007101150491A CN101187929A (en) | 2007-12-05 | 2007-12-05 | Formula definition assembly for flexible mathematical aiming at large data of database table |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNA2007101150491A CN101187929A (en) | 2007-12-05 | 2007-12-05 | Formula definition assembly for flexible mathematical aiming at large data of database table |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN101187929A true CN101187929A (en) | 2008-05-28 |
Family
ID=39480326
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CNA2007101150491A Pending CN101187929A (en) | 2007-12-05 | 2007-12-05 | Formula definition assembly for flexible mathematical aiming at large data of database table |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101187929A (en) |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102375802A (en) * | 2010-08-23 | 2012-03-14 | 深圳市鹏海运电子数据交换有限公司 | System and method for automatically creating calculation formula |
| CN103258121A (en) * | 2013-04-25 | 2013-08-21 | 重庆图珀信息技术有限公司 | Clinical blood transfusion evaluating system and evaluating method |
| CN105630761A (en) * | 2016-03-04 | 2016-06-01 | 中国建设银行股份有限公司 | Method and device for manipulating formulas |
| CN106201539A (en) * | 2016-07-18 | 2016-12-07 | 浪潮通用软件有限公司 | A kind of method realizing accounting item dynamic calculation in Star Model |
| CN108133168A (en) * | 2016-12-01 | 2018-06-08 | 北京新唐思创教育科技有限公司 | Formula searching method and its device in a kind of text identification |
| CN109033059A (en) * | 2018-08-15 | 2018-12-18 | 优信数享（北京）信息技术有限公司 | A kind of calculation method and device of list data |
-
2007
- 2007-12-05 CN CNA2007101150491A patent/CN101187929A/en active Pending
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102375802A (en) * | 2010-08-23 | 2012-03-14 | 深圳市鹏海运电子数据交换有限公司 | System and method for automatically creating calculation formula |
| CN103258121A (en) * | 2013-04-25 | 2013-08-21 | 重庆图珀信息技术有限公司 | Clinical blood transfusion evaluating system and evaluating method |
| CN105630761A (en) * | 2016-03-04 | 2016-06-01 | 中国建设银行股份有限公司 | Method and device for manipulating formulas |
| CN105630761B (en) * | 2016-03-04 | 2019-03-12 | 中国建设银行股份有限公司 | Formula processing method and device |
| CN106201539A (en) * | 2016-07-18 | 2016-12-07 | 浪潮通用软件有限公司 | A kind of method realizing accounting item dynamic calculation in Star Model |
| CN108133168A (en) * | 2016-12-01 | 2018-06-08 | 北京新唐思创教育科技有限公司 | Formula searching method and its device in a kind of text identification |
| CN108133168B (en) * | 2016-12-01 | 2021-04-30 | 北京新唐思创教育科技有限公司 | Formula searching method and device in text recognition |
| CN109033059A (en) * | 2018-08-15 | 2018-12-18 | 优信数享（北京）信息技术有限公司 | A kind of calculation method and device of list data |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US9292306B2 (en) | System, multi-tier interface and methods for management of operational structured data | |
| US9740992B2 (en) | Data warehouse system | |
| US9684703B2 (en) | Method and apparatus for automatically creating a data warehouse and OLAP cube | |
| US9477786B2 (en) | System for metadata management | |
| Tvrdíková | Support of decision making by business intelligence tools | |
| Dolk | Integrated model management in the data warehouse era | |
| WO2018236886A1 (en) | System and method for code and data versioning in computerized data modeling and analysis | |
| CN106407170A (en) | Rapid generation method and system for data report | |
| CN101452485A (en) | Method and device for generating multidimensional cubic based on relational database | |
| EP1747517A1 (en) | Method and apparatus for automatically creating a data warehouse and olap cube | |
| US20120005151A1 (en) | Methods and systems of content development for a data warehouse | |
| CN101187929A (en) | Formula definition assembly for flexible mathematical aiming at large data of database table | |
| US20140229222A1 (en) | Integrated project planning and management application | |
| EP1225528A2 (en) | Data warehouse system | |
| Hancock et al. | Practical Business Intelligence with SQL Server 2005 | |
| US20070239587A1 (en) | System and Method For Dynamically Utilizing and Managing Financial, Operational, and Compliance Data | |
| US8706578B2 (en) | Using account symbols instead of general ledger accounts in the transaction messages of the business applications of an enterprise | |
| Stefanovic et al. | Composite web information system for management of water resources | |
| Dunlop | Beginning Big Data with Power BI and Excel 2013: Big Data Processing and Analysis Using PowerBI in Excel 2013 | |
| US20180039681A1 (en) | Method of organizing multiple hierarchical data structures in a single normalized structure of relational database for automation of data process design and for discovery analysis. | |
| Gallo et al. | Data warehouse design and management: theory and practice | |
| Stefanov et al. | Explaining data warehouse data to business users-a model-based approach to business metadata | |
| Huawei Technologies Co., Ltd. | Database Design Fundamentals | |
| Ruvolo | Business Intelligence: concepts and application-Implementation of an Intelligent Planning through software Board | |
| Tvrdíková et al. | Implementation of Business Intelligence as the" Software as a Service"-The Opportunity for Small and Medium-Sized Companies. |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C02 | Deemed withdrawal of patent application after publication (patent law 2001) | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Open date: 20080528 |