SAP HANA SQL in itself is no rocket science. It strongly gravitates around standard SQL-92, with a couple of extensions here and there.
If I had to decide about my favorite SQL primitive data type, without giving it much more intellectual thought than I already did, I would choose the cute and light 8-bit store unsigned integer, wearing the not-really tiny, little pleonastic name "TINYINT" (please, note the freestyle usage of double quotes for non-identifiers).
If you do the math, 2 to the power of 8 is 256, that is, a TINYINT can assume the values from 0 to 255, which should be enough for columns containing integer data such as, for example, people's ages.
I don't think a Y2K-similar issue is expected for the next couple of hundred years regarding human longevity. Maybe the kids born today will have a chance to live 100-110 years on average (although I am not yet convinced about this statistical extrapolation), but I do not expect us to survive much longer than that, at least before a new age of revolutionary Hardware and Software Migration waves happens spontaneously. It would be interesting to do a global programmer's statistics study (maybe there is already more than one) and calculate the percentage of developers taking the time to carefully analyze the minimum/maximum amount of storage required for the different data fields for a software application.
My hypothesis is that many developers will tend to take slightly "oversized" data types, just in case. I also tended to do that myself some years ago when I was a real developer, but then again, I was not a brilliant Wozniak. I must also admit that 10 to 15 years ago I was naive enough to think that the Club of Rome was exaggerating a bit in 1972.
During IT prehistory, people had to save data storage for necessity. Nowadays people may think they can afford to be profligate and extravagant with RAM, Disk and CPU power, because "capacity is going up and prices are going down" all the time.
There is no need to be extremely ecologically intelligent to see the catch in this reasoning, even though we are bombarded with this kind of statements from everywhere all the time.
And now I will temporarily get back to purely robotic-thinking, even though I am not finished with all I wanted to say about the topic above, and will keep developing this line of thought further in the near future.
Let me give you a very compact summary about the main SAP HANA SQL Data Types, just for the (robotic?) fun of it:
That was it about SAP HANA SQL Data Types on my side... And now I have to go. I need to recreate some users in the SAP HANA instance I will be using tomorrow for the next training, create a couple of variables for some Analytic Views, in order to show off a bit (although currently, this "variables business" with the SAP HANA Studio does not give you the greatest user experience in the world, to put it very diplomatically), and I also want to observe the behavior of my new royal Analytic Privileges, of course on the sly, and without cameras. Last but not least, I have to prepare lunch... collaboratively. I am hungry after so much discussion about storage and resources, but we like mediterranean cuisine, which tends to be lean(er) than others.
Gemma Durany
Co-Founder and COO
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
37 | |
10 | |
5 | |
4 | |
4 | |
3 | |
3 | |
3 | |
2 | |
2 |