Irish SEO,  Marketing & Webmaster Discussion
 

 

Go Back   Irish SEO, Marketing & Webmaster Discussion > Webmaster Help > Webmaster Discussion > CMS and Content Management


Reply
 
LinkBack (1) Thread Tools Display Modes
  1 links from elsewhere to this Post. Click to view. #1 (permalink)  
Old 27-04-2008, 05:14 PM
jmcc's Avatar
Wannabe Geek
 
Join Date: Feb 2006
Posts: 277
jmcc has a spectacular aura about
Default Best Navigation Architecture For Domain Database?

I've got a database here with the hosting history (new/deleted/transferred/dns added removed etc) for domains going back to 2000. In individual terms, it would be approximately 190 Million pages of content. Any ideas on how to build a navigation architecture (other than a search box)?

Regards...jmcc
Reply With Quote
  #2 (permalink)  
Old 27-04-2008, 10:21 PM
Briask's Avatar
Coder
 
Join Date: Feb 2008
Location: D'Office
Posts: 60
Briask will become famous soon enough
Default

Its down to what you want to be able to do?

Theres some nifty data mining architectures, data visualisation tools and navigation methods out there but you really need to start off with some idea of how you want to slice and dice the data.

What is you want ppl to do with the data? Find specifics?Carry out trend analysis? Visualise the data?
Reply With Quote
  #3 (permalink)  
Old 27-04-2008, 10:43 PM
jmcc's Avatar
Wannabe Geek
 
Join Date: Feb 2006
Posts: 277
jmcc has a spectacular aura about
Default

Quote:
Originally Posted by Briask View Post
Its down to what you want to be able to do?
Provide easily accessible domain hosting histories. The simplest way is to provide a search box. But I want to provide alternative searching methods and perhaps a directory structure. The directory structure is the hardest thing.

Regards...jmcc
Reply With Quote
  #4 (permalink)  
Old 28-04-2008, 12:16 AM
blacknight's Avatar
Web Slave
Recent Blog: Jaiku Back Online
 
Join Date: Jan 2006
Location: Ireland
Posts: 5,894
blacknight is just really niceblacknight is just really niceblacknight is just really niceblacknight is just really nice
Send a message via ICQ to blacknight Send a message via AIM to blacknight Send a message via MSN to blacknight
Default

Which TLDs are you covering?

It *might* make some sense to organise:
  • by tld
  • alphabetically
  • number of characters in domain
  • by nameserver
  • by country
  • by age (not sure about that one.. )
Reply With Quote
  #5 (permalink)  
Old 28-04-2008, 10:25 AM
jmcc's Avatar
Wannabe Geek
 
Join Date: Feb 2006
Posts: 277
jmcc has a spectacular aura about
Default

Quote:
Originally Posted by blacknight View Post
Which TLDs are you covering?
com/net/org/biz/info/eu/co.uk/mobi/asia for the moment.

Quote:
by tld
This is the one I've implemented already.
Quote:
alphabetically
Each list would be millions of domains long.[/quote]
Quote:
number of characters in domain
That's a good one.
Quote:
by nameserver
Could be tricky - there are loads of nameservers with one domain hosted but there are also nameservers with millions of domains hosted. The history of Godaddy's or Enom's nameservers is amazing.
Quote:
by country
Can be done. But it might not be 100% accurate.
Quote:
by age (not sure about that one.. )
This one is a very interesting option. It would be possible to generate complete lists of domains that were dropped and not reregistered. It would also be possible to identify tasted domains and domain tasters. It could be done on a monthly or yearly basis.

Regards...jmcc
Reply With Quote
  #6 (permalink)  
Old 28-04-2008, 11:21 AM
Forbairt's Avatar
respect my AW-THOR-IT-AYY
 
Join Date: Jun 2007
Location: My Office, Dublin
Posts: 1,664
Forbairt has a reputation beyond reputeForbairt has a reputation beyond reputeForbairt has a reputation beyond reputeForbairt has a reputation beyond reputeForbairt has a reputation beyond reputeForbairt has a reputation beyond reputeForbairt has a reputation beyond reputeForbairt has a reputation beyond reputeForbairt has a reputation beyond reputeForbairt has a reputation beyond reputeForbairt has a reputation beyond repute
Send a message via AIM to Forbairt Send a message via MSN to Forbairt Send a message via Yahoo to Forbairt Send a message via Skype™ to Forbairt
Default

alphabetically ... could be broken down further into ..

a -> aa ... ab ... ac .... th -> the...

listing them alphabetically with just the initial letter wouldn't make too much sense to me ... (unless it was something like dropped irish domains)

Also .. if you start getting spidered 190 million page hits could be ouch ... not to mention bots potentially collecting all the data from your system (though you've probably thought of that already)
__________________
Forbairt Media | Web Design & Development Galway / Dublin, Ireland - coming soon ... ( vague but descriptive isn't it )

Recent Work: Safari Club African Safari Holidays - Botswana Safaris
Reply With Quote
  #7 (permalink)  
Old 28-04-2008, 11:41 AM
jmcc's Avatar
Wannabe Geek
 
Join Date: Feb 2006
Posts: 277
jmcc has a spectacular aura about
Default

Quote:
Originally Posted by Forbairt View Post
alphabetically ... could be broken down further into ..

a -> aa ... ab ... ac .... th -> the...

listing them alphabetically with just the initial letter wouldn't make too much sense to me ... (unless it was something like dropped irish domains)
Yep. This would narrow it down a bit.

Quote:
Also .. if you start getting spidered 190 million page hits could be ouch ... not to mention bots potentially collecting all the data from your system (though you've probably thought of that already)
It gives me nightmares. Google is ok. But the morons in Microsoft and Yahoo with their multitude of braindead spiders would be continually hammering the sites. As for the scrapers, I have no problem with banning entire countries or Class A if they irritate me. The trick is maintaining a healthy balance between giving genuine users the info they want and blocking maggots.

Regards...jmcc
Reply With Quote
  #8 (permalink)  
Old 28-04-2008, 12:22 PM
Forbairt's Avatar
respect my AW-THOR-IT-AYY
 
Join Date: Jun 2007
Location: My Office, Dublin
Posts: 1,664
Forbairt has a reputation beyond reputeForbairt has a reputation beyond reputeForbairt has a reputation beyond reputeForbairt has a reputation beyond reputeForbairt has a reputation beyond reputeForbairt has a reputation beyond reputeForbairt has a reputation beyond reputeForbairt has a reputation beyond reputeForbairt has a reputation beyond reputeForbairt has a reputation beyond reputeForbairt has a reputation beyond repute
Send a message via AIM to Forbairt Send a message via MSN to Forbairt Send a message via Yahoo to Forbairt Send a message via Skype™ to Forbairt
Default

Quote:
Originally Posted by jmcc View Post
The trick is maintaining a healthy balance between giving genuine users the info they want and blocking maggots.
Given the nature of this ... would requesting people sign up be that big an issue ?

Considering a lot of sites are charging for this type of information ... a simple sign up wouldn't be out of the question in my mind

(remember you posting that you weren't doing it as a commercial venture ... as such on boards)
__________________
Forbairt Media | Web Design & Development Galway / Dublin, Ireland - coming soon ... ( vague but descriptive isn't it )

Recent Work: Safari Club African Safari Holidays - Botswana Safaris
Reply With Quote
  #9 (permalink)  
Old 28-04-2008, 12:33 PM
jmcc's Avatar
Wannabe Geek
 
Join Date: Feb 2006
Posts: 277
jmcc has a spectacular aura about
Default

Quote:
Originally Posted by Forbairt View Post
Given the nature of this ... would requesting people sign up be that big an issue ?
It would be an extra layer of complexity. What I want to do is to make it as simple as possible to implement and run.

Quote:
Considering a lot of sites are charging for this type of information ... a simple sign up wouldn't be out of the question in my mind
Possibly but only for the more intricate information. Sessions, users, authentication in php scares me.

Quote:
(remember you posting that you weren't doing it as a commercial venture ... as such on boards)
I'm trying to remember writing that.

Regards...jmcc
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump

LinkBacks (?)
LinkBack to this Thread: http://www.irishwebmasterforum.com/cms-and-content-management/5485-best-navigation-architecture-for-domain-database.html
Posted By For Type Date
Issue On Domain Hosting: (Cash Gifting.. Vodien Launches Domain Name.. » Host News . biz This thread Pingback 27-04-2008 07:22 PM

Similar Threads
Thread Thread Starter Forum Replies Last Post
Connecting to 2 Mysql database in the same script?? Ciarán Mc Cann Coding Help 11 24-07-2007 10:21 AM
Restoring a database JamesA Forum Management 4 04-02-2007 10:40 PM
recomend IP to Alpha2 and dialing code database Frodo Webmaster Discussion 2 27-01-2007 02:40 PM
How many scripts on one database? ButtermilkJack Webmaster Discussion 4 17-04-2006 02:13 PM


All times are GMT +1. The time now is 02:03 AM.


Powered by: vBulletin Version 3.7.2, Copyright ©2000 - 2008, Jelsoft Enterprises Limited.

Search Engine Friendly URLs by vBSEO 3.2.0

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56