Abstract
Our previous work has shown that architectural and application shifts have resulted in modern OLTP databases increasingly falling short of optimal performance [10]. In particular, the availability of multiple-cores, the abundance of main memory, the lack of user stalls, and the dominant use of stored procedures are factors that portend a clean-slate redesign of RDBMSs. This previous work showed that such a redesign has the potential to outperform legacy OLTP databases by a significant factor. These results, however, were obtained using a bare-bones prototype that was developed just to demonstrate the potential of such a system. We have since set out to design a more complete execution platform, and to implement some of the ideas presented in the original paper. Our demonstration presented here provides insight on the development of a distributed main memory OLTP database and allows for the further study of the challenges inherent in this operating environment.
- M. M. Astrahan, M. W. Blasgen, D. D. Chamberlin, K. P. Eswaran, J. N. Gray, P. P. Griffiths, W. F. King, R. A. Lorie, P. R. McJones, J. W. Mehl, G. R. Putzolu, I. L. Traiger, B. W. Wade, and V. Watson. System R: relational approach to database management. ACM Trans. Database Syst., 1(2):97--137, 1976. Google ScholarDigital Library
- D. J. DeWitt, R. H. Gerber, G. Graefe, M. L. Heytens, K. B. Kumar, and M. Muralikrishna. Gamma - a high performance dataflow database machine. In VLDB '86, pages 228--237, 1986. Google ScholarDigital Library
- W. Hong and M. Stonebraker. Optimization of parallel query execution plans in xprs. In PDIS '91, pages 218--225, 1991. Google ScholarDigital Library
- H. V. Jagadish, D. F. Lieuwen, R. Rastogi, A. Silberschatz, and S. Sudarshan. Dali: A high performance main memory storage manager. In VLDB '94, pages 48--59, 1994. Google ScholarDigital Library
- I. Lee and H. Y. Yeom. A single phase distributed commit protocol for main memory database systems. In IPDPS '02, page 44, 2002. Google ScholarDigital Library
- A.-P. Liedes and A. Wolski. SIREN: A memory-conserving, snapshot-consistent checkpoint algorithm for in-memory databases. In ICDE '06, page 99, 2006. Google ScholarDigital Library
- M. Stonebraker, D. J. Abadi, A. Batkin, X. Chen, M. Cherniack, M. Ferreira, E. Lau, A. Lin, S. Madden, E. O'Neil, P. O'Neil, A. Rasin, N. Tran, and S. Zdonik. C-Store: A column-oriented dbms. In VLDB '05, pages 553--564, 2005. Google ScholarDigital Library
- M. Stonebraker, C. Bear, U. Cetintemel, M. Cherniack, T. Ge, N. Hachem, S. Harizopoulos, J. Lifter, J. Rogers, and S. B. Zdonik. One size fits all? part 2: Benchmarking studies. In CIDR '07, pages 173--184, 2007.Google Scholar
- M. Stonebraker and U. Cetintemel. "one size fits all": An idea whose time has come and gone. In ICDE '05, pages 2--11, 2005. Google ScholarDigital Library
- M. Stonebraker, S. Madden, D. J. Abadi, S. Harizopoulos, N. Hachem, and P. Helland. The end of an architectural era: (it's time for a complete rewrite). In VLDB '07, pages 1150--1160, 2007. Google ScholarDigital Library
- The Transaction Processing Council. TPC-C Benchmark (Revision 5.9.0). http://www.tpc.org/tpcc/spec/tpcc_current.pdf, June 2007.Google Scholar
- A. Whitney, D. Shasha, and S. Apter. High volume transaction processing without concurrency control, two phase commit, sql or c. In Int. Workshop on High Performance Transaction Systems.Google Scholar
Index Terms
- H-store: a high-performance, distributed main memory transaction processing system
Recommendations
E-store: fine-grained elastic partitioning for distributed transaction processing systems
On-line transaction processing (OLTP) database management systems (DBMSs) often serve time-varying workloads due to daily, weekly or seasonal fluctuations in demand, or because of rapid growth in demand due to a company's business success. In addition, ...
Store and Visualize EER in Neo4j
ISCSIC '18: Proceedings of the 2nd International Symposium on Computer Science and Intelligent ControlNoSQL databases have become very popular in the last few years. Graph databases, as a major NoSQL database type, are used for many problems. In relational databases, conceptual modeling is very important, for which Enhanced Entity-Relationship (EER) ...
Forensic investigation framework for the document store NoSQL DBMS
The NoSQL DBMS provides an efficient means of storing and accessing big data because its servers are more easily horizontally scalable and replicable than relational DBMSs. Its data model lacks a fixed schema, so that users can easily dynamically change ...
Comments