Results 1 to 3 of 3
  1. #1
    Senior Member dennis123's Avatar
    Join Date
    Apr 2013
    Location
    Bangalore
    Posts
    1,420

    Difference between EAV and flat model

    Difference between EAV and flat model

  2. #2
    Registered User
    Join Date
    Sep 2017
    Posts
    958
    EAV is entity attribute value database model, where data is fully in normalized form.

    The flat model uses just one table, so it’s not normalized and uses more database space.

  3. #3
    Registered User
    Join Date
    Feb 2016
    Location
    Bangalore
    Posts
    632
    EAV is an entity attribute value database model, where data is fully in normalized form. Each column data value is stored in their respective data type table.
    On the other hand, the Flat model uses only one table, therefore it’s not normalized and uses more database space. It clears the EAV overhead

    It’s good when comes to performance, as it will only require one query to load whole product instead of joining 5-6 tables to get just one product’s details.

    In the flat model, columns are called fields.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

  Find Web Hosting      
  Shared Web Hosting UNIX & Linux Web Hosting Windows Web Hosting Adult Web Hosting
  ASP ASP.NET Web Hosting Reseller Web Hosting VPS Web Hosting Managed Web Hosting
  Cloud Web Hosting Dedicated Server E-commerce Web Hosting Cheap Web Hosting


Premium Partners:


Visit forums.thewebhostbiz.com: to discuss the web hosting business, buy and sell websites and domain names, and discuss current web hosting tools and software.