Abstract: A method for executing a query to access data stored in a database, wherein the query includes a plurality of DISTINCT keys, is disclosed. The method of the present invention includes providing a first DISTINCT operation on a first DISTINCT key, storing data fetched from the first DISTINCT operation in a master workfile if more than one sort process is needed to execute the query, and utilizing the master workfile to perform subsequent DISTINCT operations for the other DISTINCT keys.

Abstract: A system and computer readable medium for executing a query to access data stored in a database, wherein the query includes a plurality of DISTINCT keys, is disclosed. The system and computer readable medium includes a capture module for identifying each of the plurality of DISTINCT keys in the query and a sort module coupled to the capture module for determining if more than one sort is needed to execute the query, performing a first DISTINCT operation on a first DISTINCT key of the plurality of DISTINCT keys, storing data fetched from the first DISTINCT operation in a master workfile only if more than one sort process is needed to execute the query, and utilizing the master workfile to perform subsequent DISTINCT operations on the other of the plurality of DISTINCT keys.

Abstract: Multiple site information of light intensity is obtained by application of a multiple-fibre probe in a real-time optical monitoring system. The multiple-fibre probe includes a plurality of optical fibres distributed along the length of the probe. Each optical fibre may be is switchable between the mode for transmitting optical signal into the malignant tissue and the mode for collecting the optical signal from the same tissue. Thus the numbers of the probes can be minimized for collecting multiple site light information and the irritation to the tissue is reduced. A method of using such a probe to determine coagulated boundary in thermal or other treatment is also described.

Abstract: The present invention discloses a passive UHF omnidirectional container electronic seal. It comprises a locking bar and a locking cap; the locking bar contains a locking bar hasing a RFID chip and a cable connector, wherein the RFID chip is electrically connected with the cable connector; and the locking cap hasing a plug-in unit, which is matched with the cable connector in the locking bar for connecting an antenna in the locking cap. The present invention combines the mechanical container seal in the present market with the RFID technology and adopts the ultra-high frequency (UHF) RFID technology, which has overcome numerous shortcomings to reach the long-distance transmission, the transmission distance can be up to 10 meters and with no direction, can resist more than 1.2 tons pulling force, and the appearance is novel, small, exquisite and cheap.

Abstract: A method and system for efficiently identifying materialized view candidates for queries filters materialized views using certain criteria, using the materialized view signatures. This filtering rejects some of the unqualified materialized views prior to the performance of the query rewrite matching algorithm, resulting in a group of materialized view candidates. The query rewrite matching algorithm is then performed on the materialized view candidates. By first filtering the materialized views based on their signatures, the number of materialized views on which the query rewrite matching algorithm is performed is significantly reduced, improving performance.

Abstract: A digital ink jet printing process method comprising following procedures: 1. Choose the basic material, 2. Pre-process the basic material, 3. Print out graphics on basic materials directly; and, 4. After process on the surface of basic materials to protect the graphics on the surface of the basic materials; based on the procedures, choose the proper basic material to have the basic material with more variable colors, the graphics, colors are not limited, more saturated colors, better scratch-proof and water-proof; the graphics can stay on basic material longer with good weather fastness and grade in deposit standard.

Abstract: A method, apparatus, and article of manufacture for optimizing a query in a computer system, wherein the query is performed by the computer system to retrieve data from a database stored on the computer system. The optimization is performed by identifying a correlated subquery in the query that qualifies for transformation, transitively closing a local filtering predicate within the identified correlated subquery that is on a same column as a correlation join predicate within the identified correlated subquery, and pulling out or bubbling up the transitively closed predicate from the correlated subquery to a parent query block of the query.

Abstract: A heuristic approach is used to order materialized view (MW) candidates in a list based on descending order of their reduction power. A query (e.g., SQL query) is then matched with the MVs in the list order, wherein searching is stopped when matching has been found. The query is matched with materialized views in the ordered list by identifying a materialized view candidate as follows: identifying an MV that is not locked by a REFRESH process; identifying a matching MV that does not require a regroup; identifying a matching MV that does not require a rejoin; identifying a matching MV that does not require a residual join; or identifying an MV with largest reduction power from the list of candidates.

Abstract: A method, apparatus, and article of manufacture for optimizing a query in a computer system, wherein the query is performed by the computer system to retrieve data from a database stored on the computer system. The optimization is performed by identifying a correlated subquery in the query that qualifies for transformation, transitively closing a local filtering predicate within the identified correlated subquery that is on a same column as a correlation join predicate within the identified correlated subquery, and pulling out or bubbling up the transitively closed predicate from the correlated subquery to a parent query block of the query.

Abstract: A heuristic approach is used to order materialized view (MW) candidates in a list based on descending order of their reduction power. A query (e.g., SQL query) is then matched with the MVs in the list order, wherein searching is stopped as soon as good enough matching has been found. The query is matched with materialized views in the ordered list by identifying a materialized view candidate as follows: identifying an MV that is not locked by a REFRESH process; identifying a matching MV that does not require a regroup; identifying a matching MV that does not require a rejoin; identifying a matching MV that does not require a residual join; or identifying an MV with largest reduction power from the list of candidates.

Abstract: A method, apparatus, and article of manufacture for optimizing a query in a computer system, wherein the query is performed by the computer system to retrieve data from a database stored on the computer system. The optimization includes: identifying a materialized view candidate in the computer system, matching a grouping of the materialized view with a grouping of the query using column equivalence and functional dependency, in order to determine whether re-aggregation is necessary, deriving one or more aggregate functions requested by the query from the materialized view and any remaining tables in the query based on the matched groupings, and rewriting the query based on the matched groupings.

Abstract: A method and system for efficiently identifying materialized view candidates for queries filters materialized views using certain criteria, using the materialized view signatures. This filtering rejects some of the unqualified materialized views prior to the performance of the query rewrite matching algorithm, resulting in a group of materialized view candidates. The query rewrite matching algorithm is then performed on the materialized view candidates. By first filtering the materialized views based on their signatures, the number of materialized views on which the query rewrite matching algorithm is performed is significantly reduced, improving performance.

Abstract: A method and system for executing a query to access data stored in a database, wherein the query includes a plurality of DISTINCT keys, is disclosed. The method and system of the present invention includes providing a first DISTINCT operation on a first DISTINCT key, storing data fetched from the first DISTINCT operation in a master workfile if more than one sort process is needed to execute the query, and utilizing the master workfile to perform subsequent DISTINCT operations for the other DISTINCT keys.

Abstract: The printed circuit board testing apparatus for use to test the short circuit in an induction element is provided. The apparatus includes: a signal generating device for providing a first signal; an inducing device for performing a mutual inductance effect with the induction element and making the first signal to produce a second signal in response to the mutual inductance effect; a signal converting device for converting the second signal into a direct current signal and obtaining a peak value voltage from the direct current signal; a signal processing device for outputting a controlling signal according to the relationship between the peak value voltage and a reference voltage; and a warning device for generating a warning signal in response to the status change of the controlling signal when a relative voltage standard is not identical to a predetermined voltage standard, thereby judging whether there is any short circuit formed.

Abstract: The invention relates to electrophotographic recording media suitable for use with color copiers and laser printers. The media comprise an opaque substrate coated with a toner-receptive layer containing an epoxy or polyester resin having a melting point in the range of about 105° C. to about 200° C., and a wax having a melting point in the range of about 90° C. to about 200° C. The glossy media have good blocking resistance and are capable of producing high quality colored images.

Abstract: Disclosed is a system, method, and program for searching a list of entries. Each entry is comprised of multiple fields. Each field in the entry may include one of a range of possible values for that field. If search criteria is provided for less than all of the fields, then multiple search keys will be generated such that each generated search key includes a search value for each field. The search value for each field for which there are no provided search criteria comprises one of the possible values for that field. A search operation is executed for each of the generated search keys to determine entries in the list that include field values that match the search values in the search key.

Abstract: The printed circuit board testing apparatus for use to test the short circuit in an induction element is provided. The apparatus includes: a signal generating device for providing a first signal; an inducing device for performing a mutual inductance effect with the induction element and making the first signal to produce a second signal in response to the mutual inductance effect; a signal converting device for converting the second signal into a direct current signal and obtaining a peak value voltage from the direct current signal; a signal processing device for outputting a controlling signal according to the relationship between the peak value voltage and a reference voltage; and a warning device for generating a warning signal in response to the status change of the controlling signal when a relative voltage standard is not identical to a predetermined voltage standard, thereby judging whether there is any short circuit formed.

Abstract: Disclosed is a system, method, and program for joining a multi-column table and at least two satellite tables. Each satellite table is comprised of multiple rows and at least one join column and each multi-column table is comprised of multiple rows and join columns corresponding to the join columns in the satellite tables. A query including predicates is received. A join predicate column comprises the satellite table and multi-column table join column to which at least one query predicate applies. A determination is then made as to whether there is at least one index on the multi-column table including at least one column for one join predicate column. One index is selected. The ordering of the join predicate columns in the selected index is used to determine the join order of the satellite tables and the multi-column table. The satellite tables and multi-column tables are then joined in the determined join order.

Abstract: A secondary index search in a relational database system compares primary key selection criteria against a primary key value stored in a secondary index record that satisfies secondary key selection criteria instead of searching a primary index for a primary key value that satisfies the primary key selection criteria.

Abstract: A hybrid hash join process joins data rows from two tables which have at least one common data column by partitioning the data rows based on the values in the common data column(s), creating data structures to decrease search time for matching rows, and recovering full data buffers using a unique buffer management methodology. A smaller one of the two tables is designated as an outer table and a larger one of the two tables as an inner table. The hybrid hash join process determines which rows in the inner and outer tables satisfy a selection criteria; the rows that satisfy the selection criteria are referred to as inner hit rows and outer hit rows. The hybrid hash join process assigns the inner and outer hit rows to corresponding inner and outer partitions, respectively. Buffer overflow in the outer partitions is handled by linking empty buffers to the outer partitions until all buffers are used. Buffer space is recovered by writing outer hit rows for a selected partition to mass storage.