System and method for efficient date retrieval and processing
    3.
    发明授权
    System and method for efficient date retrieval and processing 有权
    有效的日期检索和处理的系统和方法

    公开(公告)号:US07430562B1

    公开(公告)日:2008-09-30

    申请号:US09883499

    申请日:2001-06-19

    IPC分类号: G06F17/00

    摘要: 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报告的数据集)定义查询结构。 语法汇编模块基于定义的查询结构定义一个或多个查询语言语句。 过程优化模块基于与数据源相关联的数据库模式来评估处理选项。 系统可以组合一个或多个查询语言语句,并针对数据源运行以返回所需的数据结果集。 还描述了其中具有处理器可读代码的方法和介质。

    System and method for user defined data object hierarchy
    5.
    发明授权
    System and method for user defined data object hierarchy 有权
    用户定义的数据对象层次结构的系统和方法

    公开(公告)号:US07010518B1

    公开(公告)日:2006-03-07

    申请号:US09884476

    申请日:2001-06-20

    IPC分类号: G06F17/30

    摘要: 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.

    摘要翻译: 本发明提供了一种用于允许用户构建用于商业智能或其他目的的定制选择的数据对象分层结构的配置工具。 在传统的数据存储技术下,磁盘驱动器或其他媒体的物理布局决定了用户可以在底层数据上运行哪些逻辑视图和搜索。 例如,级别不能轻易跳过,或者很难对数据对象关系进行维护。 在本发明中,用户可以将一组数据对象选择并连接到其选择的层级中,以允许对要执行的数据的期望报告和其他操纵。 可以编辑层次结构,并且可以定义入口点。 可以将不同级别的安全性应用于层次结构的不同层次。 可以为一个数据库或其他数据源构建多个层次结构或表示。

    System and method for extension of data schema
    6.
    发明授权
    System and method for extension of data schema 有权
    用于扩展数据模式的系统和方法

    公开(公告)号:US06996568B1

    公开(公告)日:2006-02-07

    申请号:US10120144

    申请日:2002-04-11

    IPC分类号: G06F17/30

    摘要: 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查询,以便在必要时使用元数据扩展定义来访问物理存储的数据,以生成适当的结果。 这里,数据被存储在由一组属性物理密钥的至少一个表中,该属性确定表中包含的数据的粒度或级别。 报告请求使引擎以比存在的更低的粒度级别计算和/或显示数据,从而调用元数据定义。 扩展定义可以描述如何将数据从物理扩展到包括连接和分配规则的逻辑。

    System and method for syntax abstraction in query language generation
    7.
    发明授权
    System and method for syntax abstraction in query language generation 有权
    查询语言生成中语法抽象的系统和方法

    公开(公告)号:US08005870B1

    公开(公告)日:2011-08-23

    申请号:US09883302

    申请日:2001-06-19

    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.

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

    System and method for function selection in analytic processing
    8.
    发明授权
    System and method for function selection in analytic processing 有权
    分析处理中功能选择的系统和方法

    公开(公告)号:US08606813B1

    公开(公告)日:2013-12-10

    申请号:US10043263

    申请日:2002-01-14

    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.

    摘要翻译: 用于协作处理网络的选择引擎,其中数据库计算搜索和分析的部分,哪些可以最有效地计算。 数据挖掘网络可能包含大型数据库,与数据库通信的分析引擎,以及其他能够执行或执行某些功能(如统计功能)的资源。 当用户希望针对数据库运行指定的报告时,可以在数据库中本地计算的那些功能被捕获和计算,而诸如高级统计功能的其他功能可以分发到远程分析引擎或其他资源 网络。 管理模块可以协调数据的传输和组装,包括订单依赖性。 管理模块可以包含选择引擎以将计算分配给数据库或其他资源作为默认值,以在选择计算站点之前测试负载平衡或应用其他标准。

    Method and device for monitoring enablement of an electrical apparatus connected to a power grid
    9.
    发明授权
    Method and device for monitoring enablement of an electrical apparatus connected to a power grid 有权
    用于监测连接到电网的电气设备的使能的方法和装置

    公开(公告)号:US06950007B2

    公开(公告)日:2005-09-27

    申请号:US10258113

    申请日:2001-04-17

    摘要: The invention concerns a method and a device for monitoring enablement of an electrical apparatus connected to a power grid. The method consists in: transmitting (A) from a specialised transmitter (ES) to the electrical apparatus (EA) a coded information message comprising an enablement information, in accordance with an enablement control code; and in receiving (B) by means of a receiver (R) equipping the electrical apparatus (EA) said information message. The latter is decoded (C) in accordance with specific enablement data integrated in the receiver (R) to generate decoded enablement data. The enablement of the electrical apparatus (EA) is granted (D, E) if the decoded data are in conformity with the integrated specific enablement data and enablement is refused (D, F) otherwise. The invention is useful for protecting electrical appliances against theft, for managing service delivery on a distant site, monitoring contractual terms.

    摘要翻译: 本发明涉及一种用于监测连接到电网的电气设备的启用的方法和装置。 该方法包括:根据启用控制码,从专用发射机(ES)向电气设备(EA)发送(A)包括启用信息的编码信息消息; 以及通过装备所述电气设备(EA)的所述信息消息的接收器(R)接收(B)。 后者根据集成在接收器(R)中的特定启用数据被解码(C)以产生解码的使能数据。 如果解码的数据与集成的特定启用数据一致,则允许电气设备(EA)的启用(D,E),否则允许启用(D,F)。 本发明对于保护电器免受盗窃而有用,用于管理远距离站点上的服务传送,监视合同条款。