| Author |
Topic |
|
lepeniotis
Yak Posting Veteran
75 Posts |
 Posted - 2008-10-14 : 08:55:12
|
| Hi all,I'm starting a PhD on Databases with the following subject."This will be a research on Database designing methods considering the normalization levels and the database platforms. There will also be a research on the system procedures of every database platform vendor and an analysis of them."Thats my main thought.My supervisor told me to start a research on sth that it is not covered by the literature review. Always related to Databases. Till now I have covered all the literature from microsoft press and the only gap that I have found is the designing methods. However researching on the literature I haven't found sth that compares the platforms and the optimization methods. their results their benefits and their disadvantages.What I ask here is if you can tell me sth that you have in mind that it is not covered by the literature and if after so many years of experience have found some gaps that may need further research and invastigation.Thank you very much for your time and I really appreciate any help.Regards,Panagiotis LepeniotisMSc Advanced Computing Science MSc Database ProfessionalSheffield Hallam UniversityMCP (70-229, 70-228)Industrial IT Engineer |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-10-14 : 09:00:11
|
There is main thing that differ between RDBMs vendors1) The implementation of standard ANSI SQL language
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2008-10-16 : 10:05:46
|
| You should look into unifying relational database theory with Superstring theory by generalizing relational algebra and pseudo-Cuntz algebra acting on indefinite-metric vector spaces with respect to the zero-mode operators of antighosts to show that they can be used interchangeably to construct an n-dimensional representation of data, matter, and energy.Make Wolfgang Pauli proud.CODO ERGO SUM |
|
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2008-10-16 : 13:02:12
|
quote:
Originally posted by lepeniotis
That is something that I hear it for first time! Can you give me a point to start?
This guy practically wrote the book on unifying relational database theory with Superstring theory by generalizing relational algebra and pseudo-Cuntz algebra acting on indefinite-metric vector spaces with respect to the zero-mode operators of antighosts to show that they can be used interchangeably to construct an n-dimensional representation of data, matter, and energy: http://relationary.wordpress.com/If it is not practically useful, then it is practically useless. |
|
|
|
Arnold Fribble
Yak-finder General
1961 Posts |
Posted - 2008-10-16 : 13:37:02
|
quote:
Make Wolfgang Pauli proud.
Shouldn't this be in the "not even wrong" thread? |
|
|
|
Arnold Fribble
Yak-finder General
1961 Posts |
Posted - 2008-10-16 : 13:47:49
|
| I'd like to see a more algebraic approach to query optimization, myself. Many's the time when I've had to shout at the optimizer for forgetting the monotonicity of a data stream in some operation and consequently inserting unnecessary sorts the execution plan, or it imagines that there can be thousands of times more rows in the output than is provably the case and consequently uses the wrong join... |
|
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2008-10-16 : 14:56:09
|
OK, I'll bite. What is quote:
Originally posted by lepeniotis
sth
???At first I thought it was just a typo, but you keep using it again and again so either your keyboard is stuck or it actually means something.If it is not practically useful, then it is practically useless. |
|
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2008-10-16 : 15:48:28
|
| We avoid l33t speak on these boards.If it is not practically useful, then it is practically useless. |
|
|
|
relationary
Starting Member
2 Posts |
Posted - 2008-10-17 : 07:13:16
|
| I would suggest considering Simon Williams' Associative Model of Data at [url]www.lazysoft.com[/url]And when you are finished that, Grant Czerepak's Hexahedron Theory at [url]relationary.wordpress.com/2008/10/14/universe-hexahedron-theory/[/url]Togther, you have a powerful alternate architecture and schema design, compared to relational architecture and conventional schemas.http://relationary.wordpress.com]relationary |
|
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2008-10-17 : 09:40:21
|
quote:
Originally posted by blindman
We avoid l33t speak on these boards.If it is not practically useful, then it is practically useless.
You know we don't by choice: it's just that none of us are k3wl enuf to get away with it.-------------Charlie |
|
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2008-10-17 : 10:15:16
|
quote:
Originally posted by relationary
I would suggest considering Simon Williams' Associative Model of Data at [url]www.lazysoft.com[/url]And when you are finished that, Grant Czerepak's Hexahedron Theory at [url]relationary.wordpress.com/2008/10/14/universe-hexahedron-theory/[/url]Togther, you have a powerful alternate architecture and schema design, compared to relational architecture and conventional schemas.http://relationary.wordpress.com]relationary
Dude, we already directed him to that website:quote:
Originally posted by blindman
quote:
Originally posted by lepeniotis
That is something that I hear it for first time! Can you give me a point to start?
This guy practically wrote the book on unifying relational database theory with Superstring theory by generalizing relational algebra and pseudo-Cuntz algebra acting on indefinite-metric vector spaces with respect to the zero-mode operators of antighosts to show that they can be used interchangeably to construct an n-dimensional representation of data, matter, and energy: http://relationary.wordpress.com/
I mean, we all know there is simply no better authority on unifying relational database theory with Superstring theory by generalizing relational algebra and pseudo-Cuntz algebra acting on indefinite-metric vector spaces with respect to the zero-mode operators of antighosts to show that they can be used interchangeably to construct an n-dimensional representation of data, matter, and energy than Grant Czerepak. He's da' bomb.If it is not practically useful, then it is practically useless. |
|
|
|
georgev
Posting Yak Master
122 Posts |
Posted - 2008-10-17 : 10:27:55
|
blindman, the majority of your sarcasm is lost in this thread.Such a shame :(
George |
|
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2008-10-17 : 11:14:48
|
| But that's the challenge, isn't it?If it is not practically useful, then it is practically useless. |
|
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2008-10-17 : 11:20:21
|
| lepeniotis, I'll give you some serious advice.This is a rather odd subject for a PHD thesis."This will be a research on Database designing methods considering the normalization levels and the database platforms. There will also be a research on the system procedures of every database platform vendor and an analysis of them."The reason being that Database Normalization Methods are about as far removed from Database Platform System Procedure as you can get and still be talking about databases.Also, I don't seen any way you can feasibly review "every" database platform vendor. Realistically, you would have to confine yourself to just a few.Also, good luck finding ANY subject that isn't "covered by the literature". Let me know when you find a google search that returns zero results.One area you might look into is the relative advantages and disadvantages of the locking strategies of Oracle vs. SQL Server. That is an area where they differ greatly, and it has a significant effect on database design and an ENORMOUS effect on SQL coding.If it is not practically useful, then it is practically useless. |
|
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2008-10-17 : 14:20:36
|
| Well, in all honesty, the people on this forum WILL help you out and give you some advice, but you have to understand two things:1) The forum has a culture that is more than occasionally sarcastic. We're just having fun with a rather dry subject when it comes down to it.2) Forum members have a low tolerance for "poseurs". You are preparing a PHD thesis on databases and list several database credentials in your sig, but the wording of your post did not demonstrate an in-depth understanding of databases.But again, I and others on the forum will help you out if:A) You don't over-represent yourself.B) You join in the fun.Here is the acid test: if you follow the links we gave you to the relationary website and read some of the guy's content and are able recognize that he is full of crap....then welcome to the forum. You're in!If it is not practically useful, then it is practically useless. |
|
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2008-10-17 : 15:55:31
|
quote:
Originally posted by lepeniotis
I saw the links about the theory but I couldn't understand anything, so I ignore it.
I wish I had your self-control.If it is not practically useful, then it is practically useless. |
|
|
|
Arnold Fribble
Yak-finder General
1961 Posts |
Posted - 2008-10-17 : 16:29:21
|
quote:
Originally posted by blindmanI wish I had your self-control.
I wish that too. |
|
|
|
darkdusky
Aged Yak Warrior
591 Posts |
Posted - 2008-10-20 : 09:41:46
|
| How about column store versus row store: http://glinden.blogspot.com/2008/08/column-versus-row-stores.html |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-10-22 : 07:51:03
|
quote:
Originally posted by blindman
quote:
Originally posted by lepeniotis
I saw the links about the theory but I couldn't understand anything, so I ignore it.
I wish I had your self-control.If it is not practically useful, then it is practically useless.
I don't as i'd rather understand why it was rubbish. |
|
|
|
relationary
Starting Member
2 Posts |
Posted - 2009-02-14 : 18:28:15
|
| I recommend you examine the comments of blindman in any forum he participates in.Technologically, he is an in the box thinking bureaucrat.He contributes nothing and is an obstacle to everything.http://relationary.wordpress.com]relationary |
|
|
|
Alexander Barnes
Starting Member
10 Posts |
Posted - 2009-02-14 : 21:33:43
|
| Blindman and relationary - thanks for pointing me to an interesting site. I have to ask what it "is" - besides being brilliant and befuddling, both at once...? The story about the passport experience (Creativity: Democratizing Evolution) was uncanningly like some of my own thoughts as I traverse the halls of bureacracy philosophizing to myself ... I'm guessing this is a site for bloggers...but of any particular kind? |
|
|
|
Next Page
|
PhD proposal any suggestion?