Site News  |   Monitor Keywords  |   Monitor Archive  |   Organizer  |   Account Info  |

System for unordered relational database retrieval returning distinct values

System for unordered relational database retrieval returning distinct values description/claims

Under 35 USC §120, this application is a continuation application and claims the benefit of priority to U.S. patent application Ser. No. 10/188,569, filed Jul. 2, 2002, entitled “Method for Unordered Relational Database Retrieval Returning Distinct Values”, which claims the benefit of priority under 35 USC §119 to Canadian Application No. 2,353,015, filed Jul. 12, 2001, all of which is incorporated herein by reference.

The present invention generally relates to relational database management systems, and in particular to relational database retrieval constrained to return distinct values.

In relational database management systems, typically relational queries are supported which may be constrained to return distinct tuples or rows. An example is the SQL keyword DISTINCT which, when used to qualify a query, ensures that there are no duplicate rows in the returned set of data satisfying the query.

In the prior art, such queries are implemented by the returned set of rows or tuples being calculated and then sorted. After the sort is carried out, the duplicate rows are discarded and the unique set of rows or tuples is returned.

Where a relational database is used as a backend for a time sensitive application, such as a website, for example, the time needed to sort the resulting table before discarding the duplicate rows may result in user dissatisfaction. In addition, where the data is to be presented to the user in a previously established order, after duplicate filtering the resulting table must be reordered to reflect that previously established order.

It is therefore desirable to provide an implementation of the relational query that is constrained to return distinct or unique values but which is not subject to initial delays in presenting resulting rows to a user and in which the resulting table retains a previously established ordering.

According to an aspect of the present invention there is provided improved retrieval of distinct tuples or rows in a relational database management system.

According to another aspect of the present invention there is provided a method for sequentially providing a consumer process with a set of relational data including tuples matching a defined criteria, the method including the steps of: retrieving from a database table a tuple in a sequence of tuples, the tuple satisfying the defined criteria, determining whether the tuple is unique in comparison to previously retrieved tuples in the sequence, providing the consumer process with the tuple where the tuple is unique and discarding the tuple where the tuple is not unique, and repeating the above steps until all tuples matching the defined criteria have been retrieved from the relational table.

Continue reading about System for unordered relational database retrieval returning distinct values...
Full patent description for System for unordered relational database retrieval returning distinct values

Brief Patent Description - Full Patent Description - Patent Application Claims

Click on the above for other options relating to this System for unordered relational database retrieval returning distinct values patent application.

Patent Applications in related categories:

20090299980 - method for searching and displaying content in a directory - An improved system and methods for searching and displaying content in a directory having a single-action process which instantaneously displays search results solely of items open and operating at the exact time of the search request, within close proximity of the requester. An exemplary method may comprise the steps of: ...

20090299982 - Apparatus and method for routing composite objects to a report server - A computer readable medium stores instructions for execution on a computer. The instructions receive a collection of composite objects. An aggregate dataset that includes a portion of contents of object instances in the collection of composite objects is created. The aggregate dataset includes contents of object instances formed by reflection, ...

20090299971 - Binary search circuit and method - A binary search circuit 36 searches a database 50, which stores pieces of data aligned in ascending or descending order, for comparison target data by binary search. Comparison circuits 36A, 36B and 36C compare pieces of data read out from databases 50A, 50B and 50C with the comparison target data. ...

20090299974 - Character sequence map generating apparatus, information searching apparatus, character sequence map generating method, information searching method, and computer product - A computer-readable recording medium stores therein a sequence-map generating program that causes a computer to execute extracting from files that include character strings written therein, a word having q (q≧2) characters; extracting from the word extracted at the extracting the word, consecutive characters from a character position s-th (1≦s≦q−r+1) from ...

20090299969 - Data warehouse system - Methods and apparatus, including computer program products, implementing and using techniques for analyzing historical data in a data warehouse. A data warehouse is provided. The data warehouse includes several database tables. Every database table has a start time column and an end time column. A query is issued to the ...

20090299972 - Device and method for updating a certificate - A method updates certificates for potential recipients. The method comprises determining whether the certificates require updating. The method comprises determining a number of the certificates that require updating. The method comprises requesting updates for each of the certificates that require updating when the number is at most a preset number ...

20090299962 - Dynamic update of a web index - Systems and methods are provided for regularly updating a web index with new or updated content, such as meta words or meta streams, for a particular web page address, such as a URL. Web page addresses and associated updated information, such as meta words, meta streams, values, and locations in ...

20090299961 - Face search in personals - A device, system and method to enable searching of personal profiles in the context of on-line dating that includes the ability to determine the personal profiles that have images that most closely resemble a target image. ...

20090299981 - Information processing device, information processing method, and program - An information processing device includes: a storage management unit configured to store and manage content files; a metadata obtaining unit configured to obtain metadata of a recommendation source content; a content selecting unit configured to select, from content files managed by the storage management unit, recommended contents to be recommended ...

20090299973 - Information searching apparatus, information managing apparatus, information searching method, information managing method, and computer product - A computer-readable recording medium stores therein an information searching program that causes a computer having access to archives including a compressed file group of compressed files that are to be searched and that have described therein character strings, to execute: sorting the compressed files in descending order of access frequency ...

20090299966 - Management of large dynamic tables - Managing a table as multiple ordered blocks of entries. Each block has a local index value for each entry, and each entry has an associated element value. The entries in the table are monotonically ordered, and the table is searchable by element value and entry index value. Each block has ...

20090299977 - Method for automatic labeling of unstructured data fragments from electronic medical records - A method for automatically labeling unstructured data from electronic medical records using a computer-based medical data processing system includes selecting a data pattern based on a desired medical finding. The selected data pattern is searched for within source data including patient records to find one or more matches. A context ...

20090299963 - Method, apparatus, and computer program product for content use assignment by exploiting social graph information - An apparatus for automatically assigning content information may include a processor. The processor may be configured to receive content information, and identify the usage type and the sub-usage type of the content information. The content information may comprise an indicator for a usage type and a sub-usage type. The processor ...

20090299968 - Methods and apparatus to save search data - Methods and apparatus to save search data are described. An example method for use in media presentation system includes receiving one or more characters to form a search string to be used in a first type of search; converting the search string to one or more keywords to be used ...

20090299960 - Methods, systems, and computer program products for automatically modifying a virtual environment based on user profile information - The subject matter described herein includes methods, systems, and computer program products for automatically modifying a virtual environment based on user profile information. According to one aspect, the method includes determining user profile information associated with a user and automatically modifying a virtual environment based on the determined user profile ...

20090299965 - Navigating product relationships within a search system - Embodiments of the present invention relate to aggregating product information from a variety of sources to generate user interfaces that allow users to navigate and discover products. Product information is aggregated from both feed and crawl sources, and product entities are identified within the aggregate product information. In some embodiments, ...

20090299984 - Partial data model exposure through client side caching - The present invention generally provides methods, articles of manufacture and systems for exposing, on a client device, fields of a data model representing an underlying database for use in building queries against the database. For some embodiments, the client device may be a device having limited resources, such as a ...

20090299964 - Presenting search queries related to navigational search queries - A method and medium are provided for determining whether search queries issued to a search engine are navigational search queries and displaying related search queries and corresponding URLs in association with a URL corresponding to a target of the navigational search query. One embodiment of the method includes receiving a ...

20090299979 - Product lifecycle information management system using ubiquitous technology - A product lifecycle information management system using ubiquitous technology is provided. The system includes a service manager that comprises a service repository for registering a service using product information in a product lifecycle and multiple interface agents (IAs) for providing an interface for the service registered in the service repository. ...

20090299970 - Social network for mail - A method for analyzing email data including: parsing a first email into one or more email attributes; searching a social network datastore that stores email attributes of other emails; retrieving history data related to one or more or the email attributes from the social network datastore; and processing the one ...

20090299975 - System and method for document analysis, processing and information extraction - The present invention is directed to a method and computer system for representing a dataset comprising N documents by computing a diffusion geometry of the dataset comprising at least a plurality of diffusion coordinates. The present method and system stores a number of diffusion coordinates, wherein the number is linear ...

20090299983 - System and method of accelerating document processing - Embodiments include methods and systems for processing XML documents. One embodiment is a system that includes a tokenizer configured to identify tokens in an XML document. A plurality of speculative processing modules are configured to receive the tokens and to at least partially process the XML document and to provide ...

20090299978 - Systems and methods for keyword and dynamic url search engine optimization - A method implemented on one or more computer processors for search engine optimization may comprise automatically determining a relevancy of the keywords, automatically assigning an inverse document frequency (IDF) value to each keyword designated highly relevant, automatically defining relationships between keywords that are determined both highly user-relevant and highly database-relevant, ...

20090299976 - Systems and methods of identifying chunks from multiple syndicated content providers - A computer receives a first set of information items from a first content provider and a second set of information items from a second content provider. For each of the first and second sets of information items, the computer retrieves the document identified by the corresponding document link from a ...

20090299967 - User advertisement click behavior modeling - Described herein is technology for, among other things, mining similar user clusters based on user advertisement click behaviors. The technology involves methods and systems for mining similar user clusters based on log data available on an online advertising platform. By building a user linkage representation based on one or more ...


###


How KEYWORD MONITOR works... a FREE service from FreshPatents
1. Sign up (takes 30 seconds). 2. Fill in the keywords to be monitored.
3. Each week you receive an email with patent applications related to your keywords.  
Start now! - Receive info on patent apps like System for unordered relational database retrieval returning distinct values or other areas of interest.
###


Previous Patent Application:
System and method for sharing of search query information across organizational boundaries
Next Patent Application:
Systems and methods for a consumer to determine food/medicine interactions
Industry Class:
Data processing: database and file management or data structures

###

• Provisional Patent
• Utility Patent

• What Is a Patent?
• What Is a Trademark or Servicemark?
• What Is a Copyright?
• Patent Laws