CN116401231A - Data source management method, device and storage medium - Google Patents
Data source management method, device and storage medium Download PDFInfo
- Publication number
- CN116401231A CN116401231A CN202310292537.9A CN202310292537A CN116401231A CN 116401231 A CN116401231 A CN 116401231A CN 202310292537 A CN202310292537 A CN 202310292537A CN 116401231 A CN116401231 A CN 116401231A
- Authority
- CN
- China
- Prior art keywords
- data source
- tenant database
- source management
- user side
- component
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
- 238000007726 management method Methods 0.000 title claims abstract description 149
- 239000000872 buffer Substances 0.000 claims abstract description 108
- 238000000034 method Methods 0.000 claims description 33
- 238000012544 monitoring process Methods 0.000 claims description 20
- 238000004891 communication Methods 0.000 claims description 9
- 239000012146 running buffer Substances 0.000 claims description 9
- 239000004973 liquid crystal related substance Substances 0.000 claims description 8
- 230000002159 abnormal effect Effects 0.000 claims description 7
- 238000013507 mapping Methods 0.000 claims description 6
- 238000010586 diagram Methods 0.000 description 6
- 238000012423 maintenance Methods 0.000 description 5
- 238000002955 isolation Methods 0.000 description 3
- 230000003139 buffering effect Effects 0.000 description 2
- 238000013523 data management Methods 0.000 description 2
- 238000011084 recovery Methods 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000013499 data model Methods 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 238000002474 experimental method Methods 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000002035 prolonged effect Effects 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/21—Design, administration or maintenance of databases
-
- 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/252—Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Abstract
The invention relates to a data source management method, equipment and a storage medium, wherein the data source management method is applied to a data source management system, the data source management system is connected with a user side, and the data source management system comprises the following components: the data source management method comprises the following steps of: querying whether a tenant database data source corresponding to the user side exists in the operation buffer area through a section component; if the operation cache area has the tenant database data sources, detecting whether the user is associated with a plurality of tenant database data sources or not based on the connection point information; if the user side is not associated with a plurality of tenant database data sources, connecting the user side to a tenant database corresponding to the tenant database data sources; if the user side is associated with a plurality of tenant database data sources, acquiring switching notes of access actions of the user side, and connecting the user side to a tenant database corresponding to the note data source corresponding to the switching notes. The invention reduces the cost of data source management and ensures the safety of the data source management.
Description
Technical Field
The present invention relates to the field of database technologies, and in particular, to a method, an apparatus, and a storage medium for managing a data source.
Background
At present, the multi-tenant-based multi-data source management system mainly has three schemes, namely:
the independent database, namely one database of one tenant, can provide independent databases for different tenants, is beneficial to simplifying the expansion design of a data model and meets the unique requirements of different tenants; if a fault occurs, the recovery data is simpler. The data is completely isolated, the security is the best, but the cost is higher.
The shared database is shared with independent schemes (modes), i.e. multiple or all tenants share the database, but one scheme is used for each tenant, and this scheme provides a certain degree of logic data isolation for tenants with higher security requirements, and each database can support more tenants, but this scheme is not completely isolated, so that if a fault occurs, data recovery is difficult, because recovering the database involves data of other tenants.
The shared database, the shared Schema and the shared data table, namely, tenants share the same database and the same Schema, which is the mode with the highest sharing degree and the lowest isolation level.
In the case of data source management using the above scheme, it is often difficult to achieve both security and low cost.
Disclosure of Invention
The invention mainly aims to provide a data source management method, a device, equipment and a computer readable storage medium, which aim to reduce the cost of data source management and ensure the safety of the data source management.
In order to achieve the above object, the present invention provides a data source management method, which is applied to a data source management system, the data source management system is connected with a user terminal, and the data source management system includes: the method comprises the steps of running a cache area, a section assembly and a main database; the main database comprises a plurality of tenant databases, and data services of the tenant databases are isolated from each other;
the data source management method comprises the following steps:
when an access request sent by a user terminal is received, inquiring whether a tenant database data source corresponding to the user terminal exists in the operation buffer area through the section component;
if the tenant database data sources exist in the operation cache area, analyzing the connection point of the user side through the section component to obtain connection point information, and detecting whether the user side is associated with a plurality of tenant database data sources or not based on the connection point information, wherein the connection point information comprises an object and parameter information of a target method for executing access operation on the main database;
If the user side is not associated with a plurality of tenant database data sources, the user side is connected to a tenant database corresponding to the tenant database data sources through the section component;
and if the user side is associated with a plurality of tenant database data sources, acquiring a switching annotation of the access action of the user side through the section component, and connecting the user side to a tenant database corresponding to the annotation data source corresponding to the switching annotation through the section component.
Optionally, the step of connecting, by the facet component, the user side to the tenant database corresponding to the annotation data source corresponding to the handover annotation includes:
inquiring whether an annotation data source corresponding to the switching annotation is in the operation cache region or not through the section component;
and if the annotation data source is in the operation cache region, connecting the user terminal to a tenant database corresponding to the annotation data source corresponding to the switching annotation through the section component.
Optionally, before the step of querying, by the facet component, whether the operation buffer has a tenant database data source corresponding to the user side, the data source management method further includes:
Connecting the user side to the main database;
analyzing the access request through the section component to obtain a user end identifier;
the step of querying, by the facet component, whether a tenant database data source corresponding to the user side exists in the operation buffer area includes:
and inquiring whether a tenant database data source corresponding to the user terminal identifier exists in the operation buffer area or not through the section component according to the user terminal identifier.
Optionally, after the step of querying, by the facet component, whether the operation buffer has the tenant database data source corresponding to the user side, the data source management method further includes:
if the tenant database data source does not exist in the operation cache area, creating a new data source through the section component;
and loading the new data source to the operation buffer area when the new data source is communicated normally, and connecting the user side to a tenant database corresponding to the new data source.
Optionally, before the step of loading the new data source into the operation buffer when the new data source is connected normally, the data source management method further includes:
Detecting whether the newly built data source is normally communicated;
after the step of detecting whether the newly-built data source is connected normally, the data source management method further includes:
and if the newly-built data source is abnormal in communication, connecting the user terminal to the main database.
Optionally, the data source management system further includes a data source monitoring component, and the running buffer area configures a buffer algorithm;
the data source management method further comprises the following steps:
detecting whether the data quantity of the data source in the operation buffer area reaches a preset threshold value or not through the data source monitoring component;
and if the data quantity of the data source reaches the preset threshold value, updating the operation buffer area according to the buffer algorithm.
Optionally, the data source management system further comprises: switching the annotation component, the data source management component and the runtime thread component; wherein, the liquid crystal display device comprises a liquid crystal display device,
the switching annotation component is used for defining the key attribute of the data source of the tenant library and marking the annotation of multiple data sources;
the data source management component is used for managing the key value pair mapping attribute and the main data source object attribute of the tenant database data source key and the tenant database data source object;
the runtime thread component is configured to hold a tenant database data source key that is currently being operated by a thread.
In addition, in order to achieve the above object, the present invention further provides a data source management device, which is applied to a data source management system, the data source management system is connected to a client, and the data source management system includes: the method comprises the steps of running a cache area, a section assembly and a main database; the main database comprises a plurality of tenant databases, and data services of the tenant databases are isolated from each other;
the data source management device includes:
the first calling module is used for inquiring whether a tenant database data source corresponding to the user side exists in the operation cache region or not through the section component when an access request sent by the user side is received;
the second calling module is used for analyzing the connection point of the user terminal through the section component to obtain connection point information if the tenant database data source exists in the operation cache region, and detecting whether the user terminal is associated with a plurality of tenant database data sources or not based on the connection point information, wherein the connection point information comprises an object and parameter information of a target method for executing access operation on the main database;
the third calling module is used for connecting the user side to the tenant database corresponding to the tenant database data sources through the section component if the user side is not associated with a plurality of tenant database data sources;
And the fourth calling module is used for acquiring the switching annotation of the access action of the user terminal through the section component and connecting the user terminal to the tenant database corresponding to the annotation data source corresponding to the switching annotation through the section component if the user terminal is associated with a plurality of tenant database data sources.
In addition, in order to achieve the above object, the present invention also provides a data source management device, which includes a memory, a processor, and a data source management program stored on the memory and executable on the processor, wherein the data source management program implements the steps of the data source management method when executed by the processor.
In addition, in order to achieve the above object, the present invention also provides a computer-readable storage medium having stored thereon a data source management program which, when executed by a processor, implements the steps of the above-described data source management method.
In the invention, a data source management system is connected with a user terminal, and the data source management system comprises: the system comprises an operation buffer area, a section component and a main database, wherein the main database comprises a plurality of tenant databases, and data services of the tenant databases are isolated from each other. In the invention, the main database in the data source management system comprises a plurality of tenant databases, and the data services of the tenant databases are isolated from each other, so that the data among the tenants can not be influenced, and the security of the data source management system is maintained.
In the invention, when an access request sent by a user terminal is received, whether a tenant database data source corresponding to the user terminal exists in an operation buffer area is inquired through a section component; if the operation cache area has the tenant database data sources, analyzing the connection points of the user side through the section component to obtain connection point information, and detecting whether the user side is associated with a plurality of tenant database data sources or not based on the connection point information, wherein the connection point information comprises an object and parameter information of a target method for executing access operation on a main database; if the user side is not associated with a plurality of tenant database data sources, the user side is connected to the tenant database corresponding to the tenant database data sources through the section cutting component; if the user side is associated with a plurality of tenant database data sources, the switching annotation of the access action of the user side is obtained through the section component, and the user side is connected to the tenant database corresponding to the annotation data source corresponding to the switching annotation through the section component.
Compared with the method for directly inquiring the database by each access, the method for inquiring the database by the operation buffer area can access the operation buffer area preferentially, saves resources, reduces the use cost of the server, prevents the database from being damaged when the access user quantity is large, prolongs the service life of the database, and reduces the maintenance cost of the server, thereby reducing the data management cost.
Meanwhile, when the user side is associated with a plurality of tenant database data sources, the switching annotation of the access action of the user side is obtained through the section component, and the user side is connected to the tenant database corresponding to the annotation data source corresponding to the switching annotation through the section component, so that the situation that the user side cannot access due to the fact that the user side is connected with the plurality of data sources is avoided, and the success rate of accessing the server is improved.
Drawings
FIG. 1 is a flowchart of a first embodiment of a data source management method according to the present invention;
FIG. 2 is a schematic functional block diagram of a data source management device according to an embodiment of the present invention;
FIG. 3 is a schematic structural diagram of a data source management device according to an embodiment of the present invention;
fig. 4 is a schematic structural diagram of a computer-readable storage medium according to an embodiment of the present invention.
The achievement of the objects, functional features and advantages of the present invention will be further described with reference to the accompanying drawings, in conjunction with the embodiments.
Detailed Description
It should be understood that the specific embodiments described herein are for purposes of illustration only and are not intended to limit the scope of the invention.
The embodiment of the invention provides a data source management system, which is connected with a user side and comprises: the system comprises an operation buffer area, a section component and a main database.
Specifically, in this embodiment, the master database includes a plurality of tenant databases, and one tenant database corresponds to one tenant ID (Identity Document, identity). The main database is used for storing public data of each tenant database, and data services of each tenant database are isolated from each other. Further, in the specific embodiment, the master database may also include a tenant database, which is not limited herein.
In this embodiment, by using two modes of independent databases and shared databases and independent Schema, the embodiment provides a certain degree of logic data isolation for tenants with higher security requirements, and each database can support more tenants.
In a specific embodiment, the operation buffer area is used for buffering the tenant database data source, and is used for querying whether the tenant database data source corresponding to the user side exists in the operation buffer area through the section component when the access request sent by the user side is received.
Further, in an embodiment, if the operation buffer area has a tenant database data source, the user side may be connected to the tenant database corresponding to the tenant database data source through the facet component; in another embodiment, if the operation buffer area does not have the tenant database data source, a new data source can be created through the section component, the new data source is loaded to the operation buffer area when the new data source is communicated normally, and the user side is connected to the tenant database corresponding to the new data source.
Further, in some possible embodiments, the data source management system further includes a data source monitoring component, in this embodiment, running a cache area configuration caching algorithm.
Specifically, in this embodiment, the data source monitoring component is configured to detect whether the data amount of the data source in the running buffer area reaches a preset threshold.
In this embodiment, the caching algorithm may automatically reject or reserve as needed according to the access heat of the data source of the tenant library in the operation cache area, so as to update the operation cache area. In a specific embodiment, if the data source monitoring component is configured to detect that the data amount of the data source in the operation buffer area reaches a preset threshold, the operation buffer area may be updated by a buffering algorithm.
Further, after the running buffer area is updated, the tenant database data source can be queried in the updated running buffer area.
It should be noted that in this embodiment, the data source management system further includes a data source monitoring component, and a cache area configuration cache algorithm is executed. And detecting whether the data quantity of the data source in the operation buffer area reaches a preset threshold value or not through the data source monitoring component, and if the data quantity of the data source reaches the preset threshold value, updating the operation buffer area according to a buffer algorithm. The embodiment realizes that the cold data source which is not accessed for a long time does not exist in the operation buffer area, can maintain the performance of the operation buffer area, avoids the occurrence of faults caused by excessive occupation of the data of the operation buffer area, and improves the working performance of the data source management system.
Further, in some possible embodiments, the data source management system further comprises: a switch annotation component, a data source management component, and a runtime thread component. Specifically, the switch annotation component is used for defining tenant database data source key attributes and for marking multi-data source annotations. The data source management component is used for managing key value pair mapping attributes and main data source object attributes of the tenant database data source key and the tenant database data source object. The runtime thread component is used to hold the tenant database data source key that the current thread is operating on.
It should be noted that, in this embodiment, the annotation component, the data source management component and the runtime thread component are switched to manage the tenant database data source, so as to maintain the order of accessing the tenant database data source by the user side, and ensure the performance of the data source management system.
In this embodiment, the main database in the data source management system includes a plurality of tenant databases, and respective data services of the tenant databases are isolated from each other, so that data among the tenants cannot be affected mutually, and security of the data source management system is maintained.
Meanwhile, the operation buffer area is arranged in the data source management system, so that compared with the case that the database is directly queried every time of access, the operation buffer area can be accessed preferentially in the embodiment, resources are saved, and the use cost of the server is reduced. And when the access user quantity is large, the batch operation databases generally cause the loading of the databases to be full, but the data source management system of the embodiment avoids damaging the databases when the access user quantity is large by running the buffer area, prolongs the service life of the databases and reduces the maintenance cost of the server.
Based on the data source management system, a first embodiment of the data source management method of the present invention is provided. Referring to fig. 1, fig. 1 is a flowchart of a first embodiment of a data source management method according to the present invention.
Reference will now be made in detail to exemplary embodiments, examples of which are illustrated in the accompanying drawings. When the following description refers to the accompanying drawings, the same numbers in different drawings refer to the same or similar elements, unless otherwise indicated. The implementations described in the following exemplary examples are not representative of all implementations consistent with the present application.
In this embodiment, the data source management method according to the embodiment of the present invention may be performed by a terminal device, for example, a PC (Personal Computer ), a tablet computer, a portable computer, or the like, and the description of the execution body is omitted for convenience of description.
Specifically, in this embodiment, the data source management system is connected to the user side, where the data source management system includes: the system comprises an operation buffer area, a section component and a main database. The main database comprises a plurality of tenant databases, and data services of the tenant databases are isolated from each other.
The data source management method of the embodiment comprises the following steps:
Step S10: when an access request sent by a user terminal is received, inquiring whether a tenant database data source corresponding to the user terminal exists in the operation buffer area through the section component;
in this embodiment, the user may send the access request through the user side. Specifically, in this embodiment, when an access request sent by a user terminal is received, whether a tenant database data source corresponding to the user terminal exists in the operation buffer area is queried through the section component.
Specifically, the basis of querying the tenant database data source is not limited herein, for example, in an embodiment, the access request may carry information of the tenant database, and in this embodiment, whether the tenant database data source corresponding to the user side exists in the operation buffer area may be queried by the section component according to the access request; in another embodiment, the access request may carry a user terminal identifier, and in this embodiment, according to the user terminal identifier, the section component may also query whether a tenant database data source corresponding to the user terminal exists in the operation buffer area, and specifically may be set according to actual requirements.
Step S20: if the tenant database data sources exist in the operation cache area, analyzing the connection point of the user side through the section component to obtain connection point information, and detecting whether the user side is associated with a plurality of tenant database data sources or not based on the connection point information, wherein the connection point information comprises an object and parameter information of a target method for executing access operation on the main database;
In this embodiment, when an access request sent by a user terminal is received, whether a tenant database data source corresponding to the user terminal exists in the operation buffer area is queried through the section component. If the operation cache region has the tenant database data source corresponding to the user side, the user side can be connected to the tenant database corresponding to the tenant database data source through the section component.
In this embodiment, before the user terminal is connected to the tenant database corresponding to the tenant database data source through the facet component, the facet component may analyze information of a connection point of the user terminal (hereinafter referred to as connection point information to show distinction), and detect whether the user terminal is associated with a plurality of tenant database data sources, where the connection point information may specifically include an object and parameter information to which a target method for performing an access operation on the database belongs.
Specifically, in this embodiment, after the connection point of the user terminal is parsed by the section component to obtain connection point information, whether the user terminal is associated with a plurality of tenant database data sources is detected based on the connection point information.
Step S30: if the user side is not associated with a plurality of tenant database data sources, the user side is connected to a tenant database corresponding to the tenant database data sources through the section component;
In this embodiment, if the user side is not associated with multiple tenant database data sources, the user side is connected to the tenant database corresponding to the tenant database data sources through the facet component.
Step S40: and if the user side is associated with a plurality of tenant database data sources, acquiring a switching annotation of the access action of the user side through the section component, and connecting the user side to a tenant database corresponding to the annotation data source corresponding to the switching annotation through the section component.
In this embodiment, before the user terminal is connected to the tenant database corresponding to the tenant database data source through the facet component, the connection point of the user terminal is analyzed through the facet component to obtain the connection point information. And detecting whether the user side is associated with a plurality of tenant database data sources or not based on the connection point information. Specifically, in this embodiment, if the user side is associated with a plurality of tenant database data sources, the switching annotation of the access action of the user side is obtained through the facet component, and the user side is connected to the tenant database corresponding to the annotation data source corresponding to the switching annotation through the facet component.
In an exemplary embodiment, the data source management system may be a database corresponding to a tenant database in the data source management system and used for each hospital, and when the user side needs to access the hospital database, the section component queries whether the data source of the hospital database corresponding to the user side exists in the operation buffer area; if the data sources of the hospital databases exist in the operation cache area, analyzing the connection points of the user side through the section component to obtain connection point information, and detecting whether the user side is associated with the data sources of a plurality of hospital databases or not based on the connection point information; if the user side is not associated with the data sources of the plurality of hospital databases, the user side is connected to the hospital database corresponding to the data sources of the hospital databases through the section component so as to query, in a specific embodiment, the user side can query the information of the individual doctor, and can also query the relevant information of the on-site experiment by a doctor; if the user side is associated with the data sources of the plurality of hospital databases, the switching annotation of the access action of the user side is obtained through the section component, and the user side is connected to the hospital database corresponding to the annotation data source corresponding to the switching annotation through the section component. In this embodiment, the security of medical data is improved by the independent tenant database. By setting the operation buffer area, the operation buffer area can be accessed preferentially in the embodiment, so that resources are saved, the use cost of the server is reduced, the operation buffer area avoids damaging the database when a large number of access users are accessed, the service life of the database is prolonged, and the maintenance cost of the server is reduced, thereby reducing the medical data management cost.
Further, in some possible embodiments, step S40 described above: connecting the user terminal to the tenant database corresponding to the annotation data source corresponding to the switching annotation through a section component may include:
step S401: inquiring whether an annotation data source corresponding to the switching annotation is in the operation cache region or not through the section component;
in this embodiment, whether the user side is associated with a plurality of tenant library data sources is detected based on the connection point information. Specifically, in this embodiment, if the user side is associated with a plurality of tenant database data sources, the switching annotation of the access action of the user side is obtained through the facet component, and the user side is connected to the tenant database corresponding to the annotation data source corresponding to the switching annotation through the facet component.
Specifically, in this embodiment, the section component queries whether the annotation data source corresponding to the switch annotation is running in the buffer.
Step S402: and if the annotation data source is in the operation cache region, connecting the user terminal to a tenant database corresponding to the annotation data source corresponding to the switching annotation through the section component.
In this embodiment, the section component queries whether the annotation data source corresponding to the switch annotation is in the running buffer. If the annotation data source is in the operation buffer area, the user side is connected to the tenant database corresponding to the annotation data source corresponding to the switching annotation through the section component.
Further, in an embodiment, the section component queries whether the annotation data source corresponding to the switch annotation is running in the buffer. If the annotation data source is not in the operation buffer area, a new data source is created through the section component.
In this embodiment, the main database in the data source management system includes a plurality of tenant databases, and respective data services of the tenant databases are isolated from each other, so that data among the tenants cannot be affected mutually, and security of the data source management system is maintained.
In this embodiment, when an access request sent by a user terminal is received, a section component is used to query whether a tenant database data source corresponding to the user terminal exists in an operation buffer area; if the operation cache area has the tenant database data sources, analyzing the connection points of the user side through the section component to obtain connection point information, and detecting whether the user side is associated with a plurality of tenant database data sources or not based on the connection point information, wherein the connection point information comprises an object and parameter information of a target method for executing access operation on a main database; if the user side is not associated with a plurality of tenant database data sources, the user side is connected to the tenant database corresponding to the tenant database data sources through the section cutting component; if the user side is associated with a plurality of tenant database data sources, the switching annotation of the access action of the user side is obtained through the section component, and the user side is connected to the tenant database corresponding to the annotation data source corresponding to the switching annotation through the section component.
Compared with the method that the database is directly queried every time of access, the method and the device have the advantages that the operation buffer area is arranged in the data source management system, and the operation buffer area can be accessed preferentially, so that resources are saved, and the use cost of a server is reduced.
And when the access user quantity is large, the batch operation databases generally cause the loading of the databases to be full, but the data source management system of the embodiment avoids damaging the databases when the access user quantity is large by running the buffer area, prolongs the service life of the databases and reduces the maintenance cost of the server.
In addition, when the user side is associated with a plurality of tenant database data sources, the embodiment obtains the switching annotation of the access action of the user side through the section component, and connects the user side to the tenant database corresponding to the annotation data source corresponding to the switching annotation through the section component, so that the situation that the user side cannot access due to the connection of the plurality of data sources is avoided, and the success rate of accessing the server is improved.
Further, based on the above-described first embodiment, a second embodiment of the present invention is proposed, and in this embodiment, in step S10 described above: before inquiring whether the tenant database data source corresponding to the user side exists in the operation buffer area through the section component, the data source management method further comprises the following steps:
Step S50: connecting the user side to the main database;
in this embodiment, before querying whether a tenant database data source corresponding to the user terminal exists in the operation buffer area through the section component, in order to avoid returning wrong connection information of the user terminal, the user terminal is first connected to the main database.
Step S60: analyzing the access request through the section component to obtain a user end identifier;
in this embodiment, after the user terminal is connected to the main database, the access request is parsed by the section component to obtain the user terminal identifier.
In a specific embodiment, the user end identifier is an identifier capable of characterizing the user end identity, and specifically, the user end identifier may be a user end address, a user end IP, a user end port, a user ID and a user password.
Step S10 described above: the querying, by the facet component, whether a tenant database data source corresponding to the user side exists in the operation buffer area may include:
step S101: and inquiring whether a tenant database data source corresponding to the user terminal identifier exists in the operation buffer area or not through the section component according to the user terminal identifier.
In this embodiment, after the access request is parsed by the section component to obtain the user terminal identifier, the section component queries whether the tenant database data source corresponding to the user terminal identifier exists in the operation buffer area according to the user terminal identifier.
It should be noted that, in this embodiment, before querying, by the section component, whether a tenant database data source corresponding to the user side exists in the operation buffer area, the user side is first connected to the main database, and after the section component analyzes the access request to obtain the user side identifier, the section component queries, according to the user side identifier, whether the tenant database data source corresponding to the user side identifier exists in the operation buffer area. The embodiment avoids returning wrong connection information of the user side and keeps the experience of the user accessing the database.
Further, in some possible embodiments, step S10 above: after inquiring whether the tenant database data source corresponding to the user side exists in the operation buffer area through the section component, the method further comprises the following steps:
step S70: if the tenant database data source does not exist in the operation cache area, creating a new data source through the section component;
in this embodiment, whether a tenant database data source corresponding to the user side exists in the operation buffer area is queried through the section component. Specifically, if the operation buffer area does not have the tenant database data source corresponding to the user side, a new data source is created through the section component.
In a specific embodiment, the operation cache region does not have a tenant database corresponding to the user side, and it may be that a tenant database data source of the tenant database corresponding to the user side is not loaded to the operation cache region, or it may be that a tenant database is not created in the main database.
Step S80: and loading the new data source to the operation buffer area when the new data source is communicated normally, and connecting the user side to a tenant database corresponding to the new data source.
In this embodiment, if the operation buffer area does not have the tenant database data source corresponding to the user side, a new data source is created through the section component.
Specifically, when the connection of the new data source is normal, the new data source is loaded to the operation buffer, and the user terminal is connected to the tenant database corresponding to the new data source.
Further, in some possible embodiments, in step S80 described above: before the new data source is loaded to the operation buffer area when the new data source is communicated normally, the data source management method further comprises the following steps:
step S90: detecting whether the newly built data source is normally communicated;
if the operation buffer area does not have the tenant database data source corresponding to the user side, creating a new data source through the section component. In this embodiment, before loading the new data source into the operation buffer, it is detected whether the new data source is normally connected.
In a specific embodiment, it may be detected whether the user information carried in the access request is consistent with the information of the tenant database in the data pool maintained by the newly-built data source, and specifically, the user information may be a user ID, a password, a user address, a user port, and the like. If the user information carried in the access request is consistent with the information of the tenant database in the data pool maintained by the new data source, the normal connection of the new data source can be determined; if the user information carried in the access request is inconsistent with the information of the tenant database in the data pool maintained by the new data source, determining that the new data source is abnormal in connection.
Step S90 described above: after detecting whether the newly built data source is communicated normally, the data source management method further comprises the following steps:
step A10: and if the newly-built data source is abnormal in communication, connecting the user terminal to the main database.
In this embodiment, whether the connection of the new data source is normal is detected, and if the connection of the new data source is abnormal, the user terminal is connected to the main database, so that an error of accessing the database by the user terminal can be avoided.
Further, in some possible embodiments, the data source management system further includes a data source monitoring component, running a cache area configuration cache algorithm, and the data source management method further includes:
Step A20: detecting whether the data quantity of the data source in the operation buffer area reaches a preset threshold value or not through the data source monitoring component;
in this embodiment, the data source management system further includes a data source monitoring component, where the data source monitoring component is configured to detect whether a data amount of a data source in the running buffer area reaches a preset threshold.
Specifically, in this embodiment, the data source monitoring component detects whether the data amount of the data source in the running buffer area reaches a preset threshold.
Step A30: and if the data quantity of the data source reaches the preset threshold value, updating the operation buffer area according to the buffer algorithm.
In this embodiment, the operation buffer area is configured with a buffer algorithm, where the buffer algorithm is configured to automatically reject or reserve the data source of the operation buffer area as needed according to the access heat of the data source of the tenant library, so as to update the operation buffer area and maintain the performance of the operation buffer area.
Specifically, the data source monitoring component detects whether the data amount of the data source in the operation buffer area reaches a preset threshold value. In this embodiment, if the data amount of the data source reaches the preset threshold, the running buffer area is updated according to the buffer algorithm.
It should be noted that in this embodiment, the data source management system further includes a data source monitoring component, and a cache area configuration cache algorithm is executed. And detecting whether the data quantity of the data source in the operation buffer area reaches a preset threshold value or not through the data source monitoring component, and if the data quantity of the data source reaches the preset threshold value, updating the operation buffer area according to a buffer algorithm. The embodiment realizes that the cold data source which is not accessed for a long time does not exist in the operation buffer area, can maintain the performance of the operation buffer area, avoids the occurrence of faults caused by excessive occupation of the data of the operation buffer area, and improves the working performance of the data source management system.
Further, in some possible embodiments, the data source management system further comprises: a switch annotation component, a data source management component, and a runtime thread component. Specifically, the switch annotation component is used for defining tenant database data source key attributes and for marking multi-data source annotations. The data source management component is used for managing key value pair mapping attributes and main data source object attributes of the tenant database data source key and the tenant database data source object. The runtime thread component is used to hold the tenant database data source key that the current thread is operating on.
It should be noted that, in this embodiment, the annotation component, the data source management component and the runtime thread component are switched to manage the tenant database data source, so as to maintain the order of accessing the tenant database data source by the user side, and ensure the performance of the data source management system.
In this embodiment, the access request is parsed by the section component to obtain the user end identifier, and the section component queries whether the tenant database data source corresponding to the user end identifier exists in the operation buffer area according to the user end identifier.
Compared with the method that the database is directly queried every time of access, the method and the device have the advantages that the operation buffer area is arranged in the data source management system, and the operation buffer area can be accessed preferentially, so that resources are saved, and the use cost of a server is reduced.
And when the access user quantity is large, the batch operation databases generally cause the loading of the databases to be full, but the data source management system of the embodiment avoids damaging the databases when the access user quantity is large by running the buffer area, prolongs the service life of the databases and reduces the maintenance cost of the server.
In addition, the invention also provides a data source management device, which is applied to a data source management system, wherein the data source management system is connected with a user side, and the data source management system comprises: the method comprises the steps of running a cache area, a section assembly and a main database; the main database comprises a plurality of tenant databases, and data services of the tenant databases are isolated from each other;
Specifically, referring to fig. 2, fig. 2 is a schematic functional block diagram of a data source management device according to an embodiment of the present invention, where the data source management device includes:
the first calling module is used for inquiring whether a tenant database data source corresponding to the user side exists in the operation cache region or not through the section component when an access request sent by the user side is received;
the second calling module is used for analyzing the connection point of the user terminal through the section component to obtain connection point information if the tenant database data source exists in the operation cache region, and detecting whether the user terminal is associated with a plurality of tenant database data sources or not based on the connection point information, wherein the connection point information comprises an object and parameter information of a target method for executing access operation on the main database;
the third calling module is used for connecting the user side to the tenant database corresponding to the tenant database data sources through the section component if the user side is not associated with a plurality of tenant database data sources;
and the fourth calling module is used for acquiring the switching annotation of the access action of the user terminal through the section component and connecting the user terminal to the tenant database corresponding to the annotation data source corresponding to the switching annotation through the section component if the user terminal is associated with a plurality of tenant database data sources.
Further, the fourth calling module 40 is further configured to:
inquiring whether an annotation data source corresponding to the switching annotation is in the operation cache region or not through the section component;
and if the annotation data source is in the operation cache region, connecting the user terminal to a tenant database corresponding to the annotation data source corresponding to the switching annotation through the section component.
Further, the data source management device further includes a fifth calling module, where the fifth calling module is configured to:
connecting the user side to the main database;
analyzing the access request through the section component to obtain a user end identifier;
the first calling module 10 is further configured to:
and inquiring whether a tenant database data source corresponding to the user terminal identifier exists in the operation buffer area or not through the section component according to the user terminal identifier.
Further, the data source management device further includes a sixth calling module, where the sixth calling module is configured to:
if the tenant database data source does not exist in the operation cache area, creating a new data source through the section component;
and loading the new data source to the operation buffer area when the new data source is communicated normally, and connecting the user side to a tenant database corresponding to the new data source.
Further, the data source management device further includes a seventh calling module, where the seventh calling module is configured to:
detecting whether the newly built data source is normally communicated;
the sixth calling module is further configured to:
and if the newly-built data source is abnormal in communication, connecting the user terminal to the main database.
Further, the data source management system further comprises a data source monitoring component, and the data source management device further comprises an eighth calling module, wherein the eighth calling module is used for:
detecting whether the data quantity of the data source in the operation buffer area reaches a preset threshold value or not through the data source monitoring component;
and if the data quantity of the data source reaches the preset threshold value, updating the operation buffer area according to the buffer algorithm.
Further, the data source management system further includes: switching the annotation component, the data source management component and the runtime thread component; wherein, the liquid crystal display device comprises a liquid crystal display device,
the switching annotation component is used for defining the key attribute of the data source of the tenant library and marking the annotation of multiple data sources;
the data source management component is used for managing the key value pair mapping attribute and the main data source object attribute of the tenant database data source key and the tenant database data source object;
The runtime thread component is configured to hold a tenant database data source key that is currently being operated by a thread.
Wherein each functional module of the data source management device realizes the steps of the data source management method when each functional module runs.
In addition, the invention also provides a data source management device. Referring to fig. 3, fig. 3 is a schematic structural diagram of a data source management device according to an embodiment of the present invention. The data source management device in the embodiment of the invention can be specifically a device for locally operating a data source management system.
As shown in fig. 3, the data source management device according to an embodiment of the present invention may include: a processor 1001, such as a CPU, a communication bus 1002, a user interface 1003, a network interface 1004, and a memory 1005. Wherein the communication bus 1002 is used to enable connected communication between these components. The user interface 1003 may include a Display, an input unit such as a Keyboard (Keyboard), and the optional user interface 1003 may further include a standard wired interface, a wireless interface. The network interface 1004 may optionally include a standard wired interface, a wireless interface (e.g., wi-Fi interface).
A memory 1005 is provided on the data source management apparatus main body, and a program is stored in the memory 1005, which when executed by the processor 1001, realizes the corresponding operation. The memory 1005 is also used to store parameters for use by the data source management device. The memory 1005 may be a high-speed RAM memory or a stable memory (non-volatile memory), such as a disk memory. The memory 1005 may also optionally be a storage device separate from the processor 1001 described above.
It will be appreciated by those skilled in the art that the data source management device structure shown in fig. 3 is not limiting of the data source management device and may include more or fewer components than shown, or may combine certain components, or a different arrangement of components.
As shown in fig. 3, an operating system, a network communication module, a user interface module, and a data source management program may be included in the memory 1005 as one type of storage medium.
In the data source management device shown in fig. 3, a processor 1001 may be used to call a data source management program stored in a memory 1005 and perform the following operations:
when an access request sent by a user terminal is received, inquiring whether a tenant database data source corresponding to the user terminal exists in the operation buffer area through the section component;
if the tenant database data sources exist in the operation cache area, analyzing the connection point of the user side through the section component to obtain connection point information, and detecting whether the user side is associated with a plurality of tenant database data sources or not based on the connection point information, wherein the connection point information comprises an object and parameter information of a target method for executing access operation on the main database;
If the user side is not associated with a plurality of tenant database data sources, the user side is connected to a tenant database corresponding to the tenant database data sources through the section component;
and if the user side is associated with a plurality of tenant database data sources, acquiring a switching annotation of the access action of the user side through the section component, and connecting the user side to a tenant database corresponding to the annotation data source corresponding to the switching annotation through the section component.
Further, the processor 1001 may be further configured to call a data source management program stored in the memory 1005, and perform the following operations:
inquiring whether an annotation data source corresponding to the switching annotation is in the operation cache region or not through the section component;
and if the annotation data source is in the operation cache region, connecting the user terminal to a tenant database corresponding to the annotation data source corresponding to the switching annotation through the section component.
Further, the processor 1001 may be further configured to call a data source management program stored in the memory 1005, and perform the following operations:
connecting the user side to the main database;
analyzing the access request through the section component to obtain a user end identifier;
The operation of querying, by the facet component, whether a tenant database data source corresponding to the user side exists in the operation cache region includes:
and inquiring whether a tenant database data source corresponding to the user terminal identifier exists in the operation buffer area or not through the section component according to the user terminal identifier.
Further, the processor 1001 may be further configured to call a data source management program stored in the memory 1005, and perform the following operations:
if the tenant database data source does not exist in the operation cache area, creating a new data source through the section component;
and loading the new data source to the operation buffer area when the new data source is communicated normally, and connecting the user side to a tenant database corresponding to the new data source.
Further, the processor 1001 may be further configured to call a data source management program stored in the memory 1005, and perform the following operations:
detecting whether the newly built data source is normally communicated;
after the detecting whether the newly built data source is communicated with normal operation, the method further comprises the following steps:
and if the newly-built data source is abnormal in communication, connecting the user terminal to the main database.
Further, the processor 1001 may be further configured to call a data source management program stored in the memory 1005, and perform the following operations:
detecting whether the data quantity of the data source in the operation buffer area reaches a preset threshold value or not through the data source monitoring component;
and if the data quantity of the data source reaches the preset threshold value, updating the operation buffer area according to the buffer algorithm.
Further, the data source management system further includes: switching the annotation component, the data source management component and the runtime thread component; wherein, the liquid crystal display device comprises a liquid crystal display device,
the switching annotation component is used for defining the key attribute of the data source of the tenant library and marking the annotation of multiple data sources;
the data source management component is used for managing the key value pair mapping attribute and the main data source object attribute of the tenant database data source key and the tenant database data source object;
the runtime thread component is configured to hold a tenant database data source key that is currently being operated by a thread.
The data source management device performs the steps of the data source management method as described above when running.
Furthermore, the invention also provides a computer readable storage medium. Referring to fig. 4, fig. 4 is a schematic structural diagram of a computer-readable storage medium according to an embodiment of the present invention. The computer readable storage medium has stored thereon a data source management program which, when executed by a processor, performs the steps of the data source management method as described above.
It should be noted that, in this document, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or system that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or system. Without further limitation, an element defined by the phrase "comprising one … …" does not exclude the presence of other like elements in a process, method, article, or system that comprises the element.
The foregoing embodiment numbers of the present invention are merely for the purpose of description, and do not represent the advantages or disadvantages of the embodiments.
From the above description of the embodiments, it will be clear to those skilled in the art that the above-described embodiment method may be implemented by means of software plus a necessary general hardware platform, but of course may also be implemented by means of hardware, but in many cases the former is a preferred embodiment. Based on such understanding, the technical solution of the present invention may be embodied essentially or in a part contributing to the prior art in the form of a software product stored in a computer readable storage medium (e.g. ROM/RAM, magnetic disk, optical disk) as described above, comprising instructions for causing a data source management device (which may be a mobile phone, a computer, a server, or a network device, etc.) to perform the method according to the embodiments of the present invention.
The foregoing description is only of the preferred embodiments of the present invention, and is not intended to limit the scope of the invention, but rather is intended to cover any equivalents of the structures or equivalent processes disclosed herein or in the alternative, which may be employed directly or indirectly in other related arts.
Claims (10)
1. The data source management method is characterized in that the data source management method is applied to a data source management system, the data source management system is connected with a user side, and the data source management system comprises: the method comprises the steps of running a cache area, a section assembly and a main database; the main database comprises a plurality of tenant databases, and data services of the tenant databases are isolated from each other;
the data source management method comprises the following steps:
when an access request sent by a user terminal is received, inquiring whether a tenant database data source corresponding to the user terminal exists in the operation buffer area through the section component;
if the tenant database data sources exist in the operation cache area, analyzing the connection point of the user side through the section component to obtain connection point information, and detecting whether the user side is associated with a plurality of tenant database data sources or not based on the connection point information, wherein the connection point information comprises an object and parameter information of a target method for executing access operation on the main database;
If the user side is not associated with a plurality of tenant database data sources, the user side is connected to a tenant database corresponding to the tenant database data sources through the section component;
and if the user side is associated with a plurality of tenant database data sources, acquiring a switching annotation of the access action of the user side through the section component, and connecting the user side to a tenant database corresponding to the annotation data source corresponding to the switching annotation through the section component.
2. The data source management method according to claim 1, wherein the step of connecting the user terminal to the tenant database corresponding to the annotation data source corresponding to the handover annotation through the facet component comprises:
inquiring whether an annotation data source corresponding to the switching annotation is in the operation cache region or not through the section component;
and if the annotation data source is in the operation cache region, connecting the user terminal to a tenant database corresponding to the annotation data source corresponding to the switching annotation through the section component.
3. The data source management method according to claim 1, wherein before the step of querying, by the facet component, whether there is a tenant database data source corresponding to the user side in the running cache region, the data source management method further comprises:
Connecting the user side to the main database;
analyzing the access request through the section component to obtain a user end identifier;
the step of querying, by the facet component, whether a tenant database data source corresponding to the user side exists in the operation buffer area includes:
and inquiring whether a tenant database data source corresponding to the user terminal identifier exists in the operation buffer area or not through the section component according to the user terminal identifier.
4. The data source management method according to claim 1, wherein after the step of querying, by the facet component, whether there is a tenant database data source corresponding to the user side in the running cache region, the data source management method further comprises:
if the tenant database data source does not exist in the operation cache area, creating a new data source through the section component;
and loading the new data source to the operation buffer area when the new data source is communicated normally, and connecting the user side to a tenant database corresponding to the new data source.
5. The data source management method according to claim 4, wherein before the step of loading the new data source into the operation buffer when the new data source connection is normal, the data source management method further comprises:
Detecting whether the newly built data source is normally communicated;
after the step of detecting whether the newly-built data source is connected normally, the data source management method further includes:
and if the newly-built data source is abnormal in communication, connecting the user terminal to the main database.
6. The data source management method according to any one of claims 1 to 5, wherein the data source management system further comprises a data source monitoring component, the running buffer configures a buffer algorithm;
the data source management method further comprises the following steps:
detecting whether the data quantity of the data source in the operation buffer area reaches a preset threshold value or not through the data source monitoring component;
and if the data quantity of the data source reaches the preset threshold value, updating the operation buffer area according to the buffer algorithm.
7. The data source management method according to any one of claims 1 to 5, wherein the data source management system further comprises: switching the annotation component, the data source management component and the runtime thread component; wherein, the liquid crystal display device comprises a liquid crystal display device,
the switching annotation component is used for defining the key attribute of the data source of the tenant library and marking the annotation of multiple data sources;
the data source management component is used for managing the key value pair mapping attribute and the main data source object attribute of the tenant database data source key and the tenant database data source object;
The runtime thread component is configured to hold a tenant database data source key that is currently being operated by a thread.
8. A data source management device, the data source management device is applied to a data source management system, the data source management system is connected with a user side, and the data source management system comprises: the method comprises the steps of running a cache area, a section assembly and a main database; the main database comprises a plurality of tenant databases, and data services of the tenant databases are isolated from each other;
the data source management device includes:
the first calling module is used for inquiring whether a tenant database data source corresponding to the user side exists in the operation cache region or not through the section component when an access request sent by the user side is received;
the second calling module is used for analyzing the connection point of the user terminal through the section component to obtain connection point information if the tenant database data source exists in the operation cache region, and detecting whether the user terminal is associated with a plurality of tenant database data sources or not based on the connection point information, wherein the connection point information comprises an object and parameter information of a target method for executing access operation on the main database;
The third calling module is used for connecting the user side to the tenant database corresponding to the tenant database data sources through the section component if the user side is not associated with a plurality of tenant database data sources;
and the fourth calling module is used for acquiring the switching annotation of the access action of the user terminal through the section component and connecting the user terminal to the tenant database corresponding to the annotation data source corresponding to the switching annotation through the section component if the user terminal is associated with a plurality of tenant database data sources.
9. A data source management device, the data source management device comprising: a memory, a processor and a data source management program stored on the memory and executable on the processor, the data source management program being configured to implement the steps of the data source management method of any one of claims 1 to 7.
10. A computer readable storage medium, wherein a data source management program is stored on the computer readable storage medium, which when executed by a processor, implements the steps of the data source management method according to any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310292537.9A CN116401231B (en) | 2023-03-20 | 2023-03-20 | Data source management method, device and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310292537.9A CN116401231B (en) | 2023-03-20 | 2023-03-20 | Data source management method, device and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN116401231A true CN116401231A (en) | 2023-07-07 |
| CN116401231B CN116401231B (en) | 2024-04-26 |
Family
ID=87011576
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202310292537.9A Active CN116401231B (en) | 2023-03-20 | 2023-03-20 | Data source management method, device and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN116401231B (en) |
Citations (14)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20140229422A1 (en) * | 2013-02-13 | 2014-08-14 | Namit Jain | Hive table links |
| CN108667930A (en) * | 2018-05-09 | 2018-10-16 | 聚龙股份有限公司 | A kind of configuration of dynamic data source and automation switching method |
| CN111491012A (en) * | 2020-03-27 | 2020-08-04 | 北京尚医智信健康管理有限公司 | SaaS multi-tenant data isolation access method and device, electronic equipment and storage medium |
| CN112527310A (en) * | 2020-12-15 | 2021-03-19 | 平安国际智慧城市科技股份有限公司 | Multi-tenant data isolation method and device, computer equipment and storage medium |
| CN113535723A (en) * | 2021-07-13 | 2021-10-22 | 杭州安恒信息技术股份有限公司 | Multi-tenant database management and control method, system and storage medium |
| WO2021218328A1 (en) * | 2020-04-28 | 2021-11-04 | 深圳壹账通智能科技有限公司 | Multi-tenant access service implementation method, apparatus and device, and storage medium |
| CN114064781A (en) * | 2021-11-29 | 2022-02-18 | 重庆忽米网络科技有限公司 | Cache mechanism-based multi-tenant data source management method and readable storage medium |
| CN114328626A (en) * | 2021-12-30 | 2022-04-12 | 重庆富民银行股份有限公司 | Multi-data source dynamic switching method, system and storage medium |
| WO2022126968A1 (en) * | 2020-12-15 | 2022-06-23 | 平安科技（深圳）有限公司 | Micro-service access method, apparatus and device, and storage medium |
| US20220245032A1 (en) * | 2021-02-03 | 2022-08-04 | Netapp, Inc. | Methods and systems for protecting multitenant databases in networked storage systems |
| CN115080537A (en) * | 2022-06-07 | 2022-09-20 | 易保网络技术(上海)有限公司 | Multi-tenant data partitioning method, program product and electronic device |
| CN115563125A (en) * | 2022-11-03 | 2023-01-03 | 东方合智数据科技(广东)有限责任公司 | Dictionary agent tangent plane method and related equipment in corrugated paper packaging industry |
| CN115587093A (en) * | 2022-09-29 | 2023-01-10 | 浪潮软件股份有限公司 | System for dynamically expanding tenants in big hall and implementation method |
| CN115620851A (en) * | 2022-12-19 | 2023-01-17 | 一临云(深圳)科技有限公司 | Data verification method and device, electronic equipment and readable storage medium |
-
2023
- 2023-03-20 CN CN202310292537.9A patent/CN116401231B/en active Active
Patent Citations (14)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20140229422A1 (en) * | 2013-02-13 | 2014-08-14 | Namit Jain | Hive table links |
| CN108667930A (en) * | 2018-05-09 | 2018-10-16 | 聚龙股份有限公司 | A kind of configuration of dynamic data source and automation switching method |
| CN111491012A (en) * | 2020-03-27 | 2020-08-04 | 北京尚医智信健康管理有限公司 | SaaS multi-tenant data isolation access method and device, electronic equipment and storage medium |
| WO2021218328A1 (en) * | 2020-04-28 | 2021-11-04 | 深圳壹账通智能科技有限公司 | Multi-tenant access service implementation method, apparatus and device, and storage medium |
| WO2022126968A1 (en) * | 2020-12-15 | 2022-06-23 | 平安科技（深圳）有限公司 | Micro-service access method, apparatus and device, and storage medium |
| CN112527310A (en) * | 2020-12-15 | 2021-03-19 | 平安国际智慧城市科技股份有限公司 | Multi-tenant data isolation method and device, computer equipment and storage medium |
| US20220245032A1 (en) * | 2021-02-03 | 2022-08-04 | Netapp, Inc. | Methods and systems for protecting multitenant databases in networked storage systems |
| CN113535723A (en) * | 2021-07-13 | 2021-10-22 | 杭州安恒信息技术股份有限公司 | Multi-tenant database management and control method, system and storage medium |
| CN114064781A (en) * | 2021-11-29 | 2022-02-18 | 重庆忽米网络科技有限公司 | Cache mechanism-based multi-tenant data source management method and readable storage medium |
| CN114328626A (en) * | 2021-12-30 | 2022-04-12 | 重庆富民银行股份有限公司 | Multi-data source dynamic switching method, system and storage medium |
| CN115080537A (en) * | 2022-06-07 | 2022-09-20 | 易保网络技术(上海)有限公司 | Multi-tenant data partitioning method, program product and electronic device |
| CN115587093A (en) * | 2022-09-29 | 2023-01-10 | 浪潮软件股份有限公司 | System for dynamically expanding tenants in big hall and implementation method |
| CN115563125A (en) * | 2022-11-03 | 2023-01-03 | 东方合智数据科技(广东)有限责任公司 | Dictionary agent tangent plane method and related equipment in corrugated paper packaging industry |
| CN115620851A (en) * | 2022-12-19 | 2023-01-17 | 一临云(深圳)科技有限公司 | Data verification method and device, electronic equipment and readable storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN116401231B (en) | 2024-04-26 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US8954391B2 (en) | System and method for supporting transient partition consistency in a distributed data grid | |
| CN101090401B (en) | Data buffer store method and system at duster environment | |
| WO2021042923A1 (en) | Data sharding storage method and apparatus, and terminal and computer-readable storage mediium | |
| US9146956B2 (en) | Statistical applications in OLTP environment | |
| US7693816B2 (en) | Computer system, computer, data access method and database system | |
| US20160183184A1 (en) | Reducing wireless reconnection time of a computing device | |
| US20150263911A1 (en) | Roaming Application Settings Across Multiple Computing Devices | |
| CN111147599B (en) | Cache data updating method and device, server and storage medium | |
| EP3376403A1 (en) | Method of accessing distributed database and device providing distributed data service | |
| CN103370695B (en) | database update notification method | |
| CN111459749A (en) | Prometous-based private cloud monitoring method and device, computer equipment and storage medium | |
| CN107491463B (en) | Optimization method and system for data query | |
| WO2020094064A1 (en) | Performance optimization method, device, apparatus, and computer readable storage medium | |
| US20150019955A1 (en) | Method and system for displaying literal contents, mobile terminal, cloud typesetting server, and storage medium | |
| CN112860386A (en) | Method for switching nodes in distributed master-slave system | |
| CN116401231B (en) | Data source management method, device and storage medium | |
| CN113132356B (en) | UDP message distribution method, device and storage medium | |
| CN111031126B (en) | Cluster cache sharing method, system, equipment and storage medium | |
| CN113612814A (en) | Method, device, terminal and storage medium for screening session information | |
| CN111488157A (en) | Server installation system and method | |
| CN113254470B (en) | Data modification method, device, computer equipment and storage medium | |
| JP2016009225A (en) | Database management device, database management method, program, and recording medium | |
| CN113157722A (en) | Data processing method, device, server, system and storage medium | |
| CN114157582A (en) | Switch port state monitoring method and device and network communication system | |
| CN112711606A (en) | Database access method and device, computer equipment and storage medium |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |