Metrika članka

  • citati u SCindeksu: 0
  • citati u CrossRef-u:0
  • citati u Google Scholaru:[=>]
  • posete u poslednjih 30 dana:7
  • preuzimanja u poslednjih 30 dana:4
članak: 1 od 5  
Back povratak na rezultate
Telfor Journal
2018, vol. 10, br. 2, str. 91-96
jezik rada: engleski
vrsta rada: neklasifikovan
doi:10.5937/telfor1802091D


An extended evaluation of schema issues advisor in the azure SQL database
(naslov ne postoji na srpskom)
aUniversity of Belgrade, School of Electrical Engineering, Beograd + Microsoft Development Center, Belgrade
bUniverzitet u Beogradu, Elektrotehnički fakultet

e-adresa: dd145019p@student.etf.rs, dejandu@microsoft.com, ls163150m@student.etf.rs, stlazi@microsoft.com, mvt@etf.bg.ac.rs, bojic@etf.bg.ac.rs

Sažetak

(ne postoji na srpskom)
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.

Ključne reči

Azure SQL database platform; Schema issue advisor; Feature validation and testing; Cloud services

Reference

*** (2018) Regulation (EU) 2016/679 of the European Parliament and of the Council of 27 April 2016 on the protection of natural persons with regard to the processing of personal data and on the free movement of such data, and repealing Directive 95/46/EC (gener. http://eurlex.europa.eu/eli/reg/2016/679/oj
Amazon Web Services (2016) Amazon RDS for SQL server. https://aws.amazon.com/rds/sqlserver/
Bernstein, P.A., Cseri, I., Dani, N., Ellis, N., Kalhan, A., Kakivaya, G., Lomet, D.B., Manne, R., Novik, L., Talius, T. (2011) Adapting microsoft SQL server for cloud computing. u: 2011 IEEE 27th International Conference on Data Engineering, Institute of Electrical and Electronics Engineers (IEEE), str. 1255-1263
Boillat, T., Legner, C. (2014) Why Do Companies Migrate Towards Cloud Enterprise Systems? A Post-Implementation Perspective. u: 2014 IEEE 16th Conference on Business Informatics, Institute of Electrical and Electronics Engineers (IEEE), str. 102-109
Dhiman, A. (2011) Analysis of on-premise to cloud computing migration strategies for enterprises. USA: Massachusetts Institute Of Technology, Ph.D. Dissertation
Dundjerski, D., Lazic, S., Tomasevic, M., Bojic, D. (2017) Improving schema issue advisor in the Azure SQL database. u: 2017 25th Telecommunication Forum (TELFOR), Institute of Electrical and Electronics Engineers (IEEE), str. 1-4
Lang, W., Bertsch, F., DeWitt, D.J., Ellis, N. (2015) Microsoft azure SQL database telemetry. u: Proceedings of the Sixth ACM Symposium on Cloud Computing - SoCC '15, New York: Association for Computing Machinery (ACM), str. 189-194
Lo, S., Sreedhar, P., Caro, C. (2016) Introduction to azure data factory service, a data integration service. https://docs.microsoft.com/en-us/azure/data-factory/data-factoryintroduction
Nair, V., Raul, A., Khanduja, S., Bahirwani, V., Sellamanickam, S., Keerthi, S., Herbert, S., Dhulipalla, S. (2015) Learning a Hierarchical Monitoring System for Detecting and Diagnosing Service Issues. u: Proceedings of the 21th ACM SIGKDD International Conference on Knowledge Discovery and Data Mining - KDD '15, New York: Association for Computing Machinery (ACM), str. 2029-2038
Stein, S., Rabeler, C. (2016) Azure SQL database advisor. https://docs.microsoft.com/en-us/azure/sql-database/sqldatabase-advisor
Varga, S., Cherry, D., d`Antoni J. (2016) Introducing Microsoft SQL Server 2016. USA: Microsoft Press, Redmond