While physical data architecture has been the predominant architecture used for decades, logical data management is increasing in popularity, for its agile nature. One of the hottest topics in the data management space is data fabric, which enables augmented data integration and sharing across heterogeneous data sources. This concept of heterogeneous data sources means you are establishing a logical data access layer atop these various data sources. Likewise, another very popular data management pattern today is data mesh, which is inherently a logical data architecture. It is built on a distributed data platform, and data access is gained through domain-based data products, which are located in an abstraction layer of underlying data sources. The consumers of data products do not necessarily see – or even know anything about – the underlying data sources. These links will provide you with more detail about data fabric and data mesh.
Logical data management is concerned with the high-level organization and classification of data, while physical data management is concerned with the physical storage and management of data.
Logical data management focuses on the meaning and relationships of data, while physical data management focuses on the technical aspects of data storage and retrieval.
Logical data management is often more abstract than physical data management. It deals with data models, structures, and relationships, while physical data management deals with data storage technologies, data compression, and data security.
Logical data management aims to provide data independence from the underlying physical data storage, allowing data to be manipulated and viewed in different ways without affecting the physical storage. In contrast, physical data management is closely tied to specific storage technology.
Logical data management is typically performed by data architects, data modelers, and business analysts, while physical data management is typically performed by database administrators, storage administrators, and system administrators.