Patents
Literature
Patsnap Eureka AI that helps you search prior art, draft patents, and assess FTO risks, powered by patent and scientific literature data.

243 results about "Database object" patented technology

A database object is any defined object in a database that is used to store or reference data.Anything which we make from create command is known as Database Object.It can be used to hold and manipulate the data.Some of the examples of database objects are : view, sequence, indexes, etc. Table – Basic unit of storage; composed rows and columns

Language model prompt authoring and execution in a database system

A database system may include one or more relational databases storing information for a plurality of tenants in accordance with database object definitions. The database system may also include a communication interface providing the plurality of tenants with access to web applications through which to access the information and configured to receive an indication of one or more of the database object definitions from a tenant. The database system may also include a storage device storing a prompt template specific to the tenant and that includes one or more natural language instructions for generating text and a reference to the one or more database object definitions. The database system may also include a processor configured to retrieve a database record associated with the tenant and corresponding to the one or more database object definitions and to determine a text generation prompt based on the database record and the prompt template.
Owner:SALESFORCE INC

Augmenting system access control perspective

A system and method for dynamically visualize and modify user authority and security resource edge based on access behaviors in a cloud computing environment. The method provides a new access control perspective to ensure the credibility of database object usage patterns, build clearer and explicit security data consumption mode for data usage requests, and guide tenants to have a more comprehensive understanding and concise use. Processing components and method are configured to gather data and analytics including collecting data resource and database object usage tagging both resources and users with security level by machine learning and building an access model for each role. The method uses graph modeling with created, trained access patterns for users protected resources and produces in-memory implicit sub-groups for users with similar access requirements and limits their resource accesses according to their history behaviors. Further provided are outlier activities prediction and in-real time access authorization modification.
Owner:INTERNATIONAL BUSINESS MACHINE CORPORATION

Object reference with selectable scope

Systems and methods for generating object references with selectable scopes are provided. The systems and methods perform operations including calling, by a first entity, a reference generator function using one or more arguments associated with a database object that the first entity is authorized to access according to a first set of access privileges, the one or more arguments comprising a scope definition that defines persistence of a reference. The operations include obtaining, from the reference generator function, a reference to the database object, the reference persisting according to the scope definition. The operations include passing the reference to a second entity to enable the second entity to perform one or more database operations on the database object according to a second set of access privileges derived from the first set of access privileges.
Owner:SNOWFLAKE INC

Distributed migration method and device for database and medium

The embodiment of the invention discloses a distributed migration method and device for a database and a medium, is applied to the technical field of data migration and is used for solving the problem that existing data migration is low in efficiency and unreliable. The method comprises the steps of collecting a DDL script of a to-be-migrated database object in a source end database, and performing grammar analysis on the DDL script to obtain a compatibility evaluation result of the current to-be-migrated database object; determining a data scale of the to-be-migrated database object based on a compatibility evaluation result, executing a task allocation strategy corresponding to the to-be-migrated database object according to the data scale, and allocating a migration task of the to-be-migrated database object to a task queue of a working cluster; and monitoring the working state when the working node executes the migration task of the task queue, and if the working node is determined to be abnormal based on the working state, determining the uncompleted migration task of the task queue based on the management node, and performing redistribution.
Owner:HIGHGO SOFTWARE

Language model prompt authoring and execution in a database system

A database system may include one or more relational databases storing information for a plurality of tenants in accordance with database object definitions. The database system may also include a communication interface providing the plurality of tenants with access to web applications through which to access the information and configured to receive an indication of one or more of the database object definitions from a tenant. The database system may also include a storage device storing a prompt template specific to the tenant and that includes one or more natural language instructions for generating text and a reference to the one or more database object definitions. The database system may also include a processor configured to retrieve a database record associated with the tenant and corresponding to the one or more database object definitions and to determine a text generation prompt based on the database record and the prompt template.
Owner:SALESFORCE INC

BIM (Building Information Modeling) full information analysis and conversion method based on light database

The invention discloses a BIM (Building Information Modeling) full information analysis and conversion method based on a light database, which comprises the following steps: S1, preparing BIM data, traversing a design model in a source file, and establishing a linear design model structure tree; s2, BIM data analysis: traversing elements in all design models in the linear design model structure tree, and analyzing a full information data structure, including geometry, attribute and material information, of the elements; s3, BIM data conversion is carried out, the element information obtained through analysis is classified and converted into database objects capable of being recognized by a light database, and the database objects adopt a full-information data structure and are written into a user-defined database file. According to the method, full information conversion of BIM data can be achieved, it is guaranteed that element geometry, attribute and material information in the model are not lost, high data conversion and storage efficiency and element-level updating synchronization are achieved, the effects of data seamless circulation and shared application are achieved, and the data delivery and application requirements for various scenes in the infrastructure field are met.
Owner:POWERCHINA HUADONG ENG CORP LTD

Hidden database objects over external data

The subject technology provides techniques for enabling hidden database objects, which in an example are utilized for testing and verifying new database objects against existing workloads. Hidden database objects are a mechanism for bridging that gap by running user workloads on user data in advance of exposing the feature to users. This mechanism allows placing a database object as a hidden object nested beneath a user's visible object (e.g., table, column, view, and the like). Hidden database objects can be used to verify the functionality, parity, performance, and correctness of new unreleased features.
Owner:SNOWFLAKE INC

Efficient in-memory multi-version concurrency control for a trie data structure based database

The invention describes a method for determining a storage location of a database object of a specific version, wherein indexes for each version of the database object are stored in a trie having a root node corresponding to the specific version, the method comprising: determining a trie corresponding to the specific version by accessing the root node of the trie corresponding to the specific version; determining an object identifier of the database object by traversing the trie corresponding to the specific version using a secondary key related to the database object as search key; determining the storage location of the database object by traversing the trie corresponding to the specific version using the determined object identifier as search key.
Owner:CENSHARE GMBH

Heterogeneous database synchronization method and device, electronic equipment and storage medium

The invention relates to a heterogeneous database synchronization method and device, electronic equipment and a storage medium, and the method comprises the steps: analyzing a transaction log of a source database, extracting and generating an abstract syntax tree of a DDL event, and carrying out the node-level syntax conversion of the abstract syntax tree according to the database type of a target database and a preset syntax mapping rule base, and obtaining an equivalent DDL operation sequence of the target database, blocking a data processing operation corresponding to the database object associated with the DDL event, and executing the equivalent DDL operation sequence on the target database. The whole-process intelligent processing of the isomerous database DDL is realized without depending on manpower, the equivalent DDL operation sequence of the target database having semantic consistency with the DDL event of the source database is obtained through dynamic replenishment and deep analysis of the DDL event and the context semantics of the DDL event in combination with the grammar mapping rule base, the processing efficiency of isomerous database DDL synchronization is improved, and the processing efficiency of isomerous database DDL synchronization is improved. And meanwhile, the safety and reliability of synchronous processing can be ensured.
Owner:JINZHUAN INFORMATION TECHNOLOGY CO LTD

User interface framework for web applications

A data platform for managing an application as a first-class database object. The data object can include User Interface (UI) components. The data application can be shared by a provider account to a plurality of consumer accounts using a share object and based on grant commands. The consumer accounts can deploy and operate the UI component based on the share object.
Owner:SNOWFLAKE INC

Secure shared data application access

A data platform for developing and deploying a data application. The data platform receives from a first user the data application and provider granted privileges including a consumer usage privilege and a consumer access to data privilege. The data platform authorizes the second user to access the data platform based on one or more consumer account privileges included in a set of account privileges. The data platform authorizes the second user to execute the data application based on the consumer usage privilege. During execution, the data platform authorizes the data application to access the provider database object based on the consumer access to data privilege, and authorizes the data application to access the consumer database object based on a provider access to data privilege provided by the second user.
Owner:SNOWFLAKE INC

Secure shared data application access

A data platform for developing and deploying a data application. The data platform receives from a first user the data application and provider granted privileges including a consumer usage privilege and a consumer access to data privilege. The data platform authorizes the second user to access the data platform based on one or more consumer account privileges included in a set of account privileges. The data platform authorizes the second user to execute the data application based on the consumer usage privilege. During execution, the data platform authorizes the data application to access the provider database object based on the consumer access to data privilege, and authorizes the data application to access the consumer database object based on a provider access to data privilege provided by the second user.
Owner:SNOWFLAKE INC

Automated Use of User Input to Improve AI Generation of Database Objects with Reduced Computational Cost and Reduced Model Hallucination

Embodiments are provided herein that include receiving, from a natural language model and based on a first textual prompt, a first output that represents a database entry, wherein the database entry includes a plurality of elements; obtaining a selection of a subset of the plurality of elements; determining a second textual prompt based on the selected subset of the plurality of elements; and generating, via the natural language model, a second output based on the second textual prompt, wherein the second output represents an update to the database entry. These embodiments provide for faster generation of catalog items or other types of database entries using generative natural language models in a manner that exhibits reduced memory requirements, computational cost, and / or amounts of training data.
Owner:SERVICENOW INC

Database workload capture and replay using optimized dependency graphs

Techniques and solutions are provided for providing improved replay of a database workload. In particular, the present disclosure provides techniques for generating dependency graphs that have a reduced number of redundant edges. In particular, the dependency graphs can be generated using a technique that removes subpaths of a larger path of requests for database operations that access a common database object. Another technique removes subpaths of a larger path the incudes additional requests in multiple sessions, even if some requests access different database objects. Particular implementations process a set of requests to generate state information, where the state information can be used in generating a dependency graph that excludes one more types of redundant edges. Additional efficiency is provided in that graphs can be generated using a single scan of a given request.
Owner:SAP SE

Comparative evaluation and migration method and system for compatibility of domestic database and medium

The invention provides a domestic database compatibility comparison evaluation and migration method and system and a medium, and belongs to the technical field of database migration. The method comprises the following steps: acquiring a creation statement of each database object in a pre-connected target source database; and based on a preset grammar parser and a preset grammar feature library, analyzing each creation statement, generating an abstract grammar tree and traversing the abstract grammar tree to determine grammar features corresponding to each database object, and generating a mapping list between each database object and each grammar feature. And comparing the mapping list with a plurality of preset grammar feature templates of the domestic databases, generating compatibility evaluation results corresponding to the domestic databases according to comparison results, and determining corresponding migration working hours and an automatic rewriting grammar set according to the compatibility evaluation results. And based on each compatibility evaluation result, each migration man-hour and the automatic rewriting grammar set, generating a multi-dimensional comparison view corresponding to each domestic database, and sending the multi-dimensional comparison view to an evaluation migration user terminal.
Owner:HIGHGO SOFTWARE

Data query method and device based on natural language

The invention discloses a data query method and device based on a natural language. The method comprises the following steps: receiving natural language input of a user; performing semantic analysis on the natural language input, and determining a user intention and a plurality of semantic elements; based on the user intention, target query operators corresponding to the semantic elements respectively are determined in a query operator sequence, and the query operator sequence comprises a plurality of query operators arranged according to the execution sequence; generating a query plan based on the target query operators, the semantic elements corresponding to the target query operators and the execution sequence of the multiple target query operators; a query statement is generated based on the query plan and target database object identifiers corresponding to the semantic elements respectively, and the target database object identifiers comprise at least one of table names and field names; and performing data query based on the query statement. According to the embodiment of the invention, the accuracy and the interpretability of the query statement can be improved, so that the accuracy and the reliability of the query result are improved.
Owner:CHINA UNIONPAY

Recycling station management method, data space flashback method, device, equipment and medium

The invention is suitable for the technical field of shared clusters, and particularly relates to a recycle bin management method, a data space flashback method, a device, equipment and a medium. When deletion operation is carried out on the table space, the database objects belonging to the table space are moved into a database recycle bin, and when deletion marking is carried out on meta-information of data files contained in the table space, the data files are moved into a shared cluster file system recycle bin, and deletion marking is carried out on the meta-information of the table space. And when the table space is flashed back, if the to-be-flashed data file corresponding to the to-be-flashed table space is not cleared, recovering the to-be-flashed data file from the shared cluster file system recycle bin, clearing the deletion mark of the meta information of the to-be-flashed data file, and recovering the to-be-flashed database object corresponding to the to-be-flashed table space from the database recycle bin. And removing the deletion mark of the meta-information of the to-be-flashed-back table space. Through a database recycle bin management mechanism and a shared cluster file system recycle bin management mechanism, the table space recovery efficiency is improved.
Owner:SHENZHEN INST OF COMPUTING SCI

Methods, systems, and computer program products for implementing metadata management

Disclosed is an improved approach to manage hierarchical metadata for a database system. A hierarchical metadata structure pertaining to a hierarchical object structure of a multitenant database architecture for a plurality of tenants may be maintained where the multitenant database architecture comprising a container database (CDB) that includes a pluggable database (PDB). A request for an access to a metadata object in the hierarchical metadata structure for one or more database objects in the container database may be received. In response to the request for the access to the metadata, access to at least a portion of the hierarchical metadata structure is provisioned.
Owner:ORACLE INT CORP

First class database object server application

A data platform for managing an application as a first-class database object. The data platform includes at least one processor and a memory storing instructions that cause the at least one processor to perform operations including detecting a data request from a browser for a data object located on the data platform, executing a stored procedure, the stored procedure containing instructions that cause the at least one processor to perform additional operations including instantiating a User Defined Function (UDF) server, an application engine, and the application within a security context of the data platform based on a security policy determined by an owner of the data object. The data platform then communicates with the browser using the application engine as a proxy server.
Owner:SNOWFLAKE INC

Oracle database compatibility rate portrait generation method, equipment and medium

The embodiment of the invention discloses an Oracle database compatibility rate portrait generation method and device and a medium, belongs to the technical field of databases, and solves the problem of low accuracy and efficiency of manual database compatibility rate detection. Performing data analysis on the metadata to obtain database object information; constructing a syntax tree to obtain reference characteristics; comparing the reference characteristics with a preset database characteristic template, and determining characteristic compatibility corresponding to the reference characteristics; classifying the database object information to obtain different types of database objects; wherein each database object corresponds to a plurality of reference characteristics; the method comprises the steps of determining a characteristic compatibility condition corresponding to each database object based on characteristic compatibility corresponding to a plurality of reference characteristics in the database objects and a preset characteristic compatibility priority, and constructing an Oracle database compatibility rate portrait according to database object information and the characteristic compatibility condition to determine the compatibility rate of a target Oracle database.
Owner:HIGHGO SOFTWARE

External control for structured query language (SQL) statement execution

A method for execution by a database system to improve testing, the method includes creating a synchronization database object (SDO) indicating a set of conditions for suspension of execution of queries. The method further includes establishing a first and second session, where the first session applies the SDO to a query expression and the second session monitors the SDO. The method further includes initiating, via the first session, execution of queries, and suspending the execution of queries when detecting a condition is met. The method further includes updating, via the first session, at least one relational database table to include monitoring data indicating suspension of the queries. The method further includes the second session verifying the suspension and instructing the SDO to resume suspended queries. The method further includes resuming, via the first session, the queries until a next condition is met or execution of the queries is finished.
Owner:OCIENT HOLDINGS LLC

FastAPI-based JSON data processing system implementation method

The application discloses a JSON data processing system implementation method based on FastAPI, which comprises the following steps: establishing a working directory based on FastAPI, creating a request processor in the working directory, and receiving original JSON data through the request processor; constructing a database object model in the working directory, generating a database table, and storing the original JSON data into the database table; constructing a business verification model in the working directory, preprocessing the original JSON data through the business verification model, and converting the processed JSON data into a Python object; creating a business processing tool in the working directory, processing the business logic of the Python object through the business processing tool, converting the processed Python object into a JSON data format; and creating a request agent and a middleware client agent of an external system in the working directory, and interacting the converted JSON data with the external system and the middleware. The application realizes an asynchronous processing kernel, supports high-concurrency tasks, improves the execution efficiency, and reduces the response time.
Owner:COWAVE SATELLITE COMM TECH CO LTD

Database object manager and management method

The invention discloses a database object manager and a management method, the manager realizes operation on a database object through interface design, and the manager comprises a database object creating module for creating and modifying the database object, the database object comprises one or more of a library, a mode, a table, an index, a partition, a constraint, a view, a sequence value, a storage process, a function, a packet, a user and a role; the database object management module is used for checking and modifying a database object, operating data, editing SQL (Structured Query Language), checking a table structure, and importing and exporting the table structure and table data; and the database object maintenance module is used for realizing table statistical analysis, index reconstruction, view compilation and modification, trigger compilation and modification, storage process and function compilation of database objects. Through the interface operation, the user can better use the database.
Owner:成都虚谷伟业科技有限公司

A blocking method, device, apparatus and storage medium

The application discloses a kind of blocking method, device, equipment and storage medium.The method comprises: when receiving the blocking instruction for target database object, active node obtains the first lock mode carried by the blocking instruction and the identification information of the target database object;The active node obtains first lock mode set according to the identification information of the target database object inquiring target mapping table;The active node generates second lock mode set according to the compatible lock mode of each lock mode in the first lock mode set;If the second lock mode set includes the first lock mode, the active node executes the blocking instruction for target database object, by the technical scheme of the application, it can be guaranteed that the total database object of transaction access is always complete during fault handling process, and there is no blocking conflict with active transaction of fault node after data recovery is completed, to ensure that fault node transaction and blocking can be successfully reconstructed.
Owner:SHANGHAI DAMENG DATABASE

Systems and methods for generalized structured data discovery utilizing contextual metadata disambiguation via machine learning techniques

Systems and methods for generalized structured data discovery utilizing contextual metadata disambiguation via machine learning are disclosed. A method may include receiving physical application metadata for an attribute, a database object, or a database; receiving reference data including tokens and their associated abbreviations and acronyms; parsing the physical application metadata into application tokens including known application tokens and unknown application tokens; identifying unknown application tokens by comparing the parsed application tokens to a corpus; performing probabilistic parsing on the unknown application tokens using the reference data resulting in token phrases; identifying monosemous tokens in the token phrases using a look-up dictionary; replacing the monosemous tokens with their expansions from the look-up dictionary; and outputting a mapping of the physical application metadata to enhanced physical application metadata that includes an expression for the physical application metadata comprising the expansions for monosemous tokens in a supported language.
Owner:JPMORGAN CHASE BANK NA

Schema evolution on a live database system without an outage

Aspects of the invention include techniques for providing a schema evolution on a live database system without an outage. A non-limiting example method includes initiating a schema change on a live database system. The schema change includes an attribute for a database object. A first application package having a user application that is dependent on the database object and that is bound with a release(deallocate) option is identified. Existing threads and new threads executing the first application package are routed to execute the first application package with a release(commit) option and the schema change on the live database system is completed. One or more additional threads concurrently executing one or more additional application packages remain executing with the release(deallocate) option.
Owner:INTERNATIONAL BUSINESS MACHINE CORPORATION

Unified persistence overall feature

A database system detects an operation to move a first database object from an in-memory store to a persistence store, wherein the first database object is in either a page-loadable or column-loadable format in the in-memory store, and wherein the first database object comprises a plurality of subcomponents. Each subcomponent of the first database object is examined separately from other subcomponents of the plurality of subcomponents. In response to determining that a first subcomponent of the plurality of subcomponents has a datatype and a compression type supported by a unified persistence format, the first subcomponent is stored in a unified persistence format in the persistence store. In response to determining that a second subcomponent of the plurality of subcomponents has either a datatype or a compression type which is not supported by the unified persistence format, the second subcomponent is stored in a serial persistence format in the persistence store.
Owner:SAP SE

Native copy mechanism for in-memory and paged primitive data structures

A database system detects a query targeting a first database object stored in a unified persistence format in a persistence store. In response to detecting the query, the database system determines whether to load the first database object in column-loadable format or page-loadable format into an in-memory store. In response to determining to load the first database object in the column-loadable format, the database system determines if a first bit representation of one or more corresponding primitives in the persistence store is compatible with a second bit representation used for storing the primitives in the in-memory store. The database system performs a native copy operation to copy the primitives from the persistence store to the in-memory store if the bit representations are compatible, where the native copy operation involves copying the primitives on a page-by-page basis without decoding and encoding values of the one or more primitives.
Owner:SAP SE

DDL statement execution method and apparatus

The embodiment of the present specification provides a DDL statement execution method and device, and relates to the technical field of databases.The method comprises the following steps: in response to an execution request for a data definition language (DDL) statement, starting a transaction, the transaction being used for executing the DDL statement; recording target lock information corresponding to the DDL statement in the transaction, the target lock information being used for indicating parameters of locks added on a database object in the execution process of the DDL statement; in response to successful submission of the transaction, deleting the target lock information, so as to complete the execution of the DDL statement.The scheme provided by the present specification connects the lock operation in the execution process of the DDL statement into the transaction, provides a perfect lock management mechanism, makes the execution condition of the DDL statement consistent with the control of the lock, and thus can coordinate the concurrent processing of multiple DDL statements.
Owner:BEIJING OCEANBASE TECHNOLOGY CO LTD