You might have seen the recent news reports about the collision between U.S. and Russian communication satellites. The U.S. satellite was one of the Iridium satellites. What wasn’t reported and you probably don’t know is that an object database management system (ODBMS) is an important part of the Iridium system. Even though ODBMSs are a [...]
February 13, 2009
I am now also posting on the Cutter Blog. My initial posting is (The Acronym) SOA is (Perhaps) Dead (at Some Companies); Long Live Services. It is a response to Anne Thomas Manes’ SOA is Dead; Long Live Services on her blog at the Burton Group.
January 9, 2009
The typical definition of an atomic task or process is one that cannot be decomposed further. This is vague and subject to interpretation. The Decomposition Matrix on this site uses a specific definition: A task (for business process diagrams) or a process (for data flow diagrams) is atomic if every input relates to every output [...]
December 3, 2008
My last posting referenced the criteria for a well-formed business process diagram mentioned in Business Process Driven SOA using BPMN and BPEL by Matjaz B. Juric and Kapil Pant. I am going to expand on their criteria to create a more comprehensive definition of a well-formed business process diagram. To start, here are three criteria [...]
November 18, 2008
I recently received two new books on business process modeling. Both books looked interesting because they had great titles. As it turns out, one book is great and the other not so good. The not so good book is Business Process Driven SOA using BPMN and BPEL by Matjaz B. Juric and Kapil Pant. There [...]
October 9, 2008
The Design Decomposition Blog is written by Doug Barry.
The relational model used the basic concept of a relation or table. The
columns or fields in the table identify the attributes such as name, age, and
so. A tuple or row contains all the data of a single instance of the table such
as a person named Doug. In the relational model, every tuple must have a unique
identification or key based on the data. In this figure, a social security
account number (SSAN) is the key that uniquely identifies each tuple in the
relation. Often, keys are used to join data from two or more relations based on
matching identification. The relational model also includes concepts such as
foreign keys, which are primary keys in one relation that re kept in another
relation to allow for the joining of data. As an example of foreign keys is
storing your mother's and father's SSAN in the tuple that represent you. Your
parents' SSANs are keys for the tuples that represent them and they are foreign
keys in the the tuple that represents you.
There are nearly 400 pages of articles on this site with over 40 pages on database concepts and standards.
Search this site for more articles
Custom Search
Browse this site for more articles
Click on the topics below to browse the articles on this site. You can see more detail by clicking on the arrows. This highlights the location of the current
article: Relational model concepts.
Related recent articles from Google News
Data Visualization for People Who Don't Visualize Data: CA ERwin 8.2 ReadWriteWeb Real-time analysis of big data, she goes on, may enable DBAs to add some elements to the relational data model that they may not have seen before. As for the other use case, Burbank agrees that data modeling may never be appealing to 100% of the ... and more » 3 Feb 2012 at 2:04pm
Become an Oracle Essbase Whizz Using Packt's Latest Oracle Essbase Book and eBook San Francisco Chronicle (press release) Written in a cookbook style by Jose R. Ruiz, the Oracle Essbase 11 Development Cookbook focuses on the use of a relational data model to build and load an Essbase cube and work with the data elements in Essbase Studio. The book highlights topics such ... and more » 30 Jan 2012 at 6:10am
Database Design for Mere Mortals®: A Hands-On Guide to Relational Database Design (2nd Edition) by Michael J. Hernandez Description: “This book takes the somewhat daunting process of database design and breaks it into completely manageable and understandable components. Mike’s approach whilst simple is completely professional, and I can recommend this book to any novice database designer.” –Sandra Barker, Lecturer, University of South Australia, Australia “Databases are a critical infrastructure technology ...
Logic and Databases: The Roots of Relational Theory by C. J. Date Description: Logic and databases are inextricably intertwined. The relational model in particular is essentially just elementary predicate logic, tailored to fit the needs of database management. Now, if you're a database professional, I'm sure this isn't news to you; but you still might not realize just how much everything we do in the database world is - or should be! - affected by predicate ...
Probabilistic Ranking Techniques in Relational Databases (Synthesis Lectures on Data Management) by Ihab F. Ilyas, Mohamed A. Soliman Description: Ranking queries are widely used in data exploration, data analysis and decision making scenarios. While most of the currently proposed ranking techniques focus on deterministic data, several emerging applications involve data that are imprecise or uncertain. Ranking uncertain data raises new challenges in query semantics and processing, making conventional methods inapplicable. Fur...
