ABSTRACT
Database systems in the context of business data processing are segmented into two categories: those intended for online transaction processing (OLTP) and those for online analytical processing (OLAP). Over the last 15 years, database management system (DBMS) proposals directly addressing one of those categories were most represented in terms of academic publications and variety of commercial products in the domain of enterprise computing.
In contrast, the most innovative DBMS proposals in this century were invented not by addressing a well-known category but by following a methodology that purely focuses on the application characteristics as practiced by Amazon or Google. This paper applies a part of that methodology to the field of enterprise applications in order to evaluate to what extend they are covered by the categories OLTP and OLAP. The evaluation shows that there are enterprise applications that reveal a mix of those characteristics which are usually exclusively associated either with OLTP or with OLAP and therefore cannot be addressed adequately by traditional DBMS.
The paper contributes by pointing out that those applications cause an online mixed workload and by explaining what properties a corresponding specialized DBMS should have and how this category of enterprise applications could benefit from it.
- B. Baryshnikov, C. Clinciu, C. Cunningham, L. Giakoumakis, S. Oks, and S. Stefani. Managing Query Compilation Memory Consumption to Improve DBMS Throughput. In CIDR, 2007.Google Scholar
- K. P. Brown, M. Mehta, M. J. Carey, and M. Livny. Towards Automated Performance Tuning for Complex Workloads. In VLDB, 1994. Google ScholarDigital Library
- E. Codd, S. B. Codd, and C. T. Salley. Providing OLAP (on-line analytical processing) to user-analysts: An IT mandate. Technical report, E. F. Codd & Associates, 1993.Google Scholar
- G. Decandia, D. Hastorun, M. Jampani, G. Kakulapati, A. Lakshman, A. Pilchin, S. Sivasubramanian, P. Vosshall, and W. Vogels. Dynamo: amazon's highly available key-value store. In ACM SIGOPS, 2007. Google ScholarDigital Library
- M. Fowler. Patterns of Enterprise Application Architecture. Addison-Wesley Professional, 2002. Google ScholarDigital Library
- C. D. French. "One size fits all" database architectures do not work for DSS. In ACM SIGMOD. ACM, 1995. Google ScholarDigital Library
- M. L. Gilenson, P. Ponniah, A. Kriegel, B. Trukhnov, A. G. Taylor, G. Powell, and F. Miller. Introduction to Database Management. Wiley Pathways, 2008.Google Scholar
- T. Hogan. Overview of tpc benchmark e: The next generation of oltp benchmarks. pages 84--98, 2009. Google ScholarDigital Library
- W. H. Inmon. Building the Operational Data Store. John Wiley & Sons, Inc., New York, NY, USA, 1999. Google ScholarDigital Library
- H. Pang, M. J. Carey, and M. Livny. Multiclass Query Scheduling in Real-Time Database Systems. IEEE Trans. on Knowl. and Data Eng., 1995. Google ScholarDigital Library
- S. Parekh, S. Parekh, K. Rose, K. Rose, J. Hellerstein, J. Hellerstein, S. Lightstone, S. Lightstone, M. Huras, M. Huras, V. Chang, and V. Chang. Managing the Performance Impact of Administrative Utilities. In in IFIP Conference on Distributed Systems Operations and Management, 2003.Google Scholar
- H. Plattner. A common database approach for OLTP and OLAP using an in-memory column database. In SIGMOD Conference, 2009. Google ScholarDigital Library
- W. Powley, P. Martin, and P. Bird. Dbms workload control using throttling: experimental insights. In Proceedings of the conference of the center for advanced studies on collaborative research, pages 1--13, New York, NY, USA, 2008. ACM. Google ScholarDigital Library
- M. Stonebraker, U. Bear, 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, 2007.Google Scholar
- M. Stonebraker and U. Cetintemel. "One Size Fits All": An Idea Whose Time Has Come and Gone. In ICDE, 2005. Google ScholarDigital Library
- E. Thomsen. OLAP Solutions: Building Multidimensional Information Systems. John Wiley Sons, Inc., New York, NY, USA, 2002. Google ScholarDigital Library
- A case for online mixed workload processing
Recommendations
Normalization in a mixed OLTP and OLAP workload scenario
TPCTC'11: Proceedings of the Third TPC Technology conference on Topics in Performance Evaluation, Measurement and CharacterizationThe historically introduced separation of online analytical processing (OLAP) from online transaction processing (OLTP) is in question considering the current developments of databases. Column-oriented databases mainly used in the OLAP environment so ...
On Workload Characterization of Relational Database Environments
A relational database workload analyzer (REDWAR) is developed to characterize the workload in a DB2 environment. This is applied to study a production DB2 system where a structured query language (SQL) trace for a two-hour interval and an image copy of ...
Aggregation strategies for columnar in-memory databases in a mixed workload
PIKM '11: Proceedings of the 4th workshop on Workshop for Ph.D. students in information & knowledge managementThe recent trend towards analytics on operational data has led to an approach of reunifying online transactional processing and online analytical processing in one single database. The advent of columnar in-memory databases makes this viable and ...
Comments