Plate and riveted stud assembly
    2.
    发明授权
    Plate and riveted stud assembly 失效
    板和铆钉螺栓组件

    公开(公告)号:US5690459A

    公开(公告)日:1997-11-25

    申请号:US654629

    申请日:1996-05-29

    IPC分类号: F16B17/00 F16B7/00 F16B19/06

    摘要: An assembly for forming a joint includes a stud joined to a plate. The stud includes a shank portion and a stem portion which extends from one end of the shank portion. The stem portion has a multi-lobular configuration thereon which is formed from a plurality of rounded lobes, each pair of lobes being interconnected to each other by a rounded flute. The plate has an aperture therethrough which has a multi-lobular configuration thereon which corresponds in shape to the multi-lobular configuration of the stem portion. To form the joint, the stem portion is inserted through the aperture such that a portion of the stem portion extends beyond the upper surface of the plate. The extending portion is then riveted to the plate to cause the extending portion to deform and uniformly expand to form a bloom or head and to secure the stud to the plate. The stem portion expands within the aperture to fully fill the aperture when the extending portion is being deformed. The extending portion can be riveted to the plate by orbital riveting, by radial riveting or by direct blow riveting.

    摘要翻译: 用于形成接头的组件包括连接到板的螺柱。 螺柱包括柄部和从柄部的一端延伸的杆部。 杆部分在其上具有多小叶构造,其由多个圆形突起形成,每对裂片通过圆形凹槽相互连接。 板具有穿过其中的孔,其上具有多小叶构造,其形状对应于茎部的多小叶构型。 为了形成接头,杆部通过孔插入,使得杆部的一部分延伸超过板的上表面。 然后将延伸部分铆接到板上,使得延伸部分变形并均匀地膨胀以形成花纹或头部,并将钉固定到板上。 当所述延伸部分变形时,所述杆部分在所述孔内扩张以完全填充所述孔。 延伸部分可以通过轨道铆接,径向铆接或直接吹制铆接铆接到板上。

    Method for loading rows into a database table while enforcing constraints
    4.
    发明授权
    Method for loading rows into a database table while enforcing constraints 失效
    在执行约束时将行加载到数据库表中的方法

    公开(公告)号:US06427143B1

    公开(公告)日:2002-07-30

    申请号:US09058754

    申请日:1998-04-10

    IPC分类号: G06F1730

    摘要: Data to be loaded into a table of a database is read from an input file by a LOAD utility including a CHECK subutility that performs constraint checking on each row prior to loading the row into the table. During initialization of the CHECK subutility, the DB2 catalog is read to identify any constraints that apply to the data to be loaded. If any check constraints apply, check constraint routines are built and compiled by the CHECK subutility. If any referential integrity constraints apply, the key values for the parent index of each referential integrity constraint are read and stored in an additional dataspace allocated by the CHECK subutility so that the foreign key values from each row to be loaded can be located by the CHECK subutility and compared against the parent index values prior to loading the data into the table. When the constraint checking for the loading of data is complete, the additional dataspace allocated by the CHECK subutility is released.

    摘要翻译: 要加载到数据库表中的数据由LOAD实用程序从输入文件中读取,该实用程序包括在将行加载到表中之前对每一行执行约束检查的CHECK子实体。 在CHECK子实体初始化期间,读取DB2目录以识别适用于要加载的数据的任何约束。 如果有任何检查约束适用,检查约束例程由CHECK子实体构建和编译。 如果适用任何引用完整性约束,则每个引用完整性约束的父索引的关键值将被读取并存储在由CHECK子实体分配的附加数据空间中,以便可以由CHECK找到要加载的每行的外键值 子系统,并在将数据加载到表格之前与父索引值进行比较。 当数据加载的约束检查完成时,CHECK子系统分配的附加数据空间被释放。