CN115586888A - Data management method and system for configured budget - Google Patents
Data management method and system for configured budget Download PDFInfo
- Publication number
- CN115586888A CN115586888A CN202211220107.8A CN202211220107A CN115586888A CN 115586888 A CN115586888 A CN 115586888A CN 202211220107 A CN202211220107 A CN 202211220107A CN 115586888 A CN115586888 A CN 115586888A
- Authority
- CN
- China
- Prior art keywords
- budget
- template
- user
- data management
- 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.)
- Granted
Links
- 238000013523 data management Methods 0.000 title claims abstract description 31
- 238000000034 method Methods 0.000 title claims abstract description 24
- 238000010276 construction Methods 0.000 claims abstract description 8
- 238000009877 rendering Methods 0.000 claims description 20
- 238000012800 visualization Methods 0.000 claims description 16
- 239000000126 substance Substances 0.000 claims description 2
- 238000007726 management method Methods 0.000 description 6
- 238000010586 diagram Methods 0.000 description 4
- 230000009286 beneficial effect Effects 0.000 description 2
- 230000008520 organization Effects 0.000 description 2
- 230000004075 alteration Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/30—Creation or generation of source code
- G06F8/34—Graphical or visual programming
-
- 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/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/186—Templates
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/30—Creation or generation of source code
- G06F8/38—Creation or generation of source code for implementing user interfaces
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/70—Software maintenance or management
- G06F8/71—Version control; Configuration management
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- General Engineering & Computer Science (AREA)
- Software Systems (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- Computer Security & Cryptography (AREA)
- Human Computer Interaction (AREA)
- Data Mining & Analysis (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
The invention provides a data management method and a data management system for budget allocation, wherein the method comprises the following steps: configuring budget dimensions and storing the budget dimensions in a relational database; the configured content includes the name of the budget dimension; responding to the template construction operation of a user, and constructing a budget template according to the budget dimensions stored in the relational database; the template information of the budget template comprises a template name, a budget type, a budget period and options corresponding to the budget dimension; responding to the template selection operation of the user, calling the template information corresponding to the budget template selected by the user to transmit to a front-end interface, and visualizing the template information corresponding to the budget template selected by the user. Compared with the prior art, the budget dimension is configured, and the budget template is constructed based on the budget dimension configured in the relational database, so that compared with the prior art, the operation is simple, and a large amount of workload is saved; the new different types of budgets are increased and realized by constructing different templates, so that the method has higher expansibility.
Description
Technical Field
The present invention relates to the field of budget management data processing, and in particular, to a data management method and system for configuring a budget.
Background
With the development of various emerging industries, different enterprises gradually have diversified demands for budget management due to new business models and operation requirements. For example, there may be large differences in the dimensions involved in the budget, the objects used, or the span of statistical time.
At present, the prior art mainly adopts a customized development strategy aiming at different requirements. This in turn results in the configuration of budget data requiring extensive code development with significant labor costs. Moreover, if a new budget requirement appears in the same or similar enterprise along with the development of the industry or policy, the customized budget configuration technology has higher difficulty in performing corresponding fast iteration on budget management data along with the new emerging requirement, and has high iteration cost and low expansibility.
Disclosure of Invention
The invention provides a data management method and a data management system for budget configuration, which solve the technical problem of how to improve expansibility by configuring budget dimensions and constructing a budget template.
In order to solve the foregoing technical problem, an embodiment of the present invention provides a data management method for configuring a budget, including:
configuring budget dimensionality and storing the budget dimensionality to a relational database; wherein the configured content includes a name of the budget dimension;
responding to the template construction operation of a user, and constructing a budget template according to the budget dimensions stored in the relational database; the template information of the budget template comprises a template name, a budget type, a budget period and options corresponding to the budget dimension;
responding to the template selection operation of the user, calling the template information corresponding to the budget template selected by the user to transmit to a front-end interface, and visualizing the template information corresponding to the budget template selected by the user.
Preferably, the configured content further comprises a data source table, a data name display column, a data unique main key column, a data query interface and a necessity option.
As a preferred scheme, the visualizing the template information corresponding to the budget template selected by the user specifically includes:
analyzing a protocol corresponding to the budget template selected by the user, and determining a rendering style;
and dynamically rendering a front-end interface according to the rendering style so as to realize visualization of the template information corresponding to the budget template selected by the user.
Preferably, the data management method further includes: and responding to the filling operation of the user, and updating the budget information corresponding to the template selected by the user according to the data filled by the user.
Preferably, the template information is a configurable item.
Correspondingly, the invention also provides a data management system for budget allocation, which comprises an allocation module, a template construction module and a visualization module; wherein, the first and the second end of the pipe are connected with each other,
the configuration module is used for configuring budget dimensions and storing the budget dimensions in the relational database; wherein the configured content comprises a name of the budget dimension;
the template building module is used for responding to the template building operation of a user and building a budget template according to the budget dimension stored in the relational database; the template information of the budget template comprises a template name, a budget type, a budget period and options corresponding to the budget dimension;
and the visualization module is used for responding to template selection operation of a user, calling template information corresponding to the budget template selected by the user to transmit to a front-end interface, and visualizing the template information corresponding to the budget template selected by the user.
Preferably, the configured content further comprises a data source table, a data name display column, a data unique main key column, a data query interface and a necessity option.
As a preferred scheme, the visualizing module visualizes the template information corresponding to the budget template selected by the user, specifically:
the visualization module analyzes a protocol corresponding to the budget template selected by the user and determines a rendering style;
and dynamically rendering a front-end interface according to the rendering style so as to realize visualization of the template information corresponding to the budget template selected by the user.
As a preferred scheme, the data management system further includes a filling module, where the filling module is configured to respond to a filling operation of a user, and update budget information corresponding to a template selected by the user according to data filled by the user.
Preferably, the template information is a configurable item.
Compared with the prior art, the embodiment of the invention has the following beneficial effects:
the embodiment of the invention provides a data management method and a system for allocated budgets, wherein the method comprises the following steps: configuring budget dimensions and storing the budget dimensions in a relational database; wherein the configured content comprises a name of the budget dimension; responding to the template construction operation of a user, and constructing a budget template according to the budget dimension stored in the relational database; the template information of the budget template comprises a template name, a budget type, a budget period and options corresponding to the budget dimension; responding to the template selection operation of the user, calling the template information corresponding to the budget template selected by the user to transmit to a front-end interface, and visualizing the template information corresponding to the budget template selected by the user. Compared with the prior art, the budget dimension is configured, the budget template is constructed based on the budget dimension configured in the relational database, the operation is simple and a large amount of workload is saved compared with a budget management method developed through customization; and the new different types of budgets are increased by constructing different templates, so that the method has higher expansibility compared with the prior art.
Drawings
FIG. 1: the present invention provides a flow chart of an embodiment of a data management method for configuring budget.
FIG. 2 is a schematic diagram: the invention provides a schematic diagram of the dimension of the configuration budget.
FIG. 3: the invention provides a schematic diagram for constructing a budget template.
FIG. 4: the invention provides a schematic structural diagram of an embodiment of a data management system for configuring budgets.
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 obtained by a person skilled in the art without inventive step based on the embodiments of the present invention, are within the scope of protection of the present invention.
The first embodiment is as follows:
referring to fig. 1, fig. 1 is a data management method for budget allocation according to an embodiment of the present invention, including steps S1 to S3,
s1, configuring budget dimensions and storing the budget dimensions in a relational database; wherein the configured content includes the name of the budget dimension.
In this embodiment, the configuration content includes, but is not limited to, the name of the budget dimension, the data source table, the data name display column, the data unique primary key column, the data query interface, and whether options are necessary.
It should be noted that the configuration of the budget dimension specifically refers to the display dimension information of the budget. Specifically, referring to fig. 2, the budget dimension may further include an associated entity table (the data source table), an entity table ID field (the data unique primary key column), an entity table name field, a dimension value query interface (the data query interface), a dimension value query field, and the like.
In this embodiment, the data source table may look up the name of the table in the relational database; the data name display column is mainly used for displaying dimension data; the data query interface is used as an interface of a dimension data source when a budget is newly added; whether the option is necessary or not is mainly to confirm whether the budget dimension needs default selection (if the budget dimension needs default selection, reconfiguration is not needed) when the budget template is newly added.
And storing the configured budget dimension into a relational database so as to facilitate the step S2 to call the configured budget dimension.
S2, responding to template construction operation of a user, and constructing a budget template according to the budget dimensions stored in the relational database; the template information of the budget template comprises a template name, a budget type, a budget period and options corresponding to the budget dimension.
In this embodiment, an operation instruction of a user is obtained, and a template building operation of the user is responded. At this time, a budget template is constructed according to the configured budget dimension, and referring to fig. 3, the template information includes, but is not limited to, a template name, a budget type, a budget period, a budget object, a visible range, and options corresponding to the budget dimension. The template information is all configurable items, and the user can customize the template information according to the requirement through a front-end interface.
As an example of this embodiment, the budget period refers to a time range of budget, and may include fields such as annual budget, quarterly budget, or monthly budget. When the demands such as export and the like exist, the budgets are classified according to the time range and the span, so that the corresponding budgets needing to be queried can be conveniently and quickly queried.
Further, the budget use object may be used, for example, by an organization or by a dealer. Options for the budget dimension may include a cost subject dimension, a brand dimension, and an item dimension, among others. By modularly configuring the template, a user can select the modules (namely template information) by himself, and the template is built by himself according to requirements, so that budget management efficiency is improved.
And S3, responding to the template selection operation of the user, calling the template information corresponding to the budget template selected by the user to transmit to a front-end interface, and visualizing the template information corresponding to the budget template selected by the user.
In this embodiment, in actual use, the user first selects a desired configured template. At the moment, responding to the template selection operation of the user, calling template information corresponding to the budget template selected by the user to transmit to a front-end interface, analyzing a protocol corresponding to the budget template selected by the user, and determining a rendering style; and dynamically rendering a front-end interface according to the rendering style so as to realize visualization of the template information corresponding to the budget template selected by the user.
Generally, there is a specified field in the protocol, and at this time, the rendering style is determined according to the value corresponding to the field. After parsing the template protocol, the dynamic sql may be assembled, querying the corresponding budget data in the template.
As a preferred implementation of this embodiment, the data management method further includes: and responding to the filling operation of the user, and updating the budget information corresponding to the template selected by the user according to the data filled by the user.
After a user constructs a plurality of templates, the user selects the required template to create the corresponding budget. At this time, it is necessary to fill in the corresponding budget information according to the template, such as but not limited to marketing organization, expense subject dimension (specifically, display expense, discount expense, or the like), year, month, and corresponding expense of budget, etc. And after the user is filled, updating budget information corresponding to the template selected by the user according to the data filled by the user, and dynamically rendering.
Correspondingly, referring to fig. 4, the invention further provides a data management system for budget configuration, which includes a configuration module 101, a template building module 102 and a visualization module 103; wherein the content of the first and second substances,
the configuration module 101 is configured to configure a budget dimension and store the budget dimension in a relational database; wherein the configured content comprises a name of the budget dimension;
the template building module 102 is configured to respond to a template building operation of a user and build a budget template according to the budget dimensions stored in the relational database; the template information of the budget template comprises a template name, a budget type, a budget period and options corresponding to the budget dimension;
the visualization module 103 is configured to respond to a template selection operation of a user, invoke template information corresponding to a budget template selected by the user to transmit to a front-end interface, and visualize template information corresponding to the budget template selected by the user.
As a further preferred embodiment, the content of the configuration further comprises a data source table, a data name display column, a data unique main key column, a data query interface and a necessity option.
As a further preferred embodiment, the visualizing module 103 visualizes the template information corresponding to the budget template selected by the user, specifically:
the visualization module 103 analyzes a protocol corresponding to the budget template selected by the user and determines a rendering style;
and dynamically rendering a front-end interface according to the rendering style so as to realize visualization of template information corresponding to the budget template selected by the user.
As a further preferred embodiment, the data management system further includes a filling module (not shown), where the filling module (not shown) is configured to respond to a filling operation of a user, and update budget information corresponding to a template selected by the user according to data filled by the user.
As a further preferred embodiment, the template information is a configurable item.
Compared with the prior art, the embodiment of the invention has the following beneficial effects:
the embodiment of the invention provides a data management method and a system for allocated budgets, wherein the method comprises the following steps: configuring budget dimensions and storing the budget dimensions in a relational database; wherein the configured content comprises a name of the budget dimension; responding to the template construction operation of a user, and constructing a budget template according to the budget dimension stored in the relational database; the template information of the budget template comprises a template name, a budget type, a budget period and options corresponding to the budget dimension; responding to the template selection operation of the user, calling the template information corresponding to the budget template selected by the user to transmit to a front-end interface, and visualizing the template information corresponding to the budget template selected by the user. Compared with the prior art, the budget dimension is configured, the budget template is constructed based on the budget dimension configured in the relational database, the operation is simple and a large amount of workload is saved compared with a budget management method developed through customization; and the new different types of budgets are increased by constructing different templates, so that the method has higher expansibility compared with the prior art.
The above-mentioned embodiments are provided to further explain the objects, technical solutions and advantages of the present invention in detail, and it should be understood that the above-mentioned embodiments are only examples of the present invention and are not intended to limit the scope of the present invention. It should be understood that various changes, substitutions and alterations can be made herein without departing from the spirit and scope of the invention as defined by the appended claims.
Claims (10)
1. A data management method for configuring a budget, comprising:
configuring budget dimensions and storing the budget dimensions in a relational database; wherein the configured content includes a name of the budget dimension;
responding to the template construction operation of a user, and constructing a budget template according to the budget dimension stored in the relational database; the template information of the budget template comprises a template name, a budget type, a budget period and options corresponding to the budget dimension;
responding to the template selection operation of the user, calling the template information corresponding to the budget template selected by the user to transmit to a front-end interface, and visualizing the template information corresponding to the budget template selected by the user.
2. The method for data management of configured budget of claim 1, wherein the configured content further comprises a data source table, a data name display column, a data unique primary key column, a data query interface and a necessity option.
3. The data management method for configuring budget according to claim 1, wherein the visualizing template information corresponding to the budget template selected by the user specifically includes:
analyzing a protocol corresponding to the budget template selected by the user and determining a rendering style;
and dynamically rendering a front-end interface according to the rendering style so as to realize visualization of template information corresponding to the budget template selected by the user.
4. The data management method for configuring budgets of claim 3, wherein the data management method further comprises: and responding to the filling operation of the user, and updating the budget information corresponding to the template selected by the user according to the data filled by the user.
5. The method for data management of configured budget according to any one of claims 1 to 4, wherein the template information is configurable.
6. A data management system for configuring budget is characterized by comprising a configuration module, a template construction module and a visualization module; wherein the content of the first and second substances,
the configuration module is used for configuring budget dimensions and storing the budget dimensions in the relational database; wherein the configured content comprises a name of the budget dimension;
the template building module is used for responding to the template building operation of a user and building a budget template according to the budget dimension stored in the relational database; the template information of the budget template comprises a template name, a budget type, a budget period and options corresponding to the budget dimension;
and the visualization module is used for responding to template selection operation of a user, calling template information corresponding to the budget template selected by the user to transmit to a front-end interface, and visualizing the template information corresponding to the budget template selected by the user.
7. The budget-configured data management system according to claim 6, wherein the configured content further comprises a data source table, a data name display column, a data unique primary key column, a data query interface and a necessity option.
8. The data management system for budget configuration according to claim 6, wherein the visualization module visualizes template information corresponding to the budget template selected by the user, specifically:
the visualization module analyzes a protocol corresponding to the budget template selected by the user and determines a rendering style;
and dynamically rendering a front-end interface according to the rendering style so as to realize visualization of the template information corresponding to the budget template selected by the user.
9. The data management system for budget allocation according to claim 8, wherein the data management system further includes a fill-in module, and the fill-in module is configured to respond to a fill-in operation of a user, and update budget information corresponding to the template selected by the user according to data filled in by the user.
10. The budget-allocated data management system according to any one of claims 6 to 9, wherein the template information is a configurable item.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202211220107.8A CN115586888B (en) | 2022-10-08 | 2022-10-08 | Data management method and system for configuring budget |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202211220107.8A CN115586888B (en) | 2022-10-08 | 2022-10-08 | Data management method and system for configuring budget |
Publications (2)
Publication Number | Publication Date |
---|---|
CN115586888A true CN115586888A (en) | 2023-01-10 |
CN115586888B CN115586888B (en) | 2024-04-16 |
Family
ID=84773369
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN202211220107.8A Active CN115586888B (en) | 2022-10-08 | 2022-10-08 | Data management method and system for configuring budget |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN115586888B (en) |
Citations (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101957852A (en) * | 2010-09-26 | 2011-01-26 | 用友软件股份有限公司 | Method and system for producing correlation information of table data |
CN102004953A (en) * | 2010-11-09 | 2011-04-06 | 浪潮集团山东通用软件有限公司 | Method for realizing multi-dimensional overall budget |
CN102270226A (en) * | 2011-06-28 | 2011-12-07 | 用友软件股份有限公司 | Budget data summarization system |
US20120158557A1 (en) * | 2010-12-21 | 2012-06-21 | Microsoft Corporation | Budget control configuration |
CN111144080A (en) * | 2019-12-27 | 2020-05-12 | 深圳市金政软件技术有限公司 | Budget document generation method and system |
CN112861494A (en) * | 2021-02-05 | 2021-05-28 | 青岛海信网络科技股份有限公司 | Road network data-based visual report generation method, equipment and storage medium |
-
2022
- 2022-10-08 CN CN202211220107.8A patent/CN115586888B/en active Active
Patent Citations (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101957852A (en) * | 2010-09-26 | 2011-01-26 | 用友软件股份有限公司 | Method and system for producing correlation information of table data |
CN102004953A (en) * | 2010-11-09 | 2011-04-06 | 浪潮集团山东通用软件有限公司 | Method for realizing multi-dimensional overall budget |
US20120158557A1 (en) * | 2010-12-21 | 2012-06-21 | Microsoft Corporation | Budget control configuration |
CN102270226A (en) * | 2011-06-28 | 2011-12-07 | 用友软件股份有限公司 | Budget data summarization system |
CN111144080A (en) * | 2019-12-27 | 2020-05-12 | 深圳市金政软件技术有限公司 | Budget document generation method and system |
CN112861494A (en) * | 2021-02-05 | 2021-05-28 | 青岛海信网络科技股份有限公司 | Road network data-based visual report generation method, equipment and storage medium |
Non-Patent Citations (3)
Title |
---|
刘潇: "H城市商业银行全面预算管理研究", 《中国优秀硕士学位论文全文数据库 经济与管理科学辑》, no. 08, pages 159 - 58 * |
朱立才: "《大数据专业应用型人才培养规划教材》", 浙江科学技术出版社, pages: 86 * |
裴奇;陆海龙;: "基于ERP的全面预算管理系统设计与实施", 中国管理信息化, no. 13 * |
Also Published As
Publication number | Publication date |
---|---|
CN115586888B (en) | 2024-04-16 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US7716233B2 (en) | System and method for processing queries for combined hierarchical dimensions | |
US8479093B2 (en) | Metamodel-based automatic report generation | |
US8190992B2 (en) | Grouping and display of logically defined reports | |
US8341191B2 (en) | Methods and structures for utilizing reusable custom-defined nestable compound data types to permit product variations within an existing taxonomy | |
US8126750B2 (en) | Consolidating data source queries for multidimensional scorecards | |
CN106528129A (en) | Web application interface generation system and method | |
US20150331928A1 (en) | User-created members positioning for olap databases | |
CN103020158A (en) | Report form creation method, device and system | |
US11755992B2 (en) | Intelligent part numbering system and method | |
CN108073688B (en) | Data migration method and device | |
US20130238549A1 (en) | Using Dimension Substitutions in OLAP Cubes | |
CN102207861A (en) | Method for expressing personalized information in business | |
CN110276059B (en) | Dynamic report processing method and device | |
US11442996B2 (en) | Smart interactions for a digital duplicate | |
CN104102670A (en) | Performance indicator analytical framework | |
CN104317964A (en) | Object-relational mapping method and system based on iBatis | |
KR20050061597A (en) | System and method for generating reports for a versioned database | |
US9298686B2 (en) | System and method for simulating discrete financial forecast calculations | |
Marotta et al. | Data warehouse design: A schema-transformation approach | |
EP1618456A2 (en) | System and method for providing a territory management tool | |
US9032362B2 (en) | System and method for generating high performance calculators for calculation graphs | |
CN104951565A (en) | XML configuration maintenance method and system based on memory database | |
US8214379B2 (en) | Composing views with automatic creation of links | |
CN115586888A (en) | Data management method and system for configured budget | |
JP2009048594A (en) | Global article data, article management program, and device operated by the program |
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 |