62 results about "Database caching" patented technology

The invention discloses a database access parameter real-time cooperative processing method and device based on multi-level cache, and belongs to the technical field of computer data caching. The method comprises the steps that a version number management table is configured; establishing a four-level cache architecture of a transaction-level cache layer, a process-level cache layer, a distributed cache layer and a database cache layer; receiving a transaction request, creating a transaction level cache layer and loading current version number information; comparing the version number in the transaction level cache layer with the version number in the process level cache layer; according to the version number comparison result, obtaining parameter data from the corresponding cache level according to a preset cache access priority strategy; and when the parameter change is detected, updating the corresponding version number in the version number management table, and updating the cache layer data as required. According to the method, real-time global effectiveness of parameter change is realized, parameter consistency of in-transit transaction is guaranteed, system processing performance and throughput are improved, system reliability and fault-tolerant capability are enhanced, and system resource utilization rate is optimized.

The embodiment of the invention provides a rendering data processing method and related equipment / products, and belongs to the field of data processing. The rendering data processing method comprises the steps of obtaining rendering duration of a component corresponding to each page; wherein the components are rendered through rendering data loaded from a preset front-end database or a back-end database, and the rendering data of partial components corresponding to partial pages are cached in the front-end database; determining a target rendering duration according to the plurality of rendering durations; uploading the target rendering duration to a rear end, so that the rear end updates a configuration rule for the front-end database according to the target rendering duration and returns the configuration rule; and executing a corresponding target operation on the front-end database according to the configuration rule. According to the embodiment of the invention, the rendering data in the front-end database is inserted, deleted or updated according to the target rendering duration of the component corresponding to each page, so that the possibility of overload of the front-end database is reduced, the page loading speed is further improved, and the situation of page loading failure is reduced.

The invention discloses an Excel file exporting method and system based on Java language, and relates to the technical field of computer software development, and the implementation of the method comprises the following steps: receiving an exporting request: the system receives the exporting request of a user through a Web interface or a graphical interface; analyzing template configuration: loading and analyzing an Excel export template specified by a user by a system; data binding and style rendering: the system binds a data set obtained from a database, a cache or other data sources with a template, and performs style rendering according to template configuration; an Excel file is generated, specifically, according to the export format selected by the user, the system calls an Apache POI library to create a Workbook object, and rendered data is written into a worksheet; and returning or storing the file. According to the method, the format and the content of the Excel file can be exported in a self-defined mode according to the configuration information of the user, the development efficiency is improved, and the expandability of the system is enhanced.

The invention discloses an image transmission system for visual communication display, and relates to the technical field of data management.The image transmission system collects and manages multi-dimensional information data of all credit enterprises through a data management unit, and a behavior analysis unit analyzes behaviors of authorized users; the data management unit generates a reading strategy of each dimension, and the enterprise portrait unit generates portrait analysis of each credit enterprise based on different dimensions. In the process of comparing and generating the reading strategy of each dimension, a plurality of character data are intercepted from the dimension data table corresponding to the dimension with relatively high click frequency and relatively large data capacity; according to the method, the high-frequency access data is stored in the independent table to generate the derivative data table of the corresponding dimension, in this way, the database cache can be more effectively utilized, and more common data can be ensured to be reserved in the cache by separating the high-frequency data, so that the performance is improved, the contention for a large table can be reduced, and the possibility of lock contention is reduced.

Techniques are disclosed relating to improving the efficiency of geolocation queries via geospatial cells and query parameter caching. In various embodiments, a system receives a request from a user device to access geolocation information of entities and determine a first geographic location of the device. The system identifies that the first location is within a geospatial cell stored in a database cache and determines whether query parameters corresponding to the cell are stored in the cache. The system may retrieve the cached query parameters corresponding to the geospatial cell and execute a geolocation query on a database storing location information for different entities based on the cached query parameters. Results of the geolocation query may be different from query results of one or more other queries executed, based on the cached query parameters, for other user computing devices located within the given geospatial cell based on the cached query parameters.

The application discloses a data query method and device, electronic equipment and storage medium, and relates to the technical field of databases. The method comprises the following steps: receiving a query request from a platform, determining the data type requested by the query request; determining a query strategy in a data storage library according to the data type; wherein the data storage library comprises a local database, a cache database and an Elasticsearch database; and querying in the data storage library according to the query strategy, and obtaining target statistical data. Through the three-layer storage structure, massive statistical data is finely divided, and is stored in a scattered and summarized manner. In the query process, massive search in a database is not required, and the data query efficiency is improved.

A database management system generates a cache entry system view of a database cache. Also, a new column is generated for the cache entry system view, where the new column is an ENTRY_HASH column to identify each entry of the database cache. In an example, the database management system detects a request to remove a given entry of the database cache, where the request includes a given ENTRY_HASH value to locate the given entry of the database cache. In response to receiving the request, the database management system identifies the given entry of the database cache based on the given ENTRY_HASH value. Then, the database management system removes the given entry of the database cache. Also, the database management system notifies a cache manager that the given entry has been removed.

Techniques for caching data in a database system include one or more non-transitory computer-readable media storing program instructions that, when executed, perform the method of receiving a request to access a database, determining a caching priority specified in the request, processing the request to generate query results, and after generating the query results, caching or not caching data from which the query results are generated based on the determined caching priority.

The invention relates to the technical field of database management, in particular to a database caching algorithm, device and equipment based on real-time load and a medium. In the application, when the object in the database is accessed, after the cache mode of the corresponding object is determined, whether the access condition in the corresponding cache mode is met is judged, and when the access condition in the corresponding cache mode is met, the data cached in the corresponding cache mode is directly accessed, so that the direct access to the hot object is greatly reduced, and the access efficiency is improved. The problem of lock conflict of hot object access under large concurrent services is solved, and database performance is improved.

The application discloses a database cache query method and device, equipment and storage medium, belongs to computer technical field, the technical scheme is: the received query request is parsed, according to the analysis result, the ID identification of each data set to be queried is determined, and the corresponding query condition of each data set is determined according to the query request;The ID identification of data set is matched with the ID identification of data set saved in the cache queue one by one;If the matching degree of the ID identification of data set meets the preset condition, the record mapping information corresponding to the data set ID identification saved in the cache queue is read from the database, the data record mapped by the record mapping information is read, and the data record meeting the corresponding query condition of the current data set is matched from the data record, as the query result and return;Solve the technical problem of improving the hit rate of cache and reducing the query pressure of underlying database under the condition of limited cache space.

The embodiment of the invention provides a method and system for customizing a configuration table, and the method comprises the steps: determining a table identifier of a target table requested to be displayed and a user identifier of a target user initiating the table display request according to a table display request; according to the table identifier and the user identifier, determining table data of a target table cached in a local database and user-defined attribute information of a target user on the target table, and determining code attribute information of the target table in codes; the table data is rendered and displayed through the custom attribute information and the coding attribute information, a table configuration component is rendered in the display page, and the table configuration component is a custom component for displaying the displayed table by the user. The invention aims to improve the working efficiency and user experience of a user.

Techniques are disclosed relating to implementing a cache layer for a distributed database system. In some embodiments, a distributed computing system that includes a plurality of physical nodes implementing a hosting service deploys, to a first of the plurality of physical nodes, a container that implements a cache for a distributed database system hosted by the hosting service. The container is executable to store the cache in a memory internal to the first physical node. The container receives, from the database system, a data request for data maintained in a persistent storage external to the first physical node. In response to determining that the requested data resides in the cache, the container services the data request from the internal memory of the first physical node.

A service server according to an embodiment may comprise: a communication circuit; a memory storing instructions; and at least one processor, wherein the instructions, when executed by the at least one processor, cause the service server to: identify a data request received from a client terminal through the communication circuit; in response to the data request, request data, cached from a database, from a primary cache including multiple cache clusters in which the data is distributed and stored; on the basis of identifying that the requested data does not exist in the primary cache, request the data from a secondary cache including at least one cache cluster; and on the basis of identifying that the requested data does not exist in the secondary cache, request the data from the database.

The invention provides a data storage method and device based on multi-level cache and intelligent distribution and a medium, and belongs to the technical field of data storage. The data storage method comprises the following steps: constructing a multi-stage cache architecture between a data acquisition end and a persistent storage end of Internet of Things data, wherein the multi-stage cache architecture at least comprises a local memory cache, a distributed cache and a database cache; according to the service priority, the change frequency and the storage cost of the Internet of Things data, dynamically routing the Internet of Things data to a corresponding cache level in a multi-level cache architecture through an intelligent distribution engine; performing data aggregation processing on the Internet of Things data, executing a timing batch writing strategy, and writing the Internet of Things data into a persistent storage end; and by adopting a data fragmentation and read-write separation strategy, dispersing and storing the data to a plurality of database instances or nodes of a persistent storage end so as to realize load balancing. According to the method and the device, the persistence of the mass sensing data with fidelity, load reduction and long period can be realized.

The invention relates to a management method for efficiently realizing cache based on an LRU flash memory database, which comprises the following steps of: (1) classifying LRU linked lists according to dry and dirty attributes and cold and hot attributes of cache pages, and classifying the corresponding cache pages into the corresponding LRU linked lists according to access times and whether modification is performed or not; and (2) judging whether the page to be accessed currently is in the cache or not, and executing cache processing of the corresponding attribute linked list according to a judgment result. The invention also relates to a corresponding device, a processor and a computer readable storage medium. By the adoption of the management method and device for efficiently achieving cache based on the LRU flash memory database, the processor and the computer readable storage medium, a four-linked-table management mode is designed, a high cache access hit rate can be obtained while write operation is not increased, and the cache access efficiency is improved. The invention provides an efficient cache management method for a flash database, which is applicable to most scenes.

The invention relates to an aircraft component test report analysis system based on an anomaly inference model, and relates to the technical field of component testing, and the aircraft component test report analysis system comprises a data analysis module which is configured with a file format analysis strategy to perform file format feature extraction on a test file, carrying out aircraft part test information analysis on the test file by matching a corresponding analysis step in the format analysis database so as to generate a test report; the file caching module is configured with a multi-stage data caching strategy, reads, writes and pre-caches the test file through a pre-constructed memory, file and database caching architecture, and keeps the data read-write efficiency and the system response speed within a preset good threshold range; and the exception analysis module is configured with an exception report identification model and is used for identifying and analyzing the test report through similar fault identification logic and a fault analysis engine so as to determine exception test information in the test report. The method has the effect of improving the analysis efficiency and accuracy of the test report of the aircraft component.

The application relates to a browser cache device and method for high-precision real-scene three-dimensional layered data, which comprises a server-side preprocessing module and a browser-side cache management module, and communication connection is established between the server-side preprocessing module and the browser-side cache management module through specific data flow and control flow. The two-step process of first searching a secondary local database cache unit and then searching the server-side preprocessing module is a key step for improving the loading speed of high-precision real-scene three-dimensional data; the browser cache strategy is further provided with steps of on-demand loading, predictive preloading and incremental updating mechanism. The application can realize the technical effects of significantly improving the loading speed, greatly reducing the resource occupation, fundamentally improving the user experience and good practicability by organically combining the server-side data layered cutting and the two-level cache architecture designed for the layered data on the browser side.

The embodiment of the invention discloses a method, a system and equipment for improving data access performance and a storage medium, which effectively alleviates the performance bottleneck problem of MDS in a distributed file system by optimizing the file reading and writing processes of an application layer and a client, improves the overall performance and expandability of the system, and improves the data access performance. In the file writing operation, after the file is written successfully, the application layer needs to store inode information of the file into a database cache; in the file reading operation, the application layer transmits the cached file inode information to the file system client, the file system client does not communicate with the MDS to obtain the file inode information any more, the load of the MDS is effectively reduced, the response time is shorter, under the condition that IO requests are dense, the client request delay can be reduced, the service failure caused by accumulation of a large number of services is avoided, and the user experience is improved. The stability is improved, meanwhile, the service requirement for high response time requirement degree can be met, the number of arranged MDS servers is reduced, and hardware investment and maintenance cost are reduced.

The invention provides a test method and system based on flow control. The method comprises the following steps: S1, a user access system performs UserldHash calculation; s2, designing a flow monitoring system which is used for monitoring the distribution condition of flow in real time and recording a test result; s3, establishing a test environment, and ensuring that deployment and operation environments of all test versions or functions are consistent, including a database, a cache and a network; s4, designing a set of data analysis and result display system for performing data analysis and result display on the test result; through the design and optimization of a flow control algorithm, the test flow is ensured to be reasonably distributed to different test versions, and the accuracy and reliability of data acquisition and analysis are improved, so that accurate comparison of data of different versions and establishment and optimization of a stability guarantee mechanism are supported, the system can stably and reliably operate under flow control, and the test efficiency is improved. And the user experience is considered and optimized, so that the adverse effect of flow control on the user experience is reduced.

The invention discloses an intelligent monitoring system and method for power operation life-saving measures based on the Internet of Things. The system comprises a user terminal layer, a communication layer, a service logic layer and a data layer. The user terminal layer is used for completing a user interaction function and a data display function; a communication layer, namely an isolation forwarding layer, is responsible for routing, load balancing, authentication and authorization of forwarding requests; the back-end service layer is used for ensuring that a request reaches a back-end service, interacting with the back-end service layer, receiving and processing the request, calling a back-end service interface data format for conversion and adaptation, and recording and monitoring load balancing authentication between the routing request and the service; the business logic layer comprises a plurality of actual business functions, and data of the functions are mutually communicated; and the data layer is used for storing and querying service data, and is responsible for accessing the relational database and the redis cache database and transferring the data to programs of other layers for calling. The safety is improved, unsafe behaviors are found and corrected in time, and the accident risk is reduced.

A database management system generates a cache entry system view of a database cache. Further, a new column is generated for the cache entry system view, where the new column is an ENTRYHASH column for identifying each entry of the database cache. In an example, a database management system detects a request to remove a given entry of a database cache, where the request includes a given ENTRYHASH value to locate the given entry of the database cache. In response to receiving the request, the database management system identifies a given entry of the database cache based on the given ENTRYHASH value. The database management system then removes a given entry of the database cache. In addition, the database management system notifies the cache manager that the given entry has been removed.

The invention discloses a campus teacher-student intelligent agent development and service platform, and the platform comprises an access layer which is used for accessing the platform through a plurality of terminal devices, and supporting an MQTT protocol and an HTTP protocol for communication; the interface layer is used for providing a standardized API interface and realizing front and rear end separation and data exchange service layer, is realized based on a. NET6 micro-service architecture, and comprises an agent management module, an API gateway and a data aggregation module; the data layer is used for storing and managing business data, statistical data and log data; the storage layer comprises a relational database, a cache system and a file storage and is used for persisting business data and course data; the platform integrates campus multi-system data through a middle platform architecture, and supports low-code agent development, containerized deployment and real-time service collaboration. Different using requirements of teachers and students can be better met.

A database management system generates a cache entry system view of a database cache. Also, a new column is generated for the cache entry system view, where the new column is an ENTRY_HASH column to identify each entry of the database cache. In an example, the database management system detects a request to remove a given entry of the database cache, where the request includes a given ENTRY_HASH value to locate the given entry of the database cache. In response to receiving the request, the database management system identifies the given entry of the database cache based on the given ENTRY_HASH value. Then, the database management system removes the given entry of the database cache. Also, the database management system notifies a cache manager that the given entry has been removed.

The invention discloses a car purchase subsidy system based on WeChat and Alipay applets, and belongs to the field of car purchase subsidy digital management, the system comprises front-end and back-end technical architecture and core function modules: a front-end applet end supports double-platform operation based on a unit-app, and a Web management end adopts Vue.js 2.6. 11 and an Element UI to construct a responsive interface; and the rear end comprises a RESTful API constructed by the Think PHP 5.1, a MySQL master-slave database, a Redis cache, a JWT authentication component, an OSS file storage and a block chain evidence storage service. In a core module, an application module realizes intelligent form filling through GAN image enhancement and ticket checking (the recognition rate is greater than or equal to 95%), a data management module uniformly stores and generates a report, a statistical analysis module supports trend analysis and time sequence prediction, a multi-platform synchronization module guarantees data consistency through message queue and edge calculation, and a machine learning risk control model is integrated. The system realizes whole-process online, improves risk control and decision-making capabilities, adapts to high-concurrency weak network scenes, and ensures stable operation.

The invention provides a map layer loading device based on a port scheduling system, and the device comprises a database caching module which is used for carrying out the database initialization of the port scheduling system, forming a map data storage table, reading a current layer version number of a webpage end, judging whether the version number is the same as a layer version number stored in a database or not, and if yes, executing the step 1; if yes, a layer data request is initiated, whether corresponding map layer data exists in the map data storage table or not is inquired according to the resource locators in the layer data request, if yes, an interception instruction is sent to a request interceptor module, the corresponding map layer data in the map data storage table is fed back to the user, and if not, an interception instruction is sent to the request interceptor module; if yes, executing the map layer data request, obtaining map layer data, feeding back the map layer data to the user, and storing the map layer data into a map data storage table; and the request interceptor module is used for adding a request interceptor and intercepting the layer data request after receiving the interception instruction.

The invention discloses a tag data storage method, a query method, electronic equipment and a storage medium. The tag data storage method comprises the following steps: acquiring current tag data; storing the current label data in a data warehouse, and storing the current label data in a cache; wherein the data warehouse uses a column database, and the cache uses a non-relational database; and when a query request of the label data is received, querying from the cached non-relational database. According to the scheme, the tag data query efficiency can be improved by changing the tag data storage strategy.

The invention relates to a hanging system service processing method and device and a storage medium, and the method comprises the steps: configuring an asynchronous thread and a cache database; the cache database is used for storing clothes hanger data written by the service main thread after outbound card reading, and the service main thread synchronously triggers issuing of a clothes hanger outbound instruction while writing the clothes hanger data; acquiring a plurality of clothes hanger data from the cache database by using an asynchronous thread, and temporarily storing the clothes hanger data in an asynchronous thread queue; when the number of the clothes hanger data in the asynchronous thread queue exceeds a preset number threshold value or the time from the completion of the last yield calculation task reaches a preset time threshold value, triggering the yield calculation task by using an asynchronous thread, and calculating yield data; and pushing the yield data to the preset terminal board for real-time display by utilizing the asynchronous thread, and through the method and the device, the problem that rapid outbound and real-time data statistics cannot be taken into account in related technologies is solved.

The invention discloses a method for compressing intelligent power distribution and utilization terminal data in a time sequence database, which comprises the following steps of: acquiring data and preprocessing the data to generate a matrix type original data group, separating almost unchanged static archive data (similar to equipment positions and the like) and dynamic measurement data changing along with time in the data acquired by the static data analysis terminal and the dynamic data analysis terminal; the static data is organized and stored in a time sequence database, and key information resides in a memory; defining a data structure for the dynamic measurement data, and registering a structural body in a time sequence database; the time sequence database caches the measurement data of the composite structure, and defines a processing component value according to an associated structure body; and the time sequence database adopts a differentiated data compression method according to the component data type. According to the method, the redundancy of the data collected by the intelligent power distribution and utilization terminal stored in the memory and the disk in the time sequence database is greatly reduced, and the data compression rate and the query processing capability of a complex measurement structure in the time sequence database are improved.

This invention relates to the field of financial trading simulation training technology, and discloses a trading simulation training system based on random historical candlestick charts. The system includes a cloud computing power filtering unit, a local database caching unit, a candlestick chart random extraction unit, and a trading simulation interaction unit. The cloud computing power filtering unit is used to clean and classify the raw historical candlestick chart data. This trading simulation training system based on random historical candlestick charts combines cloud computing power filtering with local database caching, separating candlestick chart data processing from rapid retrieval. This effectively reduces latency and traffic consumption caused by frequent network requests, significantly improving system response speed and operational stability. The local cache supports offline use, eliminating network environment limitations and adapting to more usage scenarios. The overall architecture optimizes computing power allocation, reducing resource waste and allowing the system to operate efficiently with low network overhead, providing users with a smooth and stable candlestick chart trading simulation training experience.

The invention provides a database cache breakdown protection method and system. The method comprises the following steps: acquiring an access request sent to a database by a user; judging whether the access request hits data in the memory space cache or not, and if yes, directly returning the hit data in the memory space cache to the user; otherwise, hard disk space cache is allocated, and the database returns data corresponding to the access request to the user through the hard disk space cache; according to the method, the memory and the hard disk space are dynamically and cooperatively allocated, and the cache allocation rate of the hard disk is automatically adjusted according to the real-time memory utilization rate, so that the sharp increase of database pressure caused by cache breakdown in a high-concurrency scene is effectively avoided, the data access speed is remarkably improved, and meanwhile, the overall stability and the resource utilization efficiency of the system are guaranteed.