Metadata: Difference between revisions

From The Jolly Contrarian
Jump to navigation Jump to search
No edit summary
No edit summary
Line 16: Line 16:


{{sa}}
{{sa}}
*[[Desktops, metadata and filing]]
*[[SharePoint]]
*[[SharePoint]]
*[[Metadata taxonomy]]
*[[Metadata taxonomy]]
*[[Information]]
*[[Information]]

Revision as of 07:18, 28 September 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