Google Enabled Table Search

Google provides two ways to upload your database table data to the cloud so that it can be queried like any other database query application on the Web.

Upload a spreadsheet of your data to a Google spreadsheet - and then do a query against that spreadsheet's query URL
Upload your data to Google Base - and then also do a query against that data's query URL

Table Storage Method 1 - Upload To A Google Spreadsheet

This is the simplest and works well for spreadsheet files up to 1MB (about 10,000 rows of data.) If you can get your data into a spreadsheet format, all you have to do is create a free Google account, then upload your spreadsheet to Google Docs where it is a spreadsheet there also.

Typically with only a couple consulting hours, the OTech Web Consulting Unit can assist you in implementing this type of solution.

* Here's an example of a Google spreadsheet query displayed on a Webpage.

Table Storage Method 2 - Upload To Google Base

This method takes a little more work and planning, but produceses a better long-term solution for: tables that are regularly updated and are very large (10,000 rows+). To leverage Google Base you must create your own "type" of data layout, and then upload as many files as is necessary to get your data up there (individual files typically must be less than 15MB in size, or around 100,000 rows or less).

Google Base allows for the following methods for updating your data there:

Schedule Google Base to regularly upload your data to Base
Manually upload your files
Manually update a single row of data using the Google Base web screen inteface
Write a program to update individual rows of data based upon updates from your transactional system

If you have enough technical experience, you can implement a Google Base solution yourself. If not, you can contact the OTech Web Consulting Unit and issue a request for consulting services to assist you with setting this up. For more information on everything needed to leverage Google Base go to: About Google Base

* Here's an example of a Google Base query displayed on a Webpage

Presenting Your Table Search Results on a Web Page

In order to present the results of your table query, you must use a script of some kind to present it on a Web page. As part of providing an OTech consulting solution, we will implement for you the various files needed to present the query results, including modifying the css to match your sites look and feel.