scispace - formally typeset
Patent

Calibration of logical cost formulae for queries in a heterogeneous DBMS using synthetic database

Reads0
Chats0
TLDR
In this paper, a programmable machine system and a method for managing electronic data access among multiple different relational databases in a network distributed database environment is presented, where the machine is programmed so that it can construct cost-effective access strategies for any of the participating databases absent any DBMS-specific cost models.
Abstract
A programmable machine system and method for managing electronic data access among multiple different relational databases in a network distributed database environment. The machine is programmed so that it can construct cost-effective access strategies for any of the participating databases absent any DBMS-specific cost models. The system provides query optimization across different database management systems in a network distributed database environment based on a calibrating database relying only on typical relational database statistics and cost data is developed by running queries in the various databases against the calibrating database. A logical cost model is constructed using the resulting cost data and is used to estimate the cost of a given query based on logical characteristics of the DBMS, the relations, and the query itself. The cost of a complex query is estimated using primitive queries. Optimal query access strategies are thereby designed and used to control execution of the queries across relational databases controlled by two or more different database management systems.

read more

Citations
More filters
Patent

Intelligent Automated Assistant

TL;DR: In this article, an intelligent automated assistant system engages with the user in an integrated, conversational manner using natural language dialog, and invokes external services when appropriate to obtain information or perform various actions.
Patent

Using context information to facilitate processing of commands in a virtual assistant

TL;DR: In this article, a virtual assistant uses context information to supplement natural language or gestural input from a user, which helps to clarify the user's intent and reduce the number of candidate interpretations of user's input, and reduces the need for the user to provide excessive clarification input.
Patent

Method and apparatus for building an intelligent automated assistant

TL;DR: In this paper, a method for building an automated assistant includes interfacing a service-oriented architecture that includes a plurality of remote services to an active ontology, where the active ontologies includes at least one active processing element that models a domain.
Patent

Contextual voice commands

TL;DR: In this paper, techniques and systems for implementing contextual voice commands are described and a physical input that relates the selected data item to an operation in a second context is received, and the operation is performed on the input data item in the second context.
Patent

Electronic Devices with Voice Command and Contextual Data Processing Capabilities

TL;DR: In this paper, an electronic device may capture a voice command from a user and store contextual information about the state of the electronic device when the voice command is received, such as a desktop computer or a remote server.
References
More filters
Patent

Automated query optimization method using both global and parallel local optimizations for materialization access planning for distributed databases

TL;DR: In this paper, three access planning methods are used: General (Response), General (Total) and Initial Feasible Solution (IFS) for a distributed query, General(Response) and General(Total) decrease the communication cost and increase the local processing costs as compared to the IFS.
Patent

System for optimizing query processing in a relational database

TL;DR: In this article, a method for processing a database for analyzing a query to the database from a user to determine an internal processing procedure therefor and executing it comprises the steps of preparing single or a plurality of internal processing procedures based on analysis result of the query including a variable inputted in a preprocess step and statistical information of a database system.
Patent

Data base optimizer using most frequency values statistics

TL;DR: In this article, a method for more accurately estimating the time required to process a data base query using a selected index is presented. But this method assumes that the query's search criteria specify values other than the stored most frequently occurring values, those values are assumed to be uniformly distributed.
Patent

Access path optimization using degrees of clustering

TL;DR: In this paper, the authors measure the degree of clustering of an index for a relational data base table, and estimate the number of physical page accesses required to access the table using a partial index scan using the index, and select the index providing the fastest access path to the table.
Patent

User friendly data base access

TL;DR: In this article, a user not having data processing skills or experience is enabled by means of a utility to access data in bulk storage device via the PCBs via the DBDs and source statements.