Abstract: A detection device for active dental caries and/or tooth erosion, comprising a light detection means, fluid dispensing means, and an atomiser, wherein the fluid dispensing means and atomiser are in fluid communication such that a disclosing fluid contained within the fluid dispensing means is dispensed through the atomiser evenly onto a surface of interest.

Abstract: A detection device for active dental caries and/or tooth erosion, comprising a light detection means, fluid dispensing means, and an atomiser, wherein the fluid dispensing means and atomiser are in fluid communication such that a disclosing fluid contained within the fluid dispensing means is dispensed through the atomiser evenly onto a surface of interest.

Abstract: In accordance with the teachings described herein, systems and methods are provided for performing index joins. A database management application may receive an instruction to perform an index join operation between columns in a first table and a second table, wherein the database management application does not have direct access to an index of the first table or the second table for performing the index join operation. A query may be automatically generated by the database management application, wherein the query includes a where clause equality expression that equates an indexed column of the second table with a parameter or updatable constant. The database management application may substitute a value from a row of the first table may for the parameter or updatable constant, and cause the query to be executed on the index of the second table to fetch any one or more rows of the second table that satisfy the where clause by having an index value that matches the substituted value.

Abstract: In accordance with the teachings described herein, systems and methods are provided for performing index joins. A database management application may receive an instruction to perform an index join operation between columns in a first table and a second table, wherein the database management application does not have direct access to an index of the first table or the second table for performing the index join operation. A query may be automatically generated by the database management application, wherein the query includes a where clause equality expression that equates an indexed column of the second table with a parameter or updatable constant. The database management application may substitute a value from a row of the first table may for the parameter or updatable constant, and cause the query to be executed on the index of the second table to fetch any one or more rows of the second table that satisfy the where clause by having an index value that matches the substituted value.

Abstract: Systems and methods are provided for performing a query in a distributed system. In one example, a query processor receives an instruction to perform a database operation involving a query. Based on an identification of a correlated subquery within the query, the query processor modifies the correlated subquery by replacing at least one correlated variable with a parameter or updatable constant. The modified subquery is sent to an external database for execution, where the external database is identified in the correlated subquery. The results of the modified subquery are received at the query processor from the external database and are used to execute the query. The correlated subquery includes a conditional relationship between a column in a first set of data and a column in a second set of data, wherein the first and second sets of data are stored in different external databases.