Skip to content
  • There are no suggestions because the search field is empty.

Database Variances

Understanding Search and Stop Word Differences Across Databases

Innoslate is compatible with both SQL and PostgreSQL databases.

While Innoslate supports multiple database backends, each handles full-text search and stop words slightly differently. The table below highlights these behavioral differences.

Search Behavior Example

To demonstrate these differences, we created four test entities:

Entity 1: Name = "Innoslate is an MBSE tool"
Entity 2: Number = "Innoslate is an MBSE tool"
Entity 3: Description = "Innoslate is an MBSE tool"
Entity 4: Number = I.1.12

Table illustrating search results across databases follows below

  Without Stop Words With Stop Words
  Microsoft SQL PostgreSQL Microsoft SQL PostgreSQL
Name:  
Name:is X X E E
Name:"is*" X X P X
Name:"is%" X X P X
Name:"%is%" X X X X
Name:"*is*" X X X X
Name:Innoslate X X X X
Name:Inn* X X X X
Name:Inn% X X X X
Name:_n* X X X X
Name:_n% X X X X
Name:"MB*" X X X X
Name:"MB%" X X X X
Name:"*MB*" X X X X
Name:"%MB%" X X X X
Name:"MBSE" X X X X
Name:"MBSE tool" X X X X
Name:"Innoslate is a MBSE tool" X X X X
Number:  
Number:2 X X X X
Number:2. X X X X
Number:2* X X * X
Number:2% X X * X
Number:is X X X X
Number:"is*" X X X X
Number:"is%" X X * X
Number:"*is*" X X X X
Number:"%is%" X X X X
Number:_.* X X X X
Number:_.% X X X X
Number:Innoslate X X X X
Number:Inn* X X X X
Number:Inn% X X X X
Number:_n* X X X X
Number:_n% X X X X
Number:"MB*" X X X X
Number:"MB%" X X X X
Number:"*MB*" X X X X
Number:"%MB%" X X X X
Number:"MBSE" ** X ** X
Number:"MBSE tool" ** X ** X
Number:"Innoslate is a MBSE tool" X X X X
Description:  
Description:is X X E E
Description:"is*" X X X X
Description:"is%" X X X X
Description:"*is*" X X X X
Description:"%is%" X X X X
Description:Innoslate X X X X
Description:Inn* X X X X
Description:Inn% X X X X
Description:*Inn* ** ** ** **
Description:%Inn% X X X X
Description:_n* ** X ** X
Description:_n% ** X ** X
Description:"MB*" X X X X
Description:"MB%" X X X X
Description:"*MB*" X X X X
Description:"%MB%" X X X X
Description:"MBSE" X X X X
Description:"MBSE tool" X X X X
Description:"Innoslate is a MBSE tool" X X X X
ALL:  
is X X E E
"is*" X X X X
"is%" X X X X
"*is*" X X X X
"%is%" X X X X
Innoslate X X X X
Inn* X X X X
Inn% X X X X
*Inn* ** ** ** **
%Inn% X X X X
_n* X X X X
_n% X X X X
"MB*" X X X X
"MB%" X X X X
"*MB*" X X X X
"%MB%" X X X X
MBSE X X X X
"MBSE" X X X X
"MBSE tool" X X X X
Innoslate is a MBSE tool X X X X
"Innoslate is a MBSE tool" X X X X
_.* X X X X
_.% X X X X
Innoslate is a MB* X X X X
Innoslate is a MB% X X X X
E: Stop word, so all results are true
P: Partial with words that start with word, but wont contain the stop words itself
* Give less than original version
** Invalid Searches