Metadata: Difference between revisions

From The Jolly Contrarian
Jump to navigation Jump to search
Created page with "{{g}}{{d|metadata|/ˈmɛtədeɪtə/|n|}} Information ''about'' information. For example, if news in a newsletter is the ''primary'' data, the newsletter’s size, its author,..."
 
No edit summary
 
(4 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{g}}{{d|metadata|/ˈmɛtədeɪtə/|n|}}
{{g}}{{d|Metadata|/ˈmɛtəˌdeɪtə/|n|}}
Information ''about'' information. For example, if news in a newsletter is the ''primary'' data, the newsletter’s size, its author, its recipients, its publication date, the date it is read — these are all metadata.


A rich, and underused, resource.
[[Information]] ''about'' [[information]]. Data that describes other data.
 
For example, if news in a newsletter is the ''primary'' data, the newsletter’s size, its author, its recipients, its publication date, the date it is read — these are all points of [[metadata|''meta''data]].
 
Metadata is how databases work: For each single ''item'' in a database there will be associated ''fields'', each representing a single point of metadata.
 
Excel is the greatest example of metadata: Each row in an Excel field is an item and each column is a metadata point. ''You can add an unlimited number of columns'': newly added columns do not affect or change existing ones, so we say they are ''non-destructive''.
 
Once you have a table of columns in Excel, you can filter sort and pivot by reference to any of the columns, in any order. Doing this is to impose a dynamic hierarchy on the items in the list. This is the magic of metadata.
 
It is curious that we intuitively understand this when presented with a spreadsheet but it does not occur to us when presented with SharePoint, which is, basically a supercharged online version of a spreadsheet.
 
A rich, underused, resource. There is a long essay on [[metadata and folders]] in our article about [[SharePoint]].


{{sa}}
{{sa}}
*[[SharePoint]]
*[[Metadata taxonomy]]
*[[Metadata taxonomy]]
*[[Information]]

Latest revision as of 09:10, 17 July 2024

The Jolly Contrarian’s Glossary
The snippy guide to financial services lingo.™
Index — Click the ᐅ to expand:
Tell me more
Sign up for our newsletter — or just get in touch: for ½ a weekly 🍺 you get to consult JC. Ask about it here.

Metadata
/ˈmɛtəˌdeɪtə/ (n.)

Information about information. Data that describes other data.

For example, if news in a newsletter is the primary data, the newsletter’s size, its author, its recipients, its publication date, the date it is read — these are all points of metadata.

Metadata is how databases work: For each single item in a database there will be associated fields, each representing a single point of metadata.

Excel is the greatest example of metadata: Each row in an Excel field is an item and each column is a metadata point. You can add an unlimited number of columns: newly added columns do not affect or change existing ones, so we say they are non-destructive.

Once you have a table of columns in Excel, you can filter sort and pivot by reference to any of the columns, in any order. Doing this is to impose a dynamic hierarchy on the items in the list. This is the magic of metadata.

It is curious that we intuitively understand this when presented with a spreadsheet but it does not occur to us when presented with SharePoint, which is, basically a supercharged online version of a spreadsheet.

A rich, underused, resource. There is a long essay on metadata and folders in our article about SharePoint.

See also