44 results about "Database maintenance" patented technology

The invention provides an image searching method, which comprises the following steps of: when a new label is added to an image in a first image database, acquiring a first semantic feature of the new label; based on the first semantic feature, performing image retrieval in a first image database to obtain a first retrieval result and a confidence coefficient of the first retrieval result; if the confidence coefficient is smaller than the preset confidence coefficient, performing secondary retrieval in the first retrieval result based on the existing tag in the first retrieval result to obtain a second retrieval result; based on the second retrieval result, adding the newly added tag into an image corresponding to the secondary retrieval result to obtain a second image database; and after an image search instruction of the user is obtained, performing image retrieval in the second image database based on the image search instruction. The problems that in the database maintenance process, a new label needs to be added, the workload of adding the label again to the data is increased while the new label is added, and the database is difficult to maintain in an existing method are solved.

A system for managing versioning of ontology data represented in multiple forms respectively in multiple databases and related methods are disclosed. The system is programmed to determine which changes to the ontology are to be incorporated into a new version of specific ontology data. In response to a write request to write a latest version of specific ontology data, the system is programmed to start representing the latest version in the multiple databases according to a first predetermined strategy. In response to a read request to read a latest version, the system is programmed to return a particular version from at least one of the multiple databases according to a second predetermined strategy.

The application discloses a cloud-native database change rollback and version management method, belongs to the technical field of database maintenance, and solves the technical problem that the same code program maintained by the current developer has no unified processing logic, so that the database change becomes chaotic and bloated, and the human time cost is increased, the method comprising the following steps: encapsulating an application program and a database management program migration-job based on a k8s platform in a container and deploying the container in a k8s cluster; when the database migration is normally operated, the database management program migration-job is operated in a non-parallel task type Job mode, a container task Pod that undertakes the Job task is constructed, and the container task Pod is used for executing a corresponding database version migration task; the database schema change and rollback sql file of the latest version of a specified database are mounted in the container encapsulating the database management program migration-job; and the database schema change and rollback sql file of the latest version of the specified database are mounted in a host path or a persistent storage volume.

The present invention discloses a maintenance method, device, computer equipment and storage medium for a TiDB database. The method comprises: collecting data in a TiDB production library through a TiDB-Binlog cluster component, obtaining a binlog file corresponding to the data in the TiDB production library, synchronizing the binlog file to a TiDB local disaster recovery library, and then using a preset scheduled backup script to synchronize the binlog file in the TiDB local disaster recovery library to a flash NAS device. When an abnormality in the TiDB production library is monitored, data restoration processing is performed on the TiDB production library based on the binlog file stored in the flash NAS device, thereby avoiding the problem of slow backup and restoration speed caused by directly saving the data in the production library in an archive tape in the traditional method, and improving the efficiency of TiDB database maintenance.

1. The name of the design product: graphical user interface of microorganism culture monitoring system for computer. 2. The use of the design product: for running program. 3. The design points of the design product: the interface content of the graphical user interface. 4. The picture or photo that best shows the design points: interface change state diagram 1. 5. The computer is an existing product, omitting the rear view; the computer is an existing product, omitting the left view; the computer is an existing product, omitting the right view; the computer is an existing product, omitting the top view; the computer is an existing product, omitting the bottom view. 6. The use of the graphical user interface: for operating the microorganism culture monitoring management system through the computer, for interacting with the automatic microorganism culture monitoring instrument, and for controlling the automatic operation of the automatic microorganism culture monitoring instrument on the test reaction process. Front view: running program software, entering the front view; interface change state diagram 1: clicking the result button in the front view, entering interface change state diagram 1; interface change state diagram 2: clicking the statistics button in interface change state diagram 1, entering interface change state diagram 2; interface change state diagram 3: clicking the log button in interface change state diagram 2, entering interface change state diagram 3; interface change state diagram 4: clicking the maintenance button in interface change state diagram 3, entering interface change state diagram 4; interface change state diagram 5: clicking the setting button in interface change state diagram 4, entering interface change state diagram 5; interface change state diagram 6: clicking the database maintenance button in interface change state diagram 5, entering interface change state diagram 6; interface change state diagram 7: clicking the restore button in interface change state diagram 6, entering interface change state diagram 7.

The application relates to the technical field of database maintenance, and discloses a database maintenance analysis method and system based on big data, which comprises the following steps: obtaining the priority maintenance indexes of each database object, generating maintenance work orders according to the numerical values, and taking corresponding maintenance measures on each database object; the application quantitatively calculates the fault risk indexes through multi-dimensional operation data, realizes scientific division of the database risk grades, can accurately identify high-risk databases and trigger deep analysis, avoids excessive consumption of maintenance resources by low-risk databases, and significantly improves the configuration efficiency of maintenance resources; at the same time, a database object dependency graph is constructed, and a graph neural network is used to calculate the correlation influence indexes, so that the influence range of each object in the whole system is accurately quantified, and reliable basis is provided for subsequent maintenance decisions; furthermore, a performance degradation model is constructed by using a time sequence convolution network, and the performance degradation trend of the database object is accurately predicted.

1. Name of this design product: Intelligent pre-review indication rule library graphical user interface for electronic devices. 2. Purpose of this design product: an electronic device. 3. The key design point of this design product lies in the graphical user interface. 4. The picture or photo that best illustrates the key points of the design: main view. 5. Purpose of the graphical user interface: used for database maintenance of drug indications in pre-prescription review. 6. Human-computer interaction mode of graphical user interface: Click the icon on the left side of the interface in the main view to enter the corresponding interface.

The present application relates to a killing method, device, computer device, storage medium, and computer program product, and relates to the field of artificial intelligence technology, and can be used in the field of fintech or other related fields. The method includes: traversing each piece of transaction operation information in a preset background table to determine target transaction operation information that meets a preset killing condition; generating a killing statement according to the session identification information corresponding to the target transaction operation information; and killing the transaction corresponding to the target transaction operation information on a database server based on the killing statement. The killing method provided in this embodiment can accurately identify and timely kill large transactions, reduce the workload of manual database maintenance, and improve the reliability and stability of database production operation.

1. Name of the product of this design: Graphical user interface for maintaining an intelligent prescription usage and dosage database for electronic devices. 2. Purpose of this design product: for use in an electronic device. 3. The key design point of this design product lies in the graphical user interface. 4. The picture or photo that best illustrates the key points of the design: main view. 5. Purpose of the graphical user interface: used for intelligent prescription review and maintenance of the database on drug usage and dosage. 6. Human-computer interaction method of the graphical user interface: In the main view, pull down the drop-down bar in the interface to enter the interface change state diagram 1, continue to pull the drop-down bar to enter the interface change state diagram 2, continue to pull the drop-down bar to enter the interface change state diagram 3, continue to pull the drop-down bar to enter the interface change state diagram 4, continue to pull the drop-down bar to enter the interface change state diagram 5, continue to pull the drop-down bar to enter the interface change state diagram 6, and continue to pull the drop-down bar to enter the interface change state diagram 7.

The embodiment of the application discloses a kind of based on multi-dimension database disaster recovery method and device, collect the network connectivity data of each node in database, database log, operating system kernel log and database event;Wherein, each node includes master node and backup node;According to the network connectivity data of each node, judge whether it meets preset master backup switching condition;If it meets preset master backup switching condition, then trigger master backup switching action;According to the database log of each node, operating system kernel log and database event, predict the failure rate of database in future period;If failure rate exceeds preset threshold, then execute database maintenance task;The application can reach the availability of master and backup nodes by business network card, management network card multi-link detection, avoid the abnormal switching of master and backup simple mutual ping, continuously monitor and predict the probability of master and backup node failure, automatically trigger initiative maintenance.

The invention discloses a collaborative retrieval method and device, electronic equipment and a storage medium. According to the collaborative retrieval method and device, due to the fact that a three-level mixed retrieval framework is adopted, a cache database maintains a high-frequency query result, repeated calculation is reduced, a relational database optimizes structured data retrieval through a joint index, and the retrieval efficiency is improved. The vector database is fragmented according to fields and multi-dimensional vectors are generated to improve the retrieval efficiency of the unstructured data; after retrieval based on the architecture, structured and unstructured results are subjected to multi-modal alignment and weighted fusion in a unified semantic space, a final answer is generated through compliance verification, a cache is updated, and a closed-loop mechanism is formed. The technical effects of improving the real-time performance of insurance business data retrieval, enhancing the structured and unstructured knowledge fusion capability, optimizing retrieval cost control, guaranteeing the service response compliance and improving the user experience and the service efficiency of business scenes such as intelligent customer service and the like are achieved.

The invention belongs to the field of database maintenance, and discloses a method and a related system for rapid data statistics of industrial time series data, which realize standardization and structuring of statistical logic by analyzing a customer data statistical request, extracting a tag name and a statistical task. Semantic differences of different databases in the aspects of statistical functions, aggregation rules, time window definitions and the like are avoided, and statistical tasks can be executed in a unified logic model. According to the method, the statistical task is divided into a plurality of time periods according to the time region, so that the system can independently execute statistical operation in different time windows. The sectional calculation not only improves the parallel calculation efficiency, but also avoids the deviation caused by different time index precisions of the bottom layer of the database, and effectively ensures the consistency and comparability of statistical results.

Disclosed herein are system, method, and computer program product embodiments for maintaining of a geometric object in a database. An embodiment operates by a database maintaining a first page storing a data block in the database's on-disk store such that the data block stores at least one byte of the geometric object. After receiving the request for the geometric object, the database loads the page storing the geometric object in the in-memory store and determines the size of the geometric object. Based on the size of the geometric object, the database stores the geometric object in the in-memory store directly or in a heap of the in-memory store.

The present invention provides a method and system for constructing a knowledge base based on a large language model, the method comprising: preprocessing the original text to obtain a plurality of original text paragraphs; deeply elaborating each of the original text paragraphs through a language enhancement model to generate detailed text content, and converting the detailed text content into a high-dimensional vector through a text vector model, wherein the high-dimensional vector matches one of the original text paragraphs; and storing the high-dimensional vector and the corresponding original text paragraph in a database, wherein the database supports vector indexing and retrieval operations. Through this application, the productivity of text processing can be improved, which is conducive to saving a certain amount of manpower and material resources, and is also conducive to reducing the difficulty of database maintenance.

The invention discloses an automatic database updating method and system based on a large language model, and the method comprises the steps: carrying out the automatic login and data comparison of a website, and recognizing and obtaining a newly-added or updated document; analyzing the document to extract text content, and sequentially performing safety review and information quality review on the text content by using a large language model; and outputting the text content passing the information quality review and the metadata to be stored in a database, and updating a local cache to record the latest processing state of the document, so as to continuously perform incremental updating. According to the method, full-process automatic management of professional document database updating is realized; the labor cost and the economic cost of database maintenance are obviously reduced; a classification system dynamically configured by a user is supported, so that the same system can seamlessly adapt to professional requirements of different vertical fields such as finance, law and medical treatment, and the system has universality and cross-field adaptation capability.

This disclosure describes systems, software, and computer implemented methods for maintaining travel databases and providing improved search results from them. Implementations include querying a plurality of data sources using a plurality of extractors. The plurality of extractors can receive travel information from the plurality of data sources and populate a software object with the travel information to generate structured travel information which can be submitted to an extraction queue. A data keeper can extract structured travel information of the particular category from the extraction queue and submit the structured travel information to a database queue. A canonical database manager (CDM) can extract the structured travel information of the particular category from the database queue.

A method, including the steps of: a) receiving, over a mobile communication network, a user device identifier based on information maintained by a database of the mobile communication network, and first purchase price information from an internet-accessible merchant, b) determining whether a data token is maintained in a memory of the user device, c) generating and transmitting the data token to the user device for storage when the token is not maintained, d) determining, based on the user device identifier, a credit worthiness indicator for the user device, e) transmitting an authorization signal for the requested purchase without concurrently requiring payment when the creditworthiness indicator satisfies predetermined conditions, f) monitoring a total outstanding purchase balance, and g) transmitting a request signal for the user device for settlement of at least a part of the total outstanding purchase balance if this exceeds a predetermined threshold amount.

Disclosed are a method and a system for changing a database schema. The method comprises receiving a request to make a set of changes to a first version of the database schema of a database, and creating, based on the set of changes to the first version, a conversion rule for converting data records maintained by the database between the first version and a second version of the database schema. The second version results from the application of the set of changes to the first version of the database schema. The method further comprises storing the conversion rule for retrieval when performing data operations on the data records in accordance with any database schema version in a set of supported versions comprising the first version and the second version of the database schema. Also disclosed are methods and systems for performing data operations on databases supporting multiple versions of a database schema.

This invention discloses a method, device, and medium for locating and repairing slow queries related to database maintenance debt. Belonging to the field of database technology, it addresses the technical problems in existing PostgreSQL databases where MVCC maintenance delays easily lead to insufficient granularity in locating the root causes of slow queries, unquantified maintenance status, lack of orchestration between repair actions and business risks, and lack of feedback on the effectiveness of repairs. The method includes: performing multi-factor weighted calculation of maintenance debt on mapped access objects; generating traceable paths between slow queries and the underlying MVCC maintenance status on the constructed SQL-object-transaction-maintenance task association graph; performing weighted calculation of root cause confidence for candidate root cause paths; calculating the risk level of repair actions corresponding to the root cause candidate list; performing repair execution on the current database that meets the execution conditions, and recording the corresponding repair effects.

The present disclosure describes techniques for facilitating a collaborative work environment. The techniques comprise creating a plurality of virtual rooms asynchronously accessible by a plurality of users, wherein at least one database maintains a status for each of the plurality of users indicating whether each of the plurality of users is associated with at least one of the plurality of virtual rooms; receiving a request from a first user among the plurality of users to associate with a first virtual room among the plurality of virtual rooms; and permitting the first user to associate with the first virtual room by enabling real-time communications between the first user and other users among the plurality of users who are associated with the first virtual room.

The invention discloses a remote loading maintenance system for civil aircrafts, and relates to the technical field of civil aviation onboard software management, the remote loading maintenance system maintains configuration information of multiple aircrafts and LRU equipment on the aircrafts through a configuration database, and when loadable onboard software imported from the outside is stored and managed, the loadable onboard software is stored and managed through the configuration database. An applicable configuration association table is associated based on data matching in a configuration database and is stored as an important carrier in a data loading process; in the data loading stage, the applicable configuration association table of the loadable airborne software is automatically matched, accurate matching of the loadable airborne software and the airborne hardware is achieved, loading failure or equipment failure caused by configuration incompatibility is avoided, then automatic remote loading and whole-process remote control can be achieved through a wireless path, and the loading efficiency is improved. And the automation degree and the operation and maintenance efficiency of the civil aircraft data loading process are improved.

The present disclosure relates to the technical field of computer, in particular to a database maintenance method and device, electronic equipment and readable storage medium. The database maintenance method comprises: obtaining an audit structured query language (SQL) statement recorded when auditing a specified database; determining the category of the audit SQL statement according to the command of the audit SQL statement; analyzing the audit SQL statement to determine the mode of the audit SQL statement; recording the category of the audit SQL statement and the mode of the audit SQL statement in an audit SQL statement summary record table; and maintaining the database using the audit SQL statement summary record table. The present disclosure determines the category and mode of the obtained audit SQL statement, classifies it, and replaces the specified field value according to the preset rule, so that the database can be maintained according to the content in the summary record table, and the sensitive information leakage is avoided, and the information security is protected.

Systems and methods for automated mainframe database maintenance are provided. In implementations, a method includes obtaining, by a computing device, real-time performance metrics of a mainframe database; automatically generating, by the computing device, a predicted maintenance task as an output of a trained database maintenance task classification machine learning (ML) model based on an input of the real-time performance metrics; automatically generating, by the computing device, a time to execute the predicted maintenance task as an output of a trained database maintenance triggering ML model based on an input of the predicted maintenance task and the real-time performance metrics; automatically generating, by the computing device, maintenance task instructions for the mainframe database based on the predicted maintenance task, the time to execute the predicted maintenance task, and a maintenance profile of the mainframe database; and automatically initiating, by the computing device, the execution of the maintenance task instructions.

The embodiment of the invention provides a data processing method and device, equipment, a storage medium and a program product, and is applied to the technical field of databases. The method comprises the steps that under the condition that a variable declaration statement is received, the variable declaration statement is analyzed, and a type identifier of a type quoted by a target variable of declaration is obtained; and determining whether the type referenced by the target variable is a table type or not according to the type identifier. If yes, the target variable is created, and the target variable is a table variable. And under the condition that a target operation statement including the target variable is received, executing a data processing operation corresponding to the target variable on a target temporary table corresponding to the target variable. The method provided by the invention can improve the working efficiency of the database and reduce the maintenance cost of the database.

The invention provides a ship design change single whole process data management method and system, and the method comprises the steps: constructing a standard database, and maintaining standard data; inputting design data, purchase data, operation data, production data and quality data; carrying out the calculation through the change list issuing time, the tray plan distribution time and the tray standard manufacturing period, and carrying out the change list material application judgment; carrying out change order dispatching judgment through change order material application judgment and a change order stage; and through the original drawing work package number, the original drawing work package state and the original drawing work package real work time, single construction department change and waste return judgment are carried out. The data management method runs through data specifications and association relationships of all links such as design, purchase, production, operation and quality, realizes data entry and management in the whole process of a design change list, ensures close collaboration of the links such as design, purchase, production and quality in the change process, and significantly improves the overall efficiency and project management level of ship construction.

The invention belongs to the technical field of network security verification, and particularly relates to a virtuality and reality combined cyberspace anti-mapping verification system. According to the system, a dynamically evolvable simulation verification environment is constructed through a virtual cluster dynamic recombination technology, a resource pooling scheduling engine and an anti-mapping transformation strategy. The method specifically comprises the steps that a server resource pooling module dynamically allocates physical resources; the virtualization engine generates heterogeneous nodes including a virtual machine and a virtual router; the anti-mapping module resists network scanning through dynamic topological transformation and a traffic confusion strategy; the topology management module is used for maintaining network topology information of different experiments and surveying and mapping / surveying and mapping resisting data in the experiment process through a database; the real-time visualization module monitors the cluster state and supports environment snapshot import / export; and the user authentication module realizes hierarchical authority management. The method solves the problems that the static topology of an existing verification system is easily identified by surveying and mapping and the resource utilization rate is low, and the authenticity and the concealment of network security testing are remarkably improved.

This invention refers to a method and a system to secure automated compensation of reciprocal debts of at least three users provided with user devices The users send user sensitive data, user statistical data, user debt data and user compensation criteria to an identity computing unit of a first server, whereas global statistical data about the users is received from one or more global statistic data sources. The identity computing unit encrypts the user sensitive data outputting anonymized user sensitive data, generates a user profile encoder, encodes the user statistical data with it, outputting encoded user statistical data, and sends the anonymized user n sensitive data, the corresponding user debt data, the user compensation criteria and the corresponding encoded user statistical data to a compensation computing unit of a second server. The compensation computing unit creates compensation rules based on the encoded user statistical data, computes a plurality of compensation circles for the user debt data based on them, selects and ranks the compensation circles that satisfy the user compensation criteria and outputs the ranked compensation circles in descending order. Then, the compensation computing unit sends compensation requests to the user devices via the identity computing unit, the latter decrypts the anonymized user sensitive data, the compensation requests being displayed on the user devices during a predetermined period of time. The compensation computing unit receives the compensation approvals, executes the compensation of the debts for the highest-ranking compensation circle in descending order, called approved compensation circle, stores the approved compensation circle in a cryptographically signed and timestamped digital ledger maintained by a database and updates the plurality of compensation circles by removal of the approved compensation circle and updates the user debt data.

This application relates to the field of database technology, specifically a method and apparatus for remotely maintaining a database via a client. The method includes: acquiring database maintenance items to be uploaded; analyzing and obtaining the processing nodes for these maintenance items, including a first administrator node and a first intermediate node; if the database maintenance item is located at the first intermediate node, acquiring relevant historical data on uploading the database maintenance item to the first administrator node via the first intermediate node; based on the relevant historical data, acquiring the historical upload efficiency of the first intermediate node; if the historical upload efficiency is lower than a preset efficiency threshold, assigning maintenance permissions to the client of the first intermediate node, allowing remote database maintenance via the client of the first intermediate node. Using this method, relevant personnel at the central node can directly perform maintenance operations on the client, improving the efficiency of database maintenance.

The invention relates to a method and a device for quickly increasing columns on an openGauss database without blocking queries. The method comprises the following steps: detecting an option of a newly added column, and triggering a rapid column adding process when a condition is met; during the period of increasing the column operation, 7-level locks are applied to the target table and associated toast table and partition table objects, and 1-level locks are kept for concurrent query operation, so that the compatibility of lock levels is realized to avoid mutual blocking; the method comprises the following steps: freezing a column metadata snapshot during query through an opentables object, and processing column projection and condition calculation based on a snapshot version in semantic processing, planning and execution stages of query to ensure data consistency; and the planner and the executor allocate memories and parse tuples based on the snapshot version, so that memory cross-border or data dislocation caused by concurrent column change is avoided. According to the technical scheme, concurrent execution of the column operation and the query operation can be increased, the database maintenance efficiency is improved, the blocking risk is reduced, and the query consistency is guaranteed.

The present application relates to the technical field of server, and specifically provides a kind of server power information verification method, system, terminal and storage medium, comprising: the actual power information of target server is collected;Decompose the parameter item of power information to generate multiple levels of comparison items;From the actual power information, sample data belonging to comparison item is collected, and the consistency comparison of the sample data and the pre-stored standard data is carried out;The data consistency comparison result of all comparison items is summarized and output.The present application can realize the multi-aspect verification of the power information of server, ensure that there is no difference between the actual power information of shipment server and the database maintenance power information, avoid the situation of missing detection and error detection, find and solve problems before shipment, improve product quality and avoid loss.