Download - CS 491B Project
![Page 1: CS 491B Project](https://reader033.vdocuments.us/reader033/viewer/2022051000/56813b5c550346895da4541e/html5/thumbnails/1.jpg)
CS 491B Project
Web Galaxy
Wendy Tan
![Page 2: CS 491B Project](https://reader033.vdocuments.us/reader033/viewer/2022051000/56813b5c550346895da4541e/html5/thumbnails/2.jpg)
Web GalaxyProject IntroductionDemoAnalysis
![Page 3: CS 491B Project](https://reader033.vdocuments.us/reader033/viewer/2022051000/56813b5c550346895da4541e/html5/thumbnails/3.jpg)
Project IntroductionE-commerce Web Site in three setupsContent
Product Display by product categoryProduct SearchShopping Cart
![Page 4: CS 491B Project](https://reader033.vdocuments.us/reader033/viewer/2022051000/56813b5c550346895da4541e/html5/thumbnails/4.jpg)
Three SetupsRed Hat Linux
Apache 1.3
MySQL
MOD_PERLMason
Window 2000
IIS 5.0
SQL 2000
C# ASP.NET
Window 2000
Apache Tomcat
MySQL
JSP/Servlet
![Page 5: CS 491B Project](https://reader033.vdocuments.us/reader033/viewer/2022051000/56813b5c550346895da4541e/html5/thumbnails/5.jpg)
MotivationCurious about different choices of web server setup and server-side languagesHave done similar web programming project for CS 437, want to try something new PERL/MySQL/Apache/JavascriptYears of work experience in web site development
![Page 6: CS 491B Project](https://reader033.vdocuments.us/reader033/viewer/2022051000/56813b5c550346895da4541e/html5/thumbnails/6.jpg)
HardwarePentium III 700 MHZ128 MB RAM12 GB Hard drive
![Page 7: CS 491B Project](https://reader033.vdocuments.us/reader033/viewer/2022051000/56813b5c550346895da4541e/html5/thumbnails/7.jpg)
DemoSetup 2 – written in C#Setup 3 – written in JSP/Servlets
![Page 8: CS 491B Project](https://reader033.vdocuments.us/reader033/viewer/2022051000/56813b5c550346895da4541e/html5/thumbnails/8.jpg)
AnalysisDatabase comparison (Emphasis)Language comparisonWeb Server comparisonPerformance Chart of Setup 2 and Setup 3
![Page 9: CS 491B Project](https://reader033.vdocuments.us/reader033/viewer/2022051000/56813b5c550346895da4541e/html5/thumbnails/9.jpg)
Database ComparisonHardwareOperating SystemPriceFeatureConclusion
![Page 10: CS 491B Project](https://reader033.vdocuments.us/reader033/viewer/2022051000/56813b5c550346895da4541e/html5/thumbnails/10.jpg)
Database HardwareSQL 2000 MySQL
Pentium 166 MHz or higher
128 MB RAM or more
recommended
270 MB hard disk
(full installation)
Should have at least 32
MB RAM and at least
60 MB hard disk
![Page 11: CS 491B Project](https://reader033.vdocuments.us/reader033/viewer/2022051000/56813b5c550346895da4541e/html5/thumbnails/11.jpg)
Database Operating System
SQL 2000 MySQL
Windows-based Windows-based
Sun Solaris; FreeBSD
Mac OS X; HP-UX
AIX-Based; QNX
SGI Irix; Dec OSF
![Page 12: CS 491B Project](https://reader033.vdocuments.us/reader033/viewer/2022051000/56813b5c550346895da4541e/html5/thumbnails/12.jpg)
Database PriceSQL 2000 MySQL
Standard Edition
$4,999 per processor
Enterprise Edition
$19,999 per processor
Free under the terms of
the GNU General Public
License.
$495 per copy (1-9)
![Page 13: CS 491B Project](https://reader033.vdocuments.us/reader033/viewer/2022051000/56813b5c550346895da4541e/html5/thumbnails/13.jpg)
Database FeatureSQL 2000 MySQL
Views
Triggers
Stored Procedures
Foreign Keys
Cursors
User-defined functions
Not supported
Not supported
Not supported
only InnoDB tables
Not supported
C, C++ external libraries
Arrays
![Page 14: CS 491B Project](https://reader033.vdocuments.us/reader033/viewer/2022051000/56813b5c550346895da4541e/html5/thumbnails/14.jpg)
Database ComparisonConclusion
Both databases are stable and efficient
![Page 15: CS 491B Project](https://reader033.vdocuments.us/reader033/viewer/2022051000/56813b5c550346895da4541e/html5/thumbnails/15.jpg)
Database ComparisonConclusion
SQL 2000 AdvantageHolds the top TPC-C performance and price/performance results. Generally accepted as easier to install, use and manageTransact-SQL is a more powerful language than MySQL dialect.
![Page 16: CS 491B Project](https://reader033.vdocuments.us/reader033/viewer/2022051000/56813b5c550346895da4541e/html5/thumbnails/16.jpg)
Database ComparisonConclusion
MySQL 4.1 AdvantageSupports all known platforms
Requires less hardware resources
Free under the terms of the GNU General Public License.
Works with medium size databases (10-100 million rows, or about 100 MB per table) on small computer systems.
![Page 17: CS 491B Project](https://reader033.vdocuments.us/reader033/viewer/2022051000/56813b5c550346895da4541e/html5/thumbnails/17.jpg)
Language ComparisonPERL JSP/Java
ServletsC#
1987Most popularMod_perl – server embbed interpreterTemplates
Late 1990sCreated to complete with CGI by PERL
2002Syntax similar to Java
![Page 18: CS 491B Project](https://reader033.vdocuments.us/reader033/viewer/2022051000/56813b5c550346895da4541e/html5/thumbnails/18.jpg)
Web Server ComparisonApache IIS
Most popular web server since April of 1996
69% of web sites use Apache
Winner in the Netcraft and Security Space monthly surveys
Dominant among Fortune 1000 enterprises
21%
![Page 19: CS 491B Project](https://reader033.vdocuments.us/reader033/viewer/2022051000/56813b5c550346895da4541e/html5/thumbnails/19.jpg)
Performance TestComparison Charts of both static and dynamic web pages involves database accessesComparison Chart of database accessPerformance Test Limitations
![Page 20: CS 491B Project](https://reader033.vdocuments.us/reader033/viewer/2022051000/56813b5c550346895da4541e/html5/thumbnails/20.jpg)
Empty Cart Page
0.000
0.020
0.040
0.060
0.080
0.100
0.120
0.140
0.160
1 & 2 3 & 4 5 & 6 7 & 8 9 & 10
Attempt
Tim
e (s
ec)
C#
Java
C#: 0.081 sec AverageJava: 0.122 sec Average
![Page 21: CS 491B Project](https://reader033.vdocuments.us/reader033/viewer/2022051000/56813b5c550346895da4541e/html5/thumbnails/21.jpg)
Add to Cart Page
0.000
0.020
0.040
0.060
0.080
0.100
0.120
0.140
0.160
0.180
0.200
1 & 2 3 & 4 5 & 6 7 & 8 9 & 10
Attempt
Tim
e (s
ec)
C#
JAVA
C#: 0.177 sec Average JAVA: 0.151 sec Average
![Page 22: CS 491B Project](https://reader033.vdocuments.us/reader033/viewer/2022051000/56813b5c550346895da4541e/html5/thumbnails/22.jpg)
Profile Page
0.000
0.020
0.040
0.060
0.080
0.100
0.120
0.140
1 & 2 3 & 4 5 & 6 7 & 8 9 & 10
Attempt
Tim
e (
se
c)
C#
JAVA
C#: 0.102 sec AverageJAVA: 0.094 sec Average
![Page 23: CS 491B Project](https://reader033.vdocuments.us/reader033/viewer/2022051000/56813b5c550346895da4541e/html5/thumbnails/23.jpg)
Search Page
0.000
0.500
1.000
1.500
2.000
2.500
1 & 2 3 & 4 5 & 6 7 & 8 9 & 10
Attempt
Tim
e (
sec
)
C#
JAVA
C#: 0.163 sec AverageJAVA: 2.189 sec Average
![Page 24: CS 491B Project](https://reader033.vdocuments.us/reader033/viewer/2022051000/56813b5c550346895da4541e/html5/thumbnails/24.jpg)
Category Page
0.000
0.500
1.000
1.500
2.000
2.500
1 & 2 3 & 4 5 & 6 7 & 8 9 & 10
Attempt
Tim
e (
se
c)
C#
JAVA
C#: 0.154 sec AverageJAVA: 2.179 sec Average
![Page 25: CS 491B Project](https://reader033.vdocuments.us/reader033/viewer/2022051000/56813b5c550346895da4541e/html5/thumbnails/25.jpg)
Averages of All Charts
0.000
0.500
1.000
1.500
2.000
2.500
Empty CartPage
Add to Cart Profile Search Category
Tim
e (
se
c)
C#
JSP/Servlet
![Page 26: CS 491B Project](https://reader033.vdocuments.us/reader033/viewer/2022051000/56813b5c550346895da4541e/html5/thumbnails/26.jpg)
SQL Database
0.000
0.005
0.010
0.015
0.020
0.025
0.030
0.035
1 2 3 4 5
Attempt
Tim
e (s
ec)
SQL2000
MySQL 3.23.46
SQL2000: 0.006 sec AverageMySQL: 0.024 sec Average
![Page 27: CS 491B Project](https://reader033.vdocuments.us/reader033/viewer/2022051000/56813b5c550346895da4541e/html5/thumbnails/27.jpg)
Performance Test Limitation
Optimized CodingDifferent Versions of OS,Server & DBHardwareDifferent techniques for certain functionalitiesMulti-users/concurrent requests
![Page 28: CS 491B Project](https://reader033.vdocuments.us/reader033/viewer/2022051000/56813b5c550346895da4541e/html5/thumbnails/28.jpg)
ConclusionConsideration of Choosing a web setup
Operation System – platform dependenceAmount of data transaction involved and type of transactionNumbers and concentration of users Developer resources
![Page 29: CS 491B Project](https://reader033.vdocuments.us/reader033/viewer/2022051000/56813b5c550346895da4541e/html5/thumbnails/29.jpg)
Referencehttp://www.mssqlcity.com/Articles/Compare/sql_server_vs_mysql.htmhttp://httpd.apache.org/http://www.serverwatch.com/tutorials/article.php/3074841http://www.tpc.org/tpcc/results/tpcc_price_perf_results.asphttp://www.perl.org/about.html