专利快速检索-快速检索全球专利，免费商用专利数据库-IPRDB

1. 发明授权

US08799489B2 Multi-user system with dynamic data source selection 有权
标题翻译：具有动态数据源选择的多用户系统
公开(公告)号：US08799489B2
公开(公告)日：2014-08-05
申请号：US10186328
申请日：2002-06-27
申请人： Edward Shaw-Lee Suen , Sunil Prabhakar Dixit
发明人： Edward Shaw-Lee Suen , Sunil Prabhakar Dixit
IPC分类号： G06F15/16
CPC分类号： G06F17/30522
摘要： Techniques to dynamically select data sources for users and to direct queries for the users to the proper data sources. Initially, user information (e.g., user name) for each user is received and used to determine a data source designated for the user. The designated data source may be determined via a look-up table or by running a query with the user information to obtain the identity (e.g., the logical name) of the data source. A data source variable for each user can then be set to the identity of the designated data source. Thereafter, queries for each user are directed to the user's designated data source by determining database connection information for the designated data source based on the data source variable and using this information to direct the queries.
摘要翻译：为用户动态选择数据源的技术，并将用户的查询引导到正确的数据源。最初，接收每个用户的用户信息（例如，用户名），并用于确定为用户指定的数据源。指定的数据源可以通过查找表来确定，或者通过运行具有用户信息的查询来获得数据源的身份（例如，逻辑名称）。然后可以将每个用户的数据源变量设置为指定数据源的标识。此后，通过基于数据源变量确定指定数据源的数据库连接信息并使用该信息来指导查询，将针对每个用户的查询定向到用户的指定数据源。

2. 发明授权

US07634397B2 Single server instance, multi-lingual applications based on loosely coupled metadata and presentation layers 有权
标题翻译：单服务器实例，基于松散耦合的元数据和表示层的多语言应用程序
公开(公告)号：US07634397B2
公开(公告)日：2009-12-15
申请号：US10186345
申请日：2002-06-27
申请人： Edward Shaw-Lee Suen , Sunil Prabhakar Dixit , James P. Rogers , Samar Abbas Lotia , Eric Alan Musser
发明人： Edward Shaw-Lee Suen , Sunil Prabhakar Dixit , James P. Rogers , Samar Abbas Lotia , Eric Alan Musser
IPC分类号： G06F17/20 , G06F17/28
CPC分类号： G06F9/454
摘要： Techniques to provide dynamic multi-lingual support for software applications such as analytics, which typically rely on two different types of data, underlying data and metadata, to generate reports. The metadata defines the underlying data and a presentation layer displays the reports, which may be generated using presentation and metadata layer objects. Each such object may be defined by a language independent representation, which may in turn be associated with multiple display or language dependent representations (i.e., translations or translated strings) for multiple supported languages. One of the languages may be selected for use in a given session, and the display representations for the selected language are then bound to the language independent representations. The binding may be dynamically performed and is session-specific.
摘要翻译：为诸如分析的软件应用提供动态多语言支持的技术，分析通常依赖于两种不同类型的数据，底层数据和元数据来生成报告。元数据定义底层数据，表示层显示可以使用表示和元数据层对象生成的报告。每个这样的对象可以由独立于语言的表示来定义，其可以依次与多个支持的语言的多个显示或语言依赖表示（即，翻译或翻译的字符串）相关联。可以选择其中一种语言在给定的会话中使用，并且所选择的语言的显示表示然后被绑定到与语言无关的表示。可以动态地执行绑定并且是会话特定的。

3. 发明授权

US07707144B2 Optimization for aggregate navigation for distinct count metrics 有权
标题翻译：不同计数指标的汇总导览优化
公开(公告)号：US07707144B2
公开(公告)日：2010-04-27
申请号：US10994905
申请日：2004-11-22
申请人： Ashish Mittal , Edward Shaw-Lee Suen
发明人： Ashish Mittal , Edward Shaw-Lee Suen
IPC分类号： G06F17/30
CPC分类号： G06F17/30457 , G06F17/30489 , Y10S707/99933
摘要： A method and apparatus for performing a distinct count metric by utilizing aggregate navigation. For a distinct count query of an identifier of a detail table, where the query specifies zero or more restrictions, an aggregate table associated with the detail table is identified. It is then determined whether the aggregate table contains the identifier that is being distinct counted, and if so, whether the identifier is different in every row of the aggregate table. If it is, then the rows of the aggregate table that satisfy the specified restrictions are plain counted to obtain a result for the distinct count query. If the identifier is not different in every row of the aggregate table, a distinct count operation is performed on the rows of the aggregate table that satisfy the specified restrictions to obtain a result for the distinct count query.
摘要翻译：一种通过利用聚合导航来执行不同计数度量的方法和装置。对于详细表的标识符的不同计数查询，其中查询指定零个或多个限制，则识别与详细表相关联的聚合表。然后确定聚合表是否包含不同的计数的标识符，如果是，则标识符在聚合表的每一行中是否不同。如果是，那么满足指定限制的聚合表的行被简单地计数，以获得不同的计数查询的结果。如果标识符在聚合表的每一行中都不相同，则对满足指定限制的聚合表的行执行不同的计数操作，以获取不同计数查询的结果。

4. 发明授权

US07499910B2 Detecting and processing cache hits for queries with aggregates 有权
标题翻译：检测和处理具有聚合的查询的缓存命中
公开(公告)号：US07499910B2
公开(公告)日：2009-03-03
申请号：US10186344
申请日：2002-06-27
申请人： Donovan Alfred Schneider , Edward Shaw-Lee Suen , Kazi Atif-Uz Zaman
发明人： Donovan Alfred Schneider , Edward Shaw-Lee Suen , Kazi Atif-Uz Zaman
IPC分类号： G06F17/30
CPC分类号： G06F17/30483 , Y10S707/99932 , Y10S707/99933 , Y10S707/99934 , Y10S707/99935 , Y10S707/99936
摘要： Techniques to improve query caching performance by efficiently selecting queries stored in a cache for evaluation and increasing the cache hit rate by allowing for inexact matches. A list of candidate queries stored in the cache that potentially could be used to answer a new query is first determined. This list may include all cached queries, cached queries containing exact matches for select list items, or cached queries containing exact and/or inexact matches. Each of at least one candidate query is then evaluated to determine whether or not there is a cache hit, which indicates that the candidate query could be used to answer the new query. The evaluation is performed using a set of rules that allows for inexact matches of aggregates, if any, in the new query. A query plan is generated for the new query based on a specific candidate query with a cache hit.
摘要翻译：通过有效地选择存储在缓存中的查询来进行评估来提高查询缓存性能的技术，通过允许不精确的匹配来提高缓存命中率。首先确定存储在缓存中的潜在可能用于回答新查询的候选查询的列表。此列表可能包括所有缓存的查询，包含精选列表项的精确匹配的缓存查询，或包含精确和/或不精确匹配的缓存查询。然后评估至少一个候选查询中的每一个以确定是否存在高速缓存命中，其指示候选查询可以用于回答新查询。评估是使用一组规则执行的，这些规则允许在新查询中聚合的不精确匹配（如果有）。基于具有高速缓存命中的特定候选查询，为新查询生成查询计划。

5. 发明授权

US09563662B2 Detecting and processing cache hits for queries with aggregates 有权
标题翻译：检测和处理具有聚合的查询的缓存命中
公开(公告)号：US09563662B2
公开(公告)日：2017-02-07
申请号：US11931947
申请日：2007-10-31
申请人： Donovan Alfred Schneider , Edward Shaw-Lee Suen , Kazi Atif-Uz Zaman
发明人： Donovan Alfred Schneider , Edward Shaw-Lee Suen , Kazi Atif-Uz Zaman
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30483 , Y10S707/99932 , Y10S707/99933 , Y10S707/99934 , Y10S707/99935 , Y10S707/99936
摘要： Techniques to improve query caching performance by efficiently selecting queries stored in a cache for evaluation and increasing the cache hit rate by allowing for inexact matches. A list of candidate queries stored in the cache that potentially could be used to answer a new query is first determined. This list may include all cached queries, cached queries containing exact matches for select list items, or cached queries containing exact and/or inexact matches. Each of at least one candidate query is then evaluated to determine whether or not there is a cache hit, which indicates that the candidate query could be used to answer the new query. The evaluation is performed using a set of rules that allows for inexact matches of aggregates, if any, in the new query. A query plan is generated for the new query based on a specific candidate query with a cache hit.
摘要翻译：通过有效地选择存储在缓存中的查询来进行评估来提高查询缓存性能的技术，通过允许不精确的匹配来提高缓存命中率。首先确定存储在缓存中的潜在可能用于回答新查询的候选查询的列表。此列表可能包括所有缓存的查询，包含精选列表项的精确匹配的缓存查询，或包含精确和/或不精确匹配的缓存查询。然后评估至少一个候选查询中的每一个以确定是否存在高速缓存命中，其指示候选查询可以用于回答新查询。评估是使用一组规则执行的，这些规则允许在新查询中聚合的不精确匹配（如果有）。基于具有高速缓存命中的特定候选查询，为新查询生成查询计划。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式