St. Cloud State University theRepository at St. Cloud State Culminating Projects in Information Assurance Department of Information Systems 5-2017 Online Banking Application with Angular JS, RESTful Web Services and Cassandra Database Naga Sandeep Singh Bondili Saint Cloud State University, [email protected] Follow this and additional works at:https://repository.stcloudstate.edu/msia_etds Recommended Citation Bondili, Naga Sandeep Singh, "Online Banking Application with Angular JS, RESTful Web Services and Cassandra Database" (2017). Culminating Projects in Information Assurance. 26. https://repository.stcloudstate.edu/msia_etds/26 This Starred Paper is brought to you for free and open access by the Department of Information Systems at theRepository at St. Cloud State. It has been accepted for inclusion in Culminating Projects in Information Assurance by an authorized administrator of theRepository at St. Cloud State. For more information, please [email protected]. Online Banking Application with Angular JS, RESTful Web Services and Cassandra Database by Naga Sandeep Singh Bondili A Starred Paper Submitted to the Graduate Faculty of St. Cloud State University in Partial Fulfillment of the Requirements for the Degree of Master of Science in Information Assurance March 2017 Starred Paper Committee: Dr. Dennis Guster Dr. Susantha Herath Dr. Kasi Balasubramaniam 2 Abstract The purpose of this project is to show how new technologies help the banking and financial industries to process and retrieve data for users. The primary goal of this project is to demonstrate the new technologies Angular JS, RESTful Web Services, and the Cassandra database which are faster than the other conventional software frameworks. This has been achieved by creating two software applications; one is an online banking application with the latest technologies and the other with traditional frameworks. After examining the time taken by the techniques to render the web page to the user, and the availability and scalability of the software, we will understand the need for the new technologies in the banking and financial sectors. The application that is developed should help the users, guide them and should perform user requested transactions with zero fault tolerance; it should give precise data without losing or showing error data. It should also provide security to the transaction. Unauthorized transactions should be prohibited from entering the server either from UI (User Interface) or from a mid-tier connection. The proposed application uses the Cassandra database which has high scalability and availability. It also uses Service Oriented Architecture (SOA) for better service and performance of the application. In the UI we use Angular JS which is fast and can handle the REST (Representational State Transfer) Application Programming Interface CRUD(Create, Read, Update & Delete) operations. 3 Acknowledgement The effective finish of this paper could not have been conceivable without the direction of my professors Dr. Dennis Guster and Dr. Susantha Herath. I also would like to thank Professor Kasi Balasubramanian for being part of the committee. 4 Table of Contents Page List of Table ................................................................................................................................ 6 List of Figures .............................................................................................................................. 7 Chapter I. Introduction ...................................................................................................................... 9 Introduction ................................................................................................................ 9 Problem Statement ..................................................................................................... 9 Nature and Significance of the Problem .................................................................... 10 Objective of the Study ............................................................................................... 10 Study Questions/Hypotheses ..................................................................................... 10 Summary .................................................................................................................... 10 II. Background and Review of Literature ............................................................................. 11 Introduction ................................................................................................................ 11 Background Related to the Problem .......................................................................... 11 Current System Problems .......................................................................................... 11 Proposed System ........................................................................................................ 11 About the Technologies ............................................................................................. 12 Java ............................................................................................................................ 18 Spring Security........................................................................................................... 36 Angular JS .................................................................................................................. 39 Summary .................................................................................................................... 50 5 III. Methodology .................................................................................................................... 51 Introduction ................................................................................................................ 51 Design of the Study .................................................................................................... 51 Testing the Hypothesis ............................................................................................... 51 Tools and Techniques ................................................................................................ 51 Hardware and Software Environment ........................................................................ 52 Advantages of Approach............................................................................................ 52 Project Explanation .................................................................................................... 53 Results ........................................................................................................................ 59 IV. Design and Installations ................................................................................................... 64 Java Installation (for mac osX) .................................................................................. 64 Installing Cassandra ................................................................................................... 65 V. Conclusion and Future Work ........................................................................................... 66 References .................................................................................................................................... 67 6 List of Table Table Page 1. Results .............................................................................................................................. 63 7 List of Figures Figure Page 1. Write Operation ............................................................................................................... 16 2. Chubby Protocol Architecture ......................................................................................... 17 3. Paxos Algorithm .............................................................................................................. 18 4. Java Architecture ............................................................................................................. 21 5. Package Name and Class Defined ................................................................................... 23 6. Folder Structure ............................................................................................................... 24 7. Class Declared with Access Modifier .............................................................................. 24 8. Method Defined Inside the Class ..................................................................................... 25 9. Angular JS Work Flow .................................................................................................... 40 10. Folder Structure ............................................................................................................... 53 11. Application Login Screen ................................................................................................ 55 12. The Network Tab of Debugger Tool ............................................................................... 58 13. Spring MVC Architecture ................................................................................................ 59 14. Star Paper Application Home Screen .............................................................................. 60 15. Star Paper Application Account Tab Screen ................................................................... 60 16. Network Tab in Debugger Tool to Display Elapsed Time .............................................. 61 17. Home Screen of Application Developed in Spring MVC ............................................... 61 18. Spring MVC Application Accounts Tab Screen .............................................................. 62 19. Spring MVC Application Accounts Tab Elapsed Time .................................................. 62 20. Test the JDK Class Path ................................................................................................... 64 8 21. Testing Java from the Console ......................................................................................... 64 22. Apache Cassandra in Local File System .......................................................................... 65 23. Create Cassandra Log Files ............................................................................................. 65 9 Chapter I: Introduction Introduction The Online Banking Applications help the bankers and customers to connect and also helps in saving time and money of the customers by avoiding a trip to banks to perform any banking transactions. Banks collect huge amounts of data such as daily transactions, calculating interest, tracking loan, and also in portfolio management. The bank customers can keep track of their funds and manage their funds whenever they want to so long as they are authorized. It should be fast enough to maintain and retrieve this huge amount of data. The application should be smart enough to restrict the access to users who are not permitted to perform such actions. In this application, we are using Spring Security, which performs specific actions when the user has roles assigned and which are allowed to carry out an action. If the user does not have permission, the application prohibits the action by giving an error message to the user. This application was developed using Service Oriented Architecture (SOA). It can have one or more services associated with each request. Here we use spring security to add security to the service. Moreover, this service contacts mid-tier architecture to fetch data from the database. Problem Statement In the current scenario, the database availability and scalability is a big problem. Some banks restrict their user’s transaction statement to a particular period instead of allowing them to view the entire report. For example, they may be limited to a period of 5 years. Sometimes the availability of the database service is also a big problem.