Patent application number | Description | Published |
20090313211 | PUSHING JOINS ACROSS A UNION - Selecting a join plan for a query containing a join and a union block includes determining whether to propose a join plan with the join pushed across the union block. A selection is made between a join plan in which the join is not pushed across the union block and any proposed join plan in which the join is pushed across the union block. | 12-17-2009 |
20130173589 | TECHNIQUES FOR OPTIMIZING OUTER JOINS - Techniques for optimizing outer joins in database operations are provided. In an embodiment, a query having an outer join with a GROUP BY clause is rewritten and expanded to expand a first level partition of that GROUP BY clause to produce a modified query. In another situation, rows associated with processing a query are each row split and then hashed based at least in part on attributes of the outer join predicate. A left outer join is performed and a global aggregation processed to produce a spooled table to process the query. | 07-04-2013 |
20140181074 | ESTIMATING NUMBER OF ITERATIONS OR SELF JOINS REQUIRED TO EVALUATE ITERATIVE OR RECURSIVE DATABASE QUERIES - The number of iterations or self joins required to execute a recursive database query can be estimated. It will be appreciated that this estimation can be used to plan the execution of the recursive query and can be made in various ways and for various applications. By way of example, an estimated number of iterations or self joins required to execute a recursive database query (e.g., 12) can be used as a basis to determine or plan an optimal execution plan. For example, given an estimated twelve (12) iterations, an execution plan can be determined for executing at least the first three (3) iterations or for executing every there (3) iterations, whereas for an estimated twenty (21) iterations required to complete a recursive database query, an execution plan can be determined for the first five (5) or six (6) iterations, and so on. | 06-26-2014 |
20140181078 | CARDINALITY ESTIMATION FOR OPTIMIZATION OF RECURSIVE OR ITERATIVE DATABASE QUERIES BY DATABASES - An execution plan for executing one or more iterations of recursive database queries can be generated in accordance with one aspect of the invention. For example, in accordance with one embodiment of the invention, one or more cardinalities (results or size of results, including intermediate results) associated with one or more iterations can be estimated. This estimation can, for example, by performed by using a sampling or sampling-based algorithm. | 06-26-2014 |
20140181079 | ADAPTIVE OPTIMIZATION OF ITERATIVE OR RECURSIVE QUERY EXECUTION BY DATABASE SYSTEMS - Based on one or more predicated results (e.g., estimations of the actual results) associated with one or more iterations and/or sub-queries of an iterative or recursive database query, it can be determined whether to use an execution plan (e.g., a current execution plan used to execute one or more iterations) to execute one or more other iterations and/or sub-queries of the iterative or recursive database query. Consequently, use of the execution plan to execute the one or more other iterations and/or sub-queries of the iterative or recursive database query can be disallowed. As a result, the iterative or recursive database query can be executed more efficiently. The determination of whether to use an execution plan can, for example, be performed by determining whether an actual result obtained by executing one or more iterations differs or diverges more than a determined value from an estimated result of the same iteration(s). | 06-26-2014 |
Patent application number | Description | Published |
20080318798 | Antigen Detection - The present invention relates to methods of detecting specific cell surface antigens present in a sample of cells being tested and in particular blood group antigens, which methods do not employ the addition of extrinsic labels to detect said cell surface antigens. Typically detection is carried out using an intrinsic fluorescence capability of the cells being tested. | 12-25-2008 |
20090022628 | APPARATUS AND METHODS FOR MICROFLUIDIC APPLICATIONS - Non-rigid tape apparatus and fabrication methods for microfluidic processing applications such as gel electrophoresis are provided, where microfluidic processing is performed on selected areas. Parts of the tape are formed by high pressure plastic film forming. Membranes and other structures are self sealing during and after penetration by pipettes and electrical probes. Rigid exoskeleton elements protect the non-rigid parts during processing and facilitate transport of the tape. | 01-22-2009 |
20100203516 | DETECTING ANALYTES USING BOTH AN OPTICAL AND AN ELECTRICAL MEASUREMENT METHOD - Provided is a method for detecting an analyte, wherein the analyte is labelled with one or more labels relatable to the analyte, which method comprises: a) performing an optical detection method on the labelled analyte to obtain optical data from the one or more labels; b) performing an electrical detection method on the labelled analyte to obtain electrical data from the one or more labels; and c) determining the identity and/or quantity of the analyte from both the optical and electrical data. Further provided is a method for detecting a plurality of analytes, wherein the each different analyte is labelled with one or more different labels relatable to the analyte, which method comprises: a) performing an optical detection method on a plurality of labelled analytes to obtain optical data from the labels; b) performing an electrochemical detection method on the plurality of labelled analytes to obtain electrical data from the labels; and c) determining the identity and/or quantity of the plurality of analytes from both the optical and electrical data. | 08-12-2010 |
20120195809 | APPARATUS AND METHODS FOR MICROFLUIDIC APPLICATIONS - Non-rigid tape apparatus and fabrication methods for microfluidic processing applications such as gel electrophoresis are provided, where microfluidic processing is performed on selected areas. Parts of the tape are formed by high pressure plastic film forming. Membranes and other structures are self sealing during and after penetration by pipettes and electrical probes. Rigid exoskeleton elements protect the non-rigid parts during processing and facilitate transport of the tape. | 08-02-2012 |
20120285829 | DETECTING ANALYTES - Provided is a method for detecting an analyte, which method comprises:
| 11-15-2012 |