PERANCANGAN SISTEM INFORMASI MANAJEMEN PERSEDIAAN BARANG DI PT. PERKEBUNAN NUSANTARA XI (PERSERO) PABRIK KARUNG ROSELLA BARU SURABAYA

The very rapid technological developments are accompanied by advances in technology, leading companies must devote all its resources optimally and professional company to support the company's success in confronting fierce competition in this era of globalization. The company's success is highly dependent on the success of management in carrying out his job. The success of the company's management depending on the availability of relevant information from appropriate data processing. In order for information work can be handled in a systematic and practical need for management information systems. New Pk.Rosella is a company engaged in the manufacture of plastic bags. Along with the development company the right information is necessary to accurately Pk. Rosella in handling the administration of sales and warehouse stock. To assist the decision making process by management. Unavailability of appropriate information systems, rapid and accurate lead time data processing and report maker becomes ineffective and can cause kesalahn in preparing reports that will ultimately affect the process penganbilan decision by management. The purpose of this study is to design a management information system in order to obtain the results of the election effective and efficient inventory and inventory related permasalahn overcome the design information data base, which contains information on design inputs and design outputs in the form of a report - the report. From the research results obtained that information systems designed to improve the procedure warehouse stock sales activities and becoming more effective because it can shorten the time of reporting, speed up delivery of information to managers so that production can easily control the existing inventory in warehouse

The use of alternative data models in data warehousing environments

Data Warehouses are increasing their data volume at an accelerated rate; high disk space consumption; slow query response time and complex database administration are common problems in these environments. The lack of a proper data model and an adequate architecture specifically targeted towards these environments are the root causes of these problems. Inefficient management of stored data includes duplicate values at column level and poor management of data sparsity which derives from a low data density, and affects the final size of Data Warehouses. It has been demonstrated that the Relational Model and Relational technology are not the best techniques for managing duplicates and data sparsity. The novelty of this research is to compare some data models considering their data density and their data sparsity management to optimise Data Warehouse environments. The Binary-Relational, the Associative/Triple Store and the Transrelational models have been investigated and based on the research results a novel Alternative Data Warehouse Reference architectural configuration has been defined. For the Transrelational model, no database implementation existed. Therefore it was necessary to develop an instantiation of it’s storage mechanism, and as far as could be determined this is the first public domain instantiation available of the storage mechanism for the Transrelational model

Conceptual Architecture of Data Warehouses - A Transformation-Oriented View

A data warehouse (DWH) is an integrated collection of worthwhile data for management support. Unfortunately operational databases – the main source of feeding the DWH with internal data – only provide data with poor management value when no transformation has taken place. The paper deals with this topic. It concentrates on a conceptual architecture of a DWH, in which the transformation machine is the main constituent part of the architecture. This machine supports sub-processes of filtering, harmonization, aggregation and enrichment and is maintained by controller and technician interfaces. Furthermore an access, load and meta data administration handles the secure and documented loading and accessing of relevant data and guarantees technical and businessoriented documentation of all transformation activities

The Use of Olap Reporting Technology to Improve Patient Care Services Decision Making Within the University Health Center

The purpose of this paper is to demonstrate that it is feasible for the student health center to leverage existing clinical data in a data warehouse by using OLAP reporting in order to improve patient care and health care services decision making. Historically, University health care centers have relied mainly on operational data sources for critical health care decision making. These sources of data do not contain enough information to allow health officials to recognize trends or predict how future changes in health care services might vastly improve overall heath care. Four proof of concept artifacts are constructed through design science research methodology, and a feasibility study is presented to build the case for the adoption of OLAP reporting technology. The study concludes that it is feasible to implement an OLAP reporting infrastructure at the student health center if physicians, clinical staff, and administration clearly define the need for the new technology, develop proper data extraction, loading, and transformation strategy, and adequately provide project management and data warehouse design towards the implementation of the solution

Challenges in public healthcare research data warehouse integration and operationalisation.

Objectives Public health service organisations use multiple patient administration and electronic health record systems. We describe the implementation of a data warehouse automation tool within the National Centre for Healthy Ageing (NCHA) data platform to operationalise a research data warehouse to optimise data quality and data provision for health services research. Approach The traditional data warehouse life cycle comprises repetitive manual tasks and dependency on specialist developers. Automation tools overcome most of these inefficiencies. We conducted an internal risk benefit analysis which was validated by published literature containing data warehouse optimisation and automation. Industry-based data warehouse automation tools were reviewed to align the NCHA requirements with the tool’s functionality. Tools were then shortlisted and evaluated over a six-week period: (1) automation of standard tasks; (2) data pipeline alignment with the World Health Organization’s (WHO) Data Quality Review Framework; and (3) resource dependency risk mitigation through a Proof of Concept (PoC). Results The priority areas identified by the risk benefit analysis included: end-to-end data warehouse automation; auto scripting; connectivity/linkage with multiple sources, reverse/forward engineering, audit trail conformance, scalability, multiple data warehouse architectures support, automated documentation; data management including data quality; and post-subscription independence. Twenty scientific publications were included in the final literature review (10% within healthcare) and supported the majority of identified priority areas. The industry-based review identified 11 suitable data warehouse/Extract-Transform-Load (ETL) automation tools. Five tools demonstrated adequate performance for task automation, data quality management, reduced dependency on specialist developers and on-premise linkage compatibility. Two automation tools were tested each for 6 weeks through PoC development. One automation tool met 8 out of the 10 automation requirements and was selected for implementation. Conclusion Data warehouse development processes are complex and time consuming. Tools that offer automation of repetitive tasks and scripting increase the consistency while reducing the dependency on specialist staff.  Integrated data quality management minimises the time researchers spend in pre-processing patient level data sourced through a semi-automated data warehouse

Knowledge and Metadata Integration for Warehousing Complex Data

With the ever-growing availability of so-called complex data, especially on the Web, decision-support systems such as data warehouses must store and process data that are not only numerical or symbolic. Warehousing and analyzing such data requires the joint exploitation of metadata and domain-related knowledge, which must thereby be integrated. In this paper, we survey the types of knowledge and metadata that are needed for managing complex data, discuss the issue of knowledge and metadata integration, and propose a CWM-compliant integration solution that we incorporate into an XML complex data warehousing framework we previously designed.Comment: 6th International Conference on Information Systems Technology and its Applications (ISTA 07), Kharkiv : Ukraine (2007

Patient Risk and Data Standards in Healthcare Supply Chain

Patient safety is one of the most important health care challenges. It is a big concern since 1 in every 10 patients around the world is affected by healthcare errors. The focus of this study is given to preventable adverse events that caused by the errors or system flaw that could have been avoided. In this study, simulation models are developed using Arena to evaluate the impact of GS1 data standards on patient risk in healthcare supply chain. The focus was given to the provider hospital supply chain operations where inventory discrepancy and performance deficiencies in recall, return, and outdate management can directly affect patient safety. Simulation models are developed for various systems and scenarios to compare different performance measures and analyze the impact of GS1. The results indicates that as the validation points are closer to the point of use, the number of recalled or outdated products administered to a patient are still reduced significantly so checking at the bedside or PAR is critical. But validation only at these points may cause some problems such as stock outs; therefore, validating in other locations is also needed

The drug logistics process: an innovation experience

Purpose - The purpose of this paper is to present the latest innovations in the drug distribution processes of hospital companies, which are currently dealing with high inventory and storage costs and fragmented organizational responsibilities. Design/methodology/approach - The literature review and the in-depth analysis of a case study support the understanding of the unit dose drug distribution system and the subsequent definition of the practical implications for hospital companies. Findings - Starting from the insights offered by the case study, the analysis shows that the unit dose system allows hospitals to improve the patient care quality and reduce costs. Research limitations/implications - The limitations of the research are those related to the theoretical and exploratory nature of the study, but from a practical point of view, the work provides important indications to the management of healthcare companies, which have to innovate their drug distribution systems. Originality/value - This paper analyzes a new and highly topical issue and provides several insights for the competitive development of a fundamental sector

Strategic Marketing Environment based on Integrated CRM to Foster Competition

After the great wave of ERP (Enterprise Resource Planning) systems implementations, the organizations focus has been turning to CRM (Customer Relationship Management) applications. CRM systems are centered on one to one interactions with customers, they analyse each client trying to identify his or her own characteristics from internal and external data. At the same time, every client interaction is registered, to create a relationship historical data. Intelligent tools like data mining and OLAP using complex algorithms, rules based systems, fuzzy logic and multivariate statistics data analysis will retrieve the best of clients, partners, employees, suppliers and other strategic data to provide the organization with accurate actions for marketing campaigns, better products, excellence of services and decision making, based on the organization ecosystem. This study reviews concepts of CRM, its architecture and integration with ERP, Governance Systems, and Competence Administration, in the current perspective of integrated corporate management systems connected to the internet. In kernel we propose a “intelligence core joystick” where the strategic core supports and decides about resources allocation, negociates and establishes politics and actions to minimize the conflicting forces to get a balance line satisfaction between participants or partners. Our model also contemplates data warehouse, which centralizes separately all the corporate significant data to provide managers with high quality data for the decision making. According to the corporation, this data warehouse can feed others data marts to serve specific departamental areas such as Marketing and Human Management Competences. In addition, to link the participants, organization and processes, there is a intelligent communication infrastructure to simplify and speed actions, to spread organizational culture and relevant information throughout the organization in a symbiotic way

Value-driven Security Agreements in Extended Enterprises

Today organizations are highly interconnected in business networks called extended enterprises. This is mostly facilitated by outsourcing and by new economic models based on pay-as-you-go billing; all supported by IT-as-a-service. Although outsourcing has been around for some time, what is now new is the fact that organizations are increasingly outsourcing critical business processes, engaging on complex service bundles, and moving infrastructure and their management to the custody of third parties. Although this gives competitive advantage by reducing cost and increasing flexibility, it increases security risks by eroding security perimeters that used to separate insiders with security privileges from outsiders without security privileges. The classical security distinction between insiders and outsiders is supplemented with a third category of threat agents, namely external insiders, who are not subject to the internal control of an organization but yet have some access privileges to its resources that normal outsiders do not have. Protection against external insiders requires security agreements between organizations in an extended enterprise. Currently, there is no practical method that allows security officers to specify such requirements. In this paper we provide a method for modeling an extended enterprise architecture, identifying external insider roles, and for specifying security requirements that mitigate security threats posed by these roles. We illustrate our method with a realistic example