Problem solving in a database
    1.
    发明授权

    公开(公告)号:US12086135B2

    公开(公告)日:2024-09-10

    申请号:US17477801

    申请日:2021-09-17

    CPC classification number: G06F16/24524 G06F11/1471 G06F11/3409 G06F16/21

    Abstract: A method includes receiving, by a computing device, a Structured Query Language (SQL) query from a user; generating, by the computing device, execution structures from the SQL query; generating, by the computing device, test results by running the SQL query with the execution structures; building, by the computing device, logs which record information of the running of the SQL query; generating, by the computing device, a candidate execution structure using the information from the logs; normalizing, by the computing device, the SQL query using the candidate execution structure; running, by the computing device, the normalized SQL query in a database; and comparing, by the computing device, results of the normalized SQL query to the test results.

    Rolling upgrades in disaggregated systems

    公开(公告)号:US10970061B2

    公开(公告)日:2021-04-06

    申请号:US16660676

    申请日:2019-10-22

    Abstract: Embodiments for performing rolling software upgrades in a disaggregated computing environment. A rolling upgrade manager is provided for upgrading one or more disaggregated servers. A designated memory area is used for storing an updated software component, and a disaggregated server is switched to the designated memory area from a currently assigned memory area when performing the software upgrade. A process state and program data is maintained in the currently assigned memory area while maintaining the updated software component in the designated memory area such that the process state and program data are read from the currently assigned memory area and the updated software component is read from the designated memory area during currently executing operations of the disaggregated server.

    Managing software licenses in a disaggregated environment

    公开(公告)号:US10701141B2

    公开(公告)日:2020-06-30

    申请号:US15199543

    申请日:2016-06-30

    Abstract: Server resources in a data center are disaggregated into shared server resource pools. Servers are constructed dynamically, on-demand and based on a tenant's workload requirements, by allocating from these resource pools. The system also includes a license manager that operates to manage a pool of licenses that are available to be associated with resources drawn from the server resource pools. Upon provisioning of a server entity composed of resources drawn from the server resource pools, the license manager determines a license configuration suitable for the server entity. In response to receipt of information indicating a change in a composition of the server entity (e.g., as a workload is processed), the license manager determines whether an adjustment to the license configuration is required. If so, an adjusted license configuration for the server entity is determined and tracked to the tenant. The data center thus allocates appropriate licenses to server entities as required.

    Dynamic cache management for in-memory data analytic platforms

    公开(公告)号:US10467152B2

    公开(公告)日:2019-11-05

    申请号:US15157637

    申请日:2016-05-18

    Abstract: At a cache manager of a directed acyclic graph-based data analytic platform, from each of a plurality of monitor components on a plurality of worker nodes, statistics are obtained for a plurality of tasks, including which of the tasks have been processed and which are in a task queue. Each of the tasks has at least one associated distributed dataset. Each worker has a distributed dataset cache. A current stage directed acyclic graph is obtained from a directed acyclic graph scheduler component. For a given one of the tasks which has been processed, and for which it is determined that no other ones of the tasks depend on the at least one distributed dataset associated with the given one of the tasks, the distributed dataset is evicted from a corresponding one of the distributed dataset caches.

    Recipe selection system with bidirectional calendar interface

    公开(公告)号:US10262302B2

    公开(公告)日:2019-04-16

    申请号:US14923470

    申请日:2015-10-27

    Abstract: Recommending a recipe and monitoring the preparation of the recipe according to a calendar by a computer that receives calendar data that includes one or more of: a date, scheduled appointment times for the date and appointment durations, any special events on the date, and proximity of the date to a holiday. The computer identifies one or more recipes that can be prepared in an available time slot in the calendar, the one or more recipes includes a list of food from a food ingredient list and monitors data, including length of time to complete a preparation step of the selected recipe. Responsive to the length of time increasing by more than a threshold value, the computer adjusts one or more subsequent preparation steps of the selected recipe to compensate for the increase to the length of time and/or the calendar to provide a longer available time for recipe preparation.

Patent Agency Ranking