Task clustering on ETL systems – A pattern-oriented approach

Usually, data warehousing populating processes are data-oriented workflows composed by dozens of granular tasks that are responsible for the integration of data coming from different data sources. Specific subset of these tasks can be grouped on a collection together with their relationships in order to form higher- level constructs. Increasing task granularity allows for the generalization of processes, simplifying their views and providing methods to carry out expertise to new applications. Well-proven practices can be used to describe general solutions that use basic skeletons configured and instantiated according to a set of specific integration requirements. Patterns can be applied to ETL processes aiming to simplify not only a possible conceptual representation but also to reduce the gap that often exists between two design perspectives. In this paper, we demonstrate the feasibility and effectiveness of an ETL pattern-based approach using task clustering, analyzing a real world ETL scenario through the definitions of two commonly used clusters of tasks: a data lookup cluster and a data conciliation and integration cluster.

Project management under uncertainty: a study on solution methods

Project Management involves onetime endeavors that demand for getting it right the first time. On the other hand, project scheduling, being one of the most modeled project management process stages, still faces a wide gap from theory to practice. Demanding computational models and their consequent call for simplification, divert the implementation of such models in project management tools from the actual day to day project management process. Special focus is being made to the robustness of the generated project schedules facing the omnipresence of uncertainty. An "easy" way out is to add, more or less cleverly calculated, time buffers that always result in project duration increase and correspondingly, in cost. A better approach to deal with uncertainty seems to be to explore slack that might be present in a given project schedule, a fortiori when a non-optimal schedule is used. The combination of such approach to recent advances in modeling resource allocation and scheduling techniques to cope with the increasing flexibility in resources, as can be expressed in "Flexible Resource Constraint Project Scheduling Problem" (FRCPSP) formulations, should be a promising line of research to generate more adequate project management tools. In reality, this approach has been frequently used, by project managers in an ad-hoc way.

A novel and efficient approach to new N3-substituted-6,8-diaminopurines

[Excerpt] Purine nucleobases are fundamental biochemicals in living organisms. They have been a valuable inspiration for drug design once they play several key roles in the cell.1 To the best of our knowledge, reported routes to 8-aminopurines are still scarce due to the difficulty in introducing amino groups in this position of the purine ring. Here we report a novel, inexpensive and facile synthetic method to generate N3,N6-disubstituted-6,8-diaminopurines. In our research group, a number of substituted purines have been obtained from a common imidazole precursor, the 5-amino-4-cyanoformimidoyl imidazole 1. Recently, a comprehensive study on the reactivity of imidazoles 1 with nucleophiles under acidic conditions led us to develop experimental methods to incorporate primary amines into the cyanoformimidoyl group.2 (...)

An algorithmic approach to estimating the minimal number of periodic points for smooth self-maps of simply-connected manifolds

For a given self-map f of M, a closed smooth connected and simply-connected manifold of dimension m ≥ 4, we provide an algorithm for estimating the values of the topological invariant Dm r [f], which equals the minimal number of r-periodic points in the smooth homotopy class of f. Our results are based on the combinatorial scheme for computing Dm r [f] introduced by G. Graff and J. Jezierski [J. Fixed Point Theory Appl. 13 (2013), 63–84]. An open-source implementation of the algorithm programmed in C++ is publicly available at http://www.pawelpilarczyk.com/combtop/.

Transanal total mesorectal excision: a pure NOTES approach for selected patients.

Transanal total mesorectal excision: a pure NOTES approach for selected patients.

A linear algebra approach to OLAP

Inspired by the relational algebra of data processing, this paper addresses the foundations of data analytical processing from a linear algebra perspective. The paper investigates, in particular, how aggregation operations such as cross tabulations and data cubes essential to quantitative analysis of data can be expressed solely in terms of matrix multiplication, transposition and the Khatri–Rao variant of the Kronecker product. The approach offers a basis for deriving an algebraic theory of data consolidation, handling the quantitative as well as qualitative sides of data science in a natural, elegant and typed way. It also shows potential for parallel analytical processing, as the parallelization theory of such matrix operations is well acknowledged.

Current and previous eating practices among women recovered from anorexia nervosa: a qualitative approach

OBJECTIVE: The aim of this study was to analyze qualitatively how women, who have recovered from anorexia nervosa, perceive and describe their current eating practices, as well as the ones developed during the eating disorder period. METHODS: Seven women were interviewed individually with the objective of investigating their eating practices, transition phases and all relevant aspects that somewhat contributed to the habit-forming; experiences, feelings and perceptions related to mealtime and the influence that food has had over the present subjects' life. The interviews were analyzed by the discourse of the collective subject method. RESULTS: The results brought up the following topics: a) control; b) concerns and feelings; c) deprivation d) beauty dictatorship; e) eating competence; f) importance of food; g) food cacophony. CONCLUSIONS: What stands out is a multiplicity of eating practices, which during the eating disorder were similar to and characterized by restriction; however, after recovery, part of the subjects seem to have developed a higher eating competence, whereas others show a practice similar to the one acquired during the anorexia nervosa, such as the difficulty in realizing when they are satisfied and a feeling of discomfort when facing social interactions.

A 3D computer assisted Orthopedic Surgery Planning approach based on planar radiography

Dissertação de mestrado integrado em Engenharia Biomédica (área de especialização em Informática Médica)

Methods to solve the equations of motion

"Series title: Springerbriefs in applied sciences and technology, ISSN 2191-530X"

Integration methods in dynamic analysis

"Series title: Springerbriefs in applied sciences and technology, ISSN 2191-530X"

Therapeutic approach to patients complaining of high blood pressure in a cardiological emergency room

OBJECTIVE: To evaluate the management of patients complaining of high blood pressure (BP) in a cardiological emergency room. METHODS: Patients referred to the cardiological emergency room with the main complaint of high blood pressure were consecutively selected. The prescriptions and the choice of antihypertensive drugs were assessed. The classification of these patients as hypertensive emergencies or pseudoemergencies, according to the physician who provided initial care, was recorded. RESULTS: From a total of 858 patients presenting to the emergency room, 80 (9.3%) complained of high BP, and 61 (76.3%) received antihypertensive drugs. Sublingual nifedipine was the most commonly used drug (59%). One patient received intravenous medication, one patient was hospitalized and 6 patients (7.5%) were classified as hypertensive emergencies or pseudoemergencies. CONCLUSION: High BP could seldom be classified as a hypertensive emergency or pseudoemergency, even though it was a frequent complaint (9.3% of visits). Currently, the therapeutic approach is not recommended, even in specialized clinics.

Chest pain in the emergency room. Importance of a systematic approach

OBJECTIVE: To evaluate the efficiency of a systematic diagnostic approach in patients with chest pain in the emergency room in relation to the diagnosis of acute coronary syndrome (ACS) and the rate of hospitalization in high-cost units. METHODS: One thousand and three consecutive patients with chest pain were screened according to a pre-established process of diagnostic investigation based on the pre-test probability of ACS determinate by chest pain type and ECG changes. RESULTS: Of the 1003 patients, 224 were immediately discharged home because of no suspicion of ACS (route 5) and 119 were immediately transferred to the coronary care united because of ST elevation or left bundle-branch block (LBBB) (route 1) (74% of these had a final diagnosis of acute myocardial infarction [AMI]). Of the 660 patients that remained in the emergency room under observation, 77 (12%) had AMI without ST segment elevation and 202 (31%) had unstable angina (UA). In route 2 (high probability of ACS) 17% of patients had AMI and 43% had UA, whereas in route 3 (low probability) 2% had AMI and 7 % had UA. The admission ECG has been confirmed as a poor sensitivity test for the diagnosis of AMI ( 49%), with a positive predictive value considered only satisfactory (79%). CONCLUSION: A systematic diagnostic strategy, as used in this study, is essential in managing patients with chest pain in the emergency room in order to obtain high diagnostic accuracy, lower cost, and optimization of the use of coronary care unit beds.

A new surgical approach for treating dilated cardiomyopathy with mitral regurgitation

OBJECTIVE: To evaluate the early outcome of mitral valve prostheses implantation and left ventricular remodeling in 23 patients with end-stage cardiomyopathy and secondary mitral regurgitation (NYHA class III and IV). METHODS: Mitral valvular prosthesis implantation with preservation of papillary muscles and chordae tendinae, and plasty of anteriun cuspid for remodeling of the left ventricle. RESULTS: The surgery was performed in 23 patients, preoperative ejection fraction (echocardiography) varied from 13% to 44% (median: 30%). In 13 patients associated procedures were performed: myocardial revascularization (9), left ventricle plicature repair (3) and aortic prosthese implantation (1). Early deaths (2) occurred on the 4th PO day (cardiogenic shock) and on the 20th PO day (upper gastrointestinal bleeding), and a late death in the second month PO (ventricular arrhythmia). Improvement occurred in NYHA class in 82.6% of the patients (P<0.0001), with a survival rate of 86.9% (mean of 8.9 months of follow-up). CONCLUSION: This technique offers a promising therapeutic alternative for the treatment of patients in refractory heart failure with cardiomyopathy and secondary mitral regurgitation.

Transradial approach for coronary interventions

OBJECTIVE: To assess the feasibility and safety of coronary interventions performed through the radial artery. METHODS: We studied 103 patients with ages from 38 to 86 years (57±8.7), 90 (87%) males, and: radial pulse with a good amplitude, presence of ulnar pulse, a good collateral flow through the palmar arch assessed with the Allen's test. RESULTS: The vascular approach was obtained in 97 (94%) patients, 88 (91%) treated electively and 9 (9%) during acute myocardial infarction, for primary angioplasty; 56 (64%) unstable angina; 22 (25%) stable angina; 10 (11%) were asymptomatic, 6 referred for recanalization of chronic occlusion and 4 silent ischemia in the first week after acute myocardial infarction. We approached 107 arteries: anterior descending artery, 49 (46%); right coronary artery, 27 (25%); circumflex artery, 25 (23%); diagonal artery, 6 (6%); and 2 saphenous vein bypass grafts. We treated 129 lesions: 80 (62%) B2 type; 23 (18%) B1 type; 17 (13%) C type; and 9 (7%). A type. There were 70 stents , and 59 balloon angioplasties performed. Thirty-two (33%) patients used GP IIb/IIIa inhibitors. The mean duration of the elective procedure was 42.3±12.8 min. Success, correct stent deployment and residual lesion <20%, was reached in 100% of the lesions treated with stent implantation; arterial dilation with residual lesion <50% was obtained in 96% of the lesions treated with transluminal coronary angioplasty (TCA). Complications, were: 1 (1.0%) non-Q-wave acute myocardial infarction; 2 (2%) hematomas in the forearm; and 2 losses of radial pulse. CONCLUSION: Radial artery aproach is practical and safe for percutaneous coronary interventions there was a low incidence of complications.

Implications of the Hemodynamic Optimization Approach Guided by Right Heart Catheterization in Patients with Severe Heart Failure

OBJECTIVE: To report the hemodynamic and functional responses obtained with clinical optimization guided by hemodynamic parameters in patients with severe and refractory heart failure. METHODS: Invasive hemodynamic monitoring using right heart catheterization aimed to reach low filling pressures and peripheral resistance. Frequent adjustments of intravenous diuretics and vasodilators were performed according to the hemodynamic measurements. RESULTS: We assessed 19 patients (age = 48±12 years and ejection fraction = 21±5%) with severe heart failure. The intravenous use of diuretics and vasodilators reduced by 12 mm Hg (relative reduction of 43%) pulmonary artery occlusion pressure (P<0.001), with a concomitant increment of 6 mL per beat in stroke volume (relative increment of 24%, P<0.001). We observed significant associations between pulmonary artery occlusion pressure and mean pulmonary artery pressure (r=0.76; P<0.001) and central venous pressure (r=0.63; P<0.001). After clinical optimization, improvement in functional class occurred (P< 0.001), with a tendency towards improvement in ejection fraction and no impairment to renal function. CONCLUSION: Optimization guided by hemodynamic parameters in patients with refractory heart failure provides a significant improvement in the hemodynamic profile with concomitant improvement in functional class. This study emphasizes that adjustments in blood volume result in imme-diate benefits for patients with severe heart failure.