Metadata: Difference between revisions

From The Jolly Contrarian
Jump to navigation Jump to search
No edit summary
No edit summary
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|''meta''data]].  
[[Information]] ''about'' [[information]]. Data that describes other data.


A rich, underused, resource. There is a long essay on the benefits of [[metadata]] over [[folders]] in our [[SharePoint]] essay.
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. There is an <<item>> and associated with it will be <<fields>>. Each field is a single point 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''.
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}}

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