A multi-type database management method, device and equipment based on SaaS application in a signal creation environment and a medium

Abstract

The application provides a multi-type database management method, device and equipment based on SaaS application in a Xinyuan environment and a medium. The method comprises the following steps: obtaining subscription information of a to-be-managed tenant, determining business characteristics and application requirements of the to-be-managed tenant based on the subscription information, defining a storage space of the to-be-managed tenant based on the business characteristics to obtain storage attributes of the storage space, creating an independent database instance for the to-be-managed tenant based on the obtained application requirements and a preset database splitting model, and adding the database instance to a routing table of the storage space. When receiving a storage space access requirement of any target tenant, the position of the target storage space is determined based on the routing table, and the target storage space is accessed. By allocating different storage spaces to different tenants and isolating the allocated storage spaces from each other, personalized data storage management of tenant-application granularity is realized.

Description

Technical Field

[0001] This application relates to the field of electronic technology, specifically to a method, apparatus, device, and medium for managing multiple types of databases based on SaaS applications in an information technology innovation environment. Background Technology

[0002] Due to various factors such as different business scenarios having different database requirements, different databases potentially having different security characteristics, and the potential risks associated with using a single database, as well as the continuous development of technology leading to the emergence of new database types and functions, adapting to multiple database types can increase application flexibility. Furthermore, selecting the appropriate database type and configuration based on actual business needs and scenarios can optimize performance and costs. Therefore, in the context of domestic IT innovation and real-world business scenarios, it is particularly important for applications to adapt to multiple database types.

[0003] However, current database adaptation methods are often unable to achieve personalized data storage management at the tenant-application granularity due to technical reasons. Summary of the Invention

[0004] In view of the shortcomings of the prior art described above, the present invention provides a method, apparatus, device and medium for managing multiple types of databases based on SaaS applications in the context of information technology innovation, so as to solve the above-mentioned technical problem of being unable to achieve personalized data storage management at the tenant-application granularity.

[0005] This invention provides a method for managing multiple types of databases based on SaaS applications in a domestic IT innovation environment. The method includes: obtaining subscription information of a tenant to be managed, and determining the business characteristics and application requirements of the tenant to be managed based on the subscription information; defining the storage space of the tenant to be managed based on the business characteristics to obtain the storage attributes of the storage space; creating an independent database instance for the tenant to be managed based on the obtained application requirements and a preset database partitioning model, and adding the database instance to the routing table of the storage space; and when a storage space access request from any target tenant is received, determining the location of the target storage space based on the routing table and accessing the target storage space.

[0006] In one embodiment of the present invention, before obtaining tenant subscription information, the method further includes: obtaining operator deployment information, and determining database characteristic information and database requirements based on the operator deployment information; and determining a target database based on the database characteristic information and the database requirements.

[0007] In one embodiment of the present invention, the storage attributes of the storage space include at least storage capacity, data security, and access speed.

[0008] In one embodiment of the present invention, creating an independent database instance for the tenant to be managed based on the application requirements and a preset database partitioning model includes: defining attributes of the database instance for the tenant to be managed based on the preset database partitioning model, wherein the attributes include at least storage capacity, data structure, and access permissions; creating an independent database instance for each tenant to be managed according to the defined database instance attributes and application requirements; and configuring corresponding database access permissions for the tenant to be managed so that the tenant to be managed can only access the data storage space corresponding to the tenant to be managed.

[0009] In one embodiment of the present invention, adding the database instance to the routing table of the storage space includes obtaining an initial routing table and instance information of the database instance, wherein the instance information includes at least the instance identifier, IP address, and port number; adding the instance information to the routing table of the storage space according to a preset format, so that a unique identifier is assigned to each database instance in the routing table, and the access path and routing rules corresponding to the identifier are recorded.

[0010] In one embodiment of the present invention, determining the location of the target storage space based on the routing table and accessing the target storage space includes: obtaining the storage identifier of the target storage space; querying the routing table to obtain a target identifier associated with the storage identifier; and determining the target access path and target routing rules of the target storage space based on the target identifier; and establishing a connection with the database instance of the target storage space based on the target access path and the target routing rules to access the target data in the target database instance.

[0011] In one embodiment of the present invention, after creating an independent database instance for the tenant to be managed, the method further includes: periodically collecting performance data and status information of the storage space instance through a preset monitoring tool to obtain monitoring data; setting reasonable thresholds for key monitoring indicators and triggering alarms when the monitoring data exceeds or falls below these thresholds; and adjusting the storage space resources based on the monitoring data, alarm information, and a preset storage resource adjustment scheme.

[0012] This application provides a multi-type database management device based on SaaS applications in a domestic IT innovation environment. The device includes: an information acquisition module, used to acquire subscription information of tenants to be managed, and determine the business characteristics and application requirements of the tenants to be managed based on the subscription information; an attribute definition module, used to define the storage space of the tenants to be managed based on the business characteristics to obtain the storage attributes of the storage space; a routing allocation module, used to create independent database instances for the tenants to be managed based on the obtained application requirements and a preset database partitioning model, and add the database instances to the routing table of the storage space; and a data access module, used to determine the location of the target storage space based on the routing table and access the target storage space when a storage space access request from any target tenant is received.

[0013] This application provides an electronic device, which includes: one or more processors; and a storage device for storing one or more programs. When the one or more programs are executed by the one or more processors, the electronic device enables the management of multiple types of databases based on SaaS applications in the context of information technology innovation as described above.

[0014] This application provides a computer-readable storage medium storing a computer program thereon, which, when executed by a computer's processor, causes the computer to perform the multi-type database management method based on SaaS applications in the context of information technology innovation as described above.

[0015] The beneficial effects of this invention are as follows: This invention provides a method, apparatus, device, and storage medium for managing multiple types of databases based on SaaS applications in a domestic IT innovation environment. The method includes: obtaining subscription information of a tenant to be managed, determining the business characteristics and application requirements of the tenant based on the subscription information, defining the storage space of the tenant based on the business characteristics to obtain the storage attributes of the storage space, creating an independent database instance for the tenant based on the obtained application requirements and a preset database partitioning model, and adding the database instance to the routing table of the storage space. When a storage space access request from any target tenant is received, the location of the target storage space is determined based on the routing table, and the target storage space is accessed. By allocating different storage spaces to different tenants, and ensuring that the allocated storage spaces are isolated from each other, personalized data storage management at the tenant-application granularity is achieved.

[0016] It should be understood that the above general description and the following detailed description are exemplary and explanatory only, and do not limit this application. Attached Figure Description

[0017] The accompanying drawings, which are incorporated in and form part of this specification, illustrate embodiments consistent with this application and, together with the description, serve to explain the principles of this application. It is obvious that the drawings described below are merely some embodiments of this application, and those skilled in the art can obtain other drawings based on these drawings without any inventive effort. In the drawings:

[0018] Figure 1 This is a schematic diagram illustrating the implementation environment of a multi-type database management method based on SaaS applications under an exemplary embodiment of this application;

[0019] Figure 2 This is a flowchart illustrating a multi-type database management method based on SaaS applications in an exemplary embodiment of this application;

[0020] Figure 3 This is a schematic diagram illustrating the steps of a multi-type database management method based on SaaS applications in an exemplary embodiment of this application;

[0021] Figure 4 This is a block diagram illustrating a multi-type database management device based on SaaS applications in an exemplary embodiment of this application;

[0022] Figure 5 A schematic diagram of the structure of a computer system suitable for implementing the electronic device of the present application is shown. Detailed Implementation

[0023] The embodiments of the present invention will be described below with reference to the accompanying drawings and preferred embodiments. Those skilled in the art can easily understand other advantages and effects of the present invention from the content disclosed in this specification. The present invention can also be implemented or applied through other different specific embodiments, and various details in this specification can also be modified or changed based on different viewpoints and applications without departing from the spirit of the present invention. It should be understood that the preferred embodiments are only for illustrating the present invention and not for limiting the scope of protection of the present invention.

[0024] It should be noted that the illustrations provided in the following embodiments are only schematic representations of the basic concept of the present invention. Therefore, the drawings only show the components related to the present invention and are not drawn according to the actual number, shape and size of the components in the actual implementation. In the actual implementation, the form, quantity and proportion of each component can be arbitrarily changed, and the layout of the components may also be more complex.

[0025] In the following description, numerous details are explored to provide a more thorough explanation of embodiments of the invention. However, it will be apparent to those skilled in the art that embodiments of the invention may be practiced without these specific details. In other embodiments, well-known structures and devices are shown in block diagram form rather than in detail to avoid obscuring embodiments of the invention.

[0026] First, it's important to clarify that SaaS stands for Software as a Service, a software delivery model. In this model, software vendors deploy applications on their own servers and make them available to users via the internet. Users can achieve the same functionality and access data through a web browser.

[0027] Figure 1 This is an exemplary embodiment of the present application illustrating the implementation environment of a multi-type database management method based on SaaS applications in the context of information technology innovation.

[0028] like Figure 1 As shown, the multi-type database management based on SaaS applications in this information technology innovation environment includes a data acquisition device 101 and a computer device 102. The parameter acquisition device 101 is used to collect initial tenant information and send it to the computer device 102. The information acquisition device can be any device capable of capturing data information; this application does not impose any restrictions on this. The computer device 102 is used to determine the storage information of the tenants based on the tenant information collected by the data acquisition device 101, allocate storage space for them, and define access paths. The computer device 102 can be at least one of a desktop graphics processing unit (GPU) computer, a GPU computing cluster, a neural network computer, etc., or it can be an intelligent processor integrated into the current vehicle; this application also does not impose any restrictions on this.

[0029] like Figure 2 As shown in an exemplary embodiment, the method for managing multiple types of databases based on SaaS applications in a domestic IT innovation environment includes at least steps S210 to S240, which are described in detail below:

[0030] Step S210: Obtain the subscription information of the tenant to be managed, and determine the business characteristics and application requirements of the tenant to be managed based on the subscription information.

[0031] In one embodiment of this application, before obtaining tenant subscription information, the method further includes: obtaining operator deployment information, and determining database characteristic information and database requirements based on the operator deployment information; and determining a target database based on the database characteristic information and the database requirements.

[0032] Step S220: Define the storage space of the tenant to be managed based on the business characteristics to obtain the storage attributes of the storage space.

[0033] In one embodiment of this application, the storage attributes of the storage space include at least storage capacity, data security, and access speed.

[0034] Step S230: Based on the obtained application requirements and the preset database partitioning model, create an independent database instance for the tenant to be managed, and add the database instance to the routing table of the storage space.

[0035] In one embodiment of this application, creating an independent database instance for the tenant to be managed based on the application requirements and a preset database partitioning model includes: defining attributes of the database instance for the tenant to be managed based on the preset database partitioning model, the attributes including at least storage capacity, data structure, and access permissions; creating an independent database instance for each tenant to be managed according to the defined database instance attributes and application requirements; and configuring corresponding database access permissions for the tenant to be managed so that the tenant to be managed can only access the data storage space corresponding to the tenant to be managed.

[0036] In one embodiment of this application, adding the database instance to the routing table of the storage space includes obtaining an initial routing table and instance information of the database instance, wherein the instance information includes at least the instance identifier, IP address, and port number; adding the instance information to the routing table of the storage space according to a preset format, so that a unique identifier is assigned to each database instance in the routing table, and the access path and routing rules corresponding to the identifier are recorded.

[0037] Step S240: Upon receiving a storage space access request from any target tenant, determine the location of the target storage space based on the routing table and access the target storage space.

[0038] In one embodiment of this application, determining the location of the target storage space based on the routing table and accessing the target storage space includes: obtaining the storage identifier of the target storage space; querying the routing table to obtain a target identifier associated with the storage identifier, and determining the target access path and target routing rules of the target storage space based on the target identifier; and establishing a connection with the database instance of the target storage space based on the target access path and the target routing rules to access target data in the target database instance.

[0039] Furthermore, in one embodiment of this application, after creating an independent database instance for the tenant to be managed, the method further includes: periodically collecting performance data and status information of the storage space instance through a preset monitoring tool to obtain monitoring data; setting reasonable thresholds for key monitoring indicators and triggering alarms when the monitoring data exceeds or falls below these thresholds; and adjusting the storage space resources based on the monitoring data, alarm information, and a preset storage resource adjustment scheme.

[0040] Figure 3 This is a schematic diagram illustrating the steps of a multi-type database management method based on SaaS applications in an exemplary embodiment of this application.

[0041] like Figure 3 As shown, the multi-type database management method based on SaaS applications in the information technology innovation environment includes the following steps:

[0042] Step 1: Define the SaaS application data storage space model. The database storage space model is defined by the five-tuple (TenantSign, AppSign, DBType, DBInstance, DBSchema), which are represented as (tenant identifier, application identifier, database type, database instance definition, and database schema definition).

[0043] Step 2: Instantiate the storage space model and update the global routing table, including initialization when the SaaS application starts and dynamic adjustment of application storage space instances during operation.

[0044] Step 3: Retrieve the instance routing table and schedule storage space access. The application's database access retrieves the connection information of the storage space instance by retrieving the global routing table through the scheduler. All database accesses of the application will be automatically routed to this storage space.

[0045] Step 4: Monitor storage space instances and automatically adjust resources. During application operation, it provides monitoring of memory-based storage space instances, such as their liveness and resource consumption.

[0046] In one specific embodiment of this application, firstly, a SaaS application data storage space model is defined, including the selection of database type (adaptable to various domestic databases) and storage space-related configurations (including whether an independent database instance is required, whether primary-standby high availability is needed, etc.). The database storage space model is defined as a five-tuple: (TenantSign, AppSign, DBType, DBInstance, DBSchema), representing (tenant identifier, application identifier, database type, database instance definition, and database schema definition), respectively. The tenant identifier defines the scope to which the application belongs; the application identifier corresponds to the subscribed SaaS application; the database type indicates the type of database on which the application data is stored; the database instance definition represents the connection information of the instance where the database resides, determined based on the database type, and multiple instances can be used for high availability; the database schema represents the schema information created based on the database instance, i.e., the actual storage space of the application, and multiple schemas can also be used to meet high availability requirements. Then, the storage space model is instantiated and the global routing table is updated, including initialization during SaaS application deployment and dynamic adjustment of application storage space instances during operation. The instance itself runs in memory, and the instance's access information is added to the global routing table for storage space router scheduling. One storage space instance can correspond to a cluster composed of multiple actual database connections. Next, the instance routing table is retrieved and storage space access scheduling is performed. The application's database access retrieves the connection information of the storage space instance through the scheduler by retrieving the global routing table. All database accesses of the application are automatically routed to this storage space. At the same time, based on the user session thread, the storage space instance is dynamically switched when the user switches applications, thereby achieving smooth application switching while meeting the requirements of tenant application data isolation. Finally, the storage space instances are monitored and resources are automatically adjusted. During application operation, monitoring of memory-based storage space instances is provided, such as their liveness and resource consumption, and instances are automatically reset or resource quotas are adjusted according to the actual situation.

[0047] It should be noted that the multi-type database management method for SaaS applications in the domestic IT innovation environment proposed in this application firstly requires the operator to select a suitable database type when deploying the SaaS application. Choosing the appropriate database type is crucial to ensuring the performance and reliability of the application. Tenants can also select the required storage space configuration when subscribing, thus meeting the data storage needs of different tenants. Secondly, based on the tenant's needs and business characteristics, specific attributes can be defined for the tenant's application storage space. Furthermore, a database partitioning model can be used to create an independent database instance for each tenant, ensuring data isolation and security for each tenant. Thirdly, by adding the instance to the storage space routing table, the flow of data between different storage space instances can be defined, and a scheduler manages and schedules data access, ensuring efficient data flow and access. In addition, application database access is managed through the scheduler, ensuring that each tenant's application storage access is guided to its independent storage space, ensuring data security and privacy for different tenants. Finally, since the entire storage space instance is cached in memory, monitoring and management of the instance becomes more efficient, and resource quotas can be automatically adjusted according to load to maintain optimal performance. Therefore, the multi-type database management method based on SaaS applications in the information technology innovation environment proposed in this application not only realizes personalized data storage management at the tenant-application granularity, but also improves the reuse rate of data storage space.

[0048] Finally, it should be noted that the multi-type database management method for SaaS applications in the domestic IT innovation environment proposed in this application has significant advantages. It not only meets the needs of multi-tenant application scenarios but also supports the mixed use of multiple database types. In today's information age, the importance of data is increasingly prominent. As a key infrastructure for storing and managing data, the management method and efficiency of databases directly affect the performance and stability of the entire system. However, different application scenarios require different types of databases to meet their specific needs. For example, relational databases are suitable for applications requiring complex queries and transaction processing, while NoSQL databases are more suitable for applications requiring the storage of large amounts of unstructured data and high concurrency. Therefore, the multi-type database management method proposed in this application allows the simultaneous use of multiple database types within the same SaaS application. This mixed-use approach can fully leverage the advantages of different database types, improving the performance and stability of the entire system. It is worth mentioning that the method proposed in this application is not only applicable to traditional database types but also supports the use of domestic databases in the domestic IT innovation environment. With the increasing emphasis on information security by the state, the development and application of domestic databases are receiving increasing attention. The method in this application can be seamlessly integrated with domestic databases, providing a more secure and reliable database management solution for applications in the domestic IT innovation environment. In summary, the multi-type database management method based on SaaS applications in the context of domestic IT innovation proposed in this application has high flexibility and scalability, can meet the increasingly diverse application needs, and provides new ideas and solutions for database management in the context of domestic IT innovation.

[0049] Figure 4 This is a block diagram illustrating a multi-type database management device based on SaaS applications in an exemplary embodiment of this application. The device can be applied to... Figure 1 The implementation environment shown is illustrated. This device can also be applied to other exemplary implementation environments and specifically configured in other devices. This embodiment does not limit the implementation environment to which the device is applicable.

[0050] like Figure 4 As shown, this exemplary multi-type database management device based on SaaS applications in a domestic IT innovation environment includes:

[0051] The system includes: an information acquisition module 410, used to acquire subscription information of the tenant to be managed, and determine the business characteristics and application requirements of the tenant to be managed based on the subscription information; an attribute definition module 420, used to define the storage space of the tenant to be managed based on the business characteristics to obtain the storage attributes of the storage space; a routing allocation module 430, used to create an independent database instance for the tenant to be managed based on the obtained application requirements and a preset database partitioning model, and add the database instance to the routing table of the storage space; and a data access module 440, used to determine the location of the target storage space based on the routing table and access the target storage space when a storage space access request from any target tenant is received.

[0052] It should be noted that the multi-type database management device based on SaaS applications in the information technology innovation environment provided in the above embodiments and the multi-type database management method based on SaaS applications in the information technology innovation environment provided in the above embodiments belong to the same concept. The specific ways in which each module and unit performs operations have been described in detail in the method embodiments, and will not be repeated here. In practical applications, the multi-type database management device based on SaaS applications in the information technology innovation environment provided in the above embodiments can allocate the above functions to different functional modules as needed, that is, divide the internal structure of the device into different functional modules to complete all or part of the functions described above, and this is not a limitation here.

[0053] Embodiments of this application also provide an electronic device, including: one or more processors; and a storage device for storing one or more programs, wherein when the one or more programs are executed by the one or more processors, the electronic device enables the multi-type database management method based on SaaS applications in the information technology innovation environment provided in the above embodiments.

[0054] Figure 5 A schematic diagram of a computer system suitable for implementing the embodiments of this application is shown. It should be noted that... Figure 5 The computer system 500 of the electronic device shown is merely an example and should not impose any limitation on the functionality and scope of use of the embodiments of this application.

[0055] like Figure 5As shown, the computer system 500 includes a Central Processing Unit (CPU) 501, which can perform various appropriate actions and processes based on programs stored in Read-Only Memory (ROM) 502 or programs loaded from storage portion 508 into Random Access Memory (RAM) 503, such as performing the methods described in the above embodiments. The RAM 503 also stores various programs and data required for system operation. The CPU 501, ROM 502, and RAM 503 are interconnected via a bus 504. An Input / Output (I / O) interface 505 is also connected to the bus 504.

[0056] The following components are connected to I / O interface 505: an input section 506 including a keyboard, mouse, etc.; an output section 507 including a cathode ray tube (CRT), liquid crystal display (LCD), etc., and speakers, etc.; a storage section 508 including a hard disk, etc.; and a communication section 509 including a network interface card such as a LAN (Local Area Network) card, modem, etc. The communication section 509 performs communication processing via a network such as the Internet. A drive 510 is also connected to I / O interface 505 as needed. Removable media 511, such as a disk, optical disk, magneto-optical disk, semiconductor memory, etc., are installed on drive 510 as needed so that computer programs read from them can be installed into storage section 508 as needed.

[0057] Specifically, according to embodiments of this application, the processes described above with reference to the flowcharts can be implemented as computer software programs. For example, embodiments of this application include a computer program product comprising a computer program carried on a computer-readable medium, the computer program including a computer program for performing the methods shown in the flowcharts. In such embodiments, the computer program can be downloaded and installed from a network via communication section 509, and / or installed from removable medium 511. When the computer program is executed by central processing unit (CPU) 501, it performs various functions defined in the system of this application.

[0058] It should be noted that the computer-readable medium shown in the embodiments of this application can be a computer-readable signal medium or a computer-readable storage medium, or any combination of the two. A computer-readable storage medium can be, for example, an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination thereof. More specific examples of a computer-readable storage medium may include, but are not limited to: an electrical connection having one or more wires, a portable computer disk, a hard disk, random access memory (RAM), read-only memory (ROM), erasable programmable read-only memory (EPROM), flash memory, optical fiber, portable compact disc read-only memory (CD-ROM), optical storage device, magnetic storage device, or any suitable combination thereof. In this application, a computer-readable signal medium may include a data signal propagated in baseband or as part of a carrier wave, carrying a computer-readable computer program. Such propagated data signals can take various forms, including but not limited to electromagnetic signals, optical signals, or any suitable combination thereof. Computer-readable signal media can also be any computer-readable medium other than computer-readable storage media, which can send, propagate, or transmit a program for use by or in connection with an instruction execution system, apparatus, or device. The computer program contained on the computer-readable medium can be transmitted using any suitable medium, including but not limited to wireless, wired, etc., or any suitable combination thereof.

[0059] The flowcharts and block diagrams in the accompanying drawings illustrate the architecture, functionality, and operation of possible implementations of systems, methods, and computer program products according to various embodiments of this application. Each block in a flowchart or block diagram may represent a module, segment, or portion of code, which contains one or more executable instructions for implementing a specified logical function. It should also be noted that in some alternative implementations, the functions indicated in the blocks may occur in a different order than those indicated in the drawings. For example, two consecutively indicated blocks may actually be executed substantially in parallel, and they may sometimes be executed in reverse order, depending on the functions involved. It should also be noted that each block in a block diagram or flowchart, and combinations of blocks in a block diagram or flowchart, can be implemented using a dedicated hardware-based system that performs the specified function or operation, or using a combination of dedicated hardware and computer instructions.

[0060] The units described in the embodiments of this application can be implemented in software or hardware, and the described units can also be located in a processor. The names of these units do not necessarily limit the specific unit itself.

[0061] Another aspect of this application provides a computer-readable storage medium storing a computer program thereon. When executed by a computer's processor, the computer program causes the computer to perform the multi-type database management method based on SaaS applications in the context of domestic IT innovation, as described above. This computer-readable storage medium may be included in the electronic device described in the above embodiments, or it may exist independently and not assembled into the electronic device.

[0062] Another aspect of this application provides a computer program product or computer program including computer instructions stored in a computer-readable storage medium. A processor of a computer device reads the computer instructions from the computer-readable storage medium and executes the computer instructions, causing the computer device to perform the multi-type database management method based on SaaS applications in the information technology innovation environment provided in the various embodiments above.

[0063] The above embodiments are merely illustrative of the principles and effects of the present invention and are not intended to limit the invention. Any person skilled in the art can modify or alter the above embodiments without departing from the spirit and scope of the present invention. Therefore, all equivalent modifications or alterations made by those skilled in the art without departing from the spirit and technical concept disclosed in the present invention should still be covered by the claims of the present invention.

Claims

1. A method for managing multiple types of databases based on SaaS applications in a domestic IT innovation environment, characterized in that, The method includes: Obtain the subscription information of the tenant to be managed, and determine the business characteristics and application requirements of the tenant to be managed based on the subscription information; Based on the aforementioned business characteristics, the storage space of the tenant to be managed is defined to obtain the storage attributes of the storage space; Based on the obtained application requirements and the preset database partitioning model, an independent database instance is created for each tenant to be managed. Specifically, based on the preset database partitioning model, attributes of the database instance are defined for each tenant to be managed, including at least storage capacity, data structure, and access permissions. According to the defined database instance attributes and application requirements, an independent database instance is created for each tenant to be managed. Corresponding database access permissions are configured for each tenant to be managed, ensuring that each tenant can only access the data storage space corresponding to it, and the database instance is added to the routing table of the storage space. Upon receiving a storage space access request from any target tenant, the location of the target storage space is determined based on the routing table, and the target storage space is accessed.

2. The method for managing multiple types of databases based on SaaS applications in a domestically developed information technology environment according to claim 1, characterized in that, Before obtaining tenant subscription information, the following is also included: Obtain operator deployment information, and determine database characteristic information and database requirements based on the operator deployment information; The target database is determined based on the database feature information and the database requirements.

3. The method for managing multiple types of databases based on SaaS applications in a domestically developed information technology environment according to claim 1, characterized in that, The storage attributes of the storage space include at least storage capacity, data security, and access speed.

4. The method for managing multiple types of databases based on SaaS applications in a domestically developed information technology environment according to claim 1, characterized in that, Add the database instance to the routing table of the storage space, including Obtain the initial routing table and the instance information of the database instance, wherein the instance information includes at least the instance identifier, IP address, and port number; The instance information is added to the routing table of the storage space according to a preset format, so that a unique identifier is assigned to each database instance in the routing table, and the access path and routing rules corresponding to the identifier are recorded.

5. The method for managing multiple types of databases based on SaaS applications in a domestically developed information technology environment according to claim 1, characterized in that, Determining the location of the target storage space based on the routing table and accessing the target storage space includes: Obtain the storage identifier of the target storage space. The routing table is queried to obtain the target identifier associated with the storage identifier, and the target access path and target routing rules of the target storage space are determined based on the target identifier. A connection is established with the database instance of the target storage space based on the target access path and the target routing rules to access the target data in the database instance.

6. The method for managing multiple types of databases based on SaaS applications in a domestically developed information technology environment according to any one of claims 1-5, characterized in that, After creating a separate database instance for the tenant to be managed, the following is also included: The performance data and status information of the storage space instance are collected periodically by pre-set monitoring tools to obtain monitoring data; Set reasonable thresholds for key monitoring indicators and trigger alarms when monitoring data exceeds or falls below these thresholds; Based on monitoring data, alarm information, and preset storage resource adjustment plans, storage space resources are adjusted.

7. A multi-type database management device based on SaaS applications in a domestic information technology innovation environment, characterized in that, The device includes: The information acquisition module is used to acquire the subscription information of the tenant to be managed, and determine the business characteristics and application requirements of the tenant to be managed based on the subscription information; The attribute definition module is used to define the storage space of the tenant to be managed based on the business characteristics, so as to obtain the storage attributes of the storage space; The routing allocation module is used to create independent database instances for the tenants to be managed based on the obtained application requirements and a preset database partitioning model. Specifically, based on the preset database partitioning model, it defines the attributes of the database instances for the tenants to be managed, including at least storage capacity, data structure, and access permissions. According to the defined database instance attributes and application requirements, it creates an independent database instance for each tenant to be managed; it configures corresponding database access permissions for the tenants to be managed, ensuring that the tenants can only access the data storage space corresponding to them, and adds the database instances to the routing table of the storage space. The data access module is used to determine the location of the target storage space based on the routing table and access the target storage space after receiving a storage space access request from any target tenant.

8. An electronic device, characterized in that, The electronic device includes: One or more processors; A storage device for storing one or more programs, which, when executed by one or more processors, enable the electronic device to implement the multi-type database management method based on SaaS applications in the context of domestic IT innovation as described in any one of claims 1 to 6.

9. A computer-readable storage medium, characterized in that, It stores a computer program, which, when executed by the computer's processor, causes the computer to perform the multi-type database management method based on SaaS applications in the information technology innovation environment as described in any one of claims 1 to 6.

Images