WIKI Using ASP.NET

1
WIKI Using ASP.NET

Mohamed Askar

Masters Report

June 17 th 2005
2
Overview

• Wiki Definition
• System Architecture
• Database Design
• Features of Wiki
• Control Flow
• Demo
• Software Architecture
• Testing
• Lessons Learnt
• Conclusion
• Future Work

3
Wiki Definition

• Simplest online database that could possibly
  work.
• User can edit the content of the page.
• Helps to keep the content of the web page
• up to date.

4
Wiki History

• Ward Cunningham founded the first wiki site on
  March 25 1995.
• Portland Pattern Repository was the first wiki
  site.
• Wiki Wiki is a Hawaiian term , meaning quick.
• Wiki encyclopedia is available on the internet.

5
Wiki Advantages

• Used as Collaborations tools.
• Used as Personal Information Managers.
• Needs only a web browser.
• Wiki provides a two way communication channel.

6
Wiki Disadvantages

• Wiki causes security risk since anyone can edit
  any page.
• Lack of WYSIWYG editor.

7
Objectives

• Building a Wiki using a Asp. Net and C.
• Adding some extra features in the wiki.
• - Mixing images with text.
• - File Handling Features.
• - Electronic mail Notification.
• - Search Feature.

8
Target Audience

• Used in the intranet.
• Can be modified as a public site.

9
System Architecture
10
Technologies Used

• HTML
• - Hypertext Markup Language.
• - Markup tags.
• - WYSIWYG editor.
• C
• - Object Oriented Programming.
• - Designed to work with .NET.
• - Uses XML and SOAP.

11
Technologies Used

• Microsoft Visual Studio .NET.
• - Common environment for building,
  deploying
• and running web application.
• - It is language-neutral.
• - Easy deployment.
• - User authentication.
• - Compiled Code.
• - Compatibility.

12
Technologies Used

• Oracle 10g.
• - Robust and web-enabled.
• - Scalable.
• - Manage the multimedia content
  directly.
• - Oracle Data Guard.
• - Data Mining.
• - Multi Platform.

13
Database Design
14
Functionalities

• Creation of new topic
• - Create a new link.
• Editing the existing topics
• - Using the editing tips.
• Electronic mail Notification to the user
• - Simple Mail Transfer Protocol.

15
Functionalities - Cont

• Adding images to the web pages
• - Resize the images.
• - Link an URL to an image.
• - Place the image at the desired
  position.
• Creating links to an uploaded file
• - List of uploaded files can be seen.
• .

16
Functionalities - Cont

• Revision Control
• - Previous version is stored in the
  database.
• - History pages to retrieve the
  previous version.
• Viewing Recent Changes
• - No of days.
• - Author and last updated time.

17
Functionalities - Cont

• Search Feature
• - Keyword Search.
• - Topic Search.
• File Manager
• - Uploading images and files to
  database.
• - Renaming and deleting a file.
• - Viewing the file.

18
Functionalities - Cont

• Simple Editing Tips
• - Create Headings.
• - Bullet and Numbered list.
• - Bold, italic and underlined.
• - Web link and mailto link.
• - Indentation.
• - Create link to a new topic.
• - Horizontal rule.

19
Control Flow
20
Demo
21
(No Transcript)
22
(No Transcript)
23
Testing Microsoft Application Test Center

• Performance Testing.
• Simulates several users.
• Tests results confirmed that there was no HTTP,
  DNS or Socket errors.
• No connection or timeout errors.

24
Test Results
25
Load Testing Ants Load

• Load Testing.
• Finds the fastest and the slowest objects in the
  web application.
• Time to connect was less than 50 milliseconds
  most of the time.

26
Test Results
27
Test Results
28
Statistics

• Total number of source code
• - 2000 lines of C code.
• - 500 lines of HTML code.
• - 12 aspx pages.
• - 15 Oracle Procedures.
• - 3 triggers and sequences.
• - Style sheet.

29
Statistics

• Design 20
• Coding 40
• Debugging 10
• Testing 15
• Documentation 15

30
Lessons Learned

• How to convert plain text to an HTML output.
• Storing and retrieving images and files from the
  database.
• Resizing of images.

31
Lessons Learned

• Using the SMTP protocol to send electronic mails.
• How to use Procedures and Packages to retrieve
  data from the database.
• .NET Testing Tools.

32
Conclusion

• Advantages of using Asp.net for building Wiki.
• Motivation For building Wiki.
• Wiki will provide a flexible, powerful and easy
  to use collaboration platform.

33
Future Work

• Wiki causes security risk since anyone can edit
  any page.
• One Solution is by defining groups and imposing
  read and write access restrictions based on the
  groups and users.
• Create statistics of the wiki webs.

34
References

• http//www.w3schools.com
• http//www.imano.com/content/oracle9i.aspx
• http//msdn.microsoft.com
• http//www.red-gate.com
• http//wiki.org/wiki.cgi?WhatIsWiki
• Nikhil Kothari and Vandana Datya. (2002).
  ASP.NET Server Controls and Components,
  Microsoft.

35
Acknowledgements

• Dr. Daniel Andresen (Major Professor)
• Dr. Mitchell Neilsen
• Dr. Bill Hankley

36
Questions ?