Understanding Sharepoint 2007 Database Structure

SharePoint 2007 is a portal application with a high flexibility. How the basic structure of the database? Let's see ...

Microsoft SharePoint 2007 applications that can be said to be a very good example in building a web-based application. With a flexible design of the portal on the SharePoint 2007, it is not surprising that many people choose to switch to SharePoint or affairs for the web portal

One indicator of a good application to the design of the database. If the database structure that is made regular and very futuristic, the application can be good even though this will not always depend on how the implementation of the application and how mengonsumsi database. SharePoint 2007 database can be designed so that the support for personalization so that more lives will be portalnya applications.

At the time this article push to point on how the structure of the database sSharePoint 2007. Microsoft itself is not the official to give details about the structure of the database so that SharePoint is often said Undocumented. Not all of the database structure we will study here and we'll see tables and data that are frequently used in SharePoint.

Configuration Database

In general, the SharePoint 2007 database can be divided into three parts, namely:
• Core Configuration
• Web Farm
• Global Tables

Following explanation:

Core Configuration

From the name, it is core, which means that the information in it is very important. At the core configuration contains important information SharePoint 2007, including:
• Virtual Server
• Sites
• Database

Core configuration we can see that the database is usually named SharePoint_Config, for we can certainly see it on the SharePoint Central Administration portal. Virtual Server server farm contains information on the SharePoint Server. Each virtual server will have many databases in it. Each database will have a lot of this site in it. Each database will have a lot of this site in it. All this information can be obtained on the table Virtual Servers, Databases, and Sites.

Web Farm

Farm contains a web server and service that are served. A server can be host to the multi-service (web and database). Each virtual server can serve a multi-server. Meanwhile, virtua IIS server ID in SharePoint have any ID in the registry.

Global Data

Global data is data that contains general information about SharePoint. This data includes:
• Globals (farm-wide configuration)
• Anti Virus Vendors
• Custom Templates
• Web Part Packages
• Web Part Packages installed

All the above data are stored in the database. Meanwhile, general information on the database or SharePoint globals can include:
• Core content
• Web part
• Alerts
• Security
• Doc management
• Web management
• Global table

At the core content, we will see all the data that is used on a site. Each site will have a database and the database name is usually preceded by the name WSS_Content_XXXX

SharePoint 2007 Site Database

As we know, the SharePoint application seen by the client is called and each SharePoint site SharePoint site will have a database that begins with the name WSS_Content_XXX the information in it can include the following:
• Sites
• Webs
• Docs
• Lists
• User Data

Sites in the table contains information on the site as the URL of the site owner to use, quotas imposed on the site, search optimization.

Sites other than the table, there is also the Webs table contains information on the web such as frontpage, theme, navigation, and so forth.

Docs on the SharePoint site can be said that this data is one of the frequently used data. All the documents we upload to SharePoint document libraries will be stored in the data this docs. Data stored in the docs table AllDocs. This table provides information AllDocs directory name, quota, status Check in / out, to remove the trigger and so on.

No less important is also the table AllUserData give all the information data with various types of data content used by the user. Meanwhile, the information list of the SharePoint site can be found in the table AllLists. Information provided such as a name list, type the list, the available field, ACL, event handler, e-mail, etc
Information system security SharePoint

SharePoint 2007 also stores all information into the database used sekuritiyang SharePoint Site information is stored, among others:
• User info
• Web Members
• Web Groups
• Site Groups

User info contains information about the user-user applications that use SharePoint, especially for the SharePoint Site. Here also provides information on the admin user. Data stored as user name, e-mail, and system ID (NT User Token ID) All this information is stored in the SharePoint Site database, the table called UserInfo.
Web members provide information about the mapping between the user and the web and Token STS. Meanwhile, Web Site Groups and Groups to provide information about users and NT group.

WebParts

As we know, SharePoint in 2007 also have webparts. Are available and active SharePoint webparts on the Site can be obtained through the WebParts table and WebPartList. To find out who installed WebParts based on site and can be seen in the page table WebPartList

Alert

SharePoint 2007 application is also provided which alerts the system can provide notification of something, eg we ask SharePoint to provide alerts to send e-mail any document that is edited or new documents into a specific folder. For information Alert, SharePoint saves the information into several tables, namely:
• EventBatches
• EventCache
• EventLog
• EventReceivers
• EventSubsMatches
• ImmedSubscriptions
• SchedSubscriptions.

thanks to the Blog:
http://turnoncomputer.blogspot.com

regards,
raju