SQL execution plan baselines
    1.
    发明授权
    SQL execution plan baselines 有权
    SQL执行计划基线

    公开(公告)号:US09189522B2

    公开(公告)日:2015-11-17

    申请号:US12188678

    申请日:2008-08-08

    IPC分类号: G06F7/00 G06F17/00 G06F17/30

    CPC分类号: G06F17/30469 G06F17/30463

    摘要: Approaches, techniques, and mechanisms are disclosed for maintaining a set of baseline query plans for a database command. Except in rare circumstances, a database server may only execute a command according to a baseline plan, even if the database server predicts that a different plan has a lower cost. The set of baseline plans are plans that, for one reason or another, have been determined to provide acceptable actual performance in at least one execution context. When the database server receives a request to execute a particular command, the database server, if possible, always executes the command according to the lowest predicted cost baseline plan. The database server may evolve the plan baseline to include additional plans by generating and testing new plans in response to new requests to execute the database command, or as part of a query optimization or tuning process.

    摘要翻译: 披露了用于维护数据库命令的一组基线查询计划的方法,技术和机制。 除极少数情况下,数据库服务器只能根据基准线执行命令,即使数据库服务器预测不同的计划成本较低。 一组基准计划是由于某种原因决定在至少一个执行环境中提供可接受的实际绩效的计划。 当数据库服务器接收到执行特定命令的请求时,如果可能,数据库服务器总是根据最低预测成本基线计划执行该命令。 数据库服务器可以通过生成和测试新计划以响应执行数据库命令的新请求,或作为查询优化或调整过程的一部分,来演进计划基准以包括额外的计划。

    OPTOISOLATOR LEADFRAME ASSEMBLY
    2.
    发明申请

    公开(公告)号:US20130175679A1

    公开(公告)日:2013-07-11

    申请号:US13783698

    申请日:2013-03-04

    IPC分类号: H01L23/495

    摘要: An optoisolator leadframe assembly includes: an emitter leadframe part including a first rail and a plurality of emitter leadframe units, each rail including two rows of emitter leadframes, each having a die-mounting pad; and a receiver leadframe part including a second rail and a plurality of receiver leadframe units, each including two rows of receiver leadframes, each having a die-mounting pad. The die-mounting pads of the emitter leadframes of each row of each of the emitter leadframe units are respectively aligned with and spaced apart from the die-mounting pads of the receiver leadframes of an adjacent row of an adjacent one of the receiver leadframe units. Each of the emitter and receiver leadframe parts is a single piece.

    摘要翻译: 光隔离器引线框组件包括:发射极引线框部分,包括第一导轨和多个发射极引线框架单元,每个导轨包括两排发射器引线框架,每排具有管芯安装焊盘; 以及包括第二导轨和多个接收器引线框架单元的接收器引线框架部件,每个接收器引线框架单元包括两排接收器引线框架,每一个都具有管芯安装焊盘。 每个发射器引线框架单元的每行的发射器引线框的管芯安装焊盘分别与相邻的一个接收器引线框架单元的相邻行的接收器引线框的管芯安装焊盘对准并间隔开。 每个发射器和接收器引线框架部件都是单件。

    Packaging apparatus for optical-electronic semiconductors
    3.
    发明授权
    Packaging apparatus for optical-electronic semiconductors 有权
    光电子半导体封装设备

    公开(公告)号:US07815836B2

    公开(公告)日:2010-10-19

    申请号:US12155270

    申请日:2008-06-02

    申请人: Cheng-Hong Su

    发明人: Cheng-Hong Su

    IPC分类号: H01L21/52

    摘要: A packaging apparatus for optical-semiconductors includes a mold base having a longitudinal receiving space, an encapsulating module attached to the mold base, and a fixing member attached to the encapsulating module. The bottom of the mold base has at least one air-vent and the mold base has a predetermined width. The encapsulating module includes a plate engaged with the mold base, a plurality of molding bodies penetrating the plate and received in the receiving space, and a plurality of supporting members connected to the molding bodies. The fixing member has a plurality of holding slots to hold the supporting members so that the supporting members are more stable. Furthermore, the width of the mold base is optimized with the dimension of a furnace so that the production rate is increased and the stability of the packaging structure is improved.

    摘要翻译: 一种用于光半导体的包装设备包括:具有纵向容纳空间的模具基座,附接到模具基座的封装模块以​​及附着于封装模块的固定构件。 模具底座的底部具有至少一个排气孔,并且模具底座具有预定的宽度。 封装模块包括与模具基座接合的板,穿过板并容纳在接收空间中的多个模制体以及连接到模制体的多个支撑构件。 固定构件具有多个保持槽以保持支撑构件,使得支撑构件更稳定。 此外,通过炉的尺寸优化模座的宽度,从而提高生产率,提高包装结构的稳定性。

    Lead frame module for manufacturing light emitting diodes
    4.
    发明申请
    Lead frame module for manufacturing light emitting diodes 有权
    用于制造发光二极管的引线框架模块

    公开(公告)号:US20090244875A1

    公开(公告)日:2009-10-01

    申请号:US12230194

    申请日:2008-08-26

    申请人: Cheng-Hong Su

    发明人: Cheng-Hong Su

    IPC分类号: H05K7/18

    摘要: A lead frame module integrally formed from a single thin metal sheet includes: parallel first and second rails extending in a first direction; and first and second lead frame sets connected to the first and second rails, respectively. The first and second lead frame sets respectively include a plurality of lead frames extending in a second direction perpendicular to the first direction. Each of the lead frames of the first and second lead frame sets has a pair of connecting leads and a pair of packaging leads. Each of the packaging leads is connected to a respective one of the connecting leads. The connecting leads of the lead frames of the first lead frame set are interdigitated with and are connected to the connecting leads of the lead frames of the second lead frame set.

    摘要翻译: 由单个薄金属片一体形成的引线框架模块包括:沿第一方向延伸的平行的第一和第二轨道; 以及分别连接到第一和第二轨道的第一和第二引线框组。 第一和第二引线框组分别包括沿垂直于第一方向的第二方向延伸的多个引线框架。 第一和第二引线框架组的每个引线框架具有一对连接引线和一对封装引线。 每个包装引线连接到相应的一个连接引线。 第一引线框架组的引线框架的连接引线与第二引线框组的引线框架的连接引线相互连接并连接。

    Packaging apparatus for optical-electronic semiconductors and a packaging method therefor
    5.
    发明申请
    Packaging apparatus for optical-electronic semiconductors and a packaging method therefor 有权
    光电半导体用包装装置及其封装方法

    公开(公告)号:US20090152712A1

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

    申请号:US12155270

    申请日:2008-06-02

    申请人: Cheng-Hong Su

    发明人: Cheng-Hong Su

    IPC分类号: H01L23/34

    摘要: A packaging apparatus for optical-semiconductors includes a mold base having a longitudinal receiving space, an encapsulating module attached to the mold base, and a fixing member attached to the encapsulating module. The bottom of the mold base has at least one air-vent and the mold base has a predetermined width. The encapsulating module includes a plate engaged with the mold base, a plurality of molding bodies penetrating the plate and received in the receiving space, and a plurality of supporting members connected to the molding bodies. The fixing member has a plurality of holding slots to hold the supporting members so that the supporting members are more stable. Furthermore, the width of the mold base is optimized with the dimension of a furnace so that the production rate is increased and the stability of the packaging structure is improved.

    摘要翻译: 一种用于光半导体的包装设备包括:具有纵向容纳空间的模具基座,附接到模具基座的封装模块以​​及附着于封装模块的固定构件。 模具底座的底部具有至少一个排气孔,并且模具底座具有预定的宽度。 封装模块包括与模具基座接合的板,穿过板并容纳在接收空间中的多个模制体以及连接到模制体的多个支撑构件。 固定构件具有多个保持槽以保持支撑构件,使得支撑构件更稳定。 此外,通过炉的尺寸优化模座的宽度,从而提高生产率,提高包装结构的稳定性。

    Approximating a database statistic
    6.
    发明申请
    Approximating a database statistic 有权
    近似数据库统计

    公开(公告)号:US20080120274A1

    公开(公告)日:2008-05-22

    申请号:US11796102

    申请日:2007-04-25

    IPC分类号: G06F7/00

    摘要: A method and apparatus for approximating a database statistic, such as the number of distinct values (NDV) is provided. To approximate the NDV for a portion of a table, a synopsis of distinct values is constructed. Each value in the portion is mapped to a domain of values. The mapping function is implemented with a uniform hash function, in one embodiment. If the resultant domain value does not exist in the synopsis, the domain value is added to the synopsis. If the synopsis reaches its capacity, a portion of the domain values are discarded from the synopsis. The statistic is approximated based on the number (N) of domain values in the synopsis and the portion of the domain that is represented in the synopsis relative to the size of the domain.

    摘要翻译: 提供了用于近似数据库统计量的方法和装置,例如不同值(NDV)的数量。 为了近似表的一部分的NDV,构建了不同值的概要。 该部分中的每个值都映射到值的域。 在一个实施例中,映射功能是用均匀散列函数实现的。 如果在概要中不存在结果域值,则将域值添加到概要中。 如果概要达到其容量,则域值的一部分将从摘要中被丢弃。 统计量基于概要中的域值的数量(N)和在概要中相对于域的大小表示的域的部分近似。

    Efficient search space analysis for join factorization
    7.
    发明申请
    Efficient search space analysis for join factorization 有权
    用于连接分解的高效搜索空间分析

    公开(公告)号:US20070219977A1

    公开(公告)日:2007-09-20

    申请号:US11716107

    申请日:2007-03-08

    IPC分类号: G06F17/30

    摘要: Under a type of query transformation referred to herein as join factorization, the branches of an UNION/UNION ALL query that join a common table are combined to reduce accesses to the common table. The transformation can be expressed as (T1 join T2) union all (T1 join T3)=T1 join (T2 union all T3), where T1, T2 and T3 are three tables. A given query may be rewritten in many alternate ways using join factorization. Evaluating each alternative can be expensive. Therefore, the alternatives are generated and evaluated in a way that minimizes the cost of evaluating the alternatives.

    摘要翻译: 在这里称为连接因式分解的一种类型的查询变换中,加入公共表的UNION / UNION ALL查询的分支被组合以减少对公共表的访问。 转换可以表示为(T 1连接T 2)联合全部(T 1连接T 3)= T 1连接(T 2并联全部T 3),其中T 1,T 2和T 3是三个表。 给定的查询可以使用连接因式分解以许多替代方式重写。 评估每个替代品可能是昂贵的。 因此,以最小化评估替代品的成本的方式生成和评估替代方案。

    Gravity sensor
    8.
    发明申请
    Gravity sensor 失效
    重力传感器

    公开(公告)号:US20050270520A1

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

    申请号:US10861386

    申请日:2004-06-07

    CPC分类号: G01C9/12 G01C2009/066

    摘要: A gravity sensor has a photo interrupter and a gravity wheel. The photo interrupter has a housing, a cavity in the housing, a light emitter on one side of the housing and a light detector on the other side of the housing. The gravity wheel points in a direction of gravity and has a pivot at center thereof and pivotally arranged on the housing, a plumb at one edge of the gravity wheel and a plurality of through holes annularly arranged in the gravity wheel. The gravity wheel has a portion present in the cavity. An inclined angle of a test object is determined by calculating relative movement between the photo interrupter and the gravity wheel.

    摘要翻译: 重力传感器具有光电断路器和重力轮。 光电断路器具有壳体,壳体中的空腔,壳体一侧上的光发射器和壳体另一侧上的光检测器。 重力轮指向重力方向并且在其中心处具有枢轴并且枢转地布置在壳体上,在重力轮的一个边缘处具有铅垂,并且多个通孔环形地布置在重力轮中。 重力轮具有存在于空腔中的部分。 通过计算光断续器和重力轮之间的相对运动来确定测试对象的倾斜角度。