CN110032554B - Management method and device of database table, storage medium and electronic equipment - Google Patents
Management method and device of database table, storage medium and electronic equipment Download PDFInfo
- Publication number
- CN110032554B CN110032554B CN201910285516.8A CN201910285516A CN110032554B CN 110032554 B CN110032554 B CN 110032554B CN 201910285516 A CN201910285516 A CN 201910285516A CN 110032554 B CN110032554 B CN 110032554B
- Authority
- CN
- China
- Prior art keywords
- virtual group
- notification
- data warehouse
- database tables
- tables
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
- G06F16/211—Schema design and management
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F9/00—Arrangements for program control, e.g. control units
- G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
- G06F9/44—Arrangements for executing specific programs
- G06F9/455—Emulation; Interpretation; Software simulation, e.g. virtualisation or emulation of application or operating system execution engines
- G06F9/45504—Abstract machines for programme code execution, e.g. Java virtual machine [JVM], interpreters, emulators
Abstract
The embodiment of the disclosure discloses a method and a device for managing a data warehouse table, a storage medium and an electronic device, wherein the method comprises the following steps: in response to selection of a data repository table, adding the selected data repository table to the virtual group; and when the specific time node arrives, sending the current yield state of the database tables in the virtual group. The user can add the selected data warehouse tables into one virtual group, manage the data warehouse tables through different virtual groups respectively, click to enter any virtual group to look up the data warehouse tables to be checked, and when a specific time node arrives, the current output state of each data warehouse table in the virtual group can be sent to the user.
Description
Technical Field
The present disclosure relates to the field of data management, and in particular, to a method and an apparatus for managing a data repository table, a storage medium, and an electronic device.
Background
For existing production operational data, the business party typically presents some business requirements to the data party, such as when which database tables are needed to perform the task.
In the existing data warehouse table management system, the business side and the data side can see the output state of each data warehouse table, however, the data warehouse tables required by all the business sides are managed uniformly, the number of the data warehouse tables is large, the data side or the business side needs manual query, the data warehouse tables to be checked cannot be found quickly, the query efficiency is low, and the user experience is poor.
Disclosure of Invention
In view of this, the embodiments of the present disclosure provide a method and an apparatus for managing a data repository table, a storage medium, and an electronic device, so as to solve the following problems in the prior art: in the existing data warehouse table management system, both a data party and a business party need to manually inquire a data warehouse table to be checked, so that the data warehouse table cannot be found quickly, the inquiry efficiency is low, and the user experience is poor.
In one aspect, an embodiment of the present disclosure provides a method for managing a data warehouse table, including: in response to a selection of a data repository table, adding the selected data repository table to a virtual group; and when a specific time node arrives, sending the current yield state of the database tables in the virtual group.
In some embodiments, the method further comprises: in response to selection of a member of the virtual group, configuring a member for the virtual group; sending the current yield state to the members of the virtual group.
In some embodiments, the particular time node comprises at least one of: the current output state changes, the preset acceptance reminding time of all the database tables in the virtual group and the appointed output time.
In some embodiments, the method further comprises: and responding to the selection of the notification modes of the database tables, and configuring corresponding notification modes for all the database tables.
In some embodiments, said sending the current yield state of the database tables in the virtual group comprises: determining a notification level corresponding to the current output state; determining a notification mode matched with the notification grade in the configured notification modes; and sending the current yield state of the database tables in the virtual group according to the notification mode matched with the notification level.
On the other hand, an embodiment of the present disclosure provides a management apparatus for a data warehouse table, including: an adding module configured to add a selected data repository table to a virtual group in response to selection of the data repository table; a sending module configured to send a current yield state of the database tables in the virtual group when a specific time node arrives.
In some embodiments, further comprising: a first setup module configured to configure members for the virtual group in response to a selection of a member in the virtual group; the sending module is further configured to send the current yield state to the member of the virtual group.
In some embodiments, the particular time node comprises at least one of: the current output state changes, the preset acceptance reminding time of all the database tables in the virtual group and the appointed output time.
In some embodiments, further comprising: and the second setting module is configured to respond to the selection of the notification modes of the data warehouse tables and configure corresponding notification modes for all the data warehouse tables.
In some embodiments, the sending module is specifically configured to determine a notification level corresponding to the current yield state; determining a notification mode matched with the notification grade in the configured notification modes; and sending the current yield state of the database tables in the virtual group according to the notification mode matched with the notification level.
In another aspect, an embodiment of the present disclosure provides a storage medium storing a computer program, where the computer program is executed by a processor to implement the method provided in any embodiment of the present disclosure.
In another aspect, an embodiment of the present disclosure provides an electronic device, which at least includes a memory and a processor, where the memory stores a computer program thereon, and the processor implements the method provided in any embodiment of the present disclosure when executing the computer program on the memory.
The user can add the selected data warehouse tables into one virtual group, manage the data warehouse tables through different virtual groups respectively, click to enter any virtual group to look up the data warehouse tables to be checked, when a specific time node arrives, the current output state of each data warehouse table in the virtual group can be sent to the user, the whole process does not need manual query of the user, the query efficiency is high, the classification management of the data warehouse tables is realized, and the user experience is good.
Drawings
Fig. 1 is a flowchart of a method for managing a database table according to a first embodiment of the present disclosure;
fig. 2 is a flowchart of a method for managing a database table according to a second embodiment of the present disclosure;
fig. 3 is a schematic structural diagram of a management apparatus for a database table according to a third embodiment of the present disclosure;
fig. 4 is a schematic structural diagram of an electronic device according to a fifth embodiment of the present disclosure.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present disclosure more clear, the technical solutions of the embodiments of the present disclosure will be described below clearly and completely with reference to the accompanying drawings of the embodiments of the present disclosure. It is to be understood that the described embodiments are only a few embodiments of the present disclosure, and not all embodiments. All other embodiments, which can be derived by a person skilled in the art from the described embodiments of the disclosure without any inventive step, are within the scope of protection of the disclosure.
Unless otherwise defined, technical or scientific terms used herein shall have the ordinary meaning as understood by one of ordinary skill in the art to which this disclosure belongs. The use of "first," "second," and similar terms in this disclosure is not intended to indicate any order, quantity, or importance, but rather is used to distinguish one element from another. The word "comprising" or "comprises", and the like, means that the element or item listed before the word covers the element or item listed after the word and its equivalents, but does not exclude other elements or items. The terms "connected" or "coupled" and the like are not restricted to physical or mechanical connections, but may include electrical connections, whether direct or indirect. "upper", "lower", "left", "right", and the like are used merely to indicate relative positional relationships, and when the absolute position of the object being described is changed, the relative positional relationships may also be changed accordingly.
To maintain the following description of the embodiments of the present disclosure clear and concise, a detailed description of known functions and known components have been omitted from the present disclosure.
A first embodiment of the present disclosure provides a method for managing a data repository table, where a flow of the method is shown in fig. 1, and the method includes steps S101 to S102:
and S101, responding to the selection of the data warehouse table, and adding the selected data warehouse table into the virtual group.
The embodiment of the disclosure sets a preset operable interface, and whether the interface is a data side or a business side, the database table concerned can be selected in the preset operable interface.
The selected database tables can be uniformly added into one group, that is, a virtual group, the virtual group can be provided with a plurality of database tables, each virtual group can have a plurality of database tables, and the virtual group 1 and the virtual group 2 can have the same database table, for example, the virtual group 1 is created for the task a and needs 3 database tables, the virtual group 2 is created for the task B and needs 5 database tables, the database tables 1 and 2 are both the database tables needed by the task a and the database tables needed by the task B, and then the database tables 1 and 2 can exist in both the virtual group 1 and the virtual group 2. In the implementation process, different names can be modified for different virtual groups according to the operation of the user on the preset operable interface, so that the user can conveniently manage and memorize.
And S102, when the specific time node arrives, sending the current yield state of the database table in the virtual group.
The specific time node may include various conditions, such as the time when the current yield status changes, the appointed yield time, and the like.
In order to reduce disturbance to the user as much as possible, the specific time node in the embodiment of the present disclosure may also be acceptance reminding time of all the database tables in the virtual group set in the preset operable interface in advance, where the acceptance reminding time may be generally applicable to a plurality of database tables under one task, and since the task may be executed only when all the plurality of database tables are required to be produced, a uniform reminding time may be set for the plurality of database tables, for example, an agreed production time of a last database table in all the database tables, so that the user may be reminded to check changes of the plurality of database tables when the agreed production time arrives.
The business side and the data side can set different reminding time respectively, different management of the same data warehouse table for different users is realized, and the management mode of the personalized mode can bring better user experience.
The embodiment of the disclosure realizes that a user selects the database tables on a preset operable interface, the selected database tables are added into one virtual group, the database tables are managed respectively through different virtual groups, the database tables to be checked can be checked by clicking to enter any virtual group, when a specific time node arrives, the current output state of each database table in the virtual group is sent to the user, the whole process does not need manual query of the user, the query efficiency is high, the classified management of the database tables is realized, and the user experience is good.
A second embodiment of the present disclosure provides a method for managing a data repository table, where a flow of the method is shown in fig. 2, and the method includes steps S201 to S206:
s201, responding to the selection of the data warehouse table, and adding the selected data warehouse table into the virtual group.
The embodiment of the disclosure sets a preset operable interface, and whether the interface is a data side or a business side, the database table concerned can be selected in the preset operable interface.
The selected database tables can be uniformly added into one group, that is, a virtual group, the virtual group can be provided with a plurality of database tables, each virtual group can have a plurality of database tables, and the virtual group 1 and the virtual group 2 can have the same database table, for example, the virtual group 1 is created for the task a and needs 3 database tables, the virtual group 2 is created for the task B and needs 5 database tables, the database tables 1 and 2 are both the database tables needed by the task a and the database tables needed by the task B, and then the database tables 1 and 2 can exist in both the virtual group 1 and the virtual group 2. In the implementation process, different names can be modified for different virtual groups according to the operation of the user on the preset operable interface, so that the user can conveniently manage and memorize.
S202, responding to the selection of the members in the virtual group, and configuring the members for the virtual group.
The user can also add the members of the virtual group in the preset operable interface. After the virtual group members are added, people related to the virtual group do not need to create the virtual group by themselves, people can directly check the added virtual group created, the process is convenient for gathering and informing people related to the same task, the related people can see the change of the database table of the database, and user experience is good. In some cases, this process is not an optional operation.
S203, responding to the selection of the notification modes of the data warehouse tables, and configuring corresponding notification modes for all the data warehouse tables.
In implementation, a notification manner selected by a user for all data warehouse tables in the virtual group in a preset operable interface may be received. The notification modes may include various modes, for example, sending a mail, sending a message inside the data warehouse table management system, sending a short message, or making a call and broadcasting by voice, and the like, which is not limited herein, the user may select one or more of the modes, and all notifications sent to the user may be sent according to the notification modes. In some cases, this process is not an optional operation and may be set by the system by default.
The process can set corresponding notification modes for each database table, and during specific setting, the notification modes can be set according to the importance levels of the database tables, for example, if the database table 1 is very important for users, the notification mode of the database table 1 can be set to be a telephone reminder and a short message reminder.
And S204, when the node arrives at a specific time, determining the notification level corresponding to the current output state.
The specific time may include various situations, such as a time when the current yield status changes, a contracted yield time, and the like.
In order to reduce disturbance to the user as much as possible, the specific time node in the embodiment of the present disclosure may also be acceptance reminding time of all the database tables in the virtual group set in the preset operable interface in advance, where the acceptance reminding time may be generally applicable to a plurality of database tables under one task, and since the task may be executed only when all the plurality of database tables are required to be produced, a uniform reminding time may be set for the plurality of database tables, for example, an agreed production time of a last database table in all the database tables, so that the user may be reminded to check changes of the plurality of database tables when the agreed production time arrives.
The notification levels may be different for different current yield states, for example, the current yield state may be the lowest notification level in production, and the current yield state may be the highest notification level in delayed production.
S205, determines a notification method matching the notification level among the configured notification methods.
When the current output state is production, the message can be sent only in the data warehouse table management system, and when the current output state is delayed production, the call can be made, the voice broadcast can be realized, and the like. The technical personnel in the field can set according to the actual requirement, and can also place the setting in a preset operable interface to be configured by the user.
In this embodiment, since the notification manners have been set for the database tables, the notification manner set individually may be preferentially adopted, and of course, a notification manner that is more likely to attract the attention of the user may also be selected from the notification manners that are matched with the notification levels and the notification manners set individually.
If the user does not set a notification mode in the process, default setting can exist according to the system, namely different current output states correspond to different notification levels, the notification can be sent only by using the notification mode that the current output state corresponds to the notification level, the current output state can be well notified to the user, and the normal work of the user cannot be disturbed due to too many messages.
And S206, sending the current output state of the database table in the virtual group according to the notification mode matched with the notification level.
The business side and the data side can set different reminding time and notification modes respectively, different management of the same data warehouse table for different users is realized, and the management mode of the personalized mode can bring better user experience.
The embodiment of the disclosure realizes that a user selects the database tables on a preset operable interface, the selected database tables are added into one virtual group, the database tables are managed respectively through different virtual groups, the database tables to be checked can be checked by clicking to enter any virtual group, when a specific time node arrives, the current output state of each database table in the virtual group is sent to the user according to a corresponding notification mode, the whole process does not need manual query of the user, the query efficiency is high, the classification management of the database tables is realized, and the user experience is good.
A third embodiment of the present disclosure provides a management apparatus for a data warehouse table, a structural schematic of the apparatus is shown in fig. 3, and the apparatus includes:
an adding module 10 configured to add the selected data repository table to the virtual group in response to selection of the data repository table; and a sending module 20, coupled to the adding module 10, configured to send the current yield state of the database tables in the virtual group when the specific time node arrives.
The embodiment of the disclosure sets a preset operable interface, and whether the interface is a data side or a business side, the database table concerned can be selected in the preset operable interface.
The selected database tables can be uniformly added into one group, that is, a virtual group, the virtual group can be provided with a plurality of database tables, each virtual group can have a plurality of database tables, and the virtual group 1 and the virtual group 2 can have the same database table, for example, the virtual group 1 is created for the task a and needs 3 database tables, the virtual group 2 is created for the task B and needs 5 database tables, the database tables 1 and 2 are both the database tables needed by the task a and the database tables needed by the task B, and then the database tables 1 and 2 can exist in both the virtual group 1 and the virtual group 2. In the implementation process, different names can be modified for different virtual groups according to the operation of the user on the preset operable interface, so that the user can conveniently manage and memorize.
The specific time node may include various conditions, such as the time when the current yield status changes, the appointed yield time, and the like.
In order to reduce disturbance to the user as much as possible, the specific time node in the embodiment of the present disclosure may also be acceptance reminding time of all the database tables in the virtual group set in the preset operable interface in advance, where the acceptance reminding time may be generally applicable to a plurality of database tables under one task, and since the task may be executed only when all the plurality of database tables are required to be produced, a uniform reminding time may be set for the plurality of database tables, for example, an agreed production time of a last database table in all the database tables, so that the user may be reminded to check changes of the plurality of database tables when the agreed production time arrives.
The business side and the data side can set different reminding time respectively, different management of the same data warehouse table for different users is realized, and the management mode of the personalized mode can bring better user experience.
In practice, the above apparatus further comprises: a first setup module configured to configure members for a virtual group in response to a selection of a member in the virtual group; and the sending module is also configured to send the current yield state to the members of the virtual group. After the virtual group members are added, people related to the virtual group do not need to create the virtual group by themselves, people can directly check the added virtual group created, the process is convenient for gathering and informing people related to the same task, the related people can see the change of the database table of the database, and user experience is good.
The device can also comprise a second setting module which is configured to respond to the selection of the notification modes of the data warehouse tables and configure corresponding notification modes for all the data warehouse tables. The notification modes may include various modes, for example, sending a mail, sending a message inside the data warehouse table management system, sending a short message, or making a call and broadcasting by voice, and the like, which is not limited herein, the user may select one or more of the modes, and all notifications sent to the user may be sent according to the notification modes. In some cases, this process is not an optional operation and may be set by the system by default.
The process can set corresponding notification modes for each database table, and during specific setting, the notification modes can be set according to the importance levels of the database tables, for example, if the database table 1 is very important for users, the notification mode of the database table 1 can be set to be a telephone reminder and a short message reminder.
In order to further optimize the notification mode, the sending module is specifically configured to determine a notification level corresponding to the current output state when the specific time node arrives; determining a notification mode matched with the notification level in the configured notification modes; and sending the current output state of the database tables in the virtual group according to the notification mode matched with the notification level.
The specific time may include various situations, such as a time when the current yield status changes, a contracted yield time, and the like.
In order to reduce disturbance to the user as much as possible, the specific time node in the embodiment of the present disclosure may also be acceptance reminding time of all the database tables in the virtual group set in the preset operable interface in advance, where the acceptance reminding time may be generally applicable to a plurality of database tables under one task, and since the task may be executed only when all the plurality of database tables are required to be produced, a uniform reminding time may be set for the plurality of database tables, for example, an agreed production time of a last database table in all the database tables, so that the user may be reminded to check changes of the plurality of database tables when the agreed production time arrives.
The notification levels may be different for different current yield states, for example, the current yield state may be the lowest notification level in production, and the current yield state may be the highest notification level in delayed production.
When the current output state is production, the message can be sent only in the data warehouse table management system, and when the current output state is delayed production, the call can be made, the voice broadcast can be realized, and the like. The technical personnel in the field can set according to the actual requirement, and can also place the setting in a preset operable interface to be configured by the user.
In this embodiment, since the notification manners have been set for the database tables, the notification manner set individually may be preferentially adopted, and of course, a notification manner that is more likely to attract the attention of the user may also be selected from the notification manners that are matched with the notification levels and the notification manners set individually.
If the user does not set a notification mode in the process, default setting can exist according to the system, namely different current output states correspond to different notification levels, the notification can be sent only by using the notification mode that the current output state corresponds to the notification level, the current output state can be well notified to the user, and the normal work of the user cannot be disturbed due to too many messages.
The business side and the data side can set different reminding time and notification modes respectively, different management of the same data warehouse table for different users is realized, and the management mode of the personalized mode can bring better user experience.
The embodiment of the disclosure realizes that a user selects the database tables on a preset operable interface, the selected database tables are added into one virtual group, the database tables are managed respectively through different virtual groups, the database tables to be checked can be checked by clicking to enter any virtual group, when a specific time node arrives, the current output state of each database table in the virtual group is sent to the user according to a corresponding notification mode, the whole process does not need manual query of the user, the query efficiency is high, the classification management of the database tables is realized, and the user experience is good.
A fourth embodiment of the present disclosure provides a storage medium storing a computer program, which when executed by a processor implements the method provided in any of the embodiments of the present disclosure, including the following steps S1 to S2:
s1, responding to the selection of the data warehouse table, and adding the selected data warehouse table to the virtual group;
s2, when the specific time node arrives, the current yield state of the database tables in the virtual group is sent.
The specific time node at least comprises one of the following components: the current output state changes, the preset acceptance reminding time of all the database tables in the virtual group and the appointed output time.
The computer program may further be executable by the processor to perform the steps of: in response to selection of a member of the virtual group, configuring the member for the virtual group; and sending the current yield state to the members of the virtual group.
The computer program may further be executable by the processor to perform the steps of: and responding to the selection of the notification modes of the data warehouse tables, and configuring corresponding notification modes for all the data warehouse tables.
When the computer program is executed by the processor to send the current yield state of the database table in the virtual group, the processor specifically executes the following steps: determining a notification level corresponding to the current output state; determining a notification mode matched with the notification level in the configured notification modes; and sending the current output state of the database tables in the virtual group according to the notification mode matched with the notification level.
The embodiment of the disclosure realizes that a user selects the database tables on a preset operable interface, the selected database tables are added into one virtual group, the database tables are managed respectively through different virtual groups, the database tables to be checked can be checked by clicking to enter any virtual group, when a specific time node arrives, the current output state of each database table in the virtual group is sent to the user, the whole process does not need manual query of the user, the query efficiency is high, the classified management of the database tables is realized, and the user experience is good.
Optionally, in this embodiment, the storage medium may include, but is not limited to: a U-disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a removable hard disk, a magnetic or optical disk, and other various media capable of storing program codes. Optionally, in this embodiment, the processor executes the method steps described in the above embodiments according to the program code stored in the storage medium. Optionally, the specific examples in this embodiment may refer to the examples described in the above embodiments and optional implementation manners, and this embodiment is not described herein again. It will be apparent to those skilled in the art that the modules or steps of the present disclosure described above may be implemented by a general purpose computing device, they may be centralized on a single computing device or distributed across a network of multiple computing devices, and alternatively, they may be implemented by program code executable by a computing device, such that they may be stored in a storage device and executed by a computing device, and in some cases, the steps shown or described may be performed in an order different than that described herein, or they may be separately fabricated into individual integrated circuit modules, or multiple ones of them may be fabricated into a single integrated circuit module. As such, the present disclosure is not limited to any specific combination of hardware and software.
A fifth embodiment of the present disclosure provides an electronic device, as shown in fig. 4, the electronic device at least includes a memory 901 and a processor 902, the memory 901 stores a computer program thereon, the processor 902 implements the method provided in any embodiment of the present disclosure when executing the computer program on the memory 901, for example, the computer program has the following steps S11 to S12:
s11, responding to the selection of the data warehouse table, and adding the selected data warehouse table to the virtual group;
s12, when the specific time node arrives, the current yield state of the database tables in the virtual group is sent.
The specific time node at least comprises one of the following components: the current output state changes, the preset acceptance reminding time of all the database tables in the virtual group and the appointed output time.
The processor 902 can execute
A computer program stored on the memory 901 executes: in response to selection of a member of the virtual group, configuring the member for the virtual group; and sending the current yield state to the members of the virtual group.
The processor 902 may execute a computer program stored on the memory 901 that performs the following: and responding to the selection of the notification modes of the data warehouse tables, and configuring corresponding notification modes for all the data warehouse tables.
When the computer program stored in the storage 901 for sending the current yield state of the database tables in the virtual group is executed, the processor 902 specifically executes the following computer program: determining a notification level corresponding to the current output state; determining a notification mode matched with the notification level in the configured notification modes; and sending the current output state of the database tables in the virtual group according to the notification mode matched with the notification level.
The embodiment of the disclosure realizes that a user selects the database tables on a preset operable interface, the selected database tables are added into one virtual group, the database tables are managed respectively through different virtual groups, the database tables to be checked can be checked by clicking to enter any virtual group, when a specific time node arrives, the current output state of each database table in the virtual group is sent to the user, the whole process does not need manual query of the user, the query efficiency is high, the classified management of the database tables is realized, and the user experience is good.
Moreover, although exemplary embodiments have been described herein, the scope thereof includes any and all embodiments based on the disclosure with equivalent elements, modifications, omissions, combinations (e.g., of various embodiments across), adaptations or alterations. The elements of the claims are to be interpreted broadly based on the language employed in the claims and not limited to examples described in the present specification or during the prosecution of the application, which examples are to be construed as non-exclusive. It is intended, therefore, that the specification and examples be considered as exemplary only, with a true scope and spirit being indicated by the following claims and their full scope of equivalents.
The above description is intended to be illustrative and not restrictive. For example, the above-described examples (or one or more versions thereof) may be used in combination with each other. For example, other embodiments may be used by those of ordinary skill in the art upon reading the above description. In addition, in the foregoing detailed description, various features may be grouped together to streamline the disclosure. This should not be interpreted as an intention that a disclosed feature not claimed is essential to any claim. Rather, the subject matter of the present disclosure may lie in less than all features of a particular disclosed embodiment. Thus, the following claims are hereby incorporated into the detailed description as examples or embodiments, with each claim standing on its own as a separate embodiment, and it is contemplated that these embodiments may be combined with each other in various combinations or permutations. The scope of the disclosure should be determined with reference to the appended claims, along with the full scope of equivalents to which such claims are entitled.
While the present disclosure has been described in detail with reference to the embodiments, the present disclosure is not limited to the specific embodiments, and those skilled in the art can make various modifications and alterations based on the concept of the present disclosure, and the modifications and alterations should fall within the scope of the present disclosure as claimed.
Claims (12)
1. A method for managing a data warehouse table, comprising:
responding to the selection of a data warehouse table, adding the selected data warehouse table into virtual groups, wherein a plurality of data warehouse tables exist in each virtual group, the virtual groups are created based on tasks, different tasks correspond to different virtual groups, and the data warehouse tables are respectively managed through different virtual groups;
and when a specific time node arrives, sending the current yield state of the database tables in the virtual group.
2. The method of claim 1, wherein the method further comprises:
in response to selection of a member of the virtual group, configuring a member for the virtual group;
sending the current yield state to the members of the virtual group.
3. The method of claim 1, wherein the particular time node comprises at least one of: the current output state changes, the preset acceptance reminding time of all the database tables in the virtual group and the appointed output time.
4. The method of any of claims 1 to 3, further comprising:
and responding to the selection of the notification modes of the database tables, and configuring corresponding notification modes for all the database tables.
5. The method of claim 4, wherein said sending the current yield state of the database tables in the virtual group comprises:
determining a notification level corresponding to the current output state;
determining a notification mode matched with the notification grade in the configured notification modes;
and sending the current yield state of the database tables in the virtual group according to the notification mode matched with the notification level.
6. An apparatus for managing a database table, comprising:
an adding module configured to respond to selection of a data warehouse table, add the selected data warehouse table to a virtual group, wherein each virtual group has a plurality of data warehouse tables, the virtual group is created based on tasks, different tasks correspond to different virtual groups, and the data warehouse tables are respectively managed through the different virtual groups;
a sending module configured to send a current yield state of the database tables in the virtual group when a specific time node arrives.
7. The apparatus of claim 6, further comprising:
a first setup module configured to configure members for the virtual group in response to a selection of a member in the virtual group;
the sending module is further configured to send the current yield state to the member of the virtual group.
8. The apparatus of claim 6, wherein the particular time node comprises at least one of: the current output state changes, the preset acceptance reminding time of all the database tables in the virtual group and the appointed output time.
9. The apparatus of any of claims 6 to 8, further comprising:
and the second setting module is configured to respond to the selection of the notification modes of the data warehouse tables and configure corresponding notification modes for all the data warehouse tables.
10. The apparatus of claim 9,
the sending module is specifically configured to determine a notification level corresponding to the current output state when a specific time node arrives; determining a notification mode matched with the notification grade in the configured notification modes; and sending the current yield state of the database tables in the virtual group according to the notification mode matched with the notification level.
11. A storage medium storing a computer program, characterized in that the computer program realizes the steps of the method of any one of claims 1 to 5 when executed by a processor.
12. An electronic device comprising at least a memory, a processor, the memory having a computer program stored thereon, characterized in that the processor realizes the steps of the method of any of claims 1 to 5 when executing the computer program on the memory.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910285516.8A CN110032554B (en) | 2019-04-10 | 2019-04-10 | Management method and device of database table, storage medium and electronic equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910285516.8A CN110032554B (en) | 2019-04-10 | 2019-04-10 | Management method and device of database table, storage medium and electronic equipment |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110032554A CN110032554A (en) | 2019-07-19 |
| CN110032554B true CN110032554B (en) | 2022-04-01 |
Family
ID=67237917
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910285516.8A Active CN110032554B (en) | 2019-04-10 | 2019-04-10 | Management method and device of database table, storage medium and electronic equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110032554B (en) |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP2767913A1 (en) * | 2013-02-13 | 2014-08-20 | Facebook, Inc. | Hive table links |
| CN106933857A (en) * | 2015-12-30 | 2017-07-07 | 阿里巴巴集团控股有限公司 | The dispatching method of task, device in a kind of data warehouse |
| CN108733713A (en) * | 2017-04-21 | 2018-11-02 | 阿里巴巴集团控股有限公司 | Data query method and device in data warehouse |
| CN109241033A (en) * | 2018-08-21 | 2019-01-18 | 北京京东尚科信息技术有限公司 | The method and apparatus for creating real-time data warehouse |
Family Cites Families (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6633878B1 (en) * | 1999-07-30 | 2003-10-14 | Accenture Llp | Initializing an ecommerce database framework |
| CN103870605A (en) * | 2014-04-08 | 2014-06-18 | 南京优玛软件科技有限公司 | Data base virtual image achieving method orientated to object |
| CN104598531B (en) * | 2014-12-25 | 2019-05-07 | 广东电子工业研究院有限公司 | Incremental data moving method between a kind of isomeric relationship type database based on trigger |
| CN106096908A (en) * | 2016-06-02 | 2016-11-09 | 深圳铂睿智恒科技有限公司 | A kind of project process monitor prompt method and system |
| CN108509440A (en) * | 2017-02-24 | 2018-09-07 | 腾讯科技（深圳）有限公司 | A kind of data processing method and device |
| CN107665243B (en) * | 2017-09-11 | 2021-03-09 | 安徽慧视金瞳科技有限公司 | Cross-language environment data interaction method based on database access |
| CN107861838A (en) * | 2017-10-18 | 2018-03-30 | 福建中金在线信息科技有限公司 | Method and device of the automated back-up MySQL database from storehouse |
-
2019
- 2019-04-10 CN CN201910285516.8A patent/CN110032554B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP2767913A1 (en) * | 2013-02-13 | 2014-08-20 | Facebook, Inc. | Hive table links |
| CN106933857A (en) * | 2015-12-30 | 2017-07-07 | 阿里巴巴集团控股有限公司 | The dispatching method of task, device in a kind of data warehouse |
| CN108733713A (en) * | 2017-04-21 | 2018-11-02 | 阿里巴巴集团控股有限公司 | Data query method and device in data warehouse |
| CN109241033A (en) * | 2018-08-21 | 2019-01-18 | 北京京东尚科信息技术有限公司 | The method and apparatus for creating real-time data warehouse |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110032554A (en) | 2019-07-19 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110704398B (en) | Database migration method and device from MySQL to Oracle and computer equipment | |
| US8225376B2 (en) | Dynamically generating a privacy summary | |
| US8533020B2 (en) | Management of user events scheduled during a user absence period | |
| CN102137029B (en) | A kind of instant communication contacts approaches to IM and device | |
| US20090281843A1 (en) | Calendar scheduling systems | |
| US20160217429A1 (en) | Selective notification of user availability status | |
| CN102542351A (en) | Hotel database establishing method and hotel automatic-booking method | |
| US20240119373A1 (en) | Titanium Task-Engine System | |
| CN104869048A (en) | Grouping processing method, device and system of MicroBlog data | |
| US8886243B1 (en) | Orchestrated group communication | |
| CN104468764A (en) | Method, device and system for strategy scheduling | |
| CN114448922A (en) | Message grading processing method, device, equipment and storage medium | |
| CN109829680B (en) | Scheduling method, scheduling device, computer device and storage medium | |
| CN110032554B (en) | Management method and device of database table, storage medium and electronic equipment | |
| CN109039670A (en) | The sharing method and device of team's configuration method, team's allocation plan | |
| US11107044B2 (en) | Remove selected user identifiers to include in an event message based on a context of an event | |
| CN115270743A (en) | Form data processing method and device | |
| US10394543B2 (en) | Lifecycle objectification of non-activity objects in an activity thread | |
| CN109857619A (en) | State subscription method, apparatus, storage medium and the electronic equipment of data warehouse table | |
| CN105978853A (en) | Session scheduling method, scheduling server and terminal | |
| CN110750557A (en) | Management method and device for insurance enterprise channel | |
| CN105812230B (en) | A kind of transmission method of related information, apparatus and system | |
| CN102333147A (en) | Method for exchanging personal related information based on ID (identification) information and verification information | |
| US8706743B2 (en) | Alert notification distribution tool | |
| CN102915477A (en) | Method and device for extending workflow active node participants |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant | ||
| CP01 | Change in the name or title of a patent holder |
Address after: 100041 B-0035, 2 floor, 3 building, 30 Shixing street, Shijingshan District, Beijing. Patentee after: Tiktok vision (Beijing) Co.,Ltd. Address before: 100041 B-0035, 2 floor, 3 building, 30 Shixing street, Shijingshan District, Beijing. Patentee before: BEIJING BYTEDANCE NETWORK TECHNOLOGY Co.,Ltd. Address after: 100041 B-0035, 2 floor, 3 building, 30 Shixing street, Shijingshan District, Beijing. Patentee after: Douyin Vision Co.,Ltd. Address before: 100041 B-0035, 2 floor, 3 building, 30 Shixing street, Shijingshan District, Beijing. Patentee before: Tiktok vision (Beijing) Co.,Ltd. |
|
| CP01 | Change in the name or title of a patent holder | ||
| TR01 | Transfer of patent right |
Effective date of registration: 20230714 Address after: 100190 1309, 13th floor, building 4, Zijin Digital Park, Haidian District, Beijing Patentee after: Beijing volcano Engine Technology Co.,Ltd. Address before: 100041 B-0035, 2 floor, 3 building, 30 Shixing street, Shijingshan District, Beijing. Patentee before: Douyin Vision Co.,Ltd. |
|
| TR01 | Transfer of patent right |