CN115586888B - Data management method and system for configuring budget - Google Patents

Data management method and system for configuring budget Download PDF

Info

Publication number
CN115586888B
CN115586888B CN202211220107.8A CN202211220107A CN115586888B CN 115586888 B CN115586888 B CN 115586888B CN 202211220107 A CN202211220107 A CN 202211220107A CN 115586888 B CN115586888 B CN 115586888B
Authority
CN
China
Prior art keywords
budget
template
user
dimension
data
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.)
Active
Application number
CN202211220107.8A
Other languages
Chinese (zh)
Other versions
CN115586888A (en
Inventor
俞允
谭谈
丁明
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Guangzhou Xuanwu Wireless Technology Co Ltd
Original Assignee
Guangzhou Xuanwu Wireless Technology Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Guangzhou Xuanwu Wireless Technology Co Ltd filed Critical Guangzhou Xuanwu Wireless Technology Co Ltd
Priority to CN202211220107.8A priority Critical patent/CN115586888B/en
Publication of CN115586888A publication Critical patent/CN115586888A/en
Application granted granted Critical
Publication of CN115586888B publication Critical patent/CN115586888B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F8/00Arrangements for software engineering
    • G06F8/30Creation or generation of source code
    • G06F8/34Graphical or visual programming
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/28Databases characterised by their database models, e.g. relational or object models
    • G06F16/284Relational databases
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00Handling natural language data
    • G06F40/10Text processing
    • G06F40/166Editing, e.g. inserting or deleting
    • G06F40/186Templates
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F8/00Arrangements for software engineering
    • G06F8/30Creation or generation of source code
    • G06F8/38Creation or generation of source code for implementing user interfaces
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F8/00Arrangements for software engineering
    • G06F8/70Software maintenance or management
    • G06F8/71Version 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 system for configuring a budget, wherein the method comprises the following steps: configuring budget dimension and storing the budget dimension 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 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 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, 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 configured budget dimension in the relational database, so that compared with the prior art, the method is simple in operation, and a large amount of workload is saved; the method supports the realization of newly increasing budgets of different types by constructing different templates, and has higher expansibility.

Description

Data management method and system for configuring budget
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 develop diversified demands for budget management due to novel business models and operation requirements. For example, there may be large differences in the dimensions involved in the budget, in the objects used, or in the span of statistical time.
At present, the prior art mainly adopts customized development strategies aiming at different requirements. This in turn entails a large amount of code development for the configuration of the budget data, with a large human cost. Moreover, if the enterprises of the same type or class have new budget demands along with development of industries or policies, the customized budget configuration technology has higher difficulty in carrying out corresponding quick iteration on the budget management data along with the new demands, and has high iteration cost and lower expansibility.
Disclosure of Invention
The invention provides a data management method and a system for configuring budget, which solve the technical problem of how to improve expansibility by configuring the dimension of the budget and constructing a budget template.
In order to solve the above technical problems, an embodiment of the present invention provides a data management method for configuring a budget, including:
Configuring budget dimension and storing the budget dimension in a relational database; the configuration content comprises a name of a budget dimension, a data source table, a data name display column, a data unique main key column, a data query interface and a selection option;
Responding to a 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; the data source table is used for inquiring the names of the tables in the relational database; the data name display column is used for displaying dimension data; the data query interface is used as an interface of a dimension data source when budget is newly increased; the selection-selection option is used for confirming whether the corresponding budget dimension needs default selection or not when the budget template is newly added;
And 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, and visualizing the template information corresponding to the budget template selected by the user.
As a preferred solution, 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 through a value of a field designated in the protocol;
And dynamically rendering a front-end interface according to the rendering style to realize visualization of 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 configuring the budget, which comprises a configuration module, a template construction module and a visualization module; wherein,
The configuration module is used for configuring the budget dimension and storing the budget dimension into the relational database; the configuration content comprises a name of a budget dimension, a data source table, a data name display column, a data unique main key column, a data query interface and a selection option; the data source table is used for inquiring the names of the tables in the relational database; the data name display column is used for displaying dimension data; the data query interface is used as an interface of a dimension data source when budget is newly increased; the selection-selection option is used for confirming whether the corresponding budget dimension needs default selection or not when the budget template is newly added;
The template construction module is used for 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;
And the visualization module is used for 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 the front-end interface, and visualizing the template information corresponding to the budget template selected by the user.
As a preferred solution, 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 through a value of a field designated in the protocol;
And dynamically rendering a front-end interface according to the rendering style to realize visualization of template information corresponding to the budget template selected by the user.
Preferably, the data management system further includes a filling module, wherein the filling module is used for responding to a filling operation of a user, and updating budget information corresponding to the 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 configuring a budget, wherein the method comprises the following steps: configuring budget dimension and storing the budget dimension in a relational database; wherein the configured content includes a name of a budget dimension; responding to a 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; and 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, 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 configured budget dimension in the relational database, and compared with a budget management method developed through customization, the budget management method is simple in operation, and a large amount of workload is saved; the method supports the realization of newly increasing budgets of different types by constructing different templates, and has higher expansibility compared with the prior art.
Drawings
Fig. 1: a flow diagram of one embodiment of a method for data management for configuring a budget is provided.
Fig. 2: schematic diagrams of configuration budget dimensions provided for the present invention.
Fig. 3: schematic diagram of constructing budget templates provided by the invention.
Fig. 4: a schematic diagram of one embodiment of a data management system for configuring a budget is provided.
Detailed Description
The following description of the embodiments of the present invention will be made clearly and completely with reference to the accompanying drawings, in which it is apparent that the embodiments described are only some embodiments of the present invention, but not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the invention without making any inventive effort, are intended to be within the scope of the invention.
Embodiment one:
Referring to fig. 1, fig. 1 is a data management method for configuring a budget according to an embodiment of the present invention, including steps S1 to S3, wherein,
Step S1, configuring budget dimension and storing the budget dimension in a relational database; wherein the configured content includes a name of the budget dimension.
In this embodiment, the content of the configuration 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 presentation dimension information of the budget. Referring specifically 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 query the relational database for the names of the tables; 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 budget is newly increased; for the optional choice, it is mainly determined whether the budget dimension needs default selection when the budget template is newly added (if the default selection is the default selection, reconfiguration is not needed).
Storing the configured budget dimension into a relational database so as to facilitate the step S2 of calling the configured budget dimension.
Step S2, responding to the operation of constructing a template by 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.
In this embodiment, an operation instruction of a user is acquired, and a template construction operation is responded to the user. 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 a configurable item, and a user can customize the template information according to the needs through a front-end interface.
As an example of this embodiment, the budget period refers to a time range of the budget, and may include a field such as an annual budget, a quarterly budget, or a monthly budget. When the requirements of 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 queried quickly.
Further, the budget use object may be used, for example, by organization or by dealer. The options for the budget dimension may include a cost subject dimension, a brand dimension, a category dimension, and the like. By modularly configuring the templates, users can select the modules (namely, the template information) by themselves, and the templates are built by themselves according to requirements, so that the budget management efficiency is improved.
And step S3, 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, and visualizing the template information corresponding to the budget template selected by the user.
In this embodiment, the user first selects a desired configured template in actual use. 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 to realize visualization of template information corresponding to the budget template selected by the user.
Typically, there is a specified field in the protocol, and at this time, the rendered style is determined according to the value corresponding to the field. After parsing the template protocol, a dynamic sql may be assembled, querying the template for the corresponding budget data.
As a preferred implementation manner 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 constructing a plurality of templates, the user selects the required templates to create corresponding budgets. At this point, corresponding budget information needs to be filled in according to the templates, including, for example, but not limited to, marketing organizations, cost subject dimensions (specifically display costs, discounted fees, or others), the age, month, and corresponding costs of the budget, and the like. And after the user is filled in, updating budget information corresponding to the template selected by the user according to the data filled in by the user, and dynamically rendering.
Correspondingly, referring to fig. 4, the invention also provides a data management system for configuring budget, which comprises a configuration module 101, a template construction module 102 and a visualization module 103; wherein,
The configuration module 101 is configured to configure a budget dimension and store the budget dimension in a relational database; wherein the configured content includes a name of a budget dimension;
the template construction module 102 is configured to respond to a user's template construction operation, and construct 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;
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 the 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 primary key column, a data query interface and a choice of whether to choose.
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 the 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 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 update budget information corresponding to the template selected by the user according to the data filled by the user in response to the filling operation of 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 configuring a budget, wherein the method comprises the following steps: configuring budget dimension and storing the budget dimension in a relational database; wherein the configured content includes a name of a budget dimension; responding to a 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; and 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, 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 configured budget dimension in the relational database, and compared with a budget management method developed through customization, the budget management method is simple in operation, and a large amount of workload is saved; the method supports the realization of newly increasing budgets of different types by constructing different templates, and has higher expansibility compared with the prior art.
The foregoing embodiments have been provided for the purpose of illustrating the general principles of the present invention, and are not to be construed as limiting the scope of the invention. It should be noted that any modifications, equivalent substitutions, improvements, etc. made by those skilled in the art without departing from the spirit and principles of the present invention are intended to be included in the scope of the present invention.

Claims (6)

1. A method of data management for configuring a budget, comprising:
Configuring budget dimension and storing the budget dimension in a relational database; the configuration content comprises a name of a budget dimension, a data source table, a data name display column, a data unique main key column, a data query interface and a selection option; the data source table is used for inquiring the names of the tables in the relational database; the data name display column is used for displaying dimension data; the data query interface is used as an interface of a dimension data source when budget is newly increased; the selection-selection option is used for confirming whether the corresponding budget dimension needs default selection or not when the budget template is newly added;
Responding to a 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 template selection operation of a user, calling template information corresponding to a 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;
The step of visualizing the template information corresponding to the budget template selected by the user comprises the following specific steps:
analyzing a protocol corresponding to the budget template selected by the user, and determining a rendering style through a value of a field designated in the protocol;
And dynamically rendering a front-end interface according to the rendering style to realize visualization of template information corresponding to the budget template selected by the user.
2. The data management method for configuring a budget according to claim 1, 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.
3. A method of data management for configuring a budget according to any of claims 1 to 2, wherein said template information is a configurable item.
4. A data management system for configuring a budget, which is characterized by comprising a configuration module, a template construction module and a visualization module; wherein,
The configuration module is used for configuring the budget dimension and storing the budget dimension into the relational database; the configuration content comprises a name of a budget dimension, a data source table, a data name display column, a data unique main key column, a data query interface and a selection option; the data source table is used for inquiring the names of the tables in the relational database; the data name display column is used for displaying dimension data; the data query interface is used as an interface of a dimension data source when budget is newly increased; the selection-selection option is used for confirming whether the corresponding budget dimension needs default selection or not when the budget template is newly added;
The template construction module is used for 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;
The visualization module is used for 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 the front-end interface, and visualizing the template information corresponding to the budget template selected by the user;
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 through a value of a field designated in the protocol;
And dynamically rendering a front-end interface according to the rendering style to realize visualization of template information corresponding to the budget template selected by the user.
5. The data management system for configuring a budget of claim 4, further comprising a fill module for updating budget information corresponding to a template selected by a user based on user-filled data in response to a user fill operation.
6. A data management system for configuring a budget in accordance with any one of claims 4 to 5, wherein said template information is a configurable item.
CN202211220107.8A 2022-10-08 2022-10-08 Data management method and system for configuring budget Active CN115586888B (en)

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 CN115586888A (en) 2023-01-10
CN115586888B true 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 (5)

* Cited by examiner, † Cited by third party
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
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

Family Cites Families (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20120158557A1 (en) * 2010-12-21 2012-06-21 Microsoft Corporation Budget control configuration

Patent Citations (5)

* Cited by examiner, † Cited by third party
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
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)

* Cited by examiner, † Cited by third party
Title
刘潇.H城市商业银行全面预算管理研究.《中国优秀硕士学位论文全文数据库 经济与管理科学辑》.2022,(第第08期期),J159-58. *
朱立才.《大数据专业应用型人才培养规划教材》.浙江科学技术出版社,2020,第86页. *
裴奇 ; 陆海龙 ; .基于ERP的全面预算管理系统设计与实施.中国管理信息化.2016,(第13期),全文. *

Also Published As

Publication number Publication date
CN115586888A (en) 2023-01-10

Similar Documents

Publication Publication Date Title
CN113342821B (en) Report configuration method, device, equipment and computer storage medium
CN106528129B (en) A kind of Web application interface generation system and method
US8479093B2 (en) Metamodel-based automatic report generation
EP2924588B1 (en) Report creation method, device and system
US8438190B2 (en) Generating web services from business intelligence queries
CN111177231A (en) Report generation method and report generation device
US10296505B2 (en) Framework for joining datasets
CN103810196A (en) Method for testing performance of database on basis of business model
US8682936B2 (en) Inherited entity storage model
CN102541867A (en) Data dictionary generating method and system
US10650044B2 (en) Method and apparatus for converting from a source database system to a destination database system
CN102207861A (en) Method for expressing personalized information in business
CN110673848A (en) Enterprise information management system configuration platform based on JavaWeb
US9147040B2 (en) Point-in-time query system
CN110276059B (en) Dynamic report processing method and device
CN104102670A (en) Performance indicator analytical framework
CN114461200A (en) Low-code development application and method based on cloud SaaS platform
US11055358B1 (en) Smart interactions for a digital duplicate
US20040210468A1 (en) System and method for providing a territory management tool
US9032362B2 (en) System and method for generating high performance calculators for calculation graphs
CN115586888B (en) Data management method and system for configuring budget
CN111401023B (en) Report generation method, report generation device, server and storage medium
CN115934716A (en) Method for importing Excel table data into database based on metadata definition and implementation
CN112989769A (en) Method, device and platform for constructing multi-data-source form based on form engine
CN112948441B (en) Multi-dimensional data collection method and equipment for financial data

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