SQL, NoSQL, Disk Images, Data Streams and Other Non-File Data


SQL, including on Azure and AWS, for Non-Programmers

dtSearch UK Database Indexer extends dtSearch’s “off the shelf” no-programming-required terabyte indexer to SQL, including on Azure and AWS.

  • An independent company from dtSearch Corp., dtSearch UK distributes the dtSearch product line in the UK and more broadly in Europe and also develops and markets add-on dtSearch productsl
  • dtSearch UK’s Database Indexer add-on extends the reach of dtSearch’s “off the shelf” Windows products to enable SQL indexing with no programming required.
  • The SQL data can be local or remote, including on Azure or AWS.
  • After indexing with dtSearch UK’s Database Indexer, dtSearch’s existing “off the shelf” products can search across the entire SQL database, or just across specific SQL metadata fields. More information
  • A 30-day evaluation version of the Database Indexer is also available from dtSearch UK.

SharePoint

The dtSearch product line can index SharePoint data in three ways:

  • First, using the dtSearch Spider (available as an"off the shelf" component in dtSearch Desktop/Network/Web). Note: some authenticated SharePoint content may require API access.
  • Second, through a .NET Spider API for dtSearch Engine developers. More information
  • Third, also for developers, through the dtSearch Engine DataSource API.
    CodeProject:  dtSearch’s "DataSource API for indexing SharePoint Site Collections"     CodeProject:  dtSearch’s "DataSource API for indexing SharePoint Site Collections"
    • A new CodeProject article demonstrates DataSource API C# indexing using the SharePoint server API.
    • Additional sample C# code demonstrating how to use the DataSource API to connect with the SharePoint client API. More information

Faceted Search

  • Faceted search is an option for classifying data at the user interface level. Using faceted search, the end-user can “drill down” through various topics to hone in on the correct topical subset prior to performing a search.
  • The dtSearch Engine offers APIs to implement faceted search.
  • CodeProject also has two articles on faceted search and the dtSearch Engine.

Additional API Options for Data Classification

Crossing the Full-Text Search / Fielded Data Divide from a Development Perspective (PDF) Crossing the Full-Text Search / Fielded Data Divide from a Development Perspective (PDF)
  • While faceted search typically operates at the user interface level, the dtSearch Engine also offers additional options for data classification for filtering data prior to search results delivery.
  • A wide range of API filters and objects can categorize documents and other data via full-text document contents, document metadata content, backend database content, or data attributes attached during document indexing.
  • For example, search filter objects work in conjunction with end-user query dialects to allow multiple users with different security classifications to search the same document collection, without having to maintain separate indexes corresponding to each classification level.
  • A single query can include an “exact phrase” full-text end-user search request; second-level Boolean search expressions (such as one or more field or metadata search criteria); and developer-added filtering expressions (such as a filtering expression to filter out documents that do not match a user’s security classification).
  • For more information on database indexing, adding metadata "on the fly" while indexing, API-driven sorting and relevancy-ranking options, and displaying a synopsis or other metadata in search results, see the Databases and Field Searching topic and the Displaying Search Results topics in Selected Articles by Subject.