SharePoint 2013 Search Database Part 2 (Link Database & Analytic Database)

Link Database:  This database store analyzes content that is being crawled and added to the search index. The usage information means the user actions or usage events, such as click or viewed items on a SharePoint Site. Link database Stores information extracted by the content processing component and search click information. Store the information based on the click also store the search reports.

1. MSSConfiguration
2. MSSOrdinal
3. MSSQLogO14PageClick
4. MSSQLogPageClick : Query suggestions are automatically generated for a query when users click a result for that same query at least 6 times. Users’ clicks on results are logged and entry pairs of (query, result) are added to the Analytics Link Store DB, specifically to the MSSQLogPageClick table.
5. MSSQLogPageImpressionBlock
6. MSSQLogPageImpressionQuery
7. MSSQLogPageImpressionQueryRule
8. MSSQLogPageImpressionResult
9. MSSQLogPageImpressionResultTemp
10. MSSQLogPageImpressionResultUnprocessed
11. MSSQLogResultDocs
12. MSSQLogResultDocsTemp
13. MSSQLogResultDocsUnprocessed
14. MSSQLogResultNewDocsTemp
15. MSSSearchAlertsDocumentInfo
16. MSSSearchAnalytics
17. MSSSearchAnalyticsTimestamps
18. Versions

Analytic Database:This database mainly used for reporting prospective. The analytic database store information that is feed during the analytic processing.

Analytic processing information store like usage information i.e. analyzes user actions, or usage events, such as clicks or viewed items, on the SharePoint site. Usage analytic combines this information with information about crawled content from the Search analyses, and processes the information. Information about recommendations and usage events is added to the search index. 
These analyses are done by timer jobs that are responsible for performing analysis lifecycle tasks such as starting, stopping, pausing, and resuming an analysis job when requested. You can manipulate these timer jobs through the Microsoft.Office.Server.Search.Analytics namespace.

1. AnalyticsItemData: The analysis calculates both recent events and all time events, for all defined event types. By default, recent events is set to the last 14 days, but you can set it between 1 and 14 days (on-premises). The statistics data is aggregated on site level, on site collection level, and on tenant level (SPO).
2. DataRange
3. MSSConfiguration
4. MSSOrdinal
5. PendingDelete
6. RecsItemData
7. ScaleOutLog
8. SearchReportsData: this table used to display the search report. 
9. TenantSettings
10. Versions


Popular posts from this blog

SharePoint RPC Protocols Examples Using OWSSVR.DLL

STS CryptographicException Error : Key set does not exist

Query suggestions in SP 2013 Using Rest API (/_api/search/suggest)