--%>

Aggregate table and materialized view

Write down the differentiation between aggregate table and materialized view.

E

Expert

Verified

Aggregate table is the generic term which is used to represent the summaries which is built in a warehouse. Materialized view is the technical execution of such aggregate tables. Though, Materialized views come with database precise properties which may not be covered with generic definition of the aggregate tables.

   Related Questions in Other Subject

  • Q : Metals which don not react with lithium

    Name the metals which don’t react with lithium Bromide.

  • Q : Strengths and weaknesses of using per

    Strengths and weaknesses of using per capital national income Question1) At the national level, public debate has centered on the performance of the main monetary measure i.e. GDP. Each year we must meliorate over the last lest we are in recession. While GDP growth is important for raising living

  • Q : Explanation of science Give a brief

    Give a brief explanation of the term science.

  • Q : Why separation does not happens in

    Why separation doesn’t takes place in stacking gel in gel electrophoresis and why does separation completed in the separating gel?

  • Q : DATA ANALYSIS Read following

    Read following instruction and check attached files. For activity 3, using the three spreadsheets attached here,: 1. Upload these into a new database called Curtin Hospital 2006_07 and in design view of each table, ensure the field properties are correct 2. Create a query using the Curtin

  • Q : Due to mass communication influences

    Due to mass communication what are the influences which takes place on culture?

  • Q : Biomedical research technology

    Hi, I have assignment in Biomedical research technologies I need excellent professional in Biomedical and bioinformatic area to answer the questions for this assignment.. In this assignment you need to use MASCOT server to answer three questions I also provided the lectures notes for this assignmen

  • Q : Organizational communication "What are

    "What are the main implications of the Hawthorne Studies? What were the implications of the study on organizational theory?"

  • Q : Explanation of Linear Cryptanalysis

    Give a brief explanation of Linear Cryptanalysis.

  • Q : Can DES be exported from United States

    Can DES be exported from United States?