| 6625593 |
Parallel query optimization strategies for replicated and partitioned tables |
| Sep-23-2003 |
A method, apparatus, and article of manufacture for optimizing database queries. The query is analyzed to determine whether at least a portion of the query can be evaluated using a plurality of parallel... |
| 6625592 |
System and method for hash scanning of shared memory interfaces |
| Sep-23-2003 |
A system, method, and data structure are delineated for use in data storage and retrieval. An array of records stored in shared memory contains data entries, and associated hash codes computed from a predetermined... |
| 6622138 |
Method and apparatus for optimizing computation of OLAP ranking functions |
| Sep-16-2003 |
Techniques are described for optimizing the computation of OLAP ranking functions. The techniques involve push-down of the filtering operation into the window sort operation corresponding to a target ranking... |
| 6618758 |
System for downloading only a portion of a file from a server through a computer network utilizing a client menu downloaded periodically from the server |
| Sep-9-2003 |
A system for use in downloading a file from a server through a computer network to a client. In one embodiment, the system can include a subfile selector that has: (1) a subfile designator, associated... |
| 6618729 |
Optimization of a star join operation using a bitmap index structure |
| Sep-9-2003 |
A method, apparatus, and article of manufacture for optimizing a star join operation in relational database management systems (RDBMS). A cross-product is generated from a plurality of dimension tables... |
| 6618720 |
Common spool files for maintaining join indexes |
| Sep-9-2003 |
The retrieval of data from a database in a computerized database management system is optimized through the use of a plurality of join indexed. The join indexes are defined for a table stored in the database.... |
| 6618719 |
Database system with methodology for reusing cost-based optimization decisions |
| Sep-9-2003 |
A database system providing a methodology, implemented as an "Abstract Plan on Disc" technology (referred to herein as, "Ariadne"), is described for turning cost based optimization decisions into stored,... |
| 6618718 |
Apparatus and method for dynamically generating query explain data |
| Sep-9-2003 |
An apparatus for dynamically generating query explain data includes modules of operational data and executable code for execution by a computer processor. The modules include a query explain program operating... |
| 6611841 |
Knowledge acquisition and retrieval apparatus and method |
| Aug-26-2003 |
A knowledge acquisition and retrieval apparatus and method that emulate the human brain and comprise at least one first memory segment, and a distinct second memory segment, wherein elements of the at... |
| 6611837 |
System and method for managing hierarchical objects |
| Aug-26-2003 |
A system and method for storing hierarchical objects. The system stores a list of hierarchies as a single object. The object includes all information relating to a particular data element. The data element... |
| 6611834 |
Customization of information retrieval through user-supplied code |
| Aug-26-2003 |
A user at a client machine can customize components of a database search performed at a server. The user does this by sending executable code to the database server. Software code runs as middleware on... |
| 6609133 |
Integrating both modifications to an object model and modifications to a database into source code by an object-relational mapping tool |
| Aug-19-2003 |
In accordance with methods and systems consistent with the present invention, an improved object-relational mapping tool is provided that generates source code containing classes which preserve both changes... |
| 6606634 |
Obtaining table objects using table dispensers |
| Aug-12-2003 |
A table dispenser provides one or more table objects for accessing one or more datastores containing configuration information in a computer system, responsive to a request for a table from a caller. The... |
| 6606619 |
Computer processes for selecting nodes to call to attention of a user during browsing of a hierarchical browse structure |
| Aug-12-2003 |
A computer-implemented process identifies specific nodes within a browse tree or other hierarchical browse structure based on historical actions of online users, and calls such nodes to the attention of... |
| 6606618 |
Method for optimizing the performance of a database |
| Aug-12-2003 |
A relational installation database for storing data elements in the form of strings, objects, etc. is aliased with integer identifiers corresponding to each data element is disclosed. The integer identifiers... |
| 6606617 |
Optimized technique for prefetching LOB table space pages |
| Aug-12-2003 |
A method, apparatus, and article of manufacture for a computer implemented technique for prefetching pages. Pages are prefetched from a database stored on a data storage device connected to a computer.... |
| 6606525 |
System and method of merging static data in web pages |
| Aug-12-2003 |
A system and method for merging static data and dynamic data downloaded to a browser from a network site of a network, preferably being a website on the Internet. The system includes at least one server... |
| 6604127 |
Dynamic lookup service in distributed system |
| Aug-5-2003 |
An improved lookup service is provided that allows for the dynamic addition and deletion of services. This lookup service allows for the addition and deletion of services automatically, without user intervention.... |
| 6604097 |
Method, system, and program for using control data structures when performing operations with respect to a database |
| Aug-5-2003 |
Provided is a method, system, program, and data structures for making data available to an application program. A result table is generated including rows corresponding to a subset of rows in a base table... |
| 6604096 |
Apparatus and method for locally caching query explain data |
| Aug-5-2003 |
An apparatus for dynamically generating query explain data includes a processor for executing instructions and a memory device having thereon modules of operational data and executable code for execution... |
| 6601064 |
Method and apparatus for fetching array based objects by direct delivery and batching |
| Jul-29-2003 |
A method, apparatus, article of manufacture, and a memory structure for providing access to an array-based data object to a client is disclosed. The method comprises the steps of receiving a database query... |
| 6598055 |
Generic code for manipulating data of a structured object |
| Jul-22-2003 |
A technique for providing generic code for manipulating a structured object stored on a data store connected to a computer. Initially, an encoded identifier is received. The encoded identifier is decoded... |
| 6598046 |
System and method for retrieving documents responsive to a given user's role and scenario |
| Jul-22-2003 |
A document retrieval and navigational system and method based on a user's role, scenario, and context in a given context or scenario. A database is provided which has a plurality of documents which are... |
| 6598038 |
Workload reduction mechanism for index tuning |
| Jul-22-2003 |
A workload reduction mechanism for index tuning is described that selects relevant database statements from a database workload, standardizes a format of the relevant database statements and reduces the... |
| 6594669 |
Method for querying a database in which a query statement is issued to a database management system for which data types can be defined |
| Jul-15-2003 |
A newly defined data type is added to a database management system. Information about a query component assisting in querying data belonging to the newly defined data type is registered along with data... |
| 6594653 |
Server integrated system and methods for processing precomputed views |
| Jul-15-2003 |
Server-integrated methods and apparatus for processing precomputed views for answering user queries on a database are described. In accordance with one embodiment, a system for answering user queries on... |
| 6594652 |
Electronic discussion system for exchanging information among users creating opinion indexes in accordance with content of each options |
| Jul-15-2003 |
An electronic discussion system including discussion terminals for writing and managing opinion information and clients for accessing the discussion terminals through a network. The electronic discussion... |
| 6594651 |
Method and apparatus for parallel execution of SQL-from within user defined functions |
| Jul-15-2003 |
A method, apparatus, and an article of manufacture for parallel execution of SQL operations from within user defined functions. One or more embodiments of the invention provide the user defined function... |
| 6594650 |
File management system and its method and storage medium |
| Jul-15-2003 |
A document management system having enhanced operability so that a plurality of documents can be processed at a time by integrating a search operation, an image recording operation, and an index input... |
| 6591346 |
Mechanism for managing an object cache |
| Jul-8-2003 |
An improved mechanism for managing an object cache is disclosed. An object cache manager receives a request for an object resident in an object cache. A determination is made as to whether the requested... |
| 6591273 |
Method and system for secure electronic distribution, archiving and retrieval |
| Jul-8-2003 |
The present invention provides a secure electronic information distribution, archiving and retrieval method and system for communication and correspondence purposes using an integrated system of email,... |
| 6591266 |
System and method for intelligent caching and refresh of dynamically generated and static web content |
| Jul-8-2003 |
A system for updating Web pages stored in cache based on modifications to data stored in a database is disclosed. The system for updating stored Web pages may be part of a larger system having a database... |
| 6591262 |
Collaborative workload management incorporating work unit attributes in resource allocation |
| Jul-8-2003 |
A collaborative workload management system comprises a workload scheduler cooperable with a schedule to submit work units for processing on a computer system according to the schedule; and a workload manager... |
| 6591261 |
Network search engine and navigation tool and method of determining search results in accordance with search criteria and/or associated sites |
| Jul-8-2003 |
The search engine of the present invention combines the rated index of the content of a web site with the correlation of links to other sites to provide a logical grouping of related sites and enhanced... |
| 6591260 |
Method of retrieving schemas for interpreting documents in an electronic commerce system |
| Jul-8-2003 |
A method and computer system are described for conducting commercial transactions by the exchange of electronic documents. The computer system includes a transaction services network, which comprises a... |
| 6587857 |
System and method for warehousing and retrieving data |
| Jul-1-2003 |
A system and method for preparing and integrating operational data received from nodes on a network prior to loading the data onto a data warehouse. Operational data received from nodes on a network is... |
| 6587847 |
Method and system for monitoring knowledge use |
| Jul-1-2003 |
Improving an entity's operational performance involves monitoring use of its knowledge by measuring use of a knowledge base storing its knowledge, and monitoring knowledge that it generates by evaluating... |
| 6581059 |
Digital persona for providing access to personal information |
| Jun-17-2003 |
A method and system provides a structured and accessible information repository for an entities personal information. An information server contains a personal information database and a set of information... |
| 6581056 |
Information retrieval system providing secondary content analysis on collections of information objects |
| Jun-17-2003 |
An information retrieval system having a secondary content analysis engine for use on collections of documents. Such collections of documents dynamically arise as a result of queries one or more, possibly... |
| 6581052 |
Test generator for database management systems |
| Jun-17-2003 |
A test generator produces a set of database query-language statements comprised of randomly chosen elements for testing one or more database management systems on arbitrary databases. The statements are... |
| 6578029 |
System and method for selectively defining access to application features |
| Jun-10-2003 |
A method and system are described for defining a user's access to one or more features of an application. One or more "attributes" are assigned to users of a computer system and stored in a data table.... |
| 6578028 |
SQL query generator utilizing matrix structures |
| Jun-10-2003 |
A graphical SQL query generator and query operators are disclosed. The query tool embeds matrix objects that are used for building and transforming SQL based queries, views, data cubes and other relations... |
| 6578027 |
Relational database access system using semantically dynamic objects |
| Jun-10-2003 |
A relational database access system and method provides a new data representation and a query technique which allows information system end users to access (query) relational databases without knowing... |
| 6578026 |
Method and system for conducting reverse index scans |
| Jun-10-2003 |
A method executed by a data processor for scanning a reverse range. The scan is conducted in an index for a table having an upper end and a lower end. The reverse range has a start key value for defining... |
| 6578025 |
Method and apparatus for distributing information to users |
| Jun-10-2003 |
A method and apparatus for providing information to a plurality of users based on the relevancy of the information to the users are disclosed. An incoming message is received. Similarity scores are generated... |
| 6574619 |
System and method for providing cross-dimensional computation and data access in an on-line analytical processing (OLAP) environment |
| Jun-3-2003 |
A system for generating a value for a first attribute includes a database having one or more dimensions that each include one or more members. The database includes one or more storage locations that are... |
| 6574615 |
System and method for monitoring support activity |
| Jun-3-2003 |
The present invention discloses a computer system for measuring and monitoring local client support activity associated with servicing and supporting a computer by a client. The system includes a local... |
| 6571243 |
Method and apparatus for creating extractors, field information objects and inheritance hierarchies in a framework for retrieving semistructured information |
| May-27-2003 |
According to the invention, a system and method for extracting information from a semistructured information source. The system includes a listing stack for holding extracted information. A means for matching... |
| 6571233 |
Optimization of SQL queries using filtering predicates |
| May-27-2003 |
A technique for optimizing execution of a query that accesses data stored on a data store connected to a computer. Query predicates involving different data types are identified. A second query predicate... |
| 6571232 |
System and method for browsing database schema information |
| May-27-2003 |
A query object generator tool which generates interface definitions and code that implement a query object also generates a database schema access query object that retrieves the schema of an underlying... |
