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

    Difference between EAV and flat model

    Difference between EAV and flat model

  2. #2
    Registered User
    Join Date
    Sep 2017
    Posts
    1,024
    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
    681
    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.

  4. #4
    Senior Member
    Join Date
    Jun 2018
    Location
    australia
    Posts
    165
    EAV is entity attribute value database model, where data is fully in normalized form. Each column data value is stored in their respective data type table. ... Flat model uses just one table, so it's not normalized and uses more database space.

  5. #5
    Member
    Join Date
    Jul 2018
    Posts
    30
    What are the differences between EAV and Flat model? EAV is entity attribute value database model, where data is fully in normalized form. Each column data value is stored in their respective data type table. ... Flat model uses just one table, so it's not normalized and uses more database space.

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.