Advanced HTML table features, Part 2Mon, May 8, 2006 in Web
This is the second article in a two-part series on understanding and using advanced features in HTML tables. In the first part I explained a few of the simpler features. In this article I’ll explain how the
axis attribute allows an author to encode multi-dimensional data into two-dimensional tables, and to encode relational data into hierarchical tables.
Encoding multiple dimensions
There are lots of places where data has more than two dimensions – or where I might want to break data apart into more than two dimensions.
As just one example, take business intelligence analysis in a relational database. Star schemas and data cubes are built expressly for the purpose of slicing and aggregating data by dimensions and measures.
I know that’s a mouthful if you’re not familiar with this type of analysis. What I’m saying is, data comes in a lump, and I want to slice and dice it a bunch of ways. For example, if I’m doing BI for a catalog retailer, I want to be able to analyze orders
- over time
- by number of items
- per buyer
- by buyer frequency
- by total dollar amount
- by geographic location
- by sign of zodiac…
Any seemingly simple data actually has tons and tons of information in it, all along different dimensions, and if I squint along the right dimensions, I see patterns that aren’t obvious otherwise. Some of the dimensions are inherent to the data itself, and others need to be indicated explicitly. For instance, the total number of orders is inherent to a set of data – I count the set to find it. Whether each order is a gift is NOT inherent to the set of data; this I need to indicate in each order. Once I have encoded that information, it’s possible to slice the data along yet another dimension (gift/non-gift).
axis attribute allows me to specify to which dimensions each cell belongs:
This attribute may be used to place a cell into conceptual categories that can be considered to form axes in an n-dimensional space... The value of this attribute is a comma-separated list of category names.
I know of no user agent which currently does the kinds of gymnastics mentioned in the spec (it sounds like the authors of the spec envision user agents as SQL databases, and users themselves as data analysts), but the capability is there in the data. I can encode rich semantic information into table cells with
axis, basically categorizing each little bit of data. And I can do it on a cell-by-cell basis – the finest granularity possible in a table.
It’s a similar concept to the way people are “tagging” things on the web these days. Since I can add as many axes to my table as I want just by putting them into the cells, there can be many-to-many relationships between the data and the axes/tags/categories.
The multiple-hierarchy problem
HTML’s essential nature is hierarchical, because elements are contained inside other elements. Whenever I encode data in one hierarchy, I rule out placing it into another. Yet I almost always want multiple hierarchies – this is a truism I’ve seen time after time in real-life applications, and it always frustrates people because it severely limits what they can do with the data.
Here’s a real example of the multiple-hierarchy problem. At my previous employer, I was tasked with integrating an analysis software package into a website. The package created a set of nested categories and subcategories for each page and product, and when a user visited a page, they recorded the page visit. Their analysis system, which the marketing and creative teams used, allowed what data-analysis folks often call “drill-down” – start viewing overall stats at the top (whole website), then navigate down through the categories to view statistics about each one. So, if I started at the top, then navigated to Men’s Wear, then to Shoes, I could see how the men’s shoes pages performed. I could do the same thing with Women’s Wear/Shoes, or Children’s/Shoes. But I could not get a summary of all pages about shoes.
This is a predictable situation. It happens every time someone tries to “categorize” things with a hierarchy. What the teams wanted was relational data, not hierarchical (actually, hierarchies are relational, but they only allow one kind of relationship: parent to child).
Another example of where people want to escape a single hierarchy is tables themselves – lots of people want the
colgroup element to apply CSS properties to “child” cells, but it can’t because of the strict element hierarchy (
colgroup is not really the parent element of any table cells at all). You can read hundreds of comments about this on Mozilla bug 915.
Flatten out the hierarchy with
It’s just not possible to have multiple hierarchies; the only way to break out of it is to encode relational data as relational, not hierarchical. That’s what
axis can do. Instead of building a strict hierarchy, I can build a flat table, then encode enough meta-data to let a processing application categorize the data as needed.
The HTML spec says
axis is for categorizing data, potentially for rendering tables in non-visual user agents, but there’s no reason that data can’t be used for other things too, such as processing by scripts. The possibilities are pretty much limitless. Just consider how scriptable the
class attribute is –
axis offers similar power, but it’s decoupled from CSS, so it’s potentially even simpler.
Example: the color chooser
This article is getting long, so I’ll wrap up with a simple example of multi-dimensional data commonly encoded in two dimensions: the familiar color chooser. Here are several color choosers from various systems:
Dreamweaver’s color chooser flattens three dimensions (red, green, blue) into two by slicing the cube into layers and placing them next to each other. Notice how there are two rows of three six-by-six blocks of color – six blocks of six by six. You can see the same strategy at a paint store. If you step back and unfocus your eyes, you can always see blocks of color next to each other.
This color chooser from the GIMP flattens the three dimensions (hue, saturation and luminance) into two by placing hue in the narrow bar on the right, and the saturation and luminance in the square on the left. The selected hue is red, all the way at the top of the bar.
This one is from the GIMP again, but it’s a different style. Don’t let the triangle fool you. It’s the same dimensions as the first one, presented a bit differently. I guess some people find it easier to use.
This is from Microsoft Paint. This is also hue, saturation and luminance. Luminance is in the narrow bar at the right. Hue is in the square (left to right), and saturation is too (top to bottom).
If I were to mark up a table of all HTML colors, I might only mark up the cells that fall on the axes to indicate where the axes are. In other words, the cell containing the color
#110000 would be on the
red axis, and the cell containing the color
#001100 would be on the
Another way I might mark things up would be to indicate when a value falls in a plane. For example, the value
#003377 is in the
I don’t know why I’d want to do any of that. I’m just hypothesizing. It would depend completely on the need I am trying to satisfy.
So, what do I do with this stuff?
If I were processing tabular data with scripts, and it involved any kind of aggregating or slicing, folding into pivot tables, or so forth, I’d certainly be using the features I’ve discussed above. Right now, though, I’m not doing any of that. I’ve had some cool data-processing articles, including scripts that do this kind of fancy processing, in draft form for about 6 months… someday I’ll finish them.
Until then, invent your own uses! How about a script that iterates over every cell, collecting a list of all axes, then populates a drop-down menu with the axes so a user can choose to do something to one axis at a time? By “do something,” I mean it could hide the other cells, or do some math on the selected axis. For example, you could have another drop-down menu of functions on the selected cells, like a spreadsheet’s status-bar display (sum, avg, etc):
In this article I explained how the
axis attribute of table cells can indicate to which axes the cell belongs in a multi-dimensional space, the multiple hierarchy problem and how to solve it, and gave some examples of flattened-out multi-dimensional data. This article is probably a solution in search of a problem, but given that the
axis attribute isn’t used very much and might also be a solution without a problem, I don’t mind :-)
I'm Baron Schwartz, the founder and CEO of VividCortex. I am the author of High Performance MySQL and many open-source tools for performance analysis, monitoring, and system administration. I contribute to various database communities such as Oracle, PostgreSQL, Redis and MongoDB.