Abstract: A location identification system is described. In various embodiments, the location identification system identifies geographic location information in response to received search queries by processing geographic information to identify spatial or geometric regions, determining region intersection information that identifies spatial relationships between the geometric regions, and building an index of regions of constant attributes by associating intersecting geometric regions. In various embodiments, the location identification system can include a vector database wherein the vector database comprises geometric information including at least (a) spatial information geographically describing items and their locations and (b) textual attributes associated with the items or their locations, and an index of regions of constant attributes wherein the index associates textual attributes with items and their locations so that a proximity of two locations can be identified.

Abstract: GUI log text record arrangements (referred to as GLTR arrangements) are disclosed which facilitate the problem diagnosis process between a Support Service Provider (SSP) machine (101) and a client machine (108). Graphical User Interface (GUI) screens and their associated user actions, with reference to a client application, are logged on the client machine (108) in the form of GUI log text records. The SSP machine (101) reproduces the application GUI screens and the user actions from logged GUI log text records passed from the client machine (108). This provides, to the SSP machine (101), a facility for browsing through historic application GUI screens and their associated user actions. The GLTR system also provides a facility for remotely operating the client application, to further clarify the problem, and/or to take remedial action for overcoming the problem.

Abstract: Hot tuples within a database are detected. The hot tuples are within a selected table having a number of columns over which tuples are stored. The hot tuples are thus included within the tuples stored in the selected table, and are defined as the tuples that are frequently referenced by tuples of one or more other tables. Such hot tuples may be detected without regards to select conditions placed on them via queries of query templates. Detection of the hot tuples is based on the query templates of such queries that are processed against the database, which includes the selected table and the other tables referencing the selected table. The database is stored on a non-volatile storage. The hot tuples detected are stored or placed to provide for quicker access thereof.