会员体验
专利管家(专利管理)
工作空间(专利管理)
风险监控(情报监控)
数据分析(专利分析)
侵权分析(诉讼无效)
联系我们
交流群
官方交流:
QQ群: 891211   
微信请扫码    >>>
现在联系顾问~
热词
    • 3. 发明申请
    • DATABASE OPTIMIZATION APPARATUS AND METHOD
    • 数据库优化装置和方法
    • US20060155675A1
    • 2006-07-13
    • US11277229
    • 2006-03-22
    • Jeremy ArnoldEric BarsnessRichard DettingerJohn Santosuosso
    • Jeremy ArnoldEric BarsnessRichard DettingerJohn Santosuosso
    • G06F17/30
    • G06F16/211Y10S707/99942Y10S707/99943
    • A database optimizer collects statistics regarding applications accessing a database, and makes one or more changes to the database schema to optimize performance according to the collected statistics. In a first embodiment, the optimizer detects when a certain type of application accesses the database a percentage of time that exceeds a predefined threshold level, and if the data in the database is stored in a less-than-optimal format for the application, the data type of one or more columns in the database is changed to a more optimal format for the application. In a second embodiment, the optimizer detects when one type of application accesses a column a percentage of time that exceeds a first predefined threshold level and is less than a second predefined threshold level, and creates a new column in the database so the data is present in both formats.
    • 数据库优化器收集有关访问数据库的应用程序的统计信息,并对数据库模式进行一个或多个更改以根据收集的统计信息优化性能。 在第一实施例中,优化器检测特定类型的应用程序何时访问数据库超过预定阈值级别的时间百分比,并且如果数据库中的数据以针对应用的不是最佳格式存储, 将数据库中的一个或多个列的数据类型更改为应用程序的更优化格式。 在第二实施例中,优化器检测何时一个应用程序访问列超过第一预定义阈值级别并小于第二预定义阈值级别的时间百分比,并在数据库中创建新列,以便数据存在 在两种格式。
    • 7. 发明申请
    • DATABASE OPTIMIZATION APPARATUS AND METHOD
    • 数据库优化装置和方法
    • US20070073644A1
    • 2007-03-29
    • US11277146
    • 2006-03-22
    • Jeremy ArnoldEric BarsnessRichard DettingerJohn Santosuosso
    • Jeremy ArnoldEric BarsnessRichard DettingerJohn Santosuosso
    • G06F17/30
    • G06F16/211Y10S707/99942Y10S707/99943
    • A database optimizer collects statistics regarding applications accessing a database, and makes one or more changes to the database schema to optimize performance according to the collected statistics. In a first embodiment, the optimizer detects when a certain type of application accesses the database a percentage of time that exceeds a predefined threshold level, and if the data in the database is stored in a less-than-optimal format for the application, the data type of one or more columns in the database is changed to a more optimal format for the application. In a second embodiment, the optimizer detects when one type of application accesses a column a percentage of time that exceeds a first predefined threshold level and is less than a second predefined threshold level, and creates a new column in the database so the data is present in both formats.
    • 数据库优化器收集有关访问数据库的应用程序的统计信息,并对数据库模式进行一个或多个更改以根据收集的统计信息优化性能。 在第一实施例中,优化器检测特定类型的应用程序何时访问数据库超过预定阈值级别的时间百分比,并且如果数据库中的数据以针对应用的不是最佳格式存储,则 将数据库中的一个或多个列的数据类型更改为应用程序的更优化格式。 在第二实施例中,优化器检测何时一个应用程序访问列超过第一预定义阈值级别并小于第二预定义阈值级别的时间百分比,并在数据库中创建新列,以便数据存在 在两种格式。