利索-全球专利检索

  1. 登录
  2. 注册

搜索结果

38 条记录 (耗时 0.026 秒)

    STATIC QUERY OPTIMIZATION
    1.
    发明申请
    STATIC QUERY OPTIMIZATION 有权
    静态查询优化

    公开(公告)号：US20110320435A1

    公开(公告)日：2011-12-29

    申请号：US13167498

    申请日：2011-06-23

    申请人： Jesse Collins ,  Jaikumar Bathija ,  John F. O'Brien

    发明人： Jesse Collins ,  Jaikumar Bathija ,  John F. O'Brien

    IPC分类号： G06F17/30

    CPC分类号： G06F17/30463 ,  G06F17/30442 ,  G06F17/30536

    摘要： In some embodiments, a computer-implemented method for tuning queries for a multi-tenant database system is provided. A processor retrieves actual statistics associated with data stored on one or more servers in the multi-tenant database system. The data may be associated with one or more tenants of the multi-tenant database system. A subset of the actual statistics is selected, wherein the subset of the actual statistics is related to tenants having a data trait targeted for optimization. The processor determines synthetic statistics based on the subset of the actual statistics. An original query is received at the multi-tenant database system, wherein the original query operates upon data associated with a tenant that has the data trait targeted for optimization. The processor determines an optimal query plan based on the original query and synthetic statistics. Finally, the processor executes the original query based on the optimal query plan.

    摘要翻译： 在一些实施例中，提供了一种用于调整多承租人数据库系统的查询的计算机实现的方法。 处理器检索与存储在多租户数据库系统中的一个或多个服务器上的数据相关联的实际统计信息。 数据可以与多租户数据库系统的一个或多个租户相关联。 选择实际统计的子集，其中实际统计的子集与具有针对优化的数据特征的租户相关。 处理器根据实际统计的子集确定合成统计。 在多租户数据库系统处接收原始查询，其中原始查询根据与具有针对优化的数据特征的租户相关联的数据进行操作。 处理器根据原始查询和综合统计信息确定最优查询计划。 最后，处理器根据最优查询计划执行原始查询。

    Static query optimization
    2.
    发明授权
    Static query optimization 有权
    静态查询优化

    公开(公告)号：US09251204B2

    公开(公告)日：2016-02-02

    申请号：US13167498

    申请日：2011-06-23

    申请人： Jesse Collins ,  Jaikumar Bathija ,  John F. O'Brien

    发明人： Jesse Collins ,  Jaikumar Bathija ,  John F. O'Brien

    IPC分类号： G06F17/30

    CPC分类号： G06F17/30463 ,  G06F17/30442 ,  G06F17/30536

    摘要： In some embodiments, a computer-implemented method for tuning queries for a multi-tenant database system is provided. A processor retrieves actual statistics associated with data stored on one or more servers in the multi-tenant database system. The data may be associated with one or more tenants of the multi-tenant database system. A subset of the actual statistics is selected, wherein the subset of the actual statistics is related to tenants having a data trait targeted for optimization. The processor determines synthetic statistics based on the subset of the actual statistics. An original query is received at the multi-tenant database system, wherein the original query operates upon data associated with a tenant that has the data trait targeted for optimization. The processor determines an optimal query plan based on the original query and synthetic statistics. Finally, the processor executes the original query based on the optimal query plan.

    摘要翻译： 在一些实施例中，提供了一种用于调整多承租人数据库系统的查询的计算机实现的方法。 处理器检索与存储在多租户数据库系统中的一个或多个服务器上的数据相关联的实际统计信息。 数据可以与多租户数据库系统的一个或多个租户相关联。 选择实际统计的子集，其中实际统计的子集与具有针对优化的数据特征的租户相关。 处理器根据实际统计的子集确定合成统计。 在多租户数据库系统处接收原始查询，其中原始查询根据与具有针对优化的数据特征的租户相关联的数据进行操作。 处理器根据原始查询和综合统计信息确定最优查询计划。 最后，处理器根据最优查询计划执行原始查询。

    Methods and Systems for Providing Multiple Column Custom Indexes In A Multi-Tenant Database Environment
    3.
    发明申请
    Methods and Systems for Providing Multiple Column Custom Indexes In A Multi-Tenant Database Environment 审中-公开
    在多租户数据库环境中提供多列自定义索引的方法和系统

    公开(公告)号：US20110289091A1

    公开(公告)日：2011-11-24

    申请号：US12897276

    申请日：2010-10-04

    申请人： Jesse Collins ,  Simon Y. Wong ,  Jaikumar Bathija ,  John F. O'Brien

    发明人： Jesse Collins ,  Simon Y. Wong ,  Jaikumar Bathija ,  John F. O'Brien

    IPC分类号： G06F17/30

    CPC分类号： G06Q10/10 ,  G06F16/2228

    摘要： In accordance with embodiments, there are provided methods and systems for providing multiple column custom indexes in a multi-tenant database environment. A method embodiment provides defining a multi-tenant data structure having a plurality of data columns data fields and a plurality of rows for each of multiple tenants, each row including a data column for a tenant identifier, defining a first data field for a tenant, the first data field having a first data type, defining a second data field for the tenant, the second field having a second data type, and defining an index table including a tenant identifier for the tenant, a copy of data from the first data field and the second data field, and a key to the corresponding rows of the multi-tenant data structure.

    摘要翻译： 根据实施例，提供了用于在多租户数据库环境中提供多个列自定义索引的方法和系统。 方法实施例提供了一种多租户数据结构，其具有多个数据列数据字段和多个租户中的每一个的多个行，每行包括为租户定义第一数据字段的租户标识符的数据列， 所述第一数据字段具有第一数据类型，为所述租户定义第二数据字段，所述第二字段具有第二数据类型，并且定义包括所述租户的租户标识符的索引表，来自所述第一数据字段的数据副本 和第二数据字段，以及多租户数据结构的相应行的密钥。

    Methods and Systems for Validating Queries in a Multi-Tenant Database Environment
    4.
    发明申请
    Methods and Systems for Validating Queries in a Multi-Tenant Database Environment 审中-公开
    在多租户数据库环境中验证查询的方法和系统

    公开(公告)号：US20110282847A1

    公开(公告)日：2011-11-17

    申请号：US12897228

    申请日：2010-10-04

    申请人： Jesse Collins ,  Matthew Peterson ,  John F. O'Brien

    发明人： Jesse Collins ,  Matthew Peterson ,  John F. O'Brien

    IPC分类号： G06F17/30

    CPC分类号： G06F16/2455

    摘要： In accordance with embodiments, there are provided mechanisms and methods for validating queries. These mechanisms and methods for validating queries can enable embodiments to provide more reliable and faster execution of queries both in development and in production. In an embodiment and by way of example, a method for validating queries is provided. The method embodiment includes capturing a query that is directed to a multi-tenant database. A plan is determined by which the query will be applied to the database. The plan is statically analyzed for performance. Then a performance measure is applied to the query.

    摘要翻译： 根据实施例，提供了用于验证查询的机制和方法。 用于验证查询的这些机制和方法可以使得实施例能够在开发和生产中提供更可靠和更快速的查询执行。 在一个实施例中，作为示例，提供了用于验证查询的方法。 方法实施例包括捕获指向多租户数据库的查询。 确定哪个查询将应用于数据库的计划。 该计划被静态分析以获得性能。 然后将性能度量应用于查询。

    FUEL CELL ASSEMBLY
    5.
    发明申请
    FUEL CELL ASSEMBLY 审中-公开
    燃油电池组件

    公开(公告)号：US20100304233A1

    公开(公告)日：2010-12-02

    申请号：US12473561

    申请日：2009-05-28

    申请人： Mohinder S. Bhatti ,  John F. O'Brien ,  Ilya Reyzin

    发明人： Mohinder S. Bhatti ,  John F. O'Brien ,  Ilya Reyzin

    IPC分类号： H01M8/04

    CPC分类号： H01M8/04164 ,  H01M2008/1095

    摘要： A fuel cell assembly for using hydrogen gas and oxygen to produce electrical energy. The cathode of the fuel cell produces water vapor to define a flow of moist air including water vapor. A dehumidifier receives the flow of moist air including water vapor to produce purified liquid water and a flow of dehumidified air. The dehumidifier has an air inlet having a first cross-sectional area and an air outlet having a larger second cross-sectional area. The diffuser cavity of the dehumidifier progressively increases in size from the air inlet to the air outlet for depressurizing and cooling the flow of moist air including water vapor below the dew point of the moist air including water vapor to condense the water vapor on the housing of the dehumidifier.

    摘要翻译： 一种用于使用氢气和氧气产生电能的燃料电池组件。 燃料电池的阴极产生水蒸气以限定包括水蒸汽的潮湿空气流。 除湿器接收包括水蒸汽在内的潮湿空气流，以产生净化的液体水和除湿空气流。 除湿器具有具有第一横截面积的空气入口和具有较大第二横截面积的空气出口。 除湿机的扩散腔从空气入口到空气出口的尺寸逐渐增大，用于减压和冷却包括水蒸汽在内的湿蒸气低于包括水蒸汽的露点的潮湿空气流，以将壳体上的水蒸气冷凝 除湿机

    Bar code scanner with asterisk scan pattern
    7.
    发明授权
    Bar code scanner with asterisk scan pattern 失效
    条码扫描器带星号扫描图案

    公开(公告)号：US4939356A

    公开(公告)日：1990-07-03

    申请号：US346434

    申请日：1989-05-02

    申请人： Joseph F. Rando ,  H. Nick Roberts ,  John F. O'Brien

    发明人： Joseph F. Rando ,  H. Nick Roberts ,  John F. O'Brien

    IPC分类号： G06K7/10

    CPC分类号： G06K7/10871 ,  G06K7/10693

    摘要： A bar code scanner which preferably generates an asterisk-like scan pattern has a scanner head at the end of a flexible mount enabling operator personnel to orient the scanner head in virtually any position and direction. The scan pattern generator is compact in size, utilizing a laser diode as a source, so that the scan head is easily manipulated to the desired position. In preferred embodiments the scanning mechanism generates the asterisk scan pattern with a rotating mirror or mirrors and a series of peripheral mirrors or lenses, one for each scan line, in an efficient and compact arrangement. The entire asterisk scan pattern may be constantly rotated at a relatively slow rate, so that bar code labels are more likely to be read without deliberate orientation by the operator, particularly in the case of bar codes of high aspect ratio.

    摘要翻译： 优选地生成星号状扫描图案的条形码扫描器在柔性安装座的端部具有扫描器头，使得操作人员能够将扫描头位于几乎任何位置和方向上。 扫描图案发生器的尺寸紧凑，利用激光二极管作为源，使得扫描头容易被操纵到期望的位置。 在优选实施例中，扫描机构以有效和紧凑的布置为旋转镜或反射镜和一系列周边镜或透镜（每个扫描线一个）生成星号扫描图案。 整个星号扫描图案可以以相对较慢的速率不断地旋转，使得条形码标签更容易被读取，而无需操作者的有意识的取向，特别是在高纵横比的条形码的情况下。

    Book desk
    8.
    发明授权
    Book desk 失效
    书桌

    公开(公告)号：US4033652A

    公开(公告)日：1977-07-05

    申请号：US638296

    申请日：1975-12-08

    申请人： John F. O'Brien

    发明人： John F. O'Brien

    IPC分类号： A47B23/02 ,  A47B63/00

    CPC分类号： A47B23/02

    摘要： A book, such as a loose-leaf binder, containing pages for writing thereon, has a rigid back cover with a hanger at the top edge thereof, and an underlying prop flap hinged to the bottom edge thereof and providing a free edge for engaging a wall, door or the like upstanding support surface to hold the book in a desk simulating position when the hanger is suspended from the surface to thereby present the pages in a comfortable writing position. The hanger is preferably an elongated downwardly opening channel strip secured along the top edge of the back cover to mate with an upwardly opening channel strip secured on the door, wall or the like. The book preferably has a rigid front cover which is also equipped with a similar downwardly opening channel strip to mate in the door or wall mounted strip thereby holding the book in rigid opened position so that both sides of pages may be presented for writing. A second prop flap on the front cover is not necessary.The book desk is especially useful in the form of a loose-leaf ring binder serving as a patient's record book in hospitals where the book may be kept in a patient's supply cabinet in the patient's room and easily and quickly mounted on a door of the cabinet to provide a desk for use by the doctor or other hospital personnel in entering records. The pages are removed from the binder to form a permanent hospital record when the patient is discharged and the binder is then available for the records of successive patients occupying the room.

    摘要翻译： 一本书，例如包含用于书写的页面的活页夹，具有在其顶部边缘处具有衣架的刚性后盖，以及铰接到其底部边缘的下面的支撑折板，并提供用于接合的自由边缘 墙壁，门或类似物的直立支撑表面，以便当衣架悬挂在表面上时将书本保持在桌面模拟位置，从而将书页放置在舒适的书写位置。 衣架优选地是沿着后盖的顶部边缘固定的细长的向下开口的通道条，以与固定在门，壁或类似物上的向上开口的通道条配合。 该书优选地具有刚性的前盖，其还装备有类似的向下开口的通道条，以在门或墙壁安装的条带中配合，从而将书保持在刚性打开位置，使得页面的两侧可以呈现为书写。 前盖上的第二个支架挡板是不必要的。