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

1. 发明授权

US08812490B1 Data source joins 有权
标题翻译：数据源连接
公开(公告)号：US08812490B1
公开(公告)日：2014-08-19
申请号：US12915752
申请日：2010-10-29
申请人： Scott Cappiello , Gang Liang , Xun Feng , Jun Yuan , Benjamin Z. Li , Rixin Liao
发明人： Scott Cappiello , Gang Liang , Xun Feng , Jun Yuan , Benjamin Z. Li , Rixin Liao
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30469 , G06F17/30442 , G06F17/30454 , G06F17/30474 , G06F17/30477 , G06F17/30554 , G06F17/30575
摘要： Database report generation technology for handling a single logical query that requires data that is physically located in two different sources. The system uses intelligent push-down joins, which move data from one source to the other and join data within that source. The system dynamically determines which direction to move data depending on how the data is used in a query.
摘要翻译：用于处理需要物理位于两个不同来源的数据的单个逻辑查询的数据库报表生成技术。该系统使用智能下拉式连接，将数据从一个源移动到另一个源，并加入该源中的数据。根据数据在查询中的使用情况，系统会动态地确定要移动数据的方向。

2. 发明授权

US09183317B1 System and method for exporting report results from a reporting system 有权
标题翻译：从报告系统导出报告结果的系统和方法
公开(公告)号：US09183317B1
公开(公告)日：2015-11-10
申请号：US09884468
申请日：2001-06-20
申请人： Scott Cappiello , William Hurwood , Benjamin Z. Li , Luis V. Orozco , Ramkumar Ramachandran , Gaurav Rewari , Jun Yuan
发明人： Scott Cappiello , William Hurwood , Benjamin Z. Li , Luis V. Orozco , Ramkumar Ramachandran , Gaurav Rewari , Jun Yuan
IPC分类号： G06F17/00 , G06F17/30
CPC分类号： G06F17/30563 , G06F17/30896
摘要： A technique for exporting results from a reporting system report in a format type including a datamart, PDF file, flat file, Excel™ file, HTML file, and XML file or in another relational database management system (RDBMS) format. In one embodiment, the technique is realized through a method and a system for automatically exporting results from a business intelligence, OLAP, or other reporting system. One embodiment of the present invention involves a method of enabling a user to designate a report desired for execution as an export-report. When the report is processed, the report is exported into a datamart or other format and made available for access by the user through one or more different types of user devices. The user may then further manipulate or export the results from the datamart to a file type as desired.
摘要翻译：一种用于以包括数据表，PDF文件，平面文件，Excel™文件，HTML文件和XML文件或其他关系数据库管理系统（RDBMS）格式的格式类型的报表系统报表导出结果的技术。在一个实施例中，该技术通过用于从商业智能，OLAP或其他报告系统自动导出结果的方法和系统来实现。本发明的一个实施例涉及一种使用户能够将执行期望的报告指定为导出报告的方法。报告处理后，报告将导出为数据表或其他格式，并可供用户通过一个或多个不同类型的用户设备进行访问。然后，用户可以根据需要进一步将结果从数据分组操作或导出到文件类型。

3. 发明授权

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.
摘要翻译：用于在数据库中创建自定义数据分组的系统和方法。创建自定义组对象，定义多个自定义组元素，每个自定义组元素是自定义组对象的子集，并由不同的过滤器定义，每个不同的过滤器表示资格的逻辑表达式基于数据或数据的派生计算。每个不同的过滤器都针对数据或数据的一个子集进行解析，并且多个自定义组元素被分组成并不自然地存在于数据结构中的统一结果集合。

4. 发明授权

US06801910B1 Method and system for guiding drilling in a report generated by a reporting system 有权
标题翻译：在报告系统生成的报告中指导钻井的方法和系统
公开(公告)号：US06801910B1
公开(公告)日：2004-10-05
申请号：US09883505
申请日：2001-06-19
申请人： Jeffrey A. Bedell , Scott Cappiello , L. Douglas Everhart , William Hurwood , Benjamin Z. Li , Fabrice Martin , David B. Sherwood , Steven S. Trundle
发明人： Jeffrey A. Bedell , Scott Cappiello , L. Douglas Everhart , William Hurwood , Benjamin Z. Li , Fabrice Martin , David B. Sherwood , Steven S. Trundle
IPC分类号： G06F1730
CPC分类号： G06F17/30592 , Y10S707/99932 , Y10S707/99935 , Y10S707/99936
摘要： A method and system for guiding drilling into a report are disclosed. Through the use of the invention, a user can drill within a first report dimension or from the first report dimension into a second report dimension. Additionally, a drill map providing a plurality of drilling paths is associated with each report. The system of the invention includes drill transformation tools and drill map management tools for assisting a user in navigating through report instances.
摘要翻译：公开了一种用于将钻孔引导到报告中的方法和系统。通过使用本发明，用户可以在第一报告维度内或从第一报告维度钻取到第二报告维度。此外，提供多个钻孔路径的钻探图与每个报告相关联。本发明的系统包括用于辅助用户浏览报告实例的钻取变换工具和钻地图管理工具。

5. 发明授权

US07113993B1 Technique for handling server session requests in a system having a plurality of servers 有权
标题翻译：在具有多个服务器的系统中处理服务器会话请求的技术
公开(公告)号：US07113993B1
公开(公告)日：2006-09-26
申请号：US10162716
申请日：2002-06-06
申请人： Scott Cappiello , Yi Du , Dyung V. Le , Benjamin Z. Li , Wenfeng Li , Ramprasad Polana , Patrick Vinton
发明人： Scott Cappiello , Yi Du , Dyung V. Le , Benjamin Z. Li , Wenfeng Li , Ramprasad Polana , Patrick Vinton
IPC分类号： G06F15/16
CPC分类号： H04L67/1008 , H04L67/1002 , H04L67/1023 , H04L67/1034 , H04L67/14 , H04L69/40
摘要： A technique for handling server session requests in a system having a plurality of servers is disclosed. In one embodiment, the technique includes receiving a request to create a session on one of the plurality of servers. In response to the request, a primary session is created on a first of the plurality of servers. After the primary session is created, at least one other of the plurality of servers are notified that the primary session has been created. Such notification allows for a backup session on the at least one other of the plurality of servers to take over for the primary session upon a failure on the first of the plurality of servers.
摘要翻译：公开了一种在具有多个服务器的系统中处理服务器会话请求的技术。在一个实施例中，该技术包括接收在多个服务器之一上创建会话的请求。响应于该请求，在多个服务器中的第一个服务器上创建主会话。在创建主会话之后，通知多个服务器中的至少一个服务器已经创建了主会话。这种通知允许多个服务器中的至少另一个服务器上的备份会话在多个服务器中的第一个上的故障时接管主会话。

6. 发明授权

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.
摘要翻译：在线分析处理系统，商业智能系统，报告系统或数据挖掘系统中的查询语言生成中的语法抽象的系统和方法。该系统生成一个或多个可针对一个或多个数据源运行的查询语言语句，以返回所需的数据结果集。该系统包括语法模式选择器模块和语句组合模块。语法模式选择器模块选择与所需功能和语法标准相对应的语法模式。语句组合模块使用与所需数据集相关联的参数数据集填充语法模式。结果是生成具有正确功能，语法和数据参数的一个或多个查询语言语句，以从数据源返回所需的数据结果集。还描述了其中具有处理器可读代码的方法和介质。

7. 发明授权

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.
摘要翻译：提供了系统和方法，用于使用执行计划过滤数据库中的数据。执行计划针对数据库进行第一处理通过，该处理计算使用过滤条件来计算过滤器集合，并针对计算报告结果的过滤器集合进行第二处理通过。

8. 发明授权

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语句到关系数据库，将初步结果传递给外部分析引擎，并将数据保存回关系数据库进行进一步处理，直到执行多步计算。

9. 发明授权

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语句到关系数据库，将初步结果传递给外部分析引擎，并将数据保存回关系数据库进行进一步处理，直到执行多步计算。

10. 发明授权

US07836178B1 Technique for limiting access to the resources of a system 有权
标题翻译：限制对系统资源的访问的技术
公开(公告)号：US07836178B1
公开(公告)日：2010-11-16
申请号：US10166044
申请日：2002-06-11
申请人： Jeffrey A. Bedell , Benjamin Z. Li , Wenfeng Li , Luis V. Orozco , Ramprasad Polana , Ramkumar Ramachandran , Jun Yuan
发明人： Jeffrey A. Bedell , Benjamin Z. Li , Wenfeng Li , Luis V. Orozco , Ramprasad Polana , Ramkumar Ramachandran , Jun Yuan
IPC分类号： G06F15/173
CPC分类号： G06F9/505
摘要： A technique for limiting access to the resources of a system is disclosed. In one embodiment, wherein the system has a server for processing requests, and wherein the server supports a plurality of projects, the technique includes receiving a request to access the resources of the system. The request is denied based upon an application level and a setting level, wherein the application level is associated with one of a plurality of functional layers within the system that is affected by the request, and wherein the setting level is a limiting value associated with one of the server alone and the server with one or more of the plurality of projects. The limiting value limits an operation on one of the plurality of functional layers, thereby limiting access to the resources of the system.
摘要翻译：公开了一种用于限制对系统的资源的访问的技术。在一个实施例中，其中系统具有用于处理请求的服务器，并且其中服务器支持多个项目，该技术包括接收访问系统资源的请求。所述请求基于应用级别和设置级别而被拒绝，其中所述应用级别与所述系统中受所述请求影响的多个功能层中的一个相关联，并且其中所述设置级别是与一个相关联的限制值的服务器和具有多个项目中的一个或多个的服务器。限制值限制在多个功能层之一上的操作，从而限制对系统的资源的访问。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式