140 likes | 265 Views
MARVIN - EP 29049 Review Meeting 06 /12/2000. Interaction with SYRIOS Sotiris Makris. CONTENTS. Overview of Shipyards’ operation SYRIOS concept SYRIOS Client-Server architecture SYRIOS database elements relevant to MARVIN Communication through the MEIT XML based data exchange
E N D
MARVIN - EP 29049Review Meeting06/12/2000 Interaction with SYRIOS Sotiris Makris
CONTENTS • Overview of Shipyards’ operation • SYRIOS concept • SYRIOS Client-Server architecture • SYRIOS database elements relevant to MARVIN • Communication through the MEIT • XML based data exchange • Status of Implementation
SYRIOS concept • A software package to support: • Customers management • Enquiries management • Estimates management • Contracts management • Work execution management • Planning and Scheduling of work in Shipyard in Long-term, Medium-term and Short-term • Invoicing ship repair services
SYRIOS DB SYRIOS modules Products INTERNET INTRANET Syrios Tables SYRIOS architecture • SYRIOS is a typical client server application. • SYRIOS is implemented in Java 1.2 • SYRIOS uses a Relational database to store the ship repair information (ORACLE 8i & MS SQL Server 7.0)
COMMUNICATION through the MEIT Ship owner Shipyard Information management Sales Scheduling Tendering Response Interface Interface MEIT as middleware Request
COMMUNICATION through the MEIT Ship owner Shipyard Response Request
Status of Implementation Current Status • Database elements required are available • Data exchange are identified (Deliverable T1.2D2) • XML data models are under development (DTDs) Further work • Implement XML translators
Example XML data model (DTD) <!ELEMENT Job (Job.Customer_job_id?,Job.job,Job.User_defined_Job?,Job.Indentation,Job.Description?,Job.Additional_info?,Job.Price_of_job?)> <!ELEMENT Job.Customer_job_id (Label)> <!ELEMENT Label (#PCDATA) <!ELEMENT Job.job EMPTY> <!ATTLIST Job.job Job_type (SERVICES_DRY_DOCKING|CLEANING_AND_SLUDGE_REMOVAL_FROM_CARGO_AND_BALLAST_TANKS|CHEMISTS_CERTIFICATE|PILOTAGE|TUGBOATS|LINE_HANDLERS|WINDLASS_AND_MOORING_WINCH_OPERATION|WHARFAGE|Fire_Watch|Fire_Hoses_Connection|Fire_Line_Water|USER_DEFINED) #REQUIRED > <!ELEMENT Job.User_defined_Job (Text)> <!ELEMENT Text (#PCDATA)> <!ELEMENT Job.Indentation EMPTY> <!ATTLIST Job.Indentation Indentation_type (Main_Item|Sub_item|Item_description) #REQUIRED > <!ELEMENT Job.Description (Text)> <!ELEMENT Job.Additional_info (Text)> <!ELEMENT Job.Price_of_job (Price)> <!ELEMENT Price (Price.ammount,Price.ammount_type,Price.currency)> <!ELEMENT Price.ammount (#PCDATA)> <!ELEMENT Price.ammount_type EMPTY> <!ATTLIST Price.ammount_type Price_type (per_mile|per_day|per_service) #REQUIRED > <!ELEMENT Price.currency EMPTY> <!ATTLIST Price.currency Currency_type (EURO|USD|YEN|DMK) #REQUIRED >
Main Targets • Support exchange of large volume of data • Electronic enquiries • Electronic transfer of work specification list • Import and Export of data using the XML standard
Summary • Shipyards’ operation • SYRIOS concept • SYRIOS Client-Server architecture • SYRIOS database elements relevant to MARVIN • Communication through the MEIT • XML based data exchange • Status of Implementation • Main Targets