Invention Grant
- Patent Title: Managing access to data in a multi-temperature database
- Patent Title (中): 管理多温度数据库中的数据访问
-
Application No.: US11565757Application Date: 2006-12-01
-
Publication No.: US09015146B2Publication Date: 2015-04-21
- Inventor: Anita Richards , Douglas P. Brown
- Applicant: Anita Richards , Douglas P. Brown
- Applicant Address: US OH Dayton
- Assignee: Teradata US, Inc.
- Current Assignee: Teradata US, Inc.
- Current Assignee Address: US OH Dayton
- Agent John D. Cowart; Ramin Mahboubian
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
An optimization technique is provided that optimizes data access by mapping each table, or row and/or column in a table, to a particular query, depending on whether the data in said table, row or column is ‘hot’ or ‘cold’ data. In one aspect, the invention features a method for optimizing the access time of an SQL query to a database including data. The method includes receiving, for each query type, a data frequency access measure and associating each query type with a processing rule set, according to the received data frequency access measure.
Public/Granted literature
- US20080133456A1 MANAGING ACCESS TO DATA IN A MULTI-TEMPERATURE DATABASE Public/Granted day:2008-06-05
Information query