Topic: How can Google search my database

I have created RoR application with a database.

When a surfer searches Google. I would like that Google will search my application database.

What should I do to make this happened?

Re: How can Google search my database

every item in your database must be retrievable via a link (<a http://... etc) or a sequence of links from the domain home page

Re: How can Google search my database

I am not sure I understand you.

Suppose I have 50 rows in Employee table which I want to reveal to Google or other search engines. What should I do?

Re: How can Google search my database

Generate an xml site map.

Google Generate rails site map

Re: How can Google search my database

for each of the 50 rows in the employee table, the row must be retrievable by a link, or a series of links from the home page.

Re: How can Google search my database

I will appreciate if you can give me an example of how such href looks.
Thanks

Re: How can Google search my database

Here, this might help your brain do as suggested.

http://tinyurl.com/ye2ahkc

Re: How can Google search my database

The sitemap is a good plan, but it will not work unless there are links to the records somewhere in the site.

In Rails, you make a link to a record like this:

<%= link_to @employee.name, employee_path(@employee) %>

Re: How can Google search my database

Ok, I read the recommended sites, learned a lot (yet not enough) and prepared my sitemap.xml that includes for example

<url>
  <loc>http://localhost:3000/doctors/6</loc>
  <lastmod>2009-10-24T16:58:27+00:00</lastmod>
  <changefreq>weekly</changefreq>
  <priority>0.7</priority>
  </url>

Does the above means that google will somehow activate the URLs and will keep their information in its databases so that upon searching their content google will display the relevant URL as the search result?.
And in simple question, suppose I keep data such as "Mark is a dentist for 20 years" on doctors row id 6, and I search such data, will it  be found by google?

And another question: is it better from SEO perception, to add a meaning full string to the url. like for example
loc>http://localhost:3000/doctors/6?doctor_title=dentist</loc>

Re: How can Google search my database

If there is a link (other than the sitemap) on the site homepage, or some other page linked to the home page, which is http://mydomain.com/doctors/6. And If clicking on that link produces an html page that contains the text "Mark is a dentist for 20 years" then Google will find it and index the text. Google knows nothing about databases, it just follows links.

Re: How can Google search my database

I think I miss something basic in understanding the whole issue.

I do not have a separate html page for each link.
"http://mydomain.com/doctors/6", "http://mydomain/doctors/5", etc  activates the show function of the doctors controller and of course I have view/doctors/show.html.erb file which displays the content of doctor with id 6/5/? from the database.


Is this enough? or should I create a static html page for each doctor?

And another question. You say that I must also have these links in my home page. Yet It does not fit my application. If I put them as hidden links would it be enough for google?

Re: How can Google search my database

Sorry, I'm not communicating very clearly...

1. You don't need a separate html page for each link, just a url. I think you have that. mydomain/doctors/5 satisfies that requirement. I imagine that the response to that url is an html page with a specific doctor's details, right? So "in effect", as far as the viewer (or search engine) is concerned, you appear to have a separate html page for each doctor, even though it's a single template in your application.

2. I didn't mean to suggest you must have a link to each doctor page on your home page, but you can alternatively have a link to another page that has the doctor page links. So for example, your home page navigation might have a link to the doctors/index page with the link text that says "Doctor list". Then on the doctor list page there might be a link for each doctor.

is that any clearer?

Re: How can Google search my database

Thanks. It is now clear.


So according to this google can crawl my dynamic data.

Does this means that google activates all the links in the sitemap, and keep their "static" results somewhere so he will be able to search them?

Why sitemap is not enough?

Re: How can Google search my database

Google can't distinguish dynamic and static data, it can see urls and it can see the html results that respond to each url.

If a sitemap contains all the links to your dynamic data, then of course that is enough.

Re: How can Google search my database

Just pretend that google is some guy using his internet explorer to view websites. If you dont give him a place to see what you want him to, then he will never know about it. He only sees what the page(link) shows him AT THAT TIME.

A sitemap it self is not enough because it ONLY includes the links to the pages, so if there is no actual page, the guy(google) wont know what is actually on that page.

Google goes page by page recording what is on it and saving it for later retrieving via their search engine. They will periodically go back to the same page to see if there are updates.

Re: How can Google search my database

Google develops its own proprietary database and file system. Here is a good article that describes the origins of both:

Re: How can Google search my database

Google can't recognize dynamic and static data, it can see urls and it can consider the html results that react to each url.

Re: How can Google search my database

Google search your database easily with use of its crawler and robots..!!!

Re: How can Google search my database

Googlebot does not have direct access to your database, just the pages that are generated by server side code that pulls data from the database, such as ASP/PHP etc.
In order to ensure that these pages are spidered effectively, you need to take a crash course in basic Search Engine Optimisation, as this is the key to ensuring that Google and other spiders are able to index all your pages.

Make sure that you read the search engine's webmaster guidelines thoroughly before creating your site, think long and hard about navigation, and once built, create an XML sitemap and submit it to Google.

Then get some decent, on-theme links from related sites, and wait for the search engine spiders to find your site.