CN110032554A - Management method, device, storage medium and the electronic equipment of data warehouse table - Google Patents
Management method, device, storage medium and the electronic equipment of data warehouse table Download PDFInfo
- Publication number
- CN110032554A CN110032554A CN201910285516.8A CN201910285516A CN110032554A CN 110032554 A CN110032554 A CN 110032554A CN 201910285516 A CN201910285516 A CN 201910285516A CN 110032554 A CN110032554 A CN 110032554A
- Authority
- CN
- China
- Prior art keywords
- data warehouse
- warehouse table
- virtual group
- output state
- selection
- 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.)
- Granted
Links
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 present disclosure discloses management method, device, storage medium and the electronic equipment of a kind of data warehouse table, and method includes: that the data warehouse table of selection is added in virtual group in response to the selection to data warehouse table；When specific time node reaches, the current output state of the data warehouse table in virtual group is sent.The data warehouse table of selection can all be added in a virtual group by embodiment of the present disclosure user, it don't bother about reason data warehouse table by different virtual components, the data warehouse table for wanting to check can be viewed by clicking to enter any one virtual group, when specific time node reaches, also the current output state of data warehouse table each in the virtual group can be sent to user, user's manual queries are not needed, search efficiency is higher, and realizes Classification Management to data warehouse table.
Description
Technical field
This disclosure relates to data management field, in particular to a kind of management method of data warehouse table, device, storage medium
And electronic equipment.
Background technique
For existing production and operation data, business side would generally propose some business demands to data side, for example, what
Which data warehouse table time needs execute task.
In existing data warehouse list management system, business side and data side can see each data warehouse table very much
Output state, however, all business sides need data warehouse table be all managed collectively, data warehouse table quantity is more no matter
It is that data side or business side require manual queries, the data warehouse table for wanting to check can not be quickly found out, search efficiency is low
Under, user experience is poor.
Summary of the invention
In view of this, the embodiment of the present disclosure proposes management method, device, storage medium and the electricity of a kind of data warehouse table
Sub- equipment, to solve the problems, such as the as follows of the prior art: in existing data warehouse list management system, either data side is also
It is the data warehouse table that business side requires that manual queries are wanted to check, can not be quickly found out, search efficiency is low, user experience
It is poor.
On the one hand, the embodiment of the present disclosure proposes a kind of management method of data warehouse table, comprising: in response to data bins
The data warehouse table of selection is added in virtual group by the selection of library table；When specific time node reaches, described in transmission
The current output state of the data warehouse table in virtual group.
In some embodiments, the method also includes: be the void in response to the selection to member in the virtual group
Quasi- group configuration member；The current output state is sent to the member of the virtual group.
In some embodiments, the specific time node includes at least following one: current output state changes
Time, all data warehouse tables in the pre-set virtual group examination reminder time, agreement output time.
In some embodiments, the method also includes: in response to the selection of the advice method to the data warehouse table,
Corresponding advice method is configured for all data warehouse tables.
In some embodiments, the current output state for sending the data warehouse table in the virtual group, packet
It includes: determining the corresponding notice grade of the current output state；The determining and notice in the configured advice method
The advice method that grade matches；It is sent in the virtual group according to the advice method to match with the notice grade
The current output state of the data warehouse table.
On the other hand, the embodiment of the present disclosure proposes a kind of managing device of data warehouse table, comprising: adding module is matched
It is set in response to the selection to data warehouse table, the data warehouse table of selection is added in virtual group；Sending module is matched
It is set to when specific time node reaches, sends the current output state of the data warehouse table in the virtual group.
In some embodiments, further includes: the first setup module is configured in response to the choosing to member in the virtual group
It selects, is the virtual group configuration member；The sending module is additionally configured to for the current output state being sent to described virtual
The member of group.
In some embodiments, the specific time node includes at least following one: current output state changes
Time, all data warehouse tables in the pre-set virtual group examination reminder time, agreement output time.
In some embodiments, further includes: the second setup module is configured in response to the notice to the data warehouse table
The selection of mode configures corresponding advice method for all data warehouse tables.
In some embodiments, the sending module, concrete configuration are to determine the corresponding notice of the current output state
Grade；The determining advice method to match with the notice grade in the configured advice method；Lead to according to described
Know that the advice method that grade matches sends the current output state of the data warehouse table in the virtual group.
On the other hand, the embodiment of the present disclosure proposes a kind of storage medium, is stored with computer program, the computer journey
The method that disclosure any embodiment provides is realized when sequence is executed by processor.
On the other hand, the embodiment of the present disclosure proposes a kind of electronic equipment, includes at least memory, processor, described to deposit
Computer program is stored on reservoir, the processor realizes that the disclosure is appointed when executing the computer program on the memory
The method that embodiment of anticipating provides.
The data warehouse table of selection can all be added in a virtual group by embodiment of the present disclosure user, by different
Virtual component don't bother about reason data warehouse table, and the data warehouse for wanting to check can be viewed by clicking to enter any one virtual group
The current output state of data warehouse table each in the virtual group can be also sent to use when specific time node reaches by table
Family, whole process do not need user's manual queries, and search efficiency is higher, and realize Classification Management, user to data warehouse table
Experience is preferable.
Detailed description of the invention
Fig. 1 is the flow chart of the management method for the data warehouse table that the first embodiment of the present disclosure provides；
Fig. 2 is the flow chart of the management method for the data warehouse table that the second embodiment of the present disclosure provides；
Fig. 3 is the structural schematic diagram of the managing device for the data warehouse table that the third embodiment of the present disclosure provides；
Fig. 4 is the structural schematic diagram for the electronic equipment that the fifth embodiment of the present disclosure provides.
Specific embodiment
In order to enable the purposes, technical schemes and advantages of the embodiment of the present disclosure are clearer, below in conjunction with disclosure reality
The technical solution of the embodiment of the present disclosure is clearly and completely described in the attached drawing for applying example.Obviously, described embodiment is
A part of this disclosure embodiment, instead of all the embodiments.Based on described embodiment of the disclosure, this field is common
Technical staff's every other embodiment obtained under the premise of being not necessarily to creative work, belongs to the model of disclosure protection
It encloses.
Unless otherwise defined, the technical term or scientific term that the disclosure uses should be tool in disclosure fields
The ordinary meaning for thering is the personage of general technical ability to be understood." first ", " second " used in the disclosure and similar word are simultaneously
Any sequence, quantity or importance are not indicated, and are used only to distinguish different component parts." comprising " or "comprising" etc.
Similar word means that the element or object before the word occur covers the element or object for appearing in the word presented hereinafter
And its it is equivalent, and it is not excluded for other elements or object.The similar word such as " connection " or " connected " is not limited to physics
Or mechanical connection, but may include electrical connection, it is either direct or indirectly."upper", "lower",
"left", "right" etc. is only used for indicating relative positional relationship, and after the absolute position for being described object changes, then the relative position is closed
System may also correspondingly change.
In order to keep the following explanation of the embodiment of the present disclosure to understand and concise, known function and known portion is omitted in the disclosure
The detailed description of part.
The first embodiment of the present disclosure provides a kind of management method of data warehouse table, the process of this method as shown in Figure 1,
Including step S101 to S102:
The data warehouse table of selection is added in virtual group by S101 in response to the selection to data warehouse table.
The embodiment of the present disclosure be provided with one it is default can operation interface, either data side or business side, can be
This, which is preset, to select the data warehouse table paid close attention in operation interface.
The above-mentioned data warehouse table having been selected can be uniformly added in a group, i.e., virtual group, virtual group can be set
Set multiple, may exist multiple data warehouse tables in each virtual group, in virtual group 1 and virtual group 2 there may be identical
Data warehouse table needs 3 data warehouse tables for example, virtual group 1 is created for task A, and virtual group 2 is for task B wound
It builds, needs 5 data warehouse tables, data warehouse table 1 and data warehouse table 2 are both the data warehouse table that task A needs,
It is the data warehouse table that task B needs, then can has data warehouse table 1 and data warehouse table 2 in virtual group 1 and virtual group 2.
When realization, can for user it is default can the operation of operation interface be that different virtual groups modifies different titles, with convenient
User management and memory.
S102 sends the current output state of the data warehouse table in virtual group when specific time node reaches.
Above-mentioned specific time node may include a variety of situations, such as current output state changed time, agreement
Output time etc..
User is bothered in order to reduce as far as possible, the above-mentioned specific time node of the embodiment of the present disclosure can also be pre-
First it is default can all data warehouse tables in the virtual group of operation interface setting examination reminder time, the examination reminder time
May be generally applicable to multiple data warehouse tables under a task, due to need this multiple data warehouse table all output the case where
Under can execute task, therefore one unified reminder time, such as all data can be set for multiple data warehouse tables
The agreement output time of the last one data warehouse table in warehouse table, in this manner it is possible to be reminded when arranging the arrival of output time
User checks the variation of above-mentioned multiple data warehouse tables.
Different reminder times can be respectively set in business side and data side, realize same data warehouse indicator to difference
User carries out different management, and the way to manage of the customized manner can bring better user experience.
The embodiment of the present disclosure realize allow user it is default can operation interface selection data warehouse table, and by the number of selection
All it is added in a virtual group according to warehouse table, reason data warehouse table don't bother about by different virtual components, click to enter any
One virtual group can view the data warehouse table for wanting to check, can also be virtual by this when specific time node reaches
The current output state of each data warehouse table is sent to user in group, and whole process does not need user's manual queries, inquiry effect
Rate is higher, and realizes Classification Management, better user experience to data warehouse table.
The second embodiment of the present disclosure provides a kind of management method of data warehouse table, the process of this method as shown in Fig. 2,
Including step S201 to S206:
The data warehouse table of selection is added in virtual group by S201 in response to the selection to data warehouse table.
The embodiment of the present disclosure be provided with one it is default can operation interface, either data side or business side, can be
This, which is preset, to select the data warehouse table paid close attention in operation interface.
The above-mentioned data warehouse table having been selected can be uniformly added in a group, i.e., virtual group, virtual group can be set
Set multiple, may exist multiple data warehouse tables in each virtual group, in virtual group 1 and virtual group 2 there may be identical
Data warehouse table needs 3 data warehouse tables for example, virtual group 1 is created for task A, and virtual group 2 is for task B wound
It builds, needs 5 data warehouse tables, data warehouse table 1 and data warehouse table 2 are both the data warehouse table that task A needs,
It is the data warehouse table that task B needs, then can has data warehouse table 1 and data warehouse table 2 in virtual group 1 and virtual group 2.
When realization, can for user it is default can the operation of operation interface be that different virtual groups modifies different titles, with convenient
User management and memory.
S202 is virtual group configuration member in response to the selection to member in virtual group.
User can also be in the above-mentioned default member that can add the virtual group in operation interface.When being added to virtual group membership
Afterwards, people relevant to virtual group does not need oneself creation virtual group, and it is virtual can be directly viewable having created of being added into
In group, which, which facilitates, carries out same task related personnel to summarize notice, and relevant personnel are it can be seen that data warehouse
The variation of table, better user experience.In some cases, it the process and optionally operates.
S203, it is corresponding for all data warehouse table configurations in response to the selection of the advice method to data warehouse table
Advice method.
When realization, can receive user it is default can operation interface be the logical of data warehouse table selection all in virtual group
Know mode.Above-mentioned advice method may include a variety of, for example, sent inside hair mail, data warehouse list management system message,
It sends short messages and breath or makes a phone call voice broadcast etc., herein without limiting, user can choose one or more of them, own
The notice for being sent to user mode can be sent as per advice.In some cases, which is not essential operation, Ke Yiyou
System default setting.
Corresponding advice method can be respectively set for each data warehouse table in the process, can basis specifically when setting
The important level of data warehouse table is configured, for example, data warehouse table 1 is extremely important for a user, then it can be by number
Being set as phone alerts according to the advice method of warehouse table 1 adds short message to remind.
S204 determines the corresponding notice grade of current output state when specific time node reaches.
Above-mentioned specific time may include a variety of situations, such as current output state changed time, agreement output
Time etc..
User is bothered in order to reduce as far as possible, the above-mentioned specific time node of the embodiment of the present disclosure can also be pre-
First it is default can all data warehouse tables in the virtual group of operation interface setting examination reminder time, the examination reminder time
May be generally applicable to multiple data warehouse tables under a task, due to need this multiple data warehouse table all output the case where
Under can execute task, therefore one unified reminder time, such as all data can be set for multiple data warehouse tables
The agreement output time of the last one data warehouse table in warehouse table, in this manner it is possible to be reminded when arranging the arrival of output time
User checks the variation of above-mentioned multiple data warehouse tables.
For different current output states, notify grade different, for example, current output state is corresponding in production
Notice grade it is minimum, current output state be postponement production in corresponding notice grade highest.
S205 determines the advice method to match with notice grade in configured advice method.
It is that then only can send message in production inside data warehouse list management system, work as in current output state
Preceding output state is in postponement production, then can make a phone call voice broadcast etc..Those skilled in the art can be according to actual needs
Corresponding to be configured, which can also be also disposed in default can be configured in operation interface by user oneself.
In the present embodiment, due to it is aforementioned be that data warehouse table is respectively provided with advice method, can be preferential
Using the advice method of personal settings, it is of course also possible in the advice method and personal settings that match with notice grade
Advice method in selection be easier the advice method that causes user to pay attention to, although for example, user is provided with all current productions
Do well and all only send mail, but for notifying higher ranked data warehouse table, can on the basis of sending mail into
One step sends short message.
If being not provided with advice method in user's aforementioned process, can there can be default setting according to system, i.e., it is different
Current output state corresponded to different notice grades, it is logical that the corresponding notice grade some of current output state can be only used
Know that mode sends notice, can will not be caused by message preferably by current output state notifying to user and excessively beat
Disturb the normal work of user.
S206 sends the current output of the data warehouse table in virtual group according to the advice method to match with notice grade
State.
Different reminder time and advice method can be respectively set in business side and data side, realize same data warehouse
Indicator carries out different management to different user, and the way to manage of the customized manner can bring better user experience.
The embodiment of the present disclosure realize allow user it is default can operation interface selection data warehouse table, and by the number of selection
All it is added in a virtual group according to warehouse table, reason data warehouse table don't bother about by different virtual components, click to enter any
One virtual group can view the data warehouse table for wanting to check, can also be according to correspondence when specific time node reaches
Advice method the current output state of data warehouse table each in the virtual group is sent to user, whole process does not need to use
Family manual queries, search efficiency is higher, and realizes Classification Management, better user experience to data warehouse table.
The third embodiment of the present disclosure provides a kind of managing device of data warehouse table, the structural representation of the device such as Fig. 3
It is shown, comprising:
Adding module 10, is configured in response to the selection to data warehouse table, and the data warehouse table of selection is added to void
In quasi- group；Sending module 20 is coupled with adding module 10, is configured to send in virtual group when specific time node reaches
The current output state of data warehouse table.
The embodiment of the present disclosure be provided with one it is default can operation interface, either data side or business side, can be
This, which is preset, to select the data warehouse table paid close attention in operation interface.
The above-mentioned data warehouse table having been selected can be uniformly added in a group, i.e., virtual group, virtual group can be set
Set multiple, may exist multiple data warehouse tables in each virtual group, in virtual group 1 and virtual group 2 there may be identical
Data warehouse table needs 3 data warehouse tables for example, virtual group 1 is created for task A, and virtual group 2 is for task B wound
It builds, needs 5 data warehouse tables, data warehouse table 1 and data warehouse table 2 are both the data warehouse table that task A needs,
It is the data warehouse table that task B needs, then can has data warehouse table 1 and data warehouse table 2 in virtual group 1 and virtual group 2.
When realization, can for user it is default can the operation of operation interface be that different virtual groups modifies different titles, with convenient
User management and memory.
Above-mentioned specific time node may include a variety of situations, such as current output state changed time, agreement
Output time etc..
User is bothered in order to reduce as far as possible, the above-mentioned specific time node of the embodiment of the present disclosure can also be pre-
First it is default can all data warehouse tables in the virtual group of operation interface setting examination reminder time, the examination reminder time
May be generally applicable to multiple data warehouse tables under a task, due to need this multiple data warehouse table all output the case where
Under can execute task, therefore one unified reminder time, such as all data can be set for multiple data warehouse tables
The agreement output time of the last one data warehouse table in warehouse table, in this manner it is possible to be reminded when arranging the arrival of output time
User checks the variation of above-mentioned multiple data warehouse tables.
Different reminder times can be respectively set in business side and data side, realize same data warehouse indicator to difference
User carries out different management, and the way to manage of the customized manner can bring better user experience.
When realization, above-mentioned apparatus further include: the first setup module is configured in response to the selection to member in virtual group,
For virtual group configuration member；Sending module is additionally configured to for current output state to be sent to the member of virtual group.When being added to void
After quasi- group membership, people relevant to virtual group does not need oneself creation virtual group, can be directly viewable the wound being added into
In the virtual group built, which, which facilitates, summarize notice for same task related personnel, and relevant personnel it can be seen that
The variation of data warehouse table, better user experience.
Above-mentioned apparatus can also include the second setup module, be configured to the choosing in response to the advice method to data warehouse table
It selects, configures corresponding advice method for all data warehouse tables.Above-mentioned advice method may include a variety of, for example, hair postal
Message is sent inside part, data warehouse list management system, sends short messages and breath or makes a phone call voice broadcast etc., herein without limit
Fixed, user can choose one or more of them, and all notices for being sent to user mode can be sent as per advice.At certain
In a little situations, which is not essential operation, can be arranged by system default.
Corresponding advice method can be respectively set for each data warehouse table in the process, can basis specifically when setting
The important level of data warehouse table is configured, for example, data warehouse table 1 is extremely important for a user, then it can be by number
Being set as phone alerts according to the advice method of warehouse table 1 adds short message to remind.
It is determined to advanced optimize advice method, above-mentioned sending module when concrete configuration is that specific time node reaches
The currently corresponding notice grade of output state；The notice side to match with notice grade is determined in configured advice method
Formula；The current output state of the data warehouse table in virtual group is sent according to the advice method to match with notice grade.
Above-mentioned specific time may include a variety of situations, such as current output state changed time, agreement output
Time etc..
User is bothered in order to reduce as far as possible, the above-mentioned specific time node of the embodiment of the present disclosure can also be pre-
First it is default can all data warehouse tables in the virtual group of operation interface setting examination reminder time, the examination reminder time
May be generally applicable to multiple data warehouse tables under a task, due to need this multiple data warehouse table all output the case where
Under can execute task, therefore one unified reminder time, such as all data can be set for multiple data warehouse tables
The agreement output time of the last one data warehouse table in warehouse table, in this manner it is possible to be reminded when arranging the arrival of output time
User checks the variation of above-mentioned multiple data warehouse tables.
For different current output states, notify grade different, for example, current output state is corresponding in production
Notice grade it is minimum, current output state be postponement production in corresponding notice grade highest.
It is that then only can send message in production inside data warehouse list management system, work as in current output state
Preceding output state is in postponement production, then can make a phone call voice broadcast etc..Those skilled in the art can be according to actual needs
Corresponding to be configured, which can also be also disposed in default can be configured in operation interface by user oneself.
In the present embodiment, due to it is aforementioned be that data warehouse table is respectively provided with advice method, can be preferential
Using the advice method of personal settings, it is of course also possible in the advice method and personal settings that match with notice grade
Advice method in selection be easier the advice method that causes user to pay attention to, although for example, user is provided with all current productions
Do well and all only send mail, but for notifying higher ranked data warehouse table, can on the basis of sending mail into
One step sends short message.
If being not provided with advice method in user's aforementioned process, can there can be default setting according to system, i.e., it is different
Current output state corresponded to different notice grades, it is logical that the corresponding notice grade some of current output state can be only used
Know that mode sends notice, can will not be caused by message preferably by current output state notifying to user and excessively beat
Disturb the normal work of user.
Different reminder time and advice method can be respectively set in business side and data side, realize same data warehouse
Indicator carries out different management to different user, and the way to manage of the customized manner can bring better user experience.
The embodiment of the present disclosure realize allow user it is default can operation interface selection data warehouse table, and by the number of selection
All it is added in a virtual group according to warehouse table, reason data warehouse table don't bother about by different virtual components, click to enter any
One virtual group can view the data warehouse table for wanting to check, can also be according to correspondence when specific time node reaches
Advice method the current output state of data warehouse table each in the virtual group is sent to user, whole process does not need to use
Family manual queries, search efficiency is higher, and realizes Classification Management, better user experience to data warehouse table.
The fourth embodiment of the present disclosure provides a kind of storage medium, is stored with computer program, which is located
The method for realizing that disclosure any embodiment provides when device executes is managed, includes the following steps S1 to S2:
The data warehouse table of selection is added in virtual group by S1 in response to the selection to data warehouse table；
S2 sends the current output state of the data warehouse table in virtual group when specific time node reaches.
Above-mentioned specific time node includes at least following one: the current output state changed time presets
Virtual group in all data warehouse tables examination reminder time, agreement the output time.
Computer program can also be executed by processor following steps: in response to the selection to member in virtual group, for void
Quasi- group configuration member；Current output state is sent to the member of virtual group.
Computer program can also be executed by processor following steps: in response to the choosing of the advice method to data warehouse table
It selects, configures corresponding advice method for all data warehouse tables.
When computer program is executed by processor the step for sending the current output state of the data warehouse table in virtual group,
It is specifically executed by processor following steps: determining the corresponding notice grade of current output state；In configured advice method
Determine the advice method to match with notice grade；The number in virtual group is sent according to the advice method to match with notice grade
According to the current output state of warehouse table.
The embodiment of the present disclosure realize allow user it is default can operation interface selection data warehouse table, and by the number of selection
All it is added in a virtual group according to warehouse table, reason data warehouse table don't bother about by different virtual components, click to enter any
One virtual group can view the data warehouse table for wanting to check, can also be virtual by this when specific time node reaches
The current output state of each data warehouse table is sent to user in group, and whole process does not need user's manual queries, inquiry effect
Rate is higher, and realizes Classification Management, better user experience to data warehouse table.
Optionally, in the present embodiment, above-mentioned storage medium can include but is not limited to: USB flash disk, read-only memory (ROM,
Read-Only Memory), random access memory (RAM, Random Access Memory), mobile hard disk, magnetic disk or
The various media that can store program code such as CD.Optionally, in the present embodiment, processor has been deposited according in storage medium
The program code of storage executes the method and step of above-described embodiment record.Optionally, the specific example in the present embodiment can refer to
Example described in above-described embodiment and optional embodiment, details are not described herein for the present embodiment.Obviously, the technology of this field
Personnel should be understood that each module of the above-mentioned disclosure or each step can be realized with general computing device, they can be with
It is concentrated on a single computing device, or is distributed over a network of multiple computing devices, optionally, they can be used
Computing device executable program code is realized, is held it is thus possible to be stored in storage device by computing device
Row, and in some cases, can with the steps shown or described are performed in an order that is different from the one herein, or by they point
It is not fabricated to each integrated circuit modules, or makes multiple modules or steps in them to single integrated circuit module
It realizes.It is combined in this way, the disclosure is not limited to any specific hardware and software.
The fifth embodiment of the present disclosure provides a kind of electronic equipment, as shown in figure 4, the electronic equipment includes at least memory
901 and processor 902, computer program is stored on memory 901, and processor 902 is executing the computer on memory 901
The method that disclosure any embodiment provides, illustratively, computer program steps following S11 to S12 are realized when program:
The data warehouse table of selection is added in virtual group by S11 in response to the selection to data warehouse table；
S12 sends the current output state of the data warehouse table in virtual group when specific time node reaches.
Above-mentioned specific time node includes at least following one: the current output state changed time presets
Virtual group in all data warehouse tables examination reminder time, agreement the output time.
Processor 902 can execute
The following computer program of the execution stored on memory 901: being virtual in response to the selection to member in virtual group
Group configuration member；Current output state is sent to the member of virtual group.
Processor 902 can execute the following computer program of the execution stored on memory 901: in response to data warehouse
The selection of the advice method of table configures corresponding advice method for all data warehouse tables.
The current output shape for the data warehouse table in transmission virtual group that processor 902 stores on executing memory 901
When the computer program of state, following computer program is specifically executed: determining the corresponding notice grade of current output state；Matching
The advice method to match with notice grade is determined in the advice method set；It is sent out according to the advice method to match with notice grade
Send the current output state of the data warehouse table in virtual group.
The embodiment of the present disclosure realize allow user it is default can operation interface selection data warehouse table, and by the number of selection
All it is added in a virtual group according to warehouse table, reason data warehouse table don't bother about by different virtual components, click to enter any
One virtual group can view the data warehouse table for wanting to check, can also be virtual by this when specific time node reaches
The current output state of each data warehouse table is sent to user in group, and whole process does not need user's manual queries, inquiry effect
Rate is higher, and realizes Classification Management, better user experience to data warehouse table.
In addition, range includes any and all based on this public affairs although exemplary embodiment has been described herein
That opens has equivalent element, modification, omission, combination (for example, scheme that various embodiments are intersected), reorganization or the implementation changed
Example.Element in claims will be construed broadly as based on the language used in claim, however it is not limited in this explanation
Described example, example are to be interpreted as nonexcludability in book or during the implementation of the application.Therefore, this specification and
Example is intended to be to be considered only as example, and real scope and spirit are by following following claims and the full scope of its equivalent institute
Instruction.
Above description is intended to illustrative rather than restrictive.For example, above-mentioned example (or one or more side
Case) it can be in combination with one another.Such as other embodiments can be used when reading foregoing description in those of ordinary skill in the art.
In addition, various features can be grouped together to simplify the disclosure in above-mentioned specific embodiment.This should not be construed as
A kind of not claimed disclosed feature is necessary intention for any claim.On the contrary, the theme of the disclosure can be with
Less than whole features of specific disclosed embodiment.To which following claims is incorporated to herein as example or embodiment
In specific embodiment, wherein each claim is independently as individual embodiment, and consider that these embodiments can be with
It is combined with each other with various combinations or arrangement.The scope of the present disclosure should refer to appended claims and these claims are entitled
The full scope of equivalent form determines.
The multiple embodiments of the disclosure are described in detail above, but the present disclosure is not limited to these specific embodiments,
Those skilled in the art can make a variety of variants and modifications embodiments on the basis of the disclosure is conceived, these modifications and repair
Change should all fall into the disclosure it is claimed within the scope of.
Claims (12)
1. a kind of management method of data warehouse table characterized by comprising
In response to the selection to data warehouse table, the data warehouse table of selection is added in virtual group；
When specific time node reaches, the current output state of the data warehouse table in the virtual group is sent.
2. the method as described in claim 1, which is characterized in that the method also includes:
It is the virtual group configuration member in response to the selection to member in the virtual group；
The current output state is sent to the member of the virtual group.
3. the method as described in claim 1, which is characterized in that the specific time node includes at least following one: current
The examination reminder time of all data warehouse tables in output state changed time, the pre-set virtual group,
Arrange the output time.
4. method according to any one of claims 1 to 3, which is characterized in that the method also includes:
It is corresponding logical for all data warehouse table configurations in response to the selection of the advice method to the data warehouse table
Know mode.
5. method as claimed in claim 4, which is characterized in that described to send the data warehouse table in the virtual group
Current output state, comprising:
Determine the corresponding notice grade of the current output state；
The determining advice method to match with the notice grade in the configured advice method；
The data warehouse table in the virtual group is sent according to the advice method to match with the notice grade
The current output state.
6. a kind of managing device of data warehouse table characterized by comprising
Adding module is configured to be added to the data warehouse table of selection virtually in response to the selection to data warehouse table
In group；
Sending module is configured to send working as the data warehouse table in the virtual group when specific time node reaches
Preceding output state.
7. device as claimed in claim 6, which is characterized in that further include:
First setup module is configured in response to the selection to member in the virtual group, is the virtual group configuration member；
The sending module is additionally configured to for the current output state to be sent to the member of the virtual group.
8. device as claimed in claim 6, which is characterized in that the specific time node includes at least following one: current
The examination reminder time of all data warehouse tables in output state changed time, the pre-set virtual group,
Arrange the output time.
9. the device as described in any one of claim 6 to 8, which is characterized in that further include:
Second setup module is configured to the selection in response to the advice method to the data warehouse table, for all numbers
Corresponding advice method is configured according to warehouse table.
10. device as claimed in claim 9, which is characterized in that
The sending module determines the corresponding notice of the current output state when concrete configuration is that specific time node reaches
Grade；The determining advice method to match with the notice grade in the configured advice method；Lead to according to described
Know that the advice method that grade matches sends the current output state of the data warehouse table in the virtual group.
11. a kind of storage medium, is stored with computer program, which is characterized in that when the computer program is executed by processor
The step of realizing any one of claims 1 to 5 the method.
12. a kind of electronic equipment includes at least memory, processor, is stored with computer program, feature on the memory
It is, the processor realizes side described in any one of claims 1 to 5 when executing the computer program on the memory
The step of method.
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 true CN110032554A (en) | 2019-07-19 |
| CN110032554B 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 (11)
| 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 |
| EP2767913A1 (en) * | 2013-02-13 | 2014-08-20 | Facebook, Inc. | Hive table links |
| CN104598531A (en) * | 2014-12-25 | 2015-05-06 | 广东电子工业研究院有限公司 | Incremental data migration method among heterogeneous relational databases based on trigger |
| CN106096908A (en) * | 2016-06-02 | 2016-11-09 | 深圳铂睿智恒科技有限公司 | A kind of project process monitor prompt method and system |
| CN106933857A (en) * | 2015-12-30 | 2017-07-07 | 阿里巴巴集团控股有限公司 | The dispatching method of task, device in a kind of data warehouse |
| CN107665243A (en) * | 2017-09-11 | 2018-02-06 | 安徽慧视金瞳科技有限公司 | A kind of across language environment data interactive 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 |
| CN108509440A (en) * | 2017-02-24 | 2018-09-07 | 腾讯科技（深圳）有限公司 | A kind of data processing method and device |
| 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 |
-
2019
- 2019-04-10 CN CN201910285516.8A patent/CN110032554B/en active Active
Patent Citations (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6633878B1 (en) * | 1999-07-30 | 2003-10-14 | Accenture Llp | Initializing an ecommerce database framework |
| EP2767913A1 (en) * | 2013-02-13 | 2014-08-20 | Facebook, Inc. | Hive table links |
| CN103870605A (en) * | 2014-04-08 | 2014-06-18 | 南京优玛软件科技有限公司 | Data base virtual image achieving method orientated to object |
| CN104598531A (en) * | 2014-12-25 | 2015-05-06 | 广东电子工业研究院有限公司 | Incremental data migration method among heterogeneous relational databases based on trigger |
| CN106933857A (en) * | 2015-12-30 | 2017-07-07 | 阿里巴巴集团控股有限公司 | The dispatching method of task, device in a kind of data warehouse |
| 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 |
| CN108733713A (en) * | 2017-04-21 | 2018-11-02 | 阿里巴巴集团控股有限公司 | Data query method and device in data warehouse |
| CN107665243A (en) * | 2017-09-11 | 2018-02-06 | 安徽慧视金瞳科技有限公司 | A kind of across language environment data interactive 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 |
| 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 |
|---|---|
| CN110032554B (en) | 2022-04-01 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106528129B (en) | A kind of Web application interface generation system and method | |
| CN104115139B (en) | Configurable workflow ability is provided | |
| CN107861982A (en) | It is dynamically determined method, terminal, server and the system of application program page layout | |
| CN110110543A (en) | Data processing method, device, server and storage medium | |
| CN103782275B (en) | For the system and method for the resource for managing portable computing | |
| CN109766097A (en) | UI generation method, device, electronic equipment and computer readable storage medium | |
| CN101472016A (en) | Administering multiple target ACD systems | |
| CN102137029A (en) | Method and device for managing instant messaging contact information | |
| CN110430121A (en) | Message informing method and device | |
| CN102006365A (en) | Contact affinity-disaffinity relationship display method, device and mobile terminal | |
| CN110233741A (en) | Service charging method, device, equipment and storage medium | |
| CN110400067A (en) | A kind of method and system of purpose balance management | |
| CN101706818A (en) | Report dynamic filtering method and device | |
| CN103870269A (en) | Method and apparatus to provide advertisement data | |
| CN107612753A (en) | Processing method, device and the radio reception device of wireless messages | |
| CN109039670A (en) | The sharing method and device of team's configuration method, team's allocation plan | |
| CN104065684B (en) | Information processing method, electronic equipment and terminal device | |
| CN108536356A (en) | Seating stand processing method, device and computer readable storage medium | |
| CN110032554A (en) | Management method, device, storage medium and the electronic equipment of data warehouse table | |
| CN109829680B (en) | Scheduling method, scheduling device, computer device and storage medium | |
| CN111027299A (en) | Form generation method and system | |
| CN109857619A (en) | State subscription method, apparatus, storage medium and the electronic equipment of data warehouse table | |
| CN109656638A (en) | A kind of user based on Purley platform customizes the implementation method of function | |
| CN109117225A (en) | A kind of display interface dynamic adjusting method, device, equipment and readable storage medium storing program for executing | |
| CN109857720A (en) | Database table monitoring method, device, computer installation and readable storage medium storing program for executing |
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 | ||
| 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. |
|
| TR01 | Transfer of patent right | ||
| 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. |