1 / 24

Internet Database Engines - Selection and Implementation

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

chaman
Download Presentation

Internet Database Engines - Selection and Implementation

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Internet Database Engines -Selection and Implementation CS689 Research Method Hong Hu December 5, 2000

  2. Content • Introduction • Methodology • Findings • Management plan, timeline, feasibility • Conclusion • References

  3. 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.

  4. 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

  5. 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

  6. 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.

  7. 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.

  8. 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.

  9. 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.

  10. 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.

  11. 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

  12. 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.

  13. 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

  14. Methodology D. Data Collection and Analysis • Survey Forms • Final selection • System configurations (Platform) • Budgeting • etc. • Statistics Methods

  15. 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

  16. 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

  17. 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

  18. 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

  19. 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

  20. 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

  21. 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.

  22. 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

  23. 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.

  24. Thank You

More Related