CN111522869A - Setting computing cloud data management method and setting computing system suitable for multiple tenants - Google Patents
Setting computing cloud data management method and setting computing system suitable for multiple tenants Download PDFInfo
- Publication number
- CN111522869A CN111522869A CN202010225549.6A CN202010225549A CN111522869A CN 111522869 A CN111522869 A CN 111522869A CN 202010225549 A CN202010225549 A CN 202010225549A CN 111522869 A CN111522869 A CN 111522869A
- Authority
- CN
- China
- Prior art keywords
- tenant
- data
- tenants
- database
- public
- 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 48
- 238000013523 data management Methods 0.000 title claims abstract description 41
- 238000004364 calculation method Methods 0.000 claims abstract description 50
- 238000007726 management method Methods 0.000 claims abstract description 20
- 230000008569 process Effects 0.000 claims abstract description 10
- 230000006870 function Effects 0.000 claims description 15
- 238000004590 computer program Methods 0.000 claims description 6
- 238000012986 modification Methods 0.000 claims description 4
- 230000004048 modification Effects 0.000 claims description 4
- 238000007792 addition Methods 0.000 claims description 3
- 238000012217 deletion Methods 0.000 claims description 3
- 230000037430 deletion Effects 0.000 claims description 3
- 238000011161 development Methods 0.000 claims description 3
- 230000008571 general function Effects 0.000 claims description 3
- 238000002955 isolation Methods 0.000 description 6
- 238000013461 design Methods 0.000 description 5
- 238000010586 diagram Methods 0.000 description 2
- 238000012423 maintenance Methods 0.000 description 2
- 238000000926 separation method Methods 0.000 description 2
- 230000004075 alteration Effects 0.000 description 1
- 238000004458 analytical method Methods 0.000 description 1
- 238000013499 data model Methods 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 230000010354 integration Effects 0.000 description 1
- 230000008520 organization Effects 0.000 description 1
- 238000012545 processing Methods 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
Images
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/25—Integrating or interfacing systems involving database management systems
- G06F16/254—Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
-
- 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/22—Indexing; Data structures therefor; Storage structures
-
- 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
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F21/00—Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
- G06F21/60—Protecting data
- G06F21/62—Protecting access to data via a platform, e.g. using keys or access control rules
- G06F21/6218—Protecting access to data via a platform, e.g. using keys or access control rules to a system of files or objects, e.g. local or distributed file system or database
- G06F21/6227—Protecting access to data via a platform, e.g. using keys or access control rules to a system of files or objects, e.g. local or distributed file system or database where protection concerns the structure of data, e.g. records, types, queries
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- General Physics & Mathematics (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Software Systems (AREA)
- Computing Systems (AREA)
- Health & Medical Sciences (AREA)
- Bioethics (AREA)
- General Health & Medical Sciences (AREA)
- Computer Hardware Design (AREA)
- Computer Security & Cryptography (AREA)
- Storage Device Security (AREA)
Abstract
The invention discloses a setting calculation cloud data management method suitable for multiple tenants, which comprises the following steps: creating a tenant table; extracting public data parts of each level of power grid tenants as public databases, and creating public tenant table data to form shared databases; the method comprises the steps that differentiated data portions of all tenants serve as independent databases, the tenants in the independent databases are selected, and virtual tenant tables are created according to tenant IDs, wherein the virtual tenant tables comprise primary model tables, protection device tables, setting process tables, constant value single data tables, calculation book management data tables and system data management data tables; and isolating the data in the independent database according to the tenant ID. Therefore, the full utilization of system resources can be guaranteed, the resource occupation cost is reduced, the safety, the sharing performance and the relative independence of data among tenants can be guaranteed, a large amount of data generated by multiple tenants in a cloud environment is effectively managed, and meanwhile, the personalized requirements of the tenants are met.
Description
Technical Field
The invention relates to the technical field of power system relay protection, in particular to a setting calculation cloud data management method suitable for multiple tenants and a setting calculation system suitable for the multiple tenants.
Background
The setting calculation system based on the cloud platform needs to manage data of multiple users at each level, including various data such as primary equipment data, secondary fixed value data and setting process data of scheduling units at each level, and because different users are scheduled at each level by using the same setting software, under the same cloud platform setting calculation software, the management of the data of scheduling users at each level and the guarantee of mutual isolation and mutual decoupling of the data are very important. Multi-Tenant technology (Multi-tent) is a data architecture in SaaS (Software as a Service) solution, and aims to allow multiple users to use the same Software or system in the same environment, and meanwhile, it is required to ensure that the multiple users do not interfere with each other.
The existing multi-tenant data management modes include: an independent database management mode, a shared database independent management mode and a shared database shared management mode.
The independent database has the highest security level in the three data management modes, and each tenant has a separate database, that is, each user has a separate database for storing business data. The mode has the advantages that high isolation among tenant data and storage of personalized demand data can be met, but the mode is not suitable for data sharing, data among tenants cannot be accessed mutually, the number of servers provided with the database is increased when the number of tenants is increased to a certain degree, and the cost is relatively high.
The shared database independent management mode is that different tenants use the same database, but the data tables are different, that is, all tenant data are in the same database, and each tenant has its own service data table to store its service related data. Compared with an independent database management mode, the number of the tenants supported by the database management mode is more, data resources among the tenants can be shared, and data isolation to a certain degree is realized.
The shared database sharing management mode is to store the data of all tenants in one table of the same database, and the mode increases the utilization rate of resources and meets the requirement of data sharing among the tenants, but because the same table is used for storing the service data of users at all levels, the data security is lower and the storage of the data which meets the individual requirements of different users is not met.
Disclosure of Invention
The present invention is directed to solving, at least to some extent, one of the technical problems in the related art. Therefore, a first objective of the present invention is to provide a method for managing cloud data of a multi-tenant setting calculation, which can ensure that system resources are fully utilized, reduce resource occupation cost, ensure security, sharing and relative independence of data among tenants, effectively manage a large amount of data generated by the multi-tenant in a cloud environment, and meet personalized requirements of the tenants.
The second purpose of the invention is to provide a setting calculation system suitable for multi-tenancy.
A third object of the invention is to propose an electronic device.
A fourth object of the invention is to propose a computer-readable storage medium.
In order to achieve the above object, an embodiment of a first aspect of the present invention provides a method for managing setting computation cloud data applicable to multiple tenants, including: creating a tenant table, wherein the tenant table comprises a tenant ID, a tenant name and unit information to which the tenant belongs; extracting public data parts of each level of power grid tenant as a public database, and creating public tenant table data to form a shared database, wherein the public tenant table comprises a system configuration related data table, a user data table, a device commonality table and a basic setting principle table; using the differentiated data part of each tenant as an independent database, selecting the tenant in the independent database, and creating a virtual tenant table according to the tenant ID, wherein the virtual tenant table comprises a primary model table, a protection device table, a setting process table, a fixed value single data table, a calculation book management data table and a system data management data table; and isolating the data in the independent database according to the tenant ID.
According to the setting calculation cloud data management method suitable for multiple tenants, provided by the embodiment of the invention, a tenant table is created, public data parts of power grid tenants at all levels are extracted to serve as public databases, public tenant table data is created to form a shared database, differentiated data parts of each tenant serve as independent databases, tenants in the independent databases are selected, a virtual tenant table is created according to the tenant ID, and data in the independent databases are isolated according to the tenant ID. Therefore, the full utilization of system resources can be guaranteed, the resource occupation cost is reduced, the safety, the sharing performance and the relative independence of data among tenants can be guaranteed, a large amount of data generated by multiple tenants in a cloud environment is effectively managed, and meanwhile, the personalized requirements of the tenants are met.
In addition, the setting calculation cloud data management method suitable for multi-tenant according to the above embodiment of the present invention may further have the following additional technical features:
according to an embodiment of the present invention, the selecting tenants in the independent database to create a virtual tenant table according to tenant IDs includes: marking the tenants which have created the virtual tenant table; judging whether the data in the independent database are created completely according to the marked tenants; if not, then rent unmarked
Creating the virtual tenant table by a user; creating a class corresponding to the public tenant table data and the virtual tenant table data; associating the virtual tenant table with the class according to the association information; a class of the operational database is created.
According to one embodiment of the invention, the association information includes a table name, fields in the table, a class name, and attribute information in the class.
According to an embodiment of the invention, the creating a class of the operation database comprises: addition, deletion, modification, and querying of data in a database.
In order to achieve the above object, a second embodiment of the present invention provides a setting calculation system suitable for multiple tenants, including: a DB layer to: creating a tenant table, wherein the tenant table comprises a tenant ID, a tenant name and unit information to which the tenant belongs; extracting public data parts of each level of power grid tenant as a public database, and creating public tenant table data to form a shared database, wherein the public tenant table comprises a system configuration related data table, a user data table, a device commonality table and a basic setting principle table; using the differentiated data part of each tenant as an independent database, selecting the tenant in the independent database, and creating a virtual tenant table according to the tenant ID, wherein the virtual tenant table comprises a primary model table, a protection device table, a setting process table, a fixed value single data table, a calculation book management data table and a system data management data table; and isolating the data in the independent database according to the tenant ID.
According to the setting calculation system suitable for multiple tenants, the tenant table is created through the DB layer, public data parts of all levels of power grid tenants are extracted to serve as public databases, public tenant table data is created to form a shared database, differentiated data parts of all tenants serve as independent databases, tenants in the independent databases are selected to create virtual tenant tables according to tenant IDs, and data in the independent databases are isolated according to the tenant IDs. Therefore, the full utilization of system resources can be guaranteed, the resource occupation cost is reduced, the safety, the sharing performance and the relative independence of data among tenants can be guaranteed, a large amount of data generated by multiple tenants in a cloud environment is effectively managed, and meanwhile, the personalized requirements of the tenants are met.
In addition, the setting calculation system suitable for multi-tenant according to the above embodiment of the present invention may further have the following additional technical features:
according to an embodiment of the present invention, the DB (Database) layer is further configured to: marking the tenants which have created the virtual tenant table; judging whether the data in the independent database are created completely according to the marked tenants; if not, the virtual tenant table is created for the unmarked tenant; creating a class corresponding to the public tenant table data and the virtual tenant table data; creating a class corresponding to the public tenant table data and the virtual tenant table data; a class of the operational database is created.
According to an embodiment of the present invention, further comprising: a SaaS layer to: and adopting a unified framework to perform personalized customization according to the personalized service development requirements of scheduling tenants at all levels.
According to an embodiment of the present invention, further comprising: a Platform as a Service (Platform as a Service) layer for: the method realizes complete sharing of basic functions, general functions and service scheduling capability, and realizes partial sharing of services related to services, wherein the sharing degree is determined by specific services of different levels of scheduling units.
To achieve the above object, a third embodiment of the present invention provides an electronic device, including a memory, a processor; the processor runs a program corresponding to the executable program code by reading the executable program code stored in the memory, so as to implement the tuning calculation cloud data management method suitable for multiple tenants, which is provided by the embodiment of the first aspect of the present invention.
According to the electronic equipment provided by the embodiment of the invention, by executing the setting calculation cloud data management method suitable for multiple tenants, not only can the full utilization of system resources be ensured, the resource occupation cost be reduced, but also the safety, sharing and relative independence of data among the tenants can be ensured, a large amount of data generated by the multiple tenants in a cloud environment can be effectively managed, and meanwhile, the individualized requirements of the tenants are met.
In order to achieve the above object, a fourth aspect of the present invention provides a computer-readable storage medium, on which a computer program is stored, where the computer program, when executed by a processor, implements the method for cloud data management for multi-tenant tuning calculation provided in the first aspect of the present invention.
According to the computer-readable storage medium provided by the embodiment of the invention, by executing the setting computing cloud data management method suitable for multiple tenants, not only can full utilization of system resources be ensured, and resource occupation cost be reduced, but also the security, sharing and relative independence of data among the tenants can be ensured, a large amount of data generated by the multiple tenants in a cloud environment can be effectively managed, and meanwhile, the personalized requirements of the tenants are also met.
Drawings
Fig. 1 is a flowchart of a tuning calculation cloud data management method suitable for multi-tenancy according to an embodiment of the present invention;
FIG. 2 is a flow diagram of a tuning computation cloud data management method suitable for multi-tenancy according to one embodiment of the invention;
fig. 3 is a schematic structural diagram of a setting calculation system suitable for multi-tenancy according to an embodiment of the present invention.
Detailed Description
Reference will now be made in detail to embodiments of the present invention, examples of which are illustrated in the accompanying drawings, wherein like or similar reference numerals refer to the same or similar elements or elements having the same or similar function throughout. The embodiments described below with reference to the drawings are illustrative and intended to be illustrative of the invention and are not to be construed as limiting the invention.
The setting calculation cloud data management method suitable for multi-tenancy, the setting calculation system suitable for multi-tenancy, the electronic device, and the computer-readable storage medium according to the embodiments of the present invention are described below with reference to the accompanying drawings.
Fig. 1 is a flowchart of a setting computing cloud data management method suitable for multiple tenants according to an embodiment of the present invention. As shown in fig. 1, a setting calculation cloud data management method suitable for multiple tenants according to an embodiment of the present invention may include the following steps:
s1, a tenant table is created.
The tenant table comprises a tenant ID, a tenant name and unit information to which the tenant belongs.
And S2, extracting public data parts of each level of power grid tenant as a public database, and creating public tenant table data to form a shared database.
The public tenant table comprises a system configuration related data table, a user data table, a device commonality table and a basic setting principle table.
And S3, taking the differentiated data part of each tenant as an independent database, and selecting the tenant in the independent database to create a virtual tenant table according to the tenant ID.
The virtual tenant table comprises a primary model table, a protection device table, a setting process table, a fixed value single data table, a calculation book management data table and a system data management data table.
According to an embodiment of the present invention, selecting a tenant in an independent database to create a virtual tenant table according to a tenant ID includes: marking the tenants which have created the virtual tenant table; judging whether the data in the independent database are created completely according to the marked tenants; if not, creating a virtual tenant table for the unmarked tenant; creating a class corresponding to the public tenant table data and the virtual tenant table data; associating the virtual tenant table and the class according to the association information; a class of the operational database is created.
Wherein, the associated information comprises a table name, a field in the table, a class name and attribute information in the class, and the class for creating the operation database comprises: addition, deletion, modification, and querying of data in a database.
And S4, isolating the data in the independent database according to the tenant ID.
Specifically, with the continuous expansion of cloud platform setting computing system tenants, based on the fact that the total amount of resources related to calculation, application, data and storage in the cloud platform setting computing system is continuously increased, shared resources among tenants are more and more, the resource utilization rate is higher and higher, and the isolation cost of tenants is increased, in order to enable a user to conveniently and efficiently use and share internet resources in the cloud platform setting computing, the invention provides a setting computing cloud data management method suitable for multiple tenants, which combines a shared database independent management mode and a shared database shared management mode, splits all levels of public data parts of a power grid of the setting computing system to serve as public databases, uses differentiated and personalized data of each tenant as an independent database, and uses the public databases as shared databases, realizes isolation among the data according to tenant database IDs, and not only can ensure the full utilization of system resources, the method has the advantages that the resource occupation cost is reduced, the safety, the sharing property and the relative independence of data among tenants can be guaranteed, a large amount of data generated by multiple tenants in the cloud environment is effectively managed, and meanwhile, the personalized requirements of the tenants are met.
In order that those skilled in the art will more clearly understand the present invention, further description will be given below with reference to specific examples of the present invention.
Specifically, as shown in fig. 2, the tuning calculation cloud data management method suitable for multiple tenants may include the following steps:
s201, creating a tenant table.
And S202, creating common tenant table data.
S203, selecting a certain tenant, creating a virtual tenant table according to the tenant ID, and marking.
And S204, judging whether all the virtual tenant table data are created completely. If yes, ending; if not, go to step S205.
And S205, creating a virtual tenant table for the unmarked tenant.
And S206, creating a class corresponding to the common tenant table data and the virtual tenant table data.
And S207, associating the virtual tenant table with the class according to the association information.
S208, creating a class of the operation database.
In summary, according to the setting calculation cloud data management method applicable to multiple tenants, according to the embodiment of the invention, a tenant table is created, public data parts of power grid tenants at different levels are extracted as public databases, public tenant table data is created to form a shared database, differentiated data parts of each tenant are used as independent databases, tenants in the independent databases are selected to create virtual tenant tables according to tenant IDs, and data in the independent databases are isolated according to the tenant IDs. Therefore, the full utilization of system resources can be guaranteed, the resource occupation cost is reduced, the safety, the sharing performance and the relative independence of data among tenants can be guaranteed, a large amount of data generated by multiple tenants in a cloud environment is effectively managed, and meanwhile, the personalized requirements of the tenants are met.
As shown in fig. 3, a setting calculation system suitable for multi-tenant according to an embodiment of the present invention may include: and (5) a DB layer.
Wherein the DB layer is used for: creating a tenant table, wherein the tenant table comprises a tenant ID, a tenant name and unit information to which the tenant belongs; extracting public data parts of each level of power grid tenant as a public database, and creating public tenant table data to form a shared database, wherein the public tenant table comprises a system configuration related data table, a user data table, a device commonality table and a basic setting principle table; the method comprises the steps that differentiated data portions of all tenants serve as independent databases, the tenants in the independent databases are selected, and virtual tenant tables are created according to tenant IDs, wherein the virtual tenant tables comprise primary model tables, protection device tables, setting process tables, constant value single data tables, calculation book management data tables and system data management data tables; and isolating the data in the independent database according to the tenant ID.
According to an embodiment of the invention, the DB layer is further specifically configured to: marking the tenants which have created the virtual tenant table; judging whether the data in the independent database are created completely according to the marked tenants; if not, creating a virtual tenant table for the unmarked tenant; creating a class corresponding to the public tenant table data and the virtual tenant table data; associating the virtual tenant table and the class according to the association information; a class of the operational database is created.
According to an embodiment of the present invention, as shown in fig. 3, the setting calculation system suitable for multi-tenancy further includes: a SaaS layer, wherein the SaaS layer is used for: and adopting a unified framework to perform personalized customization according to the personalized service development requirements of scheduling tenants at all levels.
According to an embodiment of the present invention, as shown in fig. 3, the setting calculation system suitable for multi-tenancy further includes: a PasS layer for: the method realizes complete sharing of basic functions, general functions and service scheduling capability, and realizes partial sharing of services related to services, wherein the sharing degree is determined by specific services of different levels of scheduling units.
Specifically, a cloud platform setting calculation system based on multiple tenants needs to realize a primary model maintenance function, an equipment fault analysis function, a protection device model maintenance function, a principle constant value setting function, a device constant value setting function, a constant value list and calculation book management function, a system data management function and a system configuration management function. The cloud platform setting computing system based on multiple tenants realizes foreground and background separation through service integration, meets the clustering of core functions and the service splitting of business logic, and realizes the separation of application and data through a distributed data access layer. By combining a multi-tenant data management implementation scheme and the cloud platform-based setting calculation service characteristics, the system architecture design supports different tenants to share application programs at a logic level, different physical instances can be run, and the tenants at different levels can obtain corresponding basic capabilities through a service arrangement layer. The service arrangement means that a plurality of micro services can be called in sequence through one request, the returned result of each service is subjected to data processing, and finally the result is integrated into a large result and returned to the front end.
The setting calculation system suitable for multiple tenants can be divided into a SaaS layer, a PasS layer and a DB layer, wherein on the PasS layer, each level of scheduling tenants form a scheduling service center according to service characteristics, the scheduling service center is supported by respective independent databases, services are provided to the outside by respective service arrangement, and on the DB layer, data related to each level of scheduling tenants and users are established by adopting a data model unification and physical isolation mode to store setting process data, setting value single data, protection device data and the like. In addition, a common database is required to store system configuration data, organization authority data, log data, commonality data, basic setting principle data and the like.
It should be noted that the multi-tenant-based tuning calculation cloud data management mainly includes a multi-tenant database design with three levels, namely a service layer, a data access object layer and a database layer.
The service layer is composed of two services including a table access service and a table data management service, and common operations of most database tables can be realized through the two services.
The data access object layer is composed of two objects, data storage and deployment are safe and isolated, and business service concentration is achieved on the basis of meeting personalized application. Selecting function support services with multiple service common points and similar service scales, constructing a centralized service support system, and meeting the requirement of scheduling multi-tenant common service call at all levels, wherein the data access object is public tenant table data, and mainly uses a shared public data table to establish a related data object and expose an access interface to the public data table, thereby simplifying the operation to the public data table; the data access object meeting different sexualization service requirements of each level of tenant service is a table data access object, and the data access object mainly uses an expanded virtual tenant table to create a related data object and expose an access interface of the virtual data table, so that the operation of the data table expanded by the tenant is simplified.
The database design comprises a public tenant table and a virtual tenant table:
and the public tenant table is shared among tenants using a single multi-tenant database. These physical relationship tables may be applied to any business domain database, or other information collected from different data sources. A public tenant table of a cloud platform setting computing system based on multiple tenants is a data structure table of the same service of each tenant, and comprises a system configuration related data table, a user data table, a device common quantity table, a basic setting principle table and the like.
The virtual tenant table allows tenants to expand on the existing related service database, and a brand new virtual database structure can be formed by establishing an expanded virtual database table, expanding database relations and other related database constraints so as to own a configurable database. This design enables tenants to create and configure their own virtual database schema, which includes the required number of tables and columns, virtual database relationships, and the assignment of appropriate data types and constraints to the table columns during multi-tenant application execution. This configurable multi-tenant database design schema enables tenants to create unique flexible relational databases to meet their business needs. The cloud platform setting computing system virtual tenant table based on multiple tenants comprises a primary model table, a protection device table, a setting process table, a fixed value single data table, a computer book management data table, a system data management data table and the like.
In summary, according to the tuning calculation system applicable to multiple tenants in the embodiment of the present invention, a tenant table is created through a DB layer, public data portions of power grid tenants at different levels are extracted as public databases, and public tenant table data is created to form a shared database, differentiated data portions of each tenant are used as independent databases, tenants in the independent databases are selected, a virtual tenant table is created according to a tenant ID, and data in the independent databases are isolated according to the tenant ID. Therefore, the full utilization of system resources can be guaranteed, the resource occupation cost is reduced, the safety, the sharing performance and the relative independence of data among tenants can be guaranteed, a large amount of data generated by multiple tenants in a cloud environment is effectively managed, and meanwhile, the personalized requirements of the tenants are met.
In addition, an embodiment of the present invention further provides an electronic device, including a memory and a processor; the processor runs a program corresponding to the executable program code by reading the executable program code stored in the memory, so as to realize the above setting computing cloud data management method suitable for multiple tenants.
According to the electronic equipment provided by the embodiment of the invention, by executing the setting calculation cloud data management method suitable for multiple tenants, not only can the full utilization of system resources be ensured, the resource occupation cost be reduced, but also the safety, sharing and relative independence of data among the tenants can be ensured, a large amount of data generated by the multiple tenants in a cloud environment can be effectively managed, and meanwhile, the individualized requirements of the tenants are met.
In addition, an embodiment of the present invention further provides a computer-readable storage medium, where a computer program is stored on the computer-readable storage medium, and when the computer program is executed by a processor, the computer-readable storage medium implements the above-mentioned tuning calculation cloud data management method suitable for multiple tenants.
According to the computer-readable storage medium provided by the embodiment of the invention, by executing the setting computing cloud data management method suitable for multiple tenants, not only can full utilization of system resources be ensured, and resource occupation cost be reduced, but also the security, sharing and relative independence of data among the tenants can be ensured, a large amount of data generated by the multiple tenants in a cloud environment can be effectively managed, and meanwhile, the personalized requirements of the tenants are also met.
It should be understood that portions of the present invention may be implemented in hardware, software, firmware, or a combination thereof. In the above embodiments, the various steps or methods may be implemented in software or firmware stored in memory and executed by a suitable instruction execution system. For example, if implemented in hardware, as in another embodiment, any one or combination of the following techniques, which are known in the art, may be used: a discrete logic circuit having a logic gate circuit for implementing a logic function on a data signal, an application specific integrated circuit having an appropriate combinational logic gate circuit, a Programmable Gate Array (PGA), a Field Programmable Gate Array (FPGA), or the like.
In addition, in the description of the present invention, the terms "center", "longitudinal", "lateral", "length", "width", "thickness", "upper", "lower", "front", "rear", "left", "right", "vertical", "horizontal", "top", "bottom", "inner", "outer", "clockwise", "counterclockwise", "axial", "radial", "circumferential", etc. indicate orientations or positional relationships based on those shown in the drawings, and are only for convenience of description and simplicity of description, but do not indicate or imply that the device or element referred to must have a particular orientation, be constructed in a particular orientation, and be operated, and thus, should not be construed as limiting the present invention.
Furthermore, the terms "first", "second" and "first" are used for descriptive purposes only and are not to be construed as indicating or implying relative importance or implicitly indicating the number of technical features indicated. Thus, a feature defined as "first" or "second" may explicitly or implicitly include at least one such feature. In the description of the present invention, "a plurality" means at least two, e.g., two, three, etc., unless specifically limited otherwise.
In the present invention, unless otherwise expressly stated or limited, the terms "mounted," "connected," "secured," and the like are to be construed broadly and can, for example, be fixedly connected, detachably connected, or integrally formed; can be mechanically or electrically connected; they may be directly connected or indirectly connected through intervening media, or they may be connected internally or in any other suitable relationship, unless expressly stated otherwise. The specific meanings of the above terms in the present invention can be understood by those skilled in the art according to specific situations.
In the present invention, unless otherwise expressly stated or limited, the first feature "on" or "under" the second feature may be directly contacting the first and second features or indirectly contacting the first and second features through an intermediate. Also, a first feature "on," "over," and "above" a second feature may be directly or diagonally above the second feature, or may simply indicate that the first feature is at a higher level than the second feature. A first feature being "under," "below," and "beneath" a second feature may be directly under or obliquely under the first feature, or may simply mean that the first feature is at a lesser elevation than the second feature.
In the description herein, references to the description of the term "one embodiment," "some embodiments," "an example," "a specific example," or "some examples," etc., mean that a particular feature, structure, material, or characteristic described in connection with the embodiment or example is included in at least one embodiment or example of the invention. In this specification, the schematic representations of the terms used above are not necessarily intended to refer to the same embodiment or example. Furthermore, the particular features, structures, materials, or characteristics described may be combined in any suitable manner in any one or more embodiments or examples. Furthermore, various embodiments or examples and features of different embodiments or examples described in this specification can be combined and combined by one skilled in the art without contradiction.
Although embodiments of the present invention have been shown and described above, it is understood that the above embodiments are exemplary and should not be construed as limiting the present invention, and that variations, modifications, substitutions and alterations can be made to the above embodiments by those of ordinary skill in the art within the scope of the present invention.
Claims (10)
1. A setting calculation cloud data management method suitable for multiple tenants is characterized by comprising the following steps:
creating a tenant table, wherein the tenant table comprises a tenant ID, a tenant name and unit information to which the tenant belongs;
extracting public data parts of each level of power grid tenant as a public database, and creating public tenant table data to form a shared database, wherein the public tenant table comprises a system configuration related data table, a user data table, a device commonality table and a basic setting principle table;
using the differentiated data part of each tenant as an independent database, selecting the tenant in the independent database, and creating a virtual tenant table according to the tenant ID, wherein the virtual tenant table comprises a primary model table, a protection device table, a setting process table, a fixed value single data table, a calculation book management data table and a system data management data table;
and isolating the data in the independent database according to the tenant ID.
2. The method for managing tuning calculation cloud data suitable for multiple tenants as claimed in claim 1, wherein the selecting tenants in an independent database to create a virtual tenant table according to tenant IDs comprises:
marking the tenants which have created the virtual tenant table;
judging whether the data in the independent database are created completely according to the marked tenants;
if not, the virtual tenant table is created for the unmarked tenant;
creating a class corresponding to the public tenant table data and the virtual tenant table data;
associating the virtual tenant table with the class according to the association information;
a class of the operational database is created.
3. The tuning calculation cloud data management method suitable for multi-tenant according to claim 2, wherein the association information includes a table name, a field in a table, a class name, and attribute information in a class.
4. The tuning calculation cloud data management method suitable for multi-tenant according to claim 2, wherein the creating a class of the operation database includes: addition, deletion, modification, and querying of data in a database.
5. A tuning calculation system suitable for multiple tenants, comprising: a DB layer to: creating a tenant table, wherein the tenant table comprises a tenant ID, a tenant name and unit information to which the tenant belongs;
extracting public data parts of each level of power grid tenant as a public database, and creating public tenant table data to form a shared database, wherein the public tenant table comprises a system configuration related data table, a user data table, a device commonality table and a basic setting principle table;
using the differentiated data part of each tenant as an independent database, selecting the tenant in the independent database, and creating a virtual tenant table according to the tenant ID, wherein the virtual tenant table comprises a primary model table, a protection device table, a setting process table, a fixed value single data table, a calculation book management data table and a system data management data table;
and isolating the data in the independent database according to the tenant ID.
6. The multi-tenant adapted tuning calculation system of claim 5, wherein the DB layer is further specifically configured to:
marking the tenants which have created the virtual tenant table;
judging whether the data in the independent database are created completely according to the marked tenants;
if not, the virtual tenant table is created for the unmarked tenant;
creating a class corresponding to the public tenant table data and the virtual tenant table data;
associating the virtual tenant table with the class according to the association information;
a class of the operational database is created.
7. The multi-tenant adapted tuning calculation system of claim 5, further comprising:
a SaaS layer to: and adopting a unified framework to perform personalized customization according to the personalized service development requirements of scheduling tenants at all levels.
8. The multi-tenant adapted tuning calculation system of claim 5, further comprising:
a PasS layer for: the method realizes complete sharing of basic functions, general functions and service scheduling capability, and realizes partial sharing of services related to services, wherein the sharing degree is determined by specific services of different levels of scheduling units.
9. An electronic device comprising a memory, a processor;
wherein the processor executes a program corresponding to the executable program code by reading the executable program code stored in the memory, so as to implement the tuning calculation cloud data management method suitable for multi-tenancy according to any one of claims 1 to 4.
10. A computer-readable storage medium having a computer program stored thereon, wherein the computer program, when executed by a processor, implements the tuning calculation cloud data management method for multi-tenancy according to any one of claims 1 to 4.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010225549.6A CN111522869A (en) | 2020-03-26 | 2020-03-26 | Setting computing cloud data management method and setting computing system suitable for multiple tenants |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010225549.6A CN111522869A (en) | 2020-03-26 | 2020-03-26 | Setting computing cloud data management method and setting computing system suitable for multiple tenants |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111522869A true CN111522869A (en) | 2020-08-11 |
Family
ID=71901940
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010225549.6A Pending CN111522869A (en) | 2020-03-26 | 2020-03-26 | Setting computing cloud data management method and setting computing system suitable for multiple tenants |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111522869A (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112200635A (en) * | 2020-10-21 | 2021-01-08 | 中国电子科技集团公司第十五研究所 | Multi-tenant data isolation method and system based on tenant attributes |
| CN113342827A (en) * | 2021-07-01 | 2021-09-03 | 广东电网有限责任公司 | Power grid data storage method, storage medium and system based on multi-tenant technology |
| CN113343065A (en) * | 2021-07-01 | 2021-09-03 | 广东电网有限责任公司 | Power grid data acquisition system |
| CN116633691A (en) * | 2023-07-24 | 2023-08-22 | 四川航天天盛科技有限公司 | Cloud platform system based on SaaS and data storage method thereof |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104123616A (en) * | 2014-07-25 | 2014-10-29 | 南京邮电大学 | Cloud computing system towards multiple tenants |
| CN104731939A (en) * | 2015-03-31 | 2015-06-24 | 浪潮集团有限公司 | Method for sharing data among tenants through data table |
| CN106547849A (en) * | 2016-10-18 | 2017-03-29 | 华南师范大学 | A kind of construction method of the multi-tenant database for meeting tenant's differentiated demand |
| CN109947773A (en) * | 2017-10-26 | 2019-06-28 | Sap欧洲公司 | Change of the deployment to key mode in multi-tenant database system |
-
2020
- 2020-03-26 CN CN202010225549.6A patent/CN111522869A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104123616A (en) * | 2014-07-25 | 2014-10-29 | 南京邮电大学 | Cloud computing system towards multiple tenants |
| CN104731939A (en) * | 2015-03-31 | 2015-06-24 | 浪潮集团有限公司 | Method for sharing data among tenants through data table |
| CN106547849A (en) * | 2016-10-18 | 2017-03-29 | 华南师范大学 | A kind of construction method of the multi-tenant database for meeting tenant's differentiated demand |
| CN109947773A (en) * | 2017-10-26 | 2019-06-28 | Sap欧洲公司 | Change of the deployment to key mode in multi-tenant database system |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112200635A (en) * | 2020-10-21 | 2021-01-08 | 中国电子科技集团公司第十五研究所 | Multi-tenant data isolation method and system based on tenant attributes |
| CN113342827A (en) * | 2021-07-01 | 2021-09-03 | 广东电网有限责任公司 | Power grid data storage method, storage medium and system based on multi-tenant technology |
| CN113343065A (en) * | 2021-07-01 | 2021-09-03 | 广东电网有限责任公司 | Power grid data acquisition system |
| CN116633691A (en) * | 2023-07-24 | 2023-08-22 | 四川航天天盛科技有限公司 | Cloud platform system based on SaaS and data storage method thereof |
| CN116633691B (en) * | 2023-07-24 | 2023-10-27 | 四川航天天盛科技有限公司 | Cloud platform system based on SaaS and data storage method thereof |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111522869A (en) | Setting computing cloud data management method and setting computing system suitable for multiple tenants | |
| CN107181808B (en) | Private cloud system and operation method | |
| US20200210421A1 (en) | Method of storing remote sensing big data in hbase database | |
| US8892558B2 (en) | Inserting data into an in-memory distributed nodal database | |
| CN108683692B (en) | Service request processing method and device | |
| CN111460045A (en) | Modeling method, model, computer device and storage medium for data warehouse construction | |
| CN106548288B (en) | The polymorphic instance management system and method for the more scenes of electric power | |
| CN111881223B (en) | Data management method, device, system and storage medium | |
| WO2021032146A1 (en) | Metadata management method and apparatus, device, and storage medium | |
| CN106775702B (en) | Container-based service internal interface discovery method | |
| US9355106B2 (en) | Sensor data locating | |
| CN108268614B (en) | Distributed management method for forest resource spatial data | |
| CN105608228B (en) | A kind of efficient distributed RDF data storage method | |
| JPWO2011111532A1 (en) | Database system | |
| CN107977773A (en) | A kind of method for the entry resource amount for managing multiple cloud platforms | |
| US11500874B2 (en) | Systems and methods for linking metric data to resources | |
| CN106790027B (en) | Multi-tenant network disk authority management method and system of HDFS file system | |
| CN111782886B (en) | Metadata management method and device | |
| CN109729071A (en) | A kind of vmware multi-tenant management method suitable for cloudy management | |
| CN109753245A (en) | A kind of multiple disks load balancing asynchronous read and write dispatching method and device | |
| CN111950866B (en) | Role-based multi-tenant organization structure management system, method, equipment and medium | |
| CN117033454A (en) | Data processing method, device, equipment and medium | |
| CN108446141B (en) | Web front-end plug-in and method for scheduling and communicating based on same | |
| CN112162731B (en) | Data expansion method, device, storage medium and electronic device | |
| JP2011113103A (en) | Multi-tenant type computer system |
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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20200811 |