Applying Physical Data Model in Entity-Relationship Analysis
by Santanu Ghosh
Entity-relationship analysis comprises of three major abstractions to describe data. These are entities, relationships and attributes. Here entities are the distinct things in the enterprise. Relationship is the relation between the entities and attributes are the nature or properties of the entities.So in a software design scenario we assimilate similar objects in sets and call these sets as entities. We then model all interactions between the objects within the entity sets by relationships or relationship sets. Relationship sets are more difficult to perceive than entity sets. We can see the entities but relationships are always underlying and we cannot see them. This makes data analysis difficult because it is necessary to create models of things that do not physically exist as single objects. There are two major parts in entity-relationship scenario. They are Conceptual data modeling and Physical data modeling.The Physical Data Model specifies the physical implementation of the database.With the Physical Data Model, we consider the details of actual physical implementation. It takes into account both software or data storage structures. We can modify the PDM to suit our performance or physical constraints.The Physical Data Model fills the following roles:Represent the physical organization of data in a graphic formatGenerate database creation and modification scriptsDefine referential integrity triggers and constraintsGenerate extended attributesReverse engineer existing databasesRegenerate a Conceptual Data ModelPhysical Data Model creationThere are several ways to create a Physical Data Model:Generate a Physical Data Model from a Conceptual Data ModelCreate a Physical Data Model from scratchReverse engineer a database into a Physical Data ModelObjects in a Physical Data ModelA Physical Data Model graphically represents the interaction of the following objects:Table : Collection of rows (records) that have associated columns (fields)Column : Data structure that contains an individual data item within a row (record), model equivalent of a database field Primary key : Column or columns whose values uniquely identify a row in a tableForeign key : Column or columns whose values depend on and migrate from a primary key in another tableIndex : Data structure that is based on a key and that speeds access to data and controls unique valuesReference : Link between the primary key and the foreign key of different tablesView : Data structure that results from a SQL query and that is built from data in one or more tables.
About the Author
A native Calcuttan, Santanu Ghosh is a man on a mission. This 38 years old man is the founder of a successful software development company, Simplesot Technologies. This Indian company boasts clients across the globe with its quality services. Santanu is in the field of Information Technology for last 15 years. He was the head of an IT company before he started Simplesoft. According to Santanu“To be successful, you have to stay focused, and be extremely good at what you do. There will always be setbacks – and I’ve had my share – but you have to get back on your feet, and keep thinking big."Much of his success, he believes, is largely due to his ability to build extensive networksFun and frivolity aside, he also understands the need to invest in the future, and ploughs the bulk of the company’s profits back into R
Tell others about
this page:
Comments? Questions? Email Here