PROCESSING QUERY OF DATABASE AND DATA STREAM

    公开(公告)号:US20170235779A1

    公开(公告)日:2017-08-17

    申请号:US15503482

    申请日:2014-09-30

    Abstract: Example implementations relate to processing a query of a database and a data stream. For example, a computing device may include a processor. The processor may receive a query associated with at least one of a database and a buffer storing streamed data from a data stream. The database may store database data previously stored in the buffer. The processor may identify a range associated with the query and generate a set of sub-queries including at least one of a buffer sub-query if the range is associated with the streamed data in the buffer and a database sub-query if the range is associated with the database data in the database. The processor may process the set of sub-queries and provide a query result of the query, where the query result is a combination of sub-query results of the set of sub-queries.

    AUTOMATIC GENERATION OF SUB-QUERIES
    2.
    发明申请

    公开(公告)号:US20170161323A1

    公开(公告)日:2017-06-08

    申请号:US15310120

    申请日:2014-06-30

    Abstract: Example implementations relate to automatic generation of sub-queries. For example, a computing device may include a processor. The processor may receive a query defining a particular set of data stored in at least one database. The processor may access metadata associated with the particular set of data and may select a data attribute associated with the particular set of data based on the metadata. The processor may automatically generate sub-queries of the query using the data attribute selected based on the metadata. The processor may process the sub-queries and provide a query result of the query that is a combination of sub-query results of the sub-queries.

    DATABASE AND DATA STREAM QUERY
    3.
    发明申请

    公开(公告)号:US20170270166A1

    公开(公告)日:2017-09-21

    申请号:US15503762

    申请日:2014-09-30

    Abstract: Example implementations relate to a database and a data stream query. For example, a computing device may include a processor. The processor may receive a query associated with at least one of a database and a buffer storing streamed data from a data stream, where the database stores database data previously stored in the buffer. The processor may identify at least one postponed command relevant to the query, the at least one postponed command being associated with at least one of the database data and the streamed data. The processor may generate a modified query based on the query and the at least one postponed command, the modified query being a modification of the query to account for the at least one postponed command. The processor may process the modified query and provide a query result of the query based on the modified query being processed.

    CANDIDATE SERVICES FOR AN APPLICATION
    5.
    发明申请
    CANDIDATE SERVICES FOR AN APPLICATION 审中-公开
    申请的候选服务

    公开(公告)号:US20170017655A1

    公开(公告)日:2017-01-19

    申请号:US15114134

    申请日:2014-03-31

    Abstract: Methods, apparatus, systems and articles of manufacture are disclosed to provide candidate services for an application. An example method includes determining a plurality of candidate services for a cloud application, determining an indication that a first candidate service from the plurality of candidate services is more relevant to the cloud application than a second candidate service based on a first prediction score corresponding to the first candidate service and a second prediction score corresponding to the second candidate service; presenting the first candidate service and the second candidate service to a user based on the first prediction score and the second prediction score; and adjusting a first weight corresponding to the first candidate service and a second weight corresponding to the second candidate service based on whether the first candidate service or the second candidate service is selected for inclusion in the cloud application.

    Abstract translation: 公开了方法,装置,系统和制品以提供应用的候选服务。 一种示例性方法包括:确定用于云应用的多个候选服务,基于与第二候选服务相对应的第一预测分数,确定来自多个候选服务的第一候选服务与第二候选服务相比更适合于云应用的指示 第一候选服务和对应于第二候选服务的第二预测分数; 基于第一预测分数和第二预测分数向用户呈现第一候选服务和第二候选服务; 以及基于所述第一候选服务或所述第二候选服务是否被选择以包括在所述云应用中,来调整对应于所述第一候选服务的第一权重和对应于所述第二候选服务的第二权重。

    Database and data stream query
    7.
    发明授权

    公开(公告)号:US11074264B2

    公开(公告)日:2021-07-27

    申请号:US16400527

    申请日:2019-05-01

    Abstract: Example implementations relate to a database and a data stream query. For example, a computing device may include a processor. The processor may receive a query associated with at least one of a database and a buffer storing streamed data from a data stream, where the database stores database data previously stored in the buffer. The processor may identify at least one postponed command relevant to the query, the at least one postponed command being associated with at least one of the database data and the streamed data. The processor may generate a modified query based on the query and the at least one postponed command, the modified query being a modification of the query to account for the at least one postponed command. The processor may process the modified query and provide a query result of the query based on the modified query being processed.

    DISCARDING DATA POINTS IN A TIME SERIES
    9.
    发明申请
    DISCARDING DATA POINTS IN A TIME SERIES 审中-公开
    在时间序列中划分数据点

    公开(公告)号:US20160292233A1

    公开(公告)日:2016-10-06

    申请号:US15034369

    申请日:2013-12-20

    CPC classification number: G06F16/2477 G06F16/215 G06F16/24578

    Abstract: Described herein are techniques for determining which data points in a time series to discard. A time series may include multiple data points. Spaced intervals over the time series may be determined. The data points can be ranked at least in part based on their respective distance from a nearest spaced interval. A data point may be discarded based on the ranking.

    Abstract translation: 这里描述的是用于确定要丢弃的时间序列中的哪些数据点的技术。 时间序列可以包括多个数据点。 可以确定时间序列上的间隔间隔。 数据点可以至少部分地基于它们与最近的间隔间隔的相应距离来进行排名。 可以基于排名丢弃数据点。

    PREDICTING EXECUTION TIMES OF CONCURRENT QUERIES
    10.
    发明申请
    PREDICTING EXECUTION TIMES OF CONCURRENT QUERIES 审中-公开
    预测相关问题的执行时间

    公开(公告)号:US20160203404A1

    公开(公告)日:2016-07-14

    申请号:US14917074

    申请日:2013-09-14

    CPC classification number: G06N5/04 G06F16/24532 G06N20/00

    Abstract: Example embodiments relate to predicting execution times of concurrent queries. In example embodiments, historical data is iteratively generated for a machine learning model by varying a concurrency level of query executions in a database, determining a query execution plan for a pending concurrent query, extracting query features from the query execution plan, and executing the pending concurrent query to determine a query execution time. The machine learning model may then be created based on the query features, variation in the concurrency level, and the query execution time. The machine learning model is used to generate an execution schedule for production queries, where the execution schedule satisfies service level agreements of the production queries.

    Abstract translation: 示例实施例涉及预测并发查询的执行时间。 在示例实施例中,通过改变数据库中的查询执行的并发级别,确定待执行的并发查询的查询执行计划,从查询执行计划中提取查询特征以及执行待处理的查询执行计划,迭代地为机器学习模型生成历史数据 并发查询确定查询执行时间。 然后可以基于查询特征,并发级别的变化和查询执行时间来创建机器学习模型。 机器学习模型用于生成生产查询的执行计划,其中执行计划满足生产查询的服务级别协议。

Patent Agency Ranking