Door

1
Door Hardware Specialties, Inc.

• SQL Server 2000 - vs - MySQL 5.0
• Comparison of RDBMS Solutions
• Eric Miles

2
Business

• DHS distributes and installs commercial doors and
  door hardware.
• Process orders via customer phone calls.
• Orders are logged in a relational Access database
  that contains job specifications, customer and
  product information.

3
Proposal

• DHS owners have decided to automate ordering
  process.
• Create an enterprise solution that would combine
  an online web ordering system with job tracking
  and inventory management.
• Will eventually integrate with accounting and
  shipping.

4
Requirements

• Requires a RDBMS software package that will
  enable a total enterprise solution.
• Stable, reliable, cost effective, efficient.
• Include specific tools to provide owners and
  employees with timely information to implement
  proactive business decisions.

5
Products compared

• SQL Server 2000 from Microsoft
• MySQL 5.0 from MySQL AB

6
Hardware

• Dell PowerEdge 1850.
• Windows 2003 or Red Hat Linux
• SQL Server can only run on Windows OS.
• MySQL has multiple distributions for Windows and
  various UNIX flavors.
• Cost difference not a significant factor at this
  point. Cost may increase for SQL Server.

7
How is data accessed?

• Data access primarily via SQL
• Data retrieval
• Manipulation (DML)
• Defining (DDL)
• Transactions
• Control (DCL)
• Also proprietary commands

8
Language specifics

• SQL Server uses Transact SQL (T-SQL) for data
  access, stored procedures, triggers, and UDFs.
• T-SQL is basically ANSI 92 compliant.
• MySQL uses SQL and C/C for data access, stored
  procedures, triggers, and UDFs.
• MySQL contains many ANSI SQL features including
  some from ANSI 2003.

9
Other language functions

• Stored procedures.
• Triggers (performed when a command is submitted
  to the database).
• User defined functions (UDFs) enable access to
  data via customized code modules.

10
Reliability and software support

• Both SQL Server and MySQL have been deployed by
  major firms in production environments.
• SQL Server received a rating of C2 (Controlled
  Access Protection) from the National Security
  Agency.
• Comprehensive software support is offered for
  both products.

11
OLAP

• OLAP (online analytical processing).
• Used to restructure existing data via complex
  queries into multidimensional (MOLAP) or
  relational (ROLAP) data.
• Provide us with ability to query for business
  reporting, business performance management,
  budgeting, forecasting, and financial reporting.
• Both products provide OLAP ability.

12
OLTP

• OLTP (online transaction processing)
• OLTP is utilized for electronic banking, order
  processing, employee time clock systems,
  e-commerce, and e-trading.
• SQL Server 2000 was originally created as an OLTP
  DBMS.
• MySQL handles OLTP via the InnoDB storage engine
  and is ACID compliant.

13
XML

• XML is used for transmitting data between a
  variety of different systems using a standard
  format.
• SQL Server possesses built-in XML functionality.
• MySQL does not possess any built-in XML
  functionality.

14
Reporting tools

• Will require reporting tools for business
  reporting, business performance management,
  budgeting, forecasting, and financial reporting.
• Microsoft provides Reporting Services software
  free in SP1 to any customer.
• MySQL does not have any built-in reporting tools.

15
Job scheduling

• Perform maintenance and other tasks during
  non-business hours and without human
  intervention.
• Based on time, events, alerts.
• SQL Server possesses a SQL Agent for job
  scheduling.
• MySQL does not possess built-in job scheduling
  abilities.

16
State of the art

• MySQL is currently on version 5.0.15.
• MySQL is updated frequently.
• SQL Server 2000 is currently on service pack
  four.
• SQL Server large selection of useful tools for
  database administration, reporting, and
  maintenance.

17
Conclusion

• Both products can provide the basic e-commerce
  functionality required.
• SQL Server 2000 possesses many built-in tools we
  require.
• MySQL requires third-party tools to meet our
  expectations.
• We choose SQL Server 2000 for our e-commerce
  solution.

18
Take away items

• Cost versus built-in capabilities.
• SQL Server provides many built-in tools that
  MySQL does not.

19
Works Consulted

• MySQL 5.0 reference manual (2005).
  http//dev.mysql.com/doc/refman/5.0/en/index.html
• MySQL All-in-one Enterprise-grade Database,
  Support and Services. https//shop.mysql.com/?rz1
  11
• Dell. (2005). Hardware quote. http//configure.us
  .dell.com/dellstore/config.aspx?cuscs04kc6W30
  0lenocpe1850rsdbsbsd
• SQL Server 2000 support options.
  http//support.microsoft.com/oas/default.aspx?lne
  n-usx20y11prid6430gprid36502
• Shah, Nilesh (2002). Database Systems Using
  Oracle A Simplified Guide to SQL and PL/SQL.
  2nd Ed.

20
Works Consulted

• Dalton, P., Whitehead, P. (2001). SQL Server
  2000 Black Book. Scottsdale, AZ The Coriolis
  Group, LLC.
• Harkins, S. Reid, M. (2002). SQL Access to
  SQL Server. Berkeley, CA Apress.
• Atkinson, Leon. (2002). Core MySQL. Upper
  Saddle River, NJ Prentice Hall PTR.
• Shapiro, J. R. (2001). SQL Server 2000 The
  Complete Reference. http//dlc.clevnet.org.
  (Adobe eBook).
• eWeek. (10/24/2005). MySQL 5.0 Arrives.
  http//www.eweek.com/article2/0,1759,1876702,00.as
  p

21
Works Consulted

• Wikipedia. (2005). OLAP. http//en.wikipedia.org/
  wiki/OLAP
• Wikipedia. (2005). OLTP. http//en.wikipedia.org/
  wiki/OLTP
• DevArticles (1/24/2002). Creating User Defined
  Functions In SQL Server 2000. http//www.devarticl
  es.com/c/a/SQL-Server/Creating-User-Defined-Functi
  ons-In-SQL-Server-2000/1/
• SQLPass (unknown). SQL Server 2000 is the market
  leader. http//www.sqlpass.org/advertising.cfm?pag
  emodeprint
• About.com (unknown). Database Servers Take the
  Security Test. http//databases.about.com/od/secur
  ity/a/aasecuritytest.htm
• Gifford, S. (8/15/2005). Re Native XML Support,
  from http//lists.mysql.com/mysql/187841

22
Works Consulted

• Open Source Business Intelligence Consolidation
  Begins Pentaho Adds 1 Open Source OLAP Server
  to BI Platform (11/10/2005). http//www.businessin
  telligence.com/ex/asp/id.1522/xe/binewsdetail.htm
• ACID is the acronym used to describe the four
  properties of an enterprise-level transaction
  (unknown).
• http//www.webopedia.com/TERM/A/ACID.html
• What is Mondrian? (unknown). http//mondrian.sour
  ceforge.net/
• First Service Pack for Microsoft SQL Server 2000
  Reporting Services Available Today (6/22/2004).
  http//www.microsoft.com/presspass/press/2004/jun0
  4/06-22ServicePackSQLPR.mspx