A Data Warehouse Engineering Process

2004 ◽  
pp. 14-23 ◽  
Author(s):  
Sergio Luján-Mora ◽  
Juan Trujillo
Keyword(s):  
Data Warehouse ◽  
Engineering Process

Eliciting Data Warehouse Contents for Policy Enforcement Rules

2014 ◽  
Vol 5 (2) ◽  
pp. 41-69 ◽  
Author(s):  
Deepika Prakash ◽  
Daya Gupta
Keyword(s):  
Data Warehouse ◽  
Requirements Engineering ◽  
Higher Order ◽  
Order Logic ◽  
Policy Enforcement ◽  
Engineering Process ◽  
Higher Order Logic ◽  
Medical Domain ◽  
Motivation Model ◽  
Er Diagram

Data Warehouse requirements engineering has been extensively looked at from the ENDS perspective of the Business Motivation Model, in terms of goals the system to-be wants to achieve. The authors propose that the MEANS perspective of this Model can drive the requirements engineering process. MEANS are organized into business policies and ‘policy enforcement rules'. Starting from policies expressed in a higher order logic, the authors propose an approach to formulate policy enforcement rules. That subset of the set of formulated policy enforcement rules which is most appropriate for the business is to be selected. For this, the information relevant to the rules is to be kept in the Data Warehouse. The authors technique picks up the components of the policy enforcement rule to elicit the information that has a bearing on its selection. The elicited information is represented as an ER diagram. The authors rely on existing methodologies to convert an ER form into star schemas. The authors use the medical domain to illustrate our methodology.

scholarly journals Metodología para el diseño de proyectos de Data Warehouse para el sector minero. Caso de Uso: Camilo Ponce Enríquez, Grupo Empresarial Campoverde

Alternativas ◽  
2019 ◽  
Vol 19 (2) ◽  
pp. 24-35
Author(s):  
Heckler Rothwell Ochoa Caicedo ◽  
Andrés Tello
Keyword(s):  
Project Management ◽  
Data Warehouse ◽  
Engineering Process ◽  
Body Of Knowledge ◽  
Nuevas Tecnologías ◽  
Toma De Decisiones

Según datos del Banco Central del Ecuador en Enero del 2017 se indica que del 100% de la actividad de explotación minera de la provincia del Azuay, el 85% se desarrolla en el Cantón Camilo Ponce Enríquez.  El mercado en que se desarrolla el sector minero posee dos características peculiares (mercado de alto riesgo y alta inversión de capital), por tanto esta industria requiere las condiciones que les permitan potenciar sus actividades y convertirse en una fuente principal para la generación de encadenamientos productivos, lo puede lograr a través de las empresas proveedoras para adquirir nuevos conocimientos, nutrirse de las nuevas tecnologías e innovaciones para mejorar su competitividad. Por tanto, la presente investigación tiene como objetivo desarrollar una metodología para elaborar un data warehouse (DW) orientado al sector minero. La metodología es validada con datos proporcionados por el grupo empresarial Campoverde del cantón Camilo Ponce Enríquez de la provincia del Azuay quienes proveen al sector minero. La metodología acoge como parte del análisis lo planteado por la ISO 21500 (Barato & Sm, 2013) y la norma Project Management Body Of Knowledge (PMBOK) para la gestión de proyectos, la arquitectura del DW y el flujo del trabajo así como también las tareas implícitas en este proceso es un compendio de dos metodologías específicas Data Warehouse Engineering Process (DWEP) y  HEFESTO, además se incorporan varios entregables personales como un aporte para la investigación. El DW resultante se lo emplea para el desarrollo de un sistema que facilite la toma de decisiones a los directivos del grupo empresarial Campoverde, enmarcados en sus objetivos estratégicos.

Template mediated crystal engineering

1994 ◽  
Vol 52 ◽  
pp. 480-481
Author(s):  
Brigid R. Heywood ◽  
S. Champ
Keyword(s):  
Crystal Engineering ◽  
Electrostatic Interactions ◽  
Alkyl Chain ◽  
Crystallographic Axis ◽  
Two Dimensional ◽  
Engineering Process ◽  
Solution Interface ◽  
Extensive Program ◽  
Geometric Homology ◽  
Long Alkyl Chain

Recent work on the crystallisation of inorganic crystals under compressed monomolecular surfactant films has shown that two dimensional templates can be used to promote the oriented nucleation of solids. When a suitable long alkyl chain surfactant is cast on the crystallisation media a monodispersied population of crystals forms exclusively at the monolayer/solution interface. Each crystal is aligned with a specific crystallographic axis perpendicular to the plane of the monolayer suggesting that nucleation is facilitated by recognition events between the nascent inorganic solid and the organic template.For example, monolayers of the long alkyl chain surfactant, stearic acid will promote the oriented nucleation of the calcium carbonate polymorph, calcite, on the (100) face, whereas compressed monolayers of n-eicosyl sulphate will induce calcite nucleation on the (001) face, (Figure 1 & 2). An extensive program of research has confirmed the general principle that molecular recognition events at the interface (including electrostatic interactions, geometric homology, stereochemical complementarity) can be used to promote the crystal engineering process.

RANCANGAN DATA WAREHOUSE PADA SEKOLAH TINGGI TEKNIK POLIPROFESI MEDAN

KURVATEK ◽  
2018 ◽  
Vol 3 (1) ◽  
pp. 63-69
Author(s):  
Siti Jamilah Tarigan ◽  
Wing Wahyu Winarno ◽  
Henderi Safei
Keyword(s):  
Data Warehouse

Pengambilan keputusan dan perencanaan bidang akademik sering kali tidak berdasarkan pada informasi yang lengkap. Jajaran pengambil keputusan (rektorat atau tingkat eksekutif) hanya bisa melihat sebuah data dalam satu dimensi. Pengambil keputusan akan lebih baik jika informasi dapat disajikan dari berbagai dimensi. Perguruan tinggi telah memiliki data operasional yang lengkap dari kegiatan akademik, kepegawaian, dan penerimaan mahasiswa yang telah dikumpulkan lebih dari 4 tahun. Data warehouse adalah suatu koleksi optimasi database untuk mendukung keputusan. Konsep ini mengintegrasikan antara sistem lama dan sistem baru sehingga tidak terjadi duplikasi data. Data yang telah diintegrasikan dapat diolah dalam berbagai bentuk laporan sesuai dengan kebutuhan.Tujuan dari penelitian ini adalah bagaimana data yang ada bisa menghasilkan informasi yang akurat dan multidimensi sehingga pengambilan keputusan lebih cepat dan akurat. Penelitian ini menggunakan analisis data OLAP, dan skema bintang. Kesimpulan dari penelitian ini adalah rancangan yang dihasilkan bisa membantu pihak akademik dalam membuat keputusan berdasarkan data dan informasi yang mulitidimensi.

Data Warehouse Development Based on Cloud Computing Using IBM Informix and IBM Cognos for Multifinance Industry

2016 ◽  
Vol 11 (9) ◽  
pp. 804
Author(s):  
Dion Darmawan ◽  
Chrissandy Fernando ◽  
Andree Gunawan ◽  
Julian Ivandi
Keyword(s):  
Cloud Computing ◽  
Data Warehouse

USE OF AN ELECTRONIC DATA WAREHOUSE TO ENHANCE CARDIAC SURGICAL SITE SURVEILLANCE AT A LARGE CANADIAN CENTRE

2008 ◽  
Vol 31 (4) ◽  
pp. 21 ◽  
Author(s):  
G W Rose ◽  
V R Roth ◽  
K N Suh ◽  
M Taljaard ◽  
C Van Walraven ◽  
...  
Keyword(s):  
Infection Control ◽  
Surgical Site Infection ◽  
Data Warehouse ◽  
Stepwise Logistic Regression ◽  
Site Infection ◽  
Electronic Data ◽  
Trigger Mechanism ◽  
Trigger Tool ◽  
Infection Surveillance ◽  
Trigger Mechanisms

Background/Purpose: Surgical site infection surveillance to determineincidence is a key infection control activity. Case detection is labour-intensive, therefore most infection control programs use manual or simple electronic mechanisms to “trigger” chart review. However, such “trigger” mechanisms are also labour-intensive, and often of poor specificity. Our objective is to develop a complex trigger mechanism using data from an electronic data warehouse, to improve specificity of surveillance of surgical site infection compared to current trigger mechanisms. Methods: We will derive an electronic trigger tool for cardiac surgical site infection surveillance using a nested case-control design, among a cohort of all patients undergoing coronary artery bypass grafting, cardiac valve repairor replacement, or heart transplant at the University of Ottawa Heart Institute, from July 1 2004 to June 30 2007. We will perform a systematic literature review to identify potential trigger factors to include in the model, then construct the trigger tool by backwards stepwise logistic regression. The best-fit model will be used to calculate the probability of surgical site infection. We will select the threshold probability to use in surveillance by visual inspection of receiver-operator-characteristic curves. The accuracy of this electronic trigger mechanism will be compared to pre-existing manual and simple electronic mechanisms using relative true positive ratios and relative false positive ratios. Results/Conclusions: We have selected 200 cases of surgical site infection and 541 controls from among 3744 procedures performed during the study period. As of the date ofthis abstract we are still undertaking the systematic review.

Sign in / Sign up

Export Citation Format

Share Document