Abstract: Techniques are disclosed for retrieving database data records using a request having a substitute clause. The substitute clause replaces a value stored in a predefined column with a new value while selecting the values of the plurality of columns in a projection list. In one embodiment, the database request may utilize a pre-defined syntax for a SELECT statement that supports a substitute clause having a form of: substitute(<col name>, <expression>).

Abstract: In accordance with embodiments, there are provided mechanisms and methods for conditionally performing a query including an aggregate function. These mechanisms and methods for conditionally performing a query including an aggregate function can limit performance of queries including aggregate functions based on a number or records associated with such performance of such aggregate functions. The ability to limit performance of queries including aggregate functions can enable performance quality of a computer system to be maintained.

Abstract: A text mining apparatus, a text mining method, and a program are provided that enable the influence that computer processing errors have on mining results to be reduced during text mining performed on a plurality of text data pieces including a text data piece generated by computer processing. A text mining apparatus 1 to be used includes an inherent portion extraction unit 6 that, for each of a plurality of text data pieces including a text data piece generated by computer processing, extracts an inherent portion of the text data piece relative to another of the text data pieces, an inherent confidence setting unit 7 that, for each inherent portion of each of the text data pieces, sets inherent confidence indicating confidence of the inherent portion, using the confidence that has been set for each of the text data pieces, and a mining processing unit 8 that performs text mining on each inherent portion of each of the text data pieces, using the inherent confidence.

Abstract: A landmark search apparatus includes a position obtaining unit configured to obtain a current position of the object, a first storage unit configured to store landmark information including a name of a landmark and position information of the landmark related to the name, an retrieving unit configured to retrieve the landmark information from the first storage unit based on the obtained current position, a second storage unit configured to store the retrieved landmark information as retrieved landmark information, and a determining unit configured to determine whether the retrieved landmark information is valid, based on the current position of the object, and a distance between a position of the subject at the time of storing the retrieved landmark information in the second storage unit and the landmark indicated by the retrieved landmark information.