When to use a database, SharePoint, or wiki.

"My client asked me to come up with a presentation of whether to use to Sharepoint or Wiki or both and how. Our team is an international team with members in New York, Singapore and London. Currently we have a wiki and Sharepoint set up but there is no clear guide/structure of how or when to use each."
 
This describes how databases, SharePoint, and Wikis should operate. Real life varies. Always remember that we're building processes, not temples.
 
A database stores structured data. The structure is typically designed and owned by an individual. Politically, it's a dictatorship. Line-of-business applications which gather and distribute raw data are typically associated with databases.
 
SharePoint provides webs to store lists and documents. Think of this as loosely-structured data. SharePoint lets you control this data with versioning, backup and recovery, workflow, security, policies and auditing. The structure might be seeded by an individual, but ownership is distributed. SharePoint should be designed to unfold according to to will of the distributed owners. Politically, SharePoint provides representative leadership like a parliamentary system though the leaders are typically appointed rather than elected. SharePoint is used by "information workers" to create, manage, and publish information typically stored in lists and documents. SharePoint is used as an interface to databases. SharePoint is a social tool used to recognize and reinforce relationships among people. Through either SharePoint's business intelligence capabilities or its integration with Reporting Services, SharePoint can report on data from structured and loosely structured data stores. SharePoint can index and provide search for structures, loosely structured, and unstructured data stores.
 
A wiki provides webs to store text with embedded references to media. This is unstructured data. Wiki content can be seeded with the intention to unfold acording to some master design, but politically, it's anarchy. A wiki allow control through versioning and moderation. A wiki is well-suited for collaborative documentation.
 
Cheers,
-Eli.
 
Published Friday, September 07, 2007 11:25 AM by erobillard

Comments

Friday, September 07, 2007 1:53 PM by Vikram

# re: When to use a database, SharePoint, or wiki.

Thanks that was helpful

Sunday, September 09, 2007 10:15 AM by phat shantz

# re: When to use a database, SharePoint, or wiki.

Definitions are not the problem.  Politics and management are the problem.  We all have a pretty good grasp on what these things are.  More than not, the popularity or novelty of a product drives a teams implementation of information-sharing tool.

Rather than a "Butterfly Collection" presentation, why not give us your professional expertise on "when" one product is superior to another, and "how" it effectively addresses remote (or even geo-close) team dynamics.

In my experience, developers are far more technical, but are far more apt to start blind.  Managers are lost (from start to end).  And the priesthood (whatever legacy intellectual archipelago a new application is supposed to automate) is unwilling or unable to fully share the inner secrets that secure enterprise primacy.

The three tools you mention for information store and retrieval are pretty well known.  None are shiny and new.  But they are still "thrown" at the development team like leg-irons thrown at the fleeing fugitive.  "Put these on so you don't run."

All tools are weapons.  All weapons are tools.  When are these tools weapons (used for the detriment of the team) and when are they tools (benefiting and extending the normal physical and cognitive abilities of the group)?

You're the expert.  You've got the blog.  You've got the spotlight.  Show some brilliance.

Sunday, September 09, 2007 8:18 PM by Links (9/9/2007) « Steve Pietrek’s SharePoint Stuff

# Links (9/9/2007) « Steve Pietrek’s SharePoint Stuff

Pingback from  Links (9/9/2007) « Steve Pietrek’s SharePoint Stuff

Thursday, September 13, 2007 9:55 AM by Drew Mace

# re: When to use a database, SharePoint, or wiki.

SharePoint Tips and Tricks

Monday, September 17, 2007 2:44 AM by Blog del CIIN

# WSS 3.0 & MOSS: Recopilación de enlaces interesantes (VII)

Retomando el clásico recopilatorio de recursos y enlaces que sobre WSS 3.0 & MOSS venimos realizando

Friday, September 21, 2007 9:57 AM by MOSS.... et moi....

# Quand utiliser une DB, un SharePoint ou un wiki ?

Eli Robillard propose ici sa vision des faits. Je suis assez d'accord avec lui et je profite de l'occasion

Thursday, October 21, 2010 12:01 PM by links for 2010-10-21 « An Engineer’s God

# links for 2010-10-21 « An Engineer’s God

Pingback from  links for 2010-10-21 « An Engineer’s God

Sunday, July 08, 2012 12:04 PM by Database sharepoint | Princeofmischi

# Database sharepoint | Princeofmischi

Pingback from  Database sharepoint | Princeofmischi