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

1. 发明授权

US08606813B1 System and method for function selection in analytic processing 有权
标题翻译：分析处理中功能选择的系统和方法
公开(公告)号：US08606813B1
公开(公告)日：2013-12-10
申请号：US10043263
申请日：2002-01-14
申请人： Jeffrey A. Bedell , Benjamin Z. Li , Fabrice Martin , Sadanand Sahasrabudhe , Jun Yuan , Xinyi Wang
发明人： Jeffrey A. Bedell , Benjamin Z. Li , Fabrice Martin , Sadanand Sahasrabudhe , Jun Yuan , Xinyi Wang
IPC分类号： G06F17/30
CPC分类号： G06F17/30545
摘要： A selection engine for a cooperative processing network, in which databases compute portions of searches and analyses which they may most efficiently compute. A data mining network may contain large scale databases, analytic engines which communicate with the databases, and other resources, each capable of performing or executing certain functions, such as statistical functions. When a user desires to run a specified report against the databases, those functions that can be computed locally in the database are trapped and computed therein, whereas other functions, such as advanced statistical functions, may be distributed to remote analytic engines or other resources in the network. A management module may coordinate the transmission and assembly of the data, including to order dependencies. The management module may contain a selection engine to allocate computations to databases or other resources as a default, to test for load balancing before choosing a compute site, or apply other criteria.
摘要翻译：用于协作处理网络的选择引擎，其中数据库计算搜索和分析的部分，哪些可以最有效地计算。数据挖掘网络可能包含大型数据库，与数据库通信的分析引擎，以及其他能够执行或执行某些功能（如统计功能）的资源。当用户希望针对数据库运行指定的报告时，可以在数据库中本地计算的那些功能被捕获和计算，而诸如高级统计功能的其他功能可以分发到远程分析引擎或其他资源网络。管理模块可以协调数据的传输和组装，包括订单依赖性。管理模块可以包含选择引擎以将计算分配给数据库或其他资源作为默认值，以在选择计算站点之前测试负载平衡或应用其他标准。

2. 发明授权

US06820073B1 System and method for multiple pass cooperative processing 有权
标题翻译：多通道协同处理系统和方法
公开(公告)号：US06820073B1
公开(公告)日：2004-11-16
申请号：US10101488
申请日：2002-03-20
申请人： Jeffrey A. Bedell , William Hurwood , Benjamin Z. Li , Sadanand Sahasrabudhe , Xinyi Wang , Jun Yuan
发明人： Jeffrey A. Bedell , William Hurwood , Benjamin Z. Li , Sadanand Sahasrabudhe , Xinyi Wang , Jun Yuan
IPC分类号： G06F1730
CPC分类号： G06F17/30286 , Y10S707/954 , Y10S707/99932 , Y10S707/99933 , Y10S707/99934
摘要： A system for collaborative processing, comprising a controlling module with access to at least one relational database capable of performing a first set of functions on the data in the database and at least one external analytical engine, the external analytical engine being external to the relational database and being capable of a second set of functions on the data in the database. The controlling module is capable of iteratively processing a multi-step calculation including generating SQL statements to the relational database, passing preliminary results to an external analytical engine and saving data back into the relational database for further processing until the multi-step calculation is performed.
摘要翻译：一种用于协同处理的系统，包括控制模块，该控制模块可访问至少一个能够对数据库中的数据执行第一组功能的关系数据库和至少一个外部分析引擎，所述外部分析引擎在关系数据库外部并且能够对数据库中的数据进行第二组功能。控制模块能够迭代处理多步计算，包括生成SQL语句到关系数据库，将初步结果传递给外部分析引擎，并将数据保存回关系数据库进行进一步处理，直到执行多步计算。

3. 发明授权

US07003512B1 System and method for multiple pass cooperative processing 有权
标题翻译：多通道协同处理系统和方法
公开(公告)号：US07003512B1
公开(公告)日：2006-02-21
申请号：US10912174
申请日：2004-08-06
申请人： Jeffrey A. Bedell , William Hurwood , Benjamin Z. Li , Sadanand Sahasrabudhe , Xinyi Wang , Jun Yuan
发明人： Jeffrey A. Bedell , William Hurwood , Benjamin Z. Li , Sadanand Sahasrabudhe , Xinyi Wang , Jun Yuan
IPC分类号： G06F17/30
CPC分类号： G06F17/30595 , G06F17/30592 , G06Q10/10 , Y10S707/99932 , Y10S707/99933 , Y10S707/99934 , Y10S707/99935
摘要： A system for collaborative processing, comprising a controlling module with access to at least one relational database capable of performing a first set of functions on the data in the database and at least one external analytical engine, the external analytical engine being external to the relational database and being capable of a second set of functions on the data in the database. The controlling module is capable of iteratively processing a multi-step calculation including generating SQL statements to the relational database, passing preliminary results to an external analytical engine and saving data back into the relational database for further processing until the multi-step calculation is performed.
摘要翻译：一种用于协同处理的系统，包括控制模块，该控制模块可访问至少一个能够对数据库中的数据执行第一组功能的关系数据库和至少一个外部分析引擎，所述外部分析引擎在关系数据库外部并且能够对数据库中的数据进行第二组功能。控制模块能够迭代处理多步计算，包括生成SQL语句到关系数据库，将初步结果传递给外部分析引擎，并将数据保存回关系数据库进行进一步处理，直到执行多步计算。

4. 发明授权

US08005870B1 System and method for syntax abstraction in query language generation 有权
标题翻译：查询语言生成中语法抽象的系统和方法
公开(公告)号：US08005870B1
公开(公告)日：2011-08-23
申请号：US09883302
申请日：2001-06-19
申请人： Jeffrey A. Bedell , Yinong Chen , Benjamin Z. Li , Fabrice Martin , Sadanand Sahasrabudhe , Jun Yuan
发明人： Jeffrey A. Bedell , Yinong Chen , Benjamin Z. Li , Fabrice Martin , Sadanand Sahasrabudhe , Jun Yuan
IPC分类号： G06F17/30 , G06F17/00
CPC分类号： G06F17/30398
摘要： A system and method for syntax abstraction in query language generation in an online analytical processing system, a business intelligence system, a reporting system, or a data mining system. The system generates one or more query language statements that can be run against one or more data sources to return a desired data result set. The system includes a syntax pattern selector module and a statement assembly module. The syntax pattern selector module selects a syntax pattern corresponding to a desired function and a syntax standard. The statement assembly module populates the syntax pattern with an argument data set associated with the desired data set. The result is the generation of one or more query language statements with the correct function, syntax, and data parameters to return the desired data result set from the data sources. A method and medium having processor readable code therein are also described.
摘要翻译：在线分析处理系统，商业智能系统，报告系统或数据挖掘系统中的查询语言生成中的语法抽象的系统和方法。该系统生成一个或多个可针对一个或多个数据源运行的查询语言语句，以返回所需的数据结果集。该系统包括语法模式选择器模块和语句组合模块。语法模式选择器模块选择与所需功能和语法标准相对应的语法模式。语句组合模块使用与所需数据集相关联的参数数据集填充语法模式。结果是生成具有正确功能，语法和数据参数的一个或多个查询语言语句，以从数据源返回所需的数据结果集。还描述了其中具有处理器可读代码的方法和介质。

5. 发明授权

US07970782B1 Systems and methods for set filtering of data 有权
标题翻译：用于数据过滤的系统和方法
公开(公告)号：US07970782B1
公开(公告)日：2011-06-28
申请号：US10134677
申请日：2002-04-30
申请人： Jeffrey A. Bedell , William Hurwood , Benjamin Z. Li , Fabrice Martin , Sadanand Sahasrabudhe , Jun Yuan
发明人： Jeffrey A. Bedell , William Hurwood , Benjamin Z. Li , Fabrice Martin , Sadanand Sahasrabudhe , Jun Yuan
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30563 , G06F17/30592
摘要： Systems and methods are provided for filtering data in a database using an execution plan. The execution plan has a first processing pass against the database that calculates a filter set using a filter criteria, and a second processing pass against the filter set that calculates a report result.
摘要翻译：提供了系统和方法，用于使用执行计划过滤数据库中的数据。执行计划针对数据库进行第一处理通过，该处理计算使用过滤条件来计算过滤器集合，并针对计算报告结果的过滤器集合进行第二处理通过。

6. 发明授权

US07430562B1 System and method for efficient date retrieval and processing 有权
标题翻译：有效的日期检索和处理的系统和方法
公开(公告)号：US07430562B1
公开(公告)日：2008-09-30
申请号：US09883499
申请日：2001-06-19
申请人： Jeffrey A. Bedell , Michael Codini , William Hurwood , Ashutosh K. Jhaveri , Benjamin Z. Li , Fabrice Martin , Sadanand Sahasrabudhe , Jun Yuan
发明人： Jeffrey A. Bedell , Michael Codini , William Hurwood , Ashutosh K. Jhaveri , Benjamin Z. Li , Fabrice Martin , Sadanand Sahasrabudhe , Jun Yuan
IPC分类号： G06F17/00
CPC分类号： G06F17/30392 , G06F17/30463 , Y10S707/99931 , Y10S707/99932 , Y10S707/99933 , Y10S707/99942 , Y10S707/99943
摘要： A system and method for efficient data retrieval and processing in an online analytical processing system, a reporting system, a business intelligence system, or a data mining system. The system provides for retrieval and processing of a data result set from a plurality of data sources. The system includes a query structure assembly module, a syntax assembly module, and a process optimization module. The query structure assembly module defines a query structure based upon query assembly rules and a desired data set (such as the set of data for a particular OLAP report). The syntax assembly module defines one or more query language statements based upon the defined query structure. The process optimization module evaluates processing options based upon a database schema associated with the data sources. One or more query language statements may be assembled by the system and run against the data sources to return the desired data result set. A method and medium having processor readable code therein are also described.
摘要翻译：一种用于在线分析处理系统，报告系统，商业智能系统或数据挖掘系统中有效数据检索和处理的系统和方法。该系统提供从多个数据源检索和处理数据结果集。该系统包括查询结构组装模块，语法组合模块和过程优化模块。查询结构组合模块基于查询组合规则和所需数据集（例如特定OLAP报告的数据集）定义查询结构。语法汇编模块基于定义的查询结构定义一个或多个查询语言语句。过程优化模块基于与数据源相关联的数据库模式来评估处理选项。系统可以组合一个或多个查询语言语句，并针对数据源运行以返回所需的数据结果集。还描述了其中具有处理器可读代码的方法和介质。

7. 发明授权

US07010518B1 System and method for user defined data object hierarchy 有权
标题翻译：用户定义的数据对象层次结构的系统和方法
公开(公告)号：US07010518B1
公开(公告)日：2006-03-07
申请号：US09884476
申请日：2001-06-20
申请人： Jeffrey A. Bedell , William Hurwood , Benjamin Z. Li , Fabrice Martin , Sadanand Sahasrabudhe , Jun Yuan
发明人： Jeffrey A. Bedell , William Hurwood , Benjamin Z. Li , Fabrice Martin , Sadanand Sahasrabudhe , Jun Yuan
IPC分类号： G06F17/30
CPC分类号： G06F17/30289 , Y10S707/99933 , Y10S707/99944
摘要： The invention provides a configuration tool to allow a user to build a custom-selected data object hierarchy, for business intelligence or other purposes. Under conventional data storage technologies, the physical layout of the disk drive or other media has dictated what logical views and searches a user could run on the underlying data. For instance, levels could not be readily skipped or many-to-many data object relationships were difficult to maintain. In the invention, a user may select and connect a set of data objects into a hierarchy of their choosing, to permit desired reports and other manipulations on the data to be performed. The hierarchy may be edited, and entry points may be defined. Different levels of security may be applied to the different levels of the hierarchy. Multiple hierarchies or representations may be built for one database or other data source.
摘要翻译：本发明提供了一种用于允许用户构建用于商业智能或其他目的的定制选择的数据对象分层结构的配置工具。在传统的数据存储技术下，磁盘驱动器或其他媒体的物理布局决定了用户可以在底层数据上运行哪些逻辑视图和搜索。例如，级别不能轻易跳过，或者很难对数据对象关系进行维护。在本发明中，用户可以将一组数据对象选择并连接到其选择的层级中，以允许对要执行的数据的期望报告和其他操纵。可以编辑层次结构，并且可以定义入口点。可以将不同级别的安全性应用于层次结构的不同层次。可以为一个数据库或其他数据源构建多个层次结构或表示。

8. 发明授权

US06996568B1 System and method for extension of data schema 有权
标题翻译：用于扩展数据模式的系统和方法
公开(公告)号：US06996568B1
公开(公告)日：2006-02-07
申请号：US10120144
申请日：2002-04-11
申请人： Jeffrey A. Bedell , William Hurwood , Benjamin Z. Li , Fabrice Martin , Sadanand Sahasrabudhe , Jun Yuan
发明人： Jeffrey A. Bedell , William Hurwood , Benjamin Z. Li , Fabrice Martin , Sadanand Sahasrabudhe , Jun Yuan
IPC分类号： G06F17/30
CPC分类号： G06F17/30306 , G06F17/30421 , Y10S707/99933 , Y10S707/99943
摘要： A system and method for defining and using logical extensions to a set of data stored in a relational database. A metadata definition for various extensions is stored to explain how to extend data as it is stored into a logical representation suitable for reporting and calculating purposes. An analytical engine translates report requests into SQL queries to access the physically stored data using the metadata extension definitions if necessary to generate appropriate results. Here, data is stored in at least one table that is physically keyed by a set of attributes with the attribute determining the granularity or level of data contained within the tables. A report request causes the engine to calculate and/or display the data at a lower level of granularity than exists, thereby invoking the metadata definitions. The extension definitions may describe how to extend data from the physical to the logical including joins and allocation rules.
摘要翻译：用于定义和使用存储在关系数据库中的一组数据的逻辑扩展的系统和方法。存储各种扩展的元数据定义，以解释如何将数据存储到适于报告和计算目的的逻辑表达中。分析引擎将报表请求转换为SQL查询，以便在必要时使用元数据扩展定义来访问物理存储的数据，以生成适当的结果。这里，数据被存储在由一组属性物理密钥的至少一个表中，该属性确定表中包含的数据的粒度或级别。报告请求使引擎以比存在的更低的粒度级别计算和/或显示数据，从而调用元数据定义。扩展定义可以描述如何将数据从物理扩展到包括连接和分配规则的逻辑。

9. 发明授权

US07356840B1 Method and system for implementing security filters for reporting systems 有权
标题翻译：用于实施报告系统的安全过滤器的方法和系统
公开(公告)号：US07356840B1
公开(公告)日：2008-04-08
申请号：US09883509
申请日：2001-06-19
申请人： Jeffrey A. Bedell , Glenn J. Boysko , Eduardo Carranza , William Hurwood , Benjamin Z. Li , Sadanand Sahasrabudhe , Michael J. Saylor , Steven S. Trundle , Abhimanyu Warikoo , Jun Yuan
发明人： Jeffrey A. Bedell , Glenn J. Boysko , Eduardo Carranza , William Hurwood , Benjamin Z. Li , Sadanand Sahasrabudhe , Michael J. Saylor , Steven S. Trundle , Abhimanyu Warikoo , Jun Yuan
IPC分类号： G06F21/00
CPC分类号： G06F21/6227 , G06F17/30528 , G06F17/30592 , G06F2221/2141
摘要： Security filters that manage user access to data based on user identification and other data when a user attempts to access information via a query or other mechanisms. Security filters may be implemented to prevent users from viewing or otherwise accessing certain data in a database or other source of information in a reporting or other system. The level of access authorized by a security filter may be based on a user's role, capabilities, or other criteria. For example, a regional manager may have a security filter that allows a user to view data from the user's particular region regardless of the report the user runs. A security filter may include a filter expression, a top level and a bottom level where each component may be further define a user's ability to access certain data.
摘要翻译：当用户尝试通过查询或其他机制访问信息时，根据用户标识和其他数据管理用户对数据的访问的安全过滤器。可以实施安全过滤器以防止用户在报告或其他系统中查看或以其他方式访问数据库中的某些数据或其他信息源。安全过滤器授权的访问级别可以基于用户的角色，能力或其他标准。例如，区域管理员可以具有允许用户从用户的特定区域查看数据的安全过滤器，而不管用户运行的报告。安全过滤器可以包括过滤器表达式，顶级和底层，其中每个组件可以进一步限定用户访问某些数据的能力。

10. 发明授权

US06996569B1 Systems and methods for custom grouping of data 有权
标题翻译：用于数据自定义分组的系统和方法
公开(公告)号：US06996569B1
公开(公告)日：2006-02-07
申请号：US10120192
申请日：2002-04-11
申请人： Jeffrey A. Bedell , Xun Feng , William Hurwood , Ashutosh K. Jhaveri , Benjamin Z. Li , Xinyi Wang , Jun Yuan
发明人： Jeffrey A. Bedell , Xun Feng , William Hurwood , Ashutosh K. Jhaveri , Benjamin Z. Li , Xinyi Wang , Jun Yuan
IPC分类号： G06F17/30
CPC分类号： G06F17/30489 , G06F17/30412 , Y10S707/99943 , Y10S707/99944
摘要： A system and method for creating a custom grouping of data in a database. A custom group object is created, a plurality of custom group elements are defined, each of the custom group elements being a subset of the custom group object and being defined by a different filter, each one of the different filters representing a logical expression of qualifications based on the data or a derived calculation of the data. Each of the different filters is resolved against the data or a subset of the data, and the plurality of custom group elements are grouped into a consolidated result set which in not naturally existing in the data structure.
摘要翻译：用于在数据库中创建自定义数据分组的系统和方法。创建自定义组对象，定义多个自定义组元素，每个自定义组元素是自定义组对象的子集，并由不同的过滤器定义，每个不同的过滤器表示资格的逻辑表达式基于数据或数据的派生计算。每个不同的过滤器都针对数据或数据的一个子集进行解析，并且多个自定义组元素被分组成并不自然地存在于数据结构中的统一结果集合。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式