29 results about "Database catalog" patented technology

The invention discloses a context learning-based database query generation method and system and a storage medium, and the method comprises the steps: extracting keywords and phrases from a natural language query, retrieving values similar to the keywords in a database, and returning values most related to the keywords and corresponding columns thereof, retrieving description information related to the keywords and the phrases in a database directory; performing mode selection aiming at the most relevant value of each keyword and the corresponding column, namely screening out the column irrelevant to the natural language query, further selecting a table necessary for generating the SQL query, and finally reducing the mode to a minimum column set necessary for generating the SQL query; and correcting logic and grammar errors of the method model through the database mode, the natural language query, the generated candidate SQL query and the execution result thereof. According to the method, the efficient SQL query statement is generated by intelligently understanding the data context and the query requirement.

The present invention provides a method, system, device and medium for automatically cataloging RQD of drilling cores, which belongs to the field of underground engineering drilling engineering informatization. The system of the present invention includes an image acquisition module, an image preprocessing module, an RQD calculation module and a cataloging module. The present invention collects core box images in batches in a standardized manner, uses a semantic segmentation network and a projection transformation to correct the distortion of the core box images, and then uses semantic segmentation to mark core blocks of 10CM and above, sorts the recognition results and calculates the RQD; uploads the on-site collected images to the cloud, and integrates the core box image correction and RQD calculation algorithm in the cloud, and performs image data storage, RQD calculation and RQD database cataloging in the cloud to achieve digitalized and standardized data backup. The technical solution of the invention can efficiently and standardizedly digitize and store core information, reduce the cost of mine data storage, improve data utilization, and provide data basis for mine rock mass quality evaluation.

A system includes reception of a first transaction including updates to a database catalog comprising transactions stored on a log and a timestamp of a snapshot of the database catalog, determination of a signature of a transaction stored on the log after the timestamp of the snapshot, determination, based on the signature, that a conflict exists between the updates to the database catalog and updates of the stored transaction, and, in response to the determination that a conflict exists, reject the first transaction.

Systems as described herein may implement a data management ecosystem for databases. A computing device may receive, from a first user device, a request to migrate one or more data objects from a sandbox to a production environment. The production environment may include a plurality of data warehouses that may be provided as a service in a cloud computing environment, and computing resources are dynamically allocated to the plurality of data warehouses. The computing device may determine lineage information and update a database catalog of the data warehouses with the lineage information. The computing device may identify sensitive data contained within the one or more data objects and generate tokenization for the sensitive data. Based on the lineage information in the database catalog and the tokenization, the computing device may generate a migration plan and cause the at least one of the plurality of data warehouses to execute the migration plan.

Techniques are disclosed that pertain to upgrading a database application. A computer system may determine to upgrade a database application from a current version associated with a first instance of a database catalog that defines the structure of a database that is managed by that database application. The first instance is associated with a first catalog signature that is indicative of the first instance of the database catalog. The computer system generates a second catalog signature that is indicative of a second instance of the database catalog that is associated with the different version. The computer system compares the first catalog signature and the second catalog signature to determine whether the database catalog changes between the current and different versions. Based on the comparing, the computer system then selects one of multiple upgrade processes performable to upgrade the database application to the different version and performs the selected upgrade process.

System for automating job matching comprises a user interface 102 for uploading job descriptions 114 and resumes 116, and displaying ranked results of candidate suitability of each job requirement. A database directory 104 stores the job descriptions and resumes. A document extension module 106 examines the file extensions of the stored documents to verify a file type or format. A processing module 108 comprises a large language model (LLM) 110 for processing and interpreting resume content through machine-readable instructions (e.g. natural language processing). This may include generating embeddings (by tokenising the documents, semantically analysing them, and assessing a textual context) and retrievers for each document, merging retrievers for respective resume and job description into one document, and creating filters for embedding and compressing the merged document. A master retriever and prompt template may be created. The LLM is coupled to vector database 118 for performing similarity searching with an embedding vector. A scoring module 112 (e.g. having rubric-based scoring templates and matching algorithm) scores candidates based on suitability for each job requirement. The scoring module may include computing scores based on relevant experience (112a, fig.1A), projects (112b, fig.1A), qualifications (112c, fig.1A), and skills (112d, fig.1A) in the candidate resumes.

A query processing device comprising: a communication interface for accessing a database and a database directory; the memory is used for storing instructions; and a processor coupled to the memory and the communication interface. The processor executes the instructions to: parse a query to generate first and second execution plans for the query; retrieving, from the database directory, respective previously determined radix values for previously executed logical steps of the first and second execution plans; selecting an execution plan from the first execution plan or the second execution plan, the selected execution plan having a lower cost based on the previously determined cardinal value; and executing the selected execution plan on data accessed from the database. The query processing system stores an actual radix value determined during execution of the logical step in the database directory for use by subsequent queries. Accordingly, the query processing apparatus may reuse a previously determined cardinal value.

The invention provides an on-chain and off-chain dynamic mapping method for a data directory based on a block chain and an oracle machine and a related device, and belongs to the technical field of block chains. According to the invention, based on bound user identity registration information, database directory information uploaded to a distributed storage system is synchronized to a block chain by using a block chain oracle machine technology; when the database directory information is synchronized to the block chain, casting the DNFT according to the database directory information uploaded to the distributed storage system, and dynamically storing the database directory information on the block chain by using the cast DNFT; and establishing a dynamic mapping relationship between the database directory information on the block chain dynamically stored by the cast DNFT and the database directory information acquired from the block chain, and realizing dynamic mapping of the database directory information on the block chain and the database directory information under the block chain. According to the method, the problems that the on-chain and off-chain data mapping is difficult to flexibly and efficiently realize according to the actual condition during database operation, and the improvement of the overall system performance is limited are solved.

An improved data system supports creation of multiple hierarchical database catalogs under a particular account. Users or organizations have the flexibility to organize their data, native or external, into an n-level hierarchy of their choice. There is a root database catalog of the account, and other catalogs (1 or n-levels) are created under it. The data system has extract, transform, and load (ETL) features that allows data to be moved between different data sources and targets.

The invention relates to an orphan file processing method and device, computer equipment, a computer readable storage medium and a computer program product. The method comprises the steps that an orphan file processing instruction is obtained, the orphan file processing instruction carries a target database label, and the target database label is used for determining a target database for executing the orphan file processing instruction; querying a database directory table by using the target database tag, determining a storage space corresponding to the target database, and obtaining each file in the storage space to obtain a first file data set; according to the target database label, a corresponding table record table is determined, a target field in the table record table is determined, and the target field is matched with a field value of a preset field; obtaining each file corresponding to the target field to obtain a second file data set; and determining the orphan file according to the first file data set and the second file data set. By adopting the method, the accuracy of orphan file determination can be improved.

Described herein are systems and techniques to facilitate a rapid database system that automates estimating a database footprint for a database implemented across multiple environments. The system may receive inputs from a user and / or automatically generate inputs. The system may determine database size using various logic-based extraction methods. For instance, operational database resources may be sized using logic-based extraction to search a database catalog of a production database, non-production databases may be sized using logic-based extraction to search database catalog metadata, development database resources may be sized using fuzzy logic queries generated based on production database information (e.g., since development database names are likely to resemble, but be different than, production database names), and associated mirror databases are also determined and measured during these steps. Outputs from the queries are used to generate a database footprint estimate and cost information, which may be transmitted to a user device for display.

A method, computer program product, and computer system are provided. Statistics for each columnar table are extracted from an online analytical processing (OLAP) database catalog. A transaction table map is created from transaction log records of an online transaction processing (OLTP) database. The transaction table map includes a counter of log records in a transaction and a timestamp indicating a longevity of the transaction. Based on the counter or the longevity exceeding a predefined threshold, the transaction is transformed, and sent to the OLAP database where it is replayed.

The present invention discloses a maintenance mode-based database abnormal state repair method and system, belonging to the field of database technology. The technical problem to be solved is how to access a database and restore data when the database enters an abnormal state and cannot be logged in. The method comprises: running a maintenance mode on the server where the database is located; using the password entered when the database directory is initialized as the maintenance mode password, calculating a hash value of the maintenance mode password as a check value and storing it in the database directory; when maintenance mode is activated, calculating a hash value of the input password and comparing the generated hash value with the check value; loading two specified template files when the database enters maintenance mode, and if at least one of the template files is successfully loaded, the database enters maintenance mode; replaying user-added data using a data playback tool in maintenance mode; and recording the operation process in a log, which is stored in an audit log.

A computer system may determine to perform an upgrade operation to deploy a second database application that is a different version than a first database application associated with a first database catalog that stores catalog objects. The computer system performs the upgrade operation, including preparing a second database catalog and deploying the second database application to manage a database based on the second database catalog. To prepare the second database catalog, the computer system may create the second database catalog and store, in the second database catalog, system catalog objects that are associated with the second database application. The computer system may further identify, from the catalog objects stored in the first database catalog, user catalog objects that were created by users of the database and then copy the identified user catalog objects from the first database catalog to the second database catalog.

A method, device and system for building a master and standby database can be used in the financial field or other fields. The method includes: obtaining the IP address of the master database server and the standby database server, determining the file size and number of the master database instance information, directory list and online redo log; creating a standby database redo log in the master database according to the file size and the number of files; generating a connection string and adding it to the descriptor configuration file of the master database server; obtaining a password file, a parameter file and a descriptor configuration file from the master database, and synchronizing them to the standby database according to the standby database server IP; creating a standby database directory list in the standby database according to the master database directory list, and storing each file under the standby database directory list, so that the standby database obtains the standby database redo log from the master database and copies the data. The present invention reduces the professional threshold for building master and standby databases and improves the accuracy, efficiency and quality of daily operation and maintenance.

An improved data system supports creation of multiple hierarchical database catalogs under a particular account. Users or organizations have the flexibility to organize their data, native or external, into an n-level hierarchy of their choice. There is a root database catalog of the account, and other catalogs (1 or n-levels) are created under it. The data system has extract, transform, and load (ETL) features that allows data to be moved between different data sources and targets.

A system includes reception of a first transaction including updates to a database catalog comprising transactions stored on a log and a timestamp of a snapshot of the database catalog, determination of a signature of a transaction stored on the log after the timestamp of the snapshot, determination, based on the signature, that a conflict exists between the updates to the database catalog and updates of the stored transaction, and, in response to the determination that a conflict exists, reject the first transaction.

Systems, methods are provided for encrypting, decrypting, re-encrypting an existing database with neither downtime nor storage overhead. Create a list of tables to be processed. Identify status of each table by an indicator in a database catalog. Store a second status in each data page. Select a table to process from list of tables. Issue a table lock against the selected table. Select a configurable number of data pages to process during the duration of the table lock. Following the processing, flush the data pages to storage. If there are no more data pages to encrypt for the selected table, remove the selected table from the list of tables to be processed. Release the table lock. If there are more data pages to process in the selected table, and there are waiters for the selected table, release the table lock; select another table from the list of tables to process.

The present invention relates to the technical field of database management, and in particular to a data warehouse management system, comprising: a database configured as a plurality of distributed spaces, wherein the capacity of each distributed space is configured as a corresponding fixed value; an archive library configured as a plurality of archive spaces, and a pedometer, which is used to execute a reset instruction to the archive library according to the state of the running archive and the archive directory; a cache manager connected to the archive library and the pedometer, which is used to record the origin of the archive directory and overwrite the origin of the archive directory in the archive library in response to the reset instruction; the present invention utilizes the method of configuring an archive library for a database, configuring a pedometer and a cache manager outside the database, to record and cache the directory of the database, and while effectively improving the management performance of the database directory, utilizes the database directory to perform reverse operations on the database, and while improving the capacity efficiency of the database, effectively improves the controllability of the distributed database.

Disclosed in the embodiments of the present application are a data backup method, an electronic device, and a computer-readable storage medium. The method is applied to an electronic device, which comprises a central processing unit, a memory and a hardware acceleration device, wherein the memory comprises a first buffer area. The method specifically comprises: reading first data from a first data file, and storing the read first data into a first buffer area, wherein the first data file is stored in a data disc corresponding to an original database directory; compressing the first data in the first buffer area by means of the hardware acceleration device, so as to generate backup data corresponding to the first data; and writing the backup data into a data disc corresponding to a backup directory. The embodiments of the present application can improve the efficiency of data backup.

The application provides a database cluster physical backup method and related products. The database cluster physical backup method comprises the following steps: an initiating node reads a configuration file stored by itself, initiates a physical backup process, and acquires a starting log sequence number; a backup set label of this backup is constructed; the starting log sequence number and the backup set label are synchronized to other nodes, and the other nodes are guided to verify whether they participate in this backup; the initiating node acquires meta information of all files in a database directory, and distributes a required copy file list to each node participating in this backup according to the configuration file of the initiating node; each node is guided to copy files according to the distributed file list, so that each node records the meta information of the copied files in the copying process; and the initiating node receives the meta information of the copied files returned by each node. The application has the advantage that all available nodes can participate in backup, and resource consumption and occupation caused by single node backup are avoided.

Methods and systems for assisting the programming of stimulation parameters for deep brain stimulation (DBS) of a subject patient are described. An accumulated database catalogues stimulation parameter sets used in programming sessions for a plurality of patients and correlates the parameter sets with good therapeutic results and / or with side effects. The accumulated database also includes stimulation field models (SFMs) for the parameter sets. Overlap of the SFMs for parameter sets may be correlated with therapeutic effects and used to determine target volumes and or avoidance volumes for the stimulation of the subject patient. In some embodiments, the SFMs may be weighted to de-emphasize volumes proximate to the electrode lead.

Systems as described herein may implement a data management ecosystem for databases. A computing device may receive, from a first user device, a request to migrate one or more data objects from a sandbox to a production environment. The production environment may include a plurality of data warehouses that may be provided as a service in a cloud computing environment, and computing resources are dynamically allocated to the plurality of data warehouses. The computing device may determine lineage information and update a database catalog of the data warehouses with the lineage information. The computing device may determine sensitive data contained within the one or more data objects and generate tokenization for the determined sensitive data. Based on the lineage information in the database catalog and the tokenization, the computing device may generate a migration plan and cause the at least one of the plurality of data warehouses to execute the migration plan.

The present application relates to the field of computer technology, and in particular to a distributed database catalog management method, system, electronic device and readable storage medium, wherein the method includes a database agent sending updated catalog information to a catalog server; wherein the database agent is a front-end middleware for accessing a database, and the database agent stores the catalog of the database; the catalog server sends the received database catalog update to a catalog database; the catalog database receives the database catalog update and updates the stored database catalog. The technical solution of the present application is more flexible in maintaining the catalog data of a distributed database, and can be based on both the catalog server and the database agent node, with stronger fault tolerance, ensuring the timeliness and consistency of the catalog data of the distributed database on each node, and ensuring the continuous availability of the distributed database under a mixed online transaction load.

The invention discloses a database abnormal state repairing method and system based on a maintenance mode, belongs to the technical field of databases, and aims to solve the technical problem of how to enter a database and recover data when the database enters an abnormal state and cannot log in. Comprising the steps that a maintenance mode runs on a server where a database is located; taking a password input when a database directory is initialized as a maintenance mode password, calculating a hash value of the maintenance mode password as a verification value, and storing the verification value in the directory of the database; when the maintenance mode is started, calculating a hash value of the input password, and comparing the generated hash value with the check value; when the database enters the maintenance mode, loading two specified template files, and if at least one template file is successfully loaded, enabling the database to enter the maintenance mode; in the maintenance mode, playing back the data added by the user through a data playback tool; and performing log recording on the operation process, and storing the recorded operation log in the audit log.

To recover from a first database application that is in an unstable condition, a computer system deploys a first instance of a second database application with an override condition that causes the first instance to use a first database catalog used by the first database application. Content of the first database catalog is different than content expected by the second database application. The computer system performs a process to create a second database catalog that includes the content expected by the second database application. The process may include communicating with the first instance to access catalog objects from the first database catalog and insert them into the second database catalog. The computer system then deploys a second instance of the second database application without the override condition to cause the second instance to use the second database catalog that includes the content expected by the second database application.

An artificial intelligence-based system 100 automates matching positions by evaluating whether each candidate resume meets position requirements. The system comprises: a user interface 102 for an administrator to upload a position description and a candidate resume; the database directory module 104 is used for data storage; the document extension module 106 is used for file verification; and a processing module 108 having a large language model 110, at least one vector database 118, and a scoring module 112. And the processing module interprets the content of the resume through a machine readable instruction, executes similarity search, and scores in real time according to whether a candidate is suitable for each position requirement or not. The method 200 of the invention includes receiving and managing job descriptions and resumes, verifying document formats, processing the resumes and job descriptions, and displaying ranking results. In the processing step (208), the method further includes processing and interpreting the resume content, performing real-time suitability scoring on candidates, and comparing eligibility and skills with job descriptions.

Methods and systems are described for assisting in programming stimulation parameters for deep brain stimulation (DBS) of a subject patient. A cumulative database records a set of stimulation parameters used in a programming session for a plurality of patients and associates the set of parameters with good treatment outcomes and / or side effects. The cumulative database also includes a stimulus field model (SFM) for the set of parameters. The overlap of the SFM for the set of parameters may be associated with a therapeutic effect and used to determine a target volume and / or an avoidance volume for stimulation of the subject patient. In some embodiments, the SFMs may be weighted to de-emphasize the volume near the electrode leads.

In certain implementations, an export plan is received, from a first database, that comprises instructions executable to create catalog objects of the first database having a relational structure. The export plan may be translated into an import plan for a second database, the import plan comprising multiple import operations and being based on a second syntax that is different from a first syntax of the export plan. The multiple input operations of the import plan may be executed in parallel to generate first import results. The first import results may be filtered and aggregated to generate second import results. The second import results may be merge sorted to generate third import results. The third import results may be imported into the second database, the third import results being consistent with the catalog objects of the first database.