公开(公告)号：US20180356993A1

公开(公告)日：2018-12-13

申请号：US16107750

申请日：2018-08-21

Applicant: International Business Machines Corporation

Inventor： Mihail C. Constantinescu ,  Abdullah Gharaibeh ,  Maohua Lu ,  David A. Pease ,  Anurag Sharma

IPC: G06F3/06 ,  G11B27/032 ,  G11B5/86 ,  G06F17/30

CPC classification number: G06F3/0608 ,  G06F3/0641 ,  G06F3/0682 ,  G06F16/1748 ,  G06F16/24557 ,  G11B5/86 ,  G11B27/032

Abstract: Data deduplication for data storage tapes includes intercepting tape control commands for a single data storage tape. The intercepted tape control commands are modified for adding processing logic and parameters for placement of deduplicated file data on the single data storage tape. Deduplication metadata is written to a metadata portion of the single data storage tape. The deduplicated file data is written to a data portion of the single data storage tape based on the placement to increase read throughput for a deduplicated set of individual files and to reduce an average number of per-file gaps on the single data storage tape without re-duplicating deduplicated data for meeting optimization of individual file accesses.

公开(公告)号：US20180203896A1

公开(公告)日：2018-07-19

申请号：US15800762

申请日：2017-11-01

Applicant: ELECTRONICS AND TELECOMMUNICATIONS RESEARCH INSTITUTE

Inventor： Moonyoung CHUNG ,  Taewhi LEE ,  Sung-Soo KIM ,  Hyewon SONG ,  Jongho WON

IPC: G06F17/30

CPC classification number: G06F16/2453 ,  G06F16/2255 ,  G06F16/2264 ,  G06F16/24554 ,  G06F16/24557 ,  G06F16/322 ,  H04L67/1097

Abstract: A method and an apparatus for processing a query are disclosed. When the query is input, in a case in which partitions are present in a data table, a partition corresponding to the input query is selected, and in a case in which one or more partition column sets are present in the selected partition, one or more partition column sets corresponding to the input query are selected, and the query is processed for the selected partition column sets.

公开(公告)号：US20160328448A1

公开(公告)日：2016-11-10

申请号：US15213687

申请日：2016-07-19

Applicant: International Business Machines Corporation

Inventor： Soh Kaijima ,  Katsuyoshi Katori ,  Seiji Minami ,  Masakazu Sano

IPC: G06F17/30 ,  G06F11/14 ,  G06F11/20

CPC classification number: G06F16/24557 ,  G06F11/1451 ,  G06F11/2056 ,  G06F11/2094 ,  G06F16/24569 ,  G06F16/27 ,  G06F2201/80

Abstract: A system for managing a plurality of storage devices that are configured to store a database. The system includes an access instruction acquiring unit configured for acquiring an access instruction to access the database. The system also includes a predicting unit configured for predicting a table to be accessed in response to the acquired access instruction. The system further includes a relocation unit configured for mirroring the table predicted by the predicting unit, the mirroring between the plurality of storage devices.

Abstract translation: 一种用于管理被配置为存储数据库的多个存储设备的系统。 该系统包括访问指令获取单元，被配置为获取访问数据库的访问指令。 该系统还包括：预测单元，被配置为响应于获取的访问指令来预测要访问的表。 该系统还包括：重定位单元，被配置为镜像由预测单元预测的表，多个存储设备之间的镜像。

公开(公告)号：US20160054952A1

公开(公告)日：2016-02-25

申请号：US14777871

申请日：2013-03-18

Applicant: GE Intelligent Platforms, Inc.

Inventor： Sunil MATHUR ,  Jerry LIN

IPC: G06F3/06 ,  G06F17/30

CPC classification number: G06F3/0649 ,  G06F3/0605 ,  G06F3/0685 ,  G06F16/2454 ,  G06F16/24557 ,  G06F16/24564

Abstract: A first query and a second query are received. The first query and the second query are evaluated and, based upon the evaluating, identifying first time series data required to fulfill the first query and second time series data required to fulfill the second query. An extent of overlap of the first time series data and the second time series data is determined. When the extent of overlap exceeds a predetermined threshold, the overlapping data is retrieved from a plurality of data storage devices in parallel, the data retrieved across all of the plurality of storage devices via a single read operation.

Abstract translation: 接收到第一个查询和第二个查询。 评估第一查询和第二查询，并且基于评估，识别满足第一查询所需的第一时间序列数据和满足第二查询所需的第二时间序列数据。 确定第一时间序列数据和第二时间序列数据的重叠程度。 当重叠的范围超过预定阈值时，并行地从多个数据存储设备中检索重叠数据，经由单个读取操作跨越所有多个存储设备检索的数据。

公开(公告)号：US20140089311A1

公开(公告)日：2014-03-27

申请号：US13627203

申请日：2012-09-26

Applicant: Anita Richards ,  Douglas Brown ,  Bruce Britton ,  Todd Walter

Inventor： Anita Richards ,  Douglas Brown ,  Bruce Britton ,  Todd Walter

IPC: G06F17/30

CPC classification number: G06F11/0754 ,  G06F11/0727 ,  G06F16/217 ,  G06F16/2453 ,  G06F16/24549 ,  G06F16/24557

Abstract: A system, method, and computer-readable medium that facilitate classification of database requests as problematic based on estimated processing characteristics of the request are provided. Estimated processing characteristics may include estimated skew including central processing unit skew and input/output operation skew, central processing unit duration per input/output operation, and estimated memory usage. The estimated processing characteristics are made on a request step basis. The request is classified as problematic responsive to determining one or more of the estimated characteristics of a request step exceed a corresponding threshold. In this manner, mechanisms for predicting bad query behavior are provided. Workload management of those requests may then be more successfully provided through workload throttles, filters, or even a more confident exception detection that correlates with the estimated bad behavior.

Abstract translation: 提供了一种系统，方法和计算机可读介质，其基于所请求的估计处理特性，有助于将数据库请求分类为有问题的。 估计的处理特性可以包括估计的偏差，包括中央处理单元偏移和输入/输出操作偏移，每个输入/输出操作的中央处理单元持续时间和估计的存储器使用。 估计的处理特性是在请求步骤的基础上进行的。 响应于确定请求步骤的估计特性中的一个或多个超过相应的阈值，将该请求分类为有问题的。 以这种方式，提供了用于预测不良查询行为的机制。 那么这些请求的工作负载管理可以通过工作负载节流，过滤器或甚至与估计的不良行为相关的更自信的异常检测来更成功地提供。

公开(公告)号：US20110289086A1

公开(公告)日：2011-11-24

申请号：US13112427

申请日：2011-05-20

Applicant: Philip Martin Jordan ,  Vilosh Marion Brito

Inventor： Philip Martin Jordan ,  Vilosh Marion Brito

IPC: G06F17/30

CPC classification number: G06F16/215 ,  G06F16/24557

Abstract: A system and method for searching a database for multiple entries in the database that contain similar data, in which some embodiments of the method include collating data on physical sites from at least one database source to form a collation of site data, assigning a unique entry identifier to each entry of the site data in the collation, performing a lexical analysis of the site data and assigning a similarity metric(s) to each entry of the site data, sorting site data into at least one group with similar lexical content based on a metric threshold difference analysis of the similarity metric(s), to thereby provide at least one group, having at least one site data entry therein, and wherein where there are two or more site data entries in the at least one group, preferably they refer to the same site or to sites having a similar physical address.

Abstract translation: 一种用于在数据库中搜索数据库中包含类似数据的多个条目的系统和方法，其中所述方法的一些实施例包括将来自至少一个数据库源的物理站点上的数据整理以形成站点数据的归类，分配唯一条目 标识符到排序规则中的站点数据的每个条目，对站点数据执行词汇分析并且将相似性度量分配给站点数据的每个条目，将站点数据分类成至少一个具有类似词汇内容的组，基于 相似性度量的度量阈值差分析，从而提供至少一个在其中具有至少一个站点数据条目的组，并且其中在所述至少一个组中存在两个或更多个站点数据条目的情况下，优选地， 请参考相同的站点或具有相似物理地址的站点。

公开(公告)号：US20100122026A1

公开(公告)日：2010-05-13

申请号：US12691146

申请日：2010-01-21

Applicant: Kothanda Umamageswaran ,  Juan R. Loaiza ,  Umesh Panchaksharaiah ,  Alexander Tsukerman ,  Timothy L. Shetler ,  Bharat C.V. Baddepudi ,  Boris Erlikhman ,  Kiran B. Goyal ,  Nilesh Choudhury ,  Susy Fan ,  Poojan Kumar ,  Selcuk Aya ,  Sue-Kyoung Lee

Inventor： Kothanda Umamageswaran ,  Juan R. Loaiza ,  Umesh Panchaksharaiah ,  Alexander Tsukerman ,  Timothy L. Shetler ,  Bharat C.V. Baddepudi ,  Boris Erlikhman ,  Kiran B. Goyal ,  Nilesh Choudhury ,  Susy Fan ,  Poojan Kumar ,  Selcuk Aya ,  Sue-Kyoung Lee

IPC: G06F12/08 ,  G06F12/00

CPC classification number: G06F12/084 ,  G06F12/0811 ,  G06F12/0866 ,  G06F12/0888 ,  G06F16/24552 ,  G06F16/24557

Abstract: Techniques are provided for using an intermediate cache to provide some of the items involved in a scan operation, while other items involved in the scan operation are provided from primary storage. Techniques are also provided for determining whether to service an I/O request for an item with a copy of the item that resides in the intermediate cache based on factors such as a) an identity of the user for whom the I/O request was submitted, b) an identity of a service that submitted the I/O request, c) an indication of a consumer group to which the I/O request maps, d) whether the I/O request is associated with an offloaded filter provided by the database server to the storage system, or e) whether the intermediate cache is overloaded. Techniques are also provided for determining whether to store items in an intermediate cache in response to the items being retrieved, based on logical characteristics associated with the requests that retrieve the items.

Abstract translation: 提供了使用中间缓存来提供扫描操作中涉及的一些项目的技术，而从主存储器提供涉及扫描操作的其他项目。 还提供了用于基于以下因素来确定是否对具有驻留在中间高速缓存中的项目的副本的项目的I / O请求进行服务的技术，例如：a）向其提交I / O请求的用户的身份 b）提交I / O请求的服务的身份，c）I / O请求所映射的消费者组的指示，d）I / O请求是否与由所述I / O请求提供的卸载过滤器相关联 数据库服务器到存储系统，或e）中间缓存是否重载。 还提供了基于与检索项目的请求相关联的逻辑特征来确定是否将项目存储在中间高速缓存中以响应于正被检索的项目的技术。

公开(公告)号：US20090063589A1

公开(公告)日：2009-03-05

申请号：US11847306

申请日：2007-08-29

Applicant: Philip S. Cox ,  Leo T. M. Lau ,  Adil M. Sardar ,  David Tremaine

Inventor： Philip S. Cox ,  Leo T. M. Lau ,  Adil M. Sardar ,  David Tremaine

IPC: G06F17/30

CPC classification number: G06F16/24557 ,  G06F16/24547

Abstract: An apparatus and method to to decouple large object (“LOB”) data processing from main-line data processing in a shared-nothing architecture. The method may include relocating rows in a database table from a source partition to a target partition, where each row stores a source descriptor identifying a LOB associated with the row. The source descriptors may be read, and space sufficient to store each LOB in a target repository may be allocated accordingly. Source descriptors may be extracted from the rows, and sorted according to the location of the LOBs in the source repository to provide an ordered retrieval sequence. Each LOB may be retrieved from the source repository according to the retrieval sequence, and stored in its allocated space. The source descriptor stored in each row in the target partition may then be replaced with a target descriptor to identify the location of the respective LOB in the target repository.

Abstract translation: 一种用于在无共享架构中将大对象（“LOB”）数据处理与主线数据处理分离的装置和方法。 该方法可以包括将数据库表中的行从源分区重新定位到目标分区，其中每行存储标识与该行相关联的LOB的源描述符。 可以读取源描述符，并且可以相应地分配足以存储目标存储库中的每个LOB的空间。 可以从行中提取源描述符，并根据源存储库中的LOB的位置进行排序以提供有序检索序列。 可以根据检索顺序从源存储库检索每个LOB，并存储在其分配的空间中。 存储在目标分区中的每行中的源描述符然后可以用目标描述符来替换，以标识目标存储库中相应LOB的位置。

公开(公告)号：US20080222086A1

公开(公告)日：2008-09-11

申请号：US12125682

申请日：2008-05-22

Applicant: Paul Meacham ,  Jacob Doornebos ,  James P. Moran

Inventor： Paul Meacham ,  Jacob Doornebos ,  James P. Moran

IPC: G06F7/00 ,  G06F17/30

CPC classification number: G06F16/24557 ,  G06Q40/04

Abstract: Systems and methods for reconstructing the state of a market are provided. Orders are arranged as a non-indexed collection of orders and may be stored in the cache memory of a processor. The physical locations of orders stored in the memory may correspond to the order in which they were received at a match engine. A computer device simulates the processing of orders between any time periods to reconstruct the activity state of an entity across a trading platform and one or more order books.

Abstract translation: 提供了重建市场状况的系统和方法。 订单被排列成非索引的订单集合，并且可以存储在处理器的高速缓冲存储器中。 存储在存储器中的订单的物理位置可以对应于它们在匹配引擎处被接收的顺序。 计算机设备模拟任何时间段之间的订单处理，以重建跨越交易平台和一个或多个订单簿的实体的活动状态。

公开(公告)号：US20050004906A1

公开(公告)日：2005-01-06

申请号：US10910119

申请日：2004-08-03

Applicant: Paul Huffman ,  Kathy McKnight ,  David Sharpe ,  Daniel Zilio

Inventor： Paul Huffman ,  Kathy McKnight ,  David Sharpe ,  Daniel Zilio

IPC: G06F12/00 ,  G06F17/30

CPC classification number: G06F16/24554 ,  G06F16/24557 ,  Y10S707/99932 ,  Y10S707/99933 ,  Y10S707/99935 ,  Y10S707/99943 ,  Y10S707/99945

Abstract: A query processing system has a query processor and a data manager. The query processor calls the data manager to carry out data access for a query including a filtering operation. The data manager accesses the data in a set of data and before returning the data, initiates a callback to the query processor to determine if the located data meets the filtering criteria. Where the data does not satisfy the filtering criteria, the data manager seeks additional data in the set of data, without having to return the first located data to the query processor.

Abstract translation: 查询处理系统具有查询处理器和数据管理器。 查询处理器调用数据管理器对包括过滤操作的查询执行数据访问。 数据管理器访问一组数据中的数据，并在返回数据之前，向查询处理器发起回调，以确定所查找的数据是否满足过滤条件。 在数据不满足过滤标准的情况下，数据管理器在数据集中寻求附加数据，而不必将第一定位数据返回给查询处理器。