Published: Standard Data Model

Here is a paper that I published and presented at the Southern Association for Information Systems 2012 conference.

It proposes a standard data model to be used for customs EDI filings.

Standard Data Model for Customs EDI Filings

http://sais.aisnet.org/2012/Grecol.pdf

————————————————————–

 

STANDARD DATA MODEL FOR CUSTOMS EDIFILINGS

Michael L. Grecol

GeorgiaSouthern University

mgrecol@hotmail.com

ABSTRACT

Electronic Data Interchange (EDI) is a popular way in which business entities exchange transactional data. A significant challenge in using EDI is that different entities have different specifications for the transmission of the same data. An example of this is border security filings that are required by many countries in order to gain admissibility of imported merchandise. Various countries require different EDI data formats.  This paper will propose a standard data model named the Single Filing System (SFS) that captures the variability of these standardized formats and allows them to be used as database inputs and outputs. It simplifies the processing of shipment data for multiple heterogeneous EDI data formats prior to exporting containerized sea freight.

Keywords

EDI, Data Model, Customs Data Model, Security Filing, ABI, Data Format, B2B Protocol, Single-Window, SAFE Framework

This entry was posted in Database Technology, Published Works and Research. Bookmark the permalink.

2 Responses to Published: Standard Data Model

  1. Jhonatan says:

    I’ve read your paper. It’s very interesting. Invoice_Part_Details entity has an attribute: Invoice_Date. I think it’s wrong. Invoice_Date must belong to the Invoice entity.
    However, I like your data model. At work, we’re building a system for a freight forwarder company, and I’m in charge of the EDI integration with trading partners.
    I’ll take some ideas from your paper.
    Thanks.

  2. Thank you for the correction, Jhonatan . I am glad you found it useful.
    I have worked for freight forwarders for years. Very interesting business and lots of opportunity for automation.
    Good luck with your project.
    -Mike

Leave a Reply

Your email address will not be published. Required fields are marked *


× four = 16

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>