The Community for Technology Leaders
RSS Icon
Issue No.04 - April (2011 vol.23)
pp: 554-567
Yan Zhou , State University of New York at Binghamton, Binghamton
Kyoung-Don Kang , State University of New York at Binghamton, Binghamton
It is essential to process real-time data service requests such as stock quotes and trade transactions in a timely manner using fresh data, which represent the current real-world phenomena such as the stock market status. Users may simply leave when the database service delay is excessive. Also, temporally inconsistent data may give an outdated view of the real-world status. However, supporting the desired timeliness and freshness is challenging due to dynamic workloads. To address the problem, we present new approaches for 1) database backlog estimation, 2) fine-grained closed-loop admission control based on the backlog model, and 3) incoming load smoothing. Our backlog estimation and control-theoretic approaches aim to support the desired service delay bound without degrading the data freshness, critical for real-time data services. Specifically, we design, implement, and evaluate two feedback controllers based on linear control theory and fuzzy logic control theory, to meet the desired service delay. Workload smoothing, under overload, helps the database admit and process more transactions in a timely fashion by probabilistically reducing the burstiness of incoming data service requests. In terms of the data service delay and throughput, our closed-loop admission control and probabilistic load smoothing schemes considerably outperform several baselines in the experiments undertaken in a stock trading database testbed.
Quality of real-time data service management, linear control theory, fuzzy logic control theory.
Yan Zhou, Kyoung-Don Kang, "Estimating and Enhancing Real-Time Data Service Delays: Control-Theoretic Approaches", IEEE Transactions on Knowledge & Data Engineering, vol.23, no. 4, pp. 554-567, April 2011, doi:10.1109/TKDE.2010.138
[1] K.D. Kang, J. Oh, and Y. Zhou, "Backlog Estimation and Management for Real-Time Data Services," Proc. 20th Euromicro Conf. Real-Time Systems, 2008.
[2] K. Ramamritham, S.H. Son, and L.C. Dipippo, "Real-Time Databases and Data Services," Real-Time Systems, vol. 28, pp. 179-215, Nov./Dec. 2004.
[3] J.L. Hellerstein, Y. Diao, S. Parekh, and D.M. Tilbury, Feedback Control of Computing Systems. John Wiley and Sons, 2004.
[4] K.M. Passino and S. Yurkovich, Fuzzy Control. Addison Wesley, 1998.
[5] M. Amirijoo, J. Hansson, and S.H. Son, "Specification and Management of QoS in Real-Time Databases Supporting Imprecise Computations," IEEE Trans. Computers, vol. 55, no. 3, pp. 304-319, Mar. 2006.
[6] K.D. Kang, S.H. Son, and J.A. Stankovic, "Managing Deadline Miss Ratio and Sensor Data Freshness in Real-Time Databases," IEEE Trans. Knowledge and Data Eng., vol. 16, no. 10, pp. 1200-1216, Oct. 2004.
[7] K.D. Kang, J. Oh, and S.H. Son, "Chronos: Feedback Control of a Real Database System Performance," Proc. 28th IEEE Real-Time Systems Symp., 2007.
[8] "Oracle Berkeley DB Product Family," index.html. 2010.
[9] K.J. Aström and B. Wittenmark, Adaptive Control. Addison Wesley, 1995.
[10] M. Xiong and K. Ramamritham, "Deriving Deadlines and Periods for Real-Time Update Transactions," IEEE Trans. Computers, vol. 53, no. 5, pp. 567-583, May 2004.
[11] D. Vrancic, "Design of Anti-Windup and Bumpless Transfer Protection," PhD dissertation, Univ. of Ljubljana, 1997.
[12] K.D. Kang, P.H. Sin, J. Oh, and S.H. Son, "A Real-Time Database Testbed and Performance Evaluation," Proc. 13th IEEE Int'l Conf. Embedded and Real-Time Computing Systems and Applications, 2007.
[13] "Transaction Processing Performance Council," http:/, 2010.
[14] "Rubis: Rice Univ. Bidding System," http:/, 2010.
[15] R. Ramakrishnan and J. Gehrke, Database Management Systems, third ed. McGraw-Hill, 2003.
[16] J.F. Kurose and K.W. Ross, Computer Networking. Addison Wesley, 2007.
[17] C.L. Phillips and H.T. Nagle, Digital Control System Analysis and Design, third ed. Prentice Hall, 1995.
[18] N.R. Draper and H. Smith, Applied Regression Analysis. Wiley, 1968.
[19] S. Kim, S.H. Son, and J.A. Stankovic, "Performance Evaluation on a Real-Time Database," Proc. IEEE Real-Time Technology and Applications Symp., 2002.
[20] Lockheed Martin "EagleSpeed Real-Time Database Manager."
[21] C. Lu, J.A. Stankovic, G. Tao, and S.H. Son, "Feedback Control Real-Time Scheduling: Framework, Modeling and Algorithms," Real-Time Systems, Special Issue on Control-Theoretical Approaches to Real-Time Computing, vol. 23, nos. 1/2, July-Sept. 2002.
[22] H. Qu, A. Labrinidis, and D. Mossé, "UNIT: User-Centric Transaction Management in Web-Database Systems," Proc. 22nd Int'l Conf. Data Eng., 2006.
[23] H. Qu and A. Labrinidis, "Preference-Aware Query and Update Scheduling in Web-Databases," Proc. 23rd Int'l Conf. Data Eng., 2007.
[24] S. Parekh, K. Rose, Y. Diao, V. Chang, J. Hellerstein, S. Lightstone, and M. Huras, "Throttling Utilities in the IBM DB2 Universal Database Server," Proc. 2004 Am. Control Conf., vol. 3, pp. 1986-1991, June 2004.
[25] B. Schroeder, M. Harchol-Balter, A. Iyengar, E. Nahum, and A. Wierman, "How to Determine a Good Multi-Programming Level for External Scheduling," Proc. 22nd Int'l Conf. Data Eng., pp. 60-71, 2006.
[26] C. Lu, Y. Lu, T. Abdelzaher, J.A. Stankovic, and S. Son, "Feedback Control Architecture and Design Methodology for Service Delay Guarantees in Web Servers," IEEE Trans. Parallel and Distributed Systems, vol. 17, no. 9, pp. 1014-1027, Sept. 2006.
[27] D. Henriksson, Y. Lu, and T. Abdelzaher, "Improved Prediction for Web Server Delay Control," Proc. Euromicro Conf. Real-Time Systems, 2004.
[28] Y. Diao, J.L. Hellerstein, and S. Parekh, "Using Fuzzy Control to Maximize Profits in Service Level Management," IBM Systems J., vol. 41, no. 3, pp. 403-420, 2002.
[29] J. Wei and C.-Z. Xu, "eQoS: Provisioning of Client-Perceived End-to-End QoS Guarantees in Web Servers," IEEE Trans. Computers, vol. 55, no. 12, pp. 1543-1556, Dec. 2006.
[30] B. Li and K. Nahrstedt, "A Control-Based Middleware Framework for Quality-of-Service Adaptations," IEEE J. Selected Areas in Comm., vol. 17, no. 9, pp. 1632-1650, Sept. 1999.
[31] M.H. Suzer and K.D. Kang, "Adaptive Fuzzy Control for Utilization Management," Proc. Int'l Symp. Object/Component/Service-Oriented Real-Time Distributed Computing, 2008.
6 ms
(Ver 2.0)

Marketing Automation Platform Marketing Automation Tool