CN103455516A - Operation platform and maintaining method for database - Google Patents
Operation platform and maintaining method for database Download PDFInfo
- Publication number
- CN103455516A CN103455516A CN2012101795223A CN201210179522A CN103455516A CN 103455516 A CN103455516 A CN 103455516A CN 2012101795223 A CN2012101795223 A CN 2012101795223A CN 201210179522 A CN201210179522 A CN 201210179522A CN 103455516 A CN103455516 A CN 103455516A
- Authority
- CN
- China
- Prior art keywords
- module
- information
- modification
- business
- search
- 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
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Information Transfer Between Computers (AREA)
Abstract
The invention discloses an operation platform and a maintaining method for a database. The operation platform comprises an authorization module used for carrying authorization setting for different business modules in the operation platform respectively and generating corresponding authorization information sheets; an inquiry module used for receiving an inquiry command and searching corresponding stored operation business information based on business module names and/or business module labels in the inquiry command; a modification module used for receiving a modification command, carrying out field matching for modified contents in the modification command and the searched operational business information and modifying corresponding information of matched fields based on the modified contents; an email module used for generating a corresponding modification log based on the modified contents, generating a prompting email about data change based on the modification log and sending the prompting email. The operation platform and the maintaining method for the database can improve flexibility, expandability and mobility of the maintenance of the database.
Description
Technical field
The present invention relates to the maintenance management technical field of database, relate in particular to the maintaining method of a kind of O&M platform and database.
Background technology
At present for the O&M demand of platform, for not being also for very ripe middle-size and small-size platform, solution is for take the mode that mail is medium simply and easily.In this manner, the O&M demand is filed an application by the relevant responsible official of platform, by its higher level, is examined, examine by after go to the developer, by developer backstage direct control database, completed.This O&M mode, due to the workflow management that lacks robotization and supervision mechanism, ageing can not be guaranteed and mail is easily omitted, be unfavorable for that problem solves smoothly rapidly; Carry out the direct control database by the developer, danger coefficient is high, and the data security consistance should not guarantee; It is numerous that treatment scheme relates to personnel, links up cost higher, and numerous and diverse backstage O&M taken developer's time, affected to a certain extent the development progress of project.
Another kind of more common O&M mode is, enumerates out the project that each need to be revised in the list on foreground, after filling in, is submitted to background program, then revises corresponding database (DB, Data Base) data, for disparate modules, processed respectively.This scheme clear logic is easy to write, and is applicable to less, the comparatively fixing situation of modification project.This O&M mode, although development originally is comparatively smooth, the O&M page that need to be different for different system developments has new module O&M demand will again develop a set of O&M page at every turn thereupon, when system requirements change to some extent, the O&M platform also will be made corresponding modification.Each data modification adds corresponding Operation Log and mail reminder if, the comparatively difficulty and complicated that also seems, and code too disperses to be not easy to safeguard.Generally speaking, the dirigibility of this scheme, extensibility, transportable property are more weak, and total exploitation of such O&M platform is consuming time longer in the long run.
Summary of the invention
In view of this, fundamental purpose of the present invention is to provide the maintaining method of a kind of O&M platform and database, to improve dirigibility, extensibility, the transportable property of database maintenance.
For achieving the above object, technical scheme of the present invention is achieved in that
The invention provides a kind of O&M platform, this platform comprises: authorization module, enquiry module, modified module and mail module, wherein,
Described authorization module, authorize respectively setting for the business module different for the O&M platform, and generate corresponding authorization message table;
Described enquiry module, for receiving query statement, according to the corresponding O&M business information of the business module name in described query statement and/or business module sign search preservation;
Described modified module, for receiving modify instruction, carry out fields match by the described O&M business information of the revised context in described modify instruction and search, and according to described revised context, the corresponding information of the field of coupling is modified;
Described mail module, for generate the corresponding daily record of revising according to described revised context, also send according to the prompting mail of described modification daily record generated data change.
Preferably, described mandate setting is the information in business module to be revised to authority authorize setting, and described information is revised authority and comprised search access right and revise authority.
Preferably, also comprise business information when coding in described query statement, described enquiry module also for, be coded in the corresponding Basic Information Table of search in the O&M business information of business module according to described business information.
Preferably, described enquiry module also for, when receiving described query statement, judge according to described authorization message table whether the initiator of described query statement has search access right, if judgement has a search access right, carry out inquiry; If judgement does not have search access right, do not carry out inquiry, and return to the inquiry failure cause to described initiator.
Preferably, described modified module also for, when receiving described modify instruction, judge according to the authorization message table whether the initiator of modify instruction has the modification authority, if judgement has a modification authority, carry out and revise; If judgement does not have the modification authority, exit current information and revise the page, and return to the modification failure cause to the initiator.
Preferably, described modified module also for, according to the operation of fields match, in judgement, have can not revised context the time, return to the modification failure cause to the initiator.
Preferably, modified module also for, when revising the corresponding information of field, according to pre-configured modification associated characters segment table, search the associate field that modification has influence on, and the corresponding information of described associate field also modified.
Preferably, modified module also for, by calling pre-configured function, the corresponding information of associate field is modified.
The present invention also provides a kind of maintaining method of database, and the method comprises:
Authorize respectively setting for business modules different in the O&M platform, and generate corresponding authorization message table;
Receive query statement, according to the corresponding O&M business information of the business module name in described query statement and/or business module sign search preservation;
Receive modify instruction, the described O&M business information of the revised context in described modify instruction and search is carried out to fields match, and according to described revised context, the corresponding information of the field of coupling is modified;
Generate the corresponding daily record of revising according to described revised context, also send according to the prompting mail of described modification daily record generated data change.
Preferably, described mandate setting is the information in business module to be revised to authority authorize setting, and described information is revised authority and comprised search access right and revise authority.
Preferably, while also comprising the business information coding in described query statement, the method also comprises:
According to the coding of the business information in described query statement, the corresponding Basic Information Table of search in the O&M business information of business module.
Preferably, the method also comprises:
When receiving described query statement, judge according to described authorization message table whether the initiator of described query statement has search access right, if judgement has search access right, carry out inquiry; If judgement does not have search access right, do not carry out inquiry, and return to the inquiry failure cause to described initiator.
Preferably, the method also comprises:
When receiving described modify instruction, judge according to the authorization message table whether the initiator of modify instruction has the modification authority, if judgement has the modification authority, carry out and revise; If judgement does not have the modification authority, exit current information and revise the page, and return to the modification failure cause to the initiator.
Preferably, the method also comprises:
According to the operation of fields match, in judgement, have can not revised context the time, return to the modification failure cause to the initiator.
Preferably, the method also comprises:
When revising the corresponding information of field, according to pre-configured modification associated characters segment table, search the associate field that modification has influence on, and the corresponding information of described associate field is also modified.
Preferably, the method also comprises: by calling pre-configured function, the corresponding information of associate field is modified.
The maintaining method of a kind of O&M platform provided by the present invention and database, the dirigibility, extensibility, transportable property and the security that have improved database maintenance.Wherein, authorization module provides assurance for the security of O&M platform; Enquiry module makes the user can locate fast the content that will revise; Embedded strict control of authority and detailed log recording in modified module, and all revisable data have been carried out to configuration process, extensibility is strong; The mail module can freely arrange addressee, mail masterplate, for O&M operates follow-up follow-up, confirms to provide guarantee.
The accompanying drawing explanation
The structural representation of a kind of O&M platform that Fig. 1 is the embodiment of the present invention;
The maintaining method process flow diagram of a kind of database that Fig. 2 is the embodiment of the present invention.
Embodiment
Below in conjunction with the drawings and specific embodiments, the technical solution of the present invention is further elaborated.
But the embodiment of the present invention is intended to build, a kind of dirigibility is high, the O&M platform of the strong rapid shaping of extensibility, and as shown in Figure 1, this platform mainly comprises authorization module, enquiry module, modified module and mail module.Wherein, the security that authorization module is the O&M platform is given security; Enquiry module makes the user can locate fast the content that will revise; Embedded strict control of authority and detailed log recording in modified module, and all revisable data have been carried out to configuration process, extensibility is strong; The mail module can freely arrange addressee, mail masterplate, for O&M operates follow-up follow-up, confirms to provide guarantee.Below the major function of each module is elaborated.
Authorization module, can be for business modules different in the O&M platform, as: waiting module, special anthorization single module etc., authorize respectively setting, the donor is taken on by the responsible official of each business module, can directly in database, be configured, then the responsible official by each business module is authorized the modification of the information in this business module authority.Information is revised authority and is mainly formed by inquiring about and revising these two parts.Wherein, query portion is responsible for the existing authorization message of retrieval from database, and return data, to client, is responsible for the demonstration of data by JS (Javascript).Revising part is specifically to be authorized for certain specific business (as waiting list, special anthorization list or nonstandard list etc.) by the donor, because each business (as waiting list, special anthorization list or nonstandard list) has the specific people to be responsible for, can be so that the specific people obtains the modification authority of specific transactions by authorizing, and authority give by the responsible official of each business module, weighed, also making thus O&M revise can effectively carry out under supervision mechanism.
Authorization message all deposits in database, and the different business module can be identified by the Fbill_type field, as: the waiting module id is " PQ ", and nonstandard single module is designated " FB ".All authorization messages all deposit in a table (being called the authorization message table), and a record in this table represents an authorization message.The authorization message list data structure is as shown in table 1 below:
| Field | Type | Null | Key | Default | Extra |
| Fid | int(11) | NO | PRI | Null | auto_increment |
| Fauth_from | varchar(50) | NO | Null | ||
| Fauth_to | varchar(200) | NO | Null | ||
| Fbill_type | varchar(10) | NO | Null | ||
| Fbill_code | varchar(50) | YES | Null | ||
| Fenable | char(1) | NO | Y | ||
| Flast_update_time | datetime | YES | Null |
Table 1
In this table, field name is shown in the Field list, field type is shown in the Type list, the Null list shows that whether corresponding field is to fill out that (NO means that corresponding field is required item, YES means that corresponding field is non-required item), the Key row are for identifying the major key foreign key information, and the Default row represent default value, the Extra row are used for illustrating some extraneous informations, as: whether this field is self-propagation.Wherein, the major key that Fid is this table, record of unique identification; Fauth_from is the donor, and the donor is generally the responsible official of each business module, can carry out the information modification to responsible business module; Fauth_to is the licensee, and the licensee only just can carry out the information retouching operation to corresponding business module after mandate; Fbill_type is for identifying the different business module of O&M platform; Fbill_code is used for the different business information (as the different waitings lists in the waiting module, the difference in the special anthorization single module are given special approval to nonstandard list of difference in list, nonstandard single module etc.) in the distinctive mark business module; Fenable is for whether identify this mandates effective, and while only having value for " Y ", just effectively, mandate is establishment, invalidly means that mandate has stopped; The final updating time that Flast_update_time is this record.For responsible official's configuration of certain business module, can deposit corresponding responsible official's coding in Fauth_to in by Fauth_from is made as to system, Fbill_type is made as the code of business module and realizes.
Enquiry module, but for the business module (as waiting module, special anthorization single module, nonstandard single module) of various O&Ms provides an entrance, the user can be in this search location.Because the page of each business module is independently, the user only need be at page incoming traffic information coding (coding as single as waiting, the single coding of special anthorization, nonstandard single coding etc.), the O&M platform can be according to the corresponding Basic Information Table of business information code search of user's input, query page as single as waiting will be searched for the waiting Basic Information Table, submit to and examine if the waiting that this business information is encoded corresponding is single, the link of revising the waiting essential information page can be returned to front page layout and show.
Modified module, it is the core of O&M platform, when modifying operation, at first the waiting revised of can fetching data in table is single, give special approval to all legacy datas that the pages such as single or nonstandard list show, itself and the amended data in foreground are compared, filter out the field of revising, these fields are modified one by one.Generally, the modification of a field in the page may relate to a plurality of tables of data, and tables of data corresponding to different field is also different to some extent, and in order to simplify the operation, the embodiment of the present invention has adopted configurable mode to be processed.The configuration data structure is as follows:
Above first array be in the O&M platform can be by the index of the business module of O&M.Array is worth (the O&M configuration of business module self, as $ module1_config_ary, $ module2_config_ary...) to forming by key (being business module name and/or business module sign, as module1, module2...).
Second array is the ios dhcp sample configuration IOS DHCP of single business module.In the O&M platform, each need to, by the business module of O&M, all can have the configuration array of a correspondence.And, along with development and the variation of business demand, when increasing again new business module, or while reducing business module, only need to increase, revise or delete configuration array and get final product.This has improved extendability and the maintainability of code to a great extent.
In the configuration array of single business module, normal-> title means the title of business module, is mainly used in showing, comprises demonstration on the page and the demonstration on mail; Normal-> url is the access links of business module, when needing to make hyperlink on the page or mail, can use; Each field (as field 1) after normal means the attribute that needs in business module revise (as the sale of waiting list, give special approval to single execution date etc.), title in each field (as field 1-> title) means the title of attribute, with normal-> title (title of business module) is similar, is used for showing.
For the information of same business module, most data all can concentrate on a table, so the normal-in configuration array > col deposits is exactly the master meter name, normal-> key deposits is exactly the major key of master meter, as: row's issue of waiting table etc.Table and major key have been arranged, then just can revise easily the field in any table.For example, ' when field 1 ' needs to revise, just directly getting final product according to this field in the configuration modification master meter in configuration.But actual business is complicated, when changing the attribute of a business module, may relate to the modification of a plurality of fields on multiple tables, so just used ' the configuration mode of field 2 '.Field 2-> deposited the field that needs each table of change in col, and field 2-deposited the corresponding major key of these tables in key.Thus, when needs change this comparatively complicated attribute, program is just revised a plurality of fields of multiple tables automatically according to configuration.If run into the more complicated attribute modification of first two situation compared, such as loaded down with trivial details rule is arranged, perhaps need to access the interface of other system, while causing simple configuration to satisfy the demands, can use ' configuration mode of field 3 ', leave in by calling ' field 2-> function of func ' completes the modification of attribute.So, no matter many complicated logic and processes only need to write in function and get final product.
Above three kinds of field configuration modes, both facilitated the modification configuration of most of simple attributes, the compatible again modification demand of minority complex properties.When having newly-increased attribute to revise, general needs the convenient and swift configuration array that must revise this business module to get final product, and O&M modification demand complicated and changeable in business module can be tackled calmly.
After back-end data is successfully modified, at first can in log sheet, record this operation, can call afterwards the prompting mail that the mail module sends data movement.Wherein, the structure of retouching operation log sheet is as shown in table 2 below:
| Field | Type | Null | Key | Default | Extra |
| Fid | int(10)unsigned | NO | PRI | Null | auto increment |
| Fuser | varchar(32) | YES | |||
| Ftype | varchar(50) | YES | |||
| Fopt | varchar(32) | YES | |||
| Forg | varchar(255) | YES | |||
| Fnew | varchar(255) | YES | |||
| Fkey | int(10)unsigned | NO | 0 | ||
| Ftime | datetime | YES | 0000-00-0000:00:00 |
Table 2
Above-mentioned log sheet field mainly by revising people (Fuser), revise field name (Ftype), revise before data (Forg), revise after data (Fnew), Update Table table name (Fopt), key name (Fkey) that amendment record is corresponding and key assignments (equal sign left and right part in corresponding where statement respectively), modification time (Ftime) forms, the clear record revised detail.The major key that Fid is this table, record of unique identification.Wherein, Null classifies ' YES ' as and is indicated as non-required field, for ' NO ' is indicated as required field.By this table, can enumerate out the O&M operation of carrying out about certain time period or certain user clearly.For the modification realized by calling self-defining function, except its modification information is charged in log sheet simply, also to carry out detailed file record, the O&M platform provides the journal file class.
When sending the prompting mail, the O&M platform is delivered to backstage mail module by information such as variation before and after the business module of modification, attribute, modification, times, and the mail module sends to the related personnel after the O&M content of operation is organized into to mail.Business module title in mail and Property Name are by the normal-in configuration array > title, field-> title obtain, hyperlink is by the normal-in configuration > url obtains.
Sum up above specific embodiment, a kind of O&M platform that the embodiment of the present invention provides mainly comprises: authorization module, enquiry module, modified module and mail module.
Wherein, authorization module, authorize respectively setting for the business module different for the O&M platform, and generate corresponding authorization message table;
Enquiry module, for receiving query statement, according to the corresponding O&M business information of the business module name in query statement and/or business module sign search preservation;
Modified module, for receiving modify instruction, carry out fields match by the O&M business information of the revised context in modify instruction and search, and according to revised context, the corresponding information of the field of coupling is modified;
The mail module, for generate the corresponding daily record of revising according to revised context, the prompting mail changed according to modification daily record generated data also sends.
Described mandate setting is the information in business module to be revised to authority authorize setting, and described information is revised authority and comprised search access right and revise authority.
Preferably, also comprise business information when coding in query statement, enquiry module also for, be coded in the corresponding Basic Information Table of search in the O&M business information of business module according to business information.
Preferably, enquiry module also for, when receiving query statement, judge according to the authorization message table whether the initiator of query statement has search access right, if judgement has a search access right, carry out inquiry; If judgement does not have search access right, do not carry out inquiry, and return to the inquiry failure cause to the initiator.The inquiry failure cause is, and the initiator of query statement does not have search access right.
Preferably, modified module also for, when receiving modify instruction, judge according to the authorization message table whether the initiator of modify instruction has the modification authority, if judgement has a modification authority, carry out and revise; If judgement does not have the modification authority, exit current information and revise the page, and return to the modification failure cause to the initiator.The modification failure cause is, and the initiator of modify instruction does not have the modification authority.In addition, modified module also for, according to the operation of fields match, in judgement, have can not revised context the time, return to the modification failure cause to the initiator.The modification failure cause is, and information can not be revised.
Preferably, modified module also for, when revising the corresponding information of field, according to pre-configured modification associated characters segment table, search the associate field that modification has influence on, and the corresponding information of associate field also modified.Further, modified module can also be modified to the corresponding information of associate field by calling pre-configured function.
Referring to Fig. 2, the maintaining method of the database of being carried out by the O&M platform of the embodiment of the present invention mainly comprises:
Step 1, authorize respectively setting for business modules different in the O&M platform, and generate corresponding authorization message table.
Described mandate setting is the information in business module to be revised to authority authorize setting, and described information is revised authority and comprised search access right and revise authority.
Step 2, receive query statement, according to the corresponding O&M business information of the business module name in query statement and/or business module sign search preservation.
When receiving query statement, judge according to the authorization message table whether the initiator of query statement has search access right, if judgement has search access right, carry out inquiry; If judgement does not have search access right, do not carry out inquiry, and return to reason to the initiator.
While also comprising the business information coding in query statement, according to the coding of the business information in query statement, the corresponding Basic Information Table of search in the O&M business information of business module.
Step 3, receive modify instruction, and the O&M business information of the revised context in modify instruction and search is carried out to fields match, and according to revised context, the corresponding information of the field of coupling is modified.
When receiving described modify instruction, judge according to the authorization message table whether the initiator of modify instruction has the modification authority, if judgement has the modification authority, carry out and revise; If judgement does not have the modification authority, exit current information and revise the page, and return to the modification failure cause to the initiator.In addition, according to the operation of fields match, in judgement, have can not revised context the time, to the initiator, return to the modification failure cause.
When revising the corresponding information of field, according to pre-configured modification associated characters segment table, search the associate field that modification has influence on, and the corresponding information of associate field is also modified.Further, can to the corresponding information of associate field, modify by calling pre-configured function.
Step 4, generate the corresponding daily record of revising according to revised context, and the prompting mail changed according to modification daily record generated data also sends.This prompting mail can send to donor's mailbox of the business module be modified, and can also issue other relevant responsible officials' of the business module be modified mailbox, specifically can be configured according to practical application.
The above, be only preferred embodiment of the present invention, is not intended to limit protection scope of the present invention.
Claims (16)
1. an O&M platform, is characterized in that, this platform comprises: authorization module, enquiry module, modified module and mail module, wherein,
Described authorization module, authorize respectively setting for the business module different for the O&M platform, and generate corresponding authorization message table;
Described enquiry module, for receiving query statement, according to the corresponding O&M business information of the business module name in described query statement and/or business module sign search preservation;
Described modified module, for receiving modify instruction, carry out fields match by the described O&M business information of the revised context in described modify instruction and search, and according to described revised context, the corresponding information of the field of coupling is modified;
Described mail module, for generate the corresponding daily record of revising according to described revised context, also send according to the prompting mail of described modification daily record generated data change.
2. O&M platform according to claim 1, is characterized in that, described mandate setting is the information in business module to be revised to authority authorizes settings, and described information is revised authority and comprised search access right and modification authority.
3. O&M platform according to claim 2, it is characterized in that, also comprise business information when coding in described query statement, described enquiry module also for, be coded in the corresponding Basic Information Table of search in the O&M business information of business module according to described business information.
4. according to the described O&M platform of claim 2 or 3, it is characterized in that, described enquiry module also for, when receiving described query statement, whether the initiator who judges described query statement according to described authorization message table has search access right, if judgement has search access right, carries out inquiry; If judgement does not have search access right, do not carry out inquiry, and return to the inquiry failure cause to described initiator.
5. according to claim 1,2 or 3 described O&M platforms, it is characterized in that, described modified module also for, when receiving described modify instruction, whether the initiator who judges modify instruction according to the authorization message table has the modification authority, if judgement has the modification authority, carries out and revises; If judgement does not have the modification authority, exit current information and revise the page, and return to the modification failure cause to the initiator.
6. O&M platform according to claim 5, is characterized in that, described modified module also for, according to the operation of fields match, in judgement, have can not revised context the time, return to the modification failure cause to the initiator.
7. according to claim 1,2 or 3 described O&M platforms, it is characterized in that, modified module also for, when revising the corresponding information of field, according to pre-configured modification associated characters segment table, search the associate field that modification has influence on, and the corresponding information of described associate field is also modified.
8. O&M platform according to claim 7, is characterized in that, modified module also for, by calling pre-configured function, the corresponding information of associate field is modified.
9. the maintaining method of a database, is characterized in that, the method comprises:
Authorize respectively setting for business modules different in the O&M platform, and generate corresponding authorization message table;
Receive query statement, according to the corresponding O&M business information of the business module name in described query statement and/or business module sign search preservation;
Receive modify instruction, the described O&M business information of the revised context in described modify instruction and search is carried out to fields match, and according to described revised context, the corresponding information of the field of coupling is modified;
Generate the corresponding daily record of revising according to described revised context, also send according to the prompting mail of described modification daily record generated data change.
10. the maintaining method of database according to claim 9, is characterized in that, described mandate setting is the information in business module to be revised to authority authorizes settings, and described information is revised authority and comprised search access right and modification authority.
11. the maintaining method of database, is characterized in that according to claim 10, while also comprising the business information coding in described query statement, the method also comprises:
According to the coding of the business information in described query statement, the corresponding Basic Information Table of search in the O&M business information of business module.
12. the maintaining method according to claim 10 or 11 described databases, is characterized in that, the method also comprises:
When receiving described query statement, judge according to described authorization message table whether the initiator of described query statement has search access right, if judgement has search access right, carry out inquiry; If judgement does not have search access right, do not carry out inquiry, and return to the inquiry failure cause to described initiator.
13. the maintaining method according to claim 9,10 or 11 described databases, is characterized in that, the method also comprises:
When receiving described modify instruction, judge according to the authorization message table whether the initiator of modify instruction has the modification authority, if judgement has the modification authority, carry out and revise; If judgement does not have the modification authority, exit current information and revise the page, and return to the modification failure cause to the initiator.
14. the maintaining method according to the described database of claim 13, is characterized in that, the method also comprises:
According to the operation of fields match, in judgement, have can not revised context the time, return to the modification failure cause to the initiator.
15. the maintaining method according to claim 9,10 or 11 described databases, is characterized in that, the method also comprises:
When revising the corresponding information of field, according to pre-configured modification associated characters segment table, search the associate field that modification has influence on, and the corresponding information of described associate field is also modified.
16. the maintaining method according to the described database of claim 15, is characterized in that, the method also comprises: by calling pre-configured function, the corresponding information of associate field is modified.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210179522.3A CN103455516B (en) | 2012-06-01 | 2012-06-01 | A kind of maintaining method of operation platform and database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210179522.3A CN103455516B (en) | 2012-06-01 | 2012-06-01 | A kind of maintaining method of operation platform and database |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN103455516A true CN103455516A (en) | 2013-12-18 |
| CN103455516B CN103455516B (en) | 2018-01-16 |
Family
ID=49737895
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201210179522.3A Active CN103455516B (en) | 2012-06-01 | 2012-06-01 | A kind of maintaining method of operation platform and database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103455516B (en) |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105446728A (en) * | 2014-11-18 | 2016-03-30 | 国网山东省电力公司 | Background configuration based dynamic realization method and system for equipment asset linkage enhancement |
| CN107273104A (en) * | 2016-04-08 | 2017-10-20 | 阿里巴巴集团控股有限公司 | A kind of processing method and processing device of configuration data structure |
| CN107958352A (en) * | 2017-12-27 | 2018-04-24 | 北京福田戴姆勒汽车有限公司 | The action prediction scheme confirmation method and system of Engineering Change Management information system |
| CN108415922A (en) * | 2017-09-30 | 2018-08-17 | 平安科技（深圳）有限公司 | Database update method and application server |
| CN109871705A (en) * | 2017-12-01 | 2019-06-11 | 中国移动通信集团广东有限公司 | A kind of database update method and system |
| CN110533385A (en) * | 2019-08-08 | 2019-12-03 | 国云科技股份有限公司 | A kind of data permission control method of the multilist multi-field of based role |
| CN113157672A (en) * | 2021-05-17 | 2021-07-23 | 中国银行股份有限公司 | Method and device for modifying SQLServer database fields in batch |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101335869A (en) * | 2008-03-26 | 2008-12-31 | 北京航空航天大学 | Video conference system based on Soft-MCU |
| US20090125830A1 (en) * | 2007-11-13 | 2009-05-14 | Apple Inc. | Compound Fields |
| CN102306355A (en) * | 2011-09-19 | 2012-01-04 | 北京信城通数码科技有限公司 | Management system for IT (Information Technology) operation and maintenance configuration |
-
2012
- 2012-06-01 CN CN201210179522.3A patent/CN103455516B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20090125830A1 (en) * | 2007-11-13 | 2009-05-14 | Apple Inc. | Compound Fields |
| CN101335869A (en) * | 2008-03-26 | 2008-12-31 | 北京航空航天大学 | Video conference system based on Soft-MCU |
| CN102306355A (en) * | 2011-09-19 | 2012-01-04 | 北京信城通数码科技有限公司 | Management system for IT (Information Technology) operation and maintenance configuration |
Non-Patent Citations (3)
| Title |
|---|
| ZAHOOR JAN ET AL.: ""Access Control Mechanism For Web Databases By Using Parameterized Cursor"", 《2010 5TH INTERNATIONAL CONFERENCE ON FUTURE INFORMATION TECHNOLOGY》 * |
| 姜华: ""主要用能产品和设备能效信息数据库管理系统的设计"", 《计算机工程与设计》 * |
| 杨德友: ""学生综合管理信息系统研究与实现"", 《中国优秀博硕士学位论文全文数据库（硕士）信息科技辑》 * |
Cited By (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105446728A (en) * | 2014-11-18 | 2016-03-30 | 国网山东省电力公司 | Background configuration based dynamic realization method and system for equipment asset linkage enhancement |
| CN107273104A (en) * | 2016-04-08 | 2017-10-20 | 阿里巴巴集团控股有限公司 | A kind of processing method and processing device of configuration data structure |
| CN107273104B (en) * | 2016-04-08 | 2021-05-28 | 创新先进技术有限公司 | Processing method and device for configuration data structure |
| CN108415922A (en) * | 2017-09-30 | 2018-08-17 | 平安科技（深圳）有限公司 | Database update method and application server |
| CN108415922B (en) * | 2017-09-30 | 2021-10-22 | 平安科技（深圳）有限公司 | Database modification method and application server |
| CN109871705A (en) * | 2017-12-01 | 2019-06-11 | 中国移动通信集团广东有限公司 | A kind of database update method and system |
| CN107958352A (en) * | 2017-12-27 | 2018-04-24 | 北京福田戴姆勒汽车有限公司 | The action prediction scheme confirmation method and system of Engineering Change Management information system |
| CN110533385A (en) * | 2019-08-08 | 2019-12-03 | 国云科技股份有限公司 | A kind of data permission control method of the multilist multi-field of based role |
| CN113157672A (en) * | 2021-05-17 | 2021-07-23 | 中国银行股份有限公司 | Method and device for modifying SQLServer database fields in batch |
| CN113157672B (en) * | 2021-05-17 | 2024-01-19 | 中国银行股份有限公司 | Batch modification method and device for SQLServer database fields |
Also Published As
| Publication number | Publication date |
|---|---|
| CN103455516B (en) | 2018-01-16 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103455516A (en) | Operation platform and maintaining method for database | |
| CN108984895B (en) | Model automatic identification method based on XML heterogeneous platform | |
| CN101794226B (en) | Service software construction method and system adapting to multiple business abstraction levels | |
| Berlack | Software configuration management | |
| CN108460136A (en) | Electric power O＆M information knowledge map construction method | |
| CN105447122A (en) | Implementation method for autonomously creating file system based on multi-table association | |
| CN101427273B (en) | The system and method for e-catalog supplier portal | |
| CN105761139A (en) | Account checking system and method | |
| CN104765745B (en) | Loading data in database are carried out with the method and system of logic checking | |
| CN103678447A (en) | Multivariate transaction classification | |
| KR20050103919A (en) | Product and parts management system, data processing system, serial number management method, computer program product, and computer-readable medium | |
| JP2008511936A (en) | Method and system for semantic identification in a data system | |
| CN104737192A (en) | Promoter system and method for processing product and service data | |
| CN105488223A (en) | Analyzing and subscribing method and system of business data events | |
| CN101770469A (en) | Page based data query method and system thereof | |
| CN103064909A (en) | Base station database inspection method based on Drools rule engine | |
| CN110032154B (en) | Production control method and system for small-batch products | |
| CN103399744B (en) | A kind of method building business gate platform | |
| Li et al. | Optimal path of internet of things service in supply chain management based on machine learning algorithms | |
| CN107437207A (en) | Three big mobile terminal commercial podium mall systems of a collection and its method | |
| CN1963849A (en) | Conformity method of managing system of data of product | |
| CN112669133A (en) | Intelligent cost control reimbursement method capable of automatically matching according to application scenes | |
| CN102289544A (en) | Electric control cabinet parametric driving system | |
| US20140278693A1 (en) | System and Method for Cross-Plant Bill of Materials | |
| CN116561345A (en) | Information knowledge graph construction method based on multi-mode data company |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |