Share via

Bachelor thesis about support of controlling with databases

Diederichs, Sebastian 20 Reputation points
2023-10-23T11:53:11.2433333+00:00

Hi everyone and sorry for troubling you,

I´m currently wirting my bachelor thesis about the support of controlling by integration of a database for data collection and analysis within my company. The selection of Azure SQL was done. But I´m now struggling with writing a comparison of database systems.

The final setup is the following: Operational System Excel exports (API Upload with Python in future) > Azure SQL > PowerBI for data modelling, visualisation and analysis

The stored data is consisting of sales, HR and financial data and therefor limited on horizontal scale. That plus the easier setup is my argument for the selection of a RDBMS over a NoSQL approach.

But it´s hard for me to argue about the selection of Azure SQL.

I´m reading about the adminstration handled by azure regarding security, data storage and updates.

Are you able to help me out understanding why Azure SQL is chosen over different approaches like MySQL. And I also dont really get what Azure itself is, as its also hosting Azure MySQL or Azure PostDegree and so on.

Many thanks in advance!!!

Sebastian

Azure SQL Database
0 comments
Accepted answer
  1. GeethaThatipatri-MSFT 29,552 Reputation points Microsoft Employee Moderator
    2023-10-23T20:23:21.9266667+00:00

    @Diederichs, Sebastian Thanks for posting your question in the Microsoft Q&A forum. It's great to hear that you are working on your bachelor thesis about the support of controlling by integration of a database for data collection and analysis within your company.

    Firstly, Azure SQL is a fully managed relational database service provided by Microsoft Azure. It is a cloud-based database service that is highly available, scalable, and secure. Azure SQL is based on the Microsoft SQL Server engine and provides predictable performance, business continuity, and data protection. It is a great choice for businesses that require data storage with referential integrity, transactional support, and support for TSQL queries.

    Why Azure SQL is chosen over different approaches like MySQL is because of its integration with other Azure services. Azure SQL is part of the Azure ecosystem, which means that it can easily integrate with other Azure services like Power BI, Azure Data Factory, and Azure Databricks. This integration allows for a seamless data pipeline from data collection to analysis and visualization.

    In addition, Azure SQL provides built-in security features like data encryption, threat detection, and auditing. It also provides automatic backups and point-in-time restore capabilities, which ensures that your data is always available and protected.

    Regarding your question about Azure itself, Azure is a cloud computing platform provided by Microsoft. It provides a wide range of cloud services like computing, storage, networking, and databases. Azure provides a flexible and scalable infrastructure for businesses to build, deploy, and manage their applications and services. Azure offers a variety of database services like Azure SQL, Azure MySQL, and Azure PostgreSQL, which are all fully managed and highly available.

    In summary, the main differences between Azure SQL, Azure MySQL, and Azure PostgreSQL are the database engine, data types and features, scalability, pricing, and integration with other Azure services. The choice of which service to use depends on the specific requirements of your application and the features and capabilities that are most important to you.

    I hope this helps you understand why Azure SQL was chosen for your project and what Azure is. If you have any further questions, feel free to ask!

    Regards

    Geetha

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.