公开(公告)号：US20090187582A1

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

申请号：US12017511

申请日：2008-01-22

Applicant: Ying Chen ,  Bin He

Inventor： Ying Chen ,  Bin He

IPC: G06F17/00

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

公开(公告)号：US20080307255A1

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

申请号：US11759856

申请日：2007-06-07

Applicant: Ying Chen ,  Bin He ,  Ana Lelescu ,  James J. Rhodes ,  Rui Wang

Inventor： Ying Chen ,  Bin He ,  Ana Lelescu ,  James J. Rhodes ,  Rui Wang

IPC: G06F11/00

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.

Abstract translation: 大型信息仓库的数据加载方法包括：将数据加载到信息仓库中同时进行检查点检查，确保多个表格之间的一致性; 并使用检查点从数据加载失败中恢复。 还公开了一种与数据加载到信息仓库中同时进行版本控制的方法。 版本控制方法可以处理在更高版本和先前版本之间的数据加载的撤消和重做操作。 执行数据加载失败恢复，而不从一开始就开始数据加载，而是从最新检查点开始，使用特征在于具有多个状态的状态转换图的检查点进程在信息仓库级别进行数据加载。 并使用系统状态表来跟踪状态之间的状态转换。

公开(公告)号：US20070009572A1

公开(公告)日：2007-01-11

申请号：US11176654

申请日：2005-07-06

Applicant: Bee Mary Chan ,  Jinye Shen ,  Bin He ,  Aiping Zhu ,  Yehai Yan ,  Chee Yue

Inventor： Bee Mary Chan ,  Jinye Shen ,  Bin He ,  Aiping Zhu ,  Yehai Yan ,  Chee Yue

IPC: A61F2/02 ,  B29C45/00

CPC classification number: B29C33/3857 ,  B29C33/424

Abstract: In embodiments of the present invention, a biodegradable/biodegradable polymer film may be used as a scaffold for tissue engineering scaffolds for engineering organized organs, such as vascular grafts, for example. In one embodiment, an ultraviolet (UV) resin made from a diacrylated biodegradable oligomer is molded into a flexible scaffold having cavities and/or channels. Channel/cavity size may be on the order of micrometers and/or nanometers, and thus the walls may have high aspect ratios. Smooth muscle cells may be deposited in the channels and because of the high aspect ratios, the cells may align along the channels/cavities as confluence is reached.

Abstract translation: 在本发明的实施方案中，可生物降解/可生物降解的聚合物膜可用作用于组织工程支架的支架，用于工程组织的器官，例如血管移植物。 在一个实施方案中，由二丙烯酸酯化的可生物降解的低聚物制成的紫外线（UV）树脂被模制成具有空腔和/或通道的柔性支架。 通道/腔尺寸可以在微米级和/或纳米级上，因此壁可具有高纵横比。 平滑肌细胞可以沉积在通道中，并且由于高纵横比，当达到汇合时，细胞可以沿着通道/腔排列。

公开(公告)号：US07047125B1

公开(公告)日：2006-05-16

申请号：US11066244

申请日：2005-02-25

Applicant: Bin He ,  Jeffrey D. Baskett

Inventor： Bin He ,  Jeffrey D. Baskett

IPC: G06G7/70

CPC classification number: F02D41/2477 ,  F02D41/0097 ,  F02D41/1405 ,  F02D41/2432 ,  F02D2041/1433 ,  F02D2200/1004 ,  F02D2200/1006 ,  G01M15/046

Abstract: A system is provided for estimating an operational parameter of a first engine, the first engine including a rotatable crankshaft. The system includes a model for estimating the operational parameter of the first engine as a function of instantaneous crankshaft speed at a plurality of angular positions of the crankshaft of the first engine. The model is developed, at least partially, based upon operational data from a second engine having a rotatable crankshaft. A sensor is operable to determine values representative of the instantaneous crankshaft speed of the first engine, at a plurality of angular positions of the crankshaft of the first engine. A modifier is operable to modify at least some of the representative values to, at least partially, calibrate out differences between the first and second engines that may cause variations in instantaneous crankshaft speed. The modified values are input to the model.

Abstract translation: 提供一种用于估计第一发动机的操作参数的系统，所述第一发动机包括可旋转的曲轴。 该系统包括用于在第一发动机的曲轴的多个角位置处估计第一发动机的操作参数作为瞬时曲轴速度的函数的模型。 该模型至少部分地基于具有可旋转曲轴的第二发动机的操作数据而开发。 传感器可操作以在第一发动机的曲轴的多个角位置处确定表示第一发动机的瞬时曲轴速度的值。 修改器可操作以将至少一些代表值修改为至少部分地校准可能引起瞬时曲轴速度变化的第一和第二发动机之间的差异。 修改后的值被输入到模型中。

公开(公告)号：US5795713A

公开(公告)日：1998-08-18

申请号：US795470

申请日：1997-02-04

Applicant: Bernard Roizman ,  Bin He

Inventor： Bernard Roizman ,  Bin He

IPC: C12Q1/42 ,  C12Q1/48 ,  C12Q1/70

CPC classification number: C12Q1/42 ,  G01N2333/912 ,  G01N2333/916

Abstract: Methods for identifying inducers and inhibitors of programmed cell death in a cell-free system are described. The methods exploit the finding that programmed cell death is accompanied by shutdown of cellular protein synthesis and by phosphorylation of eIF-2.alpha. and that the dephosphorylation of eIF-2.alpha. prevents the shutdown of protein synthesis.

Abstract translation: 描述了在无细胞系统中鉴定诱导剂和程序性细胞死亡抑制剂的方法。 该方法利用程序性细胞死亡伴随着细胞蛋白质合成的停止和eIF-2α的磷酸化的发现，并且eIF-2α的去磷酸化阻止了蛋白质合成的停止。