-
公开(公告)号：US10032131B2
公开(公告)日：2018-07-24
申请号：US13527601
申请日：2012-06-20
申请人： Tao Cheng , Kris Ganjam , Kaushik Chakrabarti , Zhimin Chen , Vivek R. Narasayya , Surajit Chaudhuri
发明人： Tao Cheng , Kris Ganjam , Kaushik Chakrabarti , Zhimin Chen , Vivek R. Narasayya , Surajit Chaudhuri
摘要： A data service system is described herein which processes raw data assets from at least one network-accessible system (such as a search system), to produce processed data assets. Enterprise applications can then leverage the processed data assets to perform various environment-specific tasks. In one implementation, the data service system can generate any of: synonym resources for use by an enterprise application in providing synonyms for specified terms associated with entities; augmentation resources for use by an enterprise application in providing supplemental information for specified seed information; and spelling-correction resources for use by an enterprise application in providing spelling information for specified terms, and so on.
-
公开(公告)号：US08452754B2
公开(公告)日：2013-05-28
申请号：US12463336
申请日：2009-05-08
CPC分类号： G06F17/30306
摘要： A tool facilitating static analysis for database applications, such that the static analysis tool (SAT) can significantly enhance the ability for developers to identify security, correctness and performance problems in database applications during the development phase of an application lifecycle. A static analysis tool for database applications presents a framework for database applications using the ADO.NET data access APIs. The SAT framework consists of a core set of static analysis services upon which verticals such as workload extraction, SQL injection detection, identifying data integrity violations, and SQL performance analysis are built using the core services.
摘要翻译： 一种促进数据库应用程序的静态分析的工具，使得静态分析工具（SAT）可以显着增强开发人员在应用程序生命周期开发阶段识别数据库应用程序中的安全性，正确性和性能问题的能力。 数据库应用程序的静态分析工具为使用ADO.NET数据访问API的数据库应用程序提供了框架。 SAT框架由静态分析服务的核心组成，其中使用核心服务构建诸如工作负载提取，SQL注入检测，识别数据完整性违规和SQL性能分析之类的垂直。
-
公开(公告)号：US20100287214A1
公开(公告)日：2010-11-11
申请号：US12463336
申请日：2009-05-08
IPC分类号： G06F17/30
CPC分类号： G06F17/30306
摘要： A tool facilitating static analysis for database applications, such that the static analysis tool (SAT) can significantly enhance the ability for developers to identify security, correctness and performance problems in database applications during the development phase of an application lifecycle. A static analysis tool for database applications presents a framework for database applications using the ADO.NET data access APIs. The SAT framework consists of a core set of static analysis services upon which verticals such as workload extraction, SQL injection detection, identifying data integrity violations, and SQL performance analysis are built using the core services.
摘要翻译： 一种促进数据库应用程序的静态分析的工具，使得静态分析工具（SAT）可以显着增强开发人员在应用程序生命周期开发阶段识别数据库应用程序中的安全性，正确性和性能问题的能力。 数据库应用程序的静态分析工具为使用ADO.NET数据访问API的数据库应用程序提供了框架。 SAT框架由静态分析服务的核心组成，其中使用核心服务构建诸如工作负载提取，SQL注入检测，识别数据完整性违规和SQL性能分析之类的垂直。
-
公开(公告)号：US07366716B2
公开(公告)日：2008-04-29
申请号：US11124021
申请日：2005-05-06
申请人： Sanjay Agrawal , Vivek R. Narasayya , Beverly Yang
发明人： Sanjay Agrawal , Vivek R. Narasayya , Beverly Yang
CPC分类号： G06F17/30584 , Y10S707/99932 , Y10S707/99933
摘要： Systems and methodologies that split a table into a plurality of sub-tables, and vertical partitions. By analyzing an associated work load to determine frequently referenced columns, the subject invention supplies a compromise among various vertical partitioning strategies (e.g., candidate selection for table spilt) via a merging act, such that the table is split optimally for the work load taken as a whole Accordingly, an incoming query can optimally reference only required columns.
摘要翻译： 将表拆分成多个子表和垂直分区的系统和方法。 通过分析相关联的工作负载以确定频繁引用的列，本发明通过合并动作在各种垂直分区策略（例如，用于表溢出的候选者选择）之间提供妥协，使得该表被最优地分解为所采用的工作负载 一个整体因此，传入的查询可以最佳地仅引用必需的列。
-
公开(公告)号：US07363301B2
公开(公告)日：2008-04-22
申请号：US11246355
申请日：2005-10-07
IPC分类号： G06F17/30
CPC分类号： G06F17/30489 , G06F17/30536 , G06F2216/03 , Y10S707/957 , Y10S707/99932 , Y10S707/99933 , Y10S707/99935 , Y10S707/99942 , Y10S707/99943
摘要： Aggregation queries are performed by first identifying outlier values, aggregating the outlier values, and sampling the remaining data after pruning the outlier values. The sampled data is extrapolated and added to the aggregated outlier values to provide an estimate for each aggregation query. Outlier values are identified by selecting values outside of a selected sliding window of data having the lowest variance. An index is created for the outlier values. The outlier data is removed from the window of data, and separately aggregated. The remaining data without the outliers is then sampled to provide a statistically relevant sample that is then aggregated and extrapolated to provide an estimate for the remaining data. This sampled estimate is combined with the outlier aggregate to form an estimate for the entire set of data.
摘要翻译： 通过首先识别异常值，聚合异常值和在修剪异常值之后对剩余数据进行采样来执行聚合查询。 采样数据被外推并加到聚合异常值中，以提供每个聚合查询的估计。 异常值通过选择具有最小方差的数据的所选滑动窗口之外的值来识别。 为异常值创建索引。 离群数据从数据窗口中移除，并单独汇总。 然后对没有异常值的剩余数据进行采样，以提供统计学上相关的样本，然后对其进行聚合和外插，以提供剩余数据的估计。 该采样估计与异常值聚合组合以形成整套数据的估计。
-
6.发明授权Merging materialized view pairs for database workload materialized view selection 有权为数据库工作负载物化视图选择合并物化视图对公开(公告)号：US06356890B1
公开(公告)日：2002-03-12
申请号：US09629353
申请日：2000-08-01
IPC分类号： G06F1730
CPC分类号： G06F17/30321 , Y10S707/99932 , Y10S707/99933 , Y10S707/99935
摘要： An index and materialized view selection wizard produces a fast and reasonable recommendation for a configuration of indexes, materialized views, and indexes on materialized views which are beneficial given a specified workload for a given database and database server. Candidate materialized views and indexes are obtained, and a joint enumeration of the combined materialized views and indexes is performed to obtain a recommended configuration. The configuration includes indexes, materialized views and indexes on materialized views. Candidate materialized views are obtained by first determining subsets of tables are referenced in queries in the workload and then finding interesting table subsets. Next, interesting subsets are considered on a per query basis to determine which are syntactically relevant for a query. Materialized views which are likely to be used for the workload are then generated along with a set of merged materialized views. Clustered indexes and non-clustered indexes on materialized views are then generated. The indexes, materialized views and indexes on materialized views are then enumerated together to form the recommended configuration.
摘要翻译： 索引和物化视图选择向导可以为物理视图的索引，物化视图和索引配置提供快速合理的建议，这对给定数据库和数据库服务器的指定工作负载是有益的。 获取候选物化视图和索引，并执行组合实例化视图和索引的联合枚举，以获得推荐的配置。 配置包括物化视图的索引，物化视图和索引。 通过首先确定表中的子集在工作负载中的查询中引用并且然后找到有趣的表子集来获得候选物化视图。 接下来，在每个查询的基础上考虑有趣的子集，以确定哪个在查询语法上相关。 可能用于工作负载的物化视图随同一组合并物化视图一起生成。 然后生成物化视图上的聚簇索引和非聚集索引。 然后将物化视图的索引，物化视图和索引列在一起以形成推荐的配置。
-
公开(公告)号：US20130346464A1
公开(公告)日：2013-12-26
申请号：US13527601
申请日：2012-06-20
申请人： Tao Cheng , Kris Ganjam , Kaushik Chakrabarti , Zhimin Chen , Vivek R. Narasayya , Surajit Chaudhuri
发明人： Tao Cheng , Kris Ganjam , Kaushik Chakrabarti , Zhimin Chen , Vivek R. Narasayya , Surajit Chaudhuri
IPC分类号： G06F15/16
CPC分类号： G06Q10/10
摘要： A data service system is described herein which processes raw data assets from at least one network-accessible system (such as a search system), to produce processed data assets. Enterprise applications can then leverage the processed data assets to perform various environment-specific tasks. In one implementation, the data service system can generate any of: synonym resources for use by an enterprise application in providing synonyms for specified terms associated with entities; augmentation resources for use by an enterprise application in providing supplemental information for specified seed information; and spelling-correction resources for use by an enterprise application in providing spelling information for specified terms, and so on.
摘要翻译： 本文描述了一种数据服务系统，其处理来自至少一个网络可访问系统（例如搜索系统）的原始数据资产以产生处理的数据资产。 企业应用程序可以利用已处理的数据资产来执行各种环境特定任务。 在一个实现中，数据服务系统可以生成以下任何一种：供企业应用使用的同义词资源，为与实体相关联的指定术语提供同义词; 增加资源供企业应用用于提供指定种子信息的补充信息; 以及企业应用程序为指定的术语提供拼写信息的拼写纠正资源等。
-
公开(公告)号：US07580941B2
公开(公告)日：2009-08-25
申请号：US11423924
申请日：2006-06-13
IPC分类号： G06F17/30
CPC分类号： G06F17/30306 , Y10S707/99942
摘要： The subject disclosure pertains to logical schema tuning for databases. Mechanisms are provided for automatically recommending one or more logical schema transformations to improve database performance with respect to workload and data characteristics. Furthermore, several potential schema transformations including desirable properties are presented including mapping tables, vertical partitioning, frequent value elimination and type and attribute conversion. Still further yet, disclosed is a mechanism for rewriting database operations (e.g. queries, updates . . . ) for an optimized schema to ensure correct evaluation.
摘要翻译： 主题公开涉及数据库的逻辑模式调整。 提供了用于自动推荐一个或多个逻辑模式转换以提高关于工作负载和数据特性的数据库性能的机制。 此外，提出了包括所需属性的几种潜在的模式转换，包括映射表，垂直分区，频繁值消除以及类型和属性转换。 更进一步地，公开了一种用于重写用于优化模式的数据库操作（例如，查询，更新...）以确保正确评估的机制。
-
公开(公告)号：US07577638B2
公开(公告)日：2009-08-18
申请号：US11296034
申请日：2005-12-07
IPC分类号： G06F17/30
CPC分类号： G06F17/30536 , G06F17/30489 , Y10S707/99931 , Y10S707/99932 , Y10S707/99933 , Y10S707/99942
摘要： An outlier index for a database and a given workload is generated by identifying sub-relations of tuples in the database induced by selection and group by conditions in queries in the workload. A variance is then generated for values in each sub-relation. Sub-relations having higher variances are selected, and outliers from such sub-relations having higher variances are generated.
摘要翻译： 数据库和给定工作负荷的异常值索引是通过识别由工作负载中的查询中的选择引起的数据库中的元数据元素的子关系而生成的。 然后为每个子关系中的值生成方差。 选择具有较高方差的子关系，并且产生具有较高方差的这种子关系的异常值。
-
公开(公告)号：US07293037B2
公开(公告)日：2007-11-06
申请号：US11246354
申请日：2005-10-07
IPC分类号： G06F17/30
CPC分类号： G06F17/30489 , G06F17/30536 , G06F2216/03 , Y10S707/957 , Y10S707/99932 , Y10S707/99933 , Y10S707/99935 , Y10S707/99942 , Y10S707/99943
摘要： Aggregation queries are performed by first identifying outlier values, aggregating the outlier values, and sampling the remaining data after pruning the outlier values. The sampled data is extrapolated and added to the aggregated outlier values to provide an estimate for each aggregation query. Outlier values are identified by selecting values outside of a selected sliding window of data having the lowest variance. An index is created for the outlier values. The outlier data is removed from the window of data, and separately aggregated. The remaining data without the outliers is then sampled to provide a statistically relevant sample that is then aggregated and extrapolated to provide an estimate for the remaining data. This sampled estimate is combined with the outlier aggregate to form an estimate for the entire set of data.
摘要翻译： 通过首先识别异常值，聚合异常值和在修剪异常值之后对剩余数据进行采样来执行聚合查询。 采样数据被外推并加到聚合异常值中，以提供每个聚合查询的估计。 异常值通过选择具有最小方差的数据的所选滑动窗口之外的值来识别。 为异常值创建索引。 离群数据从数据窗口中移除，并单独汇总。 然后对没有异常值的剩余数据进行采样，以提供统计学上相关的样本，然后对其进行聚合和外插，以提供剩余数据的估计。 该采样估计与异常值聚合组合以形成整套数据的估计。
-
-
-
-
-
-
-
-
-
搜索结果
31 条记录 (耗时 0.024 秒)
