Abstract: Methods and systems are provided for converting a loop (e.g., a cursor loop) to a declarative Structured Query Language (SQL) query that invokes a custom aggregate function. The loop includes a select query and a loop body that includes a program fragment that can be evaluated over a result set of the select query one row at a time. The system verifies that the loop body does not modify a persistent state of the database. A custom aggregate function that expresses the loop body is automatically constructed according to a contract. An aggregate class comprising aggregation methods of the contract are used to construct the aggregate function based on results of static analysis. The select query is automatically rewritten to form a declarative SQL query that invokes the custom aggregate function. The declarative SQL query may be executed by a database management system (DBMS) SQL server.

Abstract: Aspects of the subject technology provide for suggested home screens and/or lock screens of an electronic device. The suggested home screens and/or lock screens can include suggested backgrounds, user interface elements, colors, styles, photos, and the like, and can be generated and/or suggested for a user of an electronic device based on activity history information for the user and/or the electronic device. In one or more implementations, the home screens and/or lock screens may be generated and/or suggested specifically for various operational modes of the electronic device.

Abstract: A user is associated with initial search requests, and results that comprise attribute types indicative of a common relationship with other results. Each result has an attribute parameter for each attribute type. Search interaction data. Search interaction data comprises attribute parameter data and user interaction data for the search results. A machine learning algorithm is trained to analyze the search interaction data to recognize common relationships, and used to detect a common relationship between the respective attribute parameters for one of the attribute types for which the user interest data indicates interest. When a subsequent search request is received from the user, a user interest characteristic is computed for each result, based on similarity between the attribute preference data detected using the machine learning algorithm and the attribute parameter for the attribute type. The search results are presented to the user, sorted according to user interest characteristic.

Abstract: Methods and systems are provided for converting a loop (e.g., a cursor loop) to a declarative Structured Query Language (SQL) query that invokes a custom aggregate function. The loop includes a select query and a loop body that includes a program fragment that can be evaluated over a result set of the select query one row at a time. The system verifies that the loop body does not modify a persistent state of the database. A custom aggregate function that expresses the loop body is automatically constructed according to a contract. An aggregate class comprising aggregation methods of the contract are used to construct the aggregate function based on results of static analysis. The select query is automatically rewritten to form a declarative SQL query that invokes the custom aggregate function. The declarative SQL query may be executed by a database management system (DBMS) SQL server.

Abstract: Methods and systems are provided for converting a loop (e.g., a cursor loop) to a declarative Structured Query Language (SQL) query that invokes a custom aggregate function. The loop includes a select query and a loop body that includes a program fragment that can be evaluated over a result set of the select query one row at a time. The system verifies that the loop body does not modify a persistent state of the database. A custom aggregate function that expresses the loop body is automatically constructed according to a contract. An aggregate class comprising aggregation methods of the contract are used to construct the aggregate function based on results of static analysis. The select query is automatically rewritten to form a declarative SQL query that invokes the custom aggregate function. The declarative SQL query may be executed by a database management system (DBMS) SQL server.

Abstract: Methods and systems are provided for converting a loop (e.g., a cursor loop) to a declarative Structured Query Language (SQL) query that invokes a custom aggregate function. The loop includes a select query and a loop body that includes a program fragment that can be evaluated over a result set of the select query one row at a time. The system verifies that the loop body does not modify a persistent state of the database. A custom aggregate function that expresses the loop body is automatically constructed according to a contract. An aggregate class comprising aggregation methods of the contract are used to construct the aggregate function based on results of static analysis. The select query is automatically rewritten to form a declarative SQL query that invokes the custom aggregate function. The declarative SQL query may be executed by a database management system (DBMS) SQL server.

Abstract: An online reservation system is configured to receive requests from a guest for searching property listings and to return property listings that satisfy the search criteria of the requests. The online reservation system also tracks interactions of the guest with the returned property listings in order to determine which of the property listings are of interest to the guest, and the system may determine one or more guest preference parameters indicative of the guest's preferences based on such interactions. Thereafter, when the guest submits another search request, the system sorts the search results based on the guest preference parameters so that the property listings deemed more likely to be of interest to the guest are ranked higher (e.g., listed first), thereby helping the guest to more quickly find property listings of interest within the search results.

Abstract: Listings and reviews of listings can be processed to identify descriptive attributes for locations associated with the listings. To do this, a corpus of words is generated for various locations based on listings in the locations and reviews of those listings. An expected frequency, and per-location frequency for each word is determined. These numbers are in turn used to determine a number of high frequency listing locations, and a number of below expected frequency listing locations for each word. Based on a comparison of the number of high frequency listing locations and the number of below expected frequency listing locations of a word with an attribute reference number, the word can be identified either as an attribute that is likely descriptive of the location, or not.

Abstract: Listings and reviews of listings can be processed to identify descriptive attributes for locations associated with the listings. To do this, a corpus of words is generated for various locations based on listings in the locations and reviews of those listings. An expected frequency, and per-location frequency for each word is determined. These numbers are in turn used to determine a number of high frequency listing locations, and a number of below expected frequency listing locations for each word. Based on a comparison of the number of high frequency listing locations and the number of below expected frequency listing locations of a word with an attribute reference number, the word can be identified either as an attribute that is likely descriptive of the location, or not.

Abstract: An online booking system allows users to search and book listings of goods or services. When a user searches for listings, the listings are ranked and scored based on a number of factors including the location and the price of the listing, the number and quality of reviews and the number of successful prior bookings. In some situations, the listing scores overly skew the top ranking results to a particular region. The listing scores may be modified to address this skewing of results. When diversity in search results is desired, the listing scores are modified such that the top ranking results that are located in a diverse set of regions. When granular relevance of search results is desired, the listing scores are modified such that the top ranking results are located in regions that are more relevant to the search than the region to which the results are skewed.

Abstract: An online booking system allows users to search and book listings of goods or services. When a user searches for listings, the listings are ranked and scored based on a number of factors including the location and the price of the listing, the number and quality of reviews and the number of successful prior bookings. In some situations, the listing scores overly skew the top ranking results to a particular region. The listing scores may be modified to address this skewing of results. When diversity in search results is desired, the listing scores are modified such that the top ranking results that are located in a diverse set of regions. When granular relevance of search results is desired, the listing scores are modified such that the top ranking results are located in regions that are more relevant to the search than the region to which the results are skewed.

Abstract: An online reservation system is configured to receive requests from a guest for searching property listings and to return property listings that satisfy the search criteria of the requests. The online reservation system also tracks interactions of the guest with the returned property listings in order to determine which of the property listings are of interest to the guest, and the system may determine one or more guest preference parameters indicative of the guest's preferences based on such interactions. Thereafter, when the guest submits another search request, the system sorts the search results based on the guest preference parameters so that the property listings deemed more likely to be of interest to the guest are ranked higher (e.g., listed first), thereby helping the guest to more quickly find property listings of interest within the search results.

Abstract: Provided is a water vapor adsorption-desorption material in which a substance having a LCST is uniformly retained inside pores of a mesoporous body, which can reduce energy required for regeneration, and a method for measuring LCST behavior capable of measuring LCST behavior of an ionic liquid used in the water vapor adsorption-desorption material without errors. The water vapor adsorption-desorption material includes a mesoporous body and an ionic liquid retained inside pores of the mesoporous body, the ionic liquid exhibiting LCST behavior, and the method for measuring LCST behavior of an ionic liquid used for a water vapor adsorption-desorption material, the method including detecting a change of hydration/dehydration state of a mixture of the ionic liquid and water as electric signals, by means of AC impedance measurement.

Abstract: Listings and reviews of listings can be processed to identify descriptive attributes for locations associated with the listings. To do this, a corpus of words is generated for various locations based on listings in the locations and reviews of those listings. An expected frequency, and per-location frequency for each word is determined. These numbers are in turn used to determine a number of high frequency listing locations, and a number of below expected frequency listing locations for each word. Based on a comparison of the number of high frequency listing locations and the number of below expected frequency listing locations of a word with an attribute reference number, the word can be identified either as an attribute that is likely descriptive of the location, or not.

Abstract: An online booking system allows users to search and book listings of goods or services. When a user searches for listings, the listings are ranked and scored based on a number of factors including the location and the price of the listing, the number and quality of reviews and the number of successful prior bookings. In some situations, the listing scores overly skew the top ranking results to a particular region. The listing scores may be modified to address this skewing of results. When diversity in search results is desired, the listing scores are modified such that the top ranking results that are located in a diverse set of regions. When granular relevance of search results is desired, the listing scores are modified such that the top ranking results are located in regions that are more relevant to the search than the region to which the results are skewed.

Abstract: Methods, systems, and apparatus, including computer programs encoded on computer storage media, for generating tasks from user observations. One of the methods includes segmenting a plurality of observations associated with a user of a user device into a plurality of tasks previously engaged in by the user; and generating a respective task presentation for each of the plurality of tasks for presentation to the user.

Abstract: Methods, systems, and apparatus, including computer programs encoded on computer storage media, for generating tasks from user observations. One of the methods includes segmenting a plurality of observations associated with a user of a user device into a plurality of tasks previously engaged in by the user; and generating a respective task presentation for each of the plurality of tasks for presentation to the user.

Abstract: Methods, systems, and apparatus, including computer programs encoded on a computer storage medium, for determining resource attributes from site address attributes. In one aspect, a method includes resource attributes of resources addressed by the resource locator and address attributes of the resource locators, determining a set of similar resource locators from the address attributes of the resource locators, comparing the address attributes of the resource locators in the set of similar resource locators to the resource attributes of the resources addressed by the resource locators in the set of similar resource locators, and determining, based on the comparison, likelihoods that the address attribute of the resource locators in the set of similar resource locators indicates resource attributes of the resources.

Abstract: Methods, systems, and apparatus, including computer programs encoded on a computer storage medium, for processing locations and distances related to resources referenced in search results. Location data for an entity are processed to determine physical locations of an entity. The physical locations are used to generate a coverage area data, and the location data and coverage area data are associated with Internet resources of the entity. The coverage area data and location data are used to filter search results and adjust the rank of individual search results that are responsive to a query associated with a query location.

Abstract: Providing for browsing a summary of content formed of keywords that can scale to a user-defined level of detail is disclosed herein. Components of a system can include a summarization component that extracts keywords related to the content and associates the keywords with portions thereof, and a zooming component that displays a number of keywords based on a keyword/keyphrase relevance rank and a zoom factor. Additionally, a speech to text component can translate speech associated with the content into text, wherein the keywords are extracted from the translated text. Consequently, the claimed subject matter can present a variable hierarchy of keywords to form a scalable summary of such recorded content.