公开(公告)号：US20070073761A1

公开(公告)日：2007-03-29

申请号：US11239617

申请日：2005-09-29

申请人： Mark Anderson ,  Robert Bestgen ,  James Flanagan ,  Scott Forstie ,  Thomas Schreiber

发明人： Mark Anderson ,  Robert Bestgen ,  James Flanagan ,  Scott Forstie ,  Thomas Schreiber

IPC分类号： G06F7/00

CPC分类号： G06F16/217 ,  G06F16/22

摘要： Continual generation of index advice that includes generating an index advice for an index of a table in a computer database and recording values of statistical attributes of the index advice accumulated across repeated generations of the index advice. The generating and recording typically are carried out continually without user intervention. Embodiments include recording values of attributes of the index advice that specify an index. Typical embodiments also include, continually and without user intervention, recording values of attributes of the index advice that characterize usefulness of an index and recording values of attributes of the index advice that characterize cost of creating an index.

摘要翻译： 持续生成索引建议，包括为计算机数据库中的表的索引生成索引建议，并记录索引建议的重复次数累积的索引建议的统计属性的值。 生成和记录通常在没有用户干预的情况下持续进行。 实施例包括记录指定索引的索引建议的属性的值。 典型实施例还包括持续地且没有用户干预的记录索引建议的属性的值，其表征索引的有用性，并记录表征创建索引的成本的索引建议的属性的值。

公开(公告)号：US20070192372A1

公开(公告)日：2007-08-16

申请号：US11353515

申请日：2006-02-14

申请人： Robert Bestgen ,  James Flanagan ,  Michale Pfeifer

发明人： Robert Bestgen ,  James Flanagan ,  Michale Pfeifer

IPC分类号： G06F17/30

CPC分类号： G06F17/30289 ,  G06F17/30386

摘要： A database management system maintains a record of queries which can be executed against the database. For a given auxiliary database structure, an advisory function automatically reviews the query record and identifies those queries which might execute with greater efficiency using the auxiliary database structure, presenting analytical information to the user. Preferably, the auxiliary database structure is an index, and the information is used for determining whether to include the index in the database definition. Preferably, a query optimizer records potentially useful indexes when considering multiple alternative database optimizations, and this information is later retrieved to identify queries which would benefit from an index.

摘要翻译： 数据库管理系统维护可以针对数据库执行的查询记录。 对于给定的辅助数据库结构，咨询功能自动审查查询记录，并使用辅助数据库结构识别可能以更高效率执行的查询，向用户呈现分析信息。 优选地，辅助数据库结构是索引，并且该信息用于确定是否将数据包括在数据库定义中。 优选地，当考虑多个备选数据库优化时，查询优化器记录潜在有用的索引，并且稍后检索该信息以识别将从索引中受益的查询。

公开(公告)号：US20070174329A1

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

申请号：US11340341

申请日：2006-01-26

申请人： Mark Anderson ,  James Flanagan ,  Thomas Giordano ,  Rafal Konik ,  Ritchie Nyland ,  Mark Theuer ,  Wilson Ward

发明人： Mark Anderson ,  James Flanagan ,  Thomas Giordano ,  Rafal Konik ,  Ritchie Nyland ,  Mark Theuer ,  Wilson Ward

IPC分类号： G06F7/00

CPC分类号： G06F16/217

摘要： In response to a request to access a database, a decision is made that a secondary data structure associated with the database needs rebuilding. A reason why the secondary data structure needs rebuilding is determined and the reason is presented via a user interface. In various embodiments, other information may also be presented, such as an identification of the operation associated with the request that encountered the secondary data structure and an identification of a most recent query that used the secondary data structure. In this way, the user may be informed of the reason why a secondary data structure needs rebuilding, so that the user may opt to take action to prevent secondary data structures from needing rebuilding in the future, and thus avoid the expense and time of rebuilding the secondary data structures.

摘要翻译： 响应于访问数据库的请求，决定与数据库相关联的辅助数据结构需要重建。 确定二次数据结构需要重建的原因，并通过用户界面呈现原因。 在各种实施例中，还可以呈现其他信息，例如与遇到辅助数据结构的请求相关联的操作的标识以及使用次要数据结构的最近查询的标识。 以这种方式，可以向用户通知二次数据结构需要重建的原因，使得用户可以选择采取行动以防止次要数据结构在将来需要重建，从而避免重建的费用和时间 辅助数据结构。

公开(公告)号：US20060287954A1

公开(公告)日：2006-12-21

申请号：US11413365

申请日：2006-04-28

申请人： Richard DeWitt ,  Nadia Lannie ,  James Flanagan ,  Mary Prozes

发明人： Richard DeWitt ,  Nadia Lannie ,  James Flanagan ,  Mary Prozes

IPC分类号： G06Q40/00

CPC分类号： G06Q30/04 ,  G06Q20/102 ,  G06Q20/105 ,  G06Q20/108 ,  G06Q40/00

摘要： A method and system for tracking and verifying estimates, invoices, and billing exceptions for charges billed to a customer by a vendor is disclosed. The vendor submits an estimate via a billing verification system. The system generates an estimate record and facilitates customer review of the estimate. The system also receives an invoice for the completed repair from the vendor and generates an invoice record. Based on the estimate record and the invoice record, the system can perform an audit to compare the invoice to the estimate. The system also enables the customer to review the invoice via the billing verification system to identify billing exceptions associated with any disputed charges. A billing exception record is generated in the billing verification system for each of the billing exceptions. The vendor is then notified of the billing exceptions. The vendor reviews and responds to the billing exception records via the billing verification system. A billing exception response record is generated for each vendor response. The customer is then notified of the reviewed billing exception response records.

摘要翻译： 披露了一种方法和系统，用于跟踪和验证供应商向客户收取的费用的估计，发票和计费例外。 供应商通过帐单验证系统提交估算。 系统生成估计记录，并促进客户对估计的审查。 系统还从供应商那里收到完成维修的发票，并生成发票记录。 根据估算记录和发票记录，系统可以进行审计，以将发票与估计进行比较。 该系统还使客户能够通过结算验证系统查看发票，以识别与任何有争议的费用相关的结算例外。 在计费验证系统中为每个帐单异常生成记帐异常记录。 然后通知供应商帐单异常。 供应商通过计费验证系统审查并响应计费异常记录。 为每个供应商响应生成记帐异常响应记录。 然后向客户通知审查的计费异常响应记录。

公开(公告)号：US20100234242A1

公开(公告)日：2010-09-16

申请号：US12524114

申请日：2008-01-23

申请人： Arturas Petronis ,  Jonathan Mill ,  James Flanagan ,  Sun-Chong Wang

发明人： Arturas Petronis ,  Jonathan Mill ,  James Flanagan ,  Sun-Chong Wang

IPC分类号： C40B30/06 ,  C12Q1/68 ,  C40B40/06 ,  C07D239/47 ,  C07H21/00

CPC分类号： C12Q1/6883 ,  C12Q2600/154 ,  C40B30/00 ,  C40B40/06

摘要： The present invention provides a method of identifying one or more epigenetic markers associated with psychosis-associated diseases such as bipolar disease or schizophrenia, the method comprising a) obtaining a first group of samples comprising genomic DNA from a plurality of bipolar or schizophrenic subjects and a second group of samples comprising genomic DNA from a plurality of control subjects; b) performing DNA methylation analysis to determine methylation differences in one or more DNA regions between the first group and second group of samples, wherein a methylation difference in a DNA region is indicative of an epigenetic marker associated with bipolar disease or schizophrenia. The invention also provides one or more epigenetic markers associated with psychosis-associated diseases such as bipolar disease or schizophrenia.

摘要翻译： 本发明提供了鉴定与精神病相关疾病如双相性精神障碍或精神分裂症相关的一种或多种表观遗传标记的方法，所述方法包括：a）获得包含来自多个双相或精神分裂症受试者的基因组DNA的第一组样品， 第二组样本，其包含来自多个对照受试者的基因组DNA; b）进行DNA甲基化分析以确定第一组和第二组样品之间的一个或多个DNA区域的甲基化差异，其中DNA区域中的甲基化差异指示与双相性精神障碍或精神分裂症相关的表观遗传学标记。 本发明还提供与精神病相关疾病如双相性精神障碍或精神分裂症相关的一种或多种表观遗传标记。