An Integrated Dealership Management System for Spare Parts, Jobcards, and Financial Analytics Using NoSQL Technologies
Keywords:
Automotive dealership management system, Inventory management, Jobcard automation, MongoDB, NoSQL database, Sales and profit analytics, Web-Based application architectureAbstract
With the tremendous growth in the number of car models and increasing service requirements, the automotive dealership business is in severe trouble in managing inventory levels for spares, managing customer information, job cards, and financial information. Such manual methods, either in hard copy or partially computerized, lead to inventory outages, incorrect invoicing, delayed reporting, and ineffective decision making. In this study, a Smart Automotive Dealership Inventory and Jobcard Management System was created for an automotive dealership business. The system combines serviceable parts management, accident parts management, and customer jobcard management into one online application. The advantage of having all components in one application allows the user to easily access and utilize inventory information, customer information, sales information, inventory notifications, and daily profit-loss statements. The front-end development of the application was completed with the following technologies: HTML, CSS, JavaScript, Tailwind CSS, and Bootstrap to develop a responsive dashboard design for the application. The back end, on the other hand, uses MongoDB, which manages different types of databases, enhances performance with indexes and aggregations, and ensures smooth operations, financial transparency, and the ability to make intelligent decisions. MongoDB is a database system that stores data in document form, and it is capable of managing different types of data, ranging from catalogs of spare parts and services to financial transactions. Using aggregations, the system is able to meet the needs of advanced reporting, providing management with the necessary information on sales, inventory turnover, and profits. Such a technology platform provides for high business efficiency, financial transparency, and decision-making for a dealership to gain long-term competitive advantage in a dynamic automotive service environment.
References
A. Silberschatz, H. F. Korth, and S. Sudarshan, Database System Concepts, 7th ed. New York, NY, USA: McGraw-Hill, 2020.
T. Connolly and C. Begg, Database Systems: A Practical Approach to Design, Implementation, and Management, 6th ed. Boston, MA, USA: Pearson, 2015
R. Elmasri and S. B. Navathe, Fundamentals of Database Systems, 7th ed. Boston, MA, USA: Pearson, 2016.
M. Stonebraker et al., “The end of an architectural era: (It’s time for a complete rewrite), VLDB, 2007, pp. 1150–1160
E. A. Brewer, “Towards robust distributed systems,” Proceedings of the Nineteenth Annual ACM Symposium on Principles of Distributed Computing, Portland, OR, USA, 2000.
P. J. Sadalage and M. Fowler, NoSQL Distilled: A Brief Guide to the Emerging World of Polyglot Persistence. Boston, MA, USA: Addison-Wesley, 2013.
D. J. Abadi, “Data management in the cloud: Limitations and opportunities,” IEEE Data Engineering Bulletin, 2009.
N. Leavitt, “Will NoSQL databases live up to their promise?,” Computer, vol. 43, no. 2, pp. 12–14, Feb. 2010, doi: 10.1109/MC.2010.
J. Manyika et al., “Big data: The next frontier for innovation, competition, and productivity,” McKinsey Global Institute, 2011.
S. Kaur and R. Kaur, “Web-based job card management system for automobile service centers,” International Journal of Advanced Research in Computer Science, vol. 10, no. 2, pp. 45–50, 2019.
R. Kimball and M. Ross, The Data Warehouse Toolkit, 3rd ed. Hoboken, NJ, USA: Wiley, 2013.
J. Han, M. Kamber, and J. Pei, Data Mining: Concepts and Techniques, 3rd ed. Waltham, Morgan Kaufmann Publishers is an imprint of Elsevier, 2012.
T. H. Davenport and J. G. Harris, Competing on Analytics. Boston, MA, USA: Harvard Business School Press, 2007.
S. Few, Information Dashboard Design: Displaying Data for At-a-Glance Monitoring, 2nd ed. Burlingame, CA, USA: Analytics Press, 2013.
J. Gray and A. Reuter, Transaction Processing: Concepts and Techniques. San Francisco, CA, USA: Morgan Kaufmann, 1992
H. Garcia-Molina, J. D. Ullman, and J. Widom, Database Systems: The Complete Book, 2nd ed. Upper Saddle River, NJ, USA: Pearson, 2009.
L. Bass, P. Clements, and R. Kazman, Software Architecture in Practice, 3rd ed. Boston, MA, USA: Addison-Wesley, 2013.
