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

B2B E-Commerce System - Essay ExampleUsers connect to the web horde and send requests to the database management system for information retrieval. The application program 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 exploiter 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 package and the others are nonrecreational. 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. 2005Justification Given that we are just starting the instruction execution of E-Commerce, it may be advisable that we front start with two tier architecture and then gradually migrate to three tier architecture if the mountain 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 opt 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 body (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, coming back 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, consumption 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 scatter 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