Intelligent apps using Azure Database for MySQL

App Service
Cognitive Services
Database for MySQL
Machine Learning
Power BI

Solution ideas

This article is a solution idea. If you'd like us to expand the content with more information, such as potential use cases, alternative services, implementation considerations, or pricing guidance, let us know by providing GitHub feedback.

This article presents a solution for automating data analysis and visualization using artificial intelligence (AI). Core components in the solution are Azure Functions, Azure Cognitive Services, and Azure Database for MySQL.

Architecture

Architecture diagram that shows the dataflow of an intelligent application using Azure Database for MySQL.

Download a Visio file of this architecture.

Dataflow

  1. An Azure Function activity allows you to trigger an Azure Functions App in the Azure Data Factory pipeline. You create a linked service connection and use the linked service with an activity to specify the Azure Function you want to execute.
  2. Data comes from various sources such as Azure Storage or Azure Event Hubs for high-volume data. When the pipeline receives new data, it triggers the Azure Functions App.
  3. The Azure Functions App calls the Cognitive Services API to analyze the data.
  4. The Cognitive Services API returns the results of the analysis in JSON format to the Azure Functions App.
  5. The Azure Functions App stores the data and results from the Cognitive Services API in Azure Database for MySQL.
  6. Azure Machine Learning use custom machine learning algorithms to provide further insights into the data.
  7. The MySQL database connector for Power BI provides options for data visualization and analysis in Power BI or a custom web application.

Components

Alternatives

Scenario details

The automated pipeline uses the following services to analyze the data:

  • Cognitive Services uses AI for question answering, sentiment analysis, and text translation.
  • Azure Machine Learning supplies machine-learning tools for predictive analytics.

The solution automates the delivery of the data analysis. A connector links Azure Database for MySQL with visualization tools like Power BI.

The architecture uses an Azure Functions App to ingest data from multiple data sources. It's a serverless solution that offers the following benefits:

  • Infrastructure maintenance: Azure Functions is a managed service that allows developers to focus on innovative work that delivers value to the business.
  • Scalability: Azure Functions provides compute resources on demand, so function instances scale as needed. As requests fall, resources and application instances drop off automatically.

Potential use cases

This solution is ideal for organizations that run predictive analytics on data from various sources. Examples include organizations in the following industries:

  • Finance
  • Education
  • Telecommunications

Considerations

  • For most features, the Cognitive Service for Language API has a maximum size of 5120 characters for a single document. For all features, the maximum request size is 1 MB. For more information about data and rate limits, see Service limits for Azure Cognitive Service for Language.

  • Previous versions of this solution used the Cognitive Services Text Analytics API. Azure Cognitive Service for Language now unifies three individual language services in Cognitive Services: Text Analytics, QnA Maker, and Language Understanding (LUIS). You can easily migrate from the Text Analytics API to the Cognitive Service for Language API. For instructions, see Migrate to the latest version of Azure Cognitive Service for Language.

Contributors

This article is maintained by Microsoft. It was originally written by the following contributor.

Principal author:

To see non-public LinkedIn profiles, sign in to LinkedIn.

Next steps

The following solution ideas feature Azure Database for MySQL: