| Author |
 Topic  |
|
SwePeso
Patron Saint of Lost Yaks
Sweden
29138 Posts |
 Posted - 01/30/2008 : 17:32:41
|
quote:
Originally posted by rel1976
Looks like you understand dimensionality as it relates to databases no better than the thread starter you're criticizing.
Hi and welcome to SQLTeam my russian friend!
If you want to discuss relativity and dimensions, please feel free to email me.
E 12°55'05.25"
N 56°04'39.16" |
 |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
USA
6997 Posts |
Posted - 01/30/2008 : 17:59:28
|
quote:
Originally posted by rel1976
quote:
Originally posted by Peso
Made me laugh good!
Just wait until he wants to introduce a fourth dimension 
Looks like you understand dimensionality as it relates to databases no better than the thread starter you're criticizing.
- rel -
I'm certainly looking forward to you enlightening us. Please proceed.
CODO ERGO SUM |
|
|
|
rel1976
Starting Member
4 Posts |
Posted - 01/30/2008 : 18:32:27
|
quote:
Originally posted by Michael Valentine Jones
quote:
Originally posted by rel1976
quote:
Originally posted by Peso
Made me laugh good!
Just wait until he wants to introduce a fourth dimension
Looks like you understand dimensionality as it relates to databases no better than the thread starter you're criticizing.
- rel -
I'm certainly looking forward to you enlightening us. Please proceed.
CODO ERGO SUM
Well, since you asked nice 
We'll ignore star schema design in dimensional (cube, OLAP, what-have-you) databases, other than to note that a fact table can have many dimensions (subject to implementation and hardware constraints).
Moving on, then, to relational (let's say, the "OLTP" world):
A table represents a relation. This is where the word "relational" comes from, as in "relational database", the "R" in RDBMS.
A table has some number of columns specified for it. These correspond to attributes in the relation being represented.
The dimensionality of a relation is the number of attributes it has. These correspond to placeholders in the predicate that the relation models.
So, for example, a table with 2 columns represents a relation with two attributes, models a binary predicate and is 2-dimensional. In general, a table with n columns represents a relation with n number of attributes, models an n-ary predicate, and is n-dimensional.
- rel - |
|
|
|
SwePeso
Patron Saint of Lost Yaks
Sweden
29138 Posts |
Posted - 01/30/2008 : 18:36:24
|
Thank you for the Class 101 notes.
As a sidenote, did you read the topic in the link?
E 12°55'05.25"
N 56°04'39.16" |
Edited by - SwePeso on 01/30/2008 18:37:06 |
|
|
|
rel1976
Starting Member
4 Posts |
Posted - 01/30/2008 : 20:00:23
|
quote:
Originally posted by Peso
Thank you for the Class 101 notes.
As a sidenote, did you read the topic in the link?
E 12°55'05.25"
N 56°04'39.16"
Yer welcome. It's just that in an industry where a practitioner can be considered an "expert" (and make a good living professionally) without even knowing the fundamentals of the field, I've learned never to take such knowledge as a given.
Does it ever blow your mind that probably the majority of people that you so patiently help and have still made "the list" on this thread get paid to do what they do?
- rel -
P.S. Yes, I read the topic. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
Sweden
29138 Posts |
Posted - 01/30/2008 : 20:12:56
|
quote:
Originally posted by rel1976
Does it ever blow your mind that probably the majority of people that you so patiently help and have still made "the list" on this thread get paid to do what they do?
And your point is?
E 12°55'05.25"
N 56°04'39.16" |
|
|
|
eyechart
Flowing Fount of Yak Knowledge
USA
3575 Posts |
Posted - 01/30/2008 : 21:40:29
|
quote:
Originally posted by Peso
quote:
Originally posted by rel1976
Does it ever blow your mind that probably the majority of people that you so patiently help and have still made "the list" on this thread get paid to do what they do?
And your point is?
E 12°55'05.25"
N 56°04'39.16"
apparently he is saying that he gets paid to do this too
-ec |
|
|
|
spirit1
Cybernetic Yak Master
Slovenia
11741 Posts |
Posted - 01/31/2008 : 05:13:21
|
i acctually have agree with the rel guy on the blowing the mind point.
being an "IT professional" is a very easy title to get even with the total lack of skills.
and majority never get those skills.
that'd be like having me performing a heart surgery wittout the proper medical training.
sure... i know how the heart works and looks like but hell if i feel competent to fiddle with it...
_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
SSMS Add-in that does a few things: www.ssmstoolspack.com <- new version out |
|
|
|
SwePeso
Patron Saint of Lost Yaks
Sweden
29138 Posts |
Posted - 01/31/2008 : 05:21:27
|
So when a lesser experienced surgeon consults a more experienced surgeon, should the lesser experienced surgeon listen to the advice he get, or should he tell the more experienced surgeon
- No, I want to do this open heart medical procedure my way because I don't like the suggestion you gave me
I think the lesser experienced surgeon should pay attention to the advice he get, or the chances are that the lesser experienced surgeon ends up like a modern Dr Frankenstein.
For what I can tell, top 20 posters on SQLTeam have at least 250 years of combined experience is this field.
E 12°55'05.25"
N 56°04'39.16" |
Edited by - SwePeso on 01/31/2008 05:28:38 |
|
|
|
spirit1
Cybernetic Yak Master
Slovenia
11741 Posts |
Posted - 01/31/2008 : 05:30:04
|
no of course not... that's not what i meant and you know it!
_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
SSMS Add-in that does a few things: www.ssmstoolspack.com <- new version out |
|
|
|
SwePeso
Patron Saint of Lost Yaks
Sweden
29138 Posts |
Posted - 01/31/2008 : 05:35:31
|
Yes, I know you know I know you know.
E 12°55'05.25"
N 56°04'39.16" |
Edited by - SwePeso on 01/31/2008 05:38:40 |
|
|
|
spirit1
Cybernetic Yak Master
Slovenia
11741 Posts |
Posted - 01/31/2008 : 05:49:10
|
i'm relly glad that you know i know you know i know you know.
_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
SSMS Add-in that does a few things: www.ssmstoolspack.com <- new version out |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
RickD
Slow But Sure Yak Herding Master
United Kingdom
3560 Posts |
Posted - 01/31/2008 : 11:22:51
|
quote:
Originally posted by X002548
Mostly because the monkeys doing the "training" have no real world experience
I have got to agree with this.
Until these people have been in situations where they are told 'I don't care how, just get it done!', then they are mostly full of drivel. |
|
|
|
elancaster
A very urgent SQL Yakette
United Kingdom
1208 Posts |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
TG
Flowing Fount of Yak Knowledge
USA
5469 Posts |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
USA
6997 Posts |
|
|
DavidChel
Constraint Violating Yak Guru
USA
474 Posts |
Posted - 02/25/2008 : 16:59:04
|
| I can't imagine acting like that and expecting anyone to be willing to help me afterwards. |
|
|
|
Topic |
|
Twit List
