International Journal of Engineering and Management Research (IJEMR)
  • Year: 2020
  • Volume: 10
  • Issue: 5

Database performance management in cloud

  • Author:
  • Navendu Mishra1, Jayant Sawarkar2, Suraj Dubey3
  • Total Page Count: 6
  • Page Number: 46 to 51

1Student, Department of Computer Science & Engineering, Birla Institute of Technology & Science, Pilani, India

2Assistant Professor, Department of Computer Science & Engineering, Datta Meghe College of Engineering, Navi Mumbai, India

3COO, Osource Global Private Limited, Mumbai, India

*Corresponding Author: jdsawarkar@yahoo.com

Online published on 23 December, 2020.

Abstract

Managing large chain of Hotels and ERP database comprises of core areas such as HRMS & PIP.HRMS (Human Resource Management System), which further includes areas such as Soft Joining, Promotion, Transfer, Confirmation, Leave Attendance and Exit, etc. PIP (Payroll Information Portal), wherein employees can view their individual Salary details, submit investment declaration, Reimbursement claim & CTC structuring, etc. Management of Large Chain of Hotels and ERP Database in AWS Cloud involves continuous monitoring with regards to the areas such as Performance of resource usages and optimization techniques relating to the use of PL/SQL. High Availability (HA) of data is accomplished through the Backup and Recovery mechanism and security of the data by Encryption & Decryption mechanism. Broad Academic Area of Work: CLOUD COMPUTING.

Keywords

AWS Cloud, Database, ERP, Hotels, PL/SQL, S3 Bucket and Query