Skip to Main Content
Joe Celko’s Complete Guide to NoSQL
book

Joe Celko’s Complete Guide to NoSQL

by Joe Celko
October 2013
Beginner to intermediate content levelBeginner to intermediate
244 pages
5h 53m
English
Morgan Kaufmann
Content preview from Joe Celko’s Complete Guide to NoSQL
Chapter 12

Multivalued or NFNF Databases

Abstract

Multivalued or NFNF databases violate 1NF by allowing a column to contain more than one scalar value. This model has been use for decades in commercial products but did not get a theoretical basis until much later. This chapter discusses multivalued databases.

Keywords

COBOL; Pick; nonfirst normal form (NFNF); first normal form (1NF)

Introduction

RDBMS is based on first normal form (1NF), which assumes that data is kept in scalar values in columns that are kept in rows and those records have the same structure. The multivalued model allows tables to be nested inside columns. They have a niche market that is not well known to SQL programmers. There is an algebra for this data model that is just ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

NoSQL for Mere Mortals®

NoSQL for Mere Mortals®

Dan Sullivan
Seven NoSQL Databases in a Week

Seven NoSQL Databases in a Week

Sudarshan Kadambi, Xun (Brian) Wu

Publisher Resources

ISBN: 9780124071926