View Maintenance Expression Improvement in Data Warehouses

Q: How can I download an article?

To download an article from SID, first log in to the site, search for the article title, and click on the 'Download Article' option.

Q: How can I download an ISI article?

To download an ISI article on SID, enter the keyword or article title in the search bar, view the relevant results, click on the desired article, and select the 'Download Article' option.

Q: How can I access the SID database?

To access the SID database, visit SID.ir, create an account, and log in to access scientific resources.

Q: Is downloading articles from SID free?

Some articles on SID are available for free, while others require payment. Details are specified on the article's page.

Ghoreishi seyed Mehdi; Daneshpour Negin

مرکز اطلاعات علمی Scientific Information Database (SID) - Trusted Source for Research and Academic Resources

Journal Paper

Paper Information

Journal: Modeling in Engineering Year:2019 | Volume:16 | Issue:55 Page(s): 101-111

Download Full-Text

Persian Verion

View:

493

Download:

Cites:

Information Journal Paper

Title

View Maintenance Expression Improvement in Data Warehouses

Author(s)

Ghoreishi seyed Mehdi | Daneshpour Negin | Issue Writer Certificate

Keywords

Data WarehouseQ1

Incremental View MaintenanceQ2

Materialized ViewQ1

View Maintenance ExpressionQ1

Abstract

In Data Warehouses, some of query responses are stored to accelerate the response time of analytical queries. Materialized Views are the response of queries stored in Data Warehouses. Materialized Views should be changed according to changes in basic relations. Different View Maintenance Expressions have been presented for maintaining Materialized Views. In this paper a new algorithm is presented to produce the improved View Maintenance Expression. The proposed algorithm consists of two parts. In the first part, the algorithm constructs a tree to reduce the number of accesses to big data sources and in the second part an improved View Maintenance Expression is presented according to the constructed tree and the amount of changes in data sources. Experimental results show that the improved View Maintenance Expression reduces the Data Warehouse maintenance time and the Data Warehouse maintenance cost in comparison with previous methods.

Cites

No record.

References

No record.

Cite

APA: Copy

Ghoreishi, seyed Mehdi, & Daneshpour, Negin. (2019). View Maintenance Expression Improvement in Data Warehouses. JOURNAL OF MODELING IN ENGINEERING, 16(55 ), 101-111. SID. https://sid.ir/paper/365033/en

Vancouver: Copy

Ghoreishi seyed Mehdi, Daneshpour Negin. View Maintenance Expression Improvement in Data Warehouses. JOURNAL OF MODELING IN ENGINEERING[Internet]. 2019;16(55 ):101-111. Available from: https://sid.ir/paper/365033/en

IEEE: Copy

seyed Mehdi Ghoreishi, and Negin Daneshpour, “View Maintenance Expression Improvement in Data Warehouses,” JOURNAL OF MODELING IN ENGINEERING, vol. 16, no. 55 , pp. 101–111, 2019, [Online]. Available: https://sid.ir/paper/365033/en

Related Journal Papers