Đang chuẩn bị liên kết để tải về tài liệu:
The Vertica Analytic Database: C­Store 7 Years Later

The Pesticide-Induced Diseases Database, launched by Beyond Pesticides, facilitates access to epidemiologic and laboratory studies based on real world exposure scenarios that link public health effects to pesticides. The scientific literature documents elevated rates of chronic diseases among people exposed to pesticides, with increasing numbers of studies associated with both specific illnesses and a range of illnesses. With some of these diseases at very high and, perhaps, epidemic proportions, there is an urgent need for public policy at all levels –local, state, and national—to end dependency on toxic pesticides, replacing them with carefully defined green strategies. . | The Vertica Analytic Database C-Store 7 Years Later Andrew Lamb Matt Fuller Ramakrishna Varadarajan Nga Tran Ben Vandiver Lyric Doshi Chuck Bear Vertica Systems An HP Company Cambridge MA alamb mfuller rvaradarajan ntran bvandiver ldoshi cbear @vertica.com ABSTRACT This paper describes the system architecture of the Ver-tica Analytic Database Vertica a commercialization of the design of the C-Store research prototype. Vertica demonstrates a modern commercial RDBMS system that presents a classical relational interface while at the same time achieving the high performance expected from modern web scale analytic systems by making appropriate architectural choices. Vertica is also an instructive lesson in how academic systems research can be directly commercialized into a successful product. 1. INTRODUCTION The Vertica Analytic Database Vertica is a distributed1 massively parallel RDBMS system that commercializes the ideas of the C-Store 21 project. It is one of the few new commercial relational database systems that is widely used in business critical systems. At the time of this writing there are over 500 production deployments of Vertica at least three of which are substantially over a petabyte in size. Despite the recent interest in academia and industry about so called NoSQL systems 13 19 12 the C-Store project anticipated the need for web scale distributed processing and these new NoSQL systems use many of the same techniques found in C-Store and other relational systems. Like any language or system SQL is not perfect but it has been a transformational abstraction for application developers freeing them from many implementation details of storing and finding their data to focus their efforts on using the information effectively. Vertica s experience in the marketplace and the emergence of other technologies such as Hive 7 and Tenzing 9 validate that the problem is not SQL. Rather the unsuitability of legacy RDBMs systems for massive analytic workloads is 1We use