CN113760899A

CN113760899A - Data table change control method and device, electronic equipment and readable storage medium

Info

Publication number: CN113760899A
Application number: CN202110123829.0A
Authority: CN
Inventors: 孔祥东
Original assignee: Xi'an Jingxundi Supply Chain Technology Co ltd
Current assignee: Xi'an Jingxundi Supply Chain Technology Co ltd
Priority date: 2021-02-01
Filing date: 2021-02-01
Publication date: 2021-12-07

Abstract

The present disclosure provides a method for controlling a change of a data table, including: receiving a change application for changing a target data sheet submitted by a data sheet manager; responding to the change application, and sending the change application to a data user subscribing the target data table; and changing the target data table based on the change application when receiving confirmation information of agreeing to the change application fed back by the data user. In addition, the present disclosure also provides a data sheet change control apparatus, an electronic device, a readable storage medium, and a computer program product.

Description

Data table change control method and device, electronic equipment and readable storage medium

Technical Field

The present disclosure relates to the field of computer technologies/databases, and more particularly, to a method for controlling change of a data table, a device for controlling change of a data table, an electronic device, a readable storage medium, and a computer program product.

Background

A database is a computer system that stores and manages data in a data structure, where data tables are the basic storage units of the database, and one or a group of data tables record the entire data content in the database.

In the prior art, users usually use public accounts or service-specific accounts to access each data table in a database, so that a data table principal cannot definitely know specific users of the data table, and when the principal changes the structure and content in the data table, the stability of all users cannot be guaranteed, and safe change is achieved.

In the process of implementing the invention, the prior art can not effectively monitor the change of the data table and can not ensure the stability of all data users.

Disclosure of Invention

In view of this, the present disclosure provides a method for controlling a change of a data table, including: receiving a change application for changing a target data sheet submitted by a data sheet manager; responding to the change application, and sending the change application to a data user who subscribes the target data table; and changing the target data table based on the change application when receiving confirmation information of agreeing to the change application fed back by the data user.

According to an embodiment of the present disclosure, the method for controlling change of a data table further includes: detecting a risk level of the change application before sending the change application to a data user who subscribes to the target data table; transmitting the change application of the first risk level to a data user who subscribes to the target data table when the risk level of the change application is a change application of a first risk level; in the case of a change application whose risk level of the change application is a second risk level, directly changing the target data table based on the change application of the second risk level; wherein the risk level of the first risk level is higher than the risk level of the second risk level.

According to an embodiment of the present disclosure, the application for changing the first risk level includes at least one of: deleting fields, changing field names and changing field types; the second risk level change application includes at least one of: adding indexes and adding fields.

According to an embodiment of the present disclosure, the method for controlling change of a data table further includes: creating subscription information of the target data table under the condition that the data user applies to use the target data table, wherein the subscription information comprises identification information of the data user; wherein the sending the change request to a data consumer subscribing to the target data table in response to the change request comprises: and sending the change application to a data user who subscribes the target data table based on the subscription information.

According to an embodiment of the present disclosure, the sending the change application to the data user who subscribes to the target data table based on the subscription information includes: broadcasting and sending the change application to all the data users according to the subscription information; and sending reminding information to the unanswered data user according to a preset frequency so that the unanswered data user responds to the change application.

According to an embodiment of the present disclosure, the above-mentioned modified application includes: the contents of the change application and the preset response time of the change application.

According to an embodiment of the present disclosure, the method for controlling change of a data table further includes: and if the data user who does not respond exists in the preset response time, regarding the feedback information of the data user who does not respond as confirmation of the change application.

According to an embodiment of the present disclosure, the method for controlling change of a data table further includes: and refusing to execute the change application when receiving the feedback information which is fed back by the data user and does not agree with the change application.

According to an embodiment of the present disclosure, the method for controlling change of a data table further includes: and sending information for confirming that the change application is still not approved to the data user who does not approve the change application, so that the data user who does not approve the change application confirms the sent feedback information which does not approve the change application.

The present disclosure also provides a data sheet change control apparatus, including: the receiving module is used for receiving a change application for changing a target data sheet submitted by a data sheet manager; a sending module, configured to respond to the change application, send the change application to a data consumer who subscribes to the target data table; and an execution module configured to change the target data table based on the change application when the reception module receives confirmation information of agreement with the change application fed back by the data user.

According to an embodiment of the present disclosure, the data sheet change control apparatus further includes: a detection module for detecting a risk level of the change application before the sending module sends the change application to a data user who subscribes to the target data table; the sending module is configured to send the change application with the first risk level to a data user who subscribes to the target data table when the risk level of the change application is a change application with a first risk level; the execution module is configured to, when the risk level of the change application is a change application of a second risk level, directly change the target data table based on the change application of the second risk level; wherein the risk level of the first risk level is higher than the risk level of the second risk level.

According to an embodiment of the present disclosure, the data sheet change control apparatus further includes: a recording module, configured to create subscription information of the target data table when the data user applies to use the target data table, where the subscription information includes identification information of the data user; wherein, the sending module is used for: and sending the change application to a data user subscribing the target data table based on the subscription information created by the recording module.

According to an embodiment of the present disclosure, the sending module includes: a first sending unit, configured to broadcast and send the change application to all the data users according to the subscription information; and the second sending unit is used for sending reminding information to the unanswered data user according to the preset frequency so that the unanswered data user responds to the change application.

According to an embodiment of the present disclosure, the execution module is further configured to, when there is an unanswered data user in the preset response time, regard feedback information of the unanswered data user as agreement with the change application.

According to an embodiment of the present disclosure, the data sheet change control apparatus further includes: and a rejecting module, configured to reject to execute the change application when the receiving module receives feedback information that is fed back by the data user and does not agree with the change application.

According to an embodiment of the present disclosure, the sending module is configured to send information for confirming that the data user who does not agree with the change application still does not agree with the change application to the data user who does not agree with the change application, so that the data user who does not agree with the change application confirms the sent feedback information that does not agree with the change application.

The present disclosure also provides an electronic device, including: one or more processors; memory for storing one or more programs, wherein the one or more programs, when executed by the one or more processors, cause the one or more processors to perform the method as described above.

The present disclosure also provides a readable storage medium having stored thereon executable instructions that, when executed by a processor, cause the processor to perform the method as described above.

The present disclosure also provides a computer program product comprising a computer program which, when executed by a processor, causes the processor to perform the method as described above.

According to the embodiment of the disclosure, a change application for changing a target data table is received, wherein the change application is submitted by a data table manager; responding to the change application, and sending the change application to a data user who subscribes the target data table; and changing the target data table based on the change application when receiving confirmation information of agreeing to the change application fed back by the data user. Because a two-way handshake mechanism is established between the data sheet manager and the user, information interaction between the data sheet manager and the user of the data sheet is realized, the problem that the user is affected by the fact that the data sheet is changed by the manager due to the fact that the change authority of the data sheet is excessively concentrated on the data sheet manager and the data sheet change cannot be supervised in the related art is solved, and the stability of the user when the data sheet is changed is effectively improved.

Drawings

The above and other objects, features and advantages of the present disclosure will become more apparent from the following description of embodiments of the present disclosure with reference to the accompanying drawings, in which:

FIG. 1 schematically illustrates an exemplary system architecture 100 to which a spreadsheet change control method may be applied, according to an embodiment of the present disclosure;

FIG. 2 schematically illustrates a flow chart of a data table alteration control method 200 according to an embodiment of the present disclosure;

FIG. 3 schematically illustrates a flow chart of a method 300 of data table change control according to another embodiment of the present disclosure;

fig. 4 schematically shows a schematic diagram of a subscription information recording process according to an embodiment of the present disclosure;

FIG. 5 schematically illustrates a schematic diagram of a spreadsheet change control system 500 according to yet another embodiment of the disclosure;

FIG. 6 schematically illustrates a schematic diagram of a spreadsheet change control device 600 according to an embodiment of the present disclosure; and

FIG. 7 schematically illustrates a block diagram of an electronic device 700 suitable for implementing the spreadsheet change control method 200 or method 300 according to an embodiment of the present disclosure.

Detailed Description

Hereinafter, embodiments of the present disclosure will be described with reference to the accompanying drawings. It should be understood that the description is illustrative only and is not intended to limit the scope of the present disclosure. In the following detailed description, for purposes of explanation, numerous specific details are set forth in order to provide a thorough understanding of the embodiments of the disclosure. It may be evident, however, that one or more embodiments may be practiced without these specific details. Moreover, in the following description, descriptions of well-known structures and techniques are omitted so as to not unnecessarily obscure the concepts of the present disclosure.

The terminology used herein is for the purpose of describing particular embodiments only and is not intended to be limiting of the disclosure. The terms "comprises," "comprising," and the like, as used herein, specify the presence of stated features, steps, operations, and/or components, but do not preclude the presence or addition of one or more other features, steps, operations, or components.

All terms (including technical and scientific terms) used herein have the same meaning as commonly understood by one of ordinary skill in the art unless otherwise defined. It is noted that the terms used herein should be interpreted as having a meaning that is consistent with the context of this specification and should not be interpreted in an idealized or overly formal sense.

Where a convention analogous to "at least one of A, B and C, etc." is used, in general such a construction is intended in the sense one having skill in the art would understand the convention (e.g., "a system having at least one of A, B and C" would include but not be limited to systems that have a alone, B alone, C alone, a and B together, a and C together, B and C together, and/or A, B, C together, etc.). Where a convention analogous to "A, B or at least one of C, etc." is used, in general such a construction is intended in the sense one having skill in the art would understand the convention (e.g., "a system having at least one of A, B or C" would include but not be limited to systems that have a alone, B alone, C alone, a and B together, a and C together, B and C together, and/or A, B, C together, etc.).

In general, a user uses a database through a public account or a private account established according to a service, and after knowing the name and address of a data table in the database, the user can access and use the data table without the approval or authorization of a manager of the data table, so that the user information of the data table is unknown to the manager. Meanwhile, since the data table is created by the manager based on the problem to be solved, when the problem changes, the manager usually changes fields and the like in the data table, and such changes are unknown information to the user.

In the process of implementing the present disclosure, it is found that unauthorized alteration of a data table by a manager cannot guarantee stability of a downstream user.

Therefore, an embodiment of the present disclosure provides a method for controlling a change of a data table, including receiving a change application for changing a target data table, which is submitted by a data table manager; responding to the change application, and sending the change application to a data user who subscribes the target data table; and changing the target data table based on the change application when receiving confirmation information of agreeing to the change application fed back by the data user.

FIG. 1 schematically illustrates an exemplary system architecture 100 to which a spreadsheet change control method may be applied, according to an embodiment of the disclosure. It should be noted that fig. 1 is only an example of a system architecture to which the embodiments of the present disclosure may be applied to help those skilled in the art understand the technical content of the present disclosure, and does not mean that the embodiments of the present disclosure may not be applied to other devices, systems, environments or scenarios.

As shown in fig. 1, the system architecture 100 according to this embodiment may include

user terminal devices

101, 102, 103, a manager terminal device 104, a network 105, and a database 106. The network 105 is used to provide a medium of communication links between the

user terminal devices

101, 102, 103, the manager terminal device 104 and the database 106. The network 105 may include various connection types, such as wired and/or wireless communication links, and so forth.

The user and the manager can interact with the database 106 through the network 105 using the

user terminal devices

101, 102, 103 and the manager terminal device 104 to perform reading, storing, changing, and the like operations. Various client applications, such as shopping-type applications, web browser applications, search-type applications, instant messaging tools, mailbox clients, and/or social platform software, etc. (examples only), may be installed on the

consumer terminal devices

101, 102, 103 and the administrator terminal device 104, and may enable reading and/or storing of the database 106 via the network 105.

The

user terminal devices

101, 102, 103 and the manager terminal device 104 may be various electronic devices having a display screen and supporting web browsing, including but not limited to a smart phone, a tablet computer, a notebook computer, a desktop computer, and the like.

The database 106 may be any type of database, such as an associative database (for example only) that provides rights discrimination for websites accessed by users using the

user terminal devices

101, 102, 103. The association-type database may perform processing such as analysis on data such as access information input by the user and feed back a processing result (e.g., authority information corresponding to the information acquired from user-input account information) to the

user terminal apparatus

101, 102, 103.

It should be noted that the data table change control method provided by the embodiment of the present disclosure may be generally executed by the database 106. The data sheet change control method provided by the embodiment of the present disclosure may also be executed by a server or a server cluster that is capable of communicating with the

user terminal devices

101, 102, 103, the manager terminal device 104, and the database 106.

For example, the pending data table may be originally stored in the database 106, or stored on an external storage device and may be imported into the database 106. Then, the user may execute the data sheet change control method provided by the embodiment of the present disclosure in the database 106 through the management-side terminal device 104, or import the to-be-processed data sheet into another database, server, or server cluster through the network 105, and execute the data sheet change control method provided by the embodiment of the present disclosure by another database, server, or server cluster that receives the to-be-processed data sheet.

It should be understood that the number of terminal devices, networks, databases in fig. 1 is merely illustrative. There may be any number of terminal devices, networks, and any kind and number of databases, as desired for the implementation.

FIG. 2 schematically illustrates a flow chart of a data table alteration control method 200 according to an embodiment of the present disclosure.

As shown in FIG. 2, the method 200 includes operations S210-S230.

In operation S210, a change application for changing a target data sheet, which is submitted by a data sheet manager, is received.

According to the embodiment of the disclosure, the change application includes change statements for operating the database, for example, including but not limited to DDL statements, DML statements, DCL statements, and the like.

Any number and variety of alteration statements may be included in an alteration application in accordance with embodiments of the present disclosure.

According to the embodiment of the disclosure, a single change application submitted by a data sheet manager can perform change operation on one or more data sheets having authority of the data sheet manager.

In operation S220, the change application is transmitted to the data consumer who subscribes to the target data table in response to the change application.

According to the embodiment of the disclosure, the data sheet change control method can be executed by a database platform, and the database platform can automatically send the related information of the change application to the data user after receiving the change application.

According to embodiments of the present disclosure, a data user may include any number of users, or no users. For example, the data table may have no user, only the data manager may use the data table, and one or more users other than the data manager may also be present.

In operation S230, in the case of receiving confirmation information agreeing to the change application fed back by the data user, the target data table is changed based on the change application.

According to the embodiment of the disclosure, for example, the database platform may perform subsequent change operations after receiving the change confirmation information of the data manager by sending the information fed back by the data user to the data manager; alternatively, the database platform may retrieve keywords, such as agreement, confirmation, etc., from the information fed back by the data user, and automatically perform subsequent change operations after retrieving the corresponding keywords.

FIG. 3 schematically illustrates a flow chart of a method 300 of controlling a change of a data table according to another embodiment of the present disclosure.

As shown in FIG. 3, the method 300 includes operations S301-S304.

In operation S301, a risk level of a change application is detected.

According to the embodiment of the disclosure, the database platform judges the risk level of the change application by detecting the keyword of the change sentence in the change application.

For example, in this embodiment, the change statement in the change application is a DDL statement, the DDL statement includes statements used by the data table, such as show, use, exit, and the like, and these statements are statements of non-change operation and can be ignored in the detection process. The DDL sentences also include the sentences for changing the data table, such as create, alter, drop and the like, and in the sentences, such as create and the like can realize operations, such as adding indexes, adding fields and the like, but the operation of adding types has no influence on a user, so the sentences, such as create and the like have lower risk level; and statements such as alter and drop can realize operations such as field deletion, field name change, field type change and the like, and the deletion and modification operations can influence a user, so the statements such as alter and drop have higher risk level.

According to the embodiment of the present disclosure, the risk level of the change application including at least one change sentence with a higher risk level is regarded as a first risk level, the risk level of the change application including only a change sentence with a lower risk level is regarded as a second risk level, and the risk level of the first risk level is higher than the risk level of the second risk level.

According to an embodiment of the present disclosure, if the risk level of the change application is the first risk level, operation S302 is performed.

In operation S302, a change application is transmitted to a data consumer who subscribes to the target data table based on the subscription information.

According to an embodiment of the present disclosure, for example, the database platform sends the change application to all data users of the target data table by way of automatic broadcast.

According to an embodiment of the present disclosure, the change application transmitted to the data consumer includes at least the entire content of the change application and the latest response time to the change application. For example, the change application may include comments about the roles of all change statements that change the data table, and the data user may be required to respond to the change application within 1 hour.

According to an embodiment of the present disclosure, the database platform may also send a plurality of alert messages to the unresponsive data consumers. The number of times of the reminding message can be set by a data management party, and the reminding frequency preset by a database platform can also be adopted. Meanwhile, the time interval of each sent reminding message may be the same, or may be increased or decreased, for example, the database platform sends the reminding message to the data user every 10 minutes, or the database platform sends the reminding message to the data user respectively 10 minutes, 30 minutes and 1 hour after the change application is sent.

In operation S303, it is determined whether the information fed back by the data consumer is a change approval application.

According to the embodiment of the disclosure, when the unanswered data user exists in the latest response time, the feedback information of the unanswered data user is regarded as the consent change application, so as to avoid the problem that the change application cannot be continued because the data user is abandoned.

According to the embodiment of the disclosure, the feedback information of the data user received by the database platform comprises the information of approving the change application and the information of refusing the change application. In case of receiving the feedback information of the unapproved change application fed back by the data user, the database platform will refuse to execute the change application, and execute operation S304.

In operation S304, information for confirming that the change application is still not approved is transmitted to the data user who does not approve the change application.

According to the embodiment of the disclosure, the data user who does not agree with the change application is convenient to confirm the feedback information of the sent change application.

According to the embodiment of the present disclosure, the database platform repeatedly performs operation S304 until there is no data user who disagrees with the change application, and performs operation S305.

According to an embodiment of the present disclosure, in the case that the risk level of the change application is the second risk level, the database platform also performs operation S305.

In operation S305, the target data table is changed based on the change application.

Fig. 4 schematically shows a schematic diagram of a subscription information recording process according to an embodiment of the present disclosure.

As shown in fig. 4, when the data user 401 applies for using the target data table 403 in the database platform 402, the database platform 402 records the identification information of the data user 401 and records the identification information in the subscription information in the corresponding target data table 403.

According to an embodiment of the present disclosure, the identification information includes, but is not limited to, system, application, data manager, usage, resource information, and the like of the data consumer.

According to an embodiment of the present disclosure, subscription information of a data table is synchronously established by a data manager when creating the data table. The subscription information may include identification information of a plurality of data consumers.

FIG. 5 schematically illustrates a schematic diagram of a spreadsheet change control system 500 according to yet another embodiment of the disclosure.

As shown in fig. 5, in another embodiment of the present disclosure, after the data manager 501 applies for the submission of a DDL change statement, the first detection unit 502 detects and classifies the DDL change statement, and when the detected DDL change statement is a change statement with a high risk level, such as a deleted field, a changed field name, or a changed field type, the first detection unit 502 sends the DDL change statement to the second detection unit 503, and forcibly performs detection of the data consumer 505 of the target data table 504. When the detected DDL change statement is a change statement with a low risk level, such as an added field change and an added index, first detecting section 502 sends the DDL change statement to change executing section 506. The change execution unit 506 may execute the received DDL change statement to implement the change to the target data table 504.

According to the embodiment of the present disclosure, the detection object of the second detection unit 503 is subscription information in the target data table 504, and the subscription information is obtained through the process shown in fig. 4. There are two types of detection results of the second detecting unit 503, one is that the target data table 504 is only a data table used by the data manager 501 itself, in which case the second detecting unit 503 sends the DDL change statement to the change executing unit 506; if the other is that the target data table 504 has a data user 505, the second detecting unit 503 will send the DDL change statement to the information interacting unit 507.

According to the embodiment of the present disclosure, the information interaction unit 507 packages the received DDL change statement into a notification, and sends the notification to the data consumer 505 in a broadcast manner, where the notification includes the latest response time. In the process of waiting for the feedback of the data user 505, the information interaction unit 507 may remind many times according to the frequency. In the case where the data consumer 505 does not respond within the latest response time, the information interaction unit 507 defaults that the data consumer 505 agrees to the execution of the change.

According to the embodiment of the present disclosure, the information interaction unit 507 may detect the received feedback information of the data usage party 505, and in a case where there is at least one data usage party 505 rejecting execution of change, the information interaction unit 507 may send a notification again to the data usage party 505 rejecting execution of change; in the case where the feedback information including the rejection information is not detected, the information interacting unit 507 transmits a DDL change statement to the change performing unit 506.

According to the embodiment of the disclosure, the database platform can determine whether to directly execute the change application according to the risk level of the change application proposed by the data manager and the data user information affected by the change application, and meanwhile, a channel for the data manager to be in contact with the data user is established, so that the two parties are no longer in a state of no perception to the other party, and the influence of the change of the data table on the stability of the downstream user is effectively reduced.

Fig. 6 schematically shows a schematic diagram of a data sheet alteration control apparatus 600 according to an embodiment of the present disclosure.

As shown in fig. 6, the apparatus 600 includes a receiving module 610, a sending module 620, and an executing module 630.

According to an embodiment of the disclosure, the receiving module 610 is configured to receive a change application for changing a target data table, which is submitted by a data table manager.

According to an embodiment of the disclosure, the sending module 620 is configured to send the change application to a data consumer subscribing to the target data table in response to the change application.

According to an embodiment of the present disclosure, the executing module 630 is configured to, in a case where the receiving module 610 receives confirmation information of approval of the change application fed back by the data user, change the target data table based on the change application.

The data sheet change control apparatus 600 of the embodiment of the present disclosure further includes a detection module. The detection module is configured to detect a risk level of the change application before the sending module 620 sends the change application to the data user subscribing to the target data table.

According to an embodiment of the disclosure, the sending module 620 is configured to send the change application with the first risk level to the data user subscribing to the target data table when the risk level of the change application is the change application with the first risk level.

According to an embodiment of the disclosure, the executing module 630 is configured to, in a case where the risk level of the change application is a change application of a second risk level, directly change the target data table based on the change application of the second risk level.

According to an embodiment of the present disclosure, the risk level of the first risk level is higher than the risk level of the second risk level.

According to an embodiment of the present disclosure, the application for change of the first risk level includes at least one of: delete field, change field name, change field type.

According to an embodiment of the present disclosure, the second risk level change application includes at least one of: adding indexes and adding fields.

The data sheet change control apparatus 600 of the present disclosure further includes a recording module. The recording module is used for creating subscription information of the target data table under the condition that the data user applies to use the target data table, wherein the subscription information comprises identification information of the data user.

According to an embodiment of the disclosure, the sending module 620 is configured to send the change application to the data user subscribing to the target data table based on the subscription information created by the recording module.

According to an embodiment of the present disclosure, the transmitting module 620 further includes a first transmitting unit and a second transmitting unit. The first sending unit is used for broadcasting and sending change applications to all data users according to the subscription information, and the second sending unit is used for sending reminding information to the data users who do not respond according to the preset frequency so that the data users who do not respond to the change applications.

According to an embodiment of the present disclosure, the change application includes: the content of the change application and the preset response time of the change application.

According to the embodiment of the disclosure, the execution module 630 is further configured to, in a case where there is an unanswered data user within the preset response time, regard feedback information of the unanswered data user as an approval change application.

The data sheet changing apparatus 600 of the embodiment of the present disclosure further includes a rejection module. The rejecting module is configured to reject to execute the change application when the receiving module 610 receives the feedback information of the change application that is not approved and fed back by the data user.

According to an embodiment of the present disclosure, the sending module 620 is further configured to send information for confirming that the change application is still not approved to the data user who does not approve the change application, so that the data user who does not approve the change application confirms the sent feedback information of the change application that is not approved.

Any number of modules, sub-modules, units, sub-units, or at least part of the functionality of any number thereof according to embodiments of the present disclosure may be implemented in one module. Any one or more of the modules, sub-modules, units, and sub-units according to the embodiments of the present disclosure may be implemented by being split into a plurality of modules. Any one or more of the modules, sub-modules, units, sub-units according to embodiments of the present disclosure may be implemented at least in part as a hardware circuit, such as a Field Programmable Gate Array (FPGA), a Programmable Logic Array (PLA), a system on a chip, a system on a substrate, a system on a package, an Application Specific Integrated Circuit (ASIC), or may be implemented in any other reasonable manner of hardware or firmware by integrating or packaging a circuit, or in any one of or a suitable combination of software, hardware, and firmware implementations. Alternatively, one or more of the modules, sub-modules, units, sub-units according to embodiments of the disclosure may be at least partially implemented as a computer program module, which when executed may perform the corresponding functions.

FIG. 7 schematically illustrates a block diagram of an electronic device 700 suitable for implementing the spreadsheet change control method 200 or method 300 according to an embodiment of the present disclosure. The electronic device shown in fig. 7 is only an example, and should not bring any limitation to the functions and the scope of use of the embodiments of the present disclosure.

As shown in fig. 7, an electronic device 700 according to an embodiment of the present disclosure includes a processor 701, which can perform various appropriate actions and processes according to a program stored in a Read Only Memory (ROM)702 or a program loaded from a storage section 708 into a Random Access Memory (RAM) 703. The processor 701 may include, for example, a general purpose microprocessor (e.g., a CPU), an instruction set processor and/or associated chipset, and/or a special purpose microprocessor (e.g., an Application Specific Integrated Circuit (ASIC)), among others. The processor 701 may also include on-board memory for caching purposes. The processor 701 may comprise a single processing unit or a plurality of processing units for performing the different actions of the method flows according to embodiments of the present disclosure.

In the RAM 703, various programs and data necessary for the operation of the electronic apparatus 700 are stored. The processor 701, the ROM 702, and the RAM 703 are connected to each other by a bus 704. The processor 701 performs various operations of the method flows according to the embodiments of the present disclosure by executing programs in the ROM 702 and/or the RAM 703. It is noted that the programs may also be stored in one or more memories other than the ROM 702 and RAM 703. The processor 701 may also perform various operations of method flows according to embodiments of the present disclosure by executing programs stored in the one or more memories.

Electronic device 700 may also include input/output (I/O) interface 705, which input/output (I/O) interface 705 is also connected to bus 704, according to an embodiment of the present disclosure. The system 700 may also include one or more of the following components connected to the I/O interface 705: an input portion 706 including a keyboard, a mouse, and the like; an output section 707 including a display such as a Cathode Ray Tube (CRT), a Liquid Crystal Display (LCD), and the like, and a speaker; a storage section 708 including a hard disk and the like; and a communication section 709 including a network interface card such as a LAN card, a modem, or the like. The communication section 709 performs communication processing via a network such as the internet. A drive 710 is also connected to the I/O interface 705 as needed. A removable medium 711 such as a magnetic disk, an optical disk, a magneto-optical disk, a semiconductor memory, or the like is mounted on the drive 710 as necessary, so that a computer program read out therefrom is mounted into the storage section 708 as necessary.

According to embodiments of the present disclosure, method flows according to embodiments of the present disclosure may be implemented as computer software programs. For example, embodiments of the present disclosure include a computer program product comprising a computer program embodied on a computer readable storage medium, the computer program containing program code for performing the method illustrated by the flow chart. In such an embodiment, the computer program can be downloaded and installed from a network through the communication section 709, and/or installed from the removable medium 711. The computer program, when executed by the processor 701, performs the above-described functions defined in the system of the embodiment of the present disclosure. The systems, devices, apparatuses, modules, units, etc. described above may be implemented by computer program modules according to embodiments of the present disclosure.

The present disclosure also provides a readable storage medium, which may be contained in the device/apparatus/system described in the above embodiments; or may exist separately and not be assembled into the device/apparatus/system. The readable storage medium carries one or more programs which, when executed, implement a method according to an embodiment of the disclosure.

According to an embodiment of the present disclosure, the readable storage medium may be a nonvolatile readable storage medium. Examples may include, but are not limited to: a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In the present disclosure, a readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device.

For example, according to embodiments of the present disclosure, a readable storage medium may include the ROM 702 and/or the RAM 703 and/or one or more memories other than the ROM 702 and the RAM 703 described above.

Embodiments of the present disclosure also include a computer program product comprising a computer program containing program code for performing the method provided by the embodiments of the present disclosure, when the computer program product is run on an electronic device, the program code being configured to cause the electronic device to implement the method for controlling a change of a data table provided by the embodiments of the present disclosure.

The computer program, when executed by the processor 701, performs the above-described functions defined in the system/apparatus of the embodiments of the present disclosure. The systems, apparatuses, modules, units, etc. described above may be implemented by computer program modules according to embodiments of the present disclosure.

In one embodiment, the computer program may be hosted on a tangible storage medium such as an optical storage device, a magnetic storage device, or the like. In another embodiment, the computer program may also be transmitted in the form of a signal on a network medium, distributed, downloaded and installed via the communication section 709, and/or installed from the removable medium 711. The computer program containing program code may be transmitted using any suitable network medium, including but not limited to: wireless, wired, etc., or any suitable combination of the foregoing.

In accordance with embodiments of the present disclosure, program code for executing computer programs provided by embodiments of the present disclosure may be written in any combination of one or more programming languages, and in particular, these computer programs may be implemented using high level procedural and/or object oriented programming languages, and/or assembly/machine languages. The programming language includes, but is not limited to, programming languages such as Java, C + +, python, the "C" language, or the like. The program code may execute entirely on the user computing device, partly on the user device, partly on a remote computing device, or entirely on the remote computing device or server. In the case of a remote computing device, the remote computing device may be connected to the user computing device through any kind of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or may be connected to an external computing device (e.g., through the internet using an internet service provider).

The flowchart and block diagrams in the figures illustrate the architecture, functionality, and operation of possible implementations of systems, methods and computer program products according to various embodiments of the present disclosure. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of code, which comprises one or more executable instructions for implementing the specified logical function(s). It should also be noted that, in some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams or flowchart illustration, and combinations of blocks in the block diagrams or flowchart illustration, can be implemented by special purpose hardware-based systems which perform the specified functions or acts, or combinations of special purpose hardware and computer instructions. Those skilled in the art will appreciate that various combinations and/or combinations of features recited in the various embodiments and/or claims of the present disclosure can be made, even if such combinations or combinations are not expressly recited in the present disclosure. In particular, various combinations and/or combinations of the features recited in the various embodiments and/or claims of the present disclosure may be made without departing from the spirit or teaching of the present disclosure. All such combinations and/or associations are within the scope of the present disclosure.

The embodiments of the present disclosure have been described above. However, these examples are for illustrative purposes only and are not intended to limit the scope of the present disclosure. Although the embodiments are described separately above, this does not mean that the measures in the embodiments cannot be used in advantageous combination. The scope of the disclosure is defined by the appended claims and equivalents thereof. Various alternatives and modifications can be devised by those skilled in the art without departing from the scope of the present disclosure, and such alternatives and modifications are intended to be within the scope of the present disclosure.

Claims

1. A data sheet change control method includes:

receiving a change application for changing a target data sheet submitted by a data sheet manager;

responding to the change application, and sending the change application to a data user who subscribes the target data table; and

and when receiving confirmation information of agreeing to the change application fed back by the data user, changing the target data table based on the change application.

2. The method of claim 1, further comprising:

before sending the change application to a data user who subscribes to the target data table, detecting the risk level of the change application;

under the condition that the risk level of the change application is a change application with a first risk level, sending the change application with the first risk level to a data user who subscribes the target data table;

directly changing the target data table based on the change application with the second risk level when the risk level of the change application is the change application with the second risk level;

wherein the first risk level has a higher risk level than the second risk level.

3. The method of claim 2, wherein the application for change of the first risk level comprises at least one of: deleting fields, changing field names and changing field types;

the second risk level change application includes at least one of: adding indexes and adding fields.

4. The method of claim 1, further comprising:

under the condition that the data user applies to use the target data table, creating subscription information of the target data table, wherein the subscription information comprises identification information of the data user;

wherein the sending the change request to a data consumer subscribing to the target data table in response to the change request comprises:

and sending the change application to a data user subscribing the target data table based on the subscription information.

5. The method of claim 4, wherein the sending the change request to a data consumer subscribing to the target data table based on the subscription information comprises:

broadcasting and sending the change application to all the data users according to the subscription information; and

and sending reminding information to the unanswered data user according to a preset frequency so that the unanswered data user responds to the change application.

6. The method of claim 5, wherein the change application comprises:

the content of the change application and the preset response time of the change application.

7. The method of claim 6, further comprising:

and if the unanswered data users exist in the preset response time, considering the feedback information of the unanswered data users as the consent of the change application.

8. The method of claim 1, further comprising:

and refusing to execute the change application when receiving feedback information which is fed back by the data user and does not agree with the change application.

9. The method of claim 8, further comprising:

and sending information for confirming that the change application is still not approved to the data user who does not approve the change application, so that the data user who does not approve the change application confirms the sent feedback information which does not approve the change application.

10. A data sheet change control device includes:

the receiving module is used for receiving a change application for changing a target data sheet submitted by a data sheet manager;

the sending module is used for responding to the change application and sending the change application to a data user who subscribes the target data table; and

and the execution module is used for changing the target data table based on the change application when the receiving module receives confirmation information fed back by the data user and agreeing to the change application.

11. An electronic device, comprising:

one or more processors;

a memory for storing one or more programs;

wherein the one or more programs, when executed by the one or more processors, cause the one or more processors to implement the method of any of claims 1-9.

12. A readable storage medium having stored thereon executable instructions which, when executed by a processor, cause the processor to carry out the method of any one of claims 1 to 9.

13. A computer program product comprising a computer program which, when executed by a processor, implements the method according to any one of claims 1 to 9.