Transcript Database Engines, Who`s the Fairest of Them All

Internet Database Engines Selection and Implementation
CS689 Research Method
Hong Hu
December 5, 2000
Content
• Introduction
• Methodology
• Findings
• Management plan, timeline,
feasibility
• Conclusion
• References
Introduction
A. General background of the study
You have the next great Web idea, and you
can’t wait to get it online. All you need is
software to run it, along with the heart and
soul of any Web site: a good database
engine.
Introduction
A. General background of the study
(Cont.)
•
•
•
•
•
Five major players in today’s database
engine product market:
Oracle’s SQL
Microsoft’s MS SQL Server 7.0
MySQL -- open source database
PostgreSQL -- bundled with Linux
Other alternatives exist in niche segments
Introduction
A. General background of the study
(Cont.)
•
•
•
•
•
•
Impacts of Database Engine Selection and
Implementation:
Platform Compatibility
Startup Cost
Implementation Cost
Implementation Time
Run Time Efficiencies
Maintenance Cost
Introduction
B. Purpose of the study
• To define a guideline and a set of critical
criterions in the selection of Internet
Database Engine for any typical Website
projects.
• To define a guideline in a typical
implementation project of a Database
Engine.
Introduction
C. Significance of the study
• Facing to so many choices, a proven dependable
selection guideline can save tremendous time and
money.
• An intelligent selection procedure can guarantee the
choosing of the right database engine.
• A proper implementation procedure leads to the
success of the whole Website project.
Methodology
A. Theoretical Framework
Database Engine
The part of a database management system
(DBMS) that actually stores and retrieves data.
Most DBMS’s include an Application
Programming Interface (API) that enables you to
directly control the engine without going through
the DBMS’s user interface.
Methodology
A. Theoretical Framework (Cont.)
Client
In the conventional client-server environment, the
client portion of the program, or front end, is run
by individual users at their desktops and performs
such tasks as querying a database, producing a
printed report, or entering a new record. These
functions are carried out through a database
specification and access language, better known as
Stuctured Query Language(SQL), which operates
in conjunction with existing applications.
Methodology
A. Theoretical Framework (Cont.)
Server
The server portion of the program, or back end, is
resident on a computer configured to support
multiple clients, offering them shared access to
numerous application programs as well as to
printers, file storage, database management,
communications,a nd other resources. The server
performs administrative tasks as transaction
management, security, logging, database creation
and updating, concurrency management, and
maintaining the data dictionary.
Methodology
B. Type of Design
• Cost
• Platform of choice in terms of hardware and
software
• Desired performance
• Reliability
• The nature of the application
• The type of services needed from the database
engine
Methodology
C. Assumptions
• Offshelf selection
• Selection shall not be biased by any non
technical/economic factors
• The selection and implementation guidelines are
based on the current state of art in the
computer/Internet industry.
Methodology
C. Selection of the Site and Participants
• Number of companies implemented new websites
– Midwest Area: 4
– East Coast: 5
– West Coast: 4
• Number of colleges implemented new websites
– Midwest Area: 10
– East Coast: 12
– West Coast: 15
Methodology
D. Data Collection and Analysis
• Survey Forms
–
–
–
–
Final selection
System configurations (Platform)
Budgeting
etc.
• Statistics Methods
Methodology
E. Methods of Achieving Validity
• Sampling needs to be representing real world
realities
• Survey answers need to be detailed and with
honesty
• Collected data needs to be analyzied properly
• Resulted guideline and procedure are based
on valid data analysis
Findings
A. Relationship to Literature
(Current Literature Review)
• Ahmad Abualsamid, Who’s the Fairest of Them All,
Network Computing, CMP Media Inc., Manhasset,
N.Y., October 30, 2000.
• Modeling Customizable Web Applications - A
requirement’s Perspective By Gerti Kappel,
Werner Retschitzegger and Wieland Schwinger,
Sept 2000, University of Linz, Austria
Findings
A. Relationship to Literature (Cont.)
(Current Literature Review)
• Self-Maintaining Web Pages - An Overview
By M. Schrefl, E. Kapsammer, W. Retschitzegger,
and B. Proll, 2000, University of South Australia
Findings
B. Relationship to Practice
• Study findings are summarized from current
practices
• Study findings are based on current technologies
realities
• Study findings try to improve future techical
practices
• Study findings will be verified and further improved
in future practices
Management Plan, Timeline,
Feasibility
A. Management Plan
• Project Leader: Hong Hu
• Project Personal:Faculties 2, Research Associates 2,
Student Assistants 4
• Project Funding: 0.5 million
• Project Phase Review: 3 phases, 2 months each
• Project Audit Team: Faculty 3, Software Industry
Experts 4
• Project Final Audit: End of 6 months project time
Management Plan, Timeline,
Feasibility
B. Timeline
• Proposal Review, November 2000
• Budgeting and Sponsorship Review, December
2000
• Project Kickoff, January 2001
• Phase one review(End in February)
• Phase two review(End in April)
• Phase three review(End in June)
• Final Audit July 2001
Management Plan, Timeline,
Feasibility
C. Feasibility
• Human Resource: Required personals are available
• Capital Resource: 0.5 million from the funding
companies
• Time Required: 8 months, completed by July 2001
• Current situation is projected to be exist until 2005,
with more Internet Database Engine entering the
competition.
Conclusion
• The proposed study is valuable
• The proposed study is feasible
• The proposed study will lead to a
succesful tool in choosing and
implementing Internet Database Engines
• The proposed study shall be funded
References
• B.Beck, and M. McGinnis: “IBM WebShere
Everyplace Suite v1.1”, white paper, IBM
Corporation, September 1999.
• P. Atzeni, G. Mecca, and P. Merialdo, “Design and
Implementation of Data-Intensive Web Sites”, Proc.
of the Conf. On Extended Database
Technology(EDBT), Valencia, Spain, March 1998.
• P. De Bra, “Design Issues in Adaptive Web-Site
Development”, Proc. of the 2nd Workshop on
Adaptive Systems and User Modeling on the WWW
of the 8th International Word Wide Web
Conference, Toronto, Canada, 1999.
Thank You