D-CRANE: A database system for utilization of cranes

M. Al-Hussein, S. Alkass, O. Moselhi

Research output: Contribution to journalArticlepeer-review

31 Citations (Scopus)

Abstract

Crane selection is a time consuming process that involves extensive data manipulation. Several systems have been developed to assist in selecting cranes and in planning their lifts. These systems lack the support of a comprehensive database to provide information about crane configurations, their lift capacity settings, and rigging equipment. Although crane manufacturers provide data for their cranes, these data are not always consistent and do not follow a standard format. This creates frequent problems for crane users, especially when interpolating the load charts. This requires the users to make decisions based on job conditions and categories of cranes, which can lead to costly mistakes. This paper describes the development of a comprehensive database (called D-CRANE) designed to support efficient selection of cranes. D-CRANE has been developed in collaboration with an industrial partner. It includes operational information about crane geometry, lift configurations, lift capacity settings, accessories, and attachments. D-CRANE has a number of interesting features: (i) powerful graphics capabilities, featuring a multimedia environment and a practical user-friendly interface; (ii) capacity to accommodate different types of commercially available cranes; (iii) powerful storage, sorting, and query routines; (iv) flexibility in using metric and empirical units; (v) capability of operating in a network environment, and (vi) minimum disk storage space. D-CRANE is a relational database designed using entity relation diagram and is implemented using MS-Access database management system. A case example is presented to demonstrate the use and capabilities of D-CRANE.

Original languageEnglish
Pages (from-to)1130-1138
Number of pages9
JournalCanadian Journal of Civil Engineering
Volume27
Issue number6
DOIs
Publication statusPublished - 2000
Externally publishedYes

Keywords

  • Crane selection
  • Database management system
  • Planning critical and heavy lift

ASJC Scopus subject areas

  • Civil and Structural Engineering
  • General Environmental Science

Fingerprint

Dive into the research topics of 'D-CRANE: A database system for utilization of cranes'. Together they form a unique fingerprint.

Cite this