Efficient update methods for large volume data updates in data warehouses
    51.
    发明授权
    Efficient update methods for large volume data updates in data warehouses 失效
    数据仓库中大量数据更新的高效更新方法

    公开(公告)号:US08429116B2

    公开(公告)日:2013-04-23

    申请号:US12131078

    申请日:2008-05-31

    Applicant: Ying Chen Bin He

    Inventor: Ying Chen Bin He

    CPC classification number: G06F17/30592

    Abstract: A system and method for ensuring large and frequent updates to a data warehouse. The process leverages a set of temporary staging tables to track the updates. A set of intermediate steps are performed to accomplish bulk deletions of the outdated changed records, and perform modifications to the map tables for models such as snowflake. Finally, bulk load operations load the updates and insert them into the final dimension tables. The process ensures performance comparable to insertion-only schemes with at most only slight performance degradation. Furthermore, a modified process is applied on the newfact data warehouse dimension model. The process can be readily adapted to handle star schema and other hierarchical data warehouse models.

    Abstract translation: 一种用于确保对数据仓库进行大量和频繁更新的系统和方法。 该过程利用一组临时暂存表来跟踪更新。 执行一组中间步骤以完成对过时的已更改记录的批量删除,并对诸如雪花之类的模型执行对映射表的修改。 最后,批量加载操作加载更新并将它们插入到最终维度表中。 该过程确保性能与只插入方案相当,最多只有轻微的性能下降。 此外,修改后的流程应用于新元数据仓库维度模型。 该过程可以容易地适应于处理星型模式和其他分层数据仓库模型。

    SUPPORTING SET-LEVEL SLICE AND DICE IN DATA WAREHOUSES
    52.
    发明申请
    SUPPORTING SET-LEVEL SLICE AND DICE IN DATA WAREHOUSES 审中-公开
    在数据仓库中支持设置级别的数据和数据

    公开(公告)号:US20130006969A1

    公开(公告)日:2013-01-03

    申请号:US13607320

    申请日:2012-09-07

    Applicant: BIN HE YING CHEN

    Inventor: BIN HE YING CHEN

    CPC classification number: G06F17/30592 G06F17/30439

    Abstract: A method and system for coping with slice and dice operations in data warehouses is disclosed. An external approach may be utilized, creating queries using structured query language on a computer. An algorithm may be used to rewrite the queries. The resulting predicates may be joined to dimension tables corresponding to fact tables. An internal approach may be utilized, using aggregation functions with early aggregation for creating the queries. The results of the slice and dice operations may be outputted to a user on a computer monitor.

    Abstract translation: 公开了一种用于处理数据仓库中的切片和骰子操作的方法和系统。 可以使用外部方法,在计算机上使用结构化查询语言创建查询。 可以使用算法来重写查询。 所得到的谓词可以连接到对应于事实表的维度表。 可以使用内部方法,使用具有早期聚合的聚合功能来创建查询。 切片和骰子操作的结果可以在计算机监视器上输出给用户。

    Supporting set-level slice and dice in data warehouses
    53.
    发明授权
    Supporting set-level slice and dice in data warehouses 失效
    支持数据仓库中的设置级切片和骰子

    公开(公告)号:US08326797B2

    公开(公告)日:2012-12-04

    申请号:US12616612

    申请日:2009-11-11

    Applicant: Bin He Ying Chen

    Inventor: Bin He Ying Chen

    CPC classification number: G06F17/30592 G06F17/30439

    Abstract: A method and system for coping with slice and dice operations in data warehouses is disclosed. An external approach may be utilized, creating queries using structured query language on a computer. An algorithm may be used to rewrite the queries. The resulting predicates may be joined to dimension tables corresponding to fact tables. An internal approach may be utilized, using aggregation functions with early aggregation for creating the queries. The results of the slice and dice operations may be outputted to a user on a computer monitor.

    Abstract translation: 公开了一种用于处理数据仓库中的切片和骰子操作的方法和系统。 可以使用外部方法,在计算机上使用结构化查询语言创建查询。 可以使用算法来重写查询。 所得到的谓词可以连接到对应于事实表的维度表。 可以使用内部方法,使用具有早期聚合的聚合功能来创建查询。 切片和骰子操作的结果可以在计算机监视器上输出给用户。

    ICEBERG QUERY EVALUATION IMPLEMENTING A COMPRESSED BITMAP INDEX
    54.
    发明申请
    ICEBERG QUERY EVALUATION IMPLEMENTING A COMPRESSED BITMAP INDEX 有权
    ICEBERG QUERY评估实施压缩的BITMAP指数

    公开(公告)号:US20110270871A1

    公开(公告)日:2011-11-03

    申请号:US12772307

    申请日:2010-05-03

    Applicant: Bin He Hui-l Hsiao

    Inventor: Bin He Hui-l Hsiao

    CPC classification number: G06F17/30539 G06F17/30324 G06F17/30489

    Abstract: Exemplary embodiments include an iceberg query method, including processing the iceberg query using a bitmap index having a plurality of bitmap vectors in a database, eliminating any of the plurality of bitmap vectors in the bitmap index that fails to meet a given condition thereby forming a subset of the plurality of bitmap vectors and aligning the vectors in the subset of the plurality of bitmap vectors in the bitmap index according to respective positions of the bitmap vectors in the subset of the plurality of bitmap vectors.

    Abstract translation: 示例性实施例包括冰山查询方法,包括使用在数据库中具有多个位图向量的位图索引来处理冰山查询,消除位图索引中不满足给定条件的多个位图矢量中的任何一个,从而形成子集 并且根据多个位图矢量的子集中的位图矢量的各个位置,对位图索引中的多个位图矢量的子集中的向量进行对齐。

    Localizing neural sources in a brain
    55.
    发明授权
    Localizing neural sources in a brain 有权
    在脑中定位神经源

    公开(公告)号:US08032209B2

    公开(公告)日:2011-10-04

    申请号:US11372225

    申请日:2006-03-09

    CPC classification number: G06K9/0057 A61B5/04008 A61B5/0476 A61B5/4094

    Abstract: Described herein is a non-invasive determination of locations of neural activity in a brain. In particular, methods and systems have been developed that utilize a FINES algorithm for use in three-dimensional (3-D) dipole source localization to locate neural activity in a brain.

    Abstract translation: 本文描述的是脑内神经活动位置的非侵入性测定。 特别地,已经开发了利用FINES算法用于三维(3-D)偶极子源定位以定位脑中的神经活动的方法和系统。

    Method and apparatus for implementing a uniform platform for data/voice service
    56.
    发明授权
    Method and apparatus for implementing a uniform platform for data/voice service 有权
    实现数据/语音服务统一平台的方法和装置

    公开(公告)号:US07864743B2

    公开(公告)日:2011-01-04

    申请号:US11685195

    申请日:2007-03-12

    CPC classification number: H04W88/08

    Abstract: Methods and apparatus are presented for implementing a uniform platform for data/voice service, in which a base station controller and a Multi-BSSFast Packet Server are integrated into one rack, and a base station controller is connected to the Multi-BSSFast Packet Server via a link based on E1 over Ethernet (E1oE).

    Abstract translation: 提出了实现用于数据/语音服务的统一平台的方法和装置,其中将基站控制器和多BSSFast分组服务器集成到一个机架中,并且基站控制器经由多BSSFast分组服务器经由 基于E1以太网(E1oE)的链路。

    Efficient Update Methods For Large Volume Data Updates In Data Warehouses
    57.
    发明申请
    Efficient Update Methods For Large Volume Data Updates In Data Warehouses 失效
    数据仓库中大容量数据更新的高效更新方法

    公开(公告)号:US20090187602A1

    公开(公告)日:2009-07-23

    申请号:US12131078

    申请日:2008-05-31

    Applicant: Ying Chen Bin He

    Inventor: Ying Chen Bin He

    CPC classification number: G06F17/30592

    Abstract: A system and method for ensuring large and frequent updates to a data warehouse. The process leverages a set of temporary staging tables to track the updates. A set of intermediate steps are performed to accomplish bulk deletions of the outdated changed records, and perform modifications to the map tables for models such as snowflake. Finally, bulk load operations load the updates and insert them into the final dimension tables. The process ensures performance comparable to insertion-only schemes with at most only slight performance degradation. Furthermore, a modified process is applied on the newfact data warehouse dimension model. The process can be readily adapted to handle star schema and other hierarchical data warehouse models.

    Abstract translation: 一种用于确保对数据仓库进行大量和频繁更新的系统和方法。 该过程利用一组临时暂存表来跟踪更新。 执行一组中间步骤以完成对过时的已更改记录的批量删除,并对诸如雪花之类的模型执行对映射表的修改。 最后,批量加载操作加载更新并将它们插入到最终维度表中。 该过程确保性能与只插入方案相当,最多只有轻微的性能下降。 此外,修改后的流程应用于新元数据仓库维度模型。 该过程可以容易地适应于处理星型模式和其他分层数据仓库模型。

    Method and system for extracting web query interfaces
    58.
    发明授权
    Method and system for extracting web query interfaces 有权
    Web查询界面提取方法和系统

    公开(公告)号:US07552116B2

    公开(公告)日:2009-06-23

    申请号:US10913721

    申请日:2004-08-06

    Abstract: A computer program product being embodied on a computer readable medium for extracting semantic information about a plurality of documents being accessible via a computer network, the computer program product including computer-executable instructions for: generating a plurality of tokens from at least one of the documents, each token being indicative of a displayed item and a corresponding position; and, constructing at least one parse tree indicative of a semantic structure of the at least one document from the tokens dependently upon a grammar being indicative of presentation conventions.

    Abstract translation: 一种计算机程序产品,其体现在计算机可读介质上,用于提取关于可通过计算机网络访问的多个文档的语义信息,所述计算机程序产品包括计算机可执行指令,用于:从至少一个文档生成多个令牌 每个标记指示显示的项目和相应的位置; 并且依赖于表示呈现约定的语法,从令牌构建指示所述至少一个文档的语义结构的至少一个解析树。

    Method and apparatus of three dimension electrocardiographic imaging
    60.
    发明授权
    Method and apparatus of three dimension electrocardiographic imaging 有权
    三维心电图成像方法与装置

    公开(公告)号:US06856830B2

    公开(公告)日:2005-02-15

    申请号:US09909338

    申请日:2001-07-19

    Applicant: Bin He

    Inventor: Bin He

    CPC classification number: A61B5/0402 A61B5/04007 A61B5/04085 G06F19/00

    Abstract: An instrument and method for imaging and localizing of electrical activities in a biological system, comprising a plurality of sensors for detecting signals over a part of a surface of the biological system, a data acquisition unit for collecting the signals, a positioning device for determining positions of the sensors, a procedure for determining geometry information of the biological system, an electrical source model incorporating physical and physiological properties of the biological system, an estimator for determining the parameters of the electrical source model, and a unit for displaying the reconstructed excitation sequence and/or electrical source distribution in the three dimension space of the biological system and over time.

    Abstract translation: 一种用于在生物系统中成像和定位电活动的仪器和方法,包括用于检测生物系统表面的一部分上的信号的多个传感器,用于收集信号的数据获取单元,用于确定位置的定位装置 的传感器,用于确定生物系统的几何信息的程序,包含生物系统的物理和生理属性的电源模型,用于确定电源模型的参数的估计器,以及用于显示重建的激励序列的单元 和/或电源分布在生物系统的三维空间中并随时间推移。

Patent Agency Ranking