CN115496411A

CN115496411A - Method, device and medium for managing basic level data

Info

Publication number: CN115496411A
Application number: CN202211311242.3A
Authority: CN
Inventors: 陈�峰; 张冠群; 马永飞; 申传旺; 王仕宁
Original assignee: Chaozhou Zhuoshu Big Data Industry Development Co Ltd
Current assignee: Chaozhou Zhuoshu Big Data Industry Development Co Ltd
Priority date: 2022-10-25
Filing date: 2022-10-25
Publication date: 2022-12-20

Abstract

The application discloses a method, equipment and medium for managing basic level data, wherein the method comprises the following steps: receiving a standing book management task issued by a superior department, and creating a corresponding standing book template according to the standing book management task; determining at least one management object for executing the standing book management task, and distributing the standing book template to the at least one management object; acquiring a designated field with data association logic in the standing book template, and matching the designated field with a preset data table in a basic database to determine a target data table associated with the standing book template; filling a corresponding ledger template according to the target data table through at least one management object to obtain a filled ledger; and summarizing the ledger generated correspondingly to at least one management object to a superior department so as to manage the ledger.

Description

Method, device and medium for managing basic level data

Technical Field

The present application relates to the field of data processing technologies, and in particular, to a method, a device, and a medium for managing basic level data.

Background

The primary data refers to the relevant management data collected during the primary remediation process. In recent years, the basic level burden reduction work has achieved certain effect, but with the continuous expansion of the basic level treatment scale, the data volume to be managed is gradually increased, and the problem of the reduction of the work efficiency is caused. Therefore, how to improve the management efficiency of the base layer data has become a problem to be solved urgently at present.

Disclosure of Invention

In order to solve the above problem, the present application provides a method for managing basic level data, which is applied to a preset ledger designer, and includes:

receiving a standing book management task issued by a superior department, and creating a corresponding standing book template according to the standing book management task;

determining at least one management object for executing the ledger management tasks and distributing the ledger templates to the at least one management object;

acquiring a designated field with data association logic in the standing book template, and matching the designated field with a preset data table in a basic database to determine a target data table associated with the standing book template;

filling a corresponding ledger template according to the target data table through the at least one management object to obtain a filled ledger;

and summarizing the machine account generated corresponding to the at least one management object to the superior department so as to realize the management of the machine account.

In an implementation manner of the present application, the distributing the ledger template to the at least one management object specifically includes:

and generating a standing book template copy of the standing book template, and distributing the standing book template copy to the at least one management object.

In an implementation manner of the present application, the filling, by the at least one management object, the ledger template corresponding to the target data table according to the target data table to obtain a filled ledger specifically includes:

determining a filling type corresponding to the ledger template, wherein the filling type comprises a line-by-line filling type and a batch filling type;

aiming at the ledger template with the filling type of line-by-line filling, determining a first field which has data association logic with the specified field in the target data table;

taking a field value corresponding to the first field as a to-be-selected field value corresponding to the specified field, and filling the ledger template by selecting the to-be-selected field value;

generating a matching rule corresponding to the specified field aiming at the ledger template with the filling type of batch filling, and determining a second field which has data association logic with the specified field in the target data table according to the matching rule;

and taking the field value corresponding to the second field as the field value corresponding to the specified field, so as to realize batch filling of the ledger template.

In an implementation manner of the present application, after the ledger template corresponding to the target data table is filled according to the target data table, the method further includes:

determining field types respectively corresponding to a plurality of fields contained in the ledger template, and acquiring format check rules respectively corresponding to the field types;

carrying out format check on the fields meeting the corresponding field types through the format check rule so as to determine whether the fields meet a preset format specified by the format check rule;

if not, giving a specified mark to the field to prompt format error.

In an implementation manner of the present application, after collecting ledgers generated corresponding to the at least one management object to the upper-level department, the method further includes:

when the at least one management object needs to change the standing book to be changed, which is submitted to the upper-level department, submitting a standing book withdrawing request for withdrawing the standing book to be changed;

and under the condition that the standing book withdrawing request passes the examination and approval, returning the standing book to be changed to the at least one management object, and deleting the standing book to be changed from a superior database corresponding to the superior department.

In an implementation manner of the present application, after creating a corresponding ledger template according to the ledger management task, the method further includes:

synchronously creating a data table corresponding to the ledger template based on the basic database;

and filling the corresponding standing book template according to the target data table to obtain the filled standing book, wherein the method further comprises the following steps:

and synchronizing the filled standing book into the data table so as to fill the standing book template associated with the standing book through the data table.

In an implementation manner of the present application, creating a corresponding ledger template according to the ledger management task specifically includes:

determining information items required to be configured by the standing book template to be created according to the standing book management task, and generating each field of the standing book template according to the information items;

configuring the attribute information of each field to obtain a configured ledger template; the attribute information includes at least one or more of: filling requirements, field formats, format check rules and metadata association logic.

In one implementation of the present application, the reporting requirements include periodic submission, single statistics, and daily maintenance.

The embodiment of the application provides a basic level data's management equipment, its characterized in that is applied to predetermined standing book designer, equipment includes:

at least one processor; and a memory communicatively coupled to the at least one processor; wherein the memory stores instructions executable by the at least one processor to enable the at least one processor to:

The embodiment of the application provides a nonvolatile computer storage medium, which stores computer executable instructions and is characterized in that the computer executable instructions are applied to a preset machine account designer and are set as follows:

filling a corresponding standing book template according to the target data table through the at least one management object to obtain a filled standing book;

The management method for the basic level data provided by the application can bring the following beneficial effects:

the standing book and the data table are associated, so that cooperative management between the standing book and the database table is realized, and in a cooperative linkage mode, the standing book template can be filled in an auxiliary mode through the data table, so that the data reuse rate is improved, and the management efficiency of basic data is improved.

Drawings

The accompanying drawings, which are included to provide a further understanding of the application and are incorporated in and constitute a part of this application, illustrate embodiment(s) of the application and together with the description serve to explain the application and not to limit the application. In the drawings:

fig. 1 is a schematic flowchart illustrating a method for managing base layer data according to an embodiment of the present disclosure;

fig. 2 is a schematic flowchart of another base layer data management method according to an embodiment of the present disclosure;

fig. 3 is a schematic structural diagram of a management device for base layer data according to an embodiment of the present application.

Detailed Description

In order to make the objects, technical solutions and advantages of the present application more apparent, the technical solutions of the present application will be described in detail and completely with reference to the following specific embodiments of the present application and the accompanying drawings. It should be apparent that the described embodiments are only some of the embodiments of the present application, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present application.

The technical solutions provided by the embodiments of the present application are described in detail below with reference to the accompanying drawings.

As shown in fig. 1, a method for managing basic level data provided in an embodiment of the present application is applied to a preset ledger designer, and includes:

s101: and receiving the standing book management task issued by the superior department, and creating a corresponding standing book template according to the standing book management task.

The standing book is an auxiliary account book set by enterprises for strengthening management of a certain aspect and knowing information of the certain aspect in more detail, and the standing book is used as a basic data carrier for relevant management. In the embodiment of the application, the standing book designer is a low-code development platform, and can receive a standing book management task issued by an upper-level department and further create a corresponding standing book template according to the standing book management task.

Specifically, according to the standing book management task, an information item required to be configured by the standing book template to be created is determined, and each field of the standing book template is generated according to the information item. On the basis of generating the fields, the attribute information of each field can be configured to obtain the configured ledger template. The attribute information includes at least one or more of: filling requirements, field formats, format check rules and metadata association logic.

The filling requirements comprise periodic submission, single statistics and daily maintenance, one item can be selected from the filling requirements when the ledger template is created, if the submission type of the periodic submission is selected, a submission period and periodic submission time need to be additionally set, and the submission period can be divided according to months, weeks, days, hours and the like. By setting multiple filling types, the method can adapt to the actual business requirements of the basic level work, and is favorable for improving the treatment efficiency of basic level data. The field format defines the field type of each field of the ledger template, such as text, date, number, etc. Format checking rules and field format adaptability are set for checking whether the field value input by a user accords with a preset field format, for example, for a text field, length requirements need to be set and whether the field is allowed to be empty; for the digital field, a specific data format, an integer, a decimal and a reserved digit are required to be set; for the date field, corresponding patterns (such as 2022-02-08, 2022/02/08, 2022, 2 months and 8 days) need to be set; for the ID card field, whether format verification is required or not and whether encryption display is required or not are set; for the mobile phone number field, whether format verification is required or not and whether encryption display is required or not are set; for the amount field, a style (e.g., quick element, quick) needs to be set; for the pull-down selection fields, to-be-selected items for assisting in filling the fields need to be set, and a user can select contents from the to-be-selected items to fill the fields of the ledger template. And the metadata association logic can associate fields which are described by using different characters but have the same meaning with each other among different accounts, so that the association relation of the data is established, and further the high-efficiency multiplexing of the basic data is realized.

S102: at least one management object for performing ledger management tasks is determined and ledger templates are distributed to the at least one management object.

After the standing book template is created, the standing book designer can utilize the real-time calculation engine and the message queue to construct data extraction service, so that a data table corresponding to the standing book template is synchronously created in the basic database, and thus, after a user fills the standing book template, the filled standing book can be directly synchronized into the data table in real time, so that the real-time storage of data is realized, the data table can fill the standing book template associated with the standing book, the user is not required to fill all contents of the standing book template, and the generation efficiency of the standing book is improved.

After the creation of each account template is completed, the online distribution management object corresponding to the account template needs to be determined, after at least one distributed management object is confirmed, an account template copy of the account template is generated, and the account template copy is distributed to at least one management object, so that the management objects all have the same account template copy, and are independent from each other and do not interfere with each other when content filling is carried out.

S103: and acquiring a designated field with data association logic in the standing book template, and matching the designated field with a preset data table in a basic database to determine a target data table associated with the standing book template.

After the management object receives the standing book template, the standing book template can be filled according to actual business content. Because corresponding metadata association logic is set for the fields in the process of creating the ledger template, the specified fields with the data association logic in the ledger template can be obtained when the data is filled, the specified fields are matched with the preset data tables in the basic database to determine the target data tables associated with the ledger template, and then the content recommendation and automatic filling are carried out on the set specified fields by utilizing the stock data and the shared data in the target data tables, so that the repeated labor of searching and verifying information is saved greatly.

S104: and filling the corresponding standing book template according to the target data table through at least one management object to obtain the filled standing book.

After the target data table associated with the machine account template to be filled currently is determined, the machine account template can be filled in an auxiliary manner according to the existing data in the target data table.

In one embodiment, the filling type corresponding to the ledger template is determined, and the filling type comprises a line-by-line filling type and a batch filling type. The line-by-line filling is suitable for the condition that the number of the standing book records is uncertain, and the standing book records need to be filled line by line according to actual business, under the condition, a first field with data association logic with a designated field in a target data table needs to be determined, then a field value corresponding to the first field is used as a to-be-selected field value corresponding to the designated field, and when a management object carries out data filling, a proper field value can be selected from the to-be-selected field value to fill the standing book template, so that the data filling amount is saved, and the standing book processing efficiency is improved. The batch filling is suitable for most columns of the ledger template, the data of a certain column exists in a certain existing ledger in the cloud end, and the existing data can be acquired by using the batch filling function to fill the ledger template so as to further improve the data filling efficiency. In this case, a matching rule corresponding to the specified field needs to be generated, a second field having data association logic with the specified field in the target data table is determined according to the matching rule, and then a field value corresponding to the second field is used as a field value corresponding to the specified field, so that batch filling of the ledger template is realized. It should be noted that the second field should correspond to one or more field values. The matching rule is used for representing field filling conditions, and the matching rule can be set to be B only when the matching rule is A, for example, when the identity card field of the cloud platform account is the same as the identity card number in the platform account template to be filled currently, the mobile phone number of the cloud platform account can be filled in the mobile phone number field in the current platform account template. By setting different filling types, the threshold of data multiplexing is reduced, and the quality and the efficiency of the basic level management object for filling the ledger are improved.

In the process of filling the standing book, real-time verification is required to be carried out on filling data, field types corresponding to a plurality of fields contained in the standing book template are determined, and format verification rules corresponding to the field types are obtained. And carrying out format check on the fields meeting the corresponding field types through the format check rule so as to determine whether the fields meet the preset format specified by the format check rule. If not, assigning a specified mark to the field to prompt format error. It should be noted that the designated mark may be a display mark, for example, a mark with an obvious color is added to an input box where the field is located, or the input box where the field is located is made to flash, the designated mark may also exist in the form of a prompt text, and when a field value that does not conform to the preset format appears, a corresponding prompt window is popped up to perform text prompt.

S105: and summarizing the standing book generated corresponding to at least one management object to a superior department so as to realize the management of the standing book.

After the filled ledger is generated through the process, if the issued ledger management task clearly requires that the ledger needs to be subjected to multi-level summary, the ledgers corresponding to the management objects need to be summarized to a higher-level department step by step, the process is automatic summary, manual summary of the management objects is not needed, and data errors during summary are avoided.

The summarized standing book is stored in a superior database corresponding to a superior department, and if the business corresponding to at least one management object needs to be changed and is submitted to the standing book to be changed of the superior department, a standing book withdrawal request for withdrawing the standing book to be changed is submitted at the moment. And when the machine account withdrawing request passes the examination and approval, returning the machine account to be changed to at least one management object which provides the machine account withdrawing request, and deleting the machine account to be changed from a superior database corresponding to a superior department, so that the withdrawing and modifying requirements of the service level are realized, and after the machine account is modified, the machine account can be submitted to the superior department again.

Fig. 2 is a schematic flow chart of another basic level data management method according to an embodiment of the present application, and as shown in fig. 2, a higher-level department issues a ledger management task, and designs a ledger template according to the ledger management task to obtain a designed ledger template. And acquiring the ledger data to be acquired by filling the ledger or acquisition equipment, filling the ledger template according to the acquired ledger data, and synchronizing the filled data into the basic database. The standing book data in the basic database can be summarized to the superior database corresponding to the superior department in a data table mode, and after the summary is completed, the standing book management task is completed. And the data in the superior database can be shared in the basic level database corresponding to the basic level department so as to assist the basic level department in acquiring and processing the corresponding data.

The embodiment of the application solves the problems of low informatization degree of basic level data collaborative service, no retention of service data, incapability of copying and multiplexing and the like, provides a new mode and approach for sharing the superior level data to the basic level, and is beneficial to exerting the efficiency of data sharing. The aim of data business is achieved through basic level data management, multi-party utilization of one-time collection is achieved, and efficiency and burden of basic level management work are increased and reduced.

The above is the method embodiment proposed by the present application. Based on the same idea, one or more embodiments of the present specification further provide an apparatus and a medium corresponding to the above method.

Fig. 3 is a schematic structural diagram of a management device for basic layer data according to an embodiment of the present application, where the management device is applied to a preset ledger designer, and the device includes:

at least one processor; and (c) a second step of,

a memory communicatively coupled to the at least one processor; wherein,

the memory stores instructions executable by the at least one processor to cause the at least one processor to:

determining at least one management object for executing the standing book management task, and distributing the standing book template to the at least one management object;

filling a corresponding standing book template according to the target data table through at least one management object to obtain a filled standing book;

and summarizing the standing book generated corresponding to at least one management object to a superior department so as to realize the management of the standing book.

The embodiment of the application provides a nonvolatile computer storage medium, which stores computer executable instructions and is applied to a preset ledger designer, wherein the computer executable instructions are set as follows:

determining at least one management object for executing the ledger management tasks, and distributing the ledger templates to the at least one management object;

The embodiments in the present application are described in a progressive manner, and the same and similar parts among the embodiments can be referred to each other, and each embodiment focuses on differences from other embodiments. In particular, for the device and media embodiments, the description is relatively simple as it is substantially similar to the method embodiments, and reference may be made to some descriptions of the method embodiments for relevant points.

The device and the medium provided by the embodiment of the application correspond to the method one to one, so the device and the medium also have the similar beneficial technical effects as the corresponding method, and the beneficial technical effects of the method are explained in detail above, so the beneficial technical effects of the device and the medium are not repeated herein.

As will be appreciated by one skilled in the art, embodiments of the present application may be provided as a method, system, or computer program product. Accordingly, the present application may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present application may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.

The present application is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the application. It will be understood that each flow and/or block of the flow diagrams and/or block diagrams, and combinations of flows and/or blocks in the flow diagrams and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.

These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.

These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.

In a typical configuration, a computing device includes one or more processors (CPUs), input/output interfaces, network interfaces, and memory.

The memory may include forms of volatile memory in a computer readable medium, random Access Memory (RAM) and/or non-volatile memory, such as Read Only Memory (ROM) or flash memory (flash RAM). Memory is an example of a computer-readable medium.

Computer-readable media, including both non-transitory and non-transitory, removable and non-removable media, may implement information storage by any method or technology. The information may be computer readable instructions, data structures, modules of a program, or other data. Examples of computer storage media include, but are not limited to, phase change memory (PRAM), static Random Access Memory (SRAM), dynamic Random Access Memory (DRAM), other types of Random Access Memory (RAM), read Only Memory (ROM), electrically Erasable Programmable Read Only Memory (EEPROM), flash memory or other memory technology, compact disc read only memory (CD-ROM), digital Versatile Discs (DVD) or other optical storage, magnetic cassettes, magnetic tape magnetic disk storage or other magnetic storage devices, or any other non-transmission medium that can be used to store information that can be accessed by a computing device. As defined herein, a computer readable medium does not include a transitory computer readable medium such as a modulated data signal and a carrier wave.

It should also be noted that the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrases "comprising a," "8230," "8230," or "comprising" does not exclude the presence of other like elements in a process, method, article, or apparatus comprising the element.

The above description is only an example of the present application and is not intended to limit the present application. Various modifications and changes may occur to those skilled in the art. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present application should be included in the scope of the claims of the present application.

Claims

1. A management method of basic level data is applied to a preset ledger designer, and the method comprises the following steps:

2. The method for managing base layer data according to claim 1, wherein distributing the ledger template to the at least one management object specifically includes:

3. The method for managing base layer data according to claim 1, wherein the step of filling, by the at least one management object, the ledger template corresponding to the target data table according to the target data table to obtain a filled ledger specifically includes:

generating a matching rule corresponding to the specified field aiming at the ledger template with the batch filling type, and determining a second field which has data association logic with the specified field in the target data table according to the matching rule;

4. The method for managing the base layer data according to claim 1, wherein after the corresponding ledger template is filled according to the target data table, the method further comprises:

if not, giving a specified mark to the field to prompt format error.

5. The method for managing the base layer data according to claim 1, wherein after the ledger generated corresponding to the at least one management object is collected to the upper department, the method further comprises:

when the at least one management object needs to change the standing book to be changed, which is submitted to the superior department, submitting a standing book withdrawing request for withdrawing the standing book to be changed;

6. The method for managing the base layer data according to claim 1, wherein after creating the corresponding ledger template according to the ledger management task, the method further comprises:

and filling the corresponding standing book template according to the target data table, and after the filled standing book is obtained, the method further comprises the following steps:

7. The method for managing the basic layer data according to claim 1, wherein the creating of the corresponding ledger template according to the ledger management task specifically includes:

determining an information item required to be configured by the standing book template to be created according to the standing book management task, and generating each field of the standing book template according to the information item;

8. The method for managing the base layer data of claim 7, wherein the filling requirements include periodic submission, single statistics, and daily maintenance.

9. A management apparatus of basic level data, applied to a preset ledger designer, comprising:

10. A non-transitory computer storage medium storing computer-executable instructions for use with a pre-defined ledger designer, the computer-executable instructions configured to: