Patents
Literature
Hiro is an intelligent assistant for R&D personnel, combined with Patent DNA, to facilitate innovative research.
Hiro

34 results about "Database catalog" patented technology

The database catalog of a database instance consists of metadata in which definitions of database objects such as base tables, views (virtual tables), synonyms, value ranges, indexes, users, and user groups are stored.

System and method for recursive path analysis of dbms procedures

A system, method and database development tool are disclosed for automatically generating the complete dependency graph for use in debugging stored code objects in a database, by using a recursive dependency tracking algorithm which takes into consideration the indirect dependencies on triggers as well as the dependencies on implementations of object oriented code objects which are represented as separate objects in the database catalog.
Owner:COMP ASSOC THINK INC

Click to accept as built modeling

A method, system, apparatus, and computer program product provide the ability to augment an as-built model. A CAD drawing of a project as well as a digital representation of a physical implementation of the project are obtained. A relationship that maps the digital representation to the CAD drawing is defined / established. A component of the digital representation is identified based on the relationship (e.g., and a database / catalog). Information about the identified component is transmitted to and displayed on a computer (e.g., a mobile device).
Owner:AUTODESK INC

Optimized database appliance

A system from processing database queries allows for cost and locale based distribution for execution of database queries. The database queries are executed on execution engines that provide flexible configuration and overlapping functionality. The system reduces various costs, including elapsed time, required to perform database queries. The system provides processing of a database query using a database catalog comprising database table locality information, record locality information and execution engine information. A query optimizer receives the query and accesses the database catalog to create a query execution plan comprising locality-based database operations. A central database operation processor providing a first execution engine executes the query execution plan by performing at least a portion of the locality-based database operations and distributing at least a portion of the locality-based database operations as a subplan. A second database operation processor providing a second execution engine executes the subplan received from the central database operation processor. At least one of the database operations can be executed on either the first execution engine or the second execution engine. A storage unit stores at least a portion of database tables and records. A data communications network connects the central database processor to the second database processor.
Owner:IBM CORP

System and method for management, creation, storage, search and delivery of rich media optimized for e-commerce in a distributed information network

Techniques are provided for managing the creation, storage, search and delivery of rich media optimized for e-commerce in a distributed information network, e.g., the Internet. In an illustrative embodiment, a content creation phase generates rich media content in a single multimedia file in the format of a HotMedia file for delivery to a Rich Media Build Engine (RMBE). Rich media content is extracted from the file using pluggable and modular extractors providing an input to a commerce-based search engine and a full-text search engine. The outputs of the search engine are combined as a search result from which a searchable database directory is created. The output is stored in a conventional database, e.g., DB2. A web client is coupled to the search system through a web server providing a search query to the rich media database and receiving an output from the search engine.
Owner:IBM CORP +1

System for obtaining forwarding information for electronic system using speech recognition

A unified message platform system integrates voice recognition and dialing capabilities with directory systems, including automated telephone directory systems and private database directory systems, to enable a user to access stored directory information related to an intended recipient of a message. The unified message platform system prompts the user to speak the name of the party intended as the recipient of a message, and the type of address information to be accessed, for example fax number, e-mail address, home address, etc. The unified message platform system analyzes the input speech information, determines the appropriate database to be accessed, and accesses either local directory databases, or remote directory databases via a local area or wide area packet switched network. For remote directory databases such as private corporate directory databases, the unified message platform system also interacts with the remote directory databases to ensure compliance with any security protocols of the remote directory databases. The unified message platform, upon obtaining the requested information, either announces the information in an audible format, or uses the requested information, for example to place a call to the station corresponding to the requested information.
Owner:GOOGLE LLC

Optimized database appliance

A system from processing database queries allows for cost and locale based distribution for execution of database queries. The database queries are executed on execution engines that provide flexible configuration and overlapping functionality. The system reduces various costs, including elapsed time, required to perform database queries. The system provides processing of a database query using a database catalog comprising database table locality information, record locality information and execution engine information. A query optimizer receives the query and accesses the database catalog to create a query execution plan comprising locality-based database operations. A central database operation processor providing a first execution engine executes the query execution plan by performing at least a portion of the locality-based database operations and distributing at least a portion of the locality-based database operations as a subplan. A second database operation processor providing a second execution engine executes the subplan received from the central database operation processor. At least one of the database operations can be executed on either the first execution engine or the second execution engine. A storage unit stores at least a portion of database tables and records. A data communications network connects the central database processor to the second database processor.
Owner:IBM CORP

Stored procedure universal calling interface

A method, apparatus and article of manufacture for a universal calling interface for executing a stored procedure in a computer. Parameter information is retrieved from a database catalog and the computer performs type checking against the user-entered parameters. If there is not a type mismatch then the computer executes the stored procedure without the user entering information about the parameters such as address and type.
Owner:IBM CORP

Self-adaptive incremental deep web data source discovery method

The invention discloses a self-adaptive incremental deep web data source discovery method. According to the method, the deep web data source discovery processes comprise a website positioning stage and an in-web searching stage, and in the website positioning stage, a website discovery mechanism is introduced so that website data can be efficiently expanded and the creep effect can be improved; a self-adaptive sorting mechanism is adopted in website and in-web linkage so that a deep web website and a queryable form can be discovered more rapidly. The method achieves automatic incremental efficient deep web data source acquisition, can be applied to deep web data integration and a hidden web crawler, and meanwhile is also suitable for building on-line database catalog websites.
Owner:HUAZHONG UNIV OF SCI & TECH

Method and System for Executing a Database Query

For a database management system installed in a data processing system, the database management system for managing a database having partitions for storing table data based on a partitioning schema, in which each partition has an associated partition identifier, and in which the database has database catalog information associated therewith, a method for executing a query against the database is disclosed. The method includes identifying a partition identifier in accordance with the partitioning schema, selecting the partition identifier based on the contents of the query and the database catalog information, and executing the query against the identified partition. The method improves the execution of queries while minimizing the consumption of network resources.
Owner:SAP AG

Avoiding creation of database statistics

The invention relates to a method for providing access paths to data within a database, in particular using REBIND for DB2, wherein real time database statistics are determined using a database integrated monitor, wherein the database statistics are output substantially in real time using said database integrated status monitor, and wherein said database statistics from said integrated monitor are used to initiate generation of data set statistics, and to determine said access paths. To allow efficient generation of access paths, the following steps are proposed: determining from said database statistics a total number of rows of at least one data set of said database, comparing said determined total number of rows with a first threshold value, deciding solely based on said total number of rows to provide a database catalogue with said data set statistics in case said total number of rows reaches said threshold value, and determining said access paths to said data based on said data set statistics within said database catalogue.
Owner:SOFTWARE ENG

Method and device for establishing directory structure of database

The invention discloses a method and device for establishing a directory structure of a database. The method comprises the following steps of: after a command of uploading a target folder is received, traversing the target folder to determine all the file data in the target folder, wherein the file data indicates file directories or files in the target folder; establishing a related directory structure according to the file data, wherein the directory structure is used for marking storage positions of the file data; and uploading the directory structure and the files in the target folder. According to the method, the target folder can be expressed through the directory structure and all the files in the target folder, and the aim of storing the target folder can be realized, so that the storage space of the database is saved.
Owner:WUXI TVMINING MEDIA SCI & TECH

Searching and matching a set of query strings used for accessing information in a database directory

Searching and matching a set of query strings used for accessing information in a database directory. In this disclosure, a user community administration tool queries a database directory containing user information associated with a user community. In the user community administration tool, there is an input query generation component that generates an input query having a search pattern that includes a combination of attribute names, logical, operators and attribute values. An accessing component accesses a library of queries used for accessing the user information in the database directory. A partitioning component partitions each of the queries in the library into logical units. Each logical unit comprises a combination of an attribute name, logical operator and attribute value. A comparing component compares the search pattern of the input query to each partitioned logical unit for each of the queries in the library. The comparing component compares the attribute name of the input query to the attribute name in the logical unit, the operator used in the input query to the operator used in the logical unit and the attribute value in the input query to the attribute value in the logical unit. A determining component determines whether there is a match between the input query and any of the logical units associated with each of the queries in the library.
Owner:GENERAL ELECTRIC CO

Characterization of biological material in a sample or isolate using unassembled sequence information, probabilistic methods and trait-specific database catalogs

The present invention relates to systems and methods for the characterization of biological material within a sample or isolate. The characterization may utilize probabilistic methods that compare sequencing information from fragment reads to sequencing information of reference genomic databases and / or trait-specific database catalogs. The characterization may be of the identities and / or relative concentrations or abundance of one or more organisms contained in the sample or isolate. The identification of the organisms may be to the species and / or sub-species and / or strain level with their relative concentrations or abundance. The characterization may additionally or alternatively be of one or more traits (i.e., characteristics) of the biological material contained in the sample or isolate. The characterization of the one or more traits may be with the relative abundance of the traits.
Owner:COSMOSID INC

Dynamic string length checking for off-line processing using client-side caching of database catalog

A system and method for preventing user-input text strings of illegal lengths from being submitted to a remote database from a database client, where, for each character in the string, a character length is determined in quantities of digital units of storage according to an encoding schema, the character lengths are accumulated into a total string length, also measured in digital units of storage, and the total string length is compared to one or more database input field requirements such as non-null and maximum length specifications. If a limit is not met, the system and method are suitably disposed in a manner to block or prevent submission of the user-input string to the database. The invention is especially useful in preventing sensitive information, such as alternate passwords, from being inadvertently transmitted to the wrong database server, as well as being useful in pre-processing data in an off-line configuration.
Owner:CHEN YEN FU +4

Placing objects on hosts using hard and soft constraints

Objects are placed on hosts using hard constraints and soft constraints. The objects to be placed on the host may be many different types of objects. For example, the objects to place may include tenants in a database, virtual machines on a physical machine, databases on a virtual machine, tenants in directory forests, tenants in farms, and the like. When determining a host for an object, a pool of hosts is filtered through a series of hard constraints. The remaining pool of hosts is further filtered through soft constraints to help in selection of a host. A host is then chosen from the remaining hosts.
Owner:MICROSOFT TECH LICENSING LLC

Prioritization of search requests using search templates

A method, a computer system, and a computer program product that prioritizes search requests to a database directory by assigning the search requests to one or more templates. Attributes of the search requests, such as an IP address, the portion of the database to which the search is constrained, one or more return attributes, the scope of the search, and / or search filters used, are compared with values of those attributes of the templates. The template whose values of the attributes match the values of the attributes in the search request is selected. This template has a template identifier that is associated with a transaction name of a work unit enclave. The search request is then associated with the work unit enclave and the operating system of the computer system will execute the search request in accordance with the performance goals and priority of the service class into which the work unit enclave is assigned. Process steps include creating a search template if none exist, and configuring a database server to assign a transaction name to search requests based on attributes and their values of the search request and then associating that transaction name with a transaction name of the work unit enclave.
Owner:DAEDALUS BLUE LLC

System and Method for an Efficient Database Storage Model Based on Sparse Files

Embodiments are provided herein for an efficient database storage model, which utilizes sparse file features to efficiently store and retrieve data. The embodiments provide database algorithms that utilize the file system abstraction layer to hide the complexity of managing disk space while providing the database a linear and contiguous logical address space for holding multiple database objects. An embodiment method includes pre-allocating, in a logical sparse file, a plurality of segments fixed in size and contiguous at fixed offsets. Upon receiving a command to write database objects to the segments, the database objects are mapped to the segments in a database catalog. The method further includes interfacing with a file system to initialize storage medium space for writing the data objects to the segments at the fixed offsets.
Owner:FUTUREWEI TECH INC

Computer document retrieval method

The invention discloses a computer document retrieval method, and relates to distributed document storage equipment. In each piece of the distributed document storage equipment, the computer document retrieval method comprises the following steps: establishing a source document attribute database, establishing sub-database catalog tables of a first level, a second level, ...and an Nth level, retrieving documents, inputting retrieval key words into retrieval equipment, opening the retrieval catalog tables level by level, checking the source document attribute database, and feeding back the retrieval result to the retrieval equipment. The computer document retrieval method is applied to retrieval on a great number of documents in the distributed document storage equipment, documents can be flexibly checked according to different retrieval key words, the computer document retrieval method has the characteristics of rapid checking speed, high retrieval efficiency and flexible application, and the requirements of checking and positioning documents of different levels and types in the distributed document storage equipment, of a user, can be met.
Owner:张梅云

System and method for an efficient database storage model based on sparse files

Embodiments are provided herein for an efficient database storage model, which utilizes sparse file features to efficiently store and retrieve data. The embodiments provide database algorithms that utilize the file system abstraction layer to hide the complexity of managing disk space while providing the database a linear and contiguous logical address space for holding multiple database objects. An embodiment method includes pre-allocating, in a logical sparse file, a plurality of segments fixed in size and contiguous at fixed offsets. Upon receiving a command to write database objects to the segments, the database objects are mapped to the segments in a database catalog. The method further includes interfacing with a file system to initialize storage medium space for writing the data objects to the segments at the fixed offsets.
Owner:HUAWEI TECH CO LTD

Apparatus and method for utilizing different data storage types to store primary and replicated database directories

An apparatus and method are provided for utilizing different data storage types to store primary and replicated database directories. Included is a first data storage of a first data storage type including a direct-access storage type. The first data storage is configured to store a primary database directory. Also included is a second data storage of a second data storage type including a share type. The second data storage is configured to store a replicated database directory that replicates at least a portion of the primary database directory.
Owner:HUAWEI TECH CO LTD

Meteorological data visualization discovery system and method, computer and computer program

The invention belongs to the technical field of meteorological data, and discloses a meteorological data visualization discovery system and method, a computer and a computer program. The method comprises: a data related database is selected on an interactive tool and a graphical interface according to the purposes of query and retrieval; Database directory structure analysis and record feature analysis are carried out, and related information can be calculated, displayed and counted; Setting availability parameters, and judging the satisfaction condition of availability conditions; On a visualization tool and a graphical interface, analyzing the quality, the time sequence and the spatial uniformity of the data by the user; Determining whether the data is available by analyzing the result;Transmission and download. Compared with a traditional data discovery method and a discovery method based on meteorological data availability analysis, a data availability analysis link and a data discovery result analysis link are added, downloading of invalid data is effectively reduced, and an effective data discovery method is provided for business researchers.
Owner:CHENGDU UNIV OF INFORMATION TECH +1

Method for monitoring database directory, storage medium and server

The invention relates to the technical field of communication, and provides a method for monitoring a database directory, a storage medium and a server. The method for monitoring the database directory comprises the following steps: accessing data dictionary information of a target database; determining a database directory to be monitored according to the accessed data dictionary information; obtaining directory information of the database directory by using a preset script file; constructing a monitoring item of a database directory according to the directory information; sending the monitoring item to a zabbix server so that the zabbix server monitors the database directory. By accessing the data dictionary information of the database, The invention can determine the directory information of the directory of the database to be monitored, and then can automatically construct the monitoring item according to the directory information, and send the constructed monitoring item to the zabbix server for monitoring. Compared with traditional conventional method of manually defining the monitoring item, the method effectively improves the operation efficiency.
Owner:PING AN TECH (SHENZHEN) CO LTD

Avoiding creation of database statistics

The invention relates to a method for providing access paths to data within a database, in particular using REBIND for DB2, wherein real time database statistics are determined using a database integrated monitor, wherein the database statistics are output substantially in real time using the database integrated status monitor, and wherein the database statistics from the integrated monitor are used to initiate generation of data set statistics, and to determine the access paths. To allow efficient generation of access paths, the following steps are proposed: determining from the database statistics a total number of rows of at least one data set of the database, comparing the determined total number of rows with a first threshold value, deciding solely based on the total number of rows to provide a database catalogue with the data set statistics in case the total number of rows reaches the threshold value, and determining the access paths to the data based on the data set statistics within the database catalogue.
Owner:SOFTWARE ENG

Method, device and system for building main database and standby database

A method, device and system for building a main database and a standby database can be used in the financial field or other fields. The method comprises: obtaining a main database server IP (Internet Protocol) and a standby database server IP, and determining main database instance information, a directory list and the file size and the file number of an online redo log; according to the file size and the file number, creating a standby database redo log in the main database; generating a connection character string, and adding the connection character string into a descriptor configuration file of the main database server; acquiring a password file, a parameter file and a descriptor configuration file from the main database, and synchronizing the password file, the parameter file and the descriptor configuration file to a standby database according to a standby database server IP; and according to the main database directory list, creating a standby database directory list in the standby database, and storing each file in the standby database directory list, so that the standby database obtains a standby database redo log from the main database and copies data. The professional threshold of the main and standby database construction is reduced, and the daily operation and maintenance accuracy, efficiency and quality are improved.
Owner:INDUSTRIAL AND COMMERCIAL BANK OF CHINA

Database deployment method and device

The invention provides a database deployment method and device. The method comprises the following steps: deploying and operating a database management system instance in a first physical storage space of a server; determining at least one to-be-borne service system in the server; for each service system, creating a database of the service system based on the database management system instance, and creating a database directory of the database in the first physical storage space; for the database of each business system, creating a logical volume for the database of the business system, performing file system formatting on the logical volume corresponding to the database of the business system, and mounting the formatted logical volume to a database directory corresponding to the database of the business system, wherein the logical volume and a second physical storage space of the server have a mapping relationship. According to the scheme, while databases of multiple service systems can be deployed on a single server, the memory resource consumption in the server is reduced, and the resource utilization rate of the server is improved.
Owner:CHINA CONSTRUCTION BANK
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products