-
公开(公告)号：US07613683B2
公开(公告)日：2009-11-03
申请号：US11684255
申请日：2007-03-09
IPC分类号： G06F17/30
CPC分类号： G06F17/3048 , Y10S707/99931 , Y10S707/99932 , Y10S707/99936 , Y10S707/99942 , Y10S707/99943
摘要： A method for retrieving information from a database includes identifying a cylinder. The cylinder includes a plurality of data segments. The method also includes retrieving the plurality of data segments from the cylinder during a single retrieval operation. In addition, the method includes storing the plurality of data segments in a cache.
摘要翻译： 从数据库检索信息的方法包括识别圆筒。 气缸包括多个数据段。 该方法还包括在单次检索操作期间从圆筒检索多个数据段。 此外，该方法包括将多个数据段存储在高速缓存中。
-
公开(公告)号：US07203691B2
公开(公告)日：2007-04-10
申请号：US10256712
申请日：2002-09-27
IPC分类号： G06F17/30
CPC分类号： G06F17/3048 , Y10S707/99931 , Y10S707/99932 , Y10S707/99936 , Y10S707/99942 , Y10S707/99943
摘要： A method for retrieving information from a database includes identifying a cylinder. The cylinder includes a plurality of data segments. The method also includes retrieving the plurality of data segments from the cylinder during a single retrieval operation. In addition, the method includes storing the plurality of data segments in a cache.
摘要翻译： 从数据库检索信息的方法包括识别圆筒。 气缸包括多个数据段。 该方法还包括在单次检索操作期间从圆筒检索多个数据段。 此外，该方法包括将多个数据段存储在高速缓存中。
-
公开(公告)号：US09141632B1
公开(公告)日：2015-09-22
申请号：US13719390
申请日：2012-12-19
申请人： Bhashyam Ramesh
发明人： Bhashyam Ramesh
IPC分类号： G06F17/30
CPC分类号： G06F17/30153 , G06F17/30091
摘要： Demographics for data are determined. A compression ratio (“CR”) is determined for each of a plurality of compression techniques. CR is a size of the data before compression divided into a predicted size of the data after compression. The predicted size of the data after compression is determined as a function of the determined demographics. An access efficiency of each of the compression techniques is determined as a function of the determined demographics. The compression techniques are ranked by CR and access efficiency. A compression technique is selected based on the ranking. The data is compressed using the selected compression technique. The compressed data is stored.
摘要翻译： 确定数据的人口统计。 针对多种压缩技术中的每一种确定压缩比（“CR”）。 CR是压缩前的数据的大小，分为压缩后的数据的预测大小。 压缩后的数据的预测大小被确定为确定的人口统计学的函数。 根据所确定的人口统计特征确定每种压缩技术的访问效率。 压缩技术由CR和访问效率排列。 基于排名选择压缩技术。 使用所选的压缩技术对数据进行压缩。 压缩数据被存储。
-
4.发明授权公开(公告)号：US07873629B1
公开(公告)日：2011-01-18
申请号：US10862649
申请日：2004-06-07
申请人： J. Mark Morris , Bhashyam Ramesh
发明人： J. Mark Morris , Bhashyam Ramesh
CPC分类号： G06F17/30498 , G06F17/30442
摘要： Methods, computer programs, and database systems for performing a database query to join a column A and a column B on an inequality condition are disclosed. A database includes value-count indexes for columns A and B. Minimum and a maximum values for A and B are determined, using the value-count indexes for A and B, respectively. The method includes defining three or more sets of values in A and B, relative to the minimum and maximum values for B and A, respectively. The method includes generating one or more Cartesian products between values in A and B. The database query is performed on a set of values in A and a set of values in B to generate a partial query result. The method includes merging one or more Cartesian products and the partial query result.
摘要翻译： 公开了用于执行数据库查询以在不等式条件下连接列A和列B的方法，计算机程序和数据库系统。 数据库包括A列和B列的值计数索引.A和B的最小值和最大值分别使用A和B的值计数索引确定。 该方法包括相对于B和A的最小值和最大值分别定义A和B中的三组或更多组值。 该方法包括在A和B中的值之间生成一个或多个笛卡尔乘积。数据库查询是在A中的一组值和B中的一组值中执行的，以生成部分查询结果。 该方法包括合并一个或多个笛卡尔乘积和部分查询结果。
-
公开(公告)号：US07860858B2
公开(公告)日：2010-12-28
申请号：US11328702
申请日：2006-01-10
CPC分类号： G06F17/30457 , G06Q30/0283
摘要： Processing of a request is optimized. The request has one or more predicates. A list of the one or more predicates in the request is created and predicates for which an actual cost has not been stored or for which a cost cannot be estimated are pruned from the list. An access path for the each of the predicates is selected. The request is processed using the selected access paths producing one or more actual predicate costs. The one or more actual predicate costs are stored.
摘要翻译： 优化处理请求。 请求具有一个或多个谓词。 创建请求中一个或多个谓词的列表，并创建实际成本尚未存储的谓词，或从列表中修剪成本无法估计的谓词。 选择每个谓词的访问路径。 使用所选择的访问路径处理请求，产生一个或多个实际的谓词成本。 存储一个或多个实际谓词成本。
-
6.发明申请公开(公告)号：US20090049024A1
公开(公告)日：2009-02-19
申请号：US11891919
申请日：2007-08-14
IPC分类号： G06F17/30
CPC分类号： G06F16/2453
摘要： A computer-implemented system, method and article of manufacture for managing a plurality of database systems in a domain, wherein each of the database systems are managed by one or more closed-loop system management (CLSM) regulators. A virtual regulator manages the domain, wherein the virtual regulator communicates with the CLSM regulators to monitor the database systems' system conditions and operating environment events within the domain and to provide for dynamic query optimization between the database systems within in the domain based on the system conditions and operating environment events.
摘要翻译： 一种用于管理域中的多个数据库系统的计算机实现的系统，方法和制品，其中每个数据库系统由一个或多个闭环系统管理（CLSM）调节器管理。 虚拟调节器管理域，其中虚拟调节器与CLSM调节器通信以监视数据库系统的系统状况和域内的操作环境事件，并且基于系统在域内的数据库系统之间提供动态查询优化 条件和操作环境事件。
-
公开(公告)号：US20080147603A1
公开(公告)日：2008-06-19
申请号：US11610534
申请日：2006-12-14
IPC分类号： G06F7/06
CPC分类号： G06F7/10 , G06F16/245
摘要： A method of and system for extracting time series data from temporal data in a database table is disclosed. The method comprises receiving a request for time series data, the request including information indicative of a period of time to be covered by the request, values sought by the request, time instants at which the values are sought and a precision between consecutive time instants, and creating a temporary table and populating the temporary table with a plurality of time stamps covering the period of time indicated by the request, consecutive time stamps being separated by the precision indicated by the request, and the time stamps specifying the time instants indicated by the request. The method also comprises querying the database table so as to identify for each time stamp in the temporary table, a row in the database table which has temporal data covering the time stamp and extracting values specified in the request from the identified rows, and associating the extracted data with the appropriate time stamps.
摘要翻译： 公开了一种从数据库表中的时间数据中提取时间序列数据的方法和系统。 所述方法包括接收对时间序列数据的请求，所述请求包括指示要由所述请求覆盖的时间段的信息，所述请求寻求的值，寻求所述值的时刻和连续时刻之间的精度， 以及创建一个临时表格并且填充临时表格，该多个时间戳覆盖由该请求所指示的时间段，连续的时间戳被该请求所指示的精度分隔，以及指定由该请求指示的时刻的时间戳 请求。 该方法还包括查询数据库表以识别临时表中的每个时间戳，数据库表中的一行具有覆盖时间标记的时间数据，并从所识别的行中提取请求中指定的值，并将 用适当的时间戳提取数据。
-
公开(公告)号：US07283999B1
公开(公告)日：2007-10-16
申请号：US10740780
申请日：2003-12-19
申请人： Bhashyam Ramesh , Michael W. Watzke
发明人： Bhashyam Ramesh , Michael W. Watzke
IPC分类号： G06F17/30
CPC分类号： G06F17/2211 , G06F17/30442 , G06F17/30489 , G06F17/30985 , Y10S707/99933 , Y10S707/99936
摘要： A method, computer program and system for optimizing similarity string filtering are disclosed. A first data string comprising one or more data characters and selecting a second data string comprising one or more data characters are selected. At least one of a defined set of shapes is applied to the first data string to generate one or more patterns associated with the first data string. At least one of the defined set of shapes is applied to the second data string to generate one or more patterns associated with the second data string. The one or more patterns associated with the first data string are compared with the one or more patterns associated with the second data string to determine if one or more matching patterns exist. The first data string and the second data string are linked if one or more matching patterns exist.
摘要翻译： 公开了一种用于优化相似性串过滤的方法，计算机程序和系统。 选择包括一个或多个数据字符并且选择包括一个或多个数据字符的第二数据串的第一数据串。 将定义的一组形状中的至少一个应用于第一数据串以产生与第一数据串相关联的一个或多个模式。 将所定义的一组形状中的至少一个应用于第二数据串以产生与第二数据串相关联的一个或多个模式。 将与第一数据串相关联的一个或多个模式与与第二数据串相关联的一个或多个模式进行比较，以确定是否存在一个或多个匹配模式。 如果存在一个或多个匹配模式，则第一数据串和第二数据串被链接。
-
公开(公告)号：US20070130231A1
公开(公告)日：2007-06-07
申请号：US11295409
申请日：2005-12-06
申请人： Douglas Brown , Anita Richards , Bhashyam Ramesh
发明人： Douglas Brown , Anita Richards , Bhashyam Ramesh
IPC分类号： G06F17/30
CPC分类号： G06F11/3409 , G06F11/3452 , G06F2201/80 , G06F2201/81 , G06F2201/86 , G06F2201/87
摘要： A closed-loop supportability system for a database system includes a system health check administrator to allow the definition of supportability service level goals, a supportability regulator to regulate the execution of the database system to attempt to achieve the supportability service level goals, a supportability monitor to provide real-time views of the database system performance against the supportability rules, and a supportability correlator to provide analysis of the database system performance against the supportability rules.
摘要翻译： 用于数据库系统的闭环支持系统包括系统健康检查管理员，以允许定义可支持性服务级别目标，支持性调节器来调节数据库系统的执行以尝试实现可支持性服务级别目标，可支持性监视器 根据支持性规则提供数据库系统性能的实时视图，以及可支持性相关器，根据可支持性规则提供数据库系统性能分析。
-
公开(公告)号：US20070130174A1
公开(公告)日：2007-06-07
申请号：US11295777
申请日：2005-12-07
申请人： Bhashyam Ramesh , Pekka Kostamaa
发明人： Bhashyam Ramesh , Pekka Kostamaa
IPC分类号： G06F7/00
CPC分类号： G06Q10/10 , G06Q10/06316 , G06Q40/04 , Y10S707/99943 , Y10S707/99945
摘要： A method, computer system, and database system for automating a business rule in a database are disclosed. One or more database triggers associated with a business rule state machine are enabled and the business rule state machine is initialized.
摘要翻译： 公开了一种用于使数据库中的业务规则自动化的方法，计算机系统和数据库系统。 启用与业务规则状态机关联的一个或多个数据库触发器，并初始化业务规则状态机。
-
-
-
-
-
-
-
-
-
搜索结果
72 条记录 (耗时 0.032 秒)
