B2B E-Commerce System Essay Example | Topics and Well Written Essays - 2000 words

B2B E-Commerce System - Essay Example Users connect to the web server and send requests to the DBMS for information retrieval. The application server that sits at the middle tier takes requests from the web server, looks up into the DBMS and then processes the information to be fed back to the web server which is visible to the user through a session with the server. Tomcat, Weblogic, and WebSphere are application servers whereas Internet Information Server (IIS) and Apache are web servers. Out of these Apache and Tomcat are free software and the others are paid. In terms of functionality and performance, all servers are similar - it is the software level configurations and hardware specifications that matter. [Liu, Xue and Heo, Jin et al. 2005] Justification: Given that we are just starting the implementation of E-Commerce, it may be advisable that we first start with two tier architecture and then gradually migrate to three tier architecture if the volume of transactions increases. Moreover, choice of the web & application servers will depend upon the technical compatibility aspects of the E-Business package that we shall select in due course. Support & maintainability will be a primary concern and hence we shall favour the platform that is better supported by vendors in our region. Background: The backe... n of E-Commerce, it may be advisable that we first start with two tier architecture and then gradually migrate to three tier architecture if the volume of transactions increases. Moreover, choice of the web & application servers will depend upon the technical compatibility aspects of the E-Business package that we shall select in due course. Support & maintainability will be a primary concern and hence we shall favour the platform that is better supported by vendors in our region. The report on Database Management Systems Background: The backend tier needs to be a database management system (DBMS) that shall hold all the information & data pertaining to the E-Business application. In this context, an analysis of MySQL, Oracle and Microsoft SQL Server is presented herewith. Detailed Analysis: MySQL is a freeware and the other two are paid DBMS software. I have studied the comparison between Oracle and MySQL from the perspective of main DBMS features - Data Types, Tables, Indexing, views, synonyms, sequences, Data Definition & Modification language, stored procedures, triggers, functions, XML compatibility, transactional capabilities, security, auditing, replication and clustering. Most of the features of Oracle are available in MySQL current versions. However, few critical features, like two way replications, high availability clustering, hot backups, role based security (grouping of users into roles before assigning privileges) and partial rollback (partial backing out of erroneous transactions) are not supported by MySQL. Given that this is an open source software, further releases can always have these features added. However, one aspect should be kept in mind that the engineering behind Oracle DBMS is the result of decades of competency development of Oracle