12 results about "Relational database management system" patented technology

Techniques discussed herein relate to an object-relational database management system (ODMS) (e.g., a PostgreSQL ODMS) that provides in-line materialization of database pages corresponding to read requests. A replica node of the ODMS may be configured to share access to a shared block storage volume with a primary node. The replica node may receive log updates from the primary indicating changes to the object-relational database. The read replica, in response to receiving a read request, may update a previous version of a database page, store the database page in local memory, and replay the log updates to update the database page in local memory. Data may be provided from the updated database page in response to the read request.

The present disclosure relates to efficiently constructing in-memory HNSW vector indexes in a database management system (DBMS). A DBMS may store in memory a segmented array, wherein the segmented array may store representations of a plurality of vectors from a database. A hierarchical navigable small world (HNSW) vector index may be constructed in the memory, wherein the HNSW vector index may index the plurality of vectors. A similarity search may be performed using the HNSW vector index.

A digital processing system for assessing urban resilience, consisting of: a central server, equipped with a multi-core processor and dedicated storage units; a relational database management system connected to the aforementioned centralization server and configured to store spatial geodata, demographic datasets, historical hazard events, land use datasets, building inventory, infrastructure systems, government policies, and stakeholder information; a geodata processing module that is operated via the multi-core processor and has mapping and spatial analysis functions; a vulnerability calculation engine that runs on the multi-core processor and is configured to calculate sensitivity and exposure indices; an adaptive capacity assessment engine that runs on the multi-core processor and is configured to assess coping and adaptation mechanisms; an urban planning attribute analyzer that is powered by the aforementioned multi-core processor and configured to process data on land use diversity, infrastructure robustness, and resource decentralization; a governance assessment module that runs on the multi-core processor and is configured to assess institutional frameworks and stakeholder engagement mechanisms; an integration and synthesis engine connected to the central server and configured to correlate data from the aforementioned modules and to take into account the five Ws of urban resilience; and a reporting and visualization module integrated into a user interface configured to display assessment results, recommendations, and interactive maps.

A method for functionally rewriting an iterative query of a relational database management system (RDBMS) is provided. The method includes receiving a first iterative query having a first non-iterative portion defining a first main table and a first iterative portion generating values in rows of a first work table based on values in rows of the first main table, determining that the first iterative portion modifies all rows of the first work table, and rewriting the first iterative portion including: adding a rename operation to rename the first work table to a new first main table and rename the first main table to a new first work table; adding a first delete operation to delete each row of the new first main table; and adding a first loop operation to repeat the first iterative portion until a first termination condition is satisfied.

Embodiments of the present application provide a data auditing method and related device, which are used to realize asynchronous auditing of machine auditing and manual auditing, and prevent business data loss in the process of machine auditing. The method comprises the following steps: storing target business data in a relational database management system by using a message queue; calling the target business data stored in the relational database management system by using the message queue according to a preset frequency; generating a business auditing table according to the target business data, generating an identity ID of the business auditing table, and returning the ID to a business side, wherein the business auditing table is used to describe the target business data and a business auditing strategy corresponding to the target business data; detecting the target business data based on the business auditing strategy to obtain a label result set, wherein the label result set comprises a plurality of label data; and determining an auditing result of the target business data according to the label result set.

A method, apparatus, and computer program product for executing a relational database management system (RDBMS) in a computer system, wherein the RDBMS manages a relational database storing data in a table having an open table format (OTF). The RDBMS maintains a cache for the data stored in the table, and determines whether the cache is stale using metadata for the table that is stored in the cache. The RDBMS incrementally updates the cache when the cache is stale.

Techniques discussed herein relate to an object-relational database management system (ODMS) (e.g., a PostgreSQL ODMS) that utilizes a shared block storage volume (SBSV) for storage. The SBSV may utilize a file system that enables a single-writer-multiple reader model in which a primary computing node may read or write to the SBSV and one or more replica computing nodes are restricted from writing to the SBSV. To enable the primary computing node to write data at its own pace, regardless of the status of synchronization at each of the one or more replica computing nodes, the SBSV may include a staging area that maintains data that has not yet been updated at one or more of the replica computing nodes. When the primary computing node no longer maintains the data in local memory, the one or more replica computing nodes may obtain the data from the staging area of the SBSV.

The application provides a method for automatically writing a relational expression of a Creo-based standard part, comprising the following steps: using a relational database management system to build a standard part parameter database, creating a corresponding data table, and storing parameter information of the standard part; writing a relational expression automatic writing program according to a Creo secondary development interface, and realizing the following steps: connecting with the standard part parameter database; obtaining standard part information selected by a user; generating a corresponding relational expression; writing the generated relational expression into a Creo standard part model; when the relational expression is generated, setting parameter association rules according to relationships between parameters of the standard part and design requirements; in the Creo standard part model, monitoring changes of the standard part parameters in real time by registering an event listener; and an event processing function automatically updating other parameters associated with the parameter according to preset parameter association rules, so as to ensure consistency and accuracy of the model.

The subject technology provides embodiments for integrating data lake functionality within a relational database management system (RDBMS) through a specialized RDBMS Data Lake Module. The subject technology enables database systems to natively support data lake table formats using SQL syntax. The system implements dual-mode access patterns supporting both internal operations through standard RDBMS interfaces and external operations via a catalog API, enabling multiple systems to access the same data lake tables without duplication. The RDBMS Data Lake Module comprises three integrated components: a lake format engine for translating SQL queries to object storage operations, a catalog manager for maintaining transactional consistency, and a catalog API for external system coordination.

Among other techniques, techniques for dynamic survivorship, cross-tenant matching, and lineage entity identifier (EID) promotion are described. A system utilizing these techniques can include an EID assignment engine, a progressive stitching engine, and a data item update engine. The progressive stitching engine can be at least conceptually characterized as comprising a data point onboarding subengine, a data point registration subengine, a data point matching subengine, and a data point merging subengine. A method utilizing these techniques can include assigning a data item EID to a data item, onboarding a data point, assigning a data point EID to the data point, matching the data point with the data item in a multitenant EID lineage-persistent relational database management system (RDBMS), merging the data point with the data item to create a merged data item, and changing the data item, triggering survivorship and lineage EID promotion rules.

The invention discloses a data backup method and device, electronic equipment and a readable storage medium, which are used for solving the technical problems that the data backup process is difficult to monitor and manage, the occupied storage space is large, and an effective compression mechanism is lacked. The method comprises the steps that when a to-be-executed task created by a user for identity authentication service data is detected in a preset database, the backup type of the to-be-executed task is determined; determining a database table and a file directory of the to-be-executed task according to the backup type; when the backup type is a person-certificate record, exporting the database table as a first comma separation value file by using a COPY command of a relational database management system; compressing the first comma separation value file by using a zstd compression algorithm to obtain first backup data; and backing up the file directory by using a command line program to obtain second backup data.

A system includes a relational database management system component and a column-oriented data processing component. The relational database system component stores database information in a row format. The column-oriented data processing component stores the database information in a column format. In response to a database update request, the relational database management system component updates the database information stored in the row format; the relational database management system component notifies the column-oriented data processing component of the database update request; and the column-oriented data processing component updates the database information stored in the column format. In response to a query request, the column-oriented data processing component generates a query response based on the database information stored in the column format. In this manner, the system is able to generate up-to-date reports without the need for extraction, translation and loading procedures.