BLU Discuss list archive
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Discuss] SQL discussion
- Subject: [Discuss] SQL discussion
- From: markw at mohawksoft.com (markw at mohawksoft.com)
- Date: Thu, 15 Jan 2015 15:33:42 -0500
- In-reply-to: <54B7AE1C.3040400@blu.org>
- References: <3b5e4d10464b98632f1d45a222c26f73.squirrel@mail.mohawksoft.com> <54B54C35.4060304@gmail.com> <0d92d1e432b8c5f1114ff2fe7f1b22b5.squirrel@mail.mohawksoft.com> <54B576BB.8020603@gmail.com> <ac7a1a82ad4ed8e6695d14f5b06cef58.squirrel@mail.mohawksoft.com> <54B6D612.8090506@gmail.com> <li6k30p6os4.fsf@panix5.panix.com> <54B7AE1C.3040400@blu.org>
> You can and usually have many tables. That's true. This example is quite good, actually. So the issue with dimensions, regardless of technology, is how do you represent them. A computer, at its core, only has one axis, i.e. element offset linear addressing. Everything else is a construct beyond that. For example: mov ecx, index mov ebx, [ecx] Everything else is X * Y [Z [* n]] Where X is the width of the record or data item, and x is the index. If you want to represent multiple dimensions you need to come up with a way to map the above into some addressing scheme that emulates true n-dimensions. What ever system you use to access a multidimensional array it has to construct this behavior in what ever language it is written in, and what ever functions and constructs it uses to implement these arrays, they are still constructs based on linear addressing. SQL should is no better or worse than any other system that is capable of multidimensional representation. Probably better because people have been doing it in SQL for some time. > > On 01/14/2015 04:22 PM, Mike Small wrote: >> Richard Pieri <richard.pieri at gmail.com> writes: >>> Precisely. What is the structure of a relational database? A table. A >>> 2-dimensional table. If you have 3 dimensions of data in a relational >> | x | y | z | t | Humidity | Pressure | >> |-----+-----+----+-------+----------+----------| >> | 100 | -10 | 12 | 12:05 | 40 | 1.302 | >> ... >> |-----+-----+----+-------+----------+----------| >> >> >> Not what you had in mind? >> >> > > -- > Jerry Feldman <gaf at blu.org> > Boston Linux and Unix > PGP key id:B7F14F2F > PGP Key fingerprint: D937 A424 4836 E052 2E1B 8DC6 24D7 000F B7F1 4F2F > > > _______________________________________________ > Discuss mailing list > Discuss at blu.org > http://lists.blu.org/mailman/listinfo/discuss >
- References:
- [Discuss] SQL discussion
- From: markw at mohawksoft.com (markw at mohawksoft.com)
- [Discuss] SQL discussion
- From: richard.pieri at gmail.com (Richard Pieri)
- [Discuss] SQL discussion
- From: markw at mohawksoft.com (markw at mohawksoft.com)
- [Discuss] SQL discussion
- From: richard.pieri at gmail.com (Richard Pieri)
- [Discuss] SQL discussion
- From: markw at mohawksoft.com (markw at mohawksoft.com)
- [Discuss] SQL discussion
- From: richard.pieri at gmail.com (Richard Pieri)
- [Discuss] SQL discussion
- From: smallm at panix.com (Mike Small)
- [Discuss] SQL discussion
- From: gaf at blu.org (Jerry Feldman)
- [Discuss] SQL discussion
- Prev by Date: [Discuss] Boston Linux Meeting Wednesday, January 21, 2015 - Fotoxx Update
- Next by Date: [Discuss] Finance software for Linux
- Previous by thread: [Discuss] SQL discussion
- Next by thread: [Discuss] SQL discussion
- Index(es):