Data Architecture Design & Data Management

Data architecture design consists of standards which have certain rules, policies, data types to be collected, from where the data is collected, storage of data, arrangement of data, and then using that data for further analysis. Data plays a vital role in successful execution of business strategy.

Data architecture design

It helps us to show how users view the data in the database. It describes the type of data structures used to manage data and make the processing easy. the concept of dbms depends on its architecture. It is divided into three models i.e. conceptual model, logical model and physical model.

Conceptual model

It is a model in which table entities and their attributes are having relation with the help of ERmodel(Entity Relationship model). it also tells us what data is stored into the database along with the security and integrity information.

Example

Student and prize are two entities provided by their attributes.

Rewarded is the relationship between the entities

Logical Model

It is used to define problems in the form of logic. It adds more detail to conceptual model i.e. presence of attribute for each entity, the presence of key and non-key attributes, and primary key-foreign key relationships are clearly defined.

Example

Physical Model

While creating a physical model, we should be referring to entities and attributes as tables and columns respectively. Specific datatypes must be there to tell the type of data to be entered. More effort than logical model is needed if any changes occur.

Example

Data management

It is the way of managing the data by performing tasks like finding data, storing data, processing data and then making the data secure.

• It is an important aspect for every organisation as it helps the growth of industry by helping in making efficient decisions. data management is proportional to better productivity in business.

• One of the motives is to make the data safe and secure in an optimal way.

• Healthy data management leads to easily making changes in data by creating, updating, deleting and accessing.

• A large amount of data is already present so to manage that we need tools and technologies like Tableau, Hadoop, power bi etc. which helps in analysing the data and making improvements.

• Data management is mainly performed by database analysts and data architects.

Conclusion

In this article, we have discussed first on the data architecture in which three models are present. First one is conceptual in which relations in data takes place helped by ERmodel. Second is logical which add more details in first one like presence of the attribute, key, and primary-foreign key. Third is physical which tends the type of database. The second part is data management in which we discussed on how the data is managed at a large scale with the help of tools used by data analysts.