Data table editing method and system based on sharing platform

Abstract

The invention discloses a data table editing method and system based on a sharing platform, and the method comprises the steps: building a basic data warehouse, forming a thematic data pool based on the thematic category of basic data, and building a data transmission channel between the basic data warehouse and the thematic data pool; establishing a communication path between the departments at all levels, obtaining a data demand, opening a unique filling permission to the grassroots department to make a data table, and providing an auditing permission to the superior department; and opening a one-way transmission permission of a superior department to the base-layer data warehouse, and adding a full-dimensional data table to the base-layer data warehouse. According to the invention, the basic level data information of each region is comprehensively combed, data sharing and multi-party cooperation are realized by building the basic level data warehouse, barriers among departments are broken, and flow reconstruction of basic level treatment and service is realized.

Description

Technical Field

[0001] The present invention relates to the field of information processing, and particularly to a method and system for editing data tables based on a shared platform. Background Art

[0002] Excel has been very mature as a tool and means for data statistics, analysis and processing. It has good compatibility, rich extension capabilities, and powerful formula editing capabilities, and can easily achieve mutual reference and calculation between cells, workbooks, and even files.

[0003] Currently, in daily work, grass-roots departments usually long-term statistically analyze, update and summarize a large amount of data from multiple parties' requirements, and do a good job in operation and service. When the superior departments need corresponding data, the grass-roots departments coordinate and sort out the corresponding categories of data for feedback to the demand departments.

[0004] However, due to a large number of data requirements, grass-roots departments are engaged in a large number of report forms, and even the same report form needs to be filled in multiple times, consuming a lot of energy and greatly increasing the work burden. Summary of the Invention

[0005] Based on this, the purpose of the present invention is to provide a method and system for editing data tables based on a shared platform, aiming to solve the problem that currently, due to a large number of data requirements, grass-roots departments are engaged in a large number of report forms, and even the same report form needs to be filled in multiple times, consuming a lot of energy and greatly increasing the work burden.

[0006] To achieve the above object, the present invention proposes a method for editing data tables based on a shared platform, and the method for editing data tables based on a shared platform includes:

[0007] Establish a grass-roots data warehouse, form a special topic data pool based on the special topic categories of grass-roots data, and establish a data transmission channel between the grass-roots data warehouse and the special topic data pool;

[0008] Establish a communication path between departments at all levels, obtain data requirements, open a unique filling permission for grass-roots departments to create data tables, and provide a review permission for superior departments;

[0009] Open a one-way transmission permission from the superior department to the grass-roots data warehouse, and add a full-dimensional data table to the grass-roots data warehouse.

[0010] In summary, a method for editing data tables based on a shared platform proposed by the present invention classifies data topics in basic-level data by establishing a basic-level data warehouse, and establishes a data transmission channel between the basic-level data warehouse and the topic data pool for data extraction and supplementation; obtains data requirements through a communication path and only opens a single filling permission to the basic level to avoid table chaos, and the superior department reviews the edited table; opens a one-way transmission permission from the superior department to the basic-level data warehouse, and the superior department reviews the summarized all-dimensional data table and transmits the successfully reviewed all-dimensional data table to the basic-level data warehouse. The present invention comprehensively sorts out the basic-level data information of each region, realizes data sharing and multi-party collaboration by building a basic-level data warehouse, breaks down the barriers between departments, and realizes the process reengineering of basic-level governance and services.

[0011] On the one hand, according to the above technical solution, in the step of forming a topic data pool based on the topic categories of basic-level data, it specifically includes:

[0012] Perform partition identification on the basic-level data in any of the topic data pools. The partition identification is used to identify the source and matter category of the basic-level data, and report to the upper-level department according to the source and matter category of the basic-level data;

[0013] The basic-level department fills data into the topic data pool through the data transmission channel.

[0014] On the one hand, according to the above technical solution, assign partition identification to the basic-level data of the same matter category;

[0015] Classify the basic-level data with the same partition identification to form a regional data block, and set the extraction key of the regional data block.

[0016] On the one hand, according to the above technical solution, the steps of establishing a communication path between departments at all levels, obtaining data requirements, opening a single filling permission to the basic-level department to create a data table, and providing a review permission to the superior department specifically include:

[0017] Establish a communication path between adjacent-level departments, and based on the communication path, obtain the data requirements of the superior department;

[0018] When the superior department issues data requirements to the basic-level department, simultaneously send a data extraction instruction to the basic-level data warehouse;

[0019] The basic-level data warehouse receives the data extraction instruction, opens a single filling permission to the basic-level department, and opens the usage permission of the data transmission channel to the basic-level department.

[0020] According to one aspect of the above technical solution, after obtaining the use permission, a demand index is sent to the base data warehouse;

[0021] The basic data warehouse searches for a branch channel of the thematic data pool of the data transmission channel based on the direction of the demand index;

[0022] Splitting the demand index to form an authorization key for using the data transmission channel and an extraction identifier of the demand data;

[0023] Matching the extraction identifier and the extraction key, if the match is successful, extracting the demand data information within the jurisdiction of the grassroots department;

[0024] A data table is prepared based on the required data information and transmitted to a superior department through the communication path.

[0025] According to one aspect of the above technical solution, the step of making a data table specifically includes:

[0026] Extract the required data information, edit the table field information items, select the basic data in the regional data block, and sort them according to the preset arrangement rules to complete the table editing of the current table field, and upload it for review through the data transmission channel.

[0027] According to one aspect of the above technical solution, the step of opening the one-way transmission permission from the superior department to the grassroots data warehouse and adding a full-dimensional data table to the grassroots data warehouse specifically includes:

[0028] The superior department merges the tables with the same partition identifier and the same table field information items to obtain the full-dimensional data table, and verifies the data of the full-dimensional data table of the same matter category;

[0029] If approved, the full-dimensional data table is uploaded to the grassroots data warehouse;

[0030] If the approval is unsatisfactory, it will be returned for modification and resubmitted.

[0031] The present invention further proposes a data table editing system based on a shared platform, the data table editing system based on a shared platform is used to implement the above-mentioned data table editing method based on a shared platform, and the system includes:

[0032] A transmission module, used to establish a basic data warehouse, form a thematic data pool based on the thematic categories of the basic data, and establish a data transmission channel between the basic data warehouse and the thematic data pool;

[0033] An audit module, which is used to establish communication paths between departments at all levels, obtain data requirements, open a unique filling permission to grass-roots departments to create data tables, and provide audit permissions to superior departments;

[0034] An addition module, which is used to open the one-way transmission permission from the superior department to the grass-roots data warehouse and add a full-dimensional data table to the grass-roots data warehouse.

[0035] The present invention also provides a computer-readable storage medium, on which a computer program is stored. When the program is executed by a processor, the above-mentioned data table editing method based on a shared platform is implemented.

[0036] The present invention also provides an electronic device, including a memory, a processor, and a computer program stored on the memory and running on the processor. When the processor executes the computer program, the above-mentioned data table editing method based on a shared platform is implemented. Description of the Drawings

[0037] Figure 1 It is a flowchart of the data table editing method based on a shared platform in Embodiment 1 of the present invention;

[0038] Figure 2 It is a schematic structural diagram of the data table editing system based on a shared platform in Embodiment 2 of the present invention;

[0039] Figure 3 It is a structural block diagram of the electronic device in Embodiment 4 of the present invention. Detailed Embodiments

[0040] To facilitate the understanding of the present invention, the present invention will be described more comprehensively below with reference to the relevant drawings. Several embodiments of the present invention are shown in the drawings. However, the present invention can be implemented in many different forms and is not limited to the embodiments described herein. On the contrary, these embodiments are provided to make the disclosure of the present invention more thorough and comprehensive.

[0041] It should be noted that when an element is referred to as being "fixedly provided on" another element, it can be directly on the other element or there may also be an intermediate element. When an element is considered to be "connected" to another element, it can be directly connected to the other element or there may be an intermediate element at the same time. The terms "vertical", "horizontal", "left", "right" and similar expressions used herein are only for the purpose of illustration.

[0042] Unless otherwise defined, all technical and scientific terms used herein have the same meaning as commonly understood by those of ordinary skill in the technical field to which this invention belongs. The terms used in the description of this invention herein are for the purpose of describing specific embodiments only and are not intended to limit the invention. The term "and / or" used herein includes any and all combinations of one or more of the related listed items.

[0043] Embodiment 1

[0044] Please refer to Figure 1 , which shows a flowchart of a data table editing method based on a shared platform in Embodiment 1 of the present invention. The data table editing method based on the shared platform includes the following steps S01 - step S03, where:

[0045] S01. Establish a grass - roots data warehouse, form a thematic data pool based on the thematic categories of grass - roots data, and establish a data transmission channel between the grass - roots data warehouse and the thematic data pool.

[0046] Based on the massive grass - roots data, in order to facilitate classification management, a grass - roots data warehouse is established, and several thematic data pools are established in the grass - roots data warehouse according to the work scope of grass - roots departments. Any thematic data pool corresponds to a large category of data. The thematic data pool can be classified according to people, houses, enterprises, events, things, or classified according to large categories such as economy, society, public resources, etc. It should be noted that the grass - roots departments mentioned in this embodiment can be village communities or the grass - roots of large enterprises, etc.

[0047] After several thematic data pools are formed in the grass - roots data warehouse, a data transmission channel is established between the grass - roots data warehouse and the thematic data pool for extracting data from and / or supplementing data to the thematic data pool.

[0048] Among them, for the grass - roots data in any thematic data pool, partition identification is performed. The partition identification is used to identify the source and matter category of the current grass - roots data. The source is used to represent the source area or source department of the current grass - roots data; the matter category is used to represent the matter of the current data category. For example, if the current grass - roots data is the revenue of a certain company in a certain period, then the current grass - roots data is economic data in a certain area. The grass - roots data with the same partition identification is classified to form a regional data block, and an extraction key for the regional data block is set.

[0049] According to the partition identification, grass - roots staff can better extract the required data from the thematic data pool. At the same time, through the data transmission channel, new data can be supplemented to the grass - roots data warehouse to continuously enrich the grass - roots data warehouse. And the extraction key can be used by grass - roots departments to extract required data from the thematic data pool.

[0050] It should be noted that the grass-roots data warehouse can be enriched by digitizing existing paper data and importing it separately according to the classification of the thematic data pool, or taking the "district" in the partition identifier as the smallest unit, classifying and aggregating the data in the sub-departments below the smallest unit into the data index library, fusing the same type of data indicators, treating the abnormal data, and then tagging the preprocessed data and importing it into the thematic data pool respectively.

[0051] S02. Establish communication paths between departments at all levels, obtain data requirements, open the only filling permission to grass-roots departments to create data forms, and provide review permission to superior departments.

[0052] Establish communication paths between departments at adjacent levels. While the superior department issues data requirements through the communication path, the grass-roots data warehouse simultaneously obtains data extraction instructions and opens the only filling permission and the permission to use the data transmission channel to grass-roots departments.

[0053] Establishing communication paths between departments at adjacent levels and opening the only filling permission to county grass-roots departments is to ensure that there is no filling outside the system, unify the distribution process and the review process, cancel other form distribution channels, and not randomly issue them to increase the burden on grass-roots departments.

[0054] After obtaining the permission to use the data transmission channel, the grass-roots department sends a demand index to the grass-roots data warehouse. Based on the direction of the demand index, the grass-roots data warehouse searches for the branch channel of the thematic data pool of the data transmission channel. By identifying and splitting the demand index, the permission key for using the data transmission channel and the extraction identifier of the demand data are obtained.

[0055] Match the extraction identifier and the extraction key. If the match is successful, extract the demand data information within the jurisdiction of the grass-roots department; if the match fails, send the demand index until the match is successful. Create a data form based on the extracted demand data information and transmit it to the superior department through the communication path.

[0056] According to one aspect of the above technical solution, in this embodiment, a form filling and number reporting toolbox can be established to connect the data transmission channel. The form filling and number reporting toolbox supports the drag-and-drop configuration method for various front-end components and data fields. The configuration panel realizes the visualization of instant operations and supports previews in different styles for PC / h5. The form configuration tool includes functions such as automatic filling of common fields, intelligent verification, automatic summarization, and reuse of historical data. The configured form can be submitted with one key, and the system will remind of the review in real time. During the review, all-round queries and displays are realized, including table field information items, coincidence rate in the form library, comparison with historical forms, etc. The forms that pass the review will automatically refresh the list, and can be enabled with one key and intelligently distributed. The form filling results can be collected with one key, and the data is automatically merged, greatly reducing the work efficiency of departments in issuing, filling out, and collecting forms. By extracting the required data information, editing the table field information items, selecting the basic data in the regional data block, and sorting according to the preset arrangement rules, the table editing of the current table field is completed, and the review is uploaded through the data transmission channel.

[0057] S03. Open the one-way transmission permission from the superior department to the grass-roots data warehouse, and add a full-dimensional data table to the grass-roots data warehouse.

[0058] The superior department merges the tables with the same partition identifier and the same table field information items to obtain a full-dimensional data table, and conducts data verification on the full-dimensional data tables of the same matter category;

[0059] If the verification is qualified, upload the full-dimensional data table to the grass-roots data warehouse;

[0060] If the verification is unqualified, return it for modification and report it again.

[0061] In summary, according to a data table editing method based on a sharing platform proposed by the present invention, by establishing a grass-roots data warehouse, classifying data topics in grass-roots data, and establishing a data transmission channel between the grass-roots data warehouse and the topic data pool for data extraction and supplementation; obtaining data requirements through the communication path and only opening a unique filling permission to the grass-roots level to avoid form chaos, and having the superior department review the edited forms; opening the one-way transmission permission from the superior department to the grass-roots data warehouse, having the superior department review the summarized full-dimensional data table, and transmitting the successfully reviewed full-dimensional data table to the grass-roots data warehouse. The present invention comprehensively sorts out the grass-roots data information of each region, realizes data sharing and multi-party collaboration by building a grass-roots data warehouse, breaks the barriers between departments, and realizes the process reengineering of grass-roots governance and services.

[0062] Embodiment 2

[0063] Another aspect of the present invention also provides a data table editing system based on a sharing platform. Please refer toFigure 2 , which shows the structural schematic diagram of the data table editing system based on the shared platform in the second embodiment of the present invention. The data table editing system based on the shared platform includes:

[0064] A transmission module 11, configured to establish a grass-roots data warehouse, form a thematic data pool based on the thematic categories of grass-roots data, and establish a data transmission channel between the grass-roots data warehouse and the thematic data pool;

[0065] An audit module 12, configured to establish a communication path between departments at all levels, obtain data requirements, open a unique filling permission for grass-roots departments to create data tables, and provide an audit permission to superior departments;

[0066] An addition module 13, configured to open a one-way transmission permission from a superior department to the grass-roots data warehouse, and add a full-dimensional data table to the grass-roots data warehouse.

[0067] Based on the massive data at the grass-roots level, in order to facilitate classified management, a grass-roots data warehouse is established, and several thematic data pools are established in the grass-roots data warehouse according to the work scope of grass-roots departments. Any thematic data pool corresponds to a large category of data. The thematic data pool can be classified according to people, houses, enterprises, events, things, or classified according to large categories such as economy, society, and public resources. It should be noted that the grass-roots departments mentioned in this embodiment can be village communities, or the grass-roots levels of large enterprises, etc.

[0068] After several thematic data pools are formed in the grass-roots data warehouse, a data transmission channel is established between the grass-roots data warehouse and the thematic data pool for extracting data from the thematic data warehouse and / or supplementing data to the thematic data warehouse.

[0069] Among them, for the grass-roots data in any thematic data pool, a partition identifier is performed. The partition identifier is used to identify the source and matter category of the current grass-roots data. The source is used to represent the source area or source department of the current grass-roots data; the matter category is used to represent the matter of the current data category. For example, if the current grass-roots data is the revenue of a certain company in a certain period, the current grass-roots data is economic data in a certain area. The grass-roots data with the same partition identifier is classified to form a regional data block, and an extraction key for the regional data block is set.

[0070] According to the partition identifier, grass-roots staff can better extract the required data from the thematic data pool. At the same time, through the data transmission channel, new data can be supplemented into the grass-roots data warehouse to continuously enrich the grass-roots data warehouse. The extraction key can be used by grass-roots departments to extract required data from the thematic data pool.

[0071] It should be noted that the grass-roots data warehouse can be enriched by digitizing existing paper data and importing it separately according to the classification of the thematic data pool, or taking the "district" in the partition identifier as the smallest unit, classifying and aggregating the data in the sub-departments below the smallest unit into the data index library, fusing the same type of data indicators, treating the abnormal data, and then performing tagging on the preprocessed data and importing it into the thematic data pool respectively.

[0072] A communication path is established between adjacent-level departments. While the superior department issues data requirements through the communication path, the grass-roots data warehouse simultaneously obtains data extraction instructions and opens the only filling permission and data transmission channel usage permission to the grass-roots departments.

[0073] Establishing a communication path between adjacent-level departments and opening the only filling permission for county grass-roots departments is to ensure that there is no filling outside the system, unify the distribution process and the review process, cancel other form distribution channels, and not randomly issue forms to increase the burden on grass-roots departments.

[0074] After obtaining the data transmission channel usage permission, the grass-roots department sends a demand index to the grass-roots data warehouse. Based on the pointing of the demand index, the grass-roots data warehouse searches for the branch channel of the thematic data pool of the data transmission channel. By identifying and splitting the demand index, the permission key for using the data transmission channel and the extraction identifier of the demand data are obtained.

[0075] The extraction identifier and the extraction key are matched. If the match is successful, the demand data information within the jurisdiction of the grass-roots department is extracted; if the match fails, the demand index is sent until the match is successful. A data table is made according to the extracted demand data information and transmitted to the superior department through the communication path.

[0076] According to one aspect of the above technical solution, in this embodiment, a filling and reporting toolbox can be established to connect the data transmission channel. The filling and reporting toolbox supports a drag-and-drop configuration method for various front-end components and data fields. The configuration panel realizes the visualization of instant operations and supports previews in different styles of pc / h5. The form configuration tool includes functions such as automatic filling of common fields, intelligent verification, automatic summarization, and reuse of historical data. The configured form can be submitted with one key, and the system reminds of the review in real time. During the review, all-round queries and displays are realized, including table field information items, coincidence rates within the form library, and comparison with historical forms. The forms that pass the review automatically refresh the list, can be enabled with one key and intelligently distributed. The form filling results can be collected with one key and the data is automatically merged, greatly reducing the work efficiency of departments in form distribution, form filling, and form collection. By extracting the demand data information, editing the table field information items, selecting the grass-roots data within the regional data block, and sorting it according to the preset arrangement rules, the table editing of the current table field is completed and uploaded for review through the data transmission channel.

[0077] The superior department merges the tables with the same partition identifier and the same table field information items to obtain a full-dimensional data table, and verifies the data of the full-dimensional data tables of the same matter category;

[0078] If the verification is qualified, the full-dimensional data table is uploaded to the grass-roots data warehouse;

[0079] If the verification is unqualified, it is returned for modification and reported again.

[0080] In summary, a data table editing system based on a sharing platform proposed by the present invention classifies data topics in grass-roots data by establishing a grass-roots data warehouse, and establishes a data transmission channel between the grass-roots data warehouse and the topic data pool for data extraction and supplementation; obtains data requirements through a communication path and only opens a unique filling permission to the grass-roots level to avoid table chaos, and the superior department audits the edited tables; opens a one-way transmission permission from the superior department to the grass-roots data warehouse, the superior department audits the summarized full-dimensional data tables, and transmits the successfully audited full-dimensional data tables to the grass-roots data warehouse. The present invention comprehensively sorts out the grass-roots data information of each region, realizes data sharing and multi-party collaboration by building a grass-roots data warehouse, breaks the barriers between departments, and realizes the process reengineering of grass-roots governance and services.

[0081] Embodiment III

[0082] On the other hand, the present invention also proposes a computer-readable storage medium, on which one or more computer programs are stored, and when the program is executed by a processor, it realizes the above-mentioned data table editing method based on a sharing platform.

[0083] Those skilled in the art can understand that the logic or steps represented in the flowchart or described in other ways herein, for example, can be considered as a sequenced list of executable instructions for implementing logical functions, and can be specifically implemented in any computer-readable storage medium for use by an instruction execution system, apparatus or device (such as a computer-based system, a system including a processor, or other systems that can fetch and execute instructions from the instruction execution system, apparatus or device), or in combination with these instruction execution systems, apparatus or devices. For the purposes of this specification, a "computer-readable storage medium" can be any device that can contain, store, communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus or device.

[0084] More specific examples (nonexhaustive list) of computer-readable storage media include the following: electrical connections (electronic devices) having one or more wirings, portable computer disk cartridges (magnetic devices), random access memory (RAM), read-only memory (ROM), erasable programmable read-only memory (EPROM or flash memory), optical fiber devices, and portable compact disc read-only memory (CDROM). Additionally, the computer-readable storage medium can even be paper or other suitable media on which the program can be printed, because the program can be obtained electronically, for example, by optically scanning the paper or other media, then editing, interpreting, or otherwise processing it as appropriate, and then storing it in a computer memory.

[0085] Embodiment 4

[0086] Figure 3 A structural block diagram of an electronic device provided for Embodiment 4. The electronic device includes a memory, a processor, and a computer program stored on the memory and executable on the processor. When the processor executes the program, it implements the data table editing method based on a shared platform in the above embodiments. Figure 3 The displayed electronic device 30 is merely an example and should not impose any limitations on the functions and usage scope of the embodiments of the present invention.

[0087] As Figure 3 shown, the electronic device 30 can be presented in the form of a general-purpose computing device, for example, it can be a server device. The components of the electronic device 30 may include, but are not limited to: the above at least one processor 31, the above at least one memory 32, and a bus 33 connecting different system components (including the memory 32 and the processor 31).

[0088] The bus 33 includes a data bus, an address bus, and a control bus.

[0089] The memory 32 may include volatile memory, such as RAM 321 (random access memory), and / or cache memory 322, and may further include ROM 323 (read-only memory).

[0090] The memory 32 may further include a program tool 325 having a set (at least one) of program modules 324. Such program modules 324 include, but are not limited to: an operating system, one or more application programs, other program modules, and program data. Each or some combination of these examples may include the implementation of a network environment.

[0091] The processor 31 executes various functional applications and data processing by running the computer program stored in the memory 32, such as the data table editing method based on a shared platform as described above in the present invention.

[0092] The electronic device 30 may also communicate with one or more external devices 34 (such as a keyboard, a pointing device, etc.). Such communication may be carried out through the I / O interface 35 (Input / Output interface). Moreover, the electronically generated device 30 may also communicate with one or more networks (such as a local area network (LAN), a wide area network (WAN), and / or a public network, such as the Internet) through the network adapter 36. As Figure 3 shown, the network adapter 36 communicates with other modules of the electronically generated device 30 through the bus 33. It should be understood that although Figure 3 not shown in the figure, other hardware and / or software modules may be used in conjunction with the electronically generated device 30, including but not limited to: microcode, device drivers, redundant processors, disk drive arrays, RAID (Redundant Array of Independent Disks) systems, tape drives, and data backup storage systems, etc.

[0093] In the description of this specification, the descriptions referring to the terms "one embodiment", "some embodiments", "example", "specific example", or "some examples", etc. mean that the specific features, structures, materials, or characteristics described in connection with the embodiment or example are included in at least one embodiment or example of the present invention. In this specification, the schematic representations of the above terms do not necessarily refer to the same embodiment or example. Moreover, the specific features, structures, materials, or characteristics described may be combined in any one or more embodiments or examples in a suitable manner.

[0094] The above-described embodiments merely represent several implementation manners of the present invention. The descriptions thereof are relatively specific and detailed, but should not be construed as a limitation on the scope of the patent of the present invention. It should be noted that for those of ordinary skill in the art, without departing from the concept of the present invention, several modifications and improvements can still be made, and these all belong to the protection scope of the present invention. Therefore, the protection scope of the patent of the present invention shall be subject to the appended claims.

Claims

1. A data table editing method based on a shared platform, characterized in that: The data table editing method based on the shared platform includes: Establishing a basic data warehouse, forming a thematic data pool based on the thematic categories of the basic data, and establishing a data transmission channel between the basic data warehouse and the thematic data pool; Establish communication paths between departments at all levels, obtain data requirements, open up the only reporting authority to grassroots departments to prepare data tables, and provide review authority to higher-level departments; Open the one-way transmission permission from the superior department to the grassroots data warehouse, and add the full-dimensional data table to the grassroots data warehouse.

2. The data table editing method based on a shared platform according to claim 1, characterized in that: The step of forming a thematic data pool based on the thematic categories of the grassroots data specifically includes: Partitioning the grassroots data in any of the subject data pools, wherein the partitioning identification is used to identify the source and category of the grassroots data, and reporting to the upper-level department based on the source and category of the grassroots data; Grassroots departments fill data into the thematic data pool through the data transmission channel.

3. The data table editing method based on a shared platform according to claim 2, characterized in that: Assigning a partition mark to the basic data of the same event category; The base data with the same partition identifier are classified to form a regional data block, and an extraction key of the regional data block is set.

4. The data table editing method based on a shared platform according to claim 1, characterized in that: The steps of establishing communication paths between departments at all levels, obtaining data requirements, opening up the only reporting authority to grassroots departments to prepare data tables, and providing review authority to superior departments specifically include: Establishing communication paths between departments at adjacent levels, and obtaining data requirements of superior departments based on the communication paths; When the superior department issues data requirements to the grassroots department, it simultaneously sends data extraction instructions to the grassroots data warehouse; The grassroots data warehouse accepts data extraction instructions, opens up unique reporting authority to grassroots departments, and grants the grassroots departments access to data transmission channels.

5. The data table editing method based on a shared platform according to claim 4, characterized in that: After obtaining the usage permission, sending the demand index to the basic data warehouse; The basic data warehouse searches for a branch channel of the thematic data pool of the data transmission channel based on the direction of the demand index; Splitting the demand index to form an authorization key for using the data transmission channel and an extraction identifier of the demand data; Matching the extraction identifier and the extraction key, if the match is successful, extracting the demand data information within the jurisdiction of the grassroots department; A data table is prepared based on the required data information and transmitted to a superior department through the communication path.

6. The data table editing method based on a shared platform according to claim 4, characterized in that: The steps to create a data table include: Extract the required data information, edit the table field information items, select the basic data in the regional data block, and sort them according to the preset arrangement rules to complete the table editing of the current table field, and upload it for review through the data transmission channel.

7. The data table editing method based on a shared platform according to claim 1, characterized in that: The step of opening the one-way transmission permission from the superior department to the grassroots data warehouse and adding a full-dimensional data table to the grassroots data warehouse specifically includes: The superior department merges the tables with the same partition identifier and the same table field information items to obtain the full-dimensional data table, and verifies the data of the full-dimensional data table of the same matter category; If approved, the full-dimensional data table is uploaded to the grassroots data warehouse; If the approval is unsatisfactory, it will be returned for modification and resubmitted.

8. A data table editing system based on a shared platform, characterized in that: The data table editing system based on the shared platform is used to implement the data table editing method based on the shared platform according to any one of claims 1 to 7, and the system includes: A transmission module, used to establish a basic data warehouse, form a thematic data pool based on the thematic categories of the basic data, and establish a data transmission channel between the basic data warehouse and the thematic data pool; The audit module is used to establish communication paths between departments at all levels and obtain data requirements, open the only reporting authority to grassroots departments to prepare data tables, and provide audit authority to higher-level departments; An adding module is used to open up the one-way transmission permission from the superior department to the grassroots data warehouse, and to add a full-dimensional data table to the grassroots data warehouse.

9. A computer-readable storage medium having a computer program stored thereon, characterized in that: When the program is executed by a processor, the data table editing method based on a shared platform as described in any one of claims 1 to 7 is implemented.

10. An electronic device comprising a memory, a processor, and a computer program stored in the memory and running on the processor, characterized in that: When the processor executes the computer program, the data table editing method based on the shared platform as described in any one of claims 1 to 7 is implemented.

Images