Parallel multisource view maintenance

Zhang, Xin; Ding, Lingli; Rundensteiner, Elke A.

doi:10.1007/s00778-003-0086-0

Cited by 12 publications

(7 citation statements)

References 25 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…Entity-Relationship diagrams and normalization techniques are popularly utilized for database design for data warehouses. However, the database designs recommended by Entity-Relationship diagrams were inappropriate for decision support systems where efficiency in querying and in loading data was important ( 7 ). Thus, we chose to use the multi-dimensional model.…”

Section: Methodsmentioning

confidence: 99%

See 1 more Smart Citation

Decision support system for health care resources allocation

et al. 2017

View full text Add to dashboard Cite

BackgroundA study about healthcare resources can improve decisions regarding the allotment and mobilization of medical resources and to better guide future investment in the health sector.AimThe aim of this work was to design and implement a decision support system to improve medical resources allocation of Bejaia region.MethodsTo achieve the retrospective cohort study, we integrated existing clinical databases from different Bejaia department health sector institutions (an Algerian department) to collect information about patients from January 2015 through December 2015. Data integration was performed in a data warehouse using the multi-dimensional model and OLAP cube. During implementation, we used Microsoft SQL server 2012 and Microsoft Excel 2010.ResultsA medical decision support platform was introduced, and was implemented during the planning stages allowing the management of different medical orientations, it provides better apportionment and allotment of medical resources, and ensures that the allocation of health care resources has optimal effects on improving health.ConclusionIn this study, we designed and implemented a decision support system which would improve health care in Bejaia department to especially assist in the selection of the optimum location of health center and hospital, the specialty of the health center, the medical equipment and the medical staff.

show abstract

Section: Methodsmentioning

confidence: 99%

“…For example, the patients address. Materialized view maintenance is to keep materialized view up to date when the underlying data sources are updated over time ( 7 , 9 ). Several maintenance methods were proposed in the literature.…”

Section: Methodsmentioning

confidence: 99%

Decision support system for health care resources allocation

et al. 2017

View full text Add to dashboard Cite

show abstract

“…Materialized views need to be maintained upon source changes since a stale view extent may not help or even mislead user applications. Incremental view maintenance, which aims at only computing the deltas of the view result instead of recomputing the view from scratch on data source changes, has been extensively studied in the past [1,[3][4][5][6][7][8][9][10][11]. Among these works, the incremental maintenance of batches of updates [3,7,12,13] is of particular interest because it is attractive from both a resource and a performance perspective to most practical systems.…”

Section: Materialized Views and Their Maintenancementioning

confidence: 99%

Maintaining large update batches by restructuring and grouping

Liu

Rundensteiner

Finkel

2007

Information Systems

Self Cite

View full text Add to dashboard Cite

“…SVC has actually been well studied in the traditional data warehousing environment [11,15,1,14]. However, since the base data changes in a web warehousing environment do not propagate from data sources to the information consumers, which is far different from the case in the traditional data warehouses, the maintenance mechanism for webviews in a web warehouse is totally different.…”

Section: Problem Statementmentioning

confidence: 99%

“…Zhang et al believe that a set of updates should be maintained in parallel by several concurrent maintenance processes [14], so that both the information sources and the warehouse would be utilized more fully throughout the maintenance process. Based on this idea, they develop the PVM, a parallel view maintenance algorithm which can improve the overall maintenance performance significantly.…”

Section: Related Workmentioning

confidence: 99%