CN110377610A - A kind of database update method, apparatus, equipment and medium based on cloud platform - Google Patents
A kind of database update method, apparatus, equipment and medium based on cloud platform Download PDFInfo
- Publication number
- CN110377610A CN110377610A CN201910569963.6A CN201910569963A CN110377610A CN 110377610 A CN110377610 A CN 110377610A CN 201910569963 A CN201910569963 A CN 201910569963A CN 110377610 A CN110377610 A CN 110377610A
- Authority
- CN
- China
- Prior art keywords
- database
- data library
- cloud gateway
- cloud
- library
- 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.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 44
- 238000012545 processing Methods 0.000 claims abstract description 60
- 230000003993 interaction Effects 0.000 claims abstract description 38
- 238000013507 mapping Methods 0.000 claims abstract description 28
- 230000004044 response Effects 0.000 claims abstract description 9
- 230000015654 memory Effects 0.000 claims description 20
- 238000010586 diagram Methods 0.000 description 12
- 238000007726 management method Methods 0.000 description 5
- 230000008569 process Effects 0.000 description 4
- 238000000605 extraction Methods 0.000 description 3
- 230000008901 benefit Effects 0.000 description 2
- 230000008859 change Effects 0.000 description 2
- 238000012512 characterization method Methods 0.000 description 2
- 230000006378 damage Effects 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 2
- 239000000284 extract Substances 0.000 description 2
- 230000006870 function Effects 0.000 description 2
- 239000000203 mixture Substances 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000011017 operating method Methods 0.000 description 2
- YMHOBZXQZVXHBM-UHFFFAOYSA-N 2,5-dimethoxy-4-bromophenethylamine Chemical compound COC1=CC(CCN)=C(OC)C=C1Br YMHOBZXQZVXHBM-UHFFFAOYSA-N 0.000 description 1
- 241000545067 Venus Species 0.000 description 1
- 230000006978 adaptation Effects 0.000 description 1
- 238000007792 addition Methods 0.000 description 1
- 230000006399 behavior Effects 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 238000012217 deletion Methods 0.000 description 1
- 230000037430 deletion Effects 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 230000000977 initiatory effect Effects 0.000 description 1
- 238000007689 inspection Methods 0.000 description 1
- 238000012423 maintenance Methods 0.000 description 1
- 238000012544 monitoring process Methods 0.000 description 1
- 230000002085 persistent effect Effects 0.000 description 1
- 238000005498 polishing Methods 0.000 description 1
- 238000002360 preparation method Methods 0.000 description 1
- 230000000750 progressive effect Effects 0.000 description 1
- 238000012163 sequencing technique Methods 0.000 description 1
- 230000001360 synchronised effect Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L67/00—Network arrangements or protocols for supporting network services or applications
- H04L67/01—Protocols
- H04L67/10—Protocols in which an application is distributed across nodes in the network
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computer Networks & Wireless Communication (AREA)
- Signal Processing (AREA)
- Computing Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a kind of database update method, apparatus, equipment and medium based on cloud platform.The described method includes: carrying out the interaction data generated for the data interaction of cloud platform in response to cloud gateway, database manipulation object is generated;The mapping relations of database structure and object model based on creation compare the corresponding database object in cloud gateway data library and the database manipulation object, determine pending data library object and the corresponding processing information of pending data library object;Pending data library object is handled according to the processing information, to update cloud gateway data library.Can it is more acurrate, securely achieve automatically updating for cloud gateway data library, cost of labor can also be reduced while updating efficiency by improving.
Description
Technical field
The present invention relates to Internet communication technology field more particularly to a kind of database update method based on cloud platform,
Device, equipment and medium.
Background technique
Structured query language (StructuredQueryLanguage), abbreviation SQL are a kind of programmings of specific purposes
Language is a kind of data base querying and programming language, for accessing data and querying, updating, and managing relational database
System.Version is often used to manage the difference of data-base content, SQL statement can be used to realize in version.For example, can pass through
The difference between database version is managed based on the SQL statement of increment, and by order (manually selecting corresponding version)
It is updated and rollback operation.
In the case where needing frequently to interact with database, need the scene of frequent reading/storing data, the prior art is used
When need heavy workload and cumbersome manual working is as support, to guarantee effective update of database.However, version generates frequency
It is numerous, it is big manually to write SQL statement difficulty;SQL statement is as a kind of more original language, and for database, there is passes
The disclosure risk of key data information;It is unable to automatic updating data library simultaneously, increases management cost.Accordingly, it is desirable to provide more efficient,
The scheme of safety.
Summary of the invention
It applies to solve the prior art in database update, the problems such as low efficiency and poor safety, the present invention is provided
A kind of database update method, apparatus, equipment and medium based on cloud platform:
On the one hand, the database update method based on cloud platform that the present invention provides a kind of, which comprises
The interaction data generated for the data interaction of cloud platform is carried out in response to cloud gateway, generates database manipulation pair
As;
The mapping relations of database structure and object model based on creation compare the corresponding database in cloud gateway data library
Object and the database manipulation object, determine pending data library object and the corresponding processing of pending data library object
Information;
Pending data library object is handled according to the processing information, to update the cloud gateway data
Library.
On the other hand a kind of database update device based on cloud platform is provided, described device includes:
Database manipulation object generation module: in response to cloud gateway carry out for cloud platform data interaction generate
Interaction data generates database manipulation object;
Object comparison module: for the mapping relations of database structure and object model based on creation, compare cloud gateway
The corresponding database object of database and the database manipulation object, determine pending data library object and the number to be processed
According to the corresponding processing information of library object;
Database update module: for being handled according to the processing information pending data library object, with
Update cloud gateway data library.
On the other hand a kind of electronic equipment is provided, the electronic equipment includes processor and memory, the memory
In be stored at least one instruction, at least a Duan Chengxu, code set or instruction set, at least one instruction, described at least one
Duan Chengxu, the code set or instruction set are loaded by the processor and are executed to realize such as the above-mentioned data based on cloud platform
Library update method.
On the other hand a kind of computer readable storage medium is provided, at least one finger is stored in the storage medium
Enable, at least a Duan Chengxu, code set or instruction set, at least one instruction, an at least Duan Chengxu, the code set or
Instruction set is loaded by processor and is executed to realize such as the above-mentioned database update method based on cloud platform.
A kind of database update method, apparatus, equipment and medium based on cloud platform provided by the invention has following skill
Art effect:
Medium cloud gateway of the present invention carries out the various data interactions based on cloud platform, by resulting interaction data object
Change: database manipulation object.Meanwhile the mapping relations between the creation of corresponding cloud gateway data library and object model.It can be more
Accurately, automatically updating for cloud gateway data library is securely achieved, cost of labor can also be reduced while updating efficiency by improving.
Detailed description of the invention
It in order to more clearly explain the embodiment of the invention or the technical proposal in the existing technology and advantage, below will be to implementation
Example or attached drawing needed to be used in the description of the prior art are briefly described, it should be apparent that, the accompanying drawings in the following description is only
It is only some embodiments of the present invention, for those of ordinary skill in the art, without creative efforts,
It can also be obtained according to these attached drawings other attached drawings.
Fig. 1 is a kind of schematic diagram of application environment provided in an embodiment of the present invention;
Fig. 2 is a kind of flow diagram of database update method based on cloud platform provided in an embodiment of the present invention;
Fig. 3 is that determining pending data library object and pending data library object provided in an embodiment of the present invention are corresponding
Processing information a kind of flow diagram;
Fig. 4 is the database structure of creation provided in an embodiment of the present invention and the mapping relations schematic diagram of object model;
Fig. 5 is that the embodiment of the present invention provides each operational instances schematic diagram of difference processing operation object;
Fig. 6 is a kind of application environment schematic diagram for being related to multiple cloud platforms provided in an embodiment of the present invention;
Fig. 7 is a kind of composition block diagram of database update device based on cloud platform provided in an embodiment of the present invention;
Fig. 8 is a kind of composition block diagram of object comparison module provided in an embodiment of the present invention;
Fig. 9 is a kind of structural schematic diagram of server provided in an embodiment of the present invention.
Specific embodiment
Following will be combined with the drawings in the embodiments of the present invention, and technical solution in the embodiment of the present invention carries out clear, complete
Site preparation description, it is clear that described embodiments are only a part of the embodiments of the present invention, instead of all the embodiments.It is based on
Embodiment in the present invention, those of ordinary skill in the art without making creative work it is obtained it is all its
His embodiment, shall fall within the protection scope of the present invention.
It should be noted that term " includes " and " tool in description and claims of this specification and above-mentioned attached drawing
Have " and their any deformation, it is intended that cover it is non-exclusive include, for example, containing a series of steps or units
Process, method, system, product or server those of are not necessarily limited to be clearly listed step or unit, but may include not having
Other step or units being clearly listed or intrinsic for these process, methods, product or equipment.
Referring to Fig. 1, Fig. 1 is a kind of schematic diagram of application environment provided in an embodiment of the present invention, as shown in Figure 1, this is answered
With the related framework in environment including a cloud platform, automatic platform, monitor supervision platform and operation platform be can be used as in framework
Operation layer.Cloud gateway, IP system and access authentication system can be used as the cloud gateway layer in framework.Cloud platform is then used as framework
In cloud layer.Cloud gateway provides unified cloud platform resource interface, and cloud gateway carries out the data interaction generation for being directed to cloud platform
Interaction data is stored in database profession.For example cloud gateway can be counted with IP system, access authentication system and cloud platform itself
According to interaction.It should be noted that Fig. 1 is only a kind of example.
Specifically, the operation layer in framework can provide the related platform directly operated for user.For example self-service platform can
To be supplied to the interface of user one application cloud platform resource;Monitor supervision platform can be supplied to whole moneys of user monitoring cloud platform
The interface of source service condition;Operation platform can provide the interface for administrator's operation, and administrator can carry out host and move
The operation such as shifting.
Specifically, the cloud gateway layer in framework has the ability for the service for externally providing cloud platform.IP system can manage
The Internet resources such as IP;Access authentication system can be with right access control (RBAC, the Role- of based role
BasedAccessControl) access authentication, the certification etc. of user.Access authority of the user based on access authentication system is true
It is fixed, the operation in corresponding authority can be carried out, for example the cloud platform resource being directed toward to the permission is applied, is directed toward to the permission
Resource service condition check etc..Correspondingly, the user can be corresponding with the cloud gateway data library of permission direction.
Specifically, cloud platform can be Openstack (the cloud computing management platform of an open source in cloud layer in framework
Project), cloud platform provides IaaS service (InfrastructureasaService, infrastructure service).Certainly, Yun Ping
Platform is also possible to the platform developed based on OpenStack, which may be implemented the service of private clound or mixed cloud.
A kind of specific embodiment of the database update method based on cloud platform of the present invention introduced below, Fig. 2 are the present invention
A kind of flow diagram for database update method based on cloud platform that embodiment provides, present description provides such as embodiments
Or method operating procedure described in flow chart, but based on routine or may include more or less without creative labor
Operating procedure.The step of enumerating in embodiment sequence is only one of numerous step execution sequences mode, is not represented unique
Execute sequence.It, can be according to embodiment or method shown in the drawings when system or server product in practice executes
Sequence executes or parallel execution (such as environment of parallel processor or multiple threads).Specifically as shown in Fig. 2, described
Method may include:
S201: the interaction data generated for the data interaction of cloud platform is carried out in response to cloud gateway, generates database behaviour
Make object;
In embodiments of the present invention, cloud gateway (such as Venus) carries out the data interaction for cloud platform, by these data
The interaction data that interaction generates characterizes some business information (for example, the group that asynchronous task information, cloud platform fail offer is joint
Source information etc.).These business information needs are stored in cloud gateway data library with corresponding data type, structure.In response to institute
Stating interaction data generation database manipulation object, (database manipulation object can be fixed based on the correspondence code for carrying out data interaction
Justice), the programming idea based on object-oriented is realized convenient for subsequent step and updates cloud gateway data library with the operation format of object.
In a specific embodiment, cloud gateway layer can be the adaptation layer in a cloud platform framework, Ke Yijie
Enter various cloud platforms.The service that these cloud platforms provide is not limited to IaaS service, can also include that PaaS is serviced
(PlatformasaService, platform service) and SaaS service (SoftwareasaService, software service).These
The service of corresponding public cloud, private clound or mixed cloud may be implemented in cloud platform.As cloud gateway layer, for different rear ends
Cloud platform has the demand for carrying out data storage in cloud gateway data library with different data types, structure.
As shown in fig. 6, each cloud gateway corresponds to a cloud platform, self-service platform accesses all cloud gateways to provide money
Pipe is received in source.The service of the corresponding cloud platform of each cloud gateway and its offer, can be in the form of a computer room in self-service platform table
Sign.Each computer room may exist difference, then the corresponding cloud platform of each cloud gateway is different, cloud gateway needs to configure different numbers
According to structure to access corresponding cloud platform.Certainly, self-service platform can provide unified interface (reference can be made to Fig. 6) and come and different clouds
Gateway carries out data interaction.Cloud gateway layer can configure multibackend database driving, according to rear end access cloud platform not to
Realize different drivings.Cloud gateway data library includes at least one cloud gateway subdata base in this way, and each cloud gateway carries out
The interaction data that data interaction for target cloud platform generates is stored in corresponding cloud gateway subdata base, different cloud nets
Corresponding interaction data can be stored in climax database with different data types, structure.
It further, can be in cloud gateway and corresponding cloud for being related to the application environment of multiple cloud platforms as shown in Figure 7
Corresponding mark is set between gateway subdata base.For example, according to the corresponding interaction data of each cloud gateway and mark
Know information, generate target database operation object, the identification information is directed toward cloud gateway corresponding with the cloud gateway
Database.When carrying out the cloudy management for multiple cloud platforms, the subsequent difficulty for carrying out database update can reduce.
S202: it is corresponding to compare cloud gateway data library for the mapping relations of database structure and object model based on creation
Database object and the database manipulation object determine that pending data library object and pending data library object are corresponding
Processing information;
In embodiments of the present invention, cloud gateway data library can be directly using SQL statement operation, cloud gateway data library
Can be Mysql (Relational DBMS).As shown in figure 4, the database structure in cloud gateway data library is corresponding
The structure on right side in figure: database, tables of data, field, database include tables of data, and tables of data includes field (list item).
In a specific embodiment, database and tables of data can be mapped to object respectively, table object is included in
In the attribute of library object, the field in tables of data is the attribute of table object.For example, as shown in figure 4, the mapping relations are by holding
Row following step creation, comprising: establish first between library object (ObjectA) and cloud gateway data library (database A)
Mapping relations;The tables of data established in table object (Objecta) and cloud gateway data library (close by the second mapping between table a)
System;The attribute information of the library object (ObjectA) includes the table object (Objecta, Objectb, Objectc), described
The attribute information record of table object (such as Objectc) has field value (such as field 1, the field 2 of table c in the tables of data
With field 3).One-to-one mapping, the convenient operation shape with object are carried out with structures such as library, tables in database using object model
Business information in formula more new database can be avoided the cumbersome manual operation for writing the SQL statement based on increment, reduce
Safeguard the difficulty and cost of database.
In another specific embodiment, the mapping relations of the database structure and object model based on creation,
Compare the corresponding database object in cloud gateway data library and the database manipulation object, determines pending data library object and institute
State the corresponding processing information of pending data library object, comprising: firstly, according to the mapping relations and the cloud gateway data
Library generates cloud gateway data library corresponding cloud gateway data library object model, can refer to Fig. 4.Then, according to the cloud
The difference of database object and the database manipulation object in the object model of gateway data library, determines the pending data
Library object and the processing information.Pass through the thought of similar Object-Oriented Programming, the objectification of Base Structure, by data
Content in library is managed in a manner of object, can check database at object hierarchy (such as code operation object) in this way
And determine the demand whether database there are additions and deletions to change.
In another specific embodiment, as shown in figure 3, the database structure and object model based on creation
Mapping relations compare the corresponding database object in cloud gateway data library and the database manipulation object, determine pending data
Library object and the corresponding processing information of pending data library object, comprising:
S301: comparison other queue is created, includes being sequentially inputted according to database manipulation in the comparison other queue
At least one described database manipulation object;
Database manipulation object within a preset period of time can be enumerated, they are sequentially inputted according to database manipulation
In comparison other queue.
Aforementioned mapping relations can be used data defined in current code automatically when cloud gateway is restarted every time
Operation object database object corresponding with cloud gateway data library in library is compared, and difference is checked, to automatically update.Certainly,
It can choose not trigger and automatically update, carry out corresponding operation flow operation.
S302: with the executive mode of multi-thread concurrent, according to the database manipulation sequentially from the comparison other queue
In extract each database manipulation object;
Can be according to the multiple extraction threads of database manipulation sequence, each extraction thread from comparison other queue for taking out
A database operation object is taken, multiple extraction threads concurrently execute.
S303: according between each database manipulation object database object corresponding with cloud gateway data library
Difference, determine the corresponding pending data library object of each database manipulation object and the processing information;
Can compare database manipulation object attribute and database object attribute (such as library object attribute information,
The attribute information of table object), and then determine pending data library object and processing information.Pending data library object can be directed toward
The already present database object of current database, processing information can be the attribute for modifying the database object or deletes the data
Library object.Pending data library object can be directed toward the database object that current database is not present, and processing information can be increasing
Add the database object.
Further, database manipulation object is corresponding with the attribute data of characterization current state and characterization changes current shape
The operation information of state.It can be generated based on database manipulation object (such as code operation object) corresponding SQL statement, in cloud net
It closes and is inquired in database, the attribute data that inquiry is directed toward with the presence or absence of database manipulation object, then creation pair if it does not exist
Database, tables of data for answering etc..Can also list cloud gateway data library there is currently database, tables of data etc., inquire data
It whether there is corresponding database object in the attribute data that library operation object is directed toward, if it does not exist then not by the database object
It is determined as pending data library object.
S304: believed according to each corresponding pending data library object of database manipulation object and the processing
Breath generates the corresponding difference processing operation object of each database manipulation object;
Pending data library object is directed toward the database object that current database is not present, and processing information is to increase the data
When the object of library, difference processing operation object can correspond to ObjectA instantiation, and the example for creating an Object A corresponds to
Database and tables of data are created in cloud gateway data library;Difference processing operation object can correspond to Objecta instantiation, correspond to
Data are inserted into table a in cloud gateway data library.
Pending data library object is directed toward the already present database object of current database, and processing information is to modify the data
When the attribute of library object, difference processing operation object can correspond to the attribute of modification ObjectA or modify the category of Objecta
Property.
Pending data library object is directed toward the already present database object of current database, and processing information is to delete the data
When the object of library, example that difference processing operation object can correspond to destruction database object.For example database object is library object
When, destroy the library object, the attribute also corresponding destruction of table object and table object.
S305: creating difference object queue, includes defeated according to the database manipulation sequence in the difference object queue
The each difference processing operation object entered.
These difference processing operation objects are sequentially inputted in comparison other queue according to database manipulation.As shown in figure 5,
The corresponding operation operational instances one by one of these difference processing operation objects.It can be operated according to each and realize database
The polishing of difference.It can be raw by the difference of the information in cloud gateways and starting in inspection database manipulation object and database
At corresponding difference processing operation object, and then database is completed by differential operation and is automatically updated.
In another specific embodiment, for being related to the application environment of multiple cloud platforms, the cloud net as shown in Figure 6
Closing database includes at least one cloud gateway subdata base, and each cloud gateway carries out the data interaction for target cloud platform
The interaction data of generation is stored in the corresponding cloud gateway subdata base.The database structure and object based on creation
The mapping relations of model compare the corresponding database object in cloud gateway data library and the database manipulation object, determine wait locate
Manage database object and the corresponding processing information of pending data library object, comprising: firstly, according to each number of targets
According to the corresponding identification information of library operation object, target cloud gateway for comparing is determined from cloud gateway data library
Database;Then, the corresponding database object in the target cloud gateway data library and the target database operation object,
Determine pending data library object and the processing information.It is convenient for realizing cloudy automation number by object model in this way
According to management, and realize the automatic dilatation to cloudy platform.Cloudy platform is solved because of multibackend database driving data difference
Big more unmanageable problem.When cloudy platform needs dilatation, a new cloud gateway can be disposed, and is configured corresponding
The driving of rear end cloud platform, and then pass through the synchronous initiation of object model realization related data.
S203: pending data library object is handled according to the processing information, to update the cloud gateway
Database.
In embodiments of the present invention, pending data library object is handled and can be given birth to according to the processing information
At corresponding Object Operations, and then SQL statement is obtained, cloud gateway data library is updated by SQL statement.
In a specific embodiment, described according to the corresponding database object in cloud gateway data library and the number
According to the difference between the operation object of library, pending data library object and the processing information are determined, comprising: firstly, according to
The database manipulation sequence extracts each difference processing operation object from the difference object queue;Then, root
According to each difference processing operation object, cloud gateway data library is updated.The process of creation difference object queue can join
See above-mentioned steps S301-S305, which is not described herein again.Automatically updating for cloud gateway data library is realized based on object model, is compared
Manually-operated fallibility possibility is lower, can preferably ensure the safety of the data of storage.
The technical solution provided by above this specification embodiment is as it can be seen that this specification embodiment medium cloud gateway carries out base
In the various data interactions of cloud platform, by resulting interaction data objectification: database manipulation object.It meanwhile being correspondence
The creation of cloud gateway data library object model between mapping relations.Can it is more acurrate, securely achieve cloud gateway data library
It automatically updates, cost of labor can also be reduced while updating efficiency by improving.There may be bases in the environment of cloud platform deployment
User demand is customized the content of exploitation, and the programming idea based on object-oriented realizes automatically updating for cloud gateway data library,
Manual operation can be reduced, staff is reduced and carries out the pressure of maintenance and management, while can guarantee database update scheme
In the adaptability for facing different deployed environments.
The embodiment of the invention also provides a kind of database update device based on cloud platform, as shown in fig. 7, described device
Include:
Database manipulation object generation module 710: for produce for the data interaction of cloud platform in response to cloud gateway
Raw interaction data generates database manipulation object;
Object comparison module 720: for the mapping relations of database structure and object model based on creation, compare cloud net
The corresponding database object of database and the database manipulation object are closed, determines pending data library object and described to be processed
The corresponding processing information of database object;
Database update module 730: for being handled according to the processing information pending data library object,
To update cloud gateway data library.
In a specific embodiment, as shown in figure 8, the object comparison module 720 includes: that object model generates list
Member 721: for generating the corresponding cloud gateway in cloud gateway data library according to the mapping relations and cloud gateway data library
Database object model;Database update unit 722: for according to the database pair in the object model of cloud gateway data library
As the difference with the database manipulation object, pending data library object and the processing information are determined.
It should be noted that the apparatus and method embodiment in described device embodiment is based on same inventive concept.
The embodiment of the invention provides a kind of electronic equipment, which includes processor and memory, the memory
In be stored at least one instruction, at least a Duan Chengxu, code set or instruction set, this at least one instruction, an at least Duan Cheng
Sequence, the code set or instruction set are loaded as the processor and are executed to realize and be put down as provided by above method embodiment based on cloud
The database update method of platform.
Memory can be used for storing software program and module, and processor is stored in the software program of memory by operation
And module, thereby executing various function application and data processing.Memory can mainly include storing program area and storage number
According to area, wherein storing program area can application program needed for storage program area, function etc.;Storage data area can store basis
The equipment uses created data etc..In addition, memory may include high-speed random access memory, can also include
Nonvolatile memory, for example, at least a disk memory, flush memory device or other volatile solid-state parts.Phase
Ying Di, memory can also include Memory Controller, to provide access of the processor to memory.
The electronic equipment can be server, the embodiment of the invention also provides a kind of structural schematic diagram of server,
Referring to Fig. 9, the server 900 is used for the database update method based on cloud platform for implementing to provide in above-described embodiment.It should
Server 900 can generate bigger difference because configuration or performance are different, may include one or more central processings
Device (CentralProcessingUnits, CPU) 910 (for example, one or more processors) and memory 930, one
Or (such as one or more mass memories are set the storage medium 920 of more than one storage application program 923 or data 922
It is standby).Wherein, memory 930 and storage medium 920 can be of short duration storage or persistent storage.It is stored in the journey of storage medium 920
Sequence may include one or more modules, and each module may include to the series of instructions operation in server.More into
One step, central processing unit 910 can be set to communicate with storage medium 920, and storage medium 920 is executed on server 900
In series of instructions operation.Server 900 can also include one or more power supplys 960, one or more have
Line or radio network interface 950, one or more input/output interfaces 940, and/or, one or more operation systems
System 921, such as WindowsServerTM, MacOSXTM, UnixTM, LinuxTM, FreeBSDTM etc..
The embodiments of the present invention also provide a kind of storage medium, the storage medium may be disposed among electronic equipment with
It saves for realizing a kind of relevant at least one instruction of database update method based on cloud platform in embodiment of the method, at least
One Duan Chengxu, code set or instruction set, at least one instruction, an at least Duan Chengxu, the code set or the instruction set are by this
Reason device loads and executes the database update method based on cloud platform to realize above method embodiment offer.
Optionally, in the present embodiment, above-mentioned storage medium can be located in multiple network servers of computer network
At least one network server.Optionally, in the present embodiment, above-mentioned storage medium can include but is not limited to: USB flash disk, only
Read memory (ROM, Read-OnlyMemory), random access memory (RAM, RandomAccessMemory), movement firmly
The various media that can store program code such as disk, magnetic or disk.
It should be understood that embodiments of the present invention sequencing is for illustration only, do not represent the advantages or disadvantages of the embodiments.
And above-mentioned this specification specific embodiment is described.Other embodiments are within the scope of the appended claims.One
In a little situations, the movement recorded in detail in the claims or step can be executed according to the sequence being different from embodiment and
Still desired result may be implemented.In addition, process depicted in the drawing not necessarily requires the particular order shown or company
Continuous sequence is just able to achieve desired result.In some embodiments, multitasking and parallel processing it is also possible or
It may be advantageous.
All the embodiments in this specification are described in a progressive manner, same and similar portion between each embodiment
Dividing may refer to each other, and each embodiment focuses on the differences from other embodiments.Especially for device and
For electronic equipment embodiment, since it is substantially similar to the method embodiment, so be described relatively simple, related place referring to
The part of embodiment of the method illustrates.
Those of ordinary skill in the art will appreciate that realizing that all or part of the steps of above-described embodiment can pass through hardware
It completes, relevant hardware can also be instructed to complete by program, the program can store in a kind of computer-readable
In storage medium, storage medium mentioned above can be read-only memory, disk or CD etc..
The foregoing is merely presently preferred embodiments of the present invention, is not intended to limit the invention, it is all in spirit of the invention and
Within principle, any modification, equivalent replacement, improvement and so on be should all be included in the protection scope of the present invention.
Claims (10)
1. a kind of database update method based on cloud platform, which is characterized in that the described method includes:
The interaction data generated for the data interaction of cloud platform is carried out in response to cloud gateway, generates database manipulation object;
The mapping relations of database structure and object model based on creation compare the corresponding database object in cloud gateway data library
With the database manipulation object, pending data library object and the corresponding processing letter of pending data library object are determined
Breath;
Pending data library object is handled according to the processing information, to update cloud gateway data library.
2. the method according to claim 1, wherein the mapping relations are by executing following step creation, packet
It includes:
Establish the first mapping relations between library object and cloud gateway data library;
Establish the second mapping relations between the tables of data in table object and cloud gateway data library;
Wherein, the attribute information of the library object includes the table object, and the attribute information record of the table object has the number
According to the field value in table.
3. the method according to claim 1, wherein the database structure and object model based on creation
Mapping relations compare the corresponding database object in cloud gateway data library and the database manipulation object, determine pending data
Library object and the corresponding processing information of pending data library object, comprising:
According to the mapping relations and cloud gateway data library, cloud gateway data library corresponding cloud gateway data library is generated
Object model;
According to the difference of database object and the database manipulation object in the object model of cloud gateway data library, determine
Pending data library object and the processing information.
4. the method according to claim 1, wherein the database structure and object model based on creation
Mapping relations compare the corresponding database object in cloud gateway data library and the database manipulation object, determine pending data
Library object and the corresponding processing information of pending data library object, comprising:
Comparison other queue is created, includes at least one institute sequentially inputted according to database manipulation in the comparison other queue
State database manipulation object;
With the executive mode of multi-thread concurrent, extracted from the comparison other queue according to the database manipulation sequence every
A database manipulation object;
According to the difference between each database manipulation object database object corresponding with cloud gateway data library, really
Fixed each corresponding pending data library object of database manipulation object and the processing information;
According to each corresponding pending data library object of database manipulation object and the processing information, generate every
The corresponding difference processing operation object of a database manipulation object;
Difference object queue is created, includes each institute sequentially inputted according to the database manipulation in the difference object queue
State difference processing operation object.
5. according to the method described in claim 4, it is characterized in that, described according to the corresponding database in cloud gateway data library
Difference between object and the database manipulation object determines pending data library object and the processing information, packet
It includes:
Each difference processing operation object is extracted from the difference object queue according to the database manipulation sequence;
According to each difference processing operation object, cloud gateway data library is updated.
6. the method according to claim 1, wherein cloud gateway data library includes at least one cloud gateway
Database, the interaction data that each cloud gateway generate for the data interaction of target cloud platform are stored in corresponding institute
It states in cloud gateway subdata base:
The interaction data for carrying out generating for the data interaction of cloud platform in response to cloud gateway, generates database manipulation pair
As, comprising:
According to the corresponding interaction data of each cloud gateway and identification information, target database operation object, institute are generated
It states identification information and is directed toward the cloud gateway subdata base corresponding with the cloud gateway;
The mapping relations of the database structure and object model based on creation compare the corresponding database in cloud gateway data library
Object and the database manipulation object, determine pending data library object and the corresponding processing of pending data library object
Information, comprising:
According to the corresponding identification information of each target database operation object, determined from cloud gateway data library
Target cloud gateway subdata base for comparing;
Compare the corresponding database object in the target cloud gateway data library and the target database operation object, determine described in
Pending data library object and the processing information.
7. a kind of database update device based on cloud platform, which is characterized in that described device includes:
Database manipulation object generation module: the interaction for generate for the data interaction of cloud platform in response to cloud gateway
Data generate database manipulation object;
Object comparison module: for the mapping relations of database structure and object model based on creation, compare cloud gateway data
The corresponding database object in library and the database manipulation object, determine pending data library object and the pending data library
The corresponding processing information of object;
Database update module: for being handled according to the processing information pending data library object, to update
Cloud gateway data library.
8. device according to claim 7, which is characterized in that the object comparison module includes:
Object model generation unit: for generating the cloud gateway number according to the mapping relations and cloud gateway data library
According to library corresponding cloud gateway data library object model;
Database update unit: for according to the database object and the database in the object model of cloud gateway data library
The difference of operation object determines pending data library object and the processing information.
9. a kind of electronic equipment, which is characterized in that the electronic equipment includes processor and memory, is stored in the memory
Have at least one instruction, at least a Duan Chengxu, code set or instruction set, at least one instruction, an at least Duan Chengxu,
The code set or instruction set are loaded by the processor and are executed to realize being put down as described in claim 1-6 is any based on cloud
The database update method method of platform.
10. a kind of computer readable storage medium, which is characterized in that be stored at least one instruction, extremely in the storage medium
A few Duan Chengxu, code set or instruction set, at least one instruction, an at least Duan Chengxu, the code set or instruction
Collection is loaded by processor and is executed to realize the database update method side based on cloud platform as described in claim 1-6 is any
Method.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201910569963.6A CN110377610A (en) | 2019-06-27 | 2019-06-27 | A kind of database update method, apparatus, equipment and medium based on cloud platform |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201910569963.6A CN110377610A (en) | 2019-06-27 | 2019-06-27 | A kind of database update method, apparatus, equipment and medium based on cloud platform |
Publications (1)
Publication Number | Publication Date |
---|---|
CN110377610A true CN110377610A (en) | 2019-10-25 |
Family
ID=68251303
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201910569963.6A Pending CN110377610A (en) | 2019-06-27 | 2019-06-27 | A kind of database update method, apparatus, equipment and medium based on cloud platform |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN110377610A (en) |
Cited By (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN111125107A (en) * | 2019-12-23 | 2020-05-08 | 京东数字科技控股有限公司 | Data processing method, device, electronic equipment and medium |
CN112446037A (en) * | 2020-10-20 | 2021-03-05 | 湖南红普创新科技发展有限公司 | Data interaction method and device based on database gateway terminal and related equipment |
CN117076430A (en) * | 2023-10-09 | 2023-11-17 | 北京数语科技有限公司 | Method, system, electronic equipment and storage medium for acquiring data model through data gateway |
Citations (7)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN1190477A (en) * | 1995-07-07 | 1998-08-12 | 瓦尔数据公司 | Method and apparatus for modifying existing relational database schemas to reflect changes made in corresponding object model |
US20060085465A1 (en) * | 2004-10-15 | 2006-04-20 | Oracle International Corporation | Method(s) for updating database object metadata |
CN103970758A (en) * | 2013-01-29 | 2014-08-06 | 鸿富锦精密工业(深圳)有限公司 | Database accessing system and method |
CN106549864A (en) * | 2016-12-06 | 2017-03-29 | 上海电器科学研究院 | A kind of cloud gateway and its communication means |
US20170212924A1 (en) * | 2016-01-21 | 2017-07-27 | Salesforce.Com, Inc. | Configurable database platform for updating objects |
US20190026321A1 (en) * | 2017-07-20 | 2019-01-24 | Vmware, Inc. | Updating schema of a database |
CN109471869A (en) * | 2018-12-27 | 2019-03-15 | 山东浪潮商用系统有限公司 | A kind of method and system that local data base upgrades automatically |
-
2019
- 2019-06-27 CN CN201910569963.6A patent/CN110377610A/en active Pending
Patent Citations (7)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN1190477A (en) * | 1995-07-07 | 1998-08-12 | 瓦尔数据公司 | Method and apparatus for modifying existing relational database schemas to reflect changes made in corresponding object model |
US20060085465A1 (en) * | 2004-10-15 | 2006-04-20 | Oracle International Corporation | Method(s) for updating database object metadata |
CN103970758A (en) * | 2013-01-29 | 2014-08-06 | 鸿富锦精密工业(深圳)有限公司 | Database accessing system and method |
US20170212924A1 (en) * | 2016-01-21 | 2017-07-27 | Salesforce.Com, Inc. | Configurable database platform for updating objects |
CN106549864A (en) * | 2016-12-06 | 2017-03-29 | 上海电器科学研究院 | A kind of cloud gateway and its communication means |
US20190026321A1 (en) * | 2017-07-20 | 2019-01-24 | Vmware, Inc. | Updating schema of a database |
CN109471869A (en) * | 2018-12-27 | 2019-03-15 | 山东浪潮商用系统有限公司 | A kind of method and system that local data base upgrades automatically |
Cited By (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN111125107A (en) * | 2019-12-23 | 2020-05-08 | 京东数字科技控股有限公司 | Data processing method, device, electronic equipment and medium |
CN112446037A (en) * | 2020-10-20 | 2021-03-05 | 湖南红普创新科技发展有限公司 | Data interaction method and device based on database gateway terminal and related equipment |
CN117076430A (en) * | 2023-10-09 | 2023-11-17 | 北京数语科技有限公司 | Method, system, electronic equipment and storage medium for acquiring data model through data gateway |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US9424274B2 (en) | Management of intermediate data spills during the shuffle phase of a map-reduce job | |
US8494996B2 (en) | Creation and revision of network object graph topology for a network performance management system | |
US8972405B1 (en) | Storage resource management information modeling in a cloud processing environment | |
US9477512B2 (en) | Task-based modeling for parallel data integration | |
US9892121B2 (en) | Methods and systems to identify and use event patterns of application workflows for data management | |
CN110377610A (en) | A kind of database update method, apparatus, equipment and medium based on cloud platform | |
JP5999574B2 (en) | Database management system and computer system | |
US10366075B2 (en) | Database management system and method | |
US8868576B1 (en) | Storing files in a parallel computing system based on user-specified parser function | |
JP2017507426A (en) | Transparent discovery of semi-structured data schema | |
US10983873B1 (en) | Prioritizing electronic backup | |
GB2534374A (en) | Distributed System with accelerator-created containers | |
JP2019530121A (en) | Data integration job conversion | |
CN113590613A (en) | Data table partitioning method and device, computer equipment and storage medium | |
KR101400499B1 (en) | Apparatus and method of parallel processing of linked big data | |
García et al. | Data-intensive analysis for scientific experiments at the large scale data facility | |
CN109753245A (en) | A kind of multiple disks load balancing asynchronous read and write dispatching method and device | |
US20150178297A1 (en) | Method to Preserve Shared Blocks when Moved | |
JP2015095096A (en) | Mapreduce job execution system and mapreduce job execution method | |
US20130138683A1 (en) | Systems and methods of automatic generation and execution of database queries | |
US10296227B2 (en) | System and method for dynamic cache distribution for in-memory data grids | |
US8656410B1 (en) | Conversion of lightweight object to a heavyweight object | |
US7987210B1 (en) | System for lightweight objects | |
Liu | Corpus‐Based Japanese Reading Teaching Database Cloud Service Model | |
Shabeera et al. | A novel approach for improving data locality of mapreduce applications in cloud environment through intelligent data placement |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination |