利索-全球专利检索

  1. 登录
  2. 注册

搜索结果

75 条记录 (耗时 0.04 秒)

    Query generator
    1.
    发明申请
    Query generator 有权
    查询生成器

    公开(公告)号：US20060271529A1

    公开(公告)日：2006-11-30

    申请号：US11140201

    申请日：2005-05-31

    申请人： Jitendra Dhamija ,  Suresh Mali ,  Christopher Evans ,  Paolo Fragapane ,  James Steadman ,  Andrew Osborn

    发明人： Jitendra Dhamija ,  Suresh Mali ,  Christopher Evans ,  Paolo Fragapane ,  James Steadman ,  Andrew Osborn

    IPC分类号： G06F17/30

    CPC分类号： G06F17/30451

    摘要： A query generator for generating a query for retrieving data from a database comprising at least one table is disclosed. The query refers to one or more data items in a first view defined to expose a portion of the database and to one or more data items that are not exposed by the first view, at least one of which has an associated reach through flag set thereby defining it as a reach through item. The query generator is adapted to: a) receive user input indicating selected items to be retrieved from the database; b) ascertain whether any of the selected items that are not exposed by the first view are defined as reach through items; and, c) if so: i) create a second view that is a copy of the first view and add a copy of each reach through item to it; and ii) create a query that refers only to the second view and the items exposed by it.

    摘要翻译： 公开了一种查询生成器，用于生成用于从包括至少一个表的数据库检索数据的查询。 该查询涉及第一视图中的一个或多个数据项，其定义为暴露数据库的一部分以及未被第一视图公开的一个或多个数据项，其中至少一个通过标志集具有相关联的到达 将其定义为通过项目的触及。 查询生成器适于：a）接收指示要从数据库检索的所选项目的用户输入; b）确定第一视野未曝光的任何选定项目是否被定义为通过项目达成; 和c）如果是这样的话：i）创建第二个视图，它是第一个视图的副本，并通过项目向每个视图添加一个副本; 和ii）创建仅引用第二个视图的查询以及它所暴露的项目。

    Query generator
    2.
    发明授权
    Query generator 有权
    查询生成器

    公开(公告)号：US07814090B2

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

    申请号：US11140201

    申请日：2005-05-31

    申请人： Jitendra Dhamija ,  Suresh Mali ,  Christopher Evans ,  Paolo Fragapane ,  James Steadman ,  Andrew Osborn

    发明人： Jitendra Dhamija ,  Suresh Mali ,  Christopher Evans ,  Paolo Fragapane ,  James Steadman ,  Andrew Osborn

    IPC分类号： G06F7/00

    CPC分类号： G06F17/30451

    摘要： A query generator for generating a query for retrieving data from a database comprising at least one table is disclosed. The query refers to one or more data items in a first view defined to expose a portion of the database and to one or more data items that are not exposed by the first view, at least one of which has an associated reach through flag set thereby defining it as a reach through item. The query generator is adapted to: receive user input indicating selected items to be retrieved from the database; ascertain whether any of the selected items that are not exposed by the first view are defined as reach through items; and, if so: create a second view that is a copy of the first view and add a copy of each reach through item to it; and create a query that refers only to the second view and the items exposed by it.

    摘要翻译： 公开了一种查询生成器，用于生成用于从包括至少一个表的数据库检索数据的查询。 该查询涉及第一视图中的一个或多个数据项，其定义为暴露数据库的一部分以及未被第一视图公开的一个或多个数据项，其中至少一个通过标志集具有相关联的到达 将其定义为通过项目的触及。 所述查询生成器适于：从所述数据库接收指示要检索的所选项的用户输入; 确定第一视图未暴露的任何选定项目是否被定义为通过项目达到; 如果是，则创建第二个视图，即第一个视图的副本，并通过项目向其添加每个触及的副本; 并创建一个仅引用第二个视图的查询及其公开的项目。

    Structured query language table merging
    4.
    发明授权
    Structured query language table merging 有权
    结构化查询语言表合并

    公开(公告)号：US07725457B2

    公开(公告)日：2010-05-25

    申请号：US10739338

    申请日：2003-12-19

    申请人： Christopher Evans ,  Paolo Fragapane ,  Stephen Cave ,  Andrew Osborn

    发明人： Christopher Evans ,  Paolo Fragapane ,  Stephen Cave ,  Andrew Osborn

    IPC分类号： G06F7/00 ,  G06F17/30

    CPC分类号： G06F17/30454

    摘要： A method of modifying a Structured Query Language (SQL) statement in order to reduce the number of joins executed by a database is disclosed. The method includes presenting the SQL statement to the database and identifying joins in the SQL statement for removal in accordance with one or more predetermined criteria. For each identified join, the SQL statement may be modified so as to remove the identified join and to change references to a first instance of a table which is referred to by the identified join to a second instance of the table.

    摘要翻译： 公开了一种修改结构化查询语言（SQL）语句以减少数据库执行的连接数量的方法。 该方法包括将SQL语句呈现给数据库，并根据一个或多个预定标准识别SQL语句中的连接以进行删除。 对于每个已标识的连接，可以修改SQL语句，以便删除所标识的连接，并将对由标识的连接引用的表的第一个实例的引用更改为表的第二个实例。

    Structured query language table merging
    5.
    发明申请
    Structured query language table merging 有权
    结构化查询语言表合并

    公开(公告)号：US20050076007A1

    公开(公告)日：2005-04-07

    申请号：US10739338

    申请日：2003-12-19

    申请人： Christopher Evans ,  Paolo Fragapane ,  Stephen Cave ,  Andrew Osborn

    发明人： Christopher Evans ,  Paolo Fragapane ,  Stephen Cave ,  Andrew Osborn

    IPC分类号： G06F17/30

    CPC分类号： G06F17/30454

    摘要： A method of modifying a Structured Query Language (SQL) statement in order to reduce the number of joins executed by a database is described. The method comprises: a) presenting the SQL statement to the database; b) identifying joins in the SQL statement for removal in accordance with one or more predetermined criteria; and c) for each identified join, modifying the SQL statement so as to remove the identified join and to change references to a first instance of a table which is referred to by the identified join to a second instance of the table.

    摘要翻译： 描述了一种修改结构化查询语言（SQL）语句以减少数据库执行的连接数量的方法。 该方法包括：a）将SQL语句呈现给数据库; b）根据一个或多个预定标准识别SQL语句中的连接以便移除; 和c）对于每个已标识的连接，修改SQL语句以便删除所标识的连接，并将对所标识的连接引用的表的第一个实例的引用更改为表的第二个实例。

    Query generator
    6.
    发明申请
    Query generator 审中-公开
    查询生成器

    公开(公告)号：US20070239659A1

    公开(公告)日：2007-10-11

    申请号：US11392777

    申请日：2006-03-30

    申请人： Paolo Fragapane ,  Natascha Kearsey ,  Christopher Evans ,  Martin Hogg

    发明人： Paolo Fragapane ,  Natascha Kearsey ,  Christopher Evans ,  Martin Hogg

    IPC分类号： G06F17/30

    CPC分类号： G06F16/24534

    摘要： A query generator for generating a query for retrieving a desired set of data from a relational database is disclosed. The query generator is adapted to: a) receive an input query adapted to retrieve a superset of the desired set of data from the database; b) analyse a default filters table comprising one or more filter application criteria, each associated with a default filter condition that refers to data contained in the superset of data; and c) for each filter application criterion that is satisfied, modify the input query in accordance with the associated default filter condition to produce an output query adapted to retrieve the desired set of data only.

    摘要翻译： 公开了一种用于从关系数据库生成用于检索所需数据集的查询的查询生成器。 所述查询生成器适于：a）接收适于从所述数据库检索期望的数据集的超集的输入查询; b）分析包括一个或多个过滤器应用准则的默认过滤器表，每个与过滤器条件相关联，该默认过滤条件涉及包含在数据超集中的数据; 以及c）对于满足的每个过滤器应用标准，根据相关联的默认过滤条件来修改输入查询以产生仅适于检索所需数据集的输出查询。

    Needle shield and adapter fixedly attached to syringe
    8.
    发明授权
    Needle shield and adapter fixedly attached to syringe 有权
    针头护罩和适配器固定在注射器上

    公开(公告)号：US09327086B2

    公开(公告)日：2016-05-03

    申请号：US13583096

    申请日：2011-03-11

    申请人： Izrail Tsals ,  Christopher Evans ,  Brian Costello

    发明人： Izrail Tsals ,  Christopher Evans ,  Brian Costello

    IPC分类号： A61M5/46 ,  A61M5/42 ,  A61M5/24 ,  A61M5/158 ,  A61M5/32

    CPC分类号： A61M5/425 ,  A61M5/158 ,  A61M5/24 ,  A61M5/3287 ,  A61M5/46 ,  A61M2005/1585

    摘要： An assembly for use with a syringe having a barrel and a needle includes a sealing element surrounding and positioned over at least a portion of the distal end of the syringe. An adapter at least partially surrounds the sealing element and is positioned over the distal end of the syringe. The adapter has a first skin contacting surface positioned at a distal end thereof. At least a portion of the first skin contacting surface extends generally parallel to at least a terminal end of the needle. The adapter also has a second skin contacting surface positioned proximally relative to the terminal end of the needle and at an angle to the first skin contacting surface. A needle shield at least partially surrounds and is removably positioned over at least one of the adapter, the sealing element and the syringe barrel.

    摘要翻译： 用于具有镜筒和针头的注射器的组件包括围绕并定位在注射器的远端的至少一部分上方的密封元件。 适配器至少部分地围绕密封元件并且被定位在注射器的远端上方。 适配器具有位于其远端处的第一皮肤接触表面。 第一皮肤接触表面的至少一部分大致平行于针的至少末端延伸。 适配器还具有相对于针的终端向近侧定位并与第一皮肤接触表面成一定角度的第二皮肤接触表面。 针护罩至少部分地围绕并且可移除地定位在适配器，密封元件和注射器筒中的至少一个上。

    INTRADERMAL PEN ADAPTER
    10.
    发明申请
    INTRADERMAL PEN ADAPTER 有权
    INTRADERMAL PEN适配器

    公开(公告)号：US20120191065A1

    公开(公告)日：2012-07-26

    申请号：US13355031

    申请日：2012-01-20

    申请人： Izrail Tsals ,  Christopher Evans ,  Brian Costello

    发明人： Izrail Tsals ,  Christopher Evans ,  Brian Costello

    IPC分类号： A61M5/32

    CPC分类号： A61M5/46 ,  A61B5/150068 ,  A61B5/150183 ,  A61B5/150748 ,  A61B5/153 ,  A61M5/158 ,  A61M5/3287

    摘要： An intradermal injection adapter includes a body having a longitudinal axis and a central portion located distally relative to the body along the longitudinal axis. The central portion has a cannula channel therethrough extending generally parallel to the longitudinal axis. A cannula within the cannula channel has a sharpened tip for injection into a patient and a sharpened opposite proximal end for injection into a pen injector. A distal protrusion has a first skin contacting surface extending generally parallel to the longitudinal axis. The first skin contacting surface is spaced from the cannula such that a distal portion of the cannula extends generally parallel to the first skin contacting surface.

    摘要翻译： 真皮内注射适配器包括具有纵向轴线的主体和沿着纵向轴线相对于身体向远侧定位的中心部分。 中心部分具有大致平行于纵向轴线的插管通道。 插管通道内的插管具有用于注入患者的尖锐尖端和用于注入笔式注射器的锐化的相对近端。 远端突起具有大致平行于纵向轴线延伸的第一皮肤接触表面。 第一皮肤接触表面与套管间隔开，使得套管的远端部分大致平行于第一皮肤接触表面延伸。