TOPYDE: A Tool for Physical Database Design

We describe a tool for physical database design based on a combination of theoretical and pragmatic approaches. The tool takes as input a relational schema, the workload defined on the schema, and some additional database characteristics and produces as output a physical schema. For the time being, the tool is tuned towards Ingres

On the selection of secondary indices in relational databases

An important problem in the physical design of databases is the selection of secondary indices. In general, this problem cannot be solved in an optimal way due to the complexity of the selection process. Often use is made of heuristics such as the well-known ADD and DROP algorithms. In this paper it will be shown that frequently used cost functions can be classified as super- or submodular functions. For these functions several mathematical properties have been derived which reduce the complexity of the index selection problem. These properties will be used to develop a tool for physical database design and also give a mathematical foundation for the success of the before-mentioned ADD and DROP algorithms

The ALHAMBRA survey: Accurate merger fractions by PDF analysis of photometric close pairs

Our goal is to develop and test a novel methodology to compute accurate close pair fractions with photometric redshifts. We improve the current methodologies to estimate the merger fraction f_m from photometric redshifts by (i) using the full probability distribution functions (PDFs) of the sources in redshift space, (ii) including the variation in the luminosity of the sources with z in both the selection of the samples and in the luminosity ratio constrain, and (iii) splitting individual PDFs into red and blue spectral templates to deal robustly with colour selections. We test the performance of our new methodology with the PDFs provided by the ALHAMBRA photometric survey. The merger fractions and rates from the ALHAMBRA survey are in excellent agreement with those from spectroscopic work, both for the general population and for red and blue galaxies. With the merger rate of bright (M_B <= -20 - 1.1z) galaxies evolving as (1+z)^n, the power-law index n is larger for blue galaxies (n = 2.7 +- 0.5) than for red galaxies (n = 1.3 +- 0.4), confirming previous results. Integrating the merger rate over cosmic time, we find that the average number of mergers per galaxy since z = 1 is N_m = 0.57 +- 0.05 for red galaxies and N_m = 0.26 +- 0.02 for blue galaxies. Our new methodology exploits statistically all the available information provided by photometric redshift codes and provides accurate measurements of the merger fraction by close pairs only using photometric redshifts. Current and future photometric surveys will benefit of this new methodology.Comment: Submitted to A&A, 15 pages, 15 figures, 6 tables. Comments are welcome. Close pair systems available at https://cloud.iaa.csic.es/alhambra/catalogues/ClosePairs