Understanding Codd's 12 Rules for RDBMS

The Real Data Science: Tables--So What?

You see, in Cassandra 1.x, the data model is centered around what Cassandra calls “column families”. A column family contains rows, which are identified by a row key. The row key is what you need to fetch the data from the row. The row can then have one or more columns, each of which has a name, value, and timestamp. (A value is also called a “cell”). Cassandra’s data model flexibility comes from the following facts:
* column names are defined per-row
* rows can be “wide” — that is, have hundreds, thousands, or even millions of columns
* columns can be sorted, and ranges of ordered columns can be selected efficiently using “slices”.
--http://blog.parsely.com/post/1928/cass/

• Database Design is Easy — Or Is It?
• 4 Reasons Why the Database Is Your #1 Bottleneck to Agile Development
• Basic Rules of Cassandra Data Modeling

• Is There a Closed Model Of the World Premise?
• The Folk Model is Real - The Universal Model is the Fiction

• 10 Common Design Mistakes
• Entity Relationship Problem

The First Normal Form in Theory and Practice Part I

The Real Data Science: Tables--So What?

[Do] formalized languages need the definition of data types? Up to now I have not read strong arguments against my statement that for interpretation and operation on data the use of character strings is sufficient when

• All data are expressed as character strings that are explicitly based in language communities, whereas the character strings denote concepts that are represented by UID's;
• The denoted concepts are defined by their supertype concepts (among others);
• Collections of allowed qualitative concepts (that are denoted by string values or value ranges) are defined to enable the specification of constraints; --LinkedIn.com

• There is no Such Thing as Object-Relational Impedance Mismatch
• SQL for Beginners in a Nutshell [Infographic]

• Orthodoxy versus the Data Management Reformation
• Back to Basics
• How to enforce a constraint over multiple tables

• Query Optimization
• Relational Algebra
• LEAP RDBMS
• Relational
• Relational Algebra Translator
• System for Translating Relational Algebra Scripts into Microsoft SQL Server SQL Scripts
• System for Translating Relational Algebra Scripts into Oracle SQL Scripts

• The Case For Teaching Ignorance
• Tech nightmares that keep Turing Award winners up at night 
• New @The PostWest

The Real Data Science: Tables -- So What? 

• The Real Data Science
• Relations and databases
• 5NF R-tables
• "Table arithmetic"
• RDM and SQL

Later, as use of RDBMS became more widespread, the complexity associated with design of a RDBMS was also well documented ... The associative database model is claimed to offer advantages over RDBMS ... “two fundamental data structures” as “„Items‟ and a set of „Links‟ that connect them together ... Items, which have "a unique identifier, a name and a type” and Links, which have “a unique identifier, together with the unique identifiers of three other things, that represent the source, verb and target of a fact that is recorded about the source in the database ... “each of the three things identified by the source, verb and target may each be either a link or an item.”
--Homan, J. V. and Kovacs, P. J., A Comparison of the Relational Database Model and the Associative Database Model, Issues in Informtion Systems, Vol. X, No. 1, 2009.

A Comparison of the Relational Database Model and the Associative Database Model

• Are our Universities teaching students how to address real world data challenges?
• Reductionism Data Mgmt. by Inertia ...or by Choice

Why Domain Expertise is More Important than Algorithms