An Extended Evaluation of Schema Issues Advisor in the Azure SQL Database

Autor: D. Dundjerski, S. Lazić, M. Tomašević, D. Bojić
Jazyk: angličtina
Rok vydání: 2018
Předmět:
Zdroj: Telfor Journal, Vol 10, Iss 2, Pp 91-96 (2018)
Druh dokumentu: article
ISSN: 1821-3251
DOI: 10.5937/telfor1802091D
Popis: The analysis of the telemetry data in Azure SQL database has revealed that most of the problems affecting the customers are due to the schema inconsistency errors. An assumption has been made that direct e-mail notifications sent to the customers about the current problems could significantly shorten time to resolve them. The prospective benefits are first validated by sending e-mail recommendations manually. Then, in an iterative way, the schema issue advisor that detects anomalies and automatically sends the appropriate notifications to the customers is implemented on top of Azure resources. Finally, an extended evaluation has confirmed the expected benefits of direct communications with the customers.
Databáze: Directory of Open Access Journals