In this thesis will be discussed all the steps about the creation of an e-commerce web site. Starting from "why a company needs a e-commerce web site" (both to boost sales and to have a "virtual showcase" easily visible to the world), the thesis will expose the requirements of the project and its realization. The analysis of requirements goes from the interaction with Order Management and General Ledger systems that manage the existing e-business sector, up to the choices of desing (shipping methods, payment, the flow of information, and which information show to customers). After highlighted the main requirements, thanks to the knowledge of a consultant company specialized in e-commerce like Sopra Steria, it proposes a software solution that can fully satisfy the needs. This solution is multi-level: a tier on the frontend and customer management (basket, login, cookies etc.) implemented with Hybris; Mule includes the exchange of files between systems; at last Stargate, an Oracle custom made in Sopra Steria, allows you to manage the order. The potentiality of Stargate is the easy management by the customer care's employees: all the order informations are presented in a simple and complete with a set of web pages. In these ones that make up the backoffice portal you can manage the order, such as canceling it, reducing a quantity ordered, changing the shipping address etc. They will list the order management data flows from and headed to the systems. Stargate, which is the center of the thesis is mainly based on three technologies: PL/SQL, an Oracle proprietary language that allows an easy and powerful interaction with database; Oracle Application Framework, for web page management; and XML Publisher to create useful reports for decision business. Finally, this thesis will present possible developments of the project.
In questa tesi verranno discussi tutti i passaggi che hanno portato la creazione di un sito e-commerce. Partendo dal perché, ovvero la necessità di un'azienda di aprire un e-commerce (sia per spingere le vendite, sia per avere una "vetrina" virtuale visibile facilmente al mondo), si arriva ai requisiti del progetto e alla sua realizzazione. L'analisi dei requisiti spazia dall'interazione con i sistemi di Order Management e General Ledger preesistenti del comparto e-business, fino alle scelte di design (metodi di spedizione, di pagamento, del flusso di informazioni, di quali informazioni mostrare al cliente). Una volta delineati i principali requisiti, anche grazie alle conoscenze di un'azienda di consulenze specializzata in e-commerce come Sopra Steria, viene proposta una soluzione software che possa soddisfare a pieno le necessità. Tale soluzione è multilivello: una parte relativa al frontend e alla gestione del cliente (carrello, login, cookies ecc.) implementata con Hybris; Mule comprende lo scambio di file fra i vari sistemi; infine Stargate, una custom di Oracle fatta da Sopra Steria, permette di gestire l'ordine. La potenzialità di Stargate sta proprio nella semplicità di gestione da parte degli addetti al customer care: tutte le informazioni dell'ordine sono presentate in maniera semplice ma completa grazie ad una serie di pagine web. Dalle web-pages di questo portale backoffice è possibile gestire l'ordine, ad esempio annullandolo, diminuendo una quantità ordinata, cambiando l'indirizzo di spedizione ecc. Verranno mostrati i flussi dati di gestione degli ordini provenienti e diretti verso i sistemi. Stargate, che è il centro della tesi, è basato principalmente su tre tecnologie: PL/SQL, un linguaggio proprietario di Oracle che permette una facile e potente interazione col database; Oracle Application Framework, per la gestione delle pagine web; e XML Publisher per la creazione di reportistica utile per le business decision. Infine si esporranno possibili evolutive del progetto.
Stargate : order management per l’e-commerce
VARALTA, MATTEO
2015/2016
Abstract
In this thesis will be discussed all the steps about the creation of an e-commerce web site. Starting from "why a company needs a e-commerce web site" (both to boost sales and to have a "virtual showcase" easily visible to the world), the thesis will expose the requirements of the project and its realization. The analysis of requirements goes from the interaction with Order Management and General Ledger systems that manage the existing e-business sector, up to the choices of desing (shipping methods, payment, the flow of information, and which information show to customers). After highlighted the main requirements, thanks to the knowledge of a consultant company specialized in e-commerce like Sopra Steria, it proposes a software solution that can fully satisfy the needs. This solution is multi-level: a tier on the frontend and customer management (basket, login, cookies etc.) implemented with Hybris; Mule includes the exchange of files between systems; at last Stargate, an Oracle custom made in Sopra Steria, allows you to manage the order. The potentiality of Stargate is the easy management by the customer care's employees: all the order informations are presented in a simple and complete with a set of web pages. In these ones that make up the backoffice portal you can manage the order, such as canceling it, reducing a quantity ordered, changing the shipping address etc. They will list the order management data flows from and headed to the systems. Stargate, which is the center of the thesis is mainly based on three technologies: PL/SQL, an Oracle proprietary language that allows an easy and powerful interaction with database; Oracle Application Framework, for web page management; and XML Publisher to create useful reports for decision business. Finally, this thesis will present possible developments of the project.| File | Dimensione | Formato | |
|---|---|---|---|
|
tesi.pdf
non accessibile
Descrizione: Testo della tesi
Dimensione
1.83 MB
Formato
Adobe PDF
|
1.83 MB | Adobe PDF | Visualizza/Apri |
I documenti in POLITesi sono protetti da copyright e tutti i diritti sono riservati, salvo diversa indicazione.
https://hdl.handle.net/10589/123722