Title :
Architecting the Database Access for a IT Infrastructure and Data Center Monitoring Tool
Author :
Unde, Pradeep ; Vin, Harrick ; Natu, Maitreya ; Kulkarni, Vaishali ; Thomas, Dilys ; Vasudevan, Sreeram ; Dhondage, Amruta ; Jog, Chinmay ; Sahai, Shivam ; Pathak, Rekha
Author_Institution :
Tata Res. Dev. & Design Center, Pune, India
Abstract :
We present our experience in architecting the database access for a tool that analyzes IT infrastructure and data center utilization. We study solutions built on top of TSDB [2] and SQL Server. We provide a configuration based multi threaded approach in SQL Server based on Spring Batch [1]. Our architecture includes spring batch partitioning, JDBC-R bridge rewrite and optimized Transact-SQL procedures.
Keywords :
SQL; computer centres; database management systems; multi-threading; rewriting systems; IT infrastructure; JDBC-R bridge rewrite; SQL server; TSDB; data center monitoring tool; data center utilization; database access; multi threaded approach; optimized transact-SQL procedures; spring batch; Computer architecture; Data mining; Databases; Java; Measurement; Servers; Time series analysis;
Conference_Titel :
Data Engineering Workshops (ICDEW), 2012 IEEE 28th International Conference on
Conference_Location :
Arlington, VA
Print_ISBN :
978-1-4673-1640-8
DOI :
10.1109/ICDEW.2012.44
