48 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.

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.

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 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 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.

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.

Embodiments of the present application provide a wide table generation method, device and equipment and a storage medium. The method comprises: obtaining a database access record table and a database cache table which are the same as a database object; the database access record table comprises executed database statement information; the database cache table comprises inter-table association relationship records; parsing the executed database statement information to obtain a statement segment included in the executed database statement information and an information type of the statement segment; when the information type is a first preset type, determining a target database cache table in which the inter-table association relationship exists from the database cache table according to the statement segment; and updating the inter-table association relationship records according to the target database cache table to obtain a wide table. Embodiments of the present application can solve the problem that the wide table generated by the existing wide table generation method is repetitive, causing waste of database storage resources.

Methods and systems for using dispersed cached data stored in multiple database nodes for serving database access requests are described herein. Upon receiving a request for data from a requesting device, a first application server determines whether the requested data is stored in a local cache memory. If it is determined that the requested data is not stored in the local cache memory, without accessing a local, first database, the first application server determines that the requested data is stored in a cache memory of a second application server, wherein the second application server stores at least a portion of the data from a second database in its cache memory. The first application server retrieves the requested data from the cache memory of the second application server and provides the retrieved data to the requesting device.

The invention provides a method and system for safely playing materials, a storage medium and a product, and the method comprises the steps: obtaining perfect target video information according to a target video playing template corresponding to a business scene identifier and a material identifier in response to a playing target material signature request; generating a playing signature according to the client identifier and the like, and caching the perfect target video information and the playing signature to a database; returning a playing signature; in response to the play link request carrying the play signature, verifying the play signature; if the verification is passed, target video information corresponding to the playing signature is acquired from the database, and a playing link request is assembled, transmitted and sent; receiving a playing link request, and generating a playing link according to the video playing related parameters; and returning the playing link. According to the method, the playing signature is generated, the playing link is requested, the video information is cached according to the database, and the playing link is generated, so that the playing link is not requested through an original chain any more, and the safety of the original chain is ensured.

The application discloses a kind of power distribution network topological model checking method and system in graph database, the method first stores the original power distribution network topological model data in relational database and graph database as snapshot in server E file, recovers topological model data to in-memory database by snapshot recovery, obtains relational database topological model and graph database topological model;Then by model analysis, compare the quantity of the relational database topological model, original graph model and the target graph model, check the absence or redundancy of the target graph model, complete power distribution network topological model checking in graph database;The application adopts embedded in-memory database cache topological model, realizes the fast checking of power distribution network topological relationship model and graph database model data;E file snapshot and recovery method is used, the speed of topological model checking is improved, so that power distribution network topological analysis result has stronger credibility.

Techniques are described herein for an integrated in-front database cache (“IIDC”) providing an in-memory, consistent, and automatically managed cache for primary database data. An IIDC comprises a database server instance that (a) caches data blocks from a source database managed by a second database server instance, and (b) performs recovery on the cached data using redo records for the database data. The IIDC instance implements relational algebra and is configured to run any complexity of query over the cached database data. Any cache miss results in the IIDC instance fetching the needed block(s) from a second database server instance managing the source database that provides the IIDC instance with the latest version of the requested data block(s) that is available to the second instance. Because redo records are used to continuously update the data blocks in an IIDC cache, the IIDC guarantees consistency of query results.

The embodiment of the invention discloses a data processing method, device and equipment, and the method comprises the steps: obtaining a settlement request for a target commercial tenant, and the settlement request comprises the identification of the target commercial tenant; in response to the settlement request, remotely calling a database cache, and querying whether settlement preferential information of the target merchant exists in the database cache based on the identifier of the target merchant through the database cache; under the condition that the query of remotely calling the database cache is abnormal, querying whether settlement preferential information of the target merchant exists in a local first cache or not based on the identifier of the target merchant; and if the settlement preferential information of the target merchant does not exist in the local first cache, obtaining the settlement preferential information of the target merchant from a database corresponding to the database cache, and executing settlement processing corresponding to the settlement request based on the obtained settlement preferential information of the target merchant.