Data Modeling Practices for E-Commerce

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 achieved and can be easily accessed and manipulated by the intended users. The development of data modelling approaches has made it possible to use massive quantities of data without degrading performance or loosening the conventional ACID properties. This paper emphasizes the importance of efficient data modelling. It provides practical guidelines for structuring RDBMS data models and for NoSQL data models, considering the types of data access patterns and highlighting their advantages and limitations in terms of e-commerce enterprises