ChunkSim

Author(s):  
Pedro Furtado

Self-tuning physical database organization involves tools that determine automatically the best solution concerning partitioning, placement, creation and tuning of auxiliary structures (e.g. indexes), based on the workload. To the best of our knowledge, no tool has focused on a relevant issue in parallel databases and in particular data warehouses running on common off-the-shelf hardware in a sharednothing configuration: determining the adequate tradeoff for balancing load and availability with costs (storage and loading costs). In previous work, we argued that effective load and availability balancing over partitioned datasets can be obtained through chunk-wise placement and replication, together with on-demand processing. In this work, we propose ChunkSim, a simulator for system size planning, performance analysis against replication degree and availability analysis. We apply the tool to illustrate the kind of results that can be obtained by it. The whole discussion in the chapter provides very important insight into data allocation and query processing over shared-nothing data warehouses and how a good simulation analysis tool can be built to predict and analyze actual systems and intended deployments.

2020 ◽  
pp. 1-14
Author(s):  
Miquel Estrada ◽  
Josep Maria Salanova ◽  
Marcos Medina-Tapia ◽  
Francesc Robusté

2003 ◽  
Vol 15 (11-12) ◽  
pp. 1001-1025 ◽  
Author(s):  
Hong-Linh Truong ◽  
Thomas Fahringer

2018 ◽  
Vol 2018 ◽  
pp. 1-26 ◽  
Author(s):  
Gang Zhou ◽  
Lei Qiu ◽  
Wenzheng Zhang ◽  
Jiao Xue

The aim of this paper was to develop a model that can characterize the actual micropore structures in coal and gain an in-depth insight into water’s seepage rules in coal pores under different pressure gradients from a microscopic perspective. To achieve this goal, long-flame coals were first scanned by an X-ray 3D microscope; then, through a representative elementary volume (REV) analysis, the optimal side length was determined to be 60 μm; subsequently, by using Avizo software, the coal’s micropore structures were acquired. Considering that the porosity varies in the same coal sample, this study selected four regions in the sample for an in-depth analysis. Moreover, numerical simulations on water’s seepage behaviors in coal under 30 different pressure gradients were performed. The results show that (1) the variation of the simulated seepage velocity and pressure gradient accorded with Forchheimer’s high-velocity nonlinear seepage rules; (2) the permeability did not necessarily increase with the increase of the effective porosity; (3) in the same model, under different pressure gradients, the average seepage pressure decreased gradually, while the average seepage velocity and average mass flow varied greatly with the increase of the seepage length; and (4) under the same pressure gradient, the increase of the average mass flow from the inlet to the outlet became more significant under a higher inlet pressure.


2022 ◽  
Vol 14 (2) ◽  
pp. 896
Author(s):  
Vítor Gouveia ◽  
João P. Duarte ◽  
Hugo Sarmento ◽  
José Freitas ◽  
Ricardo Rebelo-Gonçalves ◽  
...  

Set pieces are important for the success of football teams, with the corner kick being one of the most game defining events. The aim of this research was twofold: (1) to analyze the corner kicks of a senior football amateur team, and (2) to compare the corner kicks of successful and unsuccessful teams (of the 2020/21 sporting season). In total, 500 corners were observed using a bespoke notational analysis tool, using a specific observational instrument tool (8 criteria; 25 categories). Out of the 500 corner kicks, 6% resulted in a goal. A greater number of direct corners using inswing trajectories were performed (n = 54%). Corners were delivered to central and front post areas most frequently (n = 79%). Five attackers were most predominantly used for offensive corners (n = 58%), but defenders won the ball more frequently (n = 44%). Attempts at goal occurred following a corner most commonly from outside of the box (n = 7%). Goals were scored most frequently with the foot (n = 16%) and head (n = 15%). Successful teams are more effective at reaching the attackers and score more goals directly from corners. Unsuccessful teams deliver more corner kicks out of play, the first touch is more frequently from the opposition defenders, and fewe goals are scored from corner kicks. The study provides an insight into the determining factors and patterns that influence corner kicks and success in football matches. This information should be used by coaches to prepare teams for both offensive and defensive corner kicks to increase team success and match outcomes.


Sign in / Sign up

Export Citation Format

Share Document