An extended evaluation of schema issues advisor in the azure SQL database

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 shorte...

Full description

Saved in:

Bibliographic Details
Published in:	Telfor Journal Vol. 10; no. 2; pp. 91 - 96
Main Authors:	Dunđerski, Dejan, Lazić, Stefan, Tomašević, Milo, Bojić, Dragan
Format:	Journal Article
Language:	English
Published:	Telecommunications Society, Academic Mind 2018
Subjects:	Azure SQL database platform Cloud services Feature validation and testing Schema issue advisor
ISSN:	1821-3251, 2334-9905
Online Access:	Get full text
Tags:	Add Tag No Tags, Be the first to tag this record!

Description
Summary:	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.
ISSN:	1821-3251 2334-9905
DOI:	10.5937/telfor1802091D