scholarly journals SCHEDULING OPTIMIZATION FOR EXTRACT, TRANSFORM, LOAD (ETL) PROCESS ON DATA WAREHOUSE USING ROUND ROBIN METHOD (CASE STUDY: UNIVERSITY of XYZ)

2017 ◽  
Vol 2 (2) ◽  
Author(s):  
Agung Yudha Berliantara
Keyword(s):  
Data Warehouse ◽  
Execution Time ◽  
Large Data ◽  
Round Robin ◽  
Long Time ◽  
Scheduling Method ◽  
The Difference ◽  
Cost Of Time ◽  
The Cost

ETL scheduling is a challenging and exciting issue to solve. The ETL scheduling problem has many facets, one of which is the cost of time. If it is not handled correctly, it may take a very long time to execute and inconsistent data in very large data. In this study using Round-robin algorithm method that proved able to produce efficient results and in accordance with conventional methods. After doing the research, the difference between these two methods is about execution time. Through this experiment, the Round-robin scheduling method gives a more efficient execution time of up to 61% depending on the amount of data and the number of partitions used.

scholarly journals Borehole Rehabilitation: A Case Study in the Dunkwa Mining Town

2020 ◽  
Vol 20 (2) ◽  
pp. 11-17
Author(s):  
A. Ewusi ◽  
J. Seidu
Keyword(s):  
Water Supply ◽  
Central Region ◽  
Pumping Test ◽  
Implementation Cost ◽  
Mining Town ◽  
Long Time ◽  
Borehole Camera ◽  
The Cost ◽  
Very High

Rehabilitation works were carried out on boreholes in the Dunkwa Mining town in the Central Region of Ghana. These works were carried out because the boreholes had lost their original yields due to clogging, corrosion and encrustation and had been abandoned for a long time. The cost of drilling a new well and assessing the productivity of the well is $4,500 which is more expensive that carrying out rehabilitation works which is cheaper, about $800. Also, the initial yields of the boreholes were very high according to the feasibility report which is not a common characteristic of the rocks in the area. Camera inspection followed by rehabilitation, pre and post pumping tests were carried out to assess whether there has been an improvement in their yield after the exercise and that the yield obtained will be adequate for a water supply design. Results show that all the boreholes had an improvement in their yields (57.19 - 259.80 %) after the rehabilitation. It can therefore be concluded that rehabilitation is effective in restoring boreholes to their original yields. Organisations drilling boreholes to communities can take advantage of rehabilitation of the existing boreholes located in the communities which are high yielding, thereby reducing project implementation cost. Keywords: Borehole Rehabilitation, Borehole Yields, Borehole Camera Inspection, Pumping Test

scholarly journals Marketing margins of aquaculture shrimp production in Kedah

2020 ◽  
Vol 4 (1) ◽  
pp. 20-23
Author(s):  
Wen Chiat Lee
Keyword(s):  
Marketing Channel ◽  
Marketing Channels ◽  
White Shrimp ◽  
Retail Market ◽  
Shrimp Production ◽  
Farm Price ◽  
The Difference ◽  
The Cost ◽  
Marketing Margins

Shrimp aquaculture has great potential for providing income and employment opportunities to farmers. Shrimp production can also contribute to economic growth given its high value and demand in Malaysia. However, it is often said that players in the marketing channel extract high margins for themselves. This study intends to verify this claim by examining a case study based on white leg shrimp (Litopenaeus vannamei) aquaculture in Kedah. The data for this study was obtained from a detailed study involving a shrimp retailer in Kedah. The marketing margins were calculated from the interviews of the farmer and the retailer. The results showed that the marketing channel was quite efficient because there was no large gap in the prices between the marketing channels. The difference between retail price and farm price is only RM7 per kilogram for the white shrimp which accounts for 43.75 percent of total farm price and represents the cost of bringing shrimps from the farm to the retail market.

scholarly journals KERAGAAN AGROINDUSTRI DAN POSISI PRODUK BERDASARKAN SIKLUS HIDUP PRODUK PADA SOSIS GULUNG VARIAN NOODLE DI CV CUCURUTUKU CERIA

2021 ◽  
Vol 9 (4) ◽  
pp. 561
Author(s):  
Meliani Indah Sari ◽  
Dyah Aring Hepiana Lestari ◽  
Wuryaningsih Dwi Sayekti
Keyword(s):  
Life Cycle ◽  
Product Life Cycle ◽  
Production Costs ◽  
Selling Price ◽  
Long Time ◽  
The Government ◽  
The Cost

This study aims to analyze the process production of sausage noodle roll, the income and production costs, the marketing action and determine the position based on the life cycle of sausage noodle roll as well learn the role of supporting service for sausage noodle roll in CV Cucurutuku Ceria. This research method is a case study. The determination of consumer samples is taken by Convenience Sampling. Analysis of the data used in this research is descriptive qualitative and quantitative analysis. The data of this study was collected in May 2019 until June 2019. The results showed that the value R/C>1, that means sausage noodle roll business was profitable. Calculation of the cost of production on sausage rolls noodles amounted to Rp1,046.53. The BEP unit calculation has been achieved for a long time, in the amount of 42,791 units from the BEP calculation of 604 units. The noodle rolls sausage has also obtained a profit from the selling price of Rp ,000.00 per pcs from the calculation of the BEP price of Rp1,238.58 per pcs. The marketing mix that has been utilized by CV Cucurutuku Ceria is collaboration with e-commerce companies namely gofood and grabfood to facilitate consumers in the ordering process and CV Cucurutuku Ceria has utilized social media as promotional activities for sausage noodle roll product. In the product life cycle, sausage noodle roll are in a stage of decline. CV Cucurutuku Ceria has not fully utilized the government policies regarding the protection and empowerment of Micro, Small and Medium Enterprises.Keywords: cost, noodle, position, and sausage

scholarly journals ANALISIS PERBANDINGAN EFISIENSI TENAGA KERJA SEMI MEKANIS DAN MANUAL PADA SESI POTONG BUAH (Studi kasus di Puhus 2 Estate PT Dharma Agrotama Nusantara di Desa Muara Wahau) (The Comparison Analysis of Efficiency of Semi Mechanical and Manual Labors on Fruit Cutting Session (Case study at Puhus 2 Estate PT. Dharma Agrotama Nusantara in Muara Wahau Village))

2018 ◽  
Vol 1 (1) ◽  
pp. 39
Author(s):  
PUTERI APRILANI ◽  
TETTY WIJAYANTI
Keyword(s):  
Palm Oil ◽  
Average Cost ◽  
Production Factor ◽  
Manual Labor ◽  
Comparison Analysis ◽  
The Difference ◽  
Fresh Fruit Bunches ◽  
The Cost ◽  
The Village

The purposes of this research were to know the difference between semi mechanical and manual on harvesting of palm oil and to know the efficiency of semi mechanical and manual labor on fruit cutting session of Fresh Fruit Bunches (TBS) of palm oil in Puhus 2 Estate of PT. Dharma Agrotama Nusantara (DAN) in the Village of Muara Wahau. This research was held for three months, start from March to May 2017 in Puhus 2 Estate PT. DAN in  Muara Wahau Village, Muara Wahau Subdistrict, East Kutai District. The result showed that the difference of utilization of semi mechanical and manual labor is not just on the use of machine or tools but there is also difference on the basic of the harvesters and cost. In semi mechanical labor, the average cost in four months was IDR89,057 ton-1 and 2,628.41 ton of production, while the cost of manual labor was IDR108,367 ton-1 with 1,677.03 ton of production. The production factor utilization of semi mechanical labor is more efficien compare to utilization of manual labor in the fruit cutting session of PT. DAN in Muara Wahau Village, Muara Wahau District, East Kutai District.

Use of Sensor Data Warehouse for Soil Moisture Analysis

2016 ◽  
pp. 43-57
Author(s):  
Myoung-Ah Kang ◽  
François Pinet ◽  
Sandro Bimonte ◽  
Gil De Sousa ◽  
Jean-Pierre Chanet
Keyword(s):  
Data Warehouse ◽  
Spatial Data ◽  
Spatial Scales ◽  
Large Data ◽  
Sensor Nodes ◽  
Sensor Data ◽  
Data Sets ◽  
Innovative Solution ◽  
The Cost ◽  
General Architecture

More and more data are collected via sensors. Wireless networks can be implemented to facilitate the collection of sensors data and to reduce the cost of their acquisition. In this chapter, we present a general architecture combining Wireless Sensor Network (WSN) and Spatial Data Warehouse (SDW) technologies. This innovative solution is used to collect automatically sensor's information and to facilitate the analysis of these data. The WSN used in this application has been deployed by Irstea and tested during several years in vineyards in South of France. The novel contribution presented in this chapter is related to the use of a SDW to manage data produced by geo-referenced sensor nodes. SDW is one of the most appropriate modern technologies for analyzing large data sets at different temporal and spatial scales. This type of databases is a specific category of information system used to integrate, accumulate and analyze information from various sources. These data are usually organized according to a multidimensional schema to facilitate the calculation of indicators. In this chapter, we introduce the development of a SDW storing the data collected by this WSN. The implemented data warehouse can allow users to aggregate and explore interactively data produced by sensors. With this system, it is possible to visualize on a map the results of these aggregations.

TIME REDUCTION DURING RESTORATION OF THE EXTERIOR OF A HISTORICAL BUILDING

2015 ◽  
Vol 2 (1) ◽  
Author(s):  
Renato Lagana
Keyword(s):  
Execution Time ◽  
Subsequent Development ◽  
Second Phase ◽  
Building Structures ◽  
Construction Site ◽  
Urban Centers ◽  
Historical Building ◽  
Protection Measures ◽  
Long Time

Emergency management due to partial collapse of facade elements is a great interest topic. The collapse often occurs in unexpected damage to building structures of architectural value within the historic urban centers. The actions often require a long time to implement. After an initial delimitation and isolation of the damaged surfaces are initiated, discovery and design of the restoration are started. The economic coverage, no less important, is often done over the years. We undertake a case study, developed in the intervention performed in front of the Cathedral of Reggio Calabria. The study covered aspects related to the organization of the first measures after the collapse of some decorative elements and the subsequent development of the site. The first phase involved the organization and implementation of protection measures to achieve tight deadlines to allow the use of space for an important and non-deferrable event. Authorization procedures for this first phase were expedited and operating procedure for the management of safety for temporary installations was established. The second phase, managed in a day, involved the intervention to ensure the practicability and ensure the safety of users. The preparation of the construction site optimized the execution time of the procedures. The design of the temporary works optimized the work of the teams involved in work sequencing, which resulted in reduced downtime and possible interference. The result of the design choices and operational programming optimized the execution time.

scholarly journals An Empirical Investigation of Transfer Effects for Reinforcement Learning

2020 ◽  
Vol 2020 ◽  
pp. 1-10
Author(s):  
Jung-Sing Jwo ◽  
Ching-Sheng Lin ◽  
Cheng-Hsiung Lee ◽  
Ya-Ching Lo
Keyword(s):  
Reinforcement Learning ◽  
Empirical Investigation ◽  
Learning Algorithm ◽  
Q Learning ◽  
Sorting Problem ◽  
Long Time ◽  
The Difference ◽  
Reinforcement Model ◽  
The Brain

Previous studies have shown that training a reinforcement model for the sorting problem takes very long time, even for small sets of data. To study whether transfer learning could improve the training process of reinforcement learning, we employ Q-learning as the base of the reinforcement learning algorithm, apply the sorting problem as a case study, and assess the performance from two aspects, the time expense and the brain capacity. We compare the total number of training steps between nontransfer and transfer methods to study the efficiencies and evaluate their differences in brain capacity (i.e., the percentage of the updated Q-values in the Q-table). According to our experimental results, the difference in the total number of training steps will become smaller when the size of the numbers to be sorted increases. Our results also show that the brain capacities of transfer and nontransfer reinforcement learning will be similar when they both reach a similar training level.

scholarly journals The Assessment of the suitability of reconfigurable design through simulation and decision trees

2020 ◽  
Vol 5 (9) ◽  
pp. 1027-1030
Author(s):  
Ricardo Irving Ramirez Guzman ◽  
Mario Luis Chew Hernández ◽  
Mtro. Leopoldo Viveros Rosas ◽  
Ricardo Rodríguez Figueroa
Keyword(s):  
Decision Trees ◽  
Process Equipment ◽  
Cost Of Transport ◽  
Reconfigurable Design ◽  
New Process ◽  
Long Time ◽  
Mobile Process ◽  
The Cost ◽  
Productive Time

Positioning of the equipment of a manufacturing company is done foreseeing that it will remain fixed for a long time. This is because changes in the plant layout are thought to be costly, as they involve redesigning equipment support services, developing new foundations, using heavy machinery to move equipment, and causing non-productive time at the plant. However, the increased competition due to globalization, lead us to consider the alternative of making modifications to the layout more frequently to improve productivity. Changing the position of the equipment can be facilitated by specifying smaller mobile process equipment or by anticipating the availability of services at different points in the workshop and the existence of cranes or other means of transportation. These forecasts, logically, result in a greater investment in elements that, at least initially, do not generate any profit. This work shows the evaluation of the feasibility of modifying the positions of the equipment when there are variations in the probability distribution in production speeds. This evaluation is carried out using decision trees and process simulation. The case study addressed consists of a generic production line with serial workstations. Jobs arrive at the first computer and join their product on hold if space is available, otherwise the job is lost. In the same way, the product on hold of the other teams are limited in size, and when a product on hold is full, the team behind stops until there is space available. Due to the use, the speeds of the equipment are changing with respect to the ones they had when new: the process times are increasing and / or becoming more variable. To improve productivity under the new process speeds, the space between the equipment can be modified, however, during this change, production must be suspended. This work shows how, by simulating processes and decision trees, it is possible to determine the ranges of values ​​of the suspension time and the cost of transport for which it is convenient to make changes in the spacing of the equipment.

scholarly journals Zwinne szacowanie pracochłonności w projektach programistycznych – studium przypadków

2017 ◽  
Vol 1 (3) ◽  
Author(s):  
Maciej Łabędzki ◽  
Patryk Promiński ◽  
Adam Rybicki ◽  
Marcin Wolski
Keyword(s):  
Software Development ◽  
Labor Intensity ◽  
Software Projects ◽  
Current Trends ◽  
The Difference ◽  
Correct Estimation ◽  
The Cost ◽  
Made In

Aim:Aim: The purpose of this paper is to identify common mistakes and pitfalls as well as best practices in estimating labor intensity in software projects. The quality of estimations in less experienced teams is often unsatisfactory, as a result of which estimation as part of the software development process is abandoned. The decision is usually justified by misunderstanding "agility". This article is part of the discussion on current trends in estimation, especially in the context of the new "no estimates" approach.Design / Research methods: The publication is a case study based on the experience of a mature development team. The author, on the basis of literature-based estimation techniques, shows good and bad practices, as well as common mistakes in thinking and behavior.Conclusions / findings: The key to correct estimation is: understanding the difference between labor intensity and time, ability to monitor performance, as well as how to analyze staff requirements for the team.Originality / value of the article: The publication helps to master confidence-boosting techniques for any estimation (duration, and indirectly, the cost of software development) where requirements are known, but mainly at the stage of project implementation (design and implementation).Limitations of the research: The work does not address the problems of initial estimation of projects, i.e. the estimation made in the early stages of planning.

scholarly journals Analisis Pendapatan Industri Tahu di Kota Wamena

2021 ◽  
Vol 5 (4) ◽  
pp. 1250-1261
Author(s):  
Rein Rumbiak ◽  
◽  
Lulus Sedavit ◽  
Sumiyati Tuhuteru
Keyword(s):  
National Development ◽  
Secondary Data ◽  
Industrial Sector ◽  
Primary Data ◽  
Agricultural Product ◽  
Selling Price ◽  
Long Time ◽  
Business Income ◽  
The Cost

Agricultural cannot development without the support of the economic sector, especially industry, in this case the development of the agricultural product processing industry (agro-industry) is one of the priorities in national development in industrial sector. Tofu processing business income is very dependent on the selling price of the product and the costs incurred to produce tofu, the higher the product selling price and the lower the cost, the higher the business income. This study aims to determine the level of profit obtained by each industry that has been operating for a long time. The research was conducted in July - September 2018, on the tofu industry in Wamena City. The method used is a case study method with the type of data collected including primary data and secondary data. The data analysis method uses Cost Analysis, Revenue Analysis, and Income Analysis. The results showed that the tofu "Tahu Tempe Jaya" industry was not profitable, compared to the tofu "Tahu Ayu Rezeki" industry which was profitable.

Sign in / Sign up

Export Citation Format

Share Document