Data Modeling Practices for E-Commerce

Abstract

In modern times, large amounts of data with diverse characteristics, such as volume, variety, etc., are generated daily. For enterprises such as E-commerce, which is escalating nowadays, massive amounts of unstructured data have increased significantly, making it essential to manage high data availability and consistency in conventional databases. To establish extreme data availability and consistency, opting for the most effective data model is necessary to ensure that data accuracy and consistency are gained and can be easily accessed and manipulated by the intended users. The development of data modeling approaches has made it possible to use massive quantities of data without demeaning performance or loosening the conventional ACID properties. This paper emphasizes the importance of efficient data modeling. It provides practical guidelines considering the type of data access patterns required for implementing relational and document-oriented NoSQL databases, highlighting their advantages and limitations in terms of e-commerce enterprises.