Optimizing Big Data Management on Microsoft SQL Server: Enhancing Performance through Normalization and Advanced Analytical Techniques

Basit Öğe Kaydı
dc.contributor.authorAltınışık, Süleyman Burak
dc.contributor.authorBilgin, Turgay Tugay
dc.date.accessioned2026-02-08T15:08:27Z
dc.date.available2026-02-08T15:08:27Z
dc.date.issued2025
dc.departmentBursa Teknik Üniversitesi
dc.description.abstractThis study investigates Big Data management challenges and solutions in cable manufacturing using Microsoft SQL Server (MSSQL), focusing on performance optimization, normalization, and advanced analytical techniques. Addressing the 4Vs of Big Data, our case study collects data from 45 TAGs at one-minute intervals, generating approximately 56 million daily records. We employ OPC technology for data acquisition, strategic normalization processes, and advanced MSSQL optimization techniques. Normalization significantly reduced data redundancy, decreasing the dataset from 56 million to 283 rows per day and improving query execution times from over 40 minutes to less than 0.1 seconds for complex analytical queries. We also propose a database-independent software development approach to balance cost and performance. This research contributes practical insights into performance optimization, scalability, and cost-effective solutions for organizations managing large-scale data processing challenges in industrial settings, offering a blueprint for efficient Big Data management that balances technical performance with economic considerations.
dc.identifier.doi10.46460/ijiea.1563777
dc.identifier.endpage36
dc.identifier.issn2587-1943
dc.identifier.issue1
dc.identifier.startpage23
dc.identifier.trdizinid1325993
dc.identifier.urihttps://doi.org/10.46460/ijiea.1563777
dc.identifier.urihttps://hdl.handle.net/20.500.12885/5045
dc.identifier.volume9
dc.indekslendigikaynakTR-Dizin
dc.language.isoen
dc.relation.ispartofInternational Journal of Innovative Engineering Applications
dc.relation.publicationcategoryMakale - Ulusal Hakemli Dergi - Kurum Öğretim Elemanı
dc.rightsinfo:eu-repo/semantics/openAccess
dc.snmzKA_TR-Dizin_20260207
dc.subjectBig Data Management
dc.subjectPerformance Optimization
dc.subjectData Normalization
dc.subjectCable Manufacturing
dc.titleOptimizing Big Data Management on Microsoft SQL Server: Enhancing Performance through Normalization and Advanced Analytical Techniques
dc.typeArticle

Dosyalar

Koleksiyon

TR-Dizin İndeksli Yayınlar Koleksiyonu