Transcript IEEE Computer Society 60th Anniversary History Competition

IEEE Computer Society 60th
Anniversary History Competition
SQL and Web Code Technologies
SQL Options
• MySQL 5.0
• Microsoft SQL Server 2005
• Oracle
SQL Comparison Chart
Feature
SQL Server 2005
Oracle 10g
MySQL 4.1
Independent Performance
Benchmarks
2nd Place
1st Place
Does not participate intended for small to
medium sized systems
Independent Analysis of
Price/Performance Ratio
1st Place - licensing is
25% the cost of Oracle
Unknown
Does not participate commercial licenses are
cheaper than SQL Server
Cross Platform Compatible
No
Yes
Yes
Fully Relational - affects
data storage, retrieval and
integrity
Yes
Yes
Somewhat - does not
support foreign key
constraints
Language
Transact-SQL considered easy to use
and more powerful than
MySQL Dialect
PL/SQL - considered
more powerful than
Transact-SQL but more
difficult to use
MySQL Dialect - difficult
to use with limited power
Maintainability
Easy
Difficult
Difficult
Open Source
No
No
Yes
Reasons for Microsoft SQL Server 2005
• T-SQL allows for stored procedures making database
calls easier and reusable
• Easy GUI for setting up and maintaining database
• Allows relational databases for speed and data integrity
• Great compatibility with .NET and Visual Studio
• Easy way to keep content up to date and expand more
content over time
Web Language C# .NET
• Object Oriented Language
• Compiled Code
– Increases speed
– Reusability
• Compatibility with SQL Server
• Follows most W3C standards
• Easy development of Web Applications
• Mobile Web Applications easy to develop
• Code behind HTML code for clearer, easier to manager
and easier to read code
Visual Studio 2005
• Normal IDE benefits
– List of properties and functions for imported libraries
– Fast error correcting of syntax without compilation
• A easy tool to develop and manage Web Code
• SQL Server integration allowing creation of Stored
Procedures and database development
• Compiles, debug and view capabilities of code