CN109800234A - Service platform database system, upgrade method, equipment and storage medium - Google Patents
Service platform database system, upgrade method, equipment and storage medium Download PDFInfo
- Publication number
- CN109800234A CN109800234A CN201910072355.4A CN201910072355A CN109800234A CN 109800234 A CN109800234 A CN 109800234A CN 201910072355 A CN201910072355 A CN 201910072355A CN 109800234 A CN109800234 A CN 109800234A
- Authority
- CN
- China
- Prior art keywords
- data
- attribute
- platform
- core
- business
- 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
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention provides a kind of service platform database system, upgrade method, equipment and storage mediums, the Database Systems include core regional data base and with platform domain multiple platform regional data bases correspondingly, the core database is stored with the first tables of data, and the first tables of data stores the business datum of core domain；The platform domain database purchase has the second tables of data, the business datum of the corresponding platform domain of the second tables of data storage；In first tables of data and second tables of data, the record of the data of every second attribute respectively include an entity identification information and with the associated attribute value pair of the entity identification information.The decoupling between core domain business, database and platform domain business may be implemented in the present invention, and during database upgrade, core regional data base peace platform regional data base is not necessarily to fully synchronized upgrading.
Description
Technical field
The present invention relates to database management technology field more particularly to a kind of service platform database system, upgrade method,
Equipment and storage medium.
Background technique
In videoconferencing platform, it can establish multiple service-domains under core domain, core domain is correspondingly connected with a core domain
Database, such as movision database, each service-domain correspond to a set of platform domain, and each platform domain is correspondingly connected with one and puts down
Platform regional data base.Core domain business mainly has business management system and account management system, and platform domain business mainly has meeting pipe
Reason system.Core domain cooperates all platform domain business to need data to be used by business management system and account management system,
And data are distributed to corresponding platform regional data base by data distribution systems as unit of service-domain, platform domain passes through connection
Platform regional data base handles corresponding business demand.
In the case where a core domain corresponds to multiple platform domains, the relationship of database is exactly a core regional data base
Corresponding to multiple platform regional data bases.Business relations are exactly that a core domain business corresponds to multiple platform domain business.It designs in this way
Benefit be realize the unified management of data, and ensure that platform domain business do not interfere with each other with data secret, reduce
The load of platform domain business, improves system effectiveness.However, there is also some defects for this kind of mode.With the increasing of demand business
Add, each version there can be new demand, and database table field also updates therewith.It, can be to whole database in upgrading
Table structure change.If core domain database upgrade, table structure is changed, core regional data base arrives data distributing
After platform regional data base, the inquiry for the platform regional data base not upgraded and reading order can not be compatible with new table structure, thus
The collapse that will lead to platform regional data base is not available.
If set of environmental there are many platform domains, multiple platform regional data bases are just had, are carrying out upgrading service
During just need to upgrade core domain and all platform domain business in the same time.Namely all core regional data bases
Upgrading synchronous with platform regional data base needs.Platform domain, and the user being related to is certainly more, also more complicated, if arranging institute
Some platform domains need very big multi-party communication cost, bring to user very big all if the same time is upgraded
It is inconvenient.
MySQL database master-slave back-up is a kind of database synchronization technology, based on master (host) all pairs of data
Update, the deletion in library etc. are recorded in binary log, host can go creation one thread come the content of log be sent to from
On machine, a copy of this operation is performed on each slave.Data are realized by the active and standby mechanism of database in the prior art
Synchronize that there are some problems: the emphasis of active and standby mechanism is the backup of database, can not individually be handled for business, can
Scalability is poor；Table structure cannot be changed, and the table structure of synchronous both sides must be consistent.
Summary of the invention
For the problems of the prior art, the purpose of the present invention is to provide a kind of service platform database systems, upgrading
The decoupling between core domain business, database and platform domain business may be implemented, in database in method, equipment and storage medium
In escalation process, core regional data base peace platform regional data base is not necessarily to fully synchronized upgrading.
The embodiment of the present invention provides a kind of service platform database system, for the business datum of storage service platform, institute
Stating business platform includes core domain and multiple platform domains, and the business datum includes the data of the first attribute and the number of the second attribute
According to first attribute does not change with the business change of the business platform, and second attribute is with the business platform
Business change and change；
The Database Systems include core regional data base and with the platform domain multiple platform domain numbers correspondingly
According to library, the core database is stored with the first tables of data, and first tables of data stores the business datum of the core domain；Institute
Stating platform domain database purchase has the second tables of data, the business datum of the corresponding platform domain of the second tables of data storage；
In first tables of data and second tables of data, the record of the data of every second attribute is respectively included
One entity identification information and with the associated attribute value pair of the entity identification information.
Optionally, when the core regional data base executes upgrading task, the variation for caused second attribute during upgrading,
The record of the data of second attribute corresponding to the second attribute change of the core domain database root according to variation.
Optionally, when the platform regional data base receives the data inquiry request of the platform domain, according to the data
Entity identification information and attribute in inquiry request transfer the record of corresponding data, and query result is sent to described put down
Platform domain.
Optionally, first tables of data includes the first main table and the first subtabulation, and second tables of data includes second main
Table and the second subtabulation, the first main table and the second main table are used to store the data of first attribute, and described first is secondary
Table and second subtabulation are used to store the data of second attribute.
Optionally, in the described first main table and the second main table, the record of the data of every first attribute includes
One entity identification information and attribute value pair with all first attributes associated by the entity identification information.
Optionally, when the new business datum of the core domain database purchase, according to the attribute type of new business datum
The data of first attribute are stored in the described first main table, the data of the second attribute are stored in first subtabulation.
Optionally, the core regional data base is also used to that institute will be issued to respectively with the associated business datum of the platform domain
Corresponding platform regional data base；
After the platform regional data base is also used to receive the business datum that the core regional data base issues, according to described
The data of first attribute are stored in the described second main table by the attribute type of business datum, and the data of the second attribute are stored in institute
State the second subtabulation.
The embodiment of the present invention also provides a kind of service platform database method for upgrading system, for the business platform number
According to the upgrading of library system, described method includes following steps:
The core regional data base executes upgrading task；
The core regional data base judges the change type of changed second attribute in escalation process；
The second attribute if there is a change is newly added second attribute, then the core regional data base is described first
The record of the data of the second newly-increased attribute is added in tables of data, the record of the data of every second attribute of addition includes one
Identification information, the second newly-increased attribute and entity of the involved entity of this upgrading it is corresponding in this newly-increased second
The attribute value of attribute；
The second deleted attribute when the second attribute if there is a change, then the core regional data base is described first
The record deletion of data corresponding to the second attribute in tables of data by deletion.
The embodiment of the present invention also provides a kind of service platform database system upgrade equipment, comprising:
Processor；
Memory, wherein being stored with the executable instruction of the processor；
Wherein, the processor is configured to execute the business platform upgrading side via the executable instruction is executed
The step of method.
The embodiment of the present invention also provides a kind of computer readable storage medium, and for storing program, described program is performed
Described in Shi Shixian the step of service platform database method for upgrading system.
Service platform database system, upgrade method, equipment and storage medium provided by the present invention have the advantage that
The present invention solves in the prior art that core domain upgrading service causes platform domain data nonbalance, leads to platform domain industry
The problem of business is collapsed and must be upgraded to cooperate core domain business, may be implemented core domain business, database and platform domain
Decoupling between business, the upgrading of core domain business will not influence the variation of database structure, and data structure does not change
The normal realization of platform domain business would not be influenced, thus realize that database is upward-compatible, during database upgrade, core
Regional data base and platform regional data base are not necessarily to fully synchronized upgrading, reduce communication cost when database upgrade, and promoting user makes
With experience.
Detailed description of the invention
Upon reading the detailed description of non-limiting embodiments with reference to the following drawings, other feature of the invention,
Objects and advantages will become more apparent upon.
Fig. 1 is the structural schematic diagram of the service platform database system of one embodiment of the invention；
Fig. 2 is the timing diagram of data synchronization mechanism in the service platform database system of one embodiment of the invention；
Fig. 3 is the flow chart of the service platform database upgrade method of one embodiment of the invention；
Fig. 4 is the structural schematic diagram of the business platform updating apparatus of one embodiment of the invention；
Fig. 5 is the structural schematic diagram of the computer storage medium of one embodiment of the invention.
Specific embodiment
Example embodiment is described more fully with reference to the drawings.However, example embodiment can be with a variety of shapes
Formula is implemented, and is not understood as limited to embodiment set forth herein；On the contrary, thesing embodiments are provided so that the present invention will
Fully and completely, and by the design of example embodiment comprehensively it is communicated to those skilled in the art.It is identical attached in figure
Icon note indicates same or similar structure, thus will omit repetition thereof.
The technical issues of in order to solve in the prior art, the embodiment of the present invention provide a kind of service platform database system,
Business datum for storage service platform.As shown in Figure 1, for service platform database system and industry in the embodiment of the present invention
The schematic diagram of business platform cooperation.
The business platform includes core domain A100 and multiple platform domain A200, and the business datum includes the first attribute
The data of data and the second attribute, first attribute do not change with the business change of the business platform, and described second belongs to
Property changes with the business change of the business platform.
The Database Systems include core regional data base M100 and multiple correspondingly with the platform domain A200
Platform regional data base M200, the core database M100 are stored with the first tables of data, and first tables of data stores the core
The business datum in heart domain；The platform regional data base M200 is stored with the second tables of data, corresponding to the second tables of data storage
Platform domain business datum.
In first tables of data and second tables of data, the record of the data of every second attribute is respectively included
One entity identification information and with the associated attribute value pair of the entity identification information.Entity can be specific user,
It is also possible to platform domain, is also possible to service-domain etc..Entity identification information is the unique identification for identifying entity identities, such as with
Family ID, platform domain ID etc..
First attribute is the attribute not changed with the business change of business platform, such as when name on account, password, creation
Between etc..Second attribute is then the attribute that can change with the business change of business platform, such as various different types of permissions
Configuration data, a kind of permission can be a kind of attribute, or the other kinds of attribute for increasing or deleting with business change.
The storage of the data of second attribute is stored by the way of key_value (attribute to), the number of the second attribute
According to every record include an entity identification information, second attribute and the entity corresponding in the attribute of second attribute
Value.For example, a record includes:
id VARCHAR(36)
s_key VARCHAR(50)
s_value TEXT
Only include VARCHAR (50) this second attribute and corresponding attribute value i.e. in the record, is for id
Other second attributes of VARCHAR (36) then re-establish a record, such as: id VARCHAR (36), s_key
VARCHAR (80), s_value TEXT, even for the same entity ID, the second different attributes also belongs to different notes
Record.When deleting a record, other data records are not interfered with, when increasing a record newly, it will not be influenced
His data record.Other data records still can normally be stored in, inquire and read.
Therefore, by using this kind of mode, the solution between core domain business, database and platform domain business may be implemented
Coupling, the upgrading of core domain business will not influence the variation of database structure, and data structure, which does not change, would not also influence to put down
The normal realization of platform domain business, to realize that database is upward-compatible.
In this embodiment, when the core regional data base executes upgrading task, for caused second attribute during upgrading
Variation, the core domain database root according to the data of the second corresponding attribute of the second attribute change of variation record.Tool
Body, first determines whether the change type of the second attribute, if it is newly-increased second attribute, then adds in the first tables of data newly-increased
The record of the data of second attribute, the record of the data of every second attribute of addition include the involved reality of this upgrading
The identification information of body, the second newly-increased attribute and the entity are corresponding in the attribute value of the second newly-increased attribute；If it is
The second attribute is deleted, then the record deletion of data corresponding to the second attribute in the first tables of data by deletion.
Due in the record of every data of the second attribute only include an attribute value pair, and each attribute value to
Entity identification information is associated, easily can inquire and read, and the record of the data of every second attribute and other
The record of the data of second attribute is mutually independent.Therefore, when deleting a record, other data notes are not interfered with
Record will not influence other data records when increasing a record newly.Other data records still can be deposited normally
Enter, inquire and reads.When core regional data base carries out data upgrading, without being changed to table structure, core regional data base
After data distributing to platform regional data base, even if platform regional data base does not upgrade, with normal queries and number can also be read
According to.
In this embodiment, first tables of data includes the first main table and the first subtabulation, and second tables of data includes
Second main table and the second subtabulation, the first main table and the second main table are used to store the data of first attribute, described
First subtabulation and second subtabulation are used to store the data of second attribute.Using real between first main table and the first subtabulation
Body identification information carries out external key association.A note in corresponding first subtabulation of an attribute in a record in first main table
Record.Such table structure had not only had to the data structure of change table simultaneously but also had farthest met wanting for configuration variance
It asks, the allocation problem of different demands under complex scene can be well solved.In first subtabulation and second subtabulation, often
The record of the data of second attribute described in item respectively includes entity identification information and associated with the entity identification information
One attribute value pair.The embodiment is by separately storing the data of the first attribute and the data of the second attribute, Ke Yibao
The stability for demonstrate,proving the data of the first attribute avoids the data of the first attribute from changing during database upgrade.Due to
The data of one attribute will not change during database upgrade, therefore, the first main table and the second main table
In, the record of the data of every first attribute can be still by the way of former data storage, i.e. every first attribute
Data record may include an entity identification information and with all first attributes associated by the entity identification information
Attribute value pair.
It the following is in the embodiment, the storage form of the record of the data of every first attribute:
id VARCHAR(36)
account VARCHAR(128)
password VARCHAR(32)
created_at TIMEST AMP
It include entity ID, account name attribute, cryptographic properties and wound in the record of the data of first attribute
Build time attribute.The data store organisation of however, the present invention is not limited thereto, the first main table and the second main table can also be secondary using first
The data store organisation of table and the second subtabulation, i.e., each second attribute belong to different data records.
In this embodiment, when the new business datum of the core domain database purchase, according to the category of new business datum
The data of first attribute are stored in the described first main table, the data of the second attribute are stored in first subtabulation by property type.
Specifically, can by the code of core domain and core regional data base in existing business platform be reconstructed come
It realizes.A main table is only stored in existing core regional data base, the original of core domain configuration data storing data library patrols
It collects substantially are as follows: entity class → service data visitation layer → main table.It, can be by the field category in entity class after carrying out code refactoring
Property explain by way of divide into two classes, one kind is the underlying attribute in entity class, and one kind is the secondary attribute in entity class.
The underlying attribute i.e. the first attribute, i.e., the attribute that will not be changed with business, the secondary attribute i.e. the second attribute that is, can be with
Business demand changes and the attribute that changes at any time.Code data access layer can realize reconstruct by way of explaining and reflecting.
The logic in the core domain configuration data storing data library after reconstruct is substantially are as follows: entity class (primary attribute, secondary attribute) → note, reflection
→ service data visitation layer (main table SQL, subtabulation SQL) → main table, subtabulation.The code refactoring of operation layer, realizes to same
The data of class carry out a point table management, and the data of core configuration of territory is allowed to more easily discriminate and manage.
In this embodiment, the core regional data base be also used to by with the associated business datum of the platform domain respectively under
It is sent to corresponding platform regional data base；The platform regional data base is also used to receive the industry that the core regional data base issues
After data of being engaged in, according to the attribute type of the business datum, the data of the first attribute are stored in the described second main table, by second
Attribute is stored in second subtabulation.
In this embodiment, first tables of data and second tables of data are with the form storage described second of row record
The data of attribute, in first tables of data and second tables of data, the record row point of the data of every second attribute
Not Bao Kuo an entity identification information and with the associated attribute value pair of the entity identification information.
As shown in Fig. 2, for the timing diagram of one of embodiment data synchronization mechanism.Core domain stores data first
Into core regional data base, core regional data base will need the data issued to be sent to message-oriented middleware, and message-oriented middleware passes through
Data distributing system is issued to corresponding platform regional data base.Platform domain can be transferred corresponding by way of data query
Data in platform regional data base, different, the different platform of the configuration information recorded during using data due to every
Domain business institute information to be used is also inconsistent.
In existing platform regional data base, when platform domain inquires data, by the limit of data store organisation in platform domain
System, all properties data of corresponding entity can be read out, will cause the waste of resource.In this embodiment, it needs
Integration processing is carried out to platform domain business, the configuration information that oneself wants only is obtained between different business, other are not made
Configuration information does not go then to obtain, i.e., only obtains the part used in oneself.Therefore, the platform regional data base receives described
When the data inquiry request of platform domain, according in the data inquiry request entity identification information and attribute transfer it is corresponding
The record of data, and query result is sent to the platform domain.Therefore, when transferring the record of corresponding data, it is only necessary to
The record for transferring the data for the second attribute that inquiry is directed toward, without by other incoherent numbers for belonging to the same entity
According to reading out.Being integrated with for platform domain business is conducive to that each configuration item is played to the work of own using data well
With not interfereing with each other between configuration and data list structure be steady due to being travelled between every record using the configuration of row record
It is fixed constant, the complicated coupling relationship between core domain business, database and platform domain business is decoupled well, and
The normal realization of platform domain business is not influenced.
In addition, the present invention, which carries out configuration data by the transverse design mode of database, can cope with the demand of various complexity
Scene, but data that can be different to same type carry out differentiation configuration, avoid unwanted configuration, utilize in maximum efficiency
The data that are configured.
As shown in figure 3, the embodiment of the present invention also provides a kind of service platform database method for upgrading system, for described
The upgrading of service platform database system, described method includes following steps:
S100: the core regional data base executes upgrading task；
S200: the core regional data base judges the change type of changed second attribute in escalation process；
S300: the second attribute if there is a change is newly added second attribute, then the core regional data base is in institute
State the record that the data of the second newly-increased attribute are added in the first tables of data, the record packet of the data of every second attribute of addition
Identification information, the second newly-increased attribute and the entity for including an involved entity of this upgrading are corresponding newly-increased in this
The second attribute attribute value；
S400: the second deleted attribute when the second attribute if there is a change, then the core regional data base is in institute
State the record deletion of data corresponding to the second attribute in the first tables of data by deletion.
In this embodiment, due to only including an attribute value pair in the record of every data of the second attribute, and it is every
A attribute value easily can be inquired and be read, and the number of every second attribute to all associated with entity identification information
According to record and the data of other the second attributes record it is mutually independent.Therefore, it when deleting a record, does not interfere with
Other data records will not influence other data records when increasing a record newly.Other data records are still
It can normally be stored in, inquire and read.When core regional data base carries out data upgrading, without being changed to table structure, core
Heart regional data base, even if platform regional data base does not upgrade, can also be looked into after data distributing to platform regional data base normally
Ask and read data.
Therefore, the present invention solves the multi-platform collective's upgrade problem of a core in the prior art, directly reduces core
Coupled relation between platform, so that core domain business can gradually be upgraded with standalone upgrade, platform domain business.
The embodiment of the present invention also provides a kind of service platform database system upgrade equipment, including processor；Memory,
In be stored with the executable instruction of the processor；Wherein, the processor is configured to next via the executable instruction is executed
The step of executing the business platform upgrade method.
Person of ordinary skill in the field it is understood that various aspects of the invention can be implemented as system, method or
Program product.Therefore, various aspects of the invention can be embodied in the following forms, it may be assumed that complete hardware embodiment, complete
The embodiment combined in terms of full Software Implementation (including firmware, microcode etc.) or hardware and software, can unite here
Referred to as circuit, " module " or " system ".
The electronic equipment 600 of this embodiment according to the present invention is described referring to Fig. 4.The electronics that Fig. 4 is shown
Equipment 600 is only an example, should not function to the embodiment of the present invention and use scope bring any restrictions.
As shown in figure 4, electronic equipment 600 is showed in the form of universal computing device.The component of electronic equipment 600 can wrap
It includes but is not limited to: at least one processing unit 610, at least one storage unit 620, (including the storage of the different system components of connection
Unit 620 and processing unit 610) bus 630, display unit 640 etc..
Wherein, the storage unit is stored with program code, and said program code can be held by the processing unit 610
Row, so that the processing unit 610 executes described in this specification above-mentioned electronic prescription circulation processing method part according to this
The step of inventing various illustrative embodiments.For example, the processing unit 610 can execute step as shown in fig. 1.
The storage unit 620 may include the readable medium of volatile memory cell form, such as random access memory
Unit (RAM) 6201 and/or cache memory unit 6202 can further include read-only memory unit (ROM) 6203.
The storage unit 620 can also include program/practical work with one group of (at least one) program module 6205
Tool 6204, such program module 6205 includes but is not limited to: operating system, one or more application program, other programs
It may include the realization of network environment in module and program data, each of these examples or certain combination.
Bus 630 can be to indicate one of a few class bus structures or a variety of, including storage unit bus or storage
Cell controller, peripheral bus, graphics acceleration port, processing unit use any bus structures in a variety of bus structures
Local bus.
Electronic equipment 600 can also be with one or more external equipments 700 (such as keyboard, sensing equipment, bluetooth equipment
Deng) communication, can also be enabled a user to one or more equipment interact with the electronic equipment 600 communicate, and/or with make
Any equipment (such as the router, modulation /demodulation that the electronic equipment 600 can be communicated with one or more of the other calculating equipment
Device etc.) communication.This communication can be carried out by input/output (I/O) interface 650.Also, electronic equipment 600 can be with
By network adapter 660 and one or more network (such as local area network (LAN), wide area network (WAN) and/or public network,
Such as internet) communication.Network adapter 660 can be communicated by bus 630 with other modules of electronic equipment 600.It should
Understand, although not shown in the drawings, other hardware and/or software module can be used in conjunction with electronic equipment 600, including but unlimited
In: microcode, device driver, redundant processing unit, external disk drive array, RAID system, tape drive and number
According to backup storage system etc..
The embodiment of the present invention also provides a kind of computer readable storage medium, and for storing program, described program is performed
Described in Shi Shixian the step of service platform database method for upgrading system.In some possible embodiments, of the invention
Various aspects are also implemented as a kind of form of program product comprising program code, when described program product is set in terminal
When standby upper operation, said program code is for making the terminal device execute the above-mentioned electronic prescription circulation processing method of this specification
Described in part according to the present invention various illustrative embodiments the step of.
Refering to what is shown in Fig. 5, describing the program product for realizing the above method of embodiment according to the present invention
800, can using portable compact disc read only memory (CD-ROM) and including program code, and can in terminal device,
Such as it is run on PC.However, program product of the invention is without being limited thereto, in this document, readable storage medium storing program for executing can be with
To be any include or the tangible medium of storage program, the program can be commanded execution system, device or device use or
It is in connection.
Described program product can be using any combination of one or more readable mediums.Readable medium can be readable letter
Number medium or readable storage medium storing program for executing.Readable storage medium storing program for executing for example can be but be not limited to electricity, magnetic, optical, electromagnetic, infrared ray or
System, device or the device of semiconductor, or any above combination.The more specific example of readable storage medium storing program for executing is (non exhaustive
List) include: electrical connection with one or more conducting wires, portable disc, hard disk, random access memory (RAM), read-only
Memory (ROM), erasable programmable read only memory (EPROM or flash memory), optical fiber, portable compact disc read only memory
(CD-ROM), light storage device, magnetic memory device or above-mentioned any appropriate combination.
The computer readable storage medium may include in a base band or the data as the propagation of carrier wave a part are believed
Number, wherein carrying readable program code.The data-signal of this propagation can take various forms, including but not limited to electromagnetism
Signal, optical signal or above-mentioned any appropriate combination.Readable storage medium storing program for executing can also be any other than readable storage medium storing program for executing
Readable medium, the readable medium can send, propagate or transmit for by instruction execution system, device or device use or
Person's program in connection.The program code for including on readable storage medium storing program for executing can transmit with any suitable medium, packet
Include but be not limited to wireless, wired, optical cable, RF etc. or above-mentioned any appropriate combination.
The program for executing operation of the present invention can be write with any combination of one or more programming languages
Code, described program design language include object oriented program language-Java, C++ etc., further include conventional
Procedural programming language-such as " C " language or similar programming language.Program code can be fully in user
It calculates and executes in equipment, partly executes on a user device, being executed as an independent software package, partially in user's calculating
Upper side point is executed on a remote computing or is executed in remote computing device or server completely.It is being related to far
Journey calculates in the situation of equipment, and remote computing device can pass through the network of any kind, including local area network (LAN) or wide area network
(WAN), it is connected to user calculating equipment, or, it may be connected to external computing device (such as utilize ISP
To be connected by internet).
In conclusion compared with prior art, service platform database system provided by the present invention, is set upgrade method
Standby and storage medium has the advantage that
The present invention solves in the prior art that core domain upgrading service causes platform domain data nonbalance, leads to platform domain industry
The problem of business is collapsed and must be upgraded to cooperate core domain business, may be implemented core domain business, database and platform domain
Decoupling between business, the upgrading of core domain business will not influence the variation of database structure, and data structure does not change
The normal realization of platform domain business would not be influenced, thus realize that database is upward-compatible, during database upgrade, core
Regional data base and platform regional data base are not necessarily to fully synchronized upgrading, reduce communication cost when database upgrade, and promoting user makes
With experience.
The above content is a further detailed description of the present invention in conjunction with specific preferred embodiments, and it cannot be said that
Specific implementation of the invention is only limited to these instructions.For those of ordinary skill in the art to which the present invention belongs, exist
Under the premise of not departing from present inventive concept, a number of simple deductions or replacements can also be made, all shall be regarded as belonging to of the invention
Protection scope.
Claims (10)
1. a kind of service platform database system, which is characterized in that for the business datum of storage service platform, the business is flat
Platform includes core domain and multiple platform domains, and the business datum includes the data of the first attribute and the data of the second attribute, described
First attribute does not change with the business change of the business platform, second attribute with the business platform business change
And change；
The Database Systems include core regional data base and with the platform domain multiple platform regional data bases correspondingly,
The core database is stored with the first tables of data, and first tables of data stores the business datum of the core domain；It is described flat
Platform regional data base is stored with the second tables of data, the business datum of the corresponding platform domain of the second tables of data storage；
In first tables of data and second tables of data, the record of the data of every second attribute respectively includes one
Entity identification information and with the associated attribute value pair of the entity identification information.
2. service platform database system according to claim 1, which is characterized in that the core regional data base executes liter
When grade task, the variation for caused second attribute during upgrading, the core domain database root becomes according to the second attribute of variation
The record of the data of the second more corresponding attribute.
3. service platform database system according to claim 1, which is characterized in that the platform regional data base receives
When the data inquiry request of the platform domain, according in the data inquiry request entity identification information and attribute transfer pair
The record for the data answered, and query result is sent to the platform domain.
4. service platform database system according to claim 1, which is characterized in that first tables of data includes first
Main table and the first subtabulation, second tables of data include the second main table and the second subtabulation, the first main table and second master
Table is used to store the data of first attribute, first subtabulation and second subtabulation for storing second attribute
Data.
5. service platform database system according to claim 4, which is characterized in that the first main table and described second
In main table, the records of the data of every first attribute include an entity identification information and with the entity identification information institute
The attribute value pair of associated all first attributes.
6. service platform database system according to claim 4, which is characterized in that the core domain database purchase is new
Business datum when, the data of the first attribute are stored in by the described first main table according to the attribute type of new business datum, will
The data of second attribute are stored in first subtabulation.
7. service platform database system according to claim 4, which is characterized in that the core regional data base is also used to
Corresponding platform regional data base will be issued to respectively with the associated business datum of the platform domain；
After the platform regional data base is also used to receive the business datum that the core regional data base issues, according to the business
The data of first attribute are stored in the described second main table by the attribute type of data, and the data of the second attribute are stored in described
Two subtabulations.
8. a kind of service platform database method for upgrading system, which is characterized in that for described in any one of claims 1 to 7
Service platform database system upgrading, described method includes following steps:
The core regional data base executes upgrading task；
The core regional data base judges the change type of changed second attribute in escalation process；
The second attribute if there is a change is newly added second attribute, then the core regional data base is in first data
Add the record of the data of the second newly-increased attribute in table, the record of the data of every second attribute of addition include one this
Identification information, the second newly-increased attribute and entity of the involved entity of upgrading are corresponding in the second newly-increased attribute
Attribute value；
The second deleted attribute when the second attribute if there is a change, then the core regional data base is in first data
The record deletion of data corresponding to the second attribute in table by deletion.
9. a kind of service platform database system upgrade equipment characterized by comprising
Processor；
Memory, wherein being stored with the executable instruction of the processor；
Wherein, the processor is configured to carry out business platform described in perform claim requirement 8 via the execution executable instruction
The step of upgrade method.
10. a kind of computer readable storage medium, for storing program, which is characterized in that described program is performed realization power
Benefit require 8 described in service platform database method for upgrading system the step of.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910072355.4A CN109800234A (en) | 2019-01-25 | 2019-01-25 | Service platform database system, upgrade method, equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910072355.4A CN109800234A (en) | 2019-01-25 | 2019-01-25 | Service platform database system, upgrade method, equipment and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN109800234A true CN109800234A (en) | 2019-05-24 |
Family
ID=66560326
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910072355.4A Pending CN109800234A (en) | 2019-01-25 | 2019-01-25 | Service platform database system, upgrade method, equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109800234A (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111221551A (en) * | 2019-10-29 | 2020-06-02 | 中盈优创资讯科技有限公司 | Database upgrading method and device |
| CN111538774A (en) * | 2020-04-23 | 2020-08-14 | 上海携程商务有限公司 | Data storage and display method, system, equipment and storage medium |
| CN114116842A (en) * | 2021-11-25 | 2022-03-01 | 上海柯林布瑞信息技术有限公司 | Multi-dimensional medical data real-time acquisition method and device, electronic equipment and storage medium |
| CN115080094A (en) * | 2022-08-16 | 2022-09-20 | 张家港金典软件有限公司 | Security system updating method and system based on hierarchical interaction |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1877573A (en) * | 2005-06-10 | 2006-12-13 | 华夏科技股份有限公司 | Multilayer database system structure |
| CN102200977A (en) * | 2010-03-23 | 2011-09-28 | 国际商业机器公司 | Method and system for extending database table under multi-tenant environment |
| CN103559301A (en) * | 2013-11-14 | 2014-02-05 | 华为技术有限公司 | Method of data update, database trigger and SE (search engine) |
| CN105912597A (en) * | 2016-03-31 | 2016-08-31 | 华南师范大学 | Method for storing structural data of tenants in multi-tenant database |
| US20170147664A1 (en) * | 2015-11-19 | 2017-05-25 | Oracle International Corporation | In-memory key-value store for a multi-model database |
| CN107515933A (en) * | 2017-08-29 | 2017-12-26 | 平安科技（深圳）有限公司 | Change method, server, system and the storage medium of source data database table structure |
| CN107967279A (en) * | 2016-10-19 | 2018-04-27 | 北京国双科技有限公司 | The data-updating method and device of distributed data base |
-
2019
- 2019-01-25 CN CN201910072355.4A patent/CN109800234A/en active Pending
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1877573A (en) * | 2005-06-10 | 2006-12-13 | 华夏科技股份有限公司 | Multilayer database system structure |
| CN102200977A (en) * | 2010-03-23 | 2011-09-28 | 国际商业机器公司 | Method and system for extending database table under multi-tenant environment |
| CN103559301A (en) * | 2013-11-14 | 2014-02-05 | 华为技术有限公司 | Method of data update, database trigger and SE (search engine) |
| US20170147664A1 (en) * | 2015-11-19 | 2017-05-25 | Oracle International Corporation | In-memory key-value store for a multi-model database |
| CN105912597A (en) * | 2016-03-31 | 2016-08-31 | 华南师范大学 | Method for storing structural data of tenants in multi-tenant database |
| CN107967279A (en) * | 2016-10-19 | 2018-04-27 | 北京国双科技有限公司 | The data-updating method and device of distributed data base |
| CN107515933A (en) * | 2017-08-29 | 2017-12-26 | 平安科技（深圳）有限公司 | Change method, server, system and the storage medium of source data database table structure |
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111221551A (en) * | 2019-10-29 | 2020-06-02 | 中盈优创资讯科技有限公司 | Database upgrading method and device |
| CN111221551B (en) * | 2019-10-29 | 2023-10-31 | 中盈优创资讯科技有限公司 | Database upgrading method and device |
| CN111538774A (en) * | 2020-04-23 | 2020-08-14 | 上海携程商务有限公司 | Data storage and display method, system, equipment and storage medium |
| CN111538774B (en) * | 2020-04-23 | 2023-04-18 | 上海携程商务有限公司 | Data storage and display method, system, equipment and storage medium |
| CN114116842A (en) * | 2021-11-25 | 2022-03-01 | 上海柯林布瑞信息技术有限公司 | Multi-dimensional medical data real-time acquisition method and device, electronic equipment and storage medium |
| CN114116842B (en) * | 2021-11-25 | 2023-05-19 | 上海柯林布瑞信息技术有限公司 | Multidimensional medical data real-time acquisition method and device, electronic equipment and storage medium |
| CN115080094A (en) * | 2022-08-16 | 2022-09-20 | 张家港金典软件有限公司 | Security system updating method and system based on hierarchical interaction |
| CN115080094B (en) * | 2022-08-16 | 2022-11-29 | 张家港金典软件有限公司 | Security system updating method and system based on hierarchical interaction |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10673932B2 (en) | System and method for abstraction of objects for cross virtual universe deployment | |
| CN109800234A (en) | Service platform database system, upgrade method, equipment and storage medium | |
| CN104160381A (en) | Managing tenant-specific data sets in a multi-tenant environment | |
| US9251163B2 (en) | File sharing system and file sharing method | |
| CN109582441A (en) | For providing system, the method and apparatus of container service | |
| CN109906448A (en) | Promote the operation on pluggable database using individual logical time stamp service | |
| CN108475271A (en) | The application container of container database | |
| JP3853387B2 (en) | Data access right management method in data independent computer system | |
| CN109947767A (en) | System in multiple lease database system shares type | |
| CN101183379A (en) | Attribute level federation from multiple data sources | |
| BRPI0609334A2 (en) | data management for mobile data system | |
| CN104866513A (en) | System and method for cross-tenant data access | |
| CN103019718A (en) | Use of distributed source control in centralized source control environment | |
| US20080104008A1 (en) | Common data broker method, system, and program product | |
| CN105283847A (en) | Local store data versioning | |
| US11226982B2 (en) | Synchronization of offline instances | |
| WO2008068114A1 (en) | Workflow processing system and method with federated database system support | |
| CN112948861A (en) | Metadata authority management method and device based on microservice | |
| CN110334545A (en) | A kind of authority control method based on SQL, device and electronic equipment | |
| CN111178849A (en) | Linear process engine implementation method, device, equipment and storage medium | |
| CN112115203A (en) | Asset management method, device, equipment and storage medium of cloud platform | |
| CN105550342B (en) | A kind of data processing method of the distributed data base of all-transparent | |
| US11704327B2 (en) | Querying distributed databases | |
| Bienko et al. | IBM cloudant: database as a service advanced topics | |
| JP2023534656A (en) | Archiving of accelerator-only database tables |
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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20190524 |
|
| RJ01 | Rejection of invention patent application after publication |