Formula definition assembly for flexible mathematical aiming at large data of database table

A technology with a large amount of data and database, applied in the fields of electrical digital data processing, special data processing applications, computing, etc., it can solve the problems of repeated function writing, troublesome users, inflexibility and convenience, etc., and achieves strong logical independence and convenient application. Effect

Inactive Publication Date: 2008-05-28
INSPUR COMMON SOFTWARE
View PDF0 Cites 9 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

When the customer needs to dynamically set the operation logic according to different situations when the program is running, fixed SQL cannot realize this function
Even if there are some products that realize this function, most of them are simple and rigid in function, not flexible and convenient enough, and it is troublesome for users to use at ordinary times. When user needs change, or new systems have such needs, it will cause problems for such functions. Repeat writing

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Formula definition assembly for flexible mathematical aiming at large data of database table
  • Formula definition assembly for flexible mathematical aiming at large data of database table
  • Formula definition assembly for flexible mathematical aiming at large data of database table

Examples

Experimental program
Comparison scheme
Effect test

Embodiment

[0019] Components of the present invention include the following steps and content:

[0020] Primary key correspondence table: The combined primary key of the external application that calls this component is matched with the single primary key inside the component, which can improve the portability of the component between different systems.

[0021] Polymorphic formula: In order to take into account the powerful functions and flexibility of the component, the component uses the

[0022] A mechanism for the coexistence of multiple formula states, including the three states of describing formula, defining formula, and analyzing formula, which correspond to formula styles in different periods. The description formula is the Chinese expression of the formula, which is convenient for users to understand the meaning of the formula; when the definition formula is saved as a formula, the Chinese expression is replaced with the name of the item field that the program can unders...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

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 [0001] The invention relates to a computer application technology, and specifically provides a logic operation formula definition component customized for a large number of customers in a database table. This component can greatly simplify the programming of customer-defined operation logic classes in database applications, and greatly improve application development efficiency, product stability, scalability, and ease of maintenance. Background technique [0002] At present, when user-customized logic is required to perform operations on database tables, it is generally implemented through formula definition. Although most of the formula definitions are relatively flexible and easy to operate, most of the formula definition functions can only perform formula operations on fixed records in fixed tables. For example, the commonly used report definition function, the general formula definition is for A cell of the report to set the access logic. Such a formul...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
IPC IPC(8): G06F17/30
Inventor 王士勇曲丽君
Owner INSPUR COMMON SOFTWARE
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap