Sunday, March 19, 2023

ON PROPERTIES IN CONCEPTUAL MODELING (rm)



Note: Reader mail (rm) posts are exchanges with my readers that raise fundamental issues. I may improve language for clarity and amplify with Ed. Notes for the benefit of readers.

“Your post Understanding Conceptual vs. Data Modeling Part 1: Data Model - The RDM Is, the E/RM Isn't is well done. However, concepts and relationships can be perceived and modeled without formulating or specifying properties. Chen did that in his ER diagrams. And informally, everyone does it as a mental model every day. I suppose anyone can define conceptual modeling however they wish to.  But at its minimum and most abstract, which is what conceptual modelling is usually understood to be, it can be done without formulating or specifying properties.” --GR

------------------------------------------------------------------------------------------------------------------

SUPPORT THIS SITE
DBDebunk was maintained and kept free with the proceeds from my @AllAnalitics column. The site was discontinued in 2018. The content here is not available anywhere else, so if you deem it useful, particularly if you are a regular reader, please help upkeep it by purchasing publications, or donating. On-site seminars and consulting are available.Thank you.

LATEST POSTS

03/04 ON NORMALIZATION AND THE SCIENTIFIC METHOD (t&n)

02/04 CONCEPTUAL MODELING, LOGICAL DATABASE DESIGN AND PHYSICAL IMPLEMENTATION (sms)

01/22 CONCEPTUAL BUSINESS RULES AND LOGICAL CONSTRAINTS (sms)

UPDATES

03/14 Added Russell’s On Denoting to LINKS page

03/14 Added Russell’s Paradox to LINKS page.

LATEST PUBLICATIONS (order from PAPERS and BOOKS pages)

08/19 Logical Symmetric Access, Data Sub-language, Kinds of Relations, Database Redundancy and Consistency 

02/18 The Key to Relational Keys: A New Understanding

04/17 Interpretation and Representation of Database Relations 

10/16 THE DBDEBUNK GUIDE TO MISCONCEPTIONS ABOUT DATA FUNDAMENTALS,

USING THIS SITE
- To work around Blogger limitations, the labels are mostly abbreviations or acronyms of the terms listed on the
FUNDAMENTALS page. For detailed instructions on how to understand and use the labels in conjunction with that page, see the ABOUT page. The 2017 and 2016 posts, including earlier posts rewritten in 2017 were relabeled accordingly. As other older posts are rewritten, they will also be relabeled. For all other older posts use Blogger search.
- The links to my AllAnalytics columns no longer work. I re-published only the 2017 columns @dbdebunk, and within them links to sources external to AllAnalytics may or may not work.

SOCIAL MEDIA
I deleted my Facebook account. You can follow me @DBDdebunk on Twitter: will link to new posts to this site, as well as To Laugh or Cry? and What's Wrong with This Picture? posts, and my exchanges on LinkedIn.
------------------------------------------------------------------------------------------------------------------

Ah, yes, after "well done" I expected a however :).

Of course they can be! Perceptions/conceptual models are not-scientific, which is why formalization is needed for database representation and manipulation. The question is: what is most useful for that objective.

I am currently working on version 2 of my Relationships & RDM series of posts and when I publish it you will see why we have a different perception/conceptualization that includes properties.

With respect to Chen specifically, see below.

Again, of course they can, but:

“... singular names, property terms and class terms correspond to common sense concepts of individual beings, traits or activities of individual beings and sets of beings who share some common traits or activities ... This three-fold distinction is an important part of our Western intellectual heritage and is deeply embedded not only in our thought habits, but also in our language. --Olson, R., MEANING AND ARGUMENT: ELEMENTS OF LOGIC

Emphasis mine.

 

Ed. Notes

1. And properties are fundamental for good reason, even though it is missed, as we explained in Understanding Conceptual vs. Data Modeling Part 4: Properties-object Modeling (PoM). 
 
2. Another angle on this from the forthcoming revision I mentioned above: “In our conceptual modeling approach relationships between entities within a group and between groups are collective properties of the group and the multigroup, respectively.”

3. As to Chen specifically:

“Chen did use properties -- he called them attributes. He understood both the importance and necessity of properties at the conceptual level. If E/RM is being used for conceptual modeling without properties (Chen's attributes), it is obviously being misused! I suggest everyone actually read Chen's Turing Award paper The Entity-Relationship Model-Toward a Unified View of Data (See especially Fig.1 on page 3). Anecdotal accounts of what E/RM is and how it should be used can be misleading, and dangerous.” --David McGoveran (was acquainted with Chen in the 1980s and early 1990s)


No comments:

Post a Comment

View My Stats