http://blogs.msdn.com/b/spses/archive/2010/12/23/social-computing-part-1-overview.aspx
There are many existing components in market, which is grouped together for Social Computing.
· My Sites
· Blogs
· Wikis
· RSS Feed
2. Socially-Enhanced information management.
Below is an example of how user information converts into social data.
User Data

Social Computing

Timer Job Roles:
SharePoint Social Computing is largely a Timer Job driven process. Behind these Jobs there are new databases and a series of tables involved. The below table lists all the timer jobs that influence Social Computing. The Jobs are prefixed with the name of their User Profile Application (UPA).
| Timer Job Name |
Timer Job jobs |
| My Site Cleanup Job |
Handles the deletion of user profiles and My Sites of those users. |
| Activity Feed Cleanup Job |
Cleans up pre-computed activities used in activity feeds which are older than 14 days. This job does not affect the User Profile Change Log. Daily by default. |
| Activity Feed Job |
Pre-computes activities shown in the user’s activity feeds. Hourly by default. |
| My Site Suggestions Email Job |
Sends out emails with colleague and keyword suggestions to people who don’t update their profiles often, prompt them to update their profiles. Monthly on the 15th. |
| Social Data Maintenance Job |
Aggregate the social tags and ratings and cleans up the Social data change log. Every hour. |
| Social Rating Synchronization Job |
Timer job to synchronize rating values between Social database and content database. Hourly. |
| System Job to Manage User Profile Synchronization |
Timer job manages provision, run sets and additional tasks related to user profile synchronization. Do not change the information or frequency of this job. If you need to change how often incremental synchronization is done, access the user interface through the User profile service admin page, and click on the schedule incremental user profile synchronization link under the synchronization category. Every minute. |
| User Profile Change Cleanup Job |
Cleans up data which is 14 days old from the User Profile Change Log. Daily by default. |
| User Profile Change Job |
Processes changes to the user profile. Hourly by default. |
| User Profile Incremental Synchronization |
Timer job will run at the specific interval to synchronize user, group, and group membership changes between the user profile application and specified directory sources such as AD or LDAP. Synchronization will look for changes since the last time this job was run and only perform these changes for AD and LDAP Sources. Daily by default. |
| User Profile Language Synchronization Job |
Looks for new language pack installation and makes sure that strings related to user profile service are localized properly. |
| User Profile to SharePoint Full Synchronization |
Synchronizes user information from the user profile application to SharePoint user and synchronizes site memberships from SharePoint to the user profile application. Hourly by default. |
| User Profile to SharePoint Quick Synchronization |
Synchronizes user information from the user profile application to SharePoint users recently added to a site. This is set to run every 5 minutes by default. This updates the ProfileSweep table Change Token. |
Other notable features:
· MySite
· Colleagues mined from your Outlook e-mail and Communicator ‘buddies’ will automatically be suggested to you.
· You can rate sites for relevance/usefulness.
http://blogs.msdn.com/b/spses/archive/2010/12/23/social-computing-part-2-user-profile-application-overview.aspx
Manage User Profiles:
Once user profiles imported from AD, it get stored in [Profile DB]; the following query will help you to get the list of property value of a particular user.
USE [Profile DB]
SELECT upf.NTName, pl.PropertyName, upv.PropertyVal FROM UserProfile_Full upf WITH(NOLOCK)
JOIN userProfileValue upv ON upv.RecordID = upf.RecordID
JOIN PropertyList pl ON pl.PropertyID = upv.PropertyID
WHERE upf.NTName = ‘Domain\alias’
select * from UserProfile_Full
select * from UserProfileValue
select * from PropertyList
Timer Jobs:
User Profile Change Job:
Whenever there is a change in user profile, either thru Central Administration->User Profile Application->Manage User Profiles or AD import there will be a changelog entry added into UserProfileEventLog table. Newly added entries will be processed thru this timer job. The “User Profile Change Job” has been scheduled for every hour.
User Profile Change Cleanup Job:
This job has been scheduled for Daily; it will clean up 14 days old data from UserProfileEventLog table.
User Profile Incremental Synchronization:
This job is to synchronize the new and updated Users, groups and group membership from AD, incremental sync will synchronize only the newly created or updated data.
User Profile to SharePoint Full Synchronization:
This job is to synchronize the user information from UPA to SharePoint sites, scheduled hourly by default.
User Profile to SharePoint Quick Synchronization:
This job is to synchronize the user information from UPA to SharePoint sites, it scheduled for every 5 minutes, it updates ProfileSweep table change token.