会员体验
专利管家(专利管理)
工作空间(专利管理)
风险监控(情报监控)
数据分析(专利分析)
侵权分析(诉讼无效)
联系我们
交流群
官方交流:
QQ群: 891211   
微信请扫码    >>>
现在联系顾问~
热词
    • 42. 发明申请
    • Apparatus and method for monitoring performance of a storage area network
    • 用于监测存储区域网络的性能的装置和方法
    • US20070073984A1
    • 2007-03-29
    • US11239501
    • 2005-09-29
    • Eric BarsnessJohn Santosuosso
    • Eric BarsnessJohn Santosuosso
    • G06F13/00
    • G06F3/0653G06F3/0605G06F3/067
    • A performance monitor reports SAN performance so that issues within the SAN are not masked from the client. Accesses to the SAN may be grouped into the categories of SAN logical or SAN physical. In one specific embodiment, the ranges of service times for accesses to the SAN are determined by monitoring service times of accesses to the SAN from the client perspective. In another specific embodiment, the ranges of service times for the SAN are determined by the SAN returning data with each request that indicates the service time from the SAN perspective. This allows reporting not only SAN logical and SAN physical accesses, but also allows reporting SAN service time. By specifying SAN service time, the client is able to better determine network delays. In yet another embodiment, information is returned by the SAN to indicate whether the access is SAN logical or SAN physical.
    • 性能监视器报告SAN性能,以便SAN中的问题不会从客户端屏蔽。 对SAN的访问可以分组为SAN逻辑或SAN物理的类别。 在一个具体实施例中,通过从客户端的角度监视对SAN的访问的服务时间来确定对SAN的访问的服务时间的范围。 在另一个具体实施例中,SAN的服务时间范围由SAN返回数据,每个请求指示从SAN角度来看服务时间。 这样可以不仅报告SAN逻辑和SAN物理访问,还可以报告SAN服务时间。 通过指定SAN服务时间,客户端能够更好地确定网络延迟。 在另一个实施例中,由SAN返回信息以指示该访问是SAN逻辑还是SAN物理。
    • 43. 发明申请
    • 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.
    • 数据库优化器收集有关访问数据库的应用程序的统计信息,并对数据库模式进行一个或多个更改以根据收集的统计信息优化性能。 在第一实施例中,优化器检测特定类型的应用程序何时访问数据库超过预定阈值级别的时间百分比,并且如果数据库中的数据以针对应用的不是最佳格式存储,则 将数据库中的一个或多个列的数据类型更改为应用程序的更优化格式。 在第二实施例中,优化器检测何时一个应用程序访问列超过第一预定义阈值级别并小于第二预定义阈值级别的时间百分比,并在数据库中创建新列,以便数据存在 在两种格式。
    • 44. 发明申请
    • Scheduling garbage collection
    • 计划垃圾收集
    • US20070033240A1
    • 2007-02-08
    • US11197603
    • 2005-08-04
    • Eric BarsnessJohn Santosuosso
    • Eric BarsnessJohn Santosuosso
    • G06F17/30
    • G06F12/0253
    • Scheduling garbage collection by gathering garbage collection information about two or more garbage collection processes, and determining when at least one of the two or more garbage collection processes should execute in dependence upon the garbage collection information is disclosed. Garbage collection information may be gathered through inter-process communication between two or more garbage collection processes, or by gathering garbage collection information from a computer on which at least one garbage collection processes is running. Determining when at least one of garbage collection processes should execute in dependence upon the garbage collection information may include determining a time to execute at least one garbage collection process so as to reduce the likelihood that execution of two or more of the garbage collection processes will overlap. A master garbage collection scheduler may be provided to schedule garbage collection.
    • 通过收集关于两个或更多垃圾收集过程的垃圾收集信息以及根据垃圾收集信息来确定两个或多个垃圾收集过程中的至少一个应该执行的调度垃圾收集。 垃圾收集信息可以通过两个或多个垃圾回收进程之间的进程间通信收集,或者通过收集来自运行至少一个垃圾回收进程的计算机的垃圾收集信息来收集垃圾收集信息。 确定垃圾收集过程中的至少一个何时根据垃圾收集信息执行可以包括确定执行至少一个垃圾收集过程的时间,以便减少两个或更多垃圾收集过程的执行重叠的可能性 。 可以提供主垃圾收集调度器来调度垃圾收集。
    • 45. 发明申请
    • Apparatus and method for journaling database queries
    • 用于日志数据库查询的装置和方法
    • US20070033181A1
    • 2007-02-08
    • US11197604
    • 2005-08-04
    • Eric BarsnessJohn SantosuossoJohn Stroh
    • Eric BarsnessJohn SantosuossoJohn Stroh
    • G06F17/30
    • G06F17/30368
    • A database journal mechanism stores both row operations and database queries in a database journal. The database queries in the journal provide significant additional information that may be used in a number of different ways. For example, a database replication send mechanism in accordance with the preferred embodiments could read a database query in the journal and determine that the query affects several rows. The database replication send mechanism could then transmit the database query to the computer system that hosts the replicated database. A database replication receive mechanism in accordance with the preferred embodiments receives the database query, and executes the database query on the replicated database. As a result, the transmission of a single database query can replace the transmission of many row operations.
    • 数据库日志机制将行操作和数据库查询都存储在数据库日志中。 期刊中的数据库查询提供可以以多种不同方式使用的重要附加信息。 例如,根据优选实施例的数据库复制发送机制可以读取日志中的数据库查询,并确定查询影响多行。 然后,数据库复制发送机制可以将数据库查询传送到承载复制数据库的计算机系统。 根据优选实施例的数据库复制接收机制接收数据库查询,并对复制数据库执行数据库查询。 因此,单个数据库查询的传输可以替代许多行操作的传输。
    • 47. 发明申请
    • Apparatus and method for inhibiting non-critical access based on measured performance in a database system
    • 基于数据库系统中的测量性能来抑制非关键访问的装置和方法
    • US20060064426A1
    • 2006-03-23
    • US10948774
    • 2004-09-23
    • Eric BarsnessMahdad MajdJohn Santosuosso
    • Eric BarsnessMahdad MajdJohn Santosuosso
    • G06F17/30
    • G06F17/30365
    • A database system has a contention monitor which determines when the level of contention for accessing or inserting records in the database rises above a threshold, and inhibits non-critical access to the database to reduce the level of contention. In a preferred embodiment, the level of contention is determined by periodically measuring the time for an INSERT operation on the database, and comparing the time to a threshold derived from a baseline time measurement for the operation during a time of normal database activity. Thus the contention level is inferred from the time to do the operation, in this case the INSERT query. In one embodiment, the contention monitor notifies a system administrator to take action to reduce the contention. In another embodiment, the contention monitor informs the system to take action automatically according to predetermined selections by the system administrator.
    • 数据库系统具有竞争监视器,其确定何时访问或插入数据库中的记录的竞争级别高于阈值,并且禁止对数据库的非关键访问以降低竞争级别。 在优选实施例中,通过周期性地测量数据库上的INSERT操作的时间,并将时间与从正常数据库活动期间的操作的基线时间测量得出的阈值进行比较来确定争用级别。 因此,从执行操作的时间推断争用级别,在这种情况下是INSERT查询。 在一个实施例中,争用监视器通知系统管理员采取行动以减少争用。 在另一个实施例中,争用监控器通知系统根据系统管理员的预定选择自动采取行动。
    • 50. 发明申请
    • Method and system for creating profiling indices
    • 创建分析索引的方法和系统
    • US20050154757A1
    • 2005-07-14
    • US10753523
    • 2004-01-08
    • Eric BarsnessBrian MurasJohn Santosuosso
    • Eric BarsnessBrian MurasJohn Santosuosso
    • G06F17/00G06F17/30
    • G06F17/30702G06F17/30867Y10S707/99933Y10S707/99935Y10S707/99936Y10S707/99937Y10S707/99945Y10S707/99948
    • A database engine and optimizer framework support creation of a series of profiling indices over a column having character string data, such as a traditional “varchar” data type. The profiling indices result in a reduction of the number of records that are searched when searching for a sub-string match within that column. In some embodiments, the series of indices are created over a column that is typically searched using the LIKE predicate or some similar technique; these indices indicate for each record whether certain sub-strings may exist in that record's value in the column. Thus, the indices are used to find the rows that may match one or more portions of the particular term being queried or, in other words, eliminate those records that do not have at least a portion of the term to be matched. The number of records actually retrieved and searched for the query sub-string is thereby reduced.
    • 数据库引擎和优化器框架支持在具有字符串数据的列(例如传统的“varchar”数据类型)上创建一系列概要分析索引。 分析索引导致在搜索该列中的子字符串匹配时减少搜索的记录数。 在一些实施例中,通过使用LIKE谓词或一些类似技术通常搜索的列创建一系列索引; 这些索引为每个记录指示该列中该记录的值中是否存在某些子字符串。 因此,索引用于找到可以匹配要查询的特定术语的一个或多个部分的行,或者换句话说,消除不具有要匹配的术语的至少一部分的那些记录。 由此减少实际检索和查询查询子串的记录数。