Design method for realizing data integration based on virtual and real projects

Abstract

The invention discloses a design method for realizing data integration based on virtual and real projects, which relates to the technical field of data management intelligent analysis, and is characterized in that compiled data can be stored on only actual projects in a system, and a user can customize arrangement levels and display positions of different projects according to business requirements; for the items with the arrangement levels set, all real items can be summarized in a mode of setting operators; the summarizing result supports the addition of a summarizing name and the setting of a display position, and the newly added summarizing item is called as a virtual item and does not store data; virtual items of different users are stored in a specified folder of a server in a TXT form, and the users can mutually refer to respective virtual-real combination item structures. According to the method and the device, the workload of querying data is reduced, the real-time performance and the accuracy of data processing are improved, and server resources are saved.

Description

Technical Field

[0001] This invention relates to the field of intelligent data management and analysis technology, and more specifically to a design method for data integration based on virtual and real projects. Background Technology

[0002] With the increasing informatization and intelligence of financial budget management, enterprises must strengthen internal management and utilize data statistics and analysis to respond to market changes. Projects are the basic unit of enterprise data management and the primary means for various departments to carry dynamic information. The design of virtual projects aims to improve the flexibility of report project structures, enabling more complex custom project logic functions to a certain extent, while also possessing good scalability. This effectively reduces the workload of users in later maintenance and meets the dynamic needs of enterprise leaders.

[0003] In practice, data comparison and summarization are generally completed under manual control and coordination using various query and calculation tools and spreadsheet creation programs. Each branch office periodically enters financial and customer information into pre-designed projects, and then the results are calculated by merging the project data. This approach has the following shortcomings: (1) The workload is large, the data reusability is poor, and the task is quite heavy.

[0004] (2) Lack of effectiveness; it cannot be specifically compiled and calculated based on the actual projects that employees are responsible for.

[0005] (3) The project's objectives and scope are unclear, which poses risks of wasted funds and inaccurate data.

[0006] (4) The amount of information interaction is low, the data are all independent, and a large amount of information interaction needs to be done manually.

[0007] Therefore, it is necessary to propose a design method for data integration based on virtual and real projects to solve the above problems. Summary of the Invention

[0008] Based on the technical background and existing problems described above, and with the storage format of TXT that supports online editing, importing, and exporting by users, the technical solution to achieve the first objective of this invention is: a simple and fast configuration file storage format, including the structure of real projects, the encoding, name, hierarchy, and calculation formula of virtual projects.

[0009] To achieve the above objectives, the present invention specifically adopts the following technical solution: A design method for data integration based on virtual and physical projects includes the following steps: (1) Actual project structure: The structure and display location of the actual project are stored on the server in the form of TXT online editing.

[0010] (2) Virtual project structure: Users construct a collection of real projects from their own management perspective, including collection code, collection name and different display levels of multiple collections. The data displayed in each real project collection is obtained by different addition and subtraction calculations of the real projects it contains.

[0011] (3) Data display: Based on the real project structure and virtual project calculation formula in the configuration file, the corresponding project is selected and the project data is calculated, and export and print operations are provided.

[0012] Furthermore, when maintaining a real project, you can also set default values ​​for the attributes displayed under that real project.

[0013] Furthermore, a virtual project is a collection of multiple real projects, and the user can customize the virtual project's code, name, display position, and calculation formula.

[0014] Furthermore, the completed real and virtual projects are stored on the server in TXT format, and online editing, import, and export are supported. Beneficial effects

[0015] The beneficial effects of this invention are as follows: 1. This invention reduces the workload of querying data and improves the user experience through a convenient and easy-to-use project structure design.

[0016] 2. This invention, through its customizable real project structure and virtual project formula, maximizes the fulfillment of users' dynamic needs and provides data support for higher-level decision-making. Attached Figure Description

[0017] Figure 1 This is a schematic diagram of the design process of the present invention. Detailed Implementation

[0018] The technical solutions of the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only some embodiments of the present invention, and not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without creative effort are within the scope of protection of the present invention.

[0019] Please refer to Figure 1, which illustrates a design method for data integration based on virtual and physical projects, including the following steps: (1) Actual project maintenance: The carrier used to store data is maintained by the user, mainly including basic settings such as project code, project name, workload, and abbreviation.

[0020] (2) Virtual project structure: Users construct a collection of real projects from their own management perspective, including collection code, collection name and different display levels of multiple collections.

[0021] (3) Virtual item formula: The data displayed in each set of real items is obtained by different addition and subtraction calculations of the real items it contains.

[0022] (4) Online editing of configuration parameters: After the virtual project is built, the configuration file can be edited online to modify the content of the real project contained in the virtual project, the calculation formula logic, and the display position.

[0023] (5) Data integrity verification: The system analyzes whether the completed configuration parameters conform to the parsing logic. If the verification is successful, the data is saved in the system; if the verification fails, a reminder is given.

[0024] (6) Data display: Based on the real project structure and virtual project calculation formula in the configuration file, the corresponding project is selected and the project data is calculated, and export and print operations are provided.

[0025] The above are merely preferred embodiments of the present invention and are not intended to limit the present invention. The scope of patent protection of the present invention shall be determined by the claims. Similarly, any equivalent structural changes made based on the description and drawings of the present invention shall also be included within the scope of protection of the present invention.

Claims

1. A design method for data integration based on virtual and real projects, characterized in that, Includes the following steps: (1) Actual project maintenance: The carrier used to store data is maintained by the user, mainly including basic settings such as project code, project name, workload, and abbreviation.

2. (2) Virtual project structure: Users construct a collection of real projects from their own management perspective, including collection code, collection name and different display levels of multiple collections.

3. (3) Virtual item formula: The data displayed in each set of real items is obtained by different addition and subtraction calculations of the real items it contains.

4. (4) Online editing of configuration parameters: After the virtual project is built, the configuration file can be edited online to modify the content of the real project, the calculation formula logic and the display position of the virtual project.

5. (5) Data integrity verification: The system analyzes whether the completed configuration parameters conform to the parsing logic. If the verification is successful, the data is saved in the system; if the verification fails, a reminder is given.

6. (6) Data display: Based on the real project structure and virtual project calculation formula in the configuration file, the corresponding project is selected and the project data is calculated, and export and print operations are provided.

7. The design method for data integration based on virtual and real projects according to claim 1, characterized in that: The coding and name of virtual projects are user-defined, and each user can freely configure the virtual-physical combined project structure they need.

8. The design method for data integration based on virtual and real projects according to claim 1, characterized in that: The configuration file for storing the virtual-physical integrated project structure is stored on the backend server. Users can modify, import, and export the configuration file online, making it convenient for users to learn from and reference each other's configuration settings.

Images