Method and apparatus for generating partitioning keys for a range-partitioned database

作者: Terence Patrick Purcell , Richard J. Brodfuehrer , Michael S. Wang , Kim Jon Worm

DOI:

关键词:

摘要: A method and apparatus for generating partition keys in an information handling system having a partitioned database. Partition are generated by concatenating subrange identifier specifying of key values sequence number particular value within subrange. assigned with the aid control table that stores available block is updated whenever blocks reserved or database repartitioned. An activity indicator maintained each indicates recent partition. In response to request key, selected assignment least as indicated its indicator. Specific indicators disclosed include timestamp table, well count threads application instance concurrently accessing

参考文章(11)
Michael Negley Abernethy, Syed-Muasir Khalil, Truong-an Hoan Thai, Travis M. Grigsby, Method and apparatus for improving cluster performance through minimization of method variation ,(2006)
Donald S. Maier, Roberta S. Marton, Pedro Celis, James H. Troisi, Relational database system and method with high data availability during table data restructuring ,(1996)
Wendy Tobagus, Sunil Kosalge, Dan Moisa, David L. Butcher, Database partitioning by virtual partitions ,(2006)
Christopher Michael Richardson, William Preston Alexander, Kean G Kuiper, Method and system for maintaining consistency during multi-threaded processing of LDIF data ,(2003)
Edward A. Heiner, David J. Husak, G. Stodel Friedman, Seters Stephen L. Van, Method and apparatus for multipoint trunking ,(1998)
Guy Restiau, Didier Ingels, Sharing of non-divisible files ,(2005)
Christine Pae Guthrie, Jesper Andersen, Douglas James McMahon, Chon Hei Lei, Virtually partitioning user data in a database system ,(2001)
Hao Wang, Jinmei Shen, Moving records between partitions ,(2008)