CN108932309A - Platform database management method, device, computer equipment and storage medium - Google Patents

Platform database management method, device, computer equipment and storage medium Download PDF

Info

Publication number
CN108932309A
CN108932309A CN201810622602.9A CN201810622602A CN108932309A CN 108932309 A CN108932309 A CN 108932309A CN 201810622602 A CN201810622602 A CN 201810622602A CN 108932309 A CN108932309 A CN 108932309A
Authority
CN
China
Prior art keywords
database
management
data
identification
terminal
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
Application number
CN201810622602.9A
Other languages
Chinese (zh)
Other versions
CN108932309B (en
Inventor
洪智杰
马奇
陈光谋
徐文灏
吴冠群
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Weikun Shanghai Technology Service Co Ltd
Original Assignee
Lujiazui Shanghai International Financial Assets Market Ltd By Share Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Lujiazui Shanghai International Financial Assets Market Ltd By Share Ltd filed Critical Lujiazui Shanghai International Financial Assets Market Ltd By Share Ltd
Priority to CN201810622602.9A priority Critical patent/CN108932309B/en
Publication of CN108932309A publication Critical patent/CN108932309A/en
Application granted granted Critical
Publication of CN108932309B publication Critical patent/CN108932309B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Abstract

This application involves a kind of platform database management method, device, computer equipment and storage mediums.The method includes：Receive the data base administration request that terminal is sent；Response database management request returns to administration page to terminal；Administration page includes multiple Database Identifications and multiple management projects；Receive the management information that terminal is returned based on administration page；Management information includes selected Database Identification, and the selected corresponding management project of Database Identification；The selected corresponding type of database of Database Identification of identification；According to type of database and the corresponding management project of selected Database Identification, corresponding management assembly is called, the selected corresponding database of Database Identification is managed.Multiple and different types of database can be managed based on same database operation platform using this method.

Description

Platform database management method, device, computer equipment and storage medium
Technical field
This application involves field of computer technology, more particularly to a kind of platform database management method, device, calculating Machine equipment and storage medium.
Background technique
Currently, more and more operation systems need database to support.In operation system exploitation or test process, not only The deployment for needing to carry out database is managed with greater need for the database of deployment, such as carries out Data Migration, structure to database It synchronizes.User mainly manages database by the database operation platform that database manufacturer provides in traditional approach.But manufacturer The database operation platform of offer can only be managed the centralized database that it is provided, if user expectation to multiple databases into Row management, then need to install multiple database operation platforms, cumbersome.
Summary of the invention
Based on this, it is necessary to which in view of the above technical problems, providing one kind can be based on same database operation platform to more Platform database management method, device, computer equipment and the storage medium that a distinct type data-base is managed.
A kind of platform database management method, the method includes：Receive the data base administration request that terminal is sent；It rings It answers the data base administration to request, returns to administration page to the terminal；The administration page include multiple Database Identifications and Multiple management projects；Receive the management information that the terminal is returned based on the administration page；The management information includes selected Database Identification and the corresponding management project of the selected Database Identification；Identify the selected Database Identification Corresponding type of database；According to the type of database and the corresponding management project of the selected Database Identification, adjust With corresponding management assembly, the corresponding database of the selected Database Identification is managed.
In one of the embodiments, the method also includes：Receive the platform access request that the terminal is sent；According to The platform access request, detects whether to be stored with corresponding image file；If it is not, pulling corresponding mirror image text in mirror image warehouse Part disposes database operation platform by starting the image file, generates the access address of the database operation platform；Hair It send the access address to terminal, so that terminal is based on the access address and access database operation platform.
The database operation platform deploys baseline database in one of the embodiments,；The management information packet Include multiple Database Identifications；The corresponding database of the Database Identification includes service database and test database；The pipe Reason project includes structure synchronization；It is described the corresponding database of the selected Database Identification is managed before, further include： The baseline database and the configuration of multiple service databases are connected；The baseline database is for storing multiple service databases Corresponding structured data dictionary；According to the structured data dictionary of the multiple service databases of preset time frequency collection；According to Structured data dictionary is collected, corresponding construction data dictionary in baseline database is updated；It is described to the selected number Corresponding database is identified according to library to be managed, including：If the management project is structure synchronization, the baseline database is obtained The corresponding structured data dictionary of the Database Identification of storage；According to the structured data dictionary got, multithreading is called simultaneously Hair is updated structured data dictionary in the corresponding test database of multiple Database Identifications, so that the database mark Know corresponding service database and test database structure synchronization.
The management project includes session unlock in one of the embodiments,；It is described to the selected database mark Know before corresponding database is managed, further includes：Monitor session of multiple databases respectively between corresponding service system State；Monitoring result is fed back into terminal；Make terminal in the session status lock state of the database, is based on the pipe The management project for managing session unlock in the page triggers unlocking request；It is described to the corresponding database of the selected Database Identification It is managed, including：If the management project is session unlock, it is corresponding to interrupt the Database Identification using the management assembly Database and corresponding service system between session.
The management information includes the Database Identification and attribute information of source database in one of the embodiments,；Institute Stating management project includes Data Migration；It is described that the corresponding database of the selected Database Identification is managed, including：If The management project is Data Migration, obtains the migration page, the migration page is back to the terminal；The migration page Database Identification and a variety of migration dimension options including multiple target databases；It receives the terminal and is based on the migration page The migration information of return；The migration information includes Database Identification and the choosing of corresponding migration dimension of selected target database ?；Transfer parameter is generated according to the attribute information of the source database；The transfer parameter is sent to selected target data The corresponding destination server in library；When receiving the confirmation transinformation that the destination server returns, tieed up according to the migration Spend option, call migration interface by the source database data and/or structural transfer to the target database.
The management project includes data readback in one of the embodiments,；It is described to the selected database mark Know before corresponding database is managed, further includes：Capture the data that the terminal occurs respectively in multiple databases Altering event generates the corresponding action statement of the data altering event；The action statement is parsed, is generated corresponding Rollback sentence；It is described that the corresponding database of the selected Database Identification is managed, including：If the management project is Data readback obtains the corresponding rollback sentence of the Database Identification, is recalled by running the rollback sentence to the data Library identifies the change of data in correspondence database.
The management information further includes recyclable data type in one of the embodiments,；The management project includes Space management；It is described that the corresponding database of the selected Database Identification is managed, including：If the management project is Space management monitors the corresponding remaining space capacity of the Database Identification；If the remaining space capacity is less than preset threshold, Data in the Database Identification correspondence database are traversed, screening number corresponding with the recyclable data type According to；The data filtered out are deleted from associated databases, discharge the space resources of the database.
A kind of platform database managing device, described device include：Project determining module, for receiving terminal transmission Data base administration request；The data base administration request is responded, returns to administration page to the terminal；The administration page includes Multiple Database Identifications and multiple management projects；Receive the management information that the terminal is returned based on the administration page；It is described Management information includes selected Database Identification and the corresponding management project of the selected Database Identification；Type identification Module, for identification corresponding type of database of the selected Database Identification；Database management module, for according to Type of database and the corresponding management project of the selected Database Identification, call corresponding management assembly, to the choosing The corresponding database of fixed Database Identification is managed.
A kind of computer equipment, including memory and processor, the memory are stored with computer program, the processing Device realizes following steps when executing the computer program：Receive the data base administration request that terminal is sent；Respond the data Depositary management reason request, returns to administration page to the terminal；The administration page includes multiple Database Identifications and multiple management items Mesh；Receive the management information that the terminal is returned based on the administration page；The management information includes selected database mark Knowledge and the corresponding management project of the selected Database Identification；Identify the corresponding data of the selected Database Identification Library type；According to the type of database and the corresponding management project of the selected Database Identification, corresponding pipe is called Component is managed, the corresponding database of the selected Database Identification is managed.
A kind of computer readable storage medium, is stored thereon with computer program, and the computer program is held by processor Following steps are realized when row：Receive the data base administration request that terminal is sent；The data base administration request is responded, to the end End returns to administration page；The administration page includes multiple Database Identifications and multiple management projects；The terminal is received to be based on The management information that the administration page returns；The management information includes selected Database Identification and the selected number Corresponding management project is identified according to library；Identify the corresponding type of database of the selected Database Identification；According to the data Library type and the corresponding management project of the selected Database Identification, call corresponding management assembly, to described selected The corresponding database of Database Identification is managed.
Above-mentioned platform database management method, device, computer equipment and storage medium, need to one as user or When multiple data base administrations, data base administration request can be sent by terminal to server；Server based on data depositary management reason Request can return to administration page to the terminal；One selected according to the user of terminal feedback based on the administration page Or multiple Database Identifications and the corresponding management project of each Database Identification, it can identify each database mark Know corresponding type of database；According to the type of database, the corresponding management assembly of corresponding management project can be called to phase The corresponding database of Database Identification is answered to be managed.Since database operation platform is for the different pipes of disparate databases type Reason project is respectively equipped with corresponding management assembly, is allowed users to using different management assemblies flat based on same database O&M Platform is managed multiple and different types of database, avoids the cumbersome of the multiple database operation platforms of installation.Due to only needing The page carries out simple selected operation, and data base administration can be realized, not only improve data base administration efficiency, also reduce database O&M threshold.
Detailed description of the invention
Fig. 1 is the application scenario diagram of platform database management method in one embodiment；
Fig. 2 is the flow diagram of platform database management method in one embodiment；
Fig. 3 is the structural block diagram of platform database managing device in one embodiment；
Fig. 4 is the internal structure chart of computer equipment in one embodiment.
Specific embodiment
It is with reference to the accompanying drawings and embodiments, right in order to which the objects, technical solutions and advantages of the application are more clearly understood The application is further elaborated.It should be appreciated that specific embodiment described herein is only used to explain the application, not For limiting the application.
Platform database management method provided by the present application, can be applied in application environment as shown in Figure 1.Its In, terminal 102 is communicated with server 104 by network.Wherein, terminal 102 can be, but not limited to be various individual calculus Machine, laptop, smart phone, tablet computer and portable wearable device, server 104 can use independent server The either server cluster of multiple servers composition is realized.Server 104 deploys database O&M in a mirror-image fashion Platform.When user needs to be managed one or more databases, it is flat database O&M can be accessed by terminal 102 Platform sends data base administration request to server 104；104 response database management of server request, to 102 recurrent canal of terminal Manage the page.Administration page includes multiple Database Identifications and multiple management projects.User can be based on administration page in terminal 102 Selected one or more Database Identifications and the corresponding management project of each Database Identification.Server 104 identifies user The selected corresponding type of database of each Database Identification calls the corresponding management of corresponding management project according to type of database Component is managed the selected corresponding database of Database Identification.Since database operation platform is directed to disparate databases The different management projects of type are respectively equipped with corresponding management assembly, are allowed users to using different management assemblies based on same Database operation platform is managed multiple and different types of database, avoids the numerous of the multiple database operation platforms of installation It is trivial.It is operated due to only needing the page to carry out simple select, data base administration can be realized, not only improve data base administration efficiency, Also reduce database O&M threshold.
In one embodiment, it as shown in Fig. 2, providing a kind of platform database management method, applies in this way It is illustrated, includes the following steps for server in Fig. 1：
Step 202, the data base administration request that terminal is sent is received.
Step 204, response database management is requested, and returns to administration page to terminal；Administration page includes multiple databases Mark and multiple management projects.
Database operation platform is deployed on server in a mirror-image fashion.User can be transported by terminal access database Platform is tieed up, a variety of different types of databases are managed based on database operation platform.For example, to operation system deployment Service database or the test database of test macro deployment are managed.Database operation platform operation management it is multiple The database that database can be same platform is also possible to the database of different platform.In other words, database operation platform energy It is enough that cross-platform multiple databases are managed.
Tester needs first to dispose and the operation system industry before using test macro to the test of some operation system The corresponding test database of business database.Service database, which is used to record, directly externally provides the truthful data of service.Test number According to library for recording analogue data corresponding with service database, for developing test, service is not provided externally directly.It surveys Examination personnel can use the database operation platform and directly be managed to test database.Operation maintenance personnel can use the data Library operation platform is directly managed service database.
User can be by attribute informations such as the database names, connection string, type of database of configuration database, in number According to the newly-increased database for needing to manage of library operation platform.The database generation pair newly-increased for each configuration of database operation platform The Database Identification answered.When needing to be managed some database, user can send data by terminal to server Depositary management reason request.The preset administration page of request is managed in server based on data depositary management.Administration page includes configured addition To the Database Identification of all database of database operation platform.Administration page further includes multiple management projects, as structure is same Step, session unlock, Data Migration, data readback or space management etc..Each management project is a function choosing-item, by selected Different management projects realizes the different management operations to database.
Step 206, the management information that terminal is returned based on administration page is received；Management information includes selected database mark Know, and the selected corresponding management project of Database Identification.
User is identified by terminal in the selected one or more wide area information servers for needing to manage of administration page, and It is expected that the management project carried out to each selected database.Terminal is based on the preset selected thing burying a capture administration page and occurring Part obtains the selected corresponding management information of event.Management information includes selected one or more Database Identifications and each The corresponding management project of Database Identification.Management information is sent to server by terminal.
Step 208, the corresponding type of database of selected Database Identification is identified.
Step 210, according to type of database and the corresponding management project of selected Database Identification, corresponding pipe is called Component is managed, the selected corresponding database of Database Identification is managed.
The database operation platform can support various database types on management object, such as Mysql, Oracle (one Kind database) etc..The database operation platform is respectively equipped with corresponding pipe for the different management projects of distinct type data-base Manage component.In other words, same type database carries out different management projects, using different management assemblies；Different types of data Library carries out identical management project, and the management assembly of use may also be different.
Server identifies the corresponding type of database of each Database Identification in management information.Server based on data library class The management project that type and user select obtains the management assembly that each Database Identification that user selectes is applicable in.If user selects Multiple Database Identifications, server calls multithreading, using the management assembly got concurrently to multiple Database Identifications are determined Corresponding database is managed, to improve data base administration efficiency.
In another embodiment, administration page further includes the corresponding multiple tables of data marks of each Database Identification, from And user can individually be managed individual or multiple tables of data in database.
In the present embodiment, when user needs to one or more data base administrations, it can be sent out by terminal to server Data base administration is sent to request；Server based on data depositary management reason request can return to administration page to terminal；It is fed back according to terminal User based on administration page select one or more Database Identifications and the corresponding management project of each Database Identification, It can identify the corresponding type of database of each Database Identification；According to type of database, corresponding management project pair can be called The management assembly answered identifies corresponding database to associated databases and is managed.Since database operation platform is directed to different numbers It is respectively equipped with corresponding management assembly according to the different management projects of library type, allows users to be based on using different management assemblies Same database operation platform is managed multiple and different types of database, avoids the multiple database operation platforms of installation It is cumbersome.Due to only needing the page to carry out simple selected operation, data base administration can be realized, not only improve data base administration effect Rate also reduces database O&M threshold.
In one embodiment, this method further includes：Receive the platform access request that terminal is sent；It is asked according to platform access It asks, detects whether to be stored with corresponding image file；If it is not, corresponding image file is pulled in mirror image warehouse, by starting mirror As file disposes database operation platform, the access address of generation database operation platform；Access address is sent to terminal, makes end End group accesses database operation platform in access address.
It is erroneous for installation in order to be further reduced, the corresponding image file of exploitation database operation platform, and then with mirror image Mode installation and deployment database operation platform.Specifically, developer installs a kind of Docker (application of open source on the server Container engine) serviced component, the All Files that the code file of database operation platform and operation are relied on are according to standard Catalogue is stored in the catalogue of Docker serviced component.Developer uses Docker Build order by database operation platform The catalogue of code file be packaged into Docker image file (hereinafter referred to as " image file "), thus by database operation platform And its it runs relied on alternative document and is bundled in a transplantable container.Developer passes through Docker Push order Image file is uploaded to privately owned mirror image warehouse or Public Warehouse (hereinafter referred to as " mirror image warehouse ").Mirror image text in Public Warehouse Any user of part can be with download access.The every other file relied on is run since image file is integrated with it in advance, thus Database operation platform can make user in the installation and deployment database operation platform with independent operating without relying on other assemblies When, without being concerned about the support issue of current platform release or dependence library, greatly simplify installation operation.
Terminal can access database operation platform based on image file.Specifically, when user needs to access database fortune When tieing up platform, platform access request is sent to server.Server detects whether to deploy corresponding database operation platform.If It is that then server starts the database operation platform, the access address of database operation platform is back to terminal.Access address It can be server address and port numbers, such as 192.168.1.1：8001.Access address can freely be set based on actual demand. For inputting corresponding access address i.e. accessible database operation platform on the browser of terminal.
If server not yet disposes database operation platform, mirror of the server from mirror image warehouse pulling data library operation platform As file, Docker RUN command is generated, starting image file is instructed using Docker RUN, it is flat thus to complete database O&M The deployment of platform.Server generates the access address of the database operation platform of deployment, and access address is back to terminal.It is easy reason Solution, the server of exploitation database operation platform and server that can be different using the server of database operation platform.
In another embodiment, user can also be in terminal disposition database operation platform.Specifically, terminal is from mirror image The image file of warehouse downloading data library operation platform, in command Window input Docker RUN command deployment starting mirror image text Part, browser input storage address, that is, accessible database operation platform of image file.
In the present embodiment, when user needs to access database operation platform, only corresponding mirror need to be downloaded in mirror image warehouse As file, start mirror image by preset instructions, O&M can be directly accessed the database by corresponding access address in browser and put down Platform is used to realize in installation and deployment and open packet, time saving and energy saving.
In one embodiment, database operation platform deploys baseline database；Management information includes multiple databases Mark；The corresponding database of Database Identification includes service database and test database；Management project includes structure synchronization；It is right Before the corresponding database of selected Database Identification is managed, further include：
Baseline database and the configuration of multiple service databases are connected；Baseline database is for storing multiple service databases Corresponding structured data dictionary；According to the structured data dictionary of the multiple service databases of preset time frequency collection；According to Structured data dictionary is collected, corresponding construction data dictionary in baseline database is updated.
In the present embodiment, the selected corresponding database of Database Identification is managed, including：If management project is Structure synchronization obtains the corresponding structured data dictionary of Database Identification of baseline database storage；According to the structure number got According to dictionary, multi-thread concurrent is called to carry out more structured data dictionary in the corresponding test database of multiple Database Identifications Newly, so that the corresponding service database of Database Identification and test database structure synchronization.
When tester, which is based on database operation platform provided by the present application, to be managed to test database, need pair Test database carries out structure synchronization, to guarantee that test database is consistent with the table structure of corresponding service database.Due to safety Isolation mech isolation test cannot be accessed directly between test database and service database.Database operation platform deploys base-line data Library.The present embodiment carries out structure synchronization to test database using baseline database as third side.
Baseline database is a kind of basic data structure, is the template of business datum database table structure.Baseline database is used for Store the structured data dictionary of service database.Structured data dictionary is one group of read-only table for users.Structured data word Allusion quotation is defined the data structure of database and describes for information about for storing.It should be noted that baseline database It is served only for the data structure of mapping storage service database, is not used to store specific data, from memory space may be not present Insufficient risk.In order to guarantee data structure safety, baseline database can set different access permission for different user, Such as outside ip address forbids access.
The table structure of service database is synchronized to base-line data automatically according to preset time frequency by database operation platform Library.Specifically, baseline database and service database are established connection at regular intervals by database operation platform, baseline is determined The structured data dictionary of each database is with respect to the change item between structured data dictionary in corresponding service database in database, According to change item in baseline database associated databases structured data dictionary carry out incremental update, keep baseline database and Business datum database table structure it is consistent.
If the management project that user selectes is structure synchronization, database operation platform is synchronous by the table structure of baseline database To corresponding test database.Specifically, the management information that terminal uploads further includes needing to synchronize if management project is structure synchronization Database description information, such as database name, table name etc..The data base administration request that server is triggered based on user, triggering fortune Carry out structure synchronization of the preset structure synchronization script of row to test database.If user has selected what multiple Structure of need synchronized Database Identification, server calls multi-thread concurrent synchronize the table structure of multiple test databases.
In another embodiment, database operation platform can provide synchronous dimension option abundant in administration page, Such as the synchronization between individual table, synchronization between object (including multiple specified tables) is same between multiple tables of different purposes It walks, synchronizing between multiple corresponding tables of different rights user meets the diversified synchronisation requirement of user, structure can be improved Synchronous efficiency.
The correctness of data and its structure determines the test result of corresponding service system in test database.If test knot Fruit is to execute failure, indicates that there may be problems for synchronization change.Traditional approach needs tester artificially to go to repair mistake Synchronous change, low efficiency and accuracy is poor.In yet another embodiment, when tester utilizes test database to operation system When being tested, as a result, if test result is to execute failure, automatic execution rollback refers to database operation platform monitoring and test It enables, to be recalled in time in synchronous fault.Rollback refers to the state for allowing test database to return to before synchronous change.
In the present embodiment, structure synchronization is carried out to test database using baseline database as third side, can make to test Database guarantees consistent with business datum database table structure in the case where that directly cannot access service database.Using parallel It executes in batches mode and structure synchronization is carried out to multiple databases, database structure synchronous efficiency can be improved.
In one embodiment, management project includes session unlock；To the selected corresponding database of Database Identification into Before row management, further include：Monitor session status of multiple databases respectively between corresponding service system；Monitoring result is anti- It is fed to terminal；Make terminal in the session status lock state of database, the management item unlocked based on session in administration page Mesh triggers unlocking request.
In the present embodiment, the selected corresponding database of Database Identification is managed, including：If management project is Session unlock interrupts the session between the corresponding database of Database Identification and corresponding service system using management assembly.
When user, which is based on operation system, to carry out business operation or test operation system, operation system is connected to correspondence Service database carry out data access.Assuming that there is abnormal or user couple in operation system in use process or test process Certain tables of data is modified but is not submitted to modified tables of data and (forget releasing session) in service database, then Operation system is continuously connected to service database, so that the occupied locking of the session between the service database and operation system, Or tables of data is lockable can not again operate the tables of data, is caused to test business under corresponding business operation or line and is obstructed.
To solve the above-mentioned problems, database operation platform supervises the session status of the database of each configuration addition It surveys, and the release processing that conversated in time according to monitoring result.Specifically, database operation platform is based on being deployed in each number in advance According to administration agent in the data in library, the attribute letter for executing order or acquiring each database in real time is periodically pushed to each database Breath, and attribute information is returned into terminal and carries out page presentation.Attribute information includes many index of database, as load data, Session status, session number etc..If user has found the meeting of some database according to the attribute information of each database of terminal display Speech phase is in the lock state, can be by selecting the triggering of " session unlock " management project on administration page to associated databases It is unlocked.The unlocking request that database operation platform is triggered according to user, using corresponding management component interrupting service system with Session between the database discharges the Session Resources of associated databases in time.
In the present embodiment, database operation platform is monitored the session status for managing multiple databases, and will monitoring As a result corresponding terminal is pushed in time, so that user understands the session status of each database in time, to some session status Can the database of lock state unlock in time, reduce because database session it is long-term occupy other business caused by influence.
In one embodiment, management information includes the Database Identification and attribute information of source database；Management project packet Include Data Migration；The selected corresponding database of Database Identification is managed, including：If management project is Data Migration, The migration page is obtained, the migration page is back to terminal；The migration page includes the Database Identifications of multiple target databases and more Kind migration dimension option；Receive the migration information that terminal is returned based on the migration page；Migration information includes selected target data The Database Identification in library and corresponding migration dimension option；Transfer parameter is generated according to the attribute information of source database；It will migration Parameter is sent to the corresponding destination server of selected target database；In the confirmation transfer letter for receiving destination server return When breath, according to migration dimension option, call migration interface by source database data and/or structural transfer to target data Library.
With business transition or data backup demand, user is sometimes for Data Migration is carried out, i.e., in deployment database Physical machine break down before, by the Data Migration of the database disposed in the physical machine (hereinafter referred to as " source database ") to portion Affix one's name to another database (hereinafter referred to as " target database ") in other physical machines.
The Migration tools of mainstream have EXP, IMP and DATAPUMP etc. at present.Wherein, Migration tools EXP, IMP can be in visitor Family end executes, and application method is simple, but execution speed is slow, and migration pattern is single.Oracle included Migration tools DATAPUMP It needs to execute in server-side, compares EXP, IMP, application method is complicated, but migration velocity is fast, and the importing with higher flexibility ratio Export mode.The management assembly for Data Migration that database operation platform provided by the present application provides based on DATAPUMP into Row transformation, continues that its migration velocity is fast and the flexible characteristic of migration pattern, and is made by far call and Transfer Parameters to evade With the disadvantage of method complexity, user is allow easily to choose at random target database in the migration page.
Specifically, server user obtains preset one or more if the management project that user selectes is Data Migration The attribute information of target database.Attribute information includes target database mark.Multiple number of targets that server by utilizing is got According to the migration page that the attribute information in library generates, the migration page is back to terminal.User can be multiple in migration page browsing The attribute information of target database mark, therefrom selection can receive one or more target datas of source database Data Migration Library mark.The migration page provides a variety of migration dimension options, and such as migrating data and table structure, a migrating data do not migrate simultaneously Table structure only migrates table structure not migrating data etc..User can also select each source database mark in the migration page and correspond to Migration dimension option, to realize different Data Migration modes.
The Database Identification for the target database that terminal selectes user and corresponding migration dimension option send server. Server obtains the attribute information of source database, generates transfer parameter according to the attribute information of source database.Attribute information includes Need data volume, the data type etc. of migrating data.Server parses the attribute information of source database, and attribute information is turned Turn to DATAPUMP transfer parameter (hereinafter referred to as " transfer parameter ").Transfer parameter is remotely sent to target database by server Corresponding server (hereinafter referred to as " destination server "), so that destination server judges whether that source can be received according to transfer parameter Data in database.When receiving the confirmation transinformation of target database return, server calls destination server pair The DATAPUMP interface answered, the Data Migration mode selected according to user, by data, associated object or the sequence in source database Column etc. are migrated to target database.
In another embodiment, in order to avoid human operational error, by source database Data Migration to target data The data that will just have moved in source database after the preset duration in library deletion.Preset duration can freely be set according to actual needs It is fixed, such as 1 day.
In the present embodiment, the management assembly for Data Migration that database operation platform provides, not only application method letter It is single, so that user is easily chosen at random target database in the migration page, and migration velocity is fast, migration pattern is flexible.
In one embodiment, management project includes data readback；To the selected corresponding database of Database Identification into Before row management, further include：The data altering event that capture terminal occurs respectively in multiple databases, generates data altering event Corresponding action statement；Action statement is parsed, corresponding rollback sentence is generated.
In the present embodiment, the selected corresponding database of Database Identification is managed, including：If management project is Data readback obtains the corresponding rollback sentence of Database Identification, is recalled by operation rollback sentence and corresponds to number to Database Identification According to the change of data in library.
User can carry out data change operation, such as newly-increased or deletion business datum to database.Database is for industry For business system, importance is self-evident.The data change operation of any mistake can all cause serious chain reaction.Traditional It needs artificially to be remedied when wrong data change operation occurs, i.e., the data readback manually changed modification to database, Low efficiency.
The data change operation that multiple databases of configured addition occur respectively for the application database operation platform into Row monitoring.Specifically, terminal is based on a preset data altering event for burying capture and occurring respectively in multiple databases, by capture Data altering event reports to server, and server remembers data change operation in the form of SQL statement (hereinafter referred to as " REDO ") Record is got off, i.e. the corresponding action statement of generation data change operation.Server carries out parsing generation pair to REDO to action statement The rollback sentence (hereinafter referred to as " UNDO ") answered, so that each data change operation has corresponding UNDO.Server is to each The UNDO that tables of data more operates is stored.
Subsequent user is when needing to carry out withdrawal operation to the data that fault adds or deletes, without opening corresponding data Table only need to can trigger based on " data readback " management project on administration interface and execute corresponding rollback sentence, automatically by phase The data change operation answered is recalled, and database is made to return to the state before data change occurs, simplifies data readback operation.
In the present embodiment, the management assembly for data readback that database operation platform provides can help user to exist The data change operation of minimum fine granularity rollback mistake, data can be restored by making the user do not need to open corresponding tables of data, be simplified Data readback operation.
In one embodiment, management information further includes recyclable data type；Management project includes space management；To choosing The corresponding database of fixed Database Identification is managed, including：If management project is space management, monitor database mark pair The remaining space capacity answered；If remaining space capacity be less than preset threshold, to the data in Database Identification correspondence database into Row traversal, screens data corresponding with recyclable data type；The data filtered out are deleted from associated databases, discharge data The space resources in library.
The management assembly for space management that database operation platform provides, can be to the spatial content of test database Automatically it is safeguarded, space management can also be carried out in the space management request that administration page triggers based on user.Spatial content Way to manage has very much, and in one of embodiment, the gross space capacity of each database of monitoring server judges that space holds Whether amount reaches corresponding capacity threshold.If reaching, server disables the automatic expanding function of data file in associated databases； Conversely, then enabling the automatic expanding function of data file in associated databases.
In another real-time mode, if user selectes " space management " management project, monitoring server phase in administration page The remaining space capacity for answering the corresponding database of Database Identification, judges whether remaining space capacity is less than preset threshold.If so, Server is polled traversal to the data in Database Identification correspondence database, screens number corresponding with recyclable data type According to, by the data filtered out from associated databases delete.Recyclable data type can be all logs related with database Deng.
In another embodiment, if user selectes " space management " management project in administration page, terminal is sent to clothes The management information of business device further includes the table name for the one or more meaningless table that user specifies.Server is according to management information in phase It answers and inquires corresponding tables of data in database, carry out deletion cleaning using management assembly.Management assembly for space management can To be truncate (a kind of cleaning assembly).It should be noted that oracle included truncate and drop can delete number According to, and space can be recycled while deletion data.Since drop will be deleted table, also when carrying out table space recycling using drop It needs to retain the information such as the index of table structure and table, then selects to recycle table space using truncate component here, make sky Between manage it is more convenient.
In the present embodiment, the spatial content of test database is monitored, space pipe is carried out according to monitoring result automatically Reason carries out space management in the space management request that administration page triggers based on user, it can be ensured that each database ring Disk space on border utilizes maximization.
It should be understood that although each step in the flow chart of Fig. 2 is successively shown according to the instruction of arrow, this A little steps are not that the inevitable sequence according to arrow instruction successively executes.Unless expressly state otherwise herein, these steps It executes there is no the limitation of stringent sequence, these steps can execute in other order.Moreover, at least part in Fig. 2 Step may include that perhaps these sub-steps of multiple stages or stage are executed in synchronization to multiple sub-steps It completes, but can execute at different times, the execution sequence in these sub-steps or stage, which is also not necessarily, successively to be carried out, But it can be executed in turn or alternately at least part of the sub-step or stage of other steps or other steps.
In one embodiment, as shown in figure 3, providing a kind of platform database managing device, including：Project determines Module 302, type identification module 304 and database management module 306, wherein：
Project determining module 302, for receiving the data base administration request of terminal transmission；Response database management request, Administration page is returned to terminal；Administration page includes multiple Database Identifications and multiple management projects；It receives terminal and is based on management The management information that the page returns；Management information includes selected Database Identification, and the selected corresponding pipe of Database Identification Reason project.
Type identification module 304, the corresponding type of database of Database Identification selected for identification.
Database management module 306, for according to type of database and the corresponding management item of selected Database Identification Mesh calls corresponding management assembly, is managed to the selected corresponding database of Database Identification.
In one embodiment, which further includes Platform deployment module 308, for receiving the platform access of terminal transmission Request；It is requested according to platform access, detects whether to be stored with corresponding image file；If it is not, being pulled accordingly in mirror image warehouse Image file disposes database operation platform by starting image file, generates the access address of database operation platform；It sends Access address makes terminal be based on access address and accesses database operation platform to terminal.
In one embodiment, database operation platform deploys baseline database；Management information includes multiple databases Mark；The corresponding database of Database Identification includes service database and test database；Management project includes structure synchronization；Number It include structure synchronization module 3062 according to database management module 306, for connecting baseline database and the configuration of multiple service databases； Baseline database is for storing the corresponding structured data dictionary of multiple service databases；It is more according to preset time frequency collection The structured data dictionary of a service database；According to structured data dictionary is collected, to corresponding construction data in baseline database Dictionary is updated；If management project is structure synchronization, the corresponding structure number of Database Identification of baseline database storage is obtained According to dictionary；According to the structured data dictionary got, call multi-thread concurrent to the corresponding test of multiple Database Identifications Structured data dictionary is updated in database, so that the corresponding service database of Database Identification and test data library structure are same Step.
In one embodiment, management project includes session unlock；Database management module 306 includes session unlocked state 3064, for monitoring session status of multiple databases respectively between corresponding service system；Monitoring result is fed back into terminal； Make terminal in the session status lock state of database, unlock is triggered based on the management project that session in administration page unlocks Request；If management project is session unlock, the corresponding database of Database Identification and corresponding service system are interrupted using management assembly Session between system.
In one embodiment, management information includes the Database Identification and attribute information of source database；Management project packet Include Data Migration；Database management module 306 includes Data Migration module 3066, if being Data Migration for management project, is obtained The migration page is taken, the migration page is back to terminal；The migration page includes the Database Identifications of multiple target databases and a variety of Migrate dimension option；Receive the migration information that terminal is returned based on the migration page；Migration information includes selected target database Database Identification and corresponding migration dimension option；Transfer parameter is generated according to the attribute information of source database；Migration is joined Number is sent to the corresponding destination server of selected target database；In the confirmation transinformation for receiving destination server return When, according to migration dimension option, call migration interface by source database data and/or structural transfer to target database.
In one embodiment, management project includes data readback；Database management module 306 includes data readback module 3068, the data altering event occurred respectively for capturing terminal in multiple databases generates the corresponding behaviour of data altering event Make sentence；Action statement is parsed, corresponding rollback sentence is generated；If management project is data readback, database is obtained Corresponding rollback sentence is identified, recalls the change to data in Database Identification correspondence database by running rollback sentence.
In one embodiment, management information further includes recyclable data type；Management project includes space management；Data Database management module 306 includes space management module 3070, if being space management for management project, monitor database mark is corresponded to Remaining space capacity；If remaining space capacity is less than preset threshold, the data in Database Identification correspondence database are carried out Traversal screens data corresponding with recyclable data type；The data filtered out are deleted from associated databases, discharge database Space resources.
Specific restriction about platform database managing device may refer to above for platform database management The restriction of method, details are not described herein.Modules in above-mentioned platform database managing device can be fully or partially through Software, hardware and combinations thereof are realized.Above-mentioned each module can be embedded in the form of hardware or independently of the place in computer equipment It manages in device, can also be stored in a software form in the memory in computer equipment, in order to which processor calls execution or more The corresponding operation of modules.
In one embodiment, a kind of computer equipment is provided, which can be server, internal junction Composition can be as shown in Figure 4.The computer equipment include by system bus connect processor, memory, network interface and Database.Wherein, the processor of the computer equipment is for providing calculating and control ability.The memory packet of the computer equipment Include non-volatile memory medium, built-in storage.The non-volatile memory medium is stored with operating system, computer program and data Library.The built-in storage provides environment for the operation of operating system and computer program in non-volatile memory medium.The calculating Attribute information of the database of machine equipment for multiple databases of configured addition.The network interface of the computer equipment is used for It is communicated with external terminal by network connection.To realize a kind of platform database when the computer program is executed by processor Management method.
It will be understood by those skilled in the art that structure shown in Fig. 4, only part relevant to application scheme is tied The block diagram of structure does not constitute the restriction for the computer equipment being applied thereon to application scheme, specific computer equipment It may include perhaps combining certain components or with different component layouts than more or fewer components as shown in the figure.
In one embodiment, a kind of computer equipment, including memory and processor are provided, which is stored with Computer program, the processor realize following steps when executing computer program：Receive the data base administration request that terminal is sent； Response database management request returns to administration page to terminal；Administration page includes multiple Database Identifications and multiple management items Mesh；Receive the management information that terminal is returned based on administration page；Management information includes selected Database Identification, and selected The corresponding management project of Database Identification；The selected corresponding type of database of Database Identification of identification；According to type of database And the selected corresponding management project of Database Identification, corresponding management assembly is called, it is corresponding to selected Database Identification Database be managed.
In one embodiment, following steps are also realized when processor executes computer program：Receive the flat of terminal transmission Platform access request；It is requested according to platform access, detects whether to be stored with corresponding image file；If it is not, being pulled in mirror image warehouse Corresponding image file disposes database operation platform by starting image file, generates the access of database operation platform Location；Access address is sent to terminal, so that terminal is based on access address and accesses database operation platform.
In one embodiment, database operation platform deploys baseline database；Management information includes multiple databases Mark；The corresponding database of Database Identification includes service database and test database；Management project includes structure synchronization；Place Reason device also realizes following steps when executing computer program：Baseline database and the configuration of multiple service databases are connected；Baseline Database is for storing the corresponding structured data dictionary of multiple service databases；According to the multiple industry of preset time frequency collection The structured data dictionary of business database；According to structured data dictionary is collected, to corresponding construction data dictionary in baseline database It is updated；If management project is structure synchronization, the corresponding structured data word of Database Identification of baseline database storage is obtained Allusion quotation；According to the structured data dictionary got, call multi-thread concurrent to the corresponding test data of multiple Database Identifications Structured data dictionary is updated in library, so that the corresponding service database of Database Identification and test database structure synchronization.
In one embodiment, management project includes session unlock；It is also realized when processor executes computer program following Step：Monitor session status of multiple databases respectively between corresponding service system；Monitoring result is fed back into terminal；Make end It holds when the session status of database is lock state, is asked based on the management project triggering unlock that session in administration page unlocks It asks；If management project is session unlock, the corresponding database of Database Identification and corresponding service system are interrupted using management assembly Between session.
In one embodiment, management information includes the Database Identification and attribute information of source database；Management project packet Include Data Migration；Processor also realizes following steps when executing computer program：If management project is Data Migration, migration is obtained The migration page is back to terminal by the page；The migration page includes the Database Identification and a variety of migrations dimension of multiple target databases Spend option；Receive the migration information that terminal is returned based on the migration page；Migration information includes the data of selected target database Library mark and corresponding migration dimension option；Transfer parameter is generated according to the attribute information of source database；Transfer parameter is sent To the selected corresponding destination server of target database；When receiving the confirmation transinformation of destination server return, root According to migration dimension option, call migration interface by source database data and/or structural transfer to target database.
In one embodiment, management project includes data readback；It is also realized when processor executes computer program following Step：The data altering event that capture terminal occurs respectively in multiple databases generates the corresponding operation language of data altering event Sentence；Action statement is parsed, corresponding rollback sentence is generated；If management project is data readback, Database Identification is obtained Corresponding rollback sentence recalls the change to data in Database Identification correspondence database by running rollback sentence.
In one embodiment, management information further includes recyclable data type；Management project includes space management；Processing Device also realizes following steps when executing computer program：If management project is space management, monitor database mark is corresponding surplus Complementary space capacity；If remaining space capacity is less than preset threshold, the data in Database Identification correspondence database are traversed, Screen data corresponding with recyclable data type；The data filtered out are deleted from associated databases, discharge the sky of database Between resource.
In one embodiment, a kind of computer readable storage medium is provided, computer program is stored thereon with, is calculated Machine program realizes following steps when being executed by processor：Receive the data base administration request that terminal is sent；Response database management Request returns to administration page to terminal；Administration page includes multiple Database Identifications and multiple management projects；Terminal is received to be based on The management information that administration page returns；Management information includes selected Database Identification, and selected Database Identification is corresponding Management project；The selected corresponding type of database of Database Identification of identification；According to type of database and selected data Library identifies corresponding management project, calls corresponding management assembly, carries out pipe to the selected corresponding database of Database Identification Reason.
In one embodiment, following steps are also realized when computer program is executed by processor：Receive what terminal was sent Platform access request；It is requested according to platform access, detects whether to be stored with corresponding image file；If it is not, being drawn in mirror image warehouse Corresponding image file is taken, database operation platform is disposed by starting image file, generates the access of database operation platform Address；Access address is sent to terminal, so that terminal is based on access address and accesses database operation platform.
In one embodiment, database operation platform deploys baseline database；Management information includes multiple databases Mark；The corresponding database of Database Identification includes service database and test database；Management project includes structure synchronization；Meter Calculation machine program also realizes following steps when being executed by processor：Baseline database and the configuration of multiple service databases are connected；Base Line database is for storing the corresponding structured data dictionary of multiple service databases；It is multiple according to preset time frequency collection The structured data dictionary of service database；According to structured data dictionary is collected, to corresponding construction data word in baseline database Allusion quotation is updated；If management project is structure synchronization, the corresponding structured data of Database Identification of baseline database storage is obtained Dictionary；According to the structured data dictionary got, call multi-thread concurrent to the corresponding test number of multiple Database Identifications It is updated according to structured data dictionary in library, so that the corresponding service database of Database Identification and test data library structure are same Step.
In one embodiment, management project includes session unlock；When computer program is executed by processor also realize with Lower step：Monitor session status of multiple databases respectively between corresponding service system；Monitoring result is fed back into terminal；Make Terminal is asked when the session status of database is lock state based on the management project triggering unlock that session in administration page unlocks It asks；If management project is session unlock, the corresponding database of Database Identification and corresponding service system are interrupted using management assembly Between session.
In one embodiment, management information includes the Database Identification and attribute information of source database；Management project packet Include Data Migration；Following steps are also realized when computer program is executed by processor：If management project is Data Migration, acquisition is moved The page is moved, the migration page is back to terminal；Migrate the Database Identification and a variety of migrations that the page includes multiple target databases Dimension option；Receive the migration information that terminal is returned based on the migration page；Migration information includes the number of selected target database According to library mark and corresponding migration dimension option；Transfer parameter is generated according to the attribute information of source database；Transfer parameter is sent out It send to the selected corresponding destination server of target database；When receiving the confirmation transinformation of destination server return, According to migration dimension option, call migration interface by source database data and/or structural transfer to target database.
In one embodiment, management project includes data readback；When computer program is executed by processor also realize with Lower step：The data altering event that capture terminal occurs respectively in multiple databases generates the corresponding operation of data altering event Sentence；Action statement is parsed, corresponding rollback sentence is generated；If management project is data readback, database mark is obtained Know corresponding rollback sentence, recalls the change to data in Database Identification correspondence database by running rollback sentence.
In one embodiment, management information further includes recyclable data type；Management project includes space management；It calculates Machine program also realizes following steps when being executed by processor：：If management project is space management, monitor database mark is corresponding Remaining space capacity；If remaining space capacity is less than preset threshold, to the data progress time in Database Identification correspondence database It goes through, screens data corresponding with recyclable data type；The data filtered out are deleted from associated databases, discharge database Space resources.
Those of ordinary skill in the art will appreciate that realizing all or part of the process in above-described embodiment method, being can be with Instruct relevant hardware to complete by computer program, computer program to can be stored in a non-volatile computer readable It takes in storage medium, the computer program is when being executed, it may include such as the process of the embodiment of above-mentioned each method.Wherein, this Shen Please provided by any reference used in each embodiment to memory, storage, database or other media, may each comprise Non-volatile and/or volatile memory.Nonvolatile memory may include read-only memory (ROM), programming ROM (PROM), electrically programmable ROM (EPROM), electrically erasable ROM (EEPROM) or flash memory.Volatile memory may include Random access memory (RAM) or external cache.By way of illustration and not limitation, RAM is available in many forms, Such as static state RAM (SRAM), dynamic ram (DRAM), synchronous dram (SDRAM), double data rate sdram (DDRSDRAM), enhancing Type SDRAM (ESDRAM), synchronization link (Synchlink) DRAM (SLDRAM), memory bus (Rambus) direct RAM (RDRAM), direct memory bus dynamic ram (DRDRAM) and memory bus dynamic ram (RDRAM) etc..
Each technical characteristic of above embodiments can be combined arbitrarily, for simplicity of description, not to above-described embodiment In each technical characteristic it is all possible combination be all described, as long as however, the combination of these technical characteristics be not present lance Shield all should be considered as described in this specification.
Above embodiments only express the several embodiments of the application, and the description thereof is more specific and detailed, but can not Therefore it is construed as limiting the scope of the patent.It should be pointed out that for those of ordinary skill in the art, Under the premise of not departing from the application design, various modifications and improvements can be made, these belong to the protection scope of the application. Therefore, the scope of protection shall be subject to the appended claims for the application patent.

Claims (10)

1. a kind of platform database management method, the method includes：
Receive the data base administration request that terminal is sent；
The data base administration request is responded, returns to administration page to the terminal；The administration page includes multiple databases Mark and multiple management projects；
Receive the management information that the terminal is returned based on the administration page；The management information includes selected database mark Knowledge and the corresponding management project of the selected Database Identification；
Identify the corresponding type of database of the selected Database Identification；
According to the type of database and the corresponding management project of the selected Database Identification, corresponding management group is called Part is managed the corresponding database of the selected Database Identification.
2. the method according to claim 1, wherein the method also includes：
Receive the platform access request that the terminal is sent；
It is requested according to the platform access, detects whether to be stored with corresponding image file；
If it is not, pulling corresponding image file in mirror image warehouse, database operation platform is disposed by starting the image file, Generate the access address of the database operation platform；
The access address is sent to terminal, so that terminal is based on the access address and accesses database operation platform.
3. according to the method described in claim 2, it is characterized in that, the database operation platform deploys baseline database； The management information includes multiple Database Identifications；The corresponding database of the Database Identification includes service database and test Database；The management project includes structure synchronization；
It is described the corresponding database of the selected Database Identification is managed before, further include：
The baseline database and the configuration of multiple service databases are connected；The baseline database is for storing multiple business numbers According to the corresponding structured data dictionary in library；
According to the structured data dictionary of the multiple service databases of preset time frequency collection；
According to structured data dictionary is collected, corresponding construction data dictionary in baseline database is updated；
It is described that the corresponding database of the selected Database Identification is managed, including：
If the management project is structure synchronization, the corresponding structure of the Database Identification of the baseline database storage is obtained Data dictionary；
According to the structured data dictionary got, call multi-thread concurrent to the corresponding test data of multiple Database Identifications Structured data dictionary is updated in library, so that the corresponding service database of the Database Identification and test data library structure are same Step.
4. the method according to claim 1, wherein the management project includes session unlock；It is described to described Before the corresponding database of selected Database Identification is managed, further include：
Monitor session status of multiple databases respectively between corresponding service system；
Monitoring result is fed back into terminal；Make terminal in the session status lock state of the database, is based on the pipe The management project for managing session unlock in the page triggers unlocking request；
It is described that the corresponding database of the selected Database Identification is managed, including：
If the management project is session unlock, using the management assembly interrupt the corresponding database of the Database Identification with Session between corresponding service system.
5. the method according to claim 1, wherein the management information includes the Database Identification of source database And attribute information；The management project includes Data Migration；It is described to the corresponding database of the selected Database Identification into Row management, including：
If the management project is Data Migration, the migration page is obtained, the migration page is back to the terminal；It is described to move Move the Database Identification and a variety of migration dimension options that the page includes multiple target databases；
Receive the migration information that the terminal is returned based on the migration page；The migration information includes selected target data The Database Identification in library and corresponding migration dimension option；
Transfer parameter is generated according to the attribute information of the source database；
The transfer parameter is sent to the corresponding destination server of selected target database；
When receiving the confirmation transinformation that the destination server returns, according to the migration dimension option, migration is called Interface by the source database data and/or structural transfer to the target database.
6. the method according to claim 1, wherein the management project includes data readback；
It is described the corresponding database of the selected Database Identification is managed before, further include：
The data altering event that the terminal occurs respectively in multiple databases is captured, the data altering event pair is generated The action statement answered；
The action statement is parsed, corresponding rollback sentence is generated；
It is described that the corresponding database of the selected Database Identification is managed, including：
If the management project is data readback, the corresponding rollback sentence of the Database Identification is obtained, by running described return Rolling sentence recalls the change to data in the Database Identification correspondence database.
7. the method according to claim 1, wherein the management information further includes recyclable data type；Institute Stating management project includes space management；It is described that the corresponding database of the selected Database Identification is managed, including：
If the management project is space management, the corresponding remaining space capacity of the Database Identification is monitored；
If the remaining space capacity is less than preset threshold, to the data progress time in the Database Identification correspondence database It goes through, screening data corresponding with the recyclable data type；
The data filtered out are deleted from associated databases, discharge the space resources of the database.
8. a kind of platform database managing device, described device include：
Project determining module, for receiving the data base administration request of terminal transmission；The data base administration request is responded, to institute It states terminal and returns to administration page；The administration page includes multiple Database Identifications and multiple management projects；Receive the terminal The management information returned based on the administration page；The management information includes selected Database Identification and described selected The corresponding management project of Database Identification；
Type identification module, for identification corresponding type of database of the selected Database Identification；
Database management module, for according to the type of database and the corresponding management item of the selected Database Identification Mesh calls corresponding management assembly, is managed to the corresponding database of the selected Database Identification.
9. a kind of computer equipment, including memory and processor, the memory are stored with computer program, feature exists In the step of processor realizes any one of claims 1 to 7 the method when executing the computer program.
10. a kind of computer readable storage medium, is stored thereon with computer program, which is characterized in that the computer program The step of method described in any one of claims 1 to 7 is realized when being executed by processor.
CN201810622602.9A 2018-06-15 2018-06-15 Cross-platform database management method, device, computer equipment and storage medium Active CN108932309B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201810622602.9A CN108932309B (en) 2018-06-15 2018-06-15 Cross-platform database management method, device, computer equipment and storage medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201810622602.9A CN108932309B (en) 2018-06-15 2018-06-15 Cross-platform database management method, device, computer equipment and storage medium

Publications (2)

Publication Number Publication Date
CN108932309A true CN108932309A (en) 2018-12-04
CN108932309B CN108932309B (en) 2020-12-01

Family

ID=64446530

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201810622602.9A Active CN108932309B (en) 2018-06-15 2018-06-15 Cross-platform database management method, device, computer equipment and storage medium

Country Status (1)

Country Link
CN (1) CN108932309B (en)

Cited By (13)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN109634976A (en) * 2018-12-12 2019-04-16 泰康保险集团股份有限公司 O&M method, apparatus, system and the readable storage medium storing program for executing of non-relational database
CN110138582A (en) * 2019-01-04 2019-08-16 北京车和家信息技术有限公司 Information processing method, device and O&M environmental improvement system
CN110502551A (en) * 2019-08-02 2019-11-26 阿里巴巴集团控股有限公司 Data read-write method, system and infrastructure component
CN110784532A (en) * 2019-10-25 2020-02-11 北京天润融通科技股份有限公司 Bidirectional data synchronization method and system
CN111352944A (en) * 2020-02-10 2020-06-30 北京百度网讯科技有限公司 Data processing method and device, electronic equipment and storage medium
CN111399830A (en) * 2020-03-16 2020-07-10 北京五八信息技术有限公司 Application program capacity monitoring method and device, electronic equipment and storage medium
CN111897794A (en) * 2020-06-23 2020-11-06 中国建设银行股份有限公司 Database maintenance method and device, electronic equipment and storage medium
CN112035197A (en) * 2020-08-11 2020-12-04 深圳前海微众银行股份有限公司 Configuration method and device of front-end page
CN112559913A (en) * 2020-12-11 2021-03-26 车智互联（北京）科技有限公司 Data processing method and device, computing equipment and readable storage medium
CN112835866A (en) * 2019-11-25 2021-05-25 深圳云天励飞技术有限公司 Database implementation method and device, electronic equipment and storage medium
CN113392092A (en) * 2021-07-06 2021-09-14 山东电力工程咨询院有限公司 Database management method and system of data center
CN113656095A (en) * 2021-08-06 2021-11-16 北京数码大方科技股份有限公司 Method and device for processing configuration data
CN114936031A (en) * 2022-07-22 2022-08-23 浙江中控技术股份有限公司 Component calling method and electronic equipment

Citations (22)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1497459A (en) * 2002-10-16 2004-05-19 Ф������ά�� Portable cross-platform data base access method and system
US20040153440A1 (en) * 2003-01-30 2004-08-05 Assaf Halevy Unified management of queries in a multi-platform distributed environment
CN1904883A (en) * 2005-07-28 2007-01-31 中兴通讯股份有限公司 Via platform database copying configurating method
CN101840348A (en) * 2009-12-24 2010-09-22 陕西移数通电讯有限公司 Database middleware system
CN101932135A (en) * 2010-08-16 2010-12-29 中兴通讯股份有限公司 Web management-based wireless data card and implementation method thereof
CN102262680A (en) * 2011-08-18 2011-11-30 北京新媒传信科技有限公司 Distributed database proxy system based on massive data access requirement
CN102591921A (en) * 2010-12-20 2012-07-18 微软公司 Scheduling and management in a personal datacenter
US20130304697A1 (en) * 2012-05-09 2013-11-14 Salesforce.Com, Inc. System and method for cross-platform synchronization of data objects in a multi-tenant environment
CN103425778A (en) * 2013-08-16 2013-12-04 国家电网公司 Intelligent development platform for database application system
CN103856393A (en) * 2013-07-09 2014-06-11 携程计算机技术（上海）有限公司 Distributed message-oriented middleware system based on database and operating method thereof
CN104252485A (en) * 2013-06-29 2014-12-31 北京新媒传信科技有限公司 Database management platform
CN105359143A (en) * 2013-07-10 2016-02-24 甲骨文国际公司 Database diagnostics interface system
CN105512790A (en) * 2015-08-14 2016-04-20 上海合胜计算机科技股份有限公司 Integrated operation and maintenance management system
CN106095571A (en) * 2016-06-07 2016-11-09 中国建设银行股份有限公司 Many RAC group system, data access method and device
WO2017023386A2 (en) * 2015-05-08 2017-02-09 YC Wellness, Inc. Integration platform and application interfaces for remote data management and security
CN106446298A (en) * 2016-11-29 2017-02-22 盐城工学院 Data management method and device based on PDM (Pulse Duration Modulation)
US9582559B1 (en) * 2012-06-29 2017-02-28 EMC IP Holding Company LLC Multi-site storage system with replicated file system synchronization utilizing virtual block storage appliances
US20170244658A1 (en) * 2016-02-18 2017-08-24 Nicholas George Celone Processing system for multivariate segmentation of electronic message content
CN107220310A (en) * 2017-05-11 2017-09-29 中国联合网络通信集团有限公司 A kind of database data management system, method and device
CN107451169A (en) * 2017-03-07 2017-12-08 河海大学常州校区 A kind of athletic competition information issuing system general-purpose platform
CN108027887A (en) * 2015-05-15 2018-05-11 空气融合有限公司 Portable set and method for the decision support for automating Fusion and analysis in real time
CN108052365A (en) * 2017-12-19 2018-05-18 深圳市四格互联信息技术有限公司 The component generation method and device of user interface

Patent Citations (23)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN100424662C (en) * 2002-10-16 2008-10-08 肖恩·萨维奇 Portable cross-platform data base access method and system
CN1497459A (en) * 2002-10-16 2004-05-19 Ф������ά�� Portable cross-platform data base access method and system
US20040153440A1 (en) * 2003-01-30 2004-08-05 Assaf Halevy Unified management of queries in a multi-platform distributed environment
CN1904883A (en) * 2005-07-28 2007-01-31 中兴通讯股份有限公司 Via platform database copying configurating method
CN101840348A (en) * 2009-12-24 2010-09-22 陕西移数通电讯有限公司 Database middleware system
CN101932135A (en) * 2010-08-16 2010-12-29 中兴通讯股份有限公司 Web management-based wireless data card and implementation method thereof
CN102591921A (en) * 2010-12-20 2012-07-18 微软公司 Scheduling and management in a personal datacenter
CN102262680A (en) * 2011-08-18 2011-11-30 北京新媒传信科技有限公司 Distributed database proxy system based on massive data access requirement
US20130304697A1 (en) * 2012-05-09 2013-11-14 Salesforce.Com, Inc. System and method for cross-platform synchronization of data objects in a multi-tenant environment
US9582559B1 (en) * 2012-06-29 2017-02-28 EMC IP Holding Company LLC Multi-site storage system with replicated file system synchronization utilizing virtual block storage appliances
CN104252485A (en) * 2013-06-29 2014-12-31 北京新媒传信科技有限公司 Database management platform
CN103856393A (en) * 2013-07-09 2014-06-11 携程计算机技术（上海）有限公司 Distributed message-oriented middleware system based on database and operating method thereof
CN105359143A (en) * 2013-07-10 2016-02-24 甲骨文国际公司 Database diagnostics interface system
CN103425778A (en) * 2013-08-16 2013-12-04 国家电网公司 Intelligent development platform for database application system
WO2017023386A2 (en) * 2015-05-08 2017-02-09 YC Wellness, Inc. Integration platform and application interfaces for remote data management and security
CN108027887A (en) * 2015-05-15 2018-05-11 空气融合有限公司 Portable set and method for the decision support for automating Fusion and analysis in real time
CN105512790A (en) * 2015-08-14 2016-04-20 上海合胜计算机科技股份有限公司 Integrated operation and maintenance management system
US20170244658A1 (en) * 2016-02-18 2017-08-24 Nicholas George Celone Processing system for multivariate segmentation of electronic message content
CN106095571A (en) * 2016-06-07 2016-11-09 中国建设银行股份有限公司 Many RAC group system, data access method and device
CN106446298A (en) * 2016-11-29 2017-02-22 盐城工学院 Data management method and device based on PDM (Pulse Duration Modulation)
CN107451169A (en) * 2017-03-07 2017-12-08 河海大学常州校区 A kind of athletic competition information issuing system general-purpose platform
CN107220310A (en) * 2017-05-11 2017-09-29 中国联合网络通信集团有限公司 A kind of database data management system, method and device
CN108052365A (en) * 2017-12-19 2018-05-18 深圳市四格互联信息技术有限公司 The component generation method and device of user interface

Cited By (17)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN109634976A (en) * 2018-12-12 2019-04-16 泰康保险集团股份有限公司 O&M method, apparatus, system and the readable storage medium storing program for executing of non-relational database
CN110138582A (en) * 2019-01-04 2019-08-16 北京车和家信息技术有限公司 Information processing method, device and O&M environmental improvement system
CN110502551A (en) * 2019-08-02 2019-11-26 阿里巴巴集团控股有限公司 Data read-write method, system and infrastructure component
CN110784532A (en) * 2019-10-25 2020-02-11 北京天润融通科技股份有限公司 Bidirectional data synchronization method and system
CN112835866A (en) * 2019-11-25 2021-05-25 深圳云天励飞技术有限公司 Database implementation method and device, electronic equipment and storage medium
CN111352944A (en) * 2020-02-10 2020-06-30 北京百度网讯科技有限公司 Data processing method and device, electronic equipment and storage medium
CN111352944B (en) * 2020-02-10 2023-08-18 北京百度网讯科技有限公司 Data processing method, device, electronic equipment and storage medium
CN111399830B (en) * 2020-03-16 2023-03-31 北京五八信息技术有限公司 Application program capacity monitoring method and device, electronic equipment and storage medium
CN111399830A (en) * 2020-03-16 2020-07-10 北京五八信息技术有限公司 Application program capacity monitoring method and device, electronic equipment and storage medium
CN111897794A (en) * 2020-06-23 2020-11-06 中国建设银行股份有限公司 Database maintenance method and device, electronic equipment and storage medium
CN112035197A (en) * 2020-08-11 2020-12-04 深圳前海微众银行股份有限公司 Configuration method and device of front-end page
CN112559913A (en) * 2020-12-11 2021-03-26 车智互联（北京）科技有限公司 Data processing method and device, computing equipment and readable storage medium
CN112559913B (en) * 2020-12-11 2023-10-20 车智互联（北京）科技有限公司 Data processing method, device, computing equipment and readable storage medium
CN113392092A (en) * 2021-07-06 2021-09-14 山东电力工程咨询院有限公司 Database management method and system of data center
CN113656095A (en) * 2021-08-06 2021-11-16 北京数码大方科技股份有限公司 Method and device for processing configuration data
CN113656095B (en) * 2021-08-06 2023-08-04 北京数码大方科技股份有限公司 Processing method and device for configuration data
CN114936031A (en) * 2022-07-22 2022-08-23 浙江中控技术股份有限公司 Component calling method and electronic equipment

Also Published As

Publication number Publication date
CN108932309B (en) 2020-12-01

Similar Documents

Publication Publication Date Title
CN108932309A (en) Platform database management method, device, computer equipment and storage medium
CN110768833B (en) Application arrangement and deployment method and device based on kubernets
CN110389900B (en) Distributed database cluster testing method and device and storage medium
US9940373B2 (en) Method and system for implementing an operating system hook in a log analytics system
US10248671B2 (en) Dynamic migration script management
US6681382B1 (en) Method and system for using virtual labels in a software configuration management system
CN101217400B (en) An integrated intelligent polling method and system
CN112269640B (en) Method for realizing life cycle management of container cloud component
CN106681956A (en) Method and device for operating large-scale computer cluster
CN104317843A (en) Data synchronism ETL (Extract Transform Load) system
CN105700939A (en) Method and system for multi-thread synchronization in distributed system
CN108897638A (en) Data back up method, device, computer equipment and storage medium
CN112600891A (en) Edge cloud cooperation system based on information physical fusion and working method
CN109905492B (en) Safety operation management system and method based on distributed modular data center
CN107844343A (en) The upgrade-system and method of a kind of complex services end application system
CN109240716B (en) Big data platform version management and rapid iterative deployment method and system
CN113973053B (en) Probe management system and method for network target range
CN110138876A (en) Task deployment method, apparatus, equipment and platform
CN115374102A (en) Data processing method and system
CN108241724A (en) A kind of metadata management method and device
Yiran et al. Design and implementation of continuous integration scheme based on Jenkins and Ansible
CN104954482A (en) Configuration management system and method
CN113778486A (en) Containerization processing method, device, medium and equipment for code pipeline
CN109145060A (en) Data processing method and device
CN114912897A (en) Workflow execution method, workflow arrangement method and electronic equipment

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
TA01 Transfer of patent application right

Effective date of registration: 20200122

Address after: 200120 floor 15, 1333 Lujiazui Ring Road, free trade Experimental Zone, Pudong New Area, Shanghai

Applicant after: Weikun (Shanghai) Technology Service Co., Ltd

Address before: 200120 13 floor, 1333 Lujiazui Road, Pudong New Area free trade pilot area, Shanghai.

Applicant before: Lujiazui Shanghai international financial assets market Limited by Share Ltd

TA01 Transfer of patent application right
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant