Tuesday, December 20

You do not exactly want a relational database

SQL is touted as a relational database, with some historic infighting because of "relational" issues.

But mostly you do not want a relational database.

A "true" relational database would, in SQL, be like if all SELECT statements were really SELECT DISTINCT statements. (This is based on the mathematical definition of a "relation" which is where we get things like outer joins from. Of course, if we instead redefine "relational" to be whatever arbitrary collection of concepts got included in some particular SQL implementation or SQL standard there's no changes from that particular choice which remain.)

So, for example, if you were tracking money (or food, or really anything), and you happened to have multiple rows with the same value, some of that would vanish from your record keeping.

I think the fundamental structure of a database table is a named collection of columns (where each column is a sequence of the same length and each value in a column is the same type - stored the same way and interpreted using the same mechanics).

Though, for databases optimized for things like retail sales, there's a long history of pushing that structure down into the row and implementing the table as a collection of rows (with some waffling about the sequential aspect of these rows - they really are still a sequence, but the traditional database implementation reorders things rather often).

Monday, August 29

Business Case Issues for Semiconductor Printers

(This is not a formal business case, but preliminary thinking that might be useful for building a business case.)

Intuitively, Semiconductor Printers (probably mostly based on silicon wafers and molecular beam epitaxy, but other approaches can be viable for some purposes) seems like it should "fit" in today's economy. The underlying techniques are old, and proven (and a first generation of patents has expired). We've a variety of systemic issues where this approach seems like it could be fruitful. And, making this work is just hard enough that the prices on these systems is extremely high - ripe for disruptive harvesting.

But why?

#1) Entertainment value.

People like to build things. Construction games have historically been steady money makers, and there's a measurable fraction of our population (perhaps 16%?) who just enjoy making things.

#2) STEM Education

There's a lot of schlock information out there, and to distinguish between the meaningful and the trash you need to have some practical experiences. Done right, these printers can teach people some important things about physics and engineering which will later be useful in addressing real needs.

#3) Business Failures

Most businesses fail. People building businesses often need to cut corners for a variety of reasons. Entire lines of semiconductors can suddenly become not available or only available under adverse conditions. In many cases these issues can be solved through negotiation and/or finding other approaches. But having another fallback can help extend negotiation timetables and can sometimes be that "other approach".

#4) Tool building

Currently, there is a lot of red tape and cost involved in designing and building new semiconductor devices (unless you happen to be associated with the right people - who are often in some other country). We can change that.

Semiconductors (and related things: conductors and insulators) include things like sensors and things that make different kinds of light. The underlying fabrication process might also be used for making "nano-scale devices" - perhaps useful for fabrics or medical or biological work.

Finally, note that a major cost and design issue is the vacuum chamber. High vacuum chambers are readily available already, but getting power and materials into them can be a significant challenge. This all changes for space based systems, where vacuum is a "natural resource". This points at a variety of future possibilities and the people who understand how to make these things work well will have some advantages in getting space based computer manufacturing ready for market.