Method, system, and program for query optimization with algebraic rules
    1.
    发明申请
    Method, system, and program for query optimization with algebraic rules 失效
    用代数规则进行查询优化的方法,系统和程序

    公开(公告)号:US20050114311A1

    公开(公告)日:2005-05-26

    申请号:US10721802

    申请日:2003-11-25

    IPC分类号: G06F17/30

    摘要: Disclosed is technique for executing a query. A query is matched to an outlier materialized query table. The query is searched for a source predicate. The outlier materialized query table is searched for a target column that corresponds to a source column in the source predicate. A new range predicate is derived based on the target column and introduced into the query.

    摘要翻译: 公开了用于执行查询的技术。 查询与异常值物化查询表匹配。 查询查询源谓词。 搜索异常值物化查询表,查找与源谓词中的源列相对应的目标列。 基于目标列导出新的范围谓词并将其引入到查询中。

    Method, system, and program for query optimization with algebraic rules
    2.
    发明授权
    Method, system, and program for query optimization with algebraic rules 失效
    用代数规则进行查询优化的方法,系统和程序

    公开(公告)号:US07240078B2

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

    申请号:US10721802

    申请日:2003-11-25

    IPC分类号: G06F17/30

    摘要: A query is matched to an outlier materialized query table that stores exception data. The query is searched for a source predicate. An outlier predicate in the outlier materialized query table that corresponds to the source predicate is searched for a target column that corresponds to a source column in the source predicate. A new range predicate is derived based on the target column and introduced into the query, wherein the query is executed to retrieve data from one or more data stores.

    摘要翻译: 查询与存储异常数据的异常值物化查询表进行匹配。 查询查询源谓词。 搜索与源谓词对应的离群物质化查询表中的异常谓词,找出与源谓词中的源列相对应的目标列。 基于目标列导出新的范围谓词并将其引入到查询中,其中执行查询以从一个或多个数据存储中检索数据。

    Method, system, and program for query optimization with algebraic rules
    3.
    发明授权
    Method, system, and program for query optimization with algebraic rules 有权
    用代数规则进行查询优化的方法,系统和程序

    公开(公告)号:US07945557B2

    公开(公告)日:2011-05-17

    申请号:US11754213

    申请日:2007-05-25

    IPC分类号: G06F17/30 G06F15/16

    摘要: A set of algebraic rules applicable to a query are identified, wherein each of the algebraic rules represents a relationship between two columns in a relational database table. A source column is identified by searching the query for a source predicate, wherein the source predicate is a range predicate. One or more candidate target columns are identified by searching the set of algebraic rules, wherein each of the candidate target columns occurs on one side of a binding expression and the source column occurs on the other side of the binding expression. For each of the one or more candidate target columns, a bounds subquery that provides a lower bound and an upper bound for a new range predicate is derived and he new range predicate is introduced into the query, wherein the query is executed to retrieve data from one or more data stores.

    摘要翻译: 识别适用于查询的一组代数规则,其中每个代数规则表示关系数据库表中两列之间的关系。 通过搜索查询源标识来识别源列,其中源谓词是范围谓词。 通过搜索代数规则集来识别一个或多个候选目标列,其中候选目标列中的每一个出现在绑定表达式的一侧上,并且源列出现在绑定表达式的另一侧上。 对于一个或多个候选目标列中的每一个,导出提供新范围谓词的下限和上限的边界子查询,并且将新范围谓词引入到查询中,其中执行查询以从 一个或多个数据存储。

    A Supraglottic Airway Device for intermittent Positive Pressure Ventilation

    公开(公告)号:US20210162154A1

    公开(公告)日:2021-06-03

    申请号:US16699601

    申请日:2019-11-30

    申请人: Yang Sun

    发明人: Yang Sun

    IPC分类号: A61M16/04

    摘要: An airway device to be inserted into a patient's throat and to be function as a supraglottic airway device during a positive pressure ventilation and spontaneous ventilation that includes an air tube, an air sac, a tongue lifting means, a pulling unit and a drainage systems. The pulling unit will be pulled by an operator's hand to cause the tongue lifting means upward movement to open up the air sac and lift up the tongue base. The air tube lumen and the air sac are configured to have inflow airflow be divided and follow specific route therefore to deliver the focused airflow to vocal cords opening, and also to let inspired airflow enter desired area of the air sac to expand the air sac to form seals with surrounding tissue. During expiration, the pressure will be relieved. Different design of the drainage system can be configured to drained fluid from upper esophagus or from posterior pharyngeal wall.

    Technique for determining a target data type in a heterogeneous multi-level environment
    6.
    发明申请
    Technique for determining a target data type in a heterogeneous multi-level environment 有权
    用于在异构多级环境中确定目标数据类型的技术

    公开(公告)号:US20050102296A1

    公开(公告)日:2005-05-12

    申请号:US10703296

    申请日:2003-11-06

    IPC分类号: G06F7/00 G06F17/30

    摘要: A method, apparatus and article of manufacture, implementing the method, of determines a target data type in an environment having a plurality of levels. Zero or more intermediate levels are between the source level and the target level. A target data type representing the transformation of a data type of an associated datum as the datum passes from the source level through the zero or more intermediate levels to the target level is generated. In another aspect of the invention, the datum is assigned to the target level in accordance with the target data type. In yet another aspect of the invention, the target data type is passed with the associated datum, via the zero or more intermediate levels to the target level.

    摘要翻译: 实现该方法的方法,装置和制品在具有多个级别的环境中确定目标数据类型。 零级或更多的中间级别在源级别和目标级别之间。 生成表示当基准从源级别通过零个或多个中间级别传递到目标级别时相关联的数据的数据类型的变换的目标数据类型。 在本发明的另一方面,根据目标数据类型将数据分配给目标级别。 在本发明的另一方面,目标数据类型通过相关联的数据经由零个或多个中间级别传递到目标级别。

    System and method for contention-free memory access
    7.
    发明授权
    System and method for contention-free memory access 有权
    无竞争内存访问的系统和方法

    公开(公告)号:US08621160B2

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

    申请号:US13329065

    申请日:2011-12-16

    IPC分类号: G06F12/06 G06F13/376

    摘要: A memory control unit of a turbo code decoder includes a buffer having a plurality of storage slots, a buffer control operatively coupled to the buffer, a router operatively coupled to the buffer control and to a plurality of data sources, and a conflict detection unit operatively coupled to the router, to the buffer control, and to the plurality of data sources. The buffer temporarily stores information intended for storage in a memory bank. The buffer control determines a number of available storage slots in the buffer. The router routes data from the data sources to the buffer control. The conflict detection unit initiates a temporary halt of some of the data sources when the number of available storage slots is insufficient to store all of the data from data sources attempting to access the memory bank.

    摘要翻译: turbo码解码器的存储器控​​制单元包括具有多个存储槽的缓冲器,可操作地耦合到缓冲器的缓冲器控制器,可操作地耦合到缓冲器控制和多个数据源的路由器,以及可操作地与冲突检测单元 耦合到路由器,到缓冲器控制和多个数据源。 缓冲器临时存储用于存储在存储体中的信息。 缓冲器控制确定缓冲器中可用的存储槽数。 路由器将数据源从数据源路由到缓冲区控制。 当可用存储时隙的数量不足以存储尝试访问存储体的数据源的所有数据时,冲突检测单元发起暂时停止某些数据源。

    Lamp control system
    10.
    发明授权
    Lamp control system 失效
    灯控系统

    公开(公告)号:US08324839B2

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

    申请号:US12695162

    申请日:2010-01-28

    申请人: Chin-Long Ku Yang Sun

    发明人: Chin-Long Ku Yang Sun

    IPC分类号: G05F1/00 H05B37/02

    CPC分类号: H05B33/0815 H02J9/06

    摘要: A lamp control system includes a first driving circuit, an assistance DC power source having an output voltage lower than a working voltage of a lamp and a second driving circuit. The first driving circuit electrically connects the lamp with a utility power source to convert an AC power a DC power and supply the DC power to the lamp. The second driving circuit electrically connects the assistance DC power source with the lamp. The second driving circuit includes a boost circuit, which is connected to the assistance DC power source to promote the output voltage of the assistance DC power source to the working voltage of the lamp and then supply electrical power with the promoted voltage to the lamp when the utility power source is off.

    摘要翻译: 灯控制系统包括第一驱动电路,具有低于灯的工作电压的输出电压的辅助DC电源和第二驱动电路。 第一驱动电路将灯与公用电源电连接,以将AC电源转换为DC电力,并将DC电力提供给灯。 第二驱动电路将辅助DC电源与灯电连接。 第二驱动电路包括升压电路,该升压电路连接到辅助DC电源,以将辅助DC电源的输出电压提升到灯的工作电压,然后在升压电压下将提升的电压提供给灯 公用电源关闭。