Google API to make text search into database

SQL Apprentice QuestionI'd like to know if it's possible to use Google APIs to make a text
search into DBs such Oracle or Sql Server.

The trend, certainly within the Microsoft space is to use SQL to query
non-structred data that offers a standard language people can use, most
developers know SQL which is why they have taken that direction, you may
also want to google the LINQ project which is even more exciting.

SQL is quite definitely not and should not imho be limited to query
relational data as definied by a 'rdbms'.


As somebody who supports standards I would have thought you'd appreciate the
'standard' interface to 'data' be it relational or non-structured.


Celko Answers
Do not use SQL for text and document searching; get a tool built for
this job. If you are doing this only once, then yhou can use whatever
your RDBMS product has for strings.

>> The trend, certainly within the Microsoft space is to use SQL to query non-structured data that offers a standard language people can use, most developers know SQL which is why they have taken that direction ..<<


I would say that Microsoft is trying to lock people into their products
and their proprietary tools, not a love of standards.

The developers who work with text are not SQL programmers; they have a
whole different mindset. Our mindset is strongly valued logic and
syntax rules; they have fuzzy logics and semantics. Knowledge
management journals are nothings like TODS and SigMod journals. Etc.



>> SQL is quite definitely not and should not imho be limited to query relational data as defined by a 'rdbms'. <<


What else should a *RELATIONAL DATA base system" do besides , well,
relational data? List processing? Symbolic Algebra? Semantic info
processing? Graph structures? Chop tomatoes? The Swiss Army Knife
school of software!


>> As somebody who supports standards I would have thought you'd appreciate the 'standard' interface to 'data' be it relational or non-structured. <<


I do. The de jure standards for text searching were set up by NISO,
and the de facto ones by Lexus, Nexis, WestLaw and Google.