Go中内存中引号的文本索引

实际上,最近我需要在字符串的开头实现搜索WHERE name LIKE '%'这是根据交换符号(AAPL,AMZN,EUR / USD等)的名称进行的搜索。我希望搜索能够快速进行,而不要再次加载数据库。结果,我进入了在内存中执行树搜索的过程,我将告诉您这一点。

55000 ( ). . , .

. , BTree, ( , ,  , trie), — . , .

. , .

.

, , . , , : 

  • AAA (BetaShares Australian High Interest Cash ETF, ASX), 

  • AAA (All Active Asset Capital LTD, LSE).

Index.Data , Index.Data AAA.

SearchIndex.Data . , .

, .

.

  1. .

  2. .

  3. .

  4. .

  5. , , ã → a.

  6. - ().

, — , .

, Index.Data .

. — Index.Children , ( — ). , AAPL, ( ):

[A], [A], [P], [L]. , . , .

, . , . , .

.

, — . .

  1. (. ).

  2. , . 

  3. .

, AA, :

  • AAL

  • AAALF

  • AAAP

  • AAB

  • AAP

  • AAPJ

  • AAPL

  • AAPT

, AA. .

WHERE name LIKE '%'. , , .

  • “EUR”, “EUR”, “EUR/USD”, “USD/EUR”. , .

  • , . , “APL”, “APL”, “AAPL” (Apple).

  • .

“EUR”, “EUR”, “EUR/USD”, “USD/EUR”, : . , “USD/EUR”, : “usd eur”, “eur”. “Grupo Financiero Galicia SA” “Grupo Financiero Galicia SA”, “Financiero Galicia SA”, “Galicia SA”, “SA”.

, 4 .

  1. .

  2. , .

  3. , .

  4. , .

, . .

  1. SearchSymbolIndex .

  2. SearchPopularIndex (10% ).

  3. SearchInstrumentIndex .

— .

var searchedData []searchindex.SearchData

searchedData = r.SearchSymbolIndex.Search(searchindex.SearchParams{
    Text: key,
    OutputSize: outputSize,
    Matching: searchsymbol.Strict,
})

searchedData = r.SearchPopularIndex.Search(searchindex.SearchParams{
    Text: key,
    OutputSize: outputSize,
    Matching: searchsymbol.Beginning,
    StartValues: searchedData,
})

searchedData = r.SearchSymbolIndex.Search(searchindex.SearchParams{
    Text: key,
    OutputSize: outputSize,
    Matching: searchindex.Beginning,
    StartValues: searchedData,
})

searchedData = r.SearchInstrumentIndex.Search(searchindex.SearchParams{
    Text: key,
    OutputSize: outputSize,
    Matching: searchindex.Beginning,
    StartValues: searchedData,
})

StartValues — , , , , , (OutputSize).

searchindex.Strict —  . 

searchindex.Beginning — .

, . 300 . , .

, 55000 2 , . 4 100-200 ( http ), .

此搜索当前在开发人员的财务API中使用,可以在此页面查看示例,在此示例中可以进行尝试。




All Articles