segment-pixel
For the best experience, try the new Microsoft Edge browser recommended by Microsoft (version 87 or above) or switch to another browser � Google Chrome / Firefox / Safari
OK
brand-elements brand-elements brand-elements brand-elements brand-elements
brand-elements

Database Management and Performance Optimization Of An Enterprise Communication Platform

Increased overall performance and usability of the web application by 40% by archiving old user data, reducing data archiving time and upgrading to Redactor editor to provide a simple, clean, smooth and an immersive user experience.

Key Requirements

  • Develop a system which will archive the old user data and all associated records
  • Develop a user interface for admin to search and select one or multiple user for data archiving
  • Develop a reverse system where admin can revert the archived data from ‘Archived Database’ to ‘Production Database’.

Key Contribution

  • Built a solution to archive the old data of size approximately equal to 50GB, clean the database for fresh use and increase the requests turnaround time by using combination of Rails Active Record and raw SQL query
  • Achieved database cleaning, improved data integrity and decreased database redundancy by writing a script to archive the production record and shift data to archived database
  • Replaced Flash based editor and upgraded it with Redactor editor and made the earlier design compatible with the latest upgrade.

Benefits

  • Archived old user data and its associated records that helped in managing huge database thus improving the overall performance of the system by 20-30%.
  • Up-gradation to Redactor editor helped the client to provide a simple, clean, smooth and an immersive user experience in building the presentation / slides and this increased the usability of the Enterprise Communication platform by 50-60.

Get Started

vector_white_1
Think Tomorrow
With Xoriant
triangle triangle triangle triangle triangle
Is your digital roadmap adaptive to Generative AI, Hyper cloud, and Intelligent Automation?
Are your people optimally leveraging AI, cloud apps, and analytics to drive enterprise future states?
Which legacy challenge worries you most when accelerating digital and adopting new products?

Your Information

16 + 0 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.

Your Information

14 + 3 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.

Your Information

9 + 7 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.