115 research outputs found

    How to Juggle Columns: An Entropy-Based Approach for Table Compression

    Get PDF
    Many relational databases exhibit complex dependencies between data attributes, caused either by the nature of the underlying data or by explicitly denormalized schemas. In data warehouse scenarios, calculated key figures may be materialized or hierarchy levels may be held within a single dimension table. Such column correlations and the resulting data redundancy may result in additional storage requirements. They may also result in bad query performance if inappropriate independence assumptions are made during query compilation. In this paper, we tackle the specific problem of detecting functional dependencies between columns to improve the compression rate for column-based database systems, which both reduces main memory consumption and improves query performance. Although a huge variety of algorithms have been proposed for detecting column dependencies in databases, we maintain that increased data volumes and recent developments in hardware architectures demand novel algorithms with much lower runtime overhead and smaller memory footprint. Our novel approach is based on entropy estimations and exploits a combination of sampling and multiple heuristics to render it applicable for a wide range of use cases. We demonstrate the quality of our approach by means of an implementation within the SAP NetWeaver Business Warehouse Accelerator. Our experiments indicate that our approach scales well with the number of columns and produces reliable dependence structure information. This both reduces memory consumption and improves performance for nontrivial queries

    Spin-state studies with XES and RIXS: From static to ultrafast

    Get PDF
    We report on extending hard X-ray emission spectroscopy (XES) along with resonant inelastic X-ray scattering (RIXS) to study ultrafast phenomena in a pump-probe scheme at MHz repetition rates. The investigated systems include low-spin (LS) Fe-II complex compounds, where optical pulses induce a spin-state transition to their (sub)nanosecond-lived high-spin (HS) state. Time-resolved XES clearly reflects the spin-state variations with very high signal-to-noise ratio, in agreement with HS-LS difference spectra measured at thermal spin crossover, and reference HS-LS systems in static experiments, next to multiplet calculations. The 1s2p RIXS, measured at the Fe Is pre-edge region, shows variations after laser excitation, which are consistent with the formation of the HS state. Our results demonstrate that X-ray spectroscopy experiments with overall rather weak signals, such as RIXS, can now be reliably exploited to study chemical and physical transformations on ultrafast time scales. (C) 2012 Elsevier B.V. All rights reserved

    Observing Solvation Dynamics with Simultaneous Femtosecond X-ray Emission Spectroscopy and X-ray Scattering

    Get PDF
    In liquid phase chemistry dynamic solute–solvent interactions often govern the path, ultimate outcome, and efficiency of chemical reactions. These steps involve many-body movements on subpicosecond time scales and thus ultrafast structural tools capable of capturing both intramolecular electronic and structural changes, and local solvent structural changes are desired. We have studied the intra- and intermolecular dynamics of a model chromophore, aqueous [Fe(bpy)3]2+, with complementary X-ray tools in a single experiment exploiting intense XFEL radiation as a probe. We monitored the ultrafast structural rearrangement of the solute with X-ray emission spectroscopy, thus establishing time zero for the ensuing X-ray diffuse scattering analysis. The simultaneously recorded X-ray diffuse scattering patterns reveal slower subpicosecond dynamics triggered by the intramolecular structural dynamics of the photoexcited solute. By simultaneous combination of both methods only, we can extract new information about the solvation dynamic processes unfolding during the first picosecond (ps). The measured bulk solvent density increase of 0.2% indicates a dramatic change of the solvation shell around each photoexcited solute, confirming previous ab initio molecular dynamics simulations. Structural changes in the aqueous solvent associated with density and temperature changes occur with ∼1 ps time constants, characteristic for structural dynamics in water. This slower time scale of the solvent response allows us to directly observe the structure of the excited solute molecules well before the solvent contributions become dominant

    Precision and accuracy of single-molecule FRET measurements - a multi-laboratory benchmark study

    Get PDF
    Single-molecule Förster resonance energy transfer (smFRET) is increasingly being used to determine distances, structures, and dynamics of biomolecules in vitro and in vivo. However, generalized protocols and FRET standards to ensure the reproducibility and accuracy of measurements of FRET efficiencies are currently lacking. Here we report the results of a comparative blind study in which 20 labs determined the FRET efficiencies (E) of several dye-labeled DNA duplexes. Using a unified, straightforward method, we obtained FRET efficiencies with s.d. between ±0.02 and ±0.05. We suggest experimental and computational procedures for converting FRET efficiencies into accurate distances, and discuss potential uncertainties in the experiment and the modeling. Our quantitative assessment of the reproducibility of intensity-based smFRET measurements and a unified correction procedure represents an important step toward the validation of distance networks, with the ultimate aim of achieving reliable structural models of biomolecular systems by smFRET-based hybrid methods

    City branding as economic necessity

    Get PDF
    Kvalitetno brendiranje grada je preduvjet za njihovu prepoznatljivost, kvalitetno pozicioniranje i stvaranje dodatne vrijednosti. Praksa i mnogobrojni primjeri potvrđuju ispravnost ove teze. Brendiranje gradova je nužno kako bi se pojačala konkurentnost, ostvarila veća dobit i osigurao razvoj mjesta. No ne radi se samo o ekonomskim kategorijama jer se pod razvojem mjesta podrazumijevaju i pozitivna demografska kretanja, obogaćivanje kulturnih sadržaja kao i drugih činitelja koji podižu ukupnu kvalitetu života. Izazov je to i nužnost i za gradove u Hrvatskoj kako bi bili konkurentni u oštroj tržišnoj konkurenciji.Quality city branding is a precondition for their recognazibility, quality positionig and creating of added value. Practice and numerous examples confirm correction of this theses. City branding is necessary to enhance concurence, gain bigger profit and ensure place development. But this is not only about economic categories because under place development it is understandable alsto positive demographic movement, enrichment of cultural contens as well as other factors which raise total quality of life. This is as well a challenge as it is a necessity for cities in Croatia so they could be concurente in harsh economy concurence

    EuReCa ONE—27 Nations, ONE Europe, ONE Registry A prospective one month analysis of out-of-hospital cardiac arrest outcomes in 27 countries in Europe

    Get PDF
    AbstractIntroductionThe aim of the EuReCa ONE study was to determine the incidence, process, and outcome for out of hospital cardiac arrest (OHCA) throughout Europe.MethodsThis was an international, prospective, multi-centre one-month study. Patients who suffered an OHCA during October 2014 who were attended and/or treated by an Emergency Medical Service (EMS) were eligible for inclusion in the study. Data were extracted from national, regional or local registries.ResultsData on 10,682 confirmed OHCAs from 248 regions in 27 countries, covering an estimated population of 174 million. In 7146 (66%) cases, CPR was started by a bystander or by the EMS. The incidence of CPR attempts ranged from 19.0 to 104.0 per 100,000 population per year. 1735 had ROSC on arrival at hospital (25.2%), Overall, 662/6414 (10.3%) in all cases with CPR attempted survived for at least 30 days or to hospital discharge.ConclusionThe results of EuReCa ONE highlight that OHCA is still a major public health problem accounting for a substantial number of deaths in Europe.EuReCa ONE very clearly demonstrates marked differences in the processes for data collection and reported outcomes following OHCA all over Europe. Using these data and analyses, different countries, regions, systems, and concepts can benchmark themselves and may learn from each other to further improve survival following one of our major health care events
    corecore