CN116450939A - System and method for calling in database based on cloud computing management platform - Google Patents
System and method for calling in database based on cloud computing management platform Download PDFInfo
- Publication number
- CN116450939A CN116450939A CN202310388606.6A CN202310388606A CN116450939A CN 116450939 A CN116450939 A CN 116450939A CN 202310388606 A CN202310388606 A CN 202310388606A CN 116450939 A CN116450939 A CN 116450939A
- Authority
- CN
- China
- Prior art keywords
- user
- data
- database server
- cloud computing
- management platform
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 14
- 238000005065 mining Methods 0.000 claims abstract description 11
- 230000003993 interaction Effects 0.000 claims abstract description 9
- 238000012544 monitoring process Methods 0.000 claims description 18
- 238000012795 verification Methods 0.000 claims description 10
- 230000005540 biological transmission Effects 0.000 claims description 3
- 238000007726 management method Methods 0.000 description 8
- 238000005070 sampling Methods 0.000 description 3
- 230000003139 buffering effect Effects 0.000 description 2
- 230000004075 alteration Effects 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/95—Retrieval from the web
- G06F16/953—Querying, e.g. by the use of web search engines
- G06F16/9535—Search customisation based on user profiles and personalisation
-
- 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/24—Querying
- G06F16/245—Query processing
- G06F16/2457—Query processing with adaptation to user needs
-
- 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/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2465—Query processing support for facilitating data mining operations in structured databases
-
- 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 discloses a system and a method for retrieving in a database based on a cloud computing management platform, wherein the system comprises a user side and a database server side, the user side performs remote data interaction with the database server side through the Internet, a data prefetching module is arranged in the database server side, the data prefetching module performs remote data interaction with the user side through the Internet, and the data prefetching module is used for predicting data which a user can access next after mining a historical access log of the user in the database server side and sending the data to the user side.
Description
Technical Field
The invention relates to the technical field of cloud computing data retrieval, in particular to a retrieval system and method in a database based on a cloud computing management platform.
Background
Cloud computing is a computing mode based on the Internet, shared software and hardware resources and information are provided for computers and other devices, resources and services can be dynamically deployed, configured and canceled according to user requirements, and cloud computing resources are distributed to schedule resources among different resource users according to a certain resource usage rule.
The increasing, usage and delivery patterns of related services, mainly internet-based, generally involve providing dynamically extensible and often virtualized resources through the internet. The cloud is a metaphor for networks and the internet. In the past, the cloud was often used to represent a telecommunications network, and later also to represent an abstraction of the internet and underlying infrastructure. Narrow cloud computing refers to the delivery and usage mode of IT infrastructure, meaning that the required resources are obtained in an on-demand, easily scalable manner over the network; generalized cloud computing refers to a mode of delivery and use of services, meaning that desired services are obtained in an on-demand, easily scalable manner over a network. Such services may be IT, software, internet related, or other services. It means that the calculation can also be circulated as a commodity through the internet.
In the prior art, a user checks data information, preferably, the user needs to open a data folder at a terminal or input data search information in a data search area, then, the data information to be checked is called, the operation steps are complex, the searching and buffering time is long, and the user needs to spend too much time.
Disclosure of Invention
In order to overcome the defects of the prior art, the invention provides a system and a method for calling in a database based on a cloud computing management platform, which are used for combining the current and historical requests of a user through a data pre-sampling module, analyzing and predicting the data content which the user is likely to access in the future, and pre-sampling the data content into a data pre-sampling unit, so that the user can conveniently and quickly call the data when using the system.
In order to solve the technical problems, the invention provides the following technical scheme: the system comprises a user side and a database server side, wherein the user side is in remote data interaction with the database server side through the Internet, a data prefetching module is arranged in the database server side, the data prefetching module is in remote data interaction with the user side through the Internet, and the data prefetching module is used for predicting data which the user can access next after mining a historical access log of the user in the database server side and sending the data to the user side.
As a preferable technical scheme of the invention, the data prefetching module obtains the access sequence of the user by mining the historical access log of the user in the database server, compares the access sequence of the current user with the mined access sequence of the user, predicts the data possibly accessed by the user next, and sends the data to the user.
As a preferable technical scheme of the invention, the data pre-fetching module comprises a data pre-fetching unit, wherein the input end of the data pre-fetching unit is electrically connected with the output end of the database server, and the output end of the data pre-fetching unit is in transmission connection with the input end of the user through the Internet.
As a preferable technical scheme of the invention, the calling system comprises a calling monitoring module which is used for verifying login information of the user side.
The invention also provides a method for calling in the database based on the cloud computing management platform, which comprises the following steps: step one: receiving a request of a user side, and verifying login information of a user by calling a monitoring module; step two: selecting whether to open the access authority to the user according to the verification result of the access monitoring module, and opening if the verification is passed; thirdly, obtaining an access sequence of the user by mining a historical access log of the user in a database server through a data prefetching module, comparing the access sequence of the current user with the mined access sequence of the user, predicting data possibly accessed by the user next, storing the data in a data prestored unit, and sending the data to the user; step four: when the data sent to the user side in the data pre-fetching module is inconsistent with the data required by the user, the request data of the user is retrieved and fetched in the database server side to obtain corresponding data, and then the corresponding data is sent to the user side through the Internet.
As a preferable technical scheme of the invention, the calling monitoring module needs to verify the login ID, the login position information and the login equipment information of the user when verifying the user.
As a preferable technical scheme of the invention, when the user information is verified, the calling monitoring module opens the relevant data authority in the database server according to the login ID of the user.
As a preferable technical scheme of the invention, the data in the database server side is stored in a grading manner according to the confidentiality level.
Compared with the prior art, the invention has the following beneficial effects:
the invention combines the current and the history requests of the user through the data pre-fetching module, analyzes and predicts the data content which the user is likely to access in the future, and pre-fetches the data content to the data pre-fetching unit, thereby being convenient for the user to quickly fetch the data when in use.
Drawings
FIG. 1 is a diagram of a retrieval system in a database based on a cloud computing management platform according to the present invention;
wherein: 1. a user terminal; 2. the Internet; 3. a database server; 4. and a data prefetching module.
Detailed Description
In order to more clearly illustrate the general inventive concept, a detailed description is given below by way of example with reference to the accompanying drawings.
In the description of the present invention, it should be understood that the terms "center," "upper," "lower," "front," "rear," "left," "right," "vertical," "horizontal," "top," "bottom," "inner," "outer," "axial," "radial," "circumferential," and the like indicate orientations or positional relationships based on the orientation or positional relationships shown in the drawings, merely to facilitate describing the present invention and simplify the description, and do not indicate or imply that the devices or elements referred to must have a specific orientation, be configured and operated in a specific orientation, and therefore should not be construed as limiting the present invention.
Furthermore, the terms "first," "second," and the like, are used for descriptive purposes only and are not to be construed as indicating or implying a relative importance or implicitly indicating the number of technical features indicated. Thus, a feature defining "a first" or "a second" may explicitly or implicitly include one or more such feature. In the description of the present invention, the meaning of "a plurality" is two or more, unless explicitly defined otherwise.
In the present invention, unless explicitly specified and limited otherwise, the terms "mounted," "connected," "secured," and the like are to be construed broadly, and may be, for example, fixedly connected, detachably connected, or integrally formed; the device can be mechanically connected, electrically connected and communicated; can be directly connected or indirectly connected through an intermediate medium, and can be communicated with the inside of two elements or the interaction relationship of the two elements. The specific meaning of the above terms in the present invention can be understood by those of ordinary skill in the art according to the specific circumstances.
In the present invention, unless expressly stated or limited otherwise, a first feature "up" or "down" a second feature may be the first and second features in direct contact, or the first and second features in indirect contact via an intervening medium. In the description of the present specification, the description with reference to the terms "one aspect," "some aspects," "examples," "specific examples," or "some examples," etc., means that a particular feature, structure, material, or characteristic described in connection with the aspect or example is included in at least one aspect or example of the present invention. In this specification, the schematic representations of the above terms are not necessarily for the same scheme or example. Furthermore, the particular features, structures, materials, or characteristics described may be combined in any suitable manner in any one or more aspects or examples.
Examples:
example 1:
as shown in fig. 1, the invention provides a system for retrieving in a database based on a cloud computing management platform, which comprises a user side 1 and a database server side 3, wherein the user side 1 performs remote data interaction with the database server side 3 through the internet 2, a data prefetching module 4 is arranged in the database server side 3, the data prefetching module 4 performs remote data interaction with the user side 1 through the internet 2, and the data prefetching module 4 is used for predicting data which the user may access next after mining a history access log of the user in the database server side 3 and sending the data to the user side 1;
the data pre-fetching module 4 obtains the access sequence of the user by mining the history access log of the user in the database server 3, compares the access sequence of the current user with the mined access sequence of the user, predicts the data which the user may access next, and sends the data to the user 1;
the data pre-fetching module 4 comprises a data pre-fetching unit, wherein the input end of the data pre-fetching unit is electrically connected with the output end of the database server 3, and the output end of the data pre-fetching unit is in transmission connection with the input end of the user terminal 1 through the Internet 2;
the calling system comprises a calling monitoring module and a calling control module, wherein the calling monitoring module is used for verifying login information of the user side 1;
when the system for calling in the database based on the cloud computing management platform is used, firstly, a request of a user side 1 is received, login information of a user is verified through a calling monitoring module, the request of the user side 1 is directly refused when verification is not passed, a data access request in an open right is carried out when the verification is passed, a data access sequence of the user is obtained through mining a historical access log of the user in a database server side 3 through a data pre-fetching module 4, the access sequence of the current user is compared with the mined user access sequence, data which the user can possibly access is predicted, the data is stored in a data pre-storing unit, the data is sent to the user side 1, meanwhile, pre-stored data which is predicted when the user accesses last time can be called, the data is sent to the user side 1, if the data is the data which is required by the user at this time, if the data is not the data required by the user at this time, the data is continuously searched in the applicable interior of the user, the data required by the user is downloaded to the user side 1 in a buffering manner, the data required by the user is predicted, the data is pre-fetched by the current data pre-fetching module, the user access unit and the data can be conveniently pre-stored in the pre-storing unit, and the data can be conveniently accessed by the user when the user can access the data is predicted by the user, and the pre-stored in the data pre-storing unit.
Example 2:
the invention also provides a method for calling in the database based on the cloud computing management platform, which comprises the following steps:
step one: receiving a request of a user side 1, and verifying login information of a user by calling a monitoring module;
step two: selecting whether to open the access authority to the user according to the verification result of the access monitoring module, and opening if the verification is passed;
thirdly, obtaining an access sequence of a user by mining a historical access log of the user in a database server 3 through a data pre-fetching module 4, comparing the access sequence of the current user with the mined access sequence of the user, predicting data possibly accessed by the user next, storing the data in a data pre-fetching unit, and sending the data to the user 1;
step four: when the data sent to the user terminal 1 in the data pre-fetching module 4 is inconsistent with the data required by the user, the request data of the user is retrieved and invoked in the database server terminal 3 to obtain corresponding data, and then the corresponding data is sent to the user terminal 1 through the internet 2.
The method comprises the steps that when a user is verified, a calling monitoring module needs to verify login ID, login position information and login equipment information of the user, when the user information is verified, the calling monitoring module opens relevant data authority in a database server 3 according to the login ID of the user, and data in the database server 3 are stored in a grading mode according to a confidential level; the login information of the user is verified and classified through the calling monitoring module, if verification fails, the request of the user is refused, if verification is successful, the data information in the authority is opened according to the ID information of the user, and the data in the database server 3 can be effectively protected through classified storage of the data according to the confidentiality degree.
Although embodiments of the present invention have been shown and described, it will be understood by those skilled in the art that various changes, modifications, substitutions and alterations can be made therein without departing from the principles and spirit of the invention, the scope of which is defined in the appended claims and their equivalents.
Claims (8)
1. The utility model provides a system of getting in database based on cloud computing management platform, includes user side (1) and database server (3), its characterized in that: the user terminal (1) performs remote data interaction with the database server terminal (3) through the Internet (2), a data prefetching module (4) is arranged in the database server terminal (3), the data prefetching module (4) performs remote data interaction with the user terminal (1) through the Internet (2), and the data prefetching module (4) is used for predicting data which the user may access next after mining a historical access log of the user in the database server terminal (3) and sending the data to the user terminal (1).
2. The system for invoking in a database based on a cloud computing management platform as recited in claim 1, wherein: the data pre-fetching module (4) obtains the access sequence of the user by mining the historical access log of the user in the database server (3), compares the access sequence of the current user with the mined access sequence of the user, predicts the data possibly accessed by the user next, and sends the data to the user side (1).
3. The system for invoking in a database based on a cloud computing management platform as recited in claim 1, wherein: the data pre-fetching module (4) comprises a data pre-fetching unit, wherein the input end of the data pre-fetching unit is electrically connected with the output end of the database server (3), and the output end of the data pre-fetching unit is in transmission connection with the input end of the user side (1) through the Internet (2).
4. The system for invoking in a database based on a cloud computing management platform as recited in claim 1, wherein: the calling system comprises a calling monitoring module which is used for verifying login information of the user side (1).
5. The method for calling in a database based on a cloud computing management platform according to claim 1, wherein the method comprises the following steps: the method comprises the following steps:
s1: receiving a request of a user side (1), and verifying login information of a user by calling a monitoring module;
s2: selecting whether to open the access authority to the user according to the verification result of the access monitoring module, and opening if the verification is passed;
s3, obtaining an access sequence of a user by mining a historical access log of the user in a database server (3) through a data pre-fetching module (4), comparing the access sequence of the current user with the mined access sequence of the user, predicting data possibly accessed by the user next, storing the data in a data pre-storing unit, and sending the data to the user (1);
s4: when the data sent to the user side (1) in the data pre-fetching module (4) is inconsistent with the data required by the user, the request data of the user is searched and fetched in the database server side (3) to obtain corresponding data, and then the corresponding data is sent to the user side (1) through the Internet (2).
6. The method for retrieving in a database based on a cloud computing management platform according to claim 5, wherein: the call monitoring module needs to verify the login ID and login position information of the user and login equipment information when verifying the user.
7. The method for retrieving in a database based on a cloud computing management platform according to claim 6, wherein: and when the calling monitoring module verifies the user information, the relevant data authority in the open database server (3) is carried out according to the login ID of the user.
8. The method for retrieving in a database based on a cloud computing management platform according to claim 5, wherein: the data in the database server (3) are stored in a hierarchical mode according to the confidential level.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310388606.6A CN116450939A (en) | 2023-04-12 | 2023-04-12 | System and method for calling in database based on cloud computing management platform |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310388606.6A CN116450939A (en) | 2023-04-12 | 2023-04-12 | System and method for calling in database based on cloud computing management platform |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN116450939A true CN116450939A (en) | 2023-07-18 |
Family
ID=87119662
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202310388606.6A Pending CN116450939A (en) | 2023-04-12 | 2023-04-12 | System and method for calling in database based on cloud computing management platform |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN116450939A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115336237A (en) * | 2020-03-20 | 2022-11-11 | 国际商业机器公司 | Predictive provisioning of remotely stored files |
-
2023
- 2023-04-12 CN CN202310388606.6A patent/CN116450939A/en active Pending
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115336237A (en) * | 2020-03-20 | 2022-11-11 | 国际商业机器公司 | Predictive provisioning of remotely stored files |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10515058B2 (en) | Unified file and object data storage | |
| US9237207B2 (en) | Device, system and method for providing distributed online services | |
| US9002932B2 (en) | Cloud computing access gateway and method for providing a user terminal access to a cloud provider | |
| EP2680624B1 (en) | Method, system and device for improving security of terminal when surfing internet | |
| US20170104829A1 (en) | Network resource crawler with multiple user-agents | |
| US20130018868A1 (en) | Searching documentation across interconnected nodes in a distributed network | |
| CN110519401A (en) | Improve method, apparatus, equipment and the storage medium of network Access Success Rate | |
| US20070240065A1 (en) | Multiple use of common perspectives | |
| US20050216519A1 (en) | Access point that monitors guest usage | |
| CN116450939A (en) | System and method for calling in database based on cloud computing management platform | |
| AU2011323987A1 (en) | Methods and systems for providing access to data and measurements in a management system | |
| CN113472901B (en) | Load balancing method, device, equipment, storage medium and program product | |
| DK2633664T3 (en) | Method and system for creating secure authenticated bi-directional server communication | |
| US8589421B1 (en) | System and method for navigating documents | |
| CN106911782A (en) | A kind of method for reading data and device | |
| US11663143B2 (en) | Multi-state midtier dynamic cache replacement | |
| CN105516321A (en) | Data acquisition method and device | |
| CN113316926A (en) | Domain name processing method and device, electronic equipment and storage medium | |
| US8566448B2 (en) | System and method for providing device file using device identifier | |
| EP2354980A1 (en) | Management of communications between a client equipment and a server equipment providing to the client equipment computer resources represented according to a file system | |
| RU2435236C1 (en) | System and method of recording data into cloud storage | |
| CN110210251A (en) | Data query method, apparatus, equipment and computer readable storage medium | |
| CN104980329B (en) | Book management method and device, Mobile Agent Server | |
| CN113746909A (en) | Network connection method, device, electronic equipment and computer readable storage medium | |
| JP2002373175A (en) | Method and system for retrieving service |
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 |