A utilização de dados públicos abertos na construção de um Data Warehouse : a construção de um repositório estatísticas educacionais públicas brasileiras

Project Work presented as the partial requirement for obtaining a Master's degree in Information Management, specialization in Knowledge Management and Business IntelligenceNa última década, diferentes países têm desenvolvido iniciativas relacionadas à divulgação de dados governamentais de forma aberta. Apesar da existência e disponibilização das bases de dados, a tarefa de utilização e extração de conhecimento dessas bases ainda apresenta alguns desafios, relacionados a à integração e à compatibilização das informações. Isso ocorre devido à baixa estruturação e a grande heterogeneidade das fontes, que faz com que as abordagens tradicionais de extração transformação e carga (ETL) tornem-se menos eficientes. Esse trabalho busca analisar uma abordagem de construção de um repositório de dados abertos baseada na estrutura dos arquivos unidimensionais (flat files), que possibilite a construção dos modelos dimensionais de forma mais eficiente.In the last decade, different countries have developed initiatives related to the dissemination of open data. Despite the existence and availability of databases, the task of using this data and knowledge extraction still presents some challenges related to the integration and compatibility of information. This occurs due to both poor-structure and a great heterogeneity of sources, which make traditional extraction, transformation, and loading (ETL) approach less efficient. This manuscript analyzes an approach for the construction of open data repository based on a flat files structure that enables a more efficient dimensional model building

The first confirmation of V-type asteroids among the Mars crosser population

The Mars crossing region constitutes a path to deliver asteroids from the Inner Main Belt to the Earth crossing space. While both the Inner Main Belt and the population of Earth crossing asteroids contains a significant fraction of asteroids belonging to the V taxonomic class, only two of such V-type asteroids has been detected in the Mars crossing region up to now. In this work, we searched for asteroids belonging to the V class among the population of Mars crossing asteroids, in order to support alternative paths to the delivery of this bodies into the Earth crossing region. We selected 18 candidate V-type asteroids in the Mars crossing region using observations contained in the Sloan Digital Sky Survey Moving Objects Catalog. Then, we observed 4 of these candidates to take their visible spectra using the Southern Astrophysical Research Telescope (SOAR). We also performed the numerical simulation of the orbital evolution of the observed asteroids. We confirmed that 3 of the observed asteroids belong to the V class, and one of these may follow a path that drives it to an Earth collision in some tens of million years

Inhomogeneities on the surface of 21 Lutetia, the asteroid target of the Rosetta mission

CONTEXT: In July 2010 the ESA spacecraft Rosetta will fly-by the main belt asteroid 21 Lutetia. Several observations of this asteroid have been so far performed, but its surface composition and nature are still a matter of debate. For long time Lutetia was supposed to have a metallic nature due to its high IRAS albedo. Later on it has been suggested to have a surface composition similar to primitive carbonaceous chondrite meteorites, while further observations proposed a possible genetic link with more evolved enstatite chondrite meteorites. AIMS: In order to give an important contribution in solving the conundrum of the nature of Lutetia, in November 2008 we performed visible spectroscopic observations of this asteroid at the Telescopio Nazionale Galileo (TNG, La Palma, Spain). METHODS: Thirteen visible spectra have been acquired at different rotational phases. RESULTS: We confirm the presence of a narrow spectral feature at about 0.47-0.48 micron already found by Lazzarin et al. (2009) on the spectra of Lutetia. We also find a spectral feature at about 0.6 micron, detected by Lazzarin et al. (2004) on one of their Lutetia's spectra. More importantly, our spectra exhibit different spectral slopes between 0.6 and 0.75 micron and, in particular, we found that up to 20% of the Lutetia surface could have flatter spectra. CONCLUSIONS: We detected a variation of the spectral slopes at different rotational phases that could be interpreted as possibly due to differences in the chemical/mineralogical composition, as well as to inhomogeneities of the structure of the Lutetia's surface (e.g., the presence of craters or albedo spots) in the southern hemisphere.Comment: 3 pages, 2 figures. Accepted for publication in Astronomy and Astrophysics. Updated on 25 March 2010

Heating of near-Earth objects and meteoroids due to close approaches to the Sun

It is known that near-Earth objects (NEOs) during their orbital evolution may often undergo close approaches to the Sun. Indeed it is estimated that up to ~70% of them end their orbital evolution colliding with the Sun. Starting from the present orbital properties, it is possible to compute the most likely past evolution for every NEO, and to trace its distance from the Sun. We find that a large fraction of the population may have experienced in the past frequent close approaches, and thus, as a consequence, a considerable Sun-driven heating, not trivially correlated to the present orbits. The detailed dynamical behaviour, the rotational and the thermal properties of NEOs determine the exact amount of the resulting heating due to the Sun. In the present paper we discuss the general features of the process, providing estimates of the surface temperature reached by NEOs during their evolution. Moreover, we investigate the effects of this process on meteor-size bodies, analyzing possible differences with the NEO population. We also discuss some possible effects of the heating which can be observed through remote sensing by ground-based surveys or space missions.Comment: 8 pages, 5 figures, accepted by MNRA

Taxonomy of asteroid families among the Jupiter Trojans: Comparison between spectroscopic data and the Sloan Digital Sky Survey colors

We present a comparative analysis of the spectral slope and color distributions of Jupiter Trojans, with particular attention to asteroid families. We use a sample of data from the Moving Object Catalogue of the Sloan Digital Sky Survey, together with spectra obtained from several surveys. A first sample of 349 observations, corresponding to 250 Trojan asteroids, were extracted from the Sloan Digital Sky Survey, and we also extracted from the literature a second sample of 91 spectra, corresponding to 71 Trojans. The spectral slopes were computed by means of a least-squares fit to a straight line of the fluxes obtained from the Sloan observations in the first sample, and of the rebinned spectra in the second sample. In both cases the reflectance fluxes/spectra were renormalized to 1 at 6230 $\textrm{\AA}$. We found that the distribution of spectral slopes among Trojan asteroids shows a bimodality. About 2/3 of the objects have reddish slopes compatible with D-type asteroids, while the remaining bodies show less reddish colors compatible with the P-type and C-type classifications. The members of asteroid families also show a bimodal distribution with a very slight predominance of D-type asteroids, but the background is clearly dominated by the D-types. The L4 and L5 swarms show different distributions of spectral slopes, and bimodality is only observed in L4. These differences can be attributed to the asteroid families since the backgraound asteroids show the same slope distribtuions in both swarms. The analysis of individual families indicates that the families in L5 are taxonomically homogeneous, but in L4 they show a mixture of taxonomic types. We discuss a few scenarios that might help to interpret these results.Comment: 20 pages, 15 figures, 2 table

Taxonomic classification of asteroids based on MOVIS near-infrared colors

We aim to provide a taxonomic classification for asteroids observed by VISTA-VHS survey. We derive a method for assigning a compositional type to an object based on its (Y-J), (J-Ks), and (H-Ks) colors. We present a taxonomic classification for 18\,265 asteroids from the MOVIS catalog, using a probabilistic method and the k-nearest neighbors algorithm. Because our taxonomy is based only on NIR colors, several classes from Bus-DeMeo were clustered into groups and a slightly different notation was used (i.e. the superscript indicates that the classification was obtained based on the NIR colors and the subscript indicates possible miss-identifications with other types). Our results are compared with the information provided by the Sloan Digital Sky Survey (SDSS) and Wide-field Infrared Survey Explorer (WISE). The two algorithms used in this study give a taxonomic type for all objects having at least (Y-J) and (J-Ks) observed colors. A final classification is reported for a set of 6\,496 asteroids based on the criteria that KNN and probabilistic algorithms gave the same result, (Y-J)$_{err}\leq$ 0.118 and (J-Ks)$_{err}\leq$0.136. This set includes 144 bodies classified as $B_k^{ni}$, 613 as $C^{ni}$, 197 as $C_{gx}^{ni}$, 91 as $X_t^{ni}$, 440 as $D_s^{ni}$, 665 as $K_l^{ni}$, 233 as $A_d^{ni}$, 3\,315 as $S^{ni}$, and 798 as $V^{ni}$. We report the albedo distribution for each taxonomic group and we compute new median values for the main types. We found that V-type and A-type candidates have identical size frequency distributions, but the V-types are five times more common than the A-types. Several particular cases, such as the A-type asteroid (11616) 1996 BQ2 and the S-type (3675) Kematsch, both in the Cybele population, are discussed. Files and codes available at: https://github.com/marcelpopescu/MOVIS-TaxonomyComment: 18 pages, 10 figures, accepted for publication in Astronomy & Astrophysics (A&A

Asteroid target selection for the new Rosetta mission baseline: 21 Lutetia and 2867 Steins

Reproduced with permission. Copyright ESO. Article published by EDP Sciences and available at http://www.aanda.org.International audienceThe new Rosetta mission baseline to the comet 67P/Churyumov-Gerasimenko includes two asteroid fly-bys. To help in target selection we studied all the candidates of all the possible scenarios. Observations have been carried out at ESO-NTT (La Silla, Chile), TNG (Canaries), and NASA-IRTF (Hawaii) telescopes, in order to determine the taxonomy of all the candidates. The asteroid targets were chosen after the spacecraft interplanetary orbit insertion manoeuvre, when the available total amount of ΔV was known. On the basis of our analysis and the available of ΔV, we recommended to the ESA ScienceWorking Group the asteroids 21 Lutetia and 2867 Steins as targets for the Rosetta mission. The nature of Lutetia is still controversial. Lutetia's spectral properties may be consistent with a composition similar to carbonaceous chondrite meteorites. The spectral properties of Steins suggest a more extensive thermal history. Steins may have a composition similar to relatively rare enstatite chondrite/achondrite meteorites