Functional Dependencies Unleashed for Scalable Data Exchange

We address the problem of efficiently evaluating target functional dependencies (fds) in the Data Exchange (DE) process. Target fds naturally occur in many DE scenarios, including the ones in Life Sciences in which multiple source relations need to be structured under a constrained target schema. However, despite their wide use, target fds' evaluation is still a bottleneck in the state-of-the-art DE engines. Systems relying on an all-SQL approach typically do not support target fds unless additional information is provided. Alternatively, DE engines that do include these dependencies typically pay the price of a significant drop in performance and scalability. In this paper, we present a novel chase-based algorithm that can efficiently handle arbitrary fds on the target. Our approach essentially relies on exploiting the interactions between source-to-target (s-t) tuple-generating dependencies (tgds) and target fds. This allows us to tame the size of the intermediate chase results, by playing on a careful ordering of chase steps interleaving fds and (chosen) tgds. As a direct consequence, we importantly diminish the fd application scope, often a central cause of the dramatic overhead induced by target fds. Moreover, reasoning on dependency interaction further leads us to interesting parallelization opportunities, yielding additional scalability gains. We provide a proof-of-concept implementation of our chase-based algorithm and an experimental study aiming at gauging its scalability with respect to a number of parameters, among which the size of source instances and the number of dependencies of each tested scenario. Finally, we empirically compare with the latest DE engines, and show that our algorithm outperforms them

Solusi Teknologi Informasi untuk Proses Bisnis Perusahaan Ikan dalam Perencanaan Strategis Sistem Informasi pada PT Nusantara Alam Bahari

Solusi Teknologi Informasi untuk Proses Bisnis Perusahaan Ikan dalam Perencanaan Strategis Sistem Informasi pada PT Nusantara Alam Bahari. Dewasa ini tuntutan untuk membuat sebuah kegiatan bisnis yang makin terintegrasi semakin tinggi, ini disebabkan oleh makin kompleksnya proses bisnis dan kegiatan USAha yang makin berkembang. Aliran data dan proses bisnis harus cepat mengalir dari satu bagian ke bagian yang lain yang mempunyai kepentingan akan proses dan data tersebut, misalnya kegiatan penjualan mengalirkan data dari bagian penjualan, ke bagian persediaan barang, kemudian ke bagian keuangan, kemudian ke bagian pembelian dan pengadaan barang, dan berakhir hingga ke tangan pembeli barang. Setiap Perusahaan mencoba untuk menerapkan teknologi informasi agar dapat meningkatkan efektifitas dan efesiensi dalam proses bisnis, hal ini bertujuan agar mampu memberikan nilai tambah yaitu berupa competitive advantage dalam persaingan bisnis.Untuk itu penerapan teknologi informasi adalah sangat penting dalam mendukung proses bisnis dalam Perusahaan. Rencana strategis Perusahaan adalah suatu rencana jangka panjang yang bersifat menyeluruh, memberikan rumusan ke mana Perusahaan akan diarahkan, dan bagaimana sumberdaya dialokasikan untuk mencapai tujuan selama jangka waktu tertentu dalam berbagai kemungkinan keadaan lingkungan sehingga lebih efektif dalam menggunakan sumberdaya. Untuk itu perlu adanya perencanaan strategis teknologi informasi pada PT Nusantara Alam Bahari Jakarta

Kepuasan Masyarakat Surabaya Dalam Menonton Tayangan Stasiun Dangdut Di JTV

Dewasa ini salah satu penyampai informasi yang efektif adalah media massa, yang salah satunya adalah televisi. Televisi sangat digemari oleh masyarakat. Melalui kegiatan menonton televisi, manusia dapat memahami dan mengerti informasi yang disampaikan. Seperti halnya fenomena atau tren di banyak stasiun televisi salah satunya program musik. Stasiun Dangdut adalah sebuah program musik yang banyak digemari oleh pemirsanya, termasuk pemirsa di Surabaya. Dengan rating tertinggi sebesar 0,4 dan waktu penayangan lebih dari 10 tahun. Tujuan dari penelitian ini adalah untuk mengetahui kepuasan pemirsa dalam menonton program Stasiun Dangdut. Metode dalam penelitian ini adalah survey dan jenis penelitian eksplanatif. Respondennya adalah pemirsa Surabaya usia 17-40 tahun. Hasil penelitian ini adalah adanya kesenjangan hasil kepuasan yang diperoleh pemirsa Surabaya yaitu antara motif (Gratification Sought) dan kepuasan yang diperoleh (Gratification Obtained). Hasil dari penelitian kepuasan pemirsa dalam menonton tayangan Stasiun Dangdut adalah pada indikator model sosial

Prediction Markets: Alternative Mechanisms for Complex Environments with Few Traders

Double auction prediction markets have proven successful in large-scale applications such as elections and sporting events. Consequently, several large corporations have adopted these markets for smaller-scale internal applications where information may be complex and the number of traders is small. Using laboratory experiments, we test the performance of the double auction in complex environments with few traders and compare it to three alternative mechanisms. When information is complex we find that an iterated poll (or Delphi method) outperforms the double auction mechanism. We present five behavioral observations that may explain why the poll performs better in these settings

Hemodialysis vascular access: evaluation of type and local of vascular access used in 23 dialysis centers in seven brazilian states

BACKGROUND: To demonstrate type and local of vascular access for hemodialysis used in 23 dialysis centers in seven Brazilian states. METHODS: From October 1999 to August 2000, a total of 2559 patients in 23 hemodialysis centers were studied to determine: A- the frequency of catheter utilization and arteriovenous fistulae (AVF) as a vascular access for hemodialysis .B- the types of catheters (cuffed, tunneled catheters) or acute one and the sites of choice for the insertion. C- if AVF was the access, its type (native or with insertion of polytetrafluoroethylene - PTFE) and location (distal or proximal). D- the costs with vascular access as a percentage of the total costs of the unit. RESULTS: The study showed that 93.4% of the patients had an AVF as a vascular access for hemodialysis and the remaining 6.6% had a catheter. Distal native AVF was the more frequently constructed (74.8%), while the proximal native AVF was constructed in 21.7% of the times. Insertion of PTFE reached 3.2%, saphenous vein was used in 0.1% and the others AVFs, 0.2%. Cuffed, tunneled catheters (long term catheters) were used in 8.7% and acute catheters in 91.3%. The sites of choice when using an acute catheter were the subclavian and internal jugular veins (both with 42.4% of the preference) and the femoral vein in 6.5%. The costs with a vascular access for hemodialysis reached 1% of the total costs of the unit. CONCLUSIONS: Vascular access for hemodialysis in Brazil has different aspects compared with United States of America or European data. The most frequently vascular access constructed is the distal native AVF and the use of PTFE for AVF construction is very low.OBJETIVO: Demonstrar os acessos vasculares para hemodiálise mais utilizados em 23 unidades de hemodiálise, distribuídas em sete estados brasileiros. MÉTODO: Entre outubro de 1999 a agosto de 2000, foram avaliados 2559 pacientes em 23 unidades de hemodiálise distribuídas em 23 estados brasileiros onde foi observado: A - A freqüência da utilização do acesso vascular, se externo através de cateteres ou se interno através de fístula arteriovenosa (FAV). B - Os tipos de cateteres, se de curta permanência ou de longa permanência, assim como os locais anatômicos utilizados para sua inserção. C - Os tipos de FAV, se direta ou com interposição de algum tipo de prótese e os locais anatômicos onde foram construídas, se distais ou proximais. D - O custo financeiro com os acessos vasculares. RESULTADOS: Constatou-se que 93,4% dos pacientes tinham um acesso vascular através de FAV e 6,6% através de cateter. As FAV diretas distais foram as mais utilizadas em 74,8% dos pacientes; as FAV diretas proximais foram construídas em 21,7% das vezes; as FAV com politetrafluoretileno expandido (PTFE) 3,2% da totalidade; a veia safena foi utilizada em 0,1% e as FAV consideradas como outras em 0,2%. Os cateteres de longa permanência foram utilizados em 8,7% da totalidade dos cateteres e os de curta permanência em 91,3%. Como via de acesso a veia jugular foi utilizada em 42,4%, a veia subclávia em 42,4% e a veia femoral em 6,5%. O custo financeiro com acesso para hemodiálise foi de 1% do custo total das unidades. CONCLUSÕES: O acesso vascular no Brasil tem características próprias. O acesso mais utilizado é a FAV distal e o uso do PTFE é baixo.PUC-SP Faculdade de Ciências Médicas Departamento de CirurgiaUSF Faculdade de Medicina de Bragança PaulistaHospital Evangélico de Sorocaba Serviço de NefrologiaPUC-SP Faculdade de Ciências Médicas Departamento de Morfologia e PatologiaPUC-SP Faculdade de Ciências MédicasUNIFESP Faculdade da Escola Paulista de MedicinaUNIFESP, Faculdade da Escola Paulista de MedicinaSciEL

Can Relational Contracts Survive Stochastic Interruptions?

This paper investigates the robustness of the “two-tiered labor market” experimental results of Brown, Falk and Fehr (2004) by subjecting relationships to stochastic interruptions. Using two different subject pools, we first replicate the basic pattern of high quality private contracting and low quality public contracting. We then study the impact of exogenous random ‘downturns’ in which firms cannot hire workers for three periods. Our hypothesis is that 1. job rents are lower in downturns 2. this will lower wages and effort, unless strong re-connection norms exist. We do find that job rents are lower, but surprisingly, the downturns do not harm aggregate market efficiency. Stochastic interruptions delay the formation of relationships, necessitating the use of public offers, which increases the competitiveness of the short term market. The high tier (private) markets responds by raising wages, thus increasing average worker surplus per trade. We also find evidence that 50-50 pre-downturn worker-firm surplus sharing predicts post-downturn re-connections

How Important of the Accuracy Sales Forecasting Method Against Sales Strategy Decision Making of the Mobile Phone Network Operator Company: a Case Study

This paper examines the accuracy of sales forecasting method that are important for decision making of sales strategy the mobile phone network operator company. Sales forecasting used to estimate company products sales for next year, so the company could make sales strategy plans and estimation an amount to be produced next year. Mobile phone network operator is one of un-seasonable products. The purpose of the paper is to compare, analyze, and giving a recommend of the best sales forecasting method to improve the mobile phone network operator company. Quantitative data were collected through published companies finnacial reports, articles, and journals which related with Supply Chain Management theory. The contribution this paper is providing the mobile phone network operator company to make successful sales strategy based from good sales forecasting method. Keywords – Sales Forecasting, Mobile Phone Network Operator Company, Sales Strategy, Forecasting Metho

Karakteristik Fisikokimia dan Organoleptik Kerupuk pada Berbagai Proporsi Tapioka dan Tepung Kacang Hijau

Crackers is a popular food in Indonesia. Public appetite for eating crackers continues to increase, so diversification of crackers need to be develop with diversification crackers from mung bean.The purpose of this research is to determine the effect of the proportion between tapioca and mung bean flour on physicochemical and organoleptic properties of mung bean cracker and get the best treatment combination. The materials for mung bean cracker is tapioca and mung bean flour. The different proportion of tapioca and mung bean flour can be affect physicochemical and organoleptic properties of cracker. The design of the study is a single randomized group design, spesifically proportion of tapioca and mung bean flour which consists of six levels and was repeated four times, 9:1, 8:2, 7:3, 6:4, 5:5, and 4:6. The results showed significantly affect the water content of raw and fried crackers, expansion volume, oil absorbtion, fracture, crispness, and organoleptic (taste, color, crispness). The higher proportion of mung bean flour, the lower the moisture content of raw crackers, expansion volume, oil absorption, crispness, and the higher hardness, water content of fried crackers. The best treatment based on organoleptic properties is crackers with proportion of tapioca : mung bean flour at 8:2 (T8H2)