Design and implementation of fishery rescue data mart system

Jun Pan; Haiguang Huang; Yousong Liu

doi:10.1117/12.2019678

19 March 2013 Design and implementation of fishery rescue data mart system

Jun Pan, Haiguang Huang, Yousong Liu

Proceedings Volume 8762, PIAGENG 2013: Intelligent Information, Control, and Communication Technology for Agricultural Engineering; 87620B (2013) https://doi.org/10.1117/12.2019678
Event: Third International Conference on Photonics and Image in Agriculture Engineering (PIAGENG 2013), 2013, Sanya, China

Abstract

A novel data mart based system for fishery rescue field was designed and implemented. The system runs ETL process to deal with original data from various databases and data warehouses, and then reorganized the data into the fishery rescue data mart. Next, online analytical processing (OLAP) are carried out and statistical reports are generated automatically. Particularly, quick configuration schemes are designed to configure query dimensions and OLAP data sets. The configuration file will be transformed into statistic interfaces automatically through a wizard-style process. The system provides various forms of reporting files, including crystal reports, flash graphical reports, and two-dimensional data grids. In addition, a wizard style interface was designed to guide users customizing inquiry processes, making it possible for nontechnical staffs to access customized reports. Characterized by quick configuration, safeness and flexibility, the system has been successfully applied in city fishery rescue department.

Citation Download Citation

Jun Pan, Haiguang Huang, and Yousong Liu "Design and implementation of fishery rescue data mart system", Proc. SPIE 8762, PIAGENG 2013: Intelligent Information, Control, and Communication Technology for Agricultural Engineering, 87620B (19 March 2013); https://doi.org/10.1117/12.2019678

ACCESS THE FULL ARTICLE

INSTITUTIONAL
Select your institution to access the SPIE Digital Library.

SELECT YOUR INSTITUTION

PERSONAL
Sign in with your SPIE account to access your personal subscriptions or to use specific features such as save to my library, sign up for alerts, save searches, etc.

PERSONAL SIGN IN

No SPIE Account? Create one

PURCHASE THIS CONTENT

SUBSCRIBE TO DIGITAL LIBRARY

50 downloads per 1-year subscription

Members: $195

Non-members: $335 ADD TO CART

25 downloads per 1 - year subscription

Members: $145

Non-members: $250 ADD TO CART

PURCHASE SINGLE ARTICLE

Includes PDF, HTML & Video, when available