Re: Equivalence of hierarchical and flat data formats

From: John Cowan <johnwcowan@gmail.com>
To: Roger L Costello <costello@mitre.org>
Date: Sat, 30 Jul 2022 09:57:33 -0400

Play the video

On Thu, Jul 28, 2022 at 7:09 AM Roger L Costello <costello@mitre.org> wrote:

Suppose I want to update the list of authors. Specifically, I want to add “John Doe” to the beginning of the AUT01 author list:

AUT01 John Doe, Alfred V. Aho, Ravi Sethi, Jeffrey Ullman

That update operation seems pretty straightforward to me. What is the issue that I’m not seeing?

That if you have any other books by Aho, Sethi, and Ullman, they will all become authored by Doe, Aho, Sethi, and Ullman, which is probably not what you want. Furthermore, if you want to find all books by Sethi, you are out of luck, because "Aho, Sethi, and Ullman" doesn't match "Sethi".

This is what normalization resolves. You need a third table with three columns: book id, author id, and author sequence number, with rows {(BOOK01, AUTH04, 1), (BOOK01, AUTH05, 2), (BOOK01, AUTH06, 3), ...]}, where AUTH04-06 are Aho, Sethi, and Ullman respectively, and AUTH01 can be removed altogether.

References:
- Equivalence of hierarchical and flat data formats
  - From: Roger L Costello <costello@mitre.org>
- Re: Equivalence of hierarchical and flat data formats
  - From: Roger L Costello <costello@mitre.org>

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index]

PURCHASE STYLUS STUDIO ONLINE TODAY!

Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Subscribe in XML format

RSS 2.0
Atom 0.3

Stylus Studio has published XML-DEV in RSS and ATOM formats, enabling users to easily subcribe to the list from their preferred news reader application.

Stylus Studio Sponsored Links are added links designed to provide related and additional information to the visitors of this website. they were not included by the author in the initial post. To view the content without the Sponsor Links please click here.

XML Editor - Download a 15 Day Free Trial Now >

See What's New in Stylus Studio >

Buy Stylus Studio - XML Editor - Now >