🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: cn.bbs.comp.database
Article #300

Re: ��SQL˵����NoSQL����ݿ⼼������zz

#300
From: Galaxy��VOLUNTEERS��Database
Date: Tue, 07 Jul 2009 05:52
50 lines
3662 bytes
BigTable is a compressed, high performance, and proprietary database system 
built on Google File System (GFS), Chubby Lock Service, and a few other 
Google programs; it is currently not distributed or used outside of Google, 
although Google offers access to it as part of their Google App Engine.

History and Design
BigTable development began in 2004[1] and is now used by a number of Google 
applications, such as MapReduce, which is often used for generating and 
modifying data stored in BigTable[2], Google Reader,[3] Google Maps,[4] 
Google Book Search, "My Search History", Google Earth, Blogger.com, Google 
Code hosting, Orkut[4], and YouTube[5]. Google's reasons for developing its 
own database include scalability, and better control of performance 
characteristics.[6]

BigTable is a fast and extremely large-scale DBMS. However, it departs from 
the typical convention of a fixed number of columns, instead described by 
the authors as "a sparse, distributed multi-dimensional sorted map", 
sharing characteristics of both row-oriented and column-oriented databases. 
BigTable is designed to scale into the petabyte range across "hundreds or 
thousands of machines, and to make it easy to add more machines [to] the 
system and automatically start taking advantage of those resources without 
any reconfiguration".[7]

Each table has multiple dimensions (one of which is a field for time, 
allowing versioning). Tables are optimized for GFS by being split into 
multiple tablets - segments of the table as split along a row chosen such 
that the tablet will be ~200 megabytes in size. When sizes threaten to grow 
beyond a specified limit, the tablets are compressed using the algorithm 
BMDiff[8] (referenced in [9]) and the secret algorithm Zippy[10], which is 
described as less space-optimal variation of LZO but more efficient in 
terms of computing time. The locations in the GFS of tablets are recorded 
as database entries in multiple special tablets, which are called "META1" 
tablets. META1 tablets are found by querying the single "META0" tablet, 
which typically has a machine to itself since it is often queried by 
clients as to the location of the "META1" tablet which itself has the 
answer to the question of where the actual data is located. Like GFS's 
master server, the META0 server is not generally a bottleneck since the 
processor time and bandwidth necessary to discover and transmit META1 
locations is minimal and clients aggressively cache locations to minimize 
queries.


--
Welcome to Database Board
��ӭ������ݿ��
http://bbs.sjtu.edu.cn/bbsdoc?board=database

�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 207.46.55.30]

�� �޸ı���:��Dem �� 07��07��13:52:25 �޸ı��ġ�[FROM: 207.46.55.30]
Technical Details
Message-ID: <4gh97L$c0i@bbs.sjtu.edu.cn>
Path: arc1-ca.pugleaf.net!g2news2.google.com!news1.google.com!npeer02.iad.highwinds-media.com!news.highwinds-media.com!feed-me.highwinds-media.com!news.glorb.com!news2.glorb.com!news.neu.edu.cn!news.shec6.edu.cn!SJTU

Show Full Headers
Complete Article Headers
X-Google-Thread: 4df683fd51,498f3b6da5438e4a,start
X-Google-Attributes: gid4df683fd51,public,usenet
X-Google-NewGroupId: yes
X-Google-Language: ENGLISH,GB
Path: arc1-ca.pugleaf.net!g2news2.google.com!news1.google.com!npeer02.iad.highwinds-media.com!news.highwinds-media.com!feed-me.highwinds-media.com!news.glorb.com!news2.glorb.com!news.neu.edu.cn!news.shec6.edu.cn!SJTU
From: Dem.bbs@bbs.sjtu.edu.cn (Galaxy��VOLUNTEERS��Database)
Newsgroups: cn.bbs.comp.database
Subject: Re: ��SQL˵����NoSQL����ݿ⼼������zz
Date: 07 Jul 2009 05:52:25 GMT
Organization: ��ˮ˼Դ
Message-ID: <4gh97L$c0i@bbs.sjtu.edu.cn>
Mime-Version: 1.0
Content-Type: text/plain; charset="gb2312"
Content-Transfer-Encoding: 8bit
X-Filename: database/M.1246945893.A