U.S. patents available from 1976 to present.
U.S. patent applications available from 2005 to present.

Icon_funbox Quotables

"Transmission of documents via telephone wires is possible in principle, but the apparatus required is so expensive that it will never become a practical proposition."

Dennis Gabor, British physicist

Newsletter  PatentStorm News

Make the Most of Our Site

See this month's Top Inventors and Most Cited Patents.

Stay on top of the latest innovations by subscribing to an RSS feed.

Registered users: Manage your profile.

 

Class 707/2 - Access augmentation or optimizing


Subclass of Class 707 - Data processing: database and file management or data structures
Definition: Subject matter directed to methods of access, including
No. of applications: 1376
Last issue date: 03/04/2010


1                      
Application No.Application TitleIssue Date
20100057670APPARATUS AND SYSTEM FOR REDUCING LOCKING IN MATERIALIZED QUERY TABLES
Disclosed is an apparatus and system for reducing locking in materialized query tables (MQT) for distributive functions. The apparatus includes an insert module that inserts into an MQT table a child record when a new record is inserted into a base table associated with...
03/04/2010
20100057673REUSABLE MAPPING RULES FOR DATA TO DATA TRANSFORMATION
What is described is a method and a system for data transformation by using predefined mapping rules. A transformation between a source data object and a target data object is defined and an initial mapping of elements from the source data object to the target data obje...
03/04/2010
20100057577System And Method For Providing Topic-Guided Broadening Of Advertising Targets In Social Indexing
A computer-implemented system and method for providing topic-guided broadening of advertising targets in social indexing is provided. Articles of digital information and one or more social indexes are maintained. Each social index includes topics that each relate to one...
03/04/2010
20100057672SYSTEM, METHOD, AND COMPUTER-READABLE MEDIUM FOR DUPLICATION OPTIMIZATION FOR PARALLEL JOIN OPERATIONS ON SIMILARLY LARGE SKEWED TABLES
A system, method, and computer-readable medium for optimizing join operations in a parallel processing system are provided. A respective set of rows of a first table and a second table involved in a join operation are distributed to each of a plurality of processing mod...
03/04/2010
20100057671URI FILE SYSTEM
An apparatus and a method for accessing data from a server. In one embodiment, data referred by a Universal Resource Identifier (URI) is mounted on a file system. The mounted data can then be operated on using the file system. To mount the data referred by the URI, a Un...
03/04/2010
20100049694METHOD AND SYSTEM FOR EXTENDING A RELATIONAL SCHEMA
According to one embodiment, a method of accessing data stored in a data store by using a query is provided and includes receiving a first query in a standardized-language at an relational database interface, the first query identifying a first data type. A provider reg...
02/25/2010
20100049693SYSTEM AND METHOD OF CACHE BASED XML PUBLISH/SUBSCRIBE
A publish/subscribe content-based distribution of messages, receives a message, codes the message to generate a message identifier, content filters the message to identify matches to subscription queries, retrievably caches the matches based on the message identifier, r...
02/25/2010
20100049692Apparatus and Method For Retrieving Information From An Application Functionality Table
A computer readable storage medium includes executable instructions to derive a table representing operations associated with an application. One or more parameters are received. A query is executed against the table if the parameters are resolvable with respect to one ...
02/25/2010
20100042581JOIN PATHS ACROSS MULTIPLE DATABASES
Methods, systems and computer instructions on computer readable media are disclosed for optimizing a query, including a first join path, a second join path, and an optimizer, to efficiently provide high quality information from large, multiple databases. The methods and...
02/18/2010
20100033746Document management device and document management method with identification, classification, search, and save functions
The present invention provides a document management device including a file receiving device for receiving a document; an optical identification device for performing optical identification on a non-textural content in the received document; a feature mark identifier f...
02/11/2010
20100036799QUERY PROCESSING USING HORIZONTAL PARTIAL COVERING JOIN INDEX
A computer implemented system and method includes obtaining a query referring to rows in a relational database. A sparse index of the database that has a set of rows that is a subset of the rows referred to in the query is obtained. Rows referred to in the query that ar...
02/11/2010
20100036801STRUCTURED QUERY LANGUAGE FUNCTION IN-LINING
Methods and apparatus, including computer program products, related to query language function in-lining. In general, data characterizing a query in accordance with structured query language format is received. A determination is made as to whether the query includes qu...
02/11/2010
20100036802Repetitive fusion search method for search system
Provided in the present invention is a repetitive fusion search method for a search system, in which: a search interface 20 displays parameter numerical value setting fields 25 for setting a numerical value for each of multiple instinct based feature param...
02/11/2010
20100036800AGGREGATE JOIN INDEX UTILIZATION IN QUERY PROCESSING
A system and method include obtaining a query and identifying an aggregate join index (AJI) at a high level of aggregation. The dimension table may be rolled-up with the grouping key being the union of the grouping key in the AJI and the grouping key of the query. The i...
02/11/2010
20100036803ADAPTIVE FILTER INDEX FOR DETERMINING QUERIES AFFECTED BY A DML OPERATION
Techniques are disclosed for creating and using a filter index in order to identify registered queries whose result sets are likely to have been changed by changes made to tables. The filter index entries are based on filter conditions. The filter conditions are created...
02/11/2010
20100027852System and Method for Fast Biometric Pattern Matching
A method and system for matching two biometric images including receiving an input biometric image; generating an index table for the input biometric image, wherein the index table includes a quality quantity for each minutia of the input biometric image; receiving a se...
02/04/2010
20100030726Mechanism For Deferred Rewrite Of Multiple Xpath Evaluations Over Binary XML
A mechanism is provided for improving the performance of particular database queries operating on a view comprising binary-encoded XML. The key to improving performance is to determine whether a XML index is available to improve the computation of XPath data before deri...
02/04/2010
20100030733Transforming SQL Queries with Table Subqueries
A computer automated technique for rewriting SQL with table subqueries into more optimal table expression equivalents without derived tables. The context of the table subqueries, including any join and filter predicates are moved to the encompassing outer query. The adv...
02/04/2010
20100030727Technique For Using Occurrence Constraints To Optimize XML Index Access
Approaches are provided for improving the performance of certain database queries that operate on binary-encoded XML. In particular, the approach uses occurrence and type constraint information about XML data stored in the database for optimizing the relational rewrite ...
02/04/2010
20100030731COST-BASED QUERY REWRITE USING MATERIALIZED VIEWS
A system and method of rewriting a database query where the query contains an aggregate includes the following. If one or more aggregate materialized views are considered, rewriting the query using an aggregate materialized view. If one or more non-aggregate multi-table...
02/04/2010
20100030732SYSTEM AND METHOD TO CREATE PROCESS REFERENCE MAPS FROM LINKS DESCRIBED IN A BUSINESS PROCESS MODEL
A method of constructing a process reference map. The method includes iterating over each of a plurality of process models. An intermediary reference graph is created. A directed link for each reference in the process models is added to the intermediary reference graph,...
02/04/2010
20100030728COMPUTING SELECTIVITIES FOR GROUP OF COLUMNS AND EXPRESSIONS
Techniques are described herein for estimating selectivities of query predicates that reference more than one column and predicates that include column expressions. Virtual columns are defined based on column groups and column expressions. Statistics are gathered on the...
02/04/2010
20100030730System, Method, and Computer Program Product for Determining SQL Replication Process
A system, method, and computer program product are provided for replicating a table in a source database to a target database. In accordance with an embodiment of the present invention, a subscription to the table is defined and a query is executed on the source databas...
02/04/2010
20100030729METHOD AND SYSTEM FOR MITIGATING IMPACT OF USER ERRORS IN DATA STORES
The invention provides a method and system for managing data access. The method includes receiving a request for accessing a file, determining a type of the received request that corresponds to an access pattern based on history of many files, marking the request based ...
02/04/2010
20100023481Computer-implemented method for deriving, translating, and using definitional expressions for data in a database
A computer-implemented method is disclosed for deriving definitional expressions for data in a database from membership abstractions, and for deriving membership abstractions from definitional expressions. Definitional expressions may be partially in a natural language....
01/28/2010
20100023480INDEXING METHOD OF DATABASE MANAGEMENT SYSTEM
A database management system has a plurality of database servers and data can be transferred between them by partitioning a data area into small areas and altering allocation of the small areas to the database servers. After altering the configuration, there occurs degr...
01/28/2010
20100023477OPTIMIZED BULK COMPUTATIONS IN DATA WAREHOUSE ENVIRONMENTS
A method including extracting data spanning a computational interval from a plurality of database tables in an optimized manner, creating an array of each column of data that is extracted, accessing each array via a standardized programmatic interface to manipulate the ...
01/28/2010
20100023478Utilizing Path IDs For Name And Namespace Searches
In a database system, names and namespace of XML nodes are computed from path ids. The path ids are constructed from tokens, each of which represents a particular name or namespace-name pair....
01/28/2010
20100023479HEXADECIMAL FILE FAST DECOMPRESSION METHOD
A computer implemented method of selectively accesses a set of subdivisions of a compressed file, wherein the compressed file is a hex dump file. A request to access a first data byte string is received. The first data byte string has a first address from within the com...
01/28/2010
20100017364SYSTEMS, METHODS, AND SOFTWARE FOR DISTRIBUTED LOADING OF DATABASES
The present inventors have devised one or more systems, methods, and software for distributed loading of information retrieval systems. One exemplary system includes two or more (at least two) load monitor servers that not only monitor and ensure completion of load task...
01/21/2010
20100017262PREDICTING SELECTION RATES OF A DOCUMENT USING CLICK-BASED TRANSLATION DICTIONARIES
The subject matter disclosed herein relates to predicting selection rates of web-based documents in response to a search query....
01/21/2010
20100017362SIMPLIFYING ACCESS TO DOCUMENTS ACCESSED RECENTLY IN A REMOTE SYSTEM
Simplifying access to documents accessed recently on a remote system. In one embodiment, the list of documents accessed by a user using a first instance of an application in a first/remote system is maintained. The list of documents is provided/displayed to the same use...
01/21/2010
20100017363EFFICIENT EVALUATION OF SQL PIVOT OPERATIONS
Techniques are described herein for supporting efficient evaluation of pivot operations. In an embodiment, a pivoting query on a data table is received. The query identifies pivot columns, measure columns, and grouping columns. In response to receiving the query, a stag...
01/21/2010
20100010960Operations of Multi-Level Nested Data Structure
Multiple sets of data are obtained from different sources. Each data set is represented using a different format having a different syntax and organized in a multi-level nested data structure. Each data set is reformatted into a standardized table format using a depth-f...
01/14/2010
20100010961DISTRIBUTED DIRECTORIES
Disclosed is a method for improving performance of distributed directory servers, which includes identifying directory servers configured to serve a partition index; monitoring the directory servers to identify whether a primary directory server has reached a maximum nu...
01/14/2010
20100010959SYSTEMS AND METHODS FOR QUERY EXPANSION IN SPONSORED SEARCH
The present invention is directed towards systems, methods and computer program products for providing query-based advertising content. According to one embodiment, a method for providing query-based advertising content comprises receiving a web query and generating an ...
01/14/2010
20100010962Deferred Compilation of Stored Procedures
A system, method, and computer program product are provided for compiling a stored procedure in a database. The compiling includes the steps of invoking the stored procedure, the stored procedure comprising one or more statements, substituting run-time values for one or...
01/14/2010
20100005056BATCH ENTITY REPRESENTATION IDENTIFICATION USING FIELD MATCH TEMPLATES
Techniques may be used to match records of a batch file to an entity representation in a universal database. Inputs may include, but are not limited to, a batch file and a universal (or other) database. The technique may compare the records of the batch file to the reco...
01/07/2010
20100005054Querying joined data within a search engine index
Techniques and systems for indexing and retrieving data and documents stored in a record-based database management system (RDBMS) utilize a search engine interface. Search-engine indices are created from tables in the RDBMS and data from the tables is used to create “...
01/07/2010
20100005055MULTI-TENANCY DATA STORAGE AND ACCESS METHOD AND APPARATUS
A method, apparatus, and a computer program product for storing and accessing multi-tenancy data. The method includes the steps of: creating a plurality of table sets in one or more databases, wherein each table set is used to store data of a group of tenants selected f...
01/07/2010
1                      
 
Sign InRegister
Username  
Password   
forgot password?