codingmasterRS Posted July 11, 2010 Share Posted July 11, 2010 First off I hope I have posted this in the right spot, if not Admins feel free to move it. Okay so I thinking of designing a web search engine (like Google/Bing/etc), and I was wandering what their DB structure was like, how do they link so many keywords and phrases to a URL etc, I am NOT concerned about their ranking algorithms just the DB structure etc... If you can offer ANY help in ANY way it would be very very much appreciated Thanks in advance codingmasterRS Quote Link to comment https://forums.phpfreaks.com/topic/207431-database-design/ Share on other sites More sharing options...
fenway Posted July 11, 2010 Share Posted July 11, 2010 That's a ridiculously large topic -- and there is no right answer. What are you planning on searching? Quote Link to comment https://forums.phpfreaks.com/topic/207431-database-design/#findComment-1084472 Share on other sites More sharing options...
ignace Posted July 11, 2010 Share Posted July 11, 2010 First off SE like Google do not use MySQL they use a "NoSQL"-alternative like BigTable. Second their DB structure is not normalized (or not much) for performance. Quote Link to comment https://forums.phpfreaks.com/topic/207431-database-design/#findComment-1084558 Share on other sites More sharing options...
fenway Posted July 11, 2010 Share Posted July 11, 2010 First off SE like Google do not use MySQL they use a "NoSQL"-alternative like BigTable. Second their DB structure is not normalized (or not much) for performance. Don't even bother trying to emulate anything of that scale. Quote Link to comment https://forums.phpfreaks.com/topic/207431-database-design/#findComment-1084570 Share on other sites More sharing options...
codingmasterRS Posted July 12, 2010 Author Share Posted July 12, 2010 Okay so their NoSQL structure would be like ..... (for example) ..... Quote Link to comment https://forums.phpfreaks.com/topic/207431-database-design/#findComment-1084636 Share on other sites More sharing options...
fenway Posted July 12, 2010 Share Posted July 12, 2010 Okay so their NoSQL structure would be like ..... (for example) ..... I wasn't kidding -- don't even start to try. Non-relational databases are quite a different beast. Quote Link to comment https://forums.phpfreaks.com/topic/207431-database-design/#findComment-1084830 Share on other sites More sharing options...
ignace Posted July 12, 2010 Share Posted July 12, 2010 Okay so their NoSQL structure would be like ..... (for example) ..... I have no idea what you mean by that, here's a link to the wikipedia article on NoSQL Quote Link to comment https://forums.phpfreaks.com/topic/207431-database-design/#findComment-1084964 Share on other sites More sharing options...
fenway Posted July 12, 2010 Share Posted July 12, 2010 Seriously, stop -- you're new at this -- don't even start to playing with NoSQL at this stage. Quote Link to comment https://forums.phpfreaks.com/topic/207431-database-design/#findComment-1085091 Share on other sites More sharing options...
codingmasterRS Posted July 13, 2010 Author Share Posted July 13, 2010 @fenway then suggest a relational DB solution, but I will use a NoSQL solution Quote Link to comment https://forums.phpfreaks.com/topic/207431-database-design/#findComment-1085127 Share on other sites More sharing options...
ignace Posted July 13, 2010 Share Posted July 13, 2010 @fenway then suggest a relational DB solution, but I will use a NoSQL solution LOL is that a threat? Quote Link to comment https://forums.phpfreaks.com/topic/207431-database-design/#findComment-1085235 Share on other sites More sharing options...
codingmasterRS Posted July 13, 2010 Author Share Posted July 13, 2010 @ignace, HOW can it be a threat Quote Link to comment https://forums.phpfreaks.com/topic/207431-database-design/#findComment-1085342 Share on other sites More sharing options...
fenway Posted July 13, 2010 Share Posted July 13, 2010 @fenway then suggest a relational DB solution, but I will use a NoSQL solution That's a bad idea -- but feel free to ignore me, it's your product, not mine. Quote Link to comment https://forums.phpfreaks.com/topic/207431-database-design/#findComment-1085375 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.