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

B2B E-Commerce System - Essay ExampleUsers connect to the web server and send requests to the database management system for information retrieval. The application server that sits at the middle tier takes requests from the web server, looks up into the DBMS and consequently processes the information to be fed back to the web server which is visible to the user through a session with the server. turkey cock, 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 package and the new(prenominal)s are paid. In terms of functionality and performance, solely 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 implementation of E-Commerce, it may be advisable that we first start with two tier architecture and then gradually transmigrate to trinity tier architecture if the volume of transactions increases. Moreover, choice of the web & application servers will enumerate upon the expert compatibility aspects of the E-Business package that we shall select in due course. Support & maintainability will be a primary feather push 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 sy stem (DBMS) that shall hold all the information & data pertaining to the E-Business application. In this context, an analysis of MySQL, seer 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 prophet 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, lofty 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 softwa re, foster releases can always have these features added. However, one aspect should be kept in mind that the engineer behind Oracle DBMS is the result of decades of competency development of Oracle