Invention Grant
- Patent Title: Small table: multitenancy for lots of small tables on a cloud database
- Patent Title (中): 小表:云数据库上许多小表的多租户
-
Application No.: US12702954Application Date: 2010-02-09
-
Publication No.: US08214355B2Publication Date: 2012-07-03
- Inventor: Brian Frank Cooper
- Applicant: Brian Frank Cooper
- Applicant Address: US CA Sunnyvale
- Assignee: Yahoo! Inc.
- Current Assignee: Yahoo! Inc.
- Current Assignee Address: US CA Sunnyvale
- Agency: Weaver Austin Villeneuve and Sampson LLP
- Main IPC: G06F7/06
- IPC: G06F7/06 ; G06F17/30

Abstract:
Methods and apparatus are described for partitioning native tables in a database cluster into logical tables. Each logical table is mapped into a unique portion of the native table by an intermediary server. Clients access a logical table as an ordinary, full-fledged database table through the intermediary server, which translates queries on the logical table into queries on the corresponding portion of the native table. The mapping may use the application name, logical table name, and a version number to create a native table key for each key in the logical table. A data structure storing these mappings may be stored at the intermediary server or in a native table in the database. This approach affords clients quick and flexible access to the database with better data integrity and security than native tables allow.
Public/Granted literature
- US20110196866A1 SMALL TABLE: MULTITENANCY FOR LOTS OF SMALL TABLES ON A CLOUD DATABASE Public/Granted day:2011-08-11
Information query