• DocumentCode
    3449859
  • 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
  • fYear
    2012
  • fDate
    1-5 April 2012
  • Firstpage
    351
  • Lastpage
    354
  • 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;
  • fLanguage
    English
  • Publisher
    ieee
  • Conference_Titel
    Data Engineering Workshops (ICDEW), 2012 IEEE 28th International Conference on
  • Conference_Location
    Arlington, VA
  • Print_ISBN
    978-1-4673-1640-8
  • Type

    conf

  • DOI
    10.1109/ICDEW.2012.44
  • Filename
    6313631