Wyniki wyszukiwania - BazTech

1

Porównanie możliwości procesów ETL w hurtowniach danych Oracle i Microsoft

Staszak Z., Ochnik P.

Prace Naukowe Instytutu Informatyki Politechniki Wrocławskiej

|

2009

|

Nr 10

9-32

PL

W pracy przedstawiono wybrane zagadnienia dotyczące hurtowni danych i, związanych z nimi, procesów ETL. Pierwsza część pracy opisuje zagadnienia teoretyczne takie jak architektura hurtowni oraz reprezentacja danych. Druga część pracy to opis zagadnień praktycznych związanych z hurtowniami danych i procesami ETL. Przedstawiono w niej rozpoznane mechanizmy ETL oraz wybrane dedykowane im narzędzia programistyczne w badanych SZBD Oracle 10g i Microsoft SQL Server 2005. Wszystkie rozpoznane mechanizmy zostały zaimplementowane w testowej hurtowni danych zrealizowanej w obu środowiskach. Zbadano ich działanie i możliwości. Praca zakończona jest wnioskami z przeprowadzonych badań.

EN

This paper describes the issues of data warehouse and associated with them ETL-process. The first part of the work describes the theoretical issues such as warehouese architecture and data representation. The second part of the job is related to the pratcical issues associated wih the warchouses and ETL mechanisms and dedicated them programming tiils in tested SZBD Orcale 10g and Microsoft SQL Server 2005 were there presented. All the mechanisms have been implemented in both environments for test data warehouse. They possibilities and operation were examined. The works is completed with the conclusions of the tests.

2

Spectroscopic Investigation of Electronic States of the CrO42 Ion in the Visible and Ultraviolet Absorption Region

Staszak Z., Wojciechowska A., Cieślak-Golonka M.

Polish Journal of Chemistry

|

2009

|

Vol. 83, nr 3

503-513

EN

Low temperature electronic spectra of potassium chromate: pure K2CrO 4 single crystal and the 1:20 solid solution of K2CrO 4 in K2SO4 have been analyzed in detail using filtration and deconvolution methods. The 14000-19000 cm-1 spectral region of crystal has been found to contain extremely low intensity bands which have been assigned to spin and symmetry forbidden CrO charge transfer (CT) transitions. Surprisingly, the whole solid solution spectrum in the 19000-50000 cm-1 energy range was found to be composed exclusively from vibronic transitions with the coupled n1 Cr-O mode.

3

Porównanie możliwości tworzenia aktywnych baz danych w szbd oracle i microsoft sql server

Staszak Z., Jasiński D.

Prace Naukowe Instytutu Informatyki Stosowanej Politechniki Wrocławskiej

|

2008

|

Nr 9

57-82

PL

Praca w pierwszej części prezentuje zagadnienia teoretyczne związane z aktywnymi bazami danych. W drugiej części przedstawione są mechanizmy tworzenia takich baz w SZBD Oracle lig i Microsoft SQL Server 2005. W kolejnej części przeprowadzone jest porównanie tych mechanizmów w obu SZBD. Analiza porównawcza przeprowadzona jest na podstawie testów, którym poddana została przykładowa aktywna baza danych zaimplementowana w obu SZBD. Na zakończenie przedstawiono wnioski.

EN

The first part of this dissertation presents theoretical issues relevant with active databases. The second part describes mechanisms of creating these databases in Oracle llg and Microsoft SQL Server 2005 DBMS. The next part presents comparison of these mechanisms in both environments. Comparative analysis is made on the basis of tests which were done on an exemplary active database implemented in both environments. The dissertation ends by presenting conclusions.

4

One-, Two- and Non-Coordinated Cr02- 4 Entity in the Nickel(II) Complexes. Structural and Spectroscopic Investigation

Pietraszko A., Bronowska W., Wojciechowska A., Staszak Z., Cieślak-Golonka M.

Polish Journal of Chemistry

|

2002

|

Vol. 76 / nr 2-3

309-324

EN

A systematic investigation of the chromate ion in [Ni(II)-(2,2_-bpy)-CrO4 2_ ] systems has been carried out. The effect of the Ni(II) ion and the organic ligand on the mode of the chromate position in the [Ni(bpy)3]CrO4_7.5H2O(1), [Ni(bpy)2(OCrO3)(H2O)]_5H2O(2) and catena-(ž-CrO4-O,O_)[Ni(bpy)(H2O)2]_2H2O (3) complexes has been shown. [Ni(bpy)3]CrO4_7.5H2O crystals (1) have a monoclinic symmetry with space group C2/c and 8 chemical units, forming a unit cell with a = 13.641(3) A, b = 22.939(5) A, c = 23.351(5) A and _ = 104.69(3) deg, whereas the [Ni(bpy)2(OCrO3)(H2O)]_5H2O crystals (2) have a monoclinic symmetry with space group P21/c and 4 chemical units per unit cell with a = 10.854(2) A, b = 22.665(5) A, c = 10.623(2) A and _ = 108.93(3) deg at room temperature. The chromate ion in 1 is not coordinated to the nickel(II) ion. The geometry around the Cr(VI) atom is pseudotetrahedral. Untypical for the chromate ion monodentate coordination has been found in the complex [Ni(bpy)2(OCrO3)(H2O)]_5H2O. The chromate position has been also elucidated from the digitally resolved IR spectra. The coordination of the chromate ion in 2 and 3 was also observed for the single crystal at 4K, in reflectance and solution electronic spectra through the appearance of a new transition at ca. 15000 cm-1. The full characterization of the chromophores present in the complexes: NiN6, NiN4O2, NiN2O4 and NiO6 have been obtained on the basis of the detailed analysis of the electronic spectra at 4K(Gaussian deconvolution followed by digital filtration).

5

Reactivity of cis-Diaminedichloroplatinum(II) (cis-Platin) Toward Chromium(IV)

Stawińska J., Staszak Z., Jezierska J., Cieślak-Golonka M., Daszkiewicz M.

Polish Journal of Chemistry

|

2000

|

Vol. 74, nr 3

291-301

EN

The interaction of Cr(VI) compounds: K2Cr2O7 with cis-diaminedichlorplatinum(II) (cis-Platin) has been studied spectroscopically (UV-VIS, IR, FIR, ESR). It was found that the redox processes took place with the precipiation of brown Pt(IV)-Cr(III) heteropolynuclear products. The deconvolution of the electronic spectra allowed the analysis in convention of independent Pt(IV) and Cr(III) crystal fields.