Lync Server 2013 中的持久聊天資料庫架構Persistent Chat database schema in Lync Server 2013


主題上次修改日期: 2012-09-18Topic Last Modified: 2012-09-18

這會在 Lync Server 2013 通訊軟體中記錄 Persistent Chat 資料庫的架構。This documents the schema of the Persistent Chat database in Lync Server 2013 communications software.

Persistent Chat 資料庫是指對應至 Lync Server 2013 後端伺服器角色的資料庫 PersistentChatStore (對應至 mgc 資料庫) 和 PersistentChatComplianceStore (對應于 mgccomp 資料庫) 。The Persistent Chat database refers to the database corresponding to the Lync Server 2013 Back End Server roles PersistentChatStore (corresponding to the mgc database) and PersistentChatComplianceStore (corresponding to the mgccomp database). 發行此結構描述的目標是讓您能夠建立查詢,並深入了解建立關於交談使用方式、作用中聊天室、前幾名的張貼者等實用報告的資訊。The goal of publishing this schema is to enable you to build queries and gain some insights into building useful reporting around chat usage, active rooms, top posters, and so on.


我們保留發展此結構描述的權利。Microsoft 不保證會維持此發行的結構描述之完整回溯相容性。We reserve the right to evolve this schema. Microsoft does not make any guarantees to maintain full backward compatibility with this published schema.

請遵循以下最佳做法:Follow these best practices:

  • *因為 column 清單可能會成長,所以不支援 SELECT//。No SELECT* // is supported because the column list can grow.

  • 不支援使用者產生的結構描述修改。No user-generated schema modifications are supported.

  • 不支援寫入作業。No write operations are supported.

  • 測試您在典型大小之資料庫上建立的任何查詢,以確定查詢可以在符合您需求的層級上執行。Test any queries that you build on representatively-sized databases to be sure that the queries can perform at a level to meet your needs.