Microsoft Dataverse : A Complete Storage

Database generally refers to organized and structural databases that improve data storage and access performance, but E. F. Cod was given a new concept called relational database in 1970s. In the continuous journey of databases, object oriented, NoSQL, graphs and other new database concepts are added. Nowadays, Microsoft Dataverse defines a new definition of database that lets users design their own data model without writing single code.

Microsoft Dataverse is cloud based managed service which provides  data service and app platform.




Microsoft Dataverse is a combination of several Azure services, being exposed through the API layer which makes it easy to request data, but also allows it to be managed through the API layer. It is easy to manage and secure data with rich metadata, logic and validation layer with multiple productivity tools. All components  created in Dataverse are held as Metadata. This means the components are discoverable and the properties for components are accessible to applications and tools.

The data held in the Dataverse is abstracted from the underlying data storage mechanism:


Microsoft Dataverse stores data in below :

  • Azure SQL Elastic Pools
  • Azure Storage Blob
  • Cosmos DB
  • Azure Data Lake
  • Cognitive Search

Azure SQL Elastic Pools:

Azure SQL Elastic Pools allow us to group more than one SQL Database as a pool and then use all resources allocated to a pool on sharing basis as par min and max limit set on specific SQL Database. (As Microsoft Definition).

MS Dataverse : All relational and structure data resides in Azure SQL Elastic Pools.

Azure Storage Blob:

Azure Blob storage is Microsoft's object storage solution for the cloud. Blob storage is optimized for storing massive amounts of unstructured data. Unstructured data is data that doesn't adhere to a particular data model or definition, such as text or binary data.(As Microsoft Definition).

MS Dataverse: Attachments and files live in Azure Storage Blob

Cosmos DB

Azure Cosmos DB is a fully managed, serverless NoSQL database for high-performance applications of any size or scale.(As Microsoft Definition).

MS Dataverse: Log or audit data resides in Cosmos DB and is also used for mobile offline capabilities.

Azure Data Lake:

Users can store structured, semi-structured or unstructured data produced from applications including social networks, relational data, sensors, videos, web apps, mobile or desktop devices. A single Azure Data Lake Store account can store trillions of files where a single file can be greater than a petabyte in size.(As Microsoft Definition).

MS Dataverse: Provides the Microsoft Azure Data Lake service that enables continuous replication of Microsoft Dataverse table data to Azure Data Lake storage that can be used to run analytics.

Cognitive Search :

Cognitive search is a new generation of Enterprise search that uses artificial intelligence technologies to improve users' search queries and extract relevant information from multiple, diverse data sets.(As Microsoft Definition).

MS Dataverse : When we enable relevant search and we start indexing data that data gets stored in Azure Cognitive Search.

Summary:

Microsoft Dataverse stores physical data in the Azure Cloud. It provides an abstraction that makes it possible to work with any type of data, including relational, non-relational, images, files, relational searches or data lakes. In MS Dataverse, there is no need to understand the types of data as it exposes a set of data types which allows us to build our model.

Comments

Post a Comment

Popular posts from this blog

Exploring the Differences: Managed vs. Unmanaged Solutions in Dynamics CRM/Dataverse

Image
In Dynamics CRM/Dataverse, solutions are central to Application Lifecycle Management (ALM) , providing a structured way to manage, package, and distribute customizations across environments. Microsoft uses solutions to transfer apps and customizations by exporting them from one Dataverse environment and importing them into another.  Each solution is authored and maintained by a publisher and includes components like Power Apps (canvas and model-driven), flows, entities, forms, connectors, web resources, and configurations—excluding business data. Solutions streamline ALM practices within Microsoft Power Platform. In Dynamics CRM/Dataverse, there are two types of solutions: Managed and Unmanaged . When planning an implementation, it’s important to understand the advantages and disadvantages of each to make an informed decision. Let’s explore both types to determine the best approach for development and deployment. In Dynamics 365 CRM, a managed solution is a fully packaged solution ...
Read more

PCF vs. Web Resources: Choosing the Right Extensibility Tool for Dataverse

Image
Extensibility refers to the ability to be extended or augmented beyond the default capabilities of the platform. This involves customization but also includes more advanced techniques, such as coding, integration with external services, and the use of custom components. In the context of Power Platform and Dynamics CRM, the term "extend behavior" refers to the ability to customize and extend the functionality of the platform to meet specific business needs. Extensibility often requires technical skills, such as coding in JavaScript, C#, or using tools like Azure Logic Apps and Power Automate for complex integrations. Customization  is a subset of extensibility. Customization involves configuring and modifying existing elements within the platform to suit specific business needs. Extensibility, on the other hand, covers a wide range of functions and techniques, including customization and more advanced development and integration tasks, to extend the capabilities of the Power ...
Read more

Effective Strategies for Debugging Plugins in Dynamics CRM

Image
In a recent interview, I was asked about debugging plugins in Dynamics CRM. The interviewer specifically wanted to know my approach to plugin debugging. In response, I mentioned using the Plugin Registration Tool profiler. However, I later realized there are multiple methods to debug plugins in Dynamics CRM/Dataverse, each essential for efficient troubleshooting. Debugging plays a crucial role in development, and having a solid understanding of various debugging approaches can help streamline issue resolution in Dynamics 365. Here, I'll explore different techniques for debugging plugin code. There are below options to use in the plugin in Dynamics CRM/Dataverse ITracingService : In Dynamics CRM plugin development, ITracingService is a service provided within the plugin's execution context that logs information for tracing and debugging. It allows developers to capture real-time. Plugin Profiler : A plugin profiler in Dynamics CRM (or Dataverse) is a debugging tool in the Plugi...
Read more