CN109783470A - Owner's follow-up mechanism, method and the storage medium of database subsystem - Google Patents
Owner's follow-up mechanism, method and the storage medium of database subsystem Download PDFInfo
- Publication number
- CN109783470A CN109783470A CN201811526208.1A CN201811526208A CN109783470A CN 109783470 A CN109783470 A CN 109783470A CN 201811526208 A CN201811526208 A CN 201811526208A CN 109783470 A CN109783470 A CN 109783470A
- Authority
- CN
- China
- Prior art keywords
- subsystem
- owner
- database
- work order
- typing
- 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
- 238000000034 method Methods 0.000 title claims abstract description 33
- 230000007246 mechanism Effects 0.000 title claims abstract description 24
- 238000003032 molecular docking Methods 0.000 claims abstract description 104
- 238000012545 processing Methods 0.000 claims description 27
- 230000009897 systematic effect Effects 0.000 claims description 24
- 230000008859 change Effects 0.000 claims description 20
- 230000004048 modification Effects 0.000 claims description 6
- 238000012986 modification Methods 0.000 claims description 6
- 238000012508 change request Methods 0.000 claims description 4
- 230000004044 response Effects 0.000 abstract description 5
- 238000005516 engineering process Methods 0.000 abstract 1
- 238000007726 management method Methods 0.000 description 66
- 238000013475 authorization Methods 0.000 description 8
- 230000008569 process Effects 0.000 description 5
- 238000010586 diagram Methods 0.000 description 4
- 238000004891 communication Methods 0.000 description 2
- 230000006870 function Effects 0.000 description 2
- 238000004321 preservation Methods 0.000 description 2
- 238000012550 audit Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 230000010365 information processing Effects 0.000 description 1
- 230000003993 interaction Effects 0.000 description 1
- 238000012423 maintenance Methods 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention relates to a kind of database technologys, disclose owner's follow-up mechanism, method and the storage medium of a kind of database subsystem, this method comprises: creating owner's work order in the scheduled catalogue of database, the user management account for obtaining the system name of each subsystem of the database and the docking people of each subsystem, increases separately typing position in owner's work order；According to owner's work order predetermined format each subsystem of typing position typing system name and user management account；After the completion of typing, call scheduled interface that the content in owner's work order is written in the allocation list that the database is safeguarded and is stored；When receive check request after, obtain the allocation list of storage and return, shown on owner's system page, for search each subsystem docking people user management account.The present invention can find the docking people of the subsystem of database, quick response business demand in time.
Description
Technical field
The present invention relates to database technical field more particularly to a kind of owner's follow-up mechanisms of database subsystem, method
And storage medium.
Background technique
Currently, needing to be determined according to table name should if user wants the authorization of the table of some subsystem in request for data library
Which subsystem table belongs to, and then determines docking people further according to subsystem, after the authorization for obtaining docking people, can just check this
Table in database in subsystem then primarily determines it is table that core protects subsystem for example, table name band " uws ".But this method
It is inaccurate, for example, table name band " lifexxx ", the actually subsystem in any one database may all have this class name,
The time for needing user effort more in this way goes the docking people of the subsystem of consulting Database one by one, and low efficiency can not timely Shen
Authorization please be arrive, the realization period of entire demand is influenced.
Summary of the invention
The purpose of the present invention is to provide owner's follow-up mechanism, method and the storage medium of a kind of database subsystem, purports
In the docking people for finding the subsystem of database in time, quick response business demand.
To achieve the above object, the present invention provides a kind of owner's follow-up mechanism of database subsystem, the database subsystem
Owner's follow-up mechanism of system includes memory and the processor that connect with the memory, and being stored in the memory can be
The processing system run on the processor, the processing system realize following steps when being executed by the processor:
Owner's work order is created in the scheduled catalogue of database, obtains the system name and each subsystem of each subsystem of the database
The user management account of the docking people of system, increases separately the typing of the system name and user management account in owner's work order
Position；
According to owner's work order predetermined format each subsystem of typing position typing system name and each subsystem
Dock the user management account of people；
After the completion of typing, system name and each subsystem of the scheduled interface by each subsystem in owner's work order are called
The user management account of docking people be written in the allocation list that the database is safeguarded, and store the allocation list；
After owner's system page in the database, which receives, checks request, matching for request storage is checked based on this
It sets table and returns, shown on owner's system page, for searching the user management account for docking people of each subsystem.
Preferably, the scheduled catalogue is srvbot catalogue.
Preferably, when the processing system is executed by the processor, following steps are also realized:
If the database has newly-increased subsystem and docking people, newly-increased work order is created in the scheduled catalogue, at this
The system name of newly-increased subsystem and the typing position for the user management account for docking people are increased separately in newly-increased work order；
According to predetermined format in the system name of the newly-increased subsystem of the typing position typing and the user management account of docking people
Number；
After the completion of typing, call the scheduled interface that this is increased newly to the system name of newly-increased subsystem in work order and right
The user management account for meeting people is written in the allocation list.
Preferably, when the processing system is executed by the processor, following steps are also realized:
If the database has, subsystem is offline, the creation replacement work order in the scheduled catalogue, in the replacement work order
Increase the typing position of the system name of underlined subsystem；
According to predetermined format the offline subsystem of the typing position typing system name；
After the completion of typing, call the scheduled interface that will replace the system name in work order and the system in the allocation list
Name is matched, after identical system name is matched in the allocation list, by the system name being matched in the allocation list and
The user management account of the corresponding docking people of the system name is deleted.
To achieve the above object, the present invention also provides a kind of owner's method for tracing of database subsystem, the databases
Owner's method for tracing of subsystem includes:
S1 creates owner's work order in the scheduled catalogue of database, obtains the system name of each subsystem of the database and each
The user management account of the docking people of subsystem, increases separately the system name and user management account in owner's work order
Typing position；
S2, according to owner's work order predetermined format each subsystem of typing position typing system name and each subsystem
Docking people user management account；
S3 calls system name and each son of the scheduled interface by each subsystem in owner's work order after the completion of typing
The user management account of the docking people of system is written in the allocation list that the database is safeguarded, and stores the allocation list；
S4 checks that request stores based on this after owner's system page in the database, which receives, checks request
Allocation list and return, shown on owner's system page, for search each subsystem docking people user management
Account.
Preferably, the scheduled catalogue is srvbot catalogue.
Preferably, after the step S4, further includes:
If the database has newly-increased subsystem and docking people, newly-increased work order is created in the scheduled catalogue, at this
The system name of newly-increased subsystem and the typing position for the user management account for docking people are increased separately in newly-increased work order；
According to predetermined format in the system name of the newly-increased subsystem of the typing position typing and the user management account of docking people
Number；
After the completion of typing, call the scheduled interface that this is increased newly to the system name of newly-increased subsystem in work order and right
The user management account for meeting people is written in the allocation list.
Preferably, after the step S4, further includes:
If the database has, subsystem is offline, the creation replacement work order in the scheduled catalogue, in the replacement work order
Increase the typing position of the system name of underlined subsystem；
According to predetermined format the offline subsystem of the typing position typing system name；
After the completion of typing, call the scheduled interface that will replace the system name in work order and the system in the allocation list
Name is matched, after identical system name is matched in the allocation list, by the system name being matched in the allocation list and
The user management account of the corresponding docking people of the system name is deleted.
Preferably, after the step S4, further includes:
If the docking human hair of the subsystem of the database changes more, the creation change work order in the scheduled catalogue,
The record of the user management account of changed docking people and the systematic name of corresponding subsystem is increased separately in the change work order
Enter position；
According to predetermined format the typing position typing changed docking people user management account and corresponding subsystem
The systematic name of system；
After the completion of typing, call the scheduled interface that will change the systematic name and the configuration of the subsystem in work order
The systematic name of subsystem in table is matched, and after identical systematic name is matched in the allocation list, is matched described
It sets in table and the user management account of the corresponding docking people of the systematic name being matched to is changed to user in the change work order
Manage account；Or
If the docking human hair of the subsystem of the database changes more, after receiving change request, by the allocation list
It is back on owner's system page and shows, for the user management account of the modification docking people on owner's system page.
The present invention also provides a kind of computer readable storage medium, processing is stored on the computer readable storage medium
The step of system, the processing system realizes owner's method for tracing of above-mentioned database subsystem when being executed by processor.
The beneficial effects of the present invention are: the present invention creates owner's work order first in catalogue, according to the pre- of owner's work order
Then the formula that fixes is called in the system name of each subsystem of typing position typing and the user management account of the docking people of each subsystem
Scheduled interface writes the user management account of the docking people of the system name of each subsystem in owner's work order and each subsystem
Enter in the allocation list that the database is safeguarded, and it is corresponding right based on each subsystem of allocation list inquiry for user to provide the page
The user management account of people is connect, the docking people of the subsystem of database can be found in time, quick response business demand improves
Efficiency avoids the realization period for influencing entire demand.
Detailed description of the invention
Fig. 1 is the schematic diagram of the hardware structure of one embodiment of owner's follow-up mechanism of database subsystem of the present invention；
Fig. 2 is the flow diagram of owner's method for tracing first embodiment of database subsystem of the present invention；
Fig. 3 is the flow diagram of owner's method for tracing second embodiment of database subsystem of the present invention；
Fig. 4 is the flow diagram of owner's method for tracing 3rd embodiment of database subsystem of the present invention.
Specific embodiment
In order to make the objectives, technical solutions, and advantages of the present invention clearer, with reference to the accompanying drawings and embodiments, right
The present invention is further elaborated.It should be appreciated that described herein, specific examples are only used to explain the present invention, not
For limiting the present invention.Based on the embodiments of the present invention, those of ordinary skill in the art are not before making creative work
Every other embodiment obtained is put, shall fall within the protection scope of the present invention.
It should be noted that the description for being related to " first ", " second " etc. in the present invention is used for description purposes only, and cannot
It is interpreted as its relative importance of indication or suggestion or implicitly indicates the quantity of indicated technical characteristic.Define as a result, " the
One ", the feature of " second " can explicitly or implicitly include at least one of the features.In addition, the skill between each embodiment
Art scheme can be combined with each other, but must be based on can be realized by those of ordinary skill in the art, when technical solution
Will be understood that the combination of this technical solution is not present in conjunction with there is conflicting or cannot achieve when, also not the present invention claims
Protection scope within.
As shown in fig.1, being the hardware structure signal of one embodiment of owner's follow-up mechanism of database subsystem of the present invention
Figure.Owner's follow-up mechanism 1 of database subsystem is that one kind can be counted automatically according to the instruction for being previously set or storing
Value calculates and/or the equipment of information processing.Owner's follow-up mechanism 1 of the database subsystem can be computer, can also be with
Be single network server, multiple network servers composition server group or based on cloud computing by a large amount of hosts or net
The cloud that network server is constituted, wherein cloud computing is one kind of distributed computing, consisting of a loosely coupled set of computers
One super virtual computer.
In the present embodiment, owner's follow-up mechanism 1 of database subsystem may include, but be not limited only to, and can pass through system
Bus is in communication with each other the memory 11, processor 12, network interface 13 of connection, and memory 11, which is stored with, to be transported on the processor 12
Capable processing system.It should be pointed out that the owner that Fig. 1 illustrates only the database subsystem with component 11-13 tracks dress
1 is set, it should be understood that it is not required for implementing all components shown, more or less groups of the implementation that can be substituted
Part.
Wherein, memory 11 includes the readable storage medium storing program for executing of memory and at least one type.Inside save as database subsystem
Owner's follow-up mechanism 1 operation provide caching；Readable storage medium storing program for executing can be for such as flash memory, hard disk, multimedia card, card-type memory
(for example, SD or DX memory etc.), random access storage device (RAM), static random-access memory (SRAM), read-only memory
(ROM), electrically erasable programmable read-only memory (EEPROM), programmable read only memory (PROM), magnetic storage, magnetic
The non-volatile memory medium of disk, CD etc..In some embodiments, readable storage medium storing program for executing can be the category of database subsystem
The internal storage unit of main follow-up mechanism 1, for example, the database subsystem owner's follow-up mechanism 1 hard disk；In other realities
It applies in example, which is also possible to the External memory equipment of owner's follow-up mechanism 1 of database subsystem, example
As database subsystem owner's follow-up mechanism 1 on the plug-in type hard disk that is equipped with, intelligent memory card (Smart Media Card,
SMC), secure digital (Secure Digital, SD) blocks, flash card (Flash Card) etc..In the present embodiment, memory 11
Readable storage medium storing program for executing is installed on the operating system and types of applications of owner's follow-up mechanism 1 of database subsystem commonly used in storage
The program code etc. of processing system in software, such as storage one embodiment of the invention.In addition, memory 11 can be also used for temporarily
When store the Various types of data that has exported or will export.
The processor 12 can be in some embodiments central processing unit (Central Processing Unit,
CPU), controller, microcontroller, microprocessor or other data processing chips.The processor 12 is commonly used in the control number
According to the overall operation of owner's follow-up mechanism 1 of library subsystem, such as executes and carry out data interaction with other equipment or communicate phase
Control and processing of pass etc..In the present embodiment, the processor 12 is for running the program code stored in the memory 11
Or processing data, such as operation processing system etc..
The network interface 13 may include radio network interface or wired network interface, which is commonly used in
Communication connection is established between the owner's follow-up mechanism 1 and other electronic equipments of the database subsystem.
The processing system is stored in memory 11, is stored in including at least one computer-readable in memory 11
Instruction, at least one computer-readable instruction can be executed by processor device 12, the method to realize each embodiment of the application；With
And the function that at least one computer-readable instruction is realized according to its each section is different, can be divided into different logic moulds
Block.
In one embodiment, following steps are realized when above-mentioned processing system is executed by the processor 12:
Owner's work order is created in the scheduled catalogue of database, obtains the system name and each subsystem of each subsystem of the database
The user management account of the docking people of system, increases separately the typing of the system name and user management account in owner's work order
Position；
According to owner's work order predetermined format each subsystem of typing position typing system name and each subsystem
Dock the user management account of people；
After the completion of typing, system name and each subsystem of the scheduled interface by each subsystem in owner's work order are called
The user management account of docking people be written in the allocation list that the database is safeguarded, and store the allocation list；
After owner's system page in the database, which receives, checks request, matching for request storage is checked based on this
It sets table and returns, shown on owner's system page, for searching the user management account for docking people of each subsystem.
Further, the scheduled catalogue is srvbot catalogue.
Further, when the processing system is executed by the processor, following steps are also realized:
If the database has newly-increased subsystem and docking people, newly-increased work order is created in the scheduled catalogue, at this
The system name of newly-increased subsystem and the typing position for the user management account for docking people are increased separately in newly-increased work order；
According to predetermined format in the system name of the newly-increased subsystem of the typing position typing and the user management account of docking people
Number；
After the completion of typing, call the scheduled interface that this is increased newly to the system name of newly-increased subsystem in work order and right
The user management account for meeting people is written in the allocation list.
Further, when the processing system is executed by the processor, following steps are also realized:
If the database has, subsystem is offline, the creation replacement work order in the scheduled catalogue, in the replacement work order
Increase the typing position of the system name of underlined subsystem；
According to predetermined format the offline subsystem of the typing position typing system name；
After the completion of typing, call the scheduled interface that will replace the system name in work order and the system in the allocation list
Name is matched, after identical system name is matched in the allocation list, by the system name being matched in the allocation list and
The user management account of the corresponding docking people of the system name is deleted.
Further, when the processing system is executed by the processor, following steps are also realized:
If the docking human hair of the subsystem of the database changes more, the creation change work order in the scheduled catalogue,
The record of the user management account of changed docking people and the systematic name of corresponding subsystem is increased separately in the change work order
Enter position；
According to predetermined format the typing position typing changed docking people user management account and corresponding subsystem
The systematic name of system；
After the completion of typing, call the scheduled interface that will change the systematic name and the configuration of the subsystem in work order
The systematic name of subsystem in table is matched, and after identical systematic name is matched in the allocation list, is matched described
It sets in table and the user management account of the corresponding docking people of the systematic name being matched to is changed to user in the change work order
Manage account；Or
If the docking human hair of the subsystem of the database changes more, after receiving change request, by the allocation list
It is back on owner's system page and shows, for the user management account of the modification docking people on owner's system page.
The present invention creates owner's work order first in catalogue, according to the predetermined format of owner's work order in the typing of typing position
The user management account of the docking people of the system name of each subsystem and each subsystem, then calls scheduled interface by owner's work
What the user management account of the docking people of the system name and each subsystem of each subsystem on list was written that the database safeguarded matches
It sets in table, and the user management account that the page inquires the corresponding docking people of each subsystem for user based on the allocation list is provided,
The docking people of the subsystem of database can be found in time, and quick response business demand improves efficiency, and avoids influencing entire
The realization period of demand.
As shown in Fig. 2, Fig. 2 is the process signal of owner's method for tracing first embodiment of database subsystem of the present invention
Figure, owner's method for tracing of the database subsystem the following steps are included:
Step S1 creates owner's work order in the scheduled catalogue of database, obtains the system name of each subsystem of the database
And the user management account of the docking people of each subsystem, the system name and user management account are increased separately in owner's work order
Number typing position；
Wherein, scheduled catalogue is the srvbot catalogue of database.Srvbot provides specification process, and srvbot itself is
Support built-in work order, it is only necessary to define the format of work order and the content that must be filled out.Owner is created in srvbot catalogue
The purpose of work order is to walk complete approval process by srvbot catalogue.
Step S2, according to owner's work order predetermined format each subsystem of typing position typing system name and each son
The user management account of the docking people of system；
Step S3, after the completion of typing, call scheduled interface by the system name of each subsystem in owner's work order and
The user management account of the docking people of each subsystem is written in the allocation list that the database is safeguarded, and stores the allocation list；
Wherein, the predetermined format of owner's work order is format artificially defined in advance.After the completion of typing, call scheduled
Interface writes the user management account of the system name of each subsystem in owner's work order and the corresponding docking personnel of each subsystem
In the allocation list for entering Database owner maintenance.Wherein, srvbot itself supports that define this owner's work order needs to call after the completion
What interface, the interface are http modes, and interface is particularly as being realized the word for word section write-in allocation list of the content in owner's work order
In, it is stored in Database owner system.
Step S4 checks request based on this after owner's system page in the database, which receives, checks request
The allocation list of storage and return, show on owner's system page, for search each subsystem docking people user
Manage account.
Wherein, the page is provided in the Database owner system for the corresponding docking people's of each subsystem of user query
Family manages account, after owner's system page in the database, which receives, checks request, by the allocation list of preservation return and
It is shown on the page, searches docking people for user.
Wherein, because having user management account corresponding contact method can be directly determined, including internal mailbox and
Phone etc. can send out mail to docking people, i.e., submit authorization requests to corresponding docking people by mail on network, dock people
Audit this authorization requests.Since the table to user's authorization subsystem is the version for needing to deliver under passing through, so not being straight
Authorization is connect, but docks people and only agrees to this authorization requests, docks people later for the corresponding version of table in database subsystem
Originally it is handed down to user, then user can check the table in the Database Systems.
In addition, in other embodiments, then user can also be searched by inputting table name on the page in allocation list
Corresponding docking people.The embodiment does a step compared to above-described embodiment more, that is, the table name of the table in subsystem is also closed
It is coupled in allocation list, for example, subsystem A includes table 1, table 2, table 3, the user management account for docking people is UM, then configuring
In table, incidence relation is [(subsystem A), (table 1, table 2, table 3), (UM)], and docking can be obtained in allocation list by table name
The user management account of people.
Compared with prior art, the present invention creates owner's work order first in catalogue, and pre- according to owner's work order fixes
Then formula is called predetermined in the system name of each subsystem of typing position typing and the user management account of the docking people of each subsystem
Interface should by the user management account write-in of the docking people of the system name of each subsystem in owner's work order and each subsystem
In the allocation list that database is safeguarded, and the page is provided and is based on the corresponding docking people of each subsystem of allocation list inquiry for user
User management account, the docking people of the subsystem of database can be found in time, quick response business demand improves effect
Rate avoids the realization period for influencing entire demand.
In a second embodiment, on the basis of the above embodiments, as shown in figure 3, after step s4, further includes: step
Rapid S5 creates newly-increased work order if the database has newly-increased subsystem and docking people in the scheduled catalogue, newly-increased at this
The system name of newly-increased subsystem is increased separately in work order and docks the typing position of the user management account of people；Step S6, is pressed
According to predetermined format in the system name of the newly-increased subsystem of the typing position typing and the user management account of docking people；Step S7,
After the completion of typing, calls the scheduled interface that this is increased newly to the system name of newly-increased subsystem in work order and dock the use of people
Family manages account and is written in the allocation list.
Wherein, if the database has newly-increased subsystem and docking people, request is submitted still through scheduled catalogue, i.e.,
Request is submitted by srvbot, and newly-increased work order is created in srvbot catalogue and covers regular examination & approval stream as described above
Cheng Hou, then added automatically by scheduled interface, which is also the interface of http mode, this is increased newly in work order
The system name of newly-increased subsystem and the user management account for docking people are written in the allocation list, realize and match when subsystem is newly-increased
Set the update operation of table.In this way, user still can find newly-increased subsystem by allocation list by the update of allocation list
Docking people user management account, application, improve flexibility.
In the third embodiment, on the basis of the above embodiments, as shown in figure 4, after step s4, further includes: step
Rapid S8, if the database has, subsystem is offline, and creation replacement work order, increases in the replacement work order in the scheduled catalogue
The typing position of the system name of offline subsystem；Step S9, according to the predetermined format subsystem offline in the typing position typing
The system name of system；Step S10 calls the scheduled interface to match the system name replaced in work order with described after the completion of typing
The system name set in table is matched, and after identical system name is matched in the allocation list, will be matched in the allocation list
To system name and the system name it is corresponding docking people user management account delete.
Wherein, if having, subsystem is offline, and request is submitted still through scheduled catalogue, i.e., is asked by srvbot to submit
It asks, the creation replacement work order in srvbot catalogue, as described above, after covering regular approval process, then automatically by pre-
Fixed interface addition, which is also the interface of http mode, by the replacement work order system name and the configuration
System name in table is matched, after being matched to identical system name, by the identical system name of this in allocation list and the system
The user management account of the corresponding docking people of name is deleted, and realizes the update operation of allocation list when subsystem is offline.In this way, logical
The update of allocation list is crossed, so that offline subsystem is not stored in allocation list, allocation list is more simplified.
In other embodiments, on the basis of the above embodiments, after step s4, further includes: if the database
The docking human hair of subsystem changes more, then the creation change work order in the scheduled catalogue, increases separately in the change work order
The typing position of the systematic name of the user management account and corresponding subsystem of the docking people changed；Exist according to predetermined format
The user management account for the docking people that the typing position typing is changed and the systematic name of corresponding subsystem；It is completed in typing
Afterwards, call the scheduled interface by the system of the subsystem in the systematic name and the allocation list that change the subsystem in work order
Title is matched, and after identical systematic name is matched in the allocation list, will be matched in the allocation list
The user management account of the corresponding docking people of systematic name is changed to the user management account in the change work order；Or
If the docking human hair of the subsystem of the database changes more, after receiving change request, by the allocation list
It is back on owner's system page and shows, for the user management account of the modification docking people on owner's system page.
Wherein, if there is the docking human hair of subsystem to change more, request can be still submitted by scheduled catalogue, that is, is passed through
Srvbot requests to submit, and creation change work order covers regular approval process as described above in srvbot catalogue
Afterwards, then automatically by scheduled interface it adds, which is also the interface of http mode, will be in the change work order
System name is matched with the system name in the allocation list, after being matched to identical system name, will be matched in allocation list
The user management account of the corresponding docking people of systematic name be changed to the user management account in the change work order, realize subsystem
The update operation of allocation list when docking people's variation of system.In this way, user still can pass through allocation list by the update of allocation list
The user management account that people is docked after subsystem changes is found, application improves flexibility.
Further, it is also possible to some simple-to-maintain functions are realized by owner's system page, such as quickly modification docking people etc.,
When the docking people of subsystem changes, by the control of " modification docking people " that owner's system page provides, configuration is returned to
It is shown on table to owner's system page, user directly modifies on owner's system page, then carries out
The update operation of allocation list when docking people changes is realized in preservation.
The present invention also provides a kind of computer readable storage medium, processing is stored on the computer readable storage medium
The step of system, the processing system realizes owner's method for tracing of above-mentioned database subsystem when being executed by processor.
The serial number of the above embodiments of the invention is only for description, does not represent the advantages or disadvantages of the embodiments.
Through the above description of the embodiments, those skilled in the art can be understood that above-described embodiment side
Method can be realized by means of software and necessary general hardware platform, naturally it is also possible to by hardware, but in many cases
The former is more preferably embodiment.Based on this understanding, technical solution of the present invention substantially in other words does the prior art
The part contributed out can be embodied in the form of software products, which is stored in a storage medium
In (such as ROM/RAM, magnetic disk, CD), including some instructions are used so that a terminal device (can be mobile phone, computer, clothes
Business device, air conditioner or the network equipment etc.) execute method described in each embodiment of the present invention.
The above is only a preferred embodiment of the present invention, is not intended to limit the scope of the invention, all to utilize this hair
Equivalent structure or equivalent flow shift made by bright specification and accompanying drawing content is applied directly or indirectly in other relevant skills
Art field, is included within the scope of the present invention.
Claims (10)
1. a kind of owner's follow-up mechanism of database subsystem, which is characterized in that the owner of the database subsystem tracks dress
It sets including memory and the processor being connect with the memory, is stored with and can run on the processor in the memory
Processing system, the processing system realizes following steps when being executed by the processor:
Owner's work order is created in the scheduled catalogue of database, obtains the system name and each subsystem of the database each subsystem
The user management account for docking people, increases separately the typing position of the system name and user management account in owner's work order
It sets；
According to owner's work order predetermined format each subsystem of typing position typing system name and each subsystem docking
The user management account of people；
After the completion of typing, call scheduled interface by the system name of each subsystem in owner's work order and pair of each subsystem
The user management account for meeting people is written in the allocation list that the database is safeguarded, and stores the allocation list；
After owner's system page in the database, which receives, checks request, the allocation list of request storage is checked based on this
And return, it is shown on owner's system page, for searching the user management account for docking people of each subsystem.
2. owner's follow-up mechanism of database subsystem according to claim 1, which is characterized in that the scheduled catalogue
For srvbot catalogue.
3. owner's follow-up mechanism of database subsystem according to claim 1 or 2, which is characterized in that the processing system
When system is executed by the processor, following steps are also realized:
If the database has newly-increased subsystem and docking people, newly-increased work order is created in the scheduled catalogue, it is newly-increased at this
The system name of newly-increased subsystem is increased separately in work order and docks the typing position of the user management account of people；
According to predetermined format in the system name of the newly-increased subsystem of the typing position typing and the user management account of docking people；
After the completion of typing, call the scheduled interface that this is increased newly to system name and the docking people of newly-increased subsystem in work order
User management account be written in the allocation list.
4. owner's follow-up mechanism of database subsystem according to claim 1 or 2, which is characterized in that the processing system
When system is executed by the processor, following steps are also realized:
If the database has, subsystem is offline, and creation replacement work order, increases in the replacement work order in the scheduled catalogue
The typing position of the system name of offline subsystem；
According to predetermined format the offline subsystem of the typing position typing system name；
After the completion of typing, call the scheduled interface will replace work order on system name and the allocation list in system name into
Row matching, after identical system name is matched in the allocation list, by the system name being matched in the allocation list and this be
The user management account of the corresponding docking people of system name is deleted.
5. a kind of owner's method for tracing of database subsystem, which is characterized in that the owner tracking side of the database subsystem
Method includes:
S1 creates owner's work order in the scheduled catalogue of database, obtains the system name and each subsystem of each subsystem of the database
The user management account of the docking people of system, increases separately the typing of the system name and user management account in owner's work order
Position；
S2, according to the predetermined format of owner's work order in the system name of each subsystem of typing position typing and pair of each subsystem
Connect the user management account of people；
S3 calls system name and each subsystem of the scheduled interface by each subsystem in owner's work order after the completion of typing
The user management account of docking people be written in the allocation list that the database is safeguarded, and store the allocation list；
S4 checks matching for request storage based on this after owner's system page in the database, which receives, checks request
It sets table and returns, shown on owner's system page, for searching the user management account for docking people of each subsystem.
6. owner's method for tracing of database subsystem according to claim 5, which is characterized in that the scheduled catalogue
For srvbot catalogue.
7. owner's method for tracing of database subsystem according to claim 5 or 6, which is characterized in that the step S4
Later, further includes:
If the database has newly-increased subsystem and docking people, newly-increased work order is created in the scheduled catalogue, it is newly-increased at this
The system name of newly-increased subsystem is increased separately in work order and docks the typing position of the user management account of people；
According to predetermined format in the system name of the newly-increased subsystem of the typing position typing and the user management account of docking people；
After the completion of typing, call the scheduled interface that this is increased newly to system name and the docking people of newly-increased subsystem in work order
User management account be written in the allocation list.
8. owner's method for tracing of database subsystem according to claim 5 or 6, which is characterized in that the step S4
Later, further includes:
If the database has, subsystem is offline, and creation replacement work order, increases in the replacement work order in the scheduled catalogue
The typing position of the system name of offline subsystem；
According to predetermined format the offline subsystem of the typing position typing system name；
After the completion of typing, call the scheduled interface will replace work order on system name and the allocation list in system name into
Row matching, after identical system name is matched in the allocation list, by the system name being matched in the allocation list and this be
The user management account of the corresponding docking people of system name is deleted.
9. owner's method for tracing of database subsystem according to claim 5 or 6, which is characterized in that the step S4
Later, further includes:
If the docking human hair of the subsystem of the database changes more, the creation change work order in the scheduled catalogue, in the change
The typing position of the user management account of changed docking people and the systematic name of corresponding subsystem is increased separately in more work order
It sets；
The user management account of the docking people changed according to predetermined format in the typing position typing and corresponding subsystem
Systematic name；
After the completion of typing, call the scheduled interface will be in the systematic name and the allocation list that change the subsystem in work order
The systematic name of subsystem matched, after identical systematic name is matched in the allocation list, in the allocation list
The user management account of the middle corresponding docking people of systematic name that will be matched to is changed to the user management in the change work order
Account；Or
If the docking human hair of the subsystem of the database changes more, after receiving change request, the allocation list is returned
It is shown on to owner's system page, for the user management account of the modification docking people on owner's system page.
10. a kind of computer readable storage medium, which is characterized in that be stored with processing system on the computer readable storage medium
System realizes the category of the database subsystem as described in any one of claim 5 to 9 when the processing system is executed by processor
The step of main method for tracing.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811526208.1A CN109783470B (en) | 2018-12-13 | 2018-12-13 | Owner tracking device, method and storage medium of database subsystem |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811526208.1A CN109783470B (en) | 2018-12-13 | 2018-12-13 | Owner tracking device, method and storage medium of database subsystem |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109783470A true CN109783470A (en) | 2019-05-21 |
| CN109783470B CN109783470B (en) | 2024-02-06 |
Family
ID=66495921
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811526208.1A Active CN109783470B (en) | 2018-12-13 | 2018-12-13 | Owner tracking device, method and storage medium of database subsystem |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109783470B (en) |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20020059291A1 (en) * | 1999-01-29 | 2002-05-16 | Jay Rossiter | Techniques for managing configuration for a system of devices arranged in a network |
| CN102855319A (en) * | 2012-09-05 | 2013-01-02 | 国家电网公司 | ORACLE database operation monitoring system |
| CN103186579A (en) * | 2011-12-29 | 2013-07-03 | 北京亿阳信通科技有限公司 | Database function-based rule implementation and application method and device |
| CN104615696A (en) * | 2015-01-23 | 2015-05-13 | 国家电网公司 | 95598 knowledge base system and establishment method |
| CN107153950A (en) * | 2017-06-21 | 2017-09-12 | 广州智萃电子科技有限公司 | A kind of workform management system based on workflow |
| CN107835195A (en) * | 2017-12-04 | 2018-03-23 | 灵动元点信息技术（北京）有限公司 | A kind of distributed network application node integrated management method |
| CN108989293A (en) * | 2018-06-27 | 2018-12-11 | 武汉虹信技术服务有限责任公司 | A kind of intelligent building management platform adaption system and adaptation method |
-
2018
- 2018-12-13 CN CN201811526208.1A patent/CN109783470B/en active Active
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20020059291A1 (en) * | 1999-01-29 | 2002-05-16 | Jay Rossiter | Techniques for managing configuration for a system of devices arranged in a network |
| CN103186579A (en) * | 2011-12-29 | 2013-07-03 | 北京亿阳信通科技有限公司 | Database function-based rule implementation and application method and device |
| CN102855319A (en) * | 2012-09-05 | 2013-01-02 | 国家电网公司 | ORACLE database operation monitoring system |
| CN104615696A (en) * | 2015-01-23 | 2015-05-13 | 国家电网公司 | 95598 knowledge base system and establishment method |
| CN107153950A (en) * | 2017-06-21 | 2017-09-12 | 广州智萃电子科技有限公司 | A kind of workform management system based on workflow |
| CN107835195A (en) * | 2017-12-04 | 2018-03-23 | 灵动元点信息技术（北京）有限公司 | A kind of distributed network application node integrated management method |
| CN108989293A (en) * | 2018-06-27 | 2018-12-11 | 武汉虹信技术服务有限责任公司 | A kind of intelligent building management platform adaption system and adaptation method |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109783470B (en) | 2024-02-06 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103544153B (en) | A kind of data-updating method based on data base and system | |
| CN108845950A (en) | Test device, the method for test and storage medium | |
| CN101493826A (en) | Database system based on WEB application and data management method thereof | |
| EP2797014A1 (en) | Database update execution according to power management schemes | |
| CN106326229B (en) | File storage method and device of embedded system | |
| CN109002543A (en) | A kind of method and apparatus of file storage | |
| CN117370280A (en) | Authority management method of cloud service and cloud data storage system thereof | |
| CN107844711B (en) | Data manipulation permission partition method, application server and computer readable storage medium | |
| US9325722B2 (en) | Apparatus, method, and computer-readable medium | |
| WO2020211258A1 (en) | Blockchain account book data query method, electronic apparatus and storage medium | |
| CN113946837A (en) | Data access and data access authority configuration method, device and storage medium | |
| CN114138776A (en) | Method, system, apparatus and medium for graph structure and graph attribute separation design | |
| CN110046181A (en) | The method and apparatus of data routing based on database distributed storage | |
| CN109343962A (en) | Data processing method, device and distribution service | |
| CN110704334B (en) | Method, system and equipment for important product data management | |
| CN109521970B (en) | Data processing method and related equipment | |
| CN107704603A (en) | A kind of method and device for realizing read and write abruption | |
| CN104317660A (en) | Bank parameter managing system | |
| WO2024016789A1 (en) | Log data query method and apparatus, and device and medium | |
| CN109783470A (en) | Owner's follow-up mechanism, method and the storage medium of database subsystem | |
| CN113076086B (en) | Metadata management system and method for modeling model object using the same | |
| CN109558073A (en) | A kind of disk based on educational system extends the method and electronic equipment in service life | |
| CN110704488B (en) | Method for managing data and corresponding system, computer device and medium | |
| CN105045874B (en) | A kind of method and device for improving database performance | |
| US8977814B1 (en) | Information lifecycle management for binding content |
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 |