-
公开(公告)号：US09292571B1
公开(公告)日：2016-03-22
申请号：US13745534
申请日：2013-01-18
发明人： Yuliyan Kiryakov , Benjamin Z. Li , Rixin Liao
CPC分类号： G06F17/30454 , G06F17/30442 , G06F17/30466 , G06F17/3048 , G06F17/30498 , G06F17/30595
摘要： In one implementation, a query is received that is related to data stored in a database that is implemented in computer memory. Based on the received query, attributes of data stored in the database that are relevant to generating a response to the received query are identified. Information that is indicative of attributes for which values are recorded in different tables included in the database is accessed. Based on having accessed this information, tables included in the database that record values for the attributes identified as being relevant to generating a response to the received query are identified. These tables then are joined to create, within computer memory, a new table that reflects relationships between values of attributes identified as being relevant to generating a response to the received query.
摘要翻译： 在一个实现中，接收到与存储在计算机存储器中实现的数据库中的数据有关的查询。 基于接收的查询，识别存储在数据库中与产生对接收到的查询的响应相关的数据的属性。 访问指示数据记录在数据库中包括的不同表中的属性的信息。 基于访问了该信息，识别数据库中记录被识别为与产生对接收到的查询的响应相关的属性的值的表。 然后，这些表被连接以在计算机存储器内创建一个新表，其反映被识别为与生成对所接收的查询的响应相关的属性的值之间的关系。
-
公开(公告)号：US09454594B2
公开(公告)日：2016-09-27
申请号：US14331170
申请日：2014-07-14
发明人： Scott Cappiello , Xun Feng , Yuliyan Kiryakov , Jun Yuan
IPC分类号： G06F17/30
CPC分类号： G06F17/30592 , G06F17/30457
摘要： Dynamic sourcing, in which a data request that is associated with a query is received and a parameter of data needed for satisfaction of the query is identified. Parameter information defining data available in at least one cube stored in a cache is accessed and the parameter is compared with the parameter information. Based on comparison results, it is determined whether one or more cubes in the cache include sufficient data to satisfy the query. In response to a determination that one or more cubes include sufficient data to satisfy the query, a response to the data request is generated by executing the query against the one or more cubes. In response to a determination that the cubes do not include sufficient data to satisfy the query, a response to the data request is generated by executing at least a portion of the query against a database system.
摘要翻译： 动态采购，其中接收到与查询相关联的数据请求，并且识别满足查询所需的数据参数。 访问定义存储在高速缓存中的至少一个立方体中可用的数据的参数信息，并将参数与参数信息进行比较。 基于比较结果，确定高速缓存中的一个或多个立方体是否包含足以满足查询的数据。 响应于确定一个或多个立方体包括足够的数据以满足查询，通过针对一个或多个立方体执行查询来生成对数据请求的响应。 响应于确定立方体不包括足够的数据以满足查询，通过针对数据库系统执行查询的至少一部分来生成对数据请求的响应。
-
3.发明授权公开(公告)号：US11995082B2
公开(公告)日：2024-05-28
申请号：US17453672
申请日：2021-11-05
发明人： Yinong Chen , Shiliang Wang , Yuliyan Kiryakov , Ananya Ojha
IPC分类号： G06F16/24 , G06F16/2453 , G06F16/901 , G06N20/00
CPC分类号： G06F16/24542 , G06F16/9017 , G06N20/00
摘要： Disclosed are methods, systems, and computer-readable medium for providing query results. The query results may be provided more accurately and faster than via distributed tables. Disclosed techniques include receiving a plurality of tables comprising attributes and attribute data, the attribute data comprising attribute forms and attribute related information, identifying attributes and corresponding attribute data from each of the plurality of tables, applying a categorization machine learning model to categorize each attribute data as an attribute form or an attribute related information, generating the lookup table based on the attributes and the corresponding attribute forms, generating the relationship table based on the attributes and the corresponding attribute related information, receiving a query for attribute data, and generating a query response based on at least one of the lookup table or the relationship table.
-
公开(公告)号：US20140324768A1
公开(公告)日：2014-10-30
申请号：US14331170
申请日：2014-07-14
发明人： Scott Cappiello , Xun Feng , Yuliyan Kiryakov , Jun Yuan
IPC分类号： G06F17/30
CPC分类号： G06F17/30592 , G06F17/30457
摘要： Dynamic sourcing, in which a data request that is associated with a query is received and a parameter of data needed for satisfaction of the query is identified. Parameter information defining data available in at least one cube stored in a cache is accessed and the parameter is compared with the parameter information. Based on comparison results, it is determined whether one or more cubes in the cache include sufficient data to satisfy the query. In response to a determination that one or more cubes include sufficient data to satisfy the query, a response to the data request is generated by executing the query against the one or more cubes. In response to a determination that the cubes do not include sufficient data to satisfy the query, a response to the data request is generated by executing at least a portion of the query against a database system.
摘要翻译： 动态采购，其中接收到与查询相关联的数据请求，并且识别满足查询所需的数据参数。 访问定义存储在高速缓存中的至少一个立方体中可用的数据的参数信息，并将参数与参数信息进行比较。 基于比较结果，确定高速缓存中的一个或多个立方体是否包含足以满足查询的数据。 响应于确定一个或多个立方体包括足够的数据以满足查询，通过针对一个或多个立方体执行查询来生成对数据请求的响应。 响应于确定立方体不包括足够的数据以满足查询，通过针对数据库系统执行查询的至少一部分来生成对数据请求的响应。
-
公开(公告)号：US12008020B2
公开(公告)日：2024-06-11
申请号：US17384857
申请日：2021-07-26
发明人： Yuliyan Kiryakov , Bingbing Ji , Ananya Ojha
CPC分类号： G06F16/283 , G06F16/2264 , G06F16/24552 , G06F16/254 , G06N5/04 , G06N20/00
摘要： Disclosed are methods, systems, and computer-readable medium for providing report results. Viscous attributes and non-viscous may be identified. A smart cube may be received and may include viscous values for the viscous attributes. The smart cube may be stored at a local cache. A report associated with an organization may be initiated. A runtime generation of the report may be generated based on initiating the report. The report may call a viscous attribute from the viscous attributes and call a non-viscous attribute from the non-viscous attributes. The runtime generation may be modified to remove the viscous attribute from the runtime generation. A viscous value for the viscous attribute may be retrieved from the smart cube at the local cache. The modified runtime generation may be executed to retrieve a non-viscous value for the non-viscous attribute from a remote database and a report result may be provided.
-
公开(公告)号：US09875277B1
公开(公告)日：2018-01-23
申请号：US15075385
申请日：2016-03-21
发明人： Yuliyan Kiryakov , Benjamin Z. Li , Rixin Liao
CPC分类号： G06F17/30454 , G06F17/30442 , G06F17/30466 , G06F17/3048 , G06F17/30498 , G06F17/30595
摘要： In one implementation, a query is received that is related to data stored in a database that is implemented in computer memory. Based on the received query, attributes of data stored in the database that are relevant to generating a response to the received query are identified. Information that is indicative of attributes for which values are recorded in different tables included in the database is accessed. Based on having accessed this information, tables included in the database that record values for the attributes identified as being relevant to generating a response to the received query are identified. These tables then are joined to create, within computer memory, a new table that reflects relationships between values of attributes identified as being relevant to generating a response to the received query.
-
-
-
-
-
搜索结果
6 条记录 (耗时 0.014 秒)
