IDEAS home Printed from https://ideas.repec.org/a/spr/ijsaem/v10y2019i4d10.1007_s13198-019-00812-x.html
   My bibliography  Save this article

Selection of materialized views using stochastic ranking based Backtracking Search Optimization Algorithm

Author

Listed:
  • Anjana Gosain

    (Guru Gobind Singh Indraprastha University)

  • Kavita Sachdeva

    (Shree Guru Gobind Singh Tricentenary University)

Abstract

Selection of materialized view plays an important part in structuring decisions effectively in datawarehouse. Materialized view selection (MVS) is recognized as NP-hard and optimization problem, involving disk space and cost constraints. Numerous algorithms exist in literature for selection of materialized views. In this study, authors have proposed stochastic ranking (SR) method, together with Backtracking Search Optimization Algorithm (BSA) for solving MVS problem. The faster exploration and exploitation capabilities of BSA and the ranking method of SR technique for handling constraints are the motivating factors for proposing these two together for MVS problem. Authors have compared results with the constrained evolutionary optimization algorithm proposed by Yu et al. (IEEE Trans Syst Man Cybernet Part C Appl Rev 33(4):458–467, 2003). The proposed method handles the constraints effectively, lessens the total processing cost of query and scales well with problem size.

Suggested Citation

  • Anjana Gosain & Kavita Sachdeva, 2019. "Selection of materialized views using stochastic ranking based Backtracking Search Optimization Algorithm," International Journal of System Assurance Engineering and Management, Springer;The Society for Reliability, Engineering Quality and Operations Management (SREQOM),India, and Division of Operation and Maintenance, Lulea University of Technology, Sweden, vol. 10(4), pages 801-810, August.
    • Handle: RePEc:spr:ijsaem:v:10:y:2019:i:4:d:10.1007_s13198-019-00812-x
    DOI: 10.1007/s13198-019-00812-x
    as

    Download full text from publisher

    File URL: http://link.springer.com/10.1007/s13198-019-00812-x
    File Function: Abstract
    Download Restriction: Access to the full text of the articles in this series is restricted.
    File URL: https://libkey.io/10.1007/s13198-019-00812-x?utm_source=ideas
    LibKey link: if access is restricted and if your library uses this service, LibKey will redirect you to where you can use your library subscription to access this item
    ---><---

    As the access to this document is restricted, you may want to search for a different version of it.

    References listed on IDEAS

    as
    1. Biri Arun & T.V. Vijay Kumar, 2015. "Materialized View Selection using Marriage in Honey Bees Optimization," International Journal of Natural Computing Research (IJNCR), IGI Global, vol. 5(3), pages 1-25, July.
    2. T.V. Vijay Kumar & Santosh Kumar, 2015. "Materialised view selection using randomised algorithms," International Journal of Business Information Systems, Inderscience Enterprises Ltd, vol. 19(2), pages 224-240.
    Full references (including those not matched with items on IDEAS)

    Most related items

    These are the items that most often cite the same works as this one and are cited by the same works as this one.
    1. Jay Prakash & T. V. Vijay Kumar, 2020. "Multi-objective materialized view selection using MOGA," International Journal of System Assurance Engineering and Management, Springer;The Society for Reliability, Engineering Quality and Operations Management (SREQOM),India, and Division of Operation and Maintenance, Lulea University of Technology, Sweden, vol. 11(2), pages 220-231, July.
    2. Jay Prakash & T. V. Vijay Kumar, 2020. "Multi-objective materialized view selection using NSGA-II," International Journal of System Assurance Engineering and Management, Springer;The Society for Reliability, Engineering Quality and Operations Management (SREQOM),India, and Division of Operation and Maintenance, Lulea University of Technology, Sweden, vol. 11(5), pages 972-984, October.
    3. T. V. Vijay Kumar & Biri Arun, 2017. "Materialized view selection using HBMO," International Journal of System Assurance Engineering and Management, Springer;The Society for Reliability, Engineering Quality and Operations Management (SREQOM),India, and Division of Operation and Maintenance, Lulea University of Technology, Sweden, vol. 8(1), pages 379-392, January.
    4. Akshay Kumar & T. V. Vijay Kumar, 2022. "Multi-Objective Big Data View Materialization Using MOGA," International Journal of Applied Metaheuristic Computing (IJAMC), IGI Global, vol. 13(1), pages 1-28, January.

    Corrections

    All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:spr:ijsaem:v:10:y:2019:i:4:d:10.1007_s13198-019-00812-x. See general information about how to correct material in RePEc.

    If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

    If CitEc recognized a bibliographic reference but did not link an item in RePEc to it, you can help with this form .

    If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: Sonal Shukla or Springer Nature Abstracting and Indexing (email available below). General contact details of provider: http://www.springer.com .

    Please note that corrections may take a couple of weeks to filter through the various RePEc services.

    IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.