3 ms·
This is a great list. One omission is the spreadsheet memory model. The spreadsheet can be argued as the multi-dimension array like in Fortran, but it's not.
by ww520 10y ago
This is a great list.
One omission is the spreadsheet memory model. The spreadsheet can be argued as the multi-dimension array like in Fortran, but it's not. Both the data of primitive types and the computation declaration are stored in the table cells. Data dependency and computation are declared. Computation order is not specified and is run on the whole table as a dependency graph. It's kind of unique.
- mathgenius 10y ago> array like in Fortran ... as a dependency graph A spreadsheet is a bunch of pipes, arranged so that the endpoints live in an array.
- ww520 10y agoIn that case, the data, the pipes, and the programs all live in the array.
- mhneu 10y agoThe spreadsheet model is the SQL table model. You should separate spreadsheet computation (which for these languages is written in the language) from the spreadsheet data. Spreadsheets slightly generalize the SQL table by allowing cells to have varying data type, but without loss of generality any spreadsheet can be broken down into a set of SQL tables.
- kragen 10y agoThank you! I think spreadsheets are kind of at a different level of abstraction from what I was talking about in this essay, a higher level. They're more like a data model or a programming paradigm than a memory model.