Skip to main content

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

Image
By
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

Labels:

Comments

Post a Comment

Popular posts from this blog

SharePoint RPC Protocols Examples Using OWSSVR.DLL

By
What is SharePoint RPC Protocols? Part 1 This reference includes information about the methods and usage of SharePoint Foundation Remote Procedure Call (RPC) protocol. This protocol can be used in Win32-based applications or in ASPX applications to make HTTP POST requests to the server. Methods in this protocol that do not modify the contents of the database can also be used in URL protocol to make HTTP GET requests. Definition taken from http://msdn.microsoft.com/en-us/library/ms448359.aspx You will find the OWSSVR.DLL in SharePoint 2010 Server Physical Path: C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\ISAPI and MOSS C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\ISAPI OWSSVR.DLL List of commands DialogView  Display ExportList GetProjSchema GetUsageBlob HitCounter RenderView To read more about the OWSSVR.DLL command Please read the URL Protocol from Microsoft Blog having a URL http://msdn.microsoft.com/en...
1 comment
Read more

SharePoint 2013 CTX variable and its function part 1

By
In this post going to show you some of the useful Utility Functions that might be useful for you while working with search display template. I used most of the functions MSDN Link: https://msdn.microsoft.com/EN-US/library/office/dn768285.aspx CTX Function Part 2   CTX Function Part 3 CTX: In Display template CTX variable is responsible for returning the all the managed properties and other DOM elements. Utility Functions String Functions: For checking Null, Undefined & empty values  Srch.U.w(str): Indicates whether the given string is null, undefined, or empty. $isNull(str): Checking for Null Srch.U.n(str): Indicates whether the given object is null or undefined. $isEmptyString(str) : Checking for an empty string Srch.U.e(str): Indicates whether the string is null or empty. Array Functions: Split & other array related operations Srch.U.getArray(property): Splits the string into an array of strings using the semi colon (";") as a s...
Post a Comment
Read more

Send Email using SharePoint Rest API

By
We have a requirement to send email vai SharePoint Rest API. We dig and find the below solution to send email using SharePoint API. Point Must be remember End point " /_api/SP.Utilities.Utility.SendEmail " end point to send email.  In JSON __metadata we used the type " SP.Utilities.EmailProperties ". The User / Group must have a read permission for particular site. where we placed this site code. JS Dependency  JQuery Code URL:  https://gist.github.com/BasantPandey/05189832546f2c6cc0bd008fcfec3264#file-sharepointsendemail-js Code  var Email = function (){ // Email Either email groupname or email address var from = ' abc.yahoo.com ' , to = ' abc.yahoo.com ' , cc = ' abc.yahoo.com ' , subject = ' My Email Subject ' ; this . options = this . options || {}; this . options [ ' fromEmail ' ] = this . options [ ' fromEmail ' ] || {}; this . options [ ' toEmail ...
Post a Comment
Read more