Web Store SQL Searches

[This is preliminary documentation and subject to change.]

The Web Store is a vast storage of resources in a single infrastructure. There are search capabilities to locate specific items or create views of resource data. Querying the Web Store is based on a familiar SQL syntax, primarily based on DAV:SQL, with unique capabilities because of the use of URLs as the data source.

With a store as vast as a Web Store, one must consider how to manage an overload of data from a search of all items. You can, of course, provide explicit properties to retrieve and a WHERE clause to refine your search. Another powerful way is to use content-classes.

Content classes loosely define types of content in Web Stores in terms of the expected properties stored along with instances of each resource. Content-classes define the set of properties returned by SQL SELECT * commands on folders that have such as class as an expected content class.

SQL queries return ADO Record or Recordset objects of Web Store property information. WebDAV converts the SQL queries into XML elements and methods for conducting the search.