Database: custom_columns: What is 'normalized'?

ownedbycats · 12-18-2022, 01:57 AM

In the custom_columns table of metadata.db is a bool column normalized. What is this for?

kovidgoyal · 12-18-2022, 02:27 AM

normalized is for columns that store many-one or many-many values. Think of tags vs titles.

ownedbycats · 12-18-2022, 01:54 PM

That makes sense. Thanks

chaley · 12-18-2022, 04:46 PM

If you want a more formal discussion of normalization see (for example) https://en.wikipedia.org/wiki/Third_normal_form and https://learn.microsoft.com/en-us/of...on-description

theducks · 12-18-2022, 08:03 PM

Many years ago Borland's Paradox DOS had an example
An Airline ticket with multiple stops.

There was the Passenger Table with all the info (tel, charge method...)
There was the Ticket (parent) issued to Passenger

There was the Hop table that had an entry for each hop Linked to the ticket. there was no limit on how many hops
There was a schedule table that detailed Flights to flesh out the hop details
All the tables were really narrow (few columns)

12-18-2022, 01:57 AM	#1
ownedbycats Custom User Title Posts: 10,797 Karma: 74203799 Join Date: Oct 2018 Location: Canada Device: Kobo Libra H2O, formerly Aura HD	Database: custom_columns: What is 'normalized'? In the custom_columns table of metadata.db is a bool column normalized. What is this for?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Database with 1.0...	john_es	Library Management	3	08-25-2013 04:37 PM
Database Failure	RichardGH	Library Management	9	07-25-2012 05:59 AM
Calibre Database cp Kindle Database	mitch13	Library Management	1	05-22-2011 07:33 PM
What Database?	LadyLou	Calibre	8	02-12-2010 06:32 AM
Compacting the Database?	Sabardeyn	Calibre	2	02-11-2010 06:45 PM

12-18-2022, 02:27 AM	#2
kovidgoyal creator of calibre Posts: 45,251 Karma: 27110894 Join Date: Oct 2006 Location: Mumbai, India Device: Various	normalized is for columns that store many-one or many-many values. Think of tags vs titles.

12-18-2022, 01:54 PM	#3
ownedbycats Custom User Title Posts: 10,797 Karma: 74203799 Join Date: Oct 2018 Location: Canada Device: Kobo Libra H2O, formerly Aura HD	That makes sense. Thanks

12-18-2022, 04:46 PM	#4
chaley Grand Sorcerer Posts: 12,362 Karma: 8012652 Join Date: Jan 2010 Location: Notts, England Device: Kobo Libra 2	If you want a more formal discussion of normalization see (for example) https://en.wikipedia.org/wiki/Third_normal_form and https://learn.microsoft.com/en-us/of...on-description

12-18-2022, 08:03 PM	#5
theducks Well trained by Cats Posts: 30,939 Karma: 60358908 Join Date: Aug 2009 Location: The Central Coast of California Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A	Many years ago Borland's Paradox DOS had an example An Airline ticket with multiple stops. There was the Passenger Table with all the info (tel, charge method...) There was the Ticket (parent) issued to Passenger There was the Hop table that had an entry for each hop Linked to the ticket. there was no limit on how many hops There was a schedule table that detailed Flights to flesh out the hop details All the tables were really narrow (few columns)

Advert

Advert