Method, computer program product, and system for pushdown analysis during query plan generation
    1.
    发明授权
    Method, computer program product, and system for pushdown analysis during query plan generation 有权
    方法,计算机程序产品和查询计划生成期间下推分析系统

    公开(公告)号:US06615203B1

    公开(公告)日:2003-09-02

    申请号:US09466560

    申请日:1999-12-17

    IPC分类号: G06F1730

    摘要: A method, computer product, and system for pushdown analysis during query plan generation is provided. Rather than do pushdown analysis for portions of a query that are query execution plan independent, the present invention provides pushdown analysis for features of a query that are plan dependent. This is done by evaluating a portion of the query plan for pushdownability to a remote database system; and if pushdownable to the remote database system, generating cost parameters for the portion of the plan if executed at a local database system and if executed at the remote database system. With both sets of cost parameters, the query optimizer has added information on which to select an optimal query plan.

    摘要翻译: 提供了一种查询计划生成过程中用于下推分析的方法,计算机产品和系统。 本发明不是针对不依赖于查询执行计划的查询的部分进行下推分析,而是针对依赖于计划的查询的特征提供下推分析。 这可以通过评估查询计划的一部分来实现对远程数据库系统的可推延性; 并且如果可以向远端数据库系统推送,则在本地数据库系统上执行并且如果在远程数据库系统上执行,则为计划的该部分生成成本参数。 使用两组成本参数,查询优化器添加了选择最佳查询计划的信息。

    Method, computer program product, and system for rewriting database queries in a heterogenous environment
    2.
    发明授权
    Method, computer program product, and system for rewriting database queries in a heterogenous environment 失效
    方法,计算机程序产品和用于在异构环境中重写数据库查询的系统

    公开(公告)号:US06526403B1

    公开(公告)日:2003-02-25

    申请号:US09466492

    申请日:1999-12-17

    IPC分类号: G06F1730

    摘要: A method, computer product, and system for rewriting database without decreasing pushdownability is provided. First, a pushdown analysis of the query in its entirety is performed prior to the application of any query rewrite rules in order to establish a baseline on pushdownability for the query. The results of this analysis is stored with the internal query representation. After each rule is applied to rewrite a portion of a query, that rewritten portion is analyzed again for pushdownability. If pushdownability is not decreased, then the rewritten query remains and the internal representation of the query is updated to reflect the pushdownability of that portion. If pushdownability is decreased, then an undo operation is applied to the rewritten portion of the query to back out the effects of the rule and leave the query in the same state as before the rewrite. Finally, additional rewrite rules that are directed to the heterogeneous database environment are also provided.

    摘要翻译: 提供了一种用于重写数据库而不降低可压缩性的方法,计算机产品和系统。 首先,在应用任何查询重写规则之前执行整个查询的下推分析,以便建立查询的可推式性的基线。 该分析的结果与内部查询表示一起存储。 每个规则应用于重写查询的一部分后,再次分析重写的部分以进行推测。 如果下推性不降低,则重写的查询将保留,并更新查询的内部表示形式,以反映该部分的可推移性。 如果可压缩性降低,则对查询的重写部分应用撤消操作,以排除规则的影响,并使查询处于与重写前相同的状态。 最后,还提供了针对异构数据库环境的其他重写规则。

    Fixing device and backlight module using the fixing device
    3.
    发明授权
    Fixing device and backlight module using the fixing device 有权
    固定装置和背光模块使用固定装置

    公开(公告)号:US09010950B2

    公开(公告)日:2015-04-21

    申请号:US13380882

    申请日:2011-12-16

    申请人: Tian Zhang

    发明人: Tian Zhang

    IPC分类号: G09F13/04 G09F13/08 H05K7/00

    摘要: Disclosed are a fixing device and a backlight module using the fixing device. The fixing device includes a positioning post, an embedded part, and at least one elastic part. The embedded part is vertically inserted in the positioning post. The at least one elastic part is disposed at one end of the positioning post. The fixing device of the present invention is capable of enhancing the structure and functions to position accurately. Furthermore, the elastic part is capable of decreasing shocks at the fixed position of the fixing device and improving the problem of stress concentration.

    摘要翻译: 公开了使用定影装置的定影装置和背光模块。 定影装置包括定位柱,嵌入部和至少一个弹性部。 嵌入部分垂直插入定位柱。 所述至少一个弹性部件设置在所述定位柱的一端。 本发明的定影装置能够提高精确定位的结构和功能。 此外,弹性部件能够减小定影装置的固定位置的冲击,改善应力集中的问题。

    Light bar fixing device and helical spring
    4.
    发明授权
    Light bar fixing device and helical spring 有权
    灯杆固定装置和螺旋弹簧

    公开(公告)号:US08757859B2

    公开(公告)日:2014-06-24

    申请号:US13377538

    申请日:2011-09-17

    申请人: Tian Zhang

    发明人: Tian Zhang

    IPC分类号: F21V7/04

    摘要: A light bar fixing device comprises a light bar defining a through-hole and a heat dissipation mechanism defining a threaded hole corresponding to the through-hole. The light bar fixing device further comprises a helical spring having a pitch identical to that of the threaded hole. A columnar body of the helical spring is adapted to be threaded into the threaded hole, and an outer diameter of a stop end of the helical spring is greater than that of the columnar body. By threading the helical spring into the threaded hole, the light bar can be securely connected to the heat dissipation mechanism with a clearance therebetween being reduced. Also, the light bar can dissipate heat evenly via the heat dissipation mechanism to allow a uniform temperature distribution in the light bar, thus resulting in a desirable light emitting effect and a prolonged service life of the light bar.

    摘要翻译: 光条固定装置包括限定通孔的灯条和限定与通孔对应的螺纹孔的散热机构。 灯条固定装置还包括具有与螺纹孔相同的间距的螺旋弹簧。 螺旋弹簧的柱状体适于螺纹连接到螺纹孔中,并且螺旋弹簧的止动端的外径大于柱状体的外径。 通过将螺旋弹簧螺纹连接到螺纹孔中,灯杆可以牢固地连接到散热机构,其间的间隙减小。 此外,灯条可以通过散热机构均匀地散发热量,以允许光棒中的均匀的温度分布,从而导致期望的发光效果和光棒的延长的使用寿命。

    LIGHT GUIDE PLATE AND BACKLIGHT MODULE
    5.
    发明申请
    LIGHT GUIDE PLATE AND BACKLIGHT MODULE 审中-公开
    光导板和背光模组

    公开(公告)号:US20130063965A1

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

    申请号:US13379656

    申请日:2011-10-31

    申请人: Tian Zhang

    发明人: Tian Zhang

    IPC分类号: G09F13/18 F21V7/05

    摘要: A light guide plate is disclosed which comprises a bottom surface and a reflective layer. The bottom surface is formed with a plurality of mesh points, and a density of the mesh points increases with a distance from a light source. The reflective layer is a sputtered film formed on the bottom surface. A corresponding backlight module is further disclosed. The light guide plate and other components of the backlight module can be pushed into the backplate from a side, so they are easy to be assembled, thus improving the yield of the backlight module.

    摘要翻译: 公开了一种导光板,其包括底表面和反射层。 底面形成有多个网点,网眼的密度随着距离光源的距离而增加。 反射层是在底面上形成的溅射膜。 进一步公开了相应的背光模块。 背光模块的导光板和其他部件可以从侧面推入背板,因此易于组装,从而提高背光模块的产量。

    Nested sector gears
    6.
    发明授权
    Nested sector gears 有权
    嵌套扇形齿轮

    公开(公告)号:US07096754B2

    公开(公告)日:2006-08-29

    申请号:US10471219

    申请日:2002-03-06

    申请人: Tian Zhang

    发明人: Tian Zhang

    IPC分类号: F16H55/17

    摘要: A sector gear is formed as one of a pair of mirror image gears (12, 14). Each of the sector gears has an arcuate portion (16) having a series of teeth (18) on an outer periphery thereof, and a V-shaped base portion (20) having a first leg (22), a second leg (24) and an apex portion (26). The first leg (22) has an S-shaped configuration and connects with the arcuate portion (16) at a first end thereof. The second leg (24) has an inverted S-shape and connects with the arcuate portion (16) near an arcuate mid-length of the arcuate portion (16). The first leg (22) and second leg (24) merge smoothly with the apex portion (26). The apex portion (26) has an aperture (30) at a radial center of the arcuate portion (16). Each of the gears has an inner periphery (28) that enables complementary nesting of the pair of sector gears (12, 14).

    摘要翻译: 扇形齿轮形成为一对镜像齿轮(12,14)中的一个。 每个扇形齿轮具有在其外周上具有一系列齿(18)的弓形部分(16)和具有第一腿部(22),第二腿部(24)的V形基部(20) 和顶点部分(26)。 第一腿部(22)具有S形构造并且在其第一端处与弓形部分(16)连接。 第二腿部(24)具有倒置的S形并且与弓形部分(16)的弧形中长度附近的弓形部分(16)连接。 第一腿部(22)和第二腿部(24)与顶部部分(26)平滑地合并。 顶点部分(26)在弧形部分(16)的径向中心处具有孔(30)。 每个齿轮具有能够使所述一对扇形齿轮(12,14)互补嵌套的内周边(28)。

    Structure and method to enhance field emission in field emitter device
    7.
    发明授权
    Structure and method to enhance field emission in field emitter device 失效
    在场发射器件中增强场发射的结构和方法

    公开(公告)号:US06692323B1

    公开(公告)日:2004-02-17

    申请号:US09483409

    申请日:2000-01-14

    IPC分类号: H01J902

    摘要: A structure and method are provided to inhibit degradation to the electron beam of a field emitter device by coating the field emitter tip with a substance or a compound. The substance or compound acts in the presence of outgassing to inhibit such degradation. In one embodiment, the substance or compound coating the field emitter tip is stable in the presence of outgassing. In another embodiment, the substance or compound decomposes at least one matter in the outgassing. In yet another embodiment, the substance or compound neutralizes at least one matter in the outgassing. In a further embodiment, the substance or compound brings about a catalysis in the presence of outgassing.

    摘要翻译: 提供了一种结构和方法,通过用物质或化合物涂覆场致发射极尖端来抑制场发射器件的电子束的劣化。 物质或化合物在除气的作用下起作用以抑制这种降解。 在一个实施方案中,涂覆场发射器尖端的物质或化合物在除气的存在下是稳定的。 在另一个实施方案中,物质或化合物在除气中分解至少一种物质。 在另一个实施方案中,物质或化合物在除气中中和至少一种物质。 在另一个实施方案中,物质或化合物在除气的存在下引起催化。

    HEAT DISSIPATION SUBSTRATE AND METHOD FOR MANUFACTURING THE SAME
    9.
    发明申请
    HEAT DISSIPATION SUBSTRATE AND METHOD FOR MANUFACTURING THE SAME 有权
    散热基板及其制造方法

    公开(公告)号:US20130248143A1

    公开(公告)日:2013-09-26

    申请号:US13519261

    申请日:2012-04-18

    申请人: Tian Zhang

    发明人: Tian Zhang

    IPC分类号: F28F3/04 B05D3/02

    摘要: A heat dissipation substrate comprises a substrate material and a heat conductive liquid. The substrate material comprises a plurality of holes and the heat conductive liquid is permeated into the holes. The thermal expansion coefficient of the heat conductive liquid is larger than that of the substrate material. A heat dissipation substrate manufacturing method comprises steps of mixing a sinter powder and an adhesive to form a substrate material; placing the substrate material into a furnace to perform a sintering process in order to form a plurality of holes in the substrate material; and permeating a heat conductive liquid into the holes.

    摘要翻译: 散热基板包括基板材料和导热液体。 基板材料包括多个孔,并且导热液体渗入孔中。 导热液体的热膨胀系数大于基板材料的热膨胀系数。 散热基板的制造方法包括以下步骤:将烧结粉末和粘合剂混合以形成基材; 将基板材料放入炉中进行烧结处理,以在基板材料中形成多个孔; 并将导热液渗透到孔中。

    Backlight module and lamp installation device thereof
    10.
    发明授权
    Backlight module and lamp installation device thereof 有权
    背光模块及其灯安装装置

    公开(公告)号:US08485677B2

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

    申请号:US12991706

    申请日:2010-08-18

    申请人: Tian Zhang

    发明人: Tian Zhang

    IPC分类号: G09F13/04

    摘要: The present invention provides a backlight module and a lamp installation device thereof. The backlight module comprises a plurality of lamps therein, and two ends of each of the lamps are clamped, positioned and electrically connected to one of the lamp installation devices, respectively. Each of the lamp installation devices comprises: a mounting end, a lamp clamping portion and an elastic conductive plate. The mounting end is used to mount the lamp installation device on the backlight module; the lamp clamping portion has a pair of elastic clamping plates for engaging with one end of the lamp; and the elastic conductive plate is electrically connected to a terminal of the end of the lamp. The manufacture cost of the lamp installation device of the present invention is relatively low and the installation thereof is simple, while the lamp also can provide a better impact resistance.

    摘要翻译: 本发明提供一种背光模块及其灯安装装置。 背光模块包括多个灯,并且每个灯的两端分别被夹持,定位并电连接到灯安装装置之一。 每个灯安装装置包括:安装端,灯夹持部分和弹性导电板。 安装端用于将灯安装装置安装在背光模组上; 灯具夹持部分具有用于与灯的一端接合的一对弹性夹板; 并且弹性导电板电连接到灯的端部的端子。 本发明的灯安装装置的制造成本相对较低,并且其安装简单,而灯也可以提供更好的抗冲击性。