FAILURE RECOVERY AND ERROR CORRECTION TECHNIQUES FOR DATA LOADING IN INFORMATION WAREHOUSES

    公开(公告)号:US20080307011A1

    公开(公告)日:2008-12-11

    申请号:US12134065

    申请日:2008-06-05

    CPC classification number: G06F17/30309 G06F11/1469 G06F11/1471

    Abstract: A method of data loading for large information warehouses includes performing checkpointing concurrently with data loading into an information warehouse, the checkpointing ensuring consistency among multiple tables; and recovering from a failure in the data loading using the checkpointing. A method is also disclosed for performing versioning concurrently with data loading into an information warehouse. The versioning method enables processing undo and redo operations of the data loading between a later version and a previous version. Data load failure recovery is performed without starting a data load from the beginning but rather from a latest checkpoint for data loading at an information warehouse level using a checkpoint process characterized by a state transition diagram having a multiplicity of states; and tracking state transitions among the states using a system state table.

    BUSINESS INFORMATION WAREHOUSE TOOLKIT AND LANGUAGE FOR WAREHOUSING SIMPLIFICATION AND AUTOMATION

    公开(公告)号:US20080306987A1

    公开(公告)日:2008-12-11

    申请号:US12134011

    申请日:2008-06-05

    CPC classification number: G06F17/30592 G06F11/1471 G06F2201/80 G06Q30/02

    Abstract: A method for use with an information (or data) warehouse comprises managing the information warehouse with instructions in a declarative language. The instructions specify information warehouse-level tasks to be done without specifying certain details of how the tasks are to be implemented, for example, using databases and text indexers. The details are hidden from the user and include, for example, in an information warehouse having a FACT table that joins two or more dimension tables, details of database level operations when structured data are being handled, including database command line utilities, database drivers, and structured query language (SQL) statements; and details of text-indexing engines when unstructured data are being handled. The information warehouse is managed in a dynamic way in which different tasks—such as data loading tasks and information warehouse construction tasks—may be interleaved (i.e., there is no particular order in which the different tasks must be completed).

    System and method for establishing wireless connections between user devices and vehicles
    23.
    发明申请
    System and method for establishing wireless connections between user devices and vehicles 审中-公开
    用于在用户设备和车辆之间建立无线连接的系统和方法

    公开(公告)号:US20070238491A1

    公开(公告)日:2007-10-11

    申请号:US11394426

    申请日:2006-03-31

    Applicant: Bin He

    Inventor: Bin He

    CPC classification number: H04M1/6083 G01C21/26

    Abstract: A system and method for a vehicle is disclosed. Memory stores user profiles for a plurality of users. Each of the user profiles includes setting inputs for vehicle components and includes a wireless connection identifier for a wireless user device. The user selects his user profile in a user interface. A controller receives the selection from the user interface and obtains the setting inputs and the wireless connection identifier form the selected user profile in memory. The controller initiates one or more commands to the vehicle components having obtained setting inputs. In addition, the controller initiates a wireless connection between the wireless vehicle device and the wireless user device of the user using the wireless connection identifier.

    Abstract translation: 公开了一种车辆的系统和方法。 存储器存储多个用户的用户简档。 每个用户简档包括用于车辆部件的设置输入,并且包括用于无线用户设备的无线连接标识符。 用户在用户界面中选择他的用户配置文件。 控制器从用户接口接收选择,并从存储器中的所选择的用户简档获得设置输入和无线连接标识符。 控制器向已经获得的设置输入的车辆部件启动一个或多个命令。 此外,控制器使用无线连接标识符来启动无线车载设备与用户的无线用户设备之间的无线连接。

    Localizing neural sources in a brain
    24.
    发明申请
    Localizing neural sources in a brain 有权
    在脑中定位神经源

    公开(公告)号:US20060251303A1

    公开(公告)日:2006-11-09

    申请号: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)偶极子源定位以定位脑中的神经活动的方法和系统。

    Bimodal dense medium for fine particles separation in a dense medium
cyclone
    26.
    发明授权
    Bimodal dense medium for fine particles separation in a dense medium cyclone 失效
    双密实的介质,用于在致密的介质旋风分离器中进行微粒分离

    公开(公告)号:US5819945A

    公开(公告)日:1998-10-13

    申请号:US521371

    申请日:1995-08-31

    CPC classification number: B03B5/34 B03B5/442

    Abstract: The present invention provides a method for separation of fine particles in a bimodal (two component) dense medium. In accordance with the present invention, the dense medium comprises ferromagnetic particles that have a relative density range from about 4.0 to 7.0 suspended in water and are characterized by a bimodal size distribution. Such a medium exhibits high stability and favourable rheological properties. The use of such a bimodal magnetite dense medium in cleaning fine coal in a dense medium cyclone or dynamic dense medium separator results in optimum separation efficiency when the medium contains approximately 20-40% fine and 60-80% coarse magnetite, and when the size ratio of coarse-to-fine magnetite is in the range of 5 to 10.

    Abstract translation: 本发明提供了一种分离双峰(双组分)致密介质中的细颗粒的方法。 根据本发明,致密介质包括铁磁颗粒,其具有悬浮在水中的约4.0至7.0的相对密度范围,并且其特征在于双峰尺寸分布。 这种介质表现出高稳定性和良好的流变性能。 当这种双峰磁铁矿致密介质在致密的介质旋风分离器或动态致密介质分离器中清洗细煤时,当介质含有约20-40%的细颗粒和60-80%的粗磁铁矿时,会产生最佳的分离效率,当尺寸 粗到细磁铁矿的比例在5〜10的范围内。

    Set-level comparisons in dynamically formed groups
    27.
    发明授权
    Set-level comparisons in dynamically formed groups 失效
    动态形成组中的集合级别比较

    公开(公告)号:US08676834B2

    公开(公告)日:2014-03-18

    申请号:US13028948

    申请日:2011-02-16

    Applicant: Bin He

    Inventor: Bin He

    CPC classification number: G06F17/30489 G06F17/30324

    Abstract: Systems are disclosed of processing a set-level query across one or more attributes, the query being grouped by one or more attributes, whereby groups that satisfy the set-level query may be aggregated over one or more attributes. The systems use bitwise arithmetic to efficiently traverse bitmap and bit-slice vectors and indexes of a data relation to determine groups that solve the set-level query.

    Abstract translation: 公开了系统以跨越一个或多个属性来处理集级别查询,该查询被一个或多个属性分组,由此可以通过一个或多个属性来聚合满足集级别查询的组。 系统使用按位运算来有效地遍历位图和位片向量以及数据关系的索引,以确定解决集级别查询的组。

    METHOD AND SERVER FOR COLLECTING RADIO FINGERPRINT POSITIONING DATA
    28.
    发明申请
    METHOD AND SERVER FOR COLLECTING RADIO FINGERPRINT POSITIONING DATA 有权
    用于收集无线指纹定位数据的方法和服务器

    公开(公告)号:US20140073354A1

    公开(公告)日:2014-03-13

    申请号:US14114734

    申请日:2011-05-04

    CPC classification number: H04W24/02 G01S5/021 G01S5/0252 H04W64/00

    Abstract: The present invention relates to a method and a positioning server in a radio access network for collecting radio fingerprint positioning data records from different nodes. The data records comprise geographical positions and radio network communication parameters and are stored and grouped in clusters in the positioning server. A geometrical shape representing a geographical area based on the network communication parameters in the collected positioning data records in the cluster is computed. When a notification about changed network configuration parameters for a radio cell is received, known positioning servers simply erase all positioning data records related to that radio cell. This results in the unavailability of still valid positioning data. The present invention overcomes this problem by selectively erase positioning data records in the positioning server only when the configuration parameters have changed beyond a predefined value range.

    Abstract translation: 无线接入网中的方法和定位服务器技术领域本发明涉及一种无线接入网络中的方法和定位服务器,用于收集来自不同节点的无线指纹定位数 数据记录包括地理位置和无线电网络通信参数,并且在定位服务器中以簇的形式存储和分组。 计算表示基于集群中收集的定位数据记录中的网络通信参数的地理区域的几何形状。 当接收到关于无线电小区的改变的网络配置参数的通知时,已知的定位服务器简单地擦除与该无线电小区有关的所有定位数据记录。 这导致不可用的仍然有效的定位数据。 本发明通过仅当配置参数已经改变超出预定值范围时选择性地删除定位服务器中的定位数据记录来克服该问题。

    Concurrency control for extraction, transform, load processes
    29.
    发明授权
    Concurrency control for extraction, transform, load processes 有权
    提取,转换,加载过程的并发控制

    公开(公告)号:US08655859B2

    公开(公告)日:2014-02-18

    申请号:US12714929

    申请日:2010-03-01

    CPC classification number: G06F17/30563 G06F17/30359

    Abstract: System and methods manage concurrent ETL processes accessing a database. Exemplary embodiments include a method for concurrency management for ETL processes in a database having database tables and communicatively coupled to a computer, the method including establishing a session lock for the database, determining that a current ETL process is accessing the database at a current time, associating a current expiration time with the session lock, the expiration time being stored in a lock table in the database, sending the session lock to the current ETL process and performing ETL-level locking for the current ETL process.

    Abstract translation: 系统和方法管理访问数据库的并发ETL进程。 示例性实施例包括用于具有数据库表并且通信地耦合到计算机的数据库中的ETL进程的并发管理的方法,所述方法包括为数据库建立会话锁定,确定当前ETL进程正在当前时间访问数据库, 将当前到期时间与会话锁相关联,到期时间存储在数据库中的锁定表中,将会话锁定发送到当前ETL进程,并为当前ETL进程执行ETL级别锁定。

Patent Agency Ranking