CFP last date
20 January 2025
Call for Paper
February Edition
IJCA solicits high quality original research papers for the upcoming February edition of the journal. The last date of research paper submission is 20 January 2025

Submit your paper
Know more
The week's pick
Responsive image
SFLA-Based Line Balancing and Task Optimization in Master-Slave Controlled Hanger Transportation Systems for Garment Production

Duc Hoang Nguyen
Random Articles
Reseach Article

Dynamic Environment and Snowflake Schema in Real Time Data Services

by S. Aswini, D. Murali, R. Selvam
journal cover thumbnail

International Journal of Computer Applications
Foundation of Computer Science (FCS), NY, USA
Volume 82 - Number 5
Year of Publication: 2013
Authors: S. Aswini, D. Murali, R. Selvam
10.5120/14113-2162

S. Aswini, D. Murali, R. Selvam . Dynamic Environment and Snowflake Schema in Real Time Data Services. International Journal of Computer Applications. 82, 5 ( November 2013), 23-29. DOI=10.5120/14113-2162

@article{ 10.5120/14113-2162,
author = { S. Aswini, D. Murali, R. Selvam },
title = { Dynamic Environment and Snowflake Schema in Real Time Data Services },
journal = { International Journal of Computer Applications },
issue_date = { November 2013 },
volume = { 82 },
number = { 5 },
month = { November },
year = { 2013 },
issn = { 0975-8887 },
pages = { 23-29 },
numpages = {9},
url = { https://ijcaonline.org/archives/volume82/number5/14113-2162/ },
doi = { 10.5120/14113-2162 },
publisher = {Foundation of Computer Science (FCS), NY, USA},
address = {New York, USA}
}
%0 Journal Article
%1 2024-02-06T21:56:59.716344+05:30
%A S. Aswini
%A D. Murali
%A R. Selvam
%T Dynamic Environment and Snowflake Schema in Real Time Data Services
%J International Journal of Computer Applications
%@ 0975-8887
%V 82
%N 5
%P 23-29
%D 2013
%I Foundation of Computer Science (FCS), NY, USA
Abstract

The demand for real-time data service is increasing in many applications such as e-commerce, agile manufacturing, telecommunications, network management and transportation management. It is desirable but challenging, the workload may vary dynamically. In this paper we propose an approach for managing the dynamic environment using snowflake schema for real time database, that the dynamic environment operates an unpredictable environment such as they cannot predict accurate client request the stock quote at a moment of time. So they can implement dynamic workload adapting technique to improve the freshness of data in real-time and implement the technique called big bang adoption technique support the changes which are needed for a real changing process start . By Modeling database dynamic workload adoption in terms of the relation between data service delay and Conglomerate estimation. They also provide Quality Of Service to data guarantees for real-time data services. compare to most existing system feedback control representing , our dynamic snowflake schema significantly improves the average throughput.

References
  1. " Exploratory Stream Processing System," http://domino. research. ibm. com/comm/research_ projects. nsf/pages/esps. index. html2012
  2. K. Ramamiritham,S. H. Son, and L. C. Dipippo,"Real- Time Databases and data Services"
  3. Real-time Database Systems, K. Y. Lam and T. W. Kuo, Eds . Kluwer Academic Publishers, 2006.
  4. "StreamBase . "http://www. streambase. com/,2012.
  5. "Microsoft SQL Server 2008 R2 - StreamInsight," http://www. microsoft. com/sqlserver/2008/en/us/r2-complex-event. aspx,2012. [6 ] G. F. Franklin, J. D. Powell, and M. L. Workman, Digital Control of Dynamic Systems, third Ed. Addison-Wesley, 1998.
  6. Y. Zhou and K. -D. Ken, "Integrating Proactive and Reactive Approaches for Robust Real-Time Data Services," Proc. 30th IEEE Real- Time Systems Symp. , Pp. 105-114, 2009.
  7. J. L. Devore, Probability and Statistics for Engineering and the Sciences sixth ed. Thomson Learning, Inc. , 2004.
  8. file://g. journal/metadata. html.
  9. Exploring the Trade-off Between Performance and Data Freshness in Database-DrivenWeb Servers, Alexandros Labrinidis, Nick Roussopoulos.
  10. K. -D. Kang, J. Oh, and Y. Zhou, "Backlog Estimation and Management for Real-Time Data Services," Proc. 20th Euromicro Conf. Real-Time Systems, pp. 289-298, 2008.
  11. 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.
  12. M. Amirijoo, N. Chaufette, J. Hansson, S. H. Son, and S. Gunnarsson,"Generalized Performance Management of Multi-Class Real-Time Imprecise Data Services," Proc. 26th IEEE Int'l Real-Time Systems Symp. , pp. 38-49, 2005.
  13. 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. , pp. 267-276, 2007.
  14. "Oracle Berkeley DB Product Family, High Performance, Embeddable Database Engines," http://www. oracle. com/database/berkeley- db/index. html, 2012.
  15. J. L. Hellerstein, Y. Diao, S. Parekh, and D. M. Tilbury, Feedback Control of Computing Systems. John Wiley & Sons, 2004.
  16. D. J. Abadi, Y. Ahmad, M. Balazinska, U. Cetintemel, M. Cherniack, J. -H. Hwang, W. Lindner, A. S. Maskey, A. Rasin, E. Ryvkina, N. Tatbul, Y. Xing, and S. B. Zdonik, "The Design of the Borealis Stream Processing Engine," Proc. Conf. Innovative DataSystems Research (CIDR), 2005.
Index Terms

Computer Science
Information Sciences

Keywords

Big-bang adaption snow flake schema conglomerate.

Powered by PhDFocusTM