Development of Online Egg Grading Information Management System with Data Warehouse Technique

2020 ◽  
Vol 36 (4) ◽  
pp. 589-604
Author(s):  
Seung-Chul Yoon ◽  
Tae Sung Shin ◽  
Kurt Lawrence ◽  
Deana R. Jones
Keyword(s):  
Information System ◽  
Data Warehouse ◽  
Information Management ◽  
Data Storage ◽  
Management System ◽  
Web Application ◽  
Data Entry ◽  
Information Management System ◽  
Online Data ◽  
Web Based

Highlights Digital data collection and management system is developed for the USDA-AMS’s shell-egg grading program. Database system consisting of OLTP, data warehouse and OLAP databases enables online data entry and trend reporting. Data and information management is done through web application servers. Users access the databases via web browsers. Abstract . This paper is concerned with development of web-based online data entry and reporting system, capable of centralized data storage and analytics of egg grading records produced by USDA egg graders. The USDA egg grading records are currently managed in paper form. While there is useful information for data-driven knowledge discovery and decision making, the paper-based egg grading record system has fundamental limitations in effective and timely management of such information. Thus, there has been a demand to electronically and digitally store and manage the egg grading records in a database for data analytics and mining, such that the quality trends of eggs observed at various levels (e.g., nation or state) are readily available to decision makers. In this study, we report the design and implementation of a web-based online data entry and reporting information system (called USDA Egg Grading Information Management System, EGIMS), based on a data warehouse framework. The developed information system consisted of web applications for data entry and reporting, and internal databases for data storage, aggregation, and query processing. The internal databases consisted of online transaction processing (OLTP) database for data entry and retrieval, data warehouse (DW) for centralized data storage and online analytical processing (OLAP) database for multidimensional analytical queries. Thus, the key design goal of the system was to build a system platform that could provide the web-based data entry and reporting capabilities while rapidly updating the OLTP, DW and OLAP databases. The developed system was evaluated by a simulation study with statistically-modeled egg grading records of one hypothetical year. The study found that the EGIMS could handle approximately up to 600 concurrent users, 32 data entries per second and 164 report requests per second, on average. The study demonstrated the feasibility of an enterprise-level data warehouse system for the USDA and a potential to provide data analytics and data mining capabilities such that the queries about historical and current trends can be reported. Once fully implemented and tested in the field, the EGIMS is expected to provide a solution to modernize the egg grading practice of the USDA and produce the useful information for timely decisions and new knowledge discovery. Keywords: Data warehouse, Database, OLTP, OLAP, Egg grading, Information management, Web application, Information system, Data.

A Web-Based Information Management System for Bus Test Data for the Pennsylvania Transportation Institute

2002 ◽  
Author(s):  
Jyotirmaya Nanda ◽  
Rob Iera ◽  
Stella Clarke ◽  
Timothy W. Simpson ◽  
David Klinikowski
Keyword(s):  
Information Management ◽  
Data Storage ◽  
Test Data ◽  
Management System ◽  
Data Entry ◽  
Information Management System ◽  
Easy Access ◽  
Web Based ◽  
Microsoft Access ◽  
Free Data

Computer-based information management systems have allowed many companies and facilities to greatly improve their data storage and processing capabilities over traditional paper and file methods. The Internet and its associated web-based technologies have further contributed to information processing capabilities. The Federal Transit Administration’s Bus Testing Program, operated by the Pennsylvania Transportation Institute at the Pennsylvania State University requires an upgrade to such a system. Currently, all bus test data is entered directly into a hardcopy report, and data analysis must be performed manually. The objective in this research is to develop an information management system for the bus test data to facilitate access to the data, enable search queries, and perform statistical analyses to examine current trends or predict performance characteristics of future buses. A database has been created in Microsoft Access and linked to a user-friendly graphical user interface developed in Visual Basic for fast and nearly error-free data entry. A web-based infrastructure comprised of HTML, XML, ASP, and customized COM objects is used to display, search, and analyze the bus test data. The resulting information system saves time and money for PTI while enabling easy access to bus test reports.

Web-Based Information System for Cladding Industry

2011 ◽  
Vol 121-126 ◽  
pp. 4265-4268
Author(s):  
Qiang Du ◽  
Stephen Ledbetter ◽  
Rui Yang
Keyword(s):  
Information System ◽  
Information Management ◽  
Software Package ◽  
Management System ◽  
Information Sources ◽  
Rapid Development ◽  
Information Management System ◽  
Web Based ◽  
Main Challenge

The cladding industry has been experiencing a rapid development since two decades ago. The client’s requirements and architect’s ambition make the building cladding become more complex than ever before. The technical complexity calls for more comprehensive managerial techniques, especially information management. This paper proposes a web-based information management system, in which software package was developed and hardware incorporated. After establishing the framework initially, a main challenge, information sources, of this mechanism was discussed.

Geo-Spatial Information System (GIS) Mapping of Pipeline Network in India Using Modern Route Survey Techniques and Practices

2019 ◽  
Author(s):  
Ravindra Kumar Singh
Keyword(s):  
Information System ◽  
Information Management ◽  
Management System ◽  
Spatial Information ◽  
Information Management System ◽  
Gis Mapping ◽  
Web Based ◽  
Pipeline Network ◽  
Survey Techniques ◽  
Points Of Interest

SECON developed GIS Database and Web based Pipeline Information Management System (PIMS Application) covering all the pipelines and facilities across the country for which work has been awarded to SECON Pvt. Ltd., Bangalore. This database comprises of different map layers and associated tables pertaining to pipeline alignment, stations and facilities, dwellings and structures along the pipeline alignment, pipeline depth of cover, points of interest along the route etc.

A Strategic Planning of Developing Student Information Management System Using SWOT Technique

2016 ◽  
Vol 2 (3) ◽  
pp. 515
Author(s):  
Luay Idrees Sarhan ◽  
Akeela M. Atroshi ◽  
Nawzat S. Ahmed
Keyword(s):  
Information System ◽  
Strategic Planning ◽  
Information Management ◽  
Management System ◽  
Information Management System ◽  
Analysis Tool ◽  
Student Information Systems ◽  
Student Information System ◽  
Key Factor ◽  
Student Information

The strategic planning of developing any information system is the key factor of progress any organization. Hence, SWOT (Strength, weakness, opportunities and threats) analysis for the strategic planning of developing information system has proved to be a good analysis tool for further development and progress of the universities/organization. Further, the implementation of computerized student information management system has become an important issue within the university campus to exchange such information between students and staff. Many studies have developed student information system through the converting of paper-based system to computer-based system in order to facilitate the work of staff. However, none of these studies focused on the development of such systems based on the strategic planning using SWOT technique. Therefore, this research focuses on the requirements needed to develop student information system based on the aforementioned strategic planning technique. Some universities located in the Kurdistan Region, Iraq have been tacking to do the investigation. Moreover, SWOT technique was selected to find strengths, weaknesses, opportunities and threats of developing such system. The findings of this research were processed as matching strengths with opportunities and converting weaknesses or threats to strengths or opportunities. Based on the results, it has been found that the need to address student information systems is of utmost importance now more than ever in order to survive and continue in the competition environment.            

Research on Manufacturing Engineering with Financial Information Management System Inter Control in Technology-Based Small and Medium-Sized Enterprises

2014 ◽  
Vol 910 ◽  
pp. 381-384
Author(s):  
Jie Chen
Keyword(s):  
Information System ◽  
Information Management ◽  
Internal Control ◽  
Management System ◽  
Information Management System ◽  
Financial Information ◽  
High Tech ◽  
Main Body ◽  
Science Content ◽  
Manufacturing Engineering

Manufacturing Engineering makes the technical science content high, if enterprise wants to utilize this kind of technical effect well .Small and medium-sized enterprises refers to the scientific and technical personnel as the main body, it is an intelligence intensive economic entity which mainly engaged in high-tech research and development, production of high-tech products and business, independent accounting. The main contents of this paper: The significance of financial information management system inter control; The specific application of financial information system under the environment of ERP; Strategies of improving the internal control of accounting information system.

Sign in / Sign up

Export Citation Format

Share Document