ERLCA-DB User Manual - ECO
Contents
1. a A 4 amp P E This is just a temporary draft By using this weighting factors the system can display a list of items ordered based on the most suited criteria for the user d i 3 34 a E 7 i CR ds dt i k ER ip Lae FHILL Figure 3 32 The final solution for the weighting factors aed b Damiri Coating Coating Coating Coating Coating Coating Coating Airless System Airless System Airless System Airless System Airless System Airless System Airless System D Gee Paint Anest Iwata 4sturo Originali Maves Ecco Airlessco HSS Series Titan Tool International Hi Tec Spray Paint Equipment AIRLESSCO LP400 240v Airless Sprarer ALS 663 Airless Spray Gun Asturo 45 Ecco Hydric LF 1057 HD GAS hydraulic Airless Paint Sprayers H5511000 IMPACT 1640 1 30 GPM Electric Piston Pump MET Xtreme Airless Sprayers Figure 3 33 An example of the list of items 3 2 5 Panel of Experts View View Fiew Fiemw View Yiew Yiew eco R ITe C ERLCA DB User Manual In order to access this section click on the Panel of Experts menu In this section short information about the involved experts can be found and a read only forum for unregistered users The experts can edit their own public information In the case of registered users the page offers the possibility to contact the experts by using the cont2. In this section are described two facets of the database the actual structure of the database and the WEB Access structure used for interfacing with the information present in the database 3 1 Database structure The database was developed considering the needs identified during the project from the partners equipment producers shipyards ship designers and other actors involved in the retrofit processes eco R E F ITe Cc ERLCA DB User Manual Level 0 Virtual networking space Level 1 Level 2 Level 3 Level 4 Figure 3 1 Database structure eco REFITec ERLCA DB User Manual The database was designed to be deployed on 4 vertical levels Figure 3 1 each level going into more detail for each item that is introduced into the database The entire database is designed to expand by itself as new data is added This is done by the users as in order to add new data it is necessary to add new fields into the database see 2 2 2 Database Catalogue Best practices Equipments categories Materials and structures categories Technologies categories Engineering services categories Eco innovation shipyard categories PK Jid PK FK2 FK3 id PK FK2 id PK FK2 FK3 id PK FK1 FK2 FK3 id PK FK1 FK2 id eve 1 name name name name name name shipyard FK1 template FK1 FK3 template FK1 template FK1 category FK2 template Figure 3 2 First level of the Database structure
3. The first level Figure 3 2 consists of general information regarding Best Practices Equipment Categories Materials and Structures Categories Technologies Categories Engineering Services Categories Eco innovation Shipyard Categories Each of the enumerated categories contains a number of basic information which was identified in the beginning of the database development The second level contains the categories and the description template for the items in Level 1 The third level stores the properties of the items from Level 1 described in Level 2 The forth level contains in depth details of the properties for each subcategory 3 2 WEB Access structure The web access home page offers the possibility for different users to access the database and to use the tools developed during the project The main page describes the background for the implementation of the database and the objectives of the project Overview Database Catalogue Best practices Yalue Engineering Panel of Experts Newsletter Tools Survey Welcome to ECOREFITEC DB Web Access Login pe New features will be available soon User Password Eco REFITEC Data Base design Survey Q ECO REFITEC DB Design Surve d Contact Project Name Background Due to the IMO and EU recently developed measures to prevent pollution from ships and shipyards respectively such as those aimed at reducing atmospheric pollution and addressing climate change and global warming the Eur
4. 0625 00526 00509 Criteria Precentage REM Em Water 13 35 Consumption Consistency Evaluation re ee ses5s3Ss 382 Consistency Ratio R SE 87 92 NF Pellet tom Consept ion l Figure 3 29 The third level of decision for the environmental criteria This is just a temporary drat EEE is just a temporary draft eco R E ITe Cc ERLCA DB User Manual Show Explanations Third Level decision Operating Equal importance Equal importance Select SuD Crtera Weighting Factor Calculation 0 3335 0 3333 03333 03333 0333 033 0 3333 0 3333 Criteria Precentage 3 Compiance With 33 33 a Standards 2 Health and Safety 33 33 sal 7 a Consistency Evaluation 10 1 1 i Consistency index Ci 0 0001 u Consistency Ratio CR 5 4 This is just a temporary draft Figure 3 30 The third level of decision for the operating criteria Elo Explanation Third Level decision Organizational Weighting Factor Calculation Criteria Precentage ees Latour SE 33 339 Regier armando Ee ae Ric armarios parar a22 2 a Consistency raxit Conhivency Radio CR This is just a temporary draf ia just a temporary draft Figure 3 31 The third level of decision for the organizational criteria eco REFITec Show Explanations ERLCA DB User Manual Statistics 4
5. SOL Server Access Visual Fox Pro web programming HTML JavaScript PHP ASPX XML programming languages Pascal C C C Java developing applications for RFID systems in C and Microsoft Access SOQOL Server databases developing applications for mobile devices using C NET Compact Framework connected to web services Short C Change Figure 3 41 Account Settings Page Change the e mail address To save the new information just presses the Save Changes button 4 Final note This user manual has been developed under the Eco REFITec project Eco innovative refitting technologies and processes for shipbuilding industry promoted by European Repair Shipyards project reference 266268 call ID FP7 SST 2010 RTD 1 funded by the European Commission under the 7 Framework Programme As the project is ongoing and the database is under constant optimization the user manual may change For the updated version please check the ERDB LCA website under help menu 5 References 1 United Nations Environment Programme 2011 Global Guidance Principles for Life Cycle Assessment Databases 2 Raul Carlson Johan Tivander CHALMERS 2001 Data definition and file syntax for ISO TS 14048 data exchange with data storage format based on ISO TS 14048 eco R ITe C ERLCA DB User Manual 3 Karolina Flemstr m Ann Christin Palsson CHALMERS 2003 An interpretation of the CPM data qualit
6. add a new field If the administrator approves this the field will be added to the template of the specific structure material category eco R IF i Te Cc ERLCA DB User Manual In order to add a new field you simply need to click on the Add new field button from the lower right corner of the form When you press the button the initial form will be extended and the Add new field form will be displayed Add a new field Field name Required O Yes No Description Value PT Add new field Figure 3 16 Wizard for adding a new material for ship retrofit Step 2 Add new field Save In the Field name text box you need to enter the property name Following this you need to choose if this property field is mandatory to be filled or not for the other structure s material s There is also a box provided for the description of the property The value field 1s optional but if you type a value it will be saved This value can be edited later as well For example if the new property is Approval date the description should be detailed such as The date of approval by IMO and the value could be 10 22 2012 or 10 22 2012 If you want to save the information entered you should press the Save button from the lower left corner of the form 3 2 2 3 Add new module When logged in go to the Database Catalogue and from the drop down list choose the Eco Innovati
7. already available in Europe not only in the waterborne sector repair shipyards will be more competitive and it will allow to keep and increase their market share Objectives The overall objective of ECO REFITEC project is to improve the competitiveness of the European shipyards and SME s involved in shipbuilding shiprepair amp recycling As ship owners and operators have to focus much more onto adopt measures to prevent or reduce any pollution from ships new and existing ECO REFITEC project aim to develop IT supported tools for retrofit impact evaluation on ship life cycle economy energy environmental performance and safety and to identify develop explore eco retrofitting technologies and solutions for existing fleet to comply with some current and future IMO standards In addition as the industry has to fulfil a wide range of constantly increasing requirements in the scope of environmental legislation and regulation ECO REFITEC aims also to provide practical and cost effective solutions to major environmental problems associated to the new eco innovative process to be carried out in ship retrofitting activities in European repair shipyards ERLCA DB User Manual SUBSCRIBE TO NEWSLETTER Aim The aim of the ECO REFITEC project WP2 is to identify technological eco innovation solutions processes materials and modules that might be of relevance to improving the performance of ship repair industry especially to address the
8. be filled The properties are generated automatically based on the process description template The process description template contains the list of recommended properties necessary for uploading a process This template is dynamic and the user could request to add a new property If the administrator approves this the property will be added to the template of the specific process category Category Coating Process Ainess System The name of the equipment The equipment supplier Please select from this drop down list bd The name of the equipment supplier The website of the equipment supplier Equipment Cost 6 o Coat Delivery Rate gpm Figure 3 11 Wizard for adding a new process for ship retrofit Step 3 Fields eco R Te Cc ERLCA DB User Manual In order to add a new field you simply need to click on the Add new field button from the lower right corner of the form When you press the button the initial form will be extended and the Add new field form will be displayed Add a new field Field name Required O Yes No Description value o Add new field Save Figure 3 12 Wizard for adding a new process for ship retrofit Step 3 Add new field In the Field name text box you need to enter the property name Following this you need to choose 1f this property field 1s mandatory to be filled or not for the other processes There is also a box p
9. future retrofit activities to be carried out in small amp medium size shipyards The specific objectives of this work package include the development of a ECO REFITEC Database ERLCA DB taking into account the selected types of vessels analyzed which are relevant both for European shipping companies and shipyards and the development of tools for data base operation and updating In order to conceive the features of the eco refitec database we are kindly asking you to help us with your opinion We need your insight so please take a few minutes to tell us what you need from the Eco Refitec Database TAKE PART IN THE SURVEY Figure 3 35 The overview of the eco REFITec Database Design Survey In order to fill the questionnaire of the survey campaign click on the Take Part in the Survey button By clicking the button you will be redirected to the survey website x Gay eco REFiTec retrofit activities It is an ambitious and important undertaking The Eco Refitec Database Team NEXT PAGE ECO REFITEC DB Design Survey Page 1 of 10 As explained in the starting page the ECO REFITEC online Database will collect and analyze information on technological eco innovation solutions processes materials and modules that might be of relevance to improving the performance of ship repair industry especially to address the future Getting your perspective is therefore crucial for understanding what you need Many t
10. next step In the third step the user is able to input detailed information for the process The first part of the page shows a note with a few instructions on how to fill the form eco R E ITe Cc ERLCA DB User Manual Overview Database Cataloque Best practices Yalue Engineering Panel of Experts Add a new process for ship retrofit Q Step 3 Please enter the information regarding the process Please note If you could not find a proper field where to Insert the information please press on the add new field button and proposed another field If you just added a new category of processes it is possible ta dont have any available fields Please be free and propose fields for this category of processes You can come back to this item in order to continue editing it by typing the follwoing address http 92 55 144 224 ecorefitec index php task addprocess amp ste p 3 amp id 4 amp passkey 4b505a0 65 7458 cficc3 794503 e0bd3 Figure 3 10 Wizard for adding a new process for ship retrofit Step 3 In addition as the new process is added a direct link to the information is provided allowing the user the possibility of returning at any time to edit the information he or she supplied to the database Note The users can edit only the information that was entered from their account In the second part of the page the chosen process category and process type will be displayed Next there will be a series of available properties to
11. where users have the possibility to change their name username password and additionally have the option to input or change information regarding their e mail organization and CV The e mail organization and CV are by default left blank as the users have the option to add more data or not Account Settings Q Name Laurentu Dancea Change Usemame loancea Change Email Change Password Midas o oh bh odiado do Change Organization Change Short C Change Figure 3 40 Account Settings page In order to change a field it is necessary to press the Change button in the right side of each field When pressed a submenu will be displayed which will give the possibility to change the existing data and will ask users to input the password This is done in order to prevent the change of user information from stations left unattended eco R ITe C ERLCA DB User Manual Account Settings Q Name Claudiu Fercu Change Username fercu Change Email cfereuuniv ovidiuis ro Enter your password Email Change Save Changes Password PEAS BA B BA SE BA BA BA BA Change Organization ovidius University of Constanta Change Claudiu Fercu is an assistant researcher specialized in computational mathematics and modern information technology with a considerable portfolio in the development of databases technical applications and e learning platforms The main skills that define him are design and maintenance of databases MySQL Microsoft
12. In the upper right corner you will find the Add new process into the DB button By clicking on it a step by step wizard will be launched Overview Database Catalogue Best practices Yalue Engineering Panel of Experts Newsletter Tools Survey Add a new process for ship retrofit V Welcome back pet Step 1 Please choose the category of the process You are successful logged in as Laurentiu Oancea Category Please select from this drop down list v Account Settings logout lf the category of process it s not in the list above please enter the name of the category in the field below Contact Figure 3 7 Wizard for adding a new process for ship retrofit Step 1 In the first step the user has the option to choose an existing process or if there is the need to add a new process which is not present in the dropdown list it can be added in the provided field below the drop down box eco REFITec Overview Database Catalogue Best practices Yalue Engineering Panel of Experts Add a new process for ship retrofit Q Step 1 Please choose the category of the process Category Please select from this drop down list i Please select from this drop down list Coating proposed Cutting proposed Welding proposed Next step ERLCA DB User Manual Newsletter Tools Survey Welcome back You are successful logged in as Laurentiu Oancea Account Settings logout Contact Figure 3 8 Wi
13. act form provided for each expert The section offers a discussion forum where registered users can post opinions questions facts ideas and others In order to access the forum you need to click on the Forum button on the lower right corner of the section or choose from the Panel of Experts menu the Forum menu item 3 2 6 Newsletter In order to access this section click on the Newsletter menu Here the registered users can access the archive of periodic newsletters or to subscribe to the newsletter mailing list to receive the newsletter by e mail The subscription form can be found in the right side of the page under the login form and is available to all users registered or not In order to subscribe you need to write your name and your e mail address in the designated boxes and press the submit button eco R F ITe C ERLCA DB User Manual Overview Database Catalogue Best practices Yalue Engineering Panel of Experts Newsletter Tools Survey Newsletter Archive Q Welcome back d ECO REFITEC DB ECO REFITEC Database Newsletter 01 ou mie ed oggagimas Newsletter 01 Claudiu Fercu Eu Inside this issue a ECO REFITEC launches its Database on Eco Innovation You are an administrator of the ese REFITes database This means that you can add a and edit your own items from the database Account Settings logout Click to Download Newsletter Contact v ST ECO REFITEC Project Newsletter 01 Project Name Newsiett
14. ample if the new property is Approval date the description should be detailed such as The date of approval by IMO and the value could be 10 22 2012 or 10 22 2012 If you want to save the information entered you should press the Save button from the lower left corner of the form 3 2 2 4 Database search engine In order to search the database for information the users have the possibility to use the Database Search Module which 1s available for all users registered or visitors This module can be found by accessing the Database Catalogue menu and choosing the Database Search Engine item Overview Database Catalogue Best practices Yalue Engineering Panel of Experts Database Search Engine Q Search word Cataloque All Catalogues Figure 3 23 Database search engine form As shown in the picture above you can search in the database by typing a keyword in the search box The default setting is for searching in the entire database while also the user has the option to filter the search to processes modules and structures and materials eco R ITe C ERLCA DB User Manual For the search some special characters can be used within the keyword to replace unknown letters or words to act as wildcard characters One of the symbols that can be used is asterisk or star if you do not know part of the word or the entire word e g if you want to search ballast you can use a
15. anations Choose Your First Level Criterias Economic Enviormental Operating Organizational Next Step This is just a temporary draft Figure 3 24 The first level of criteria for the choosing of weighting factors Seer Enpara Second Level decision Equal Impotance Equal Importante Equal Importance Equal Importance Back This is just a temporary draft Figure 3 25 The user needs to choose the importance of each criteria on the level 2 of the hierarchy by using a grading system eco R E ITe Cc ERLCA DB User Manual Grading system Intensity of importance Definition Explanantion 1 Equal importance Two activities contribute equally to the objective 3 Moderate importance Experience and judgment strongly favor one activity over the another 5 Essential importante Experience and judgment strongly favor one activity over the another 7 very strong importance An activity is strongly favored and its dominance demonstrated in practice 4 Extreme importance The evidence favoring one activity over another is of the highest possible order of affirmation 2 Equal or Moderate importance When compromise is needed 4 Moderate or Essential importance When compromise is needed 6 Essential or very strong importance When compromise is needed 8 very strong importance or extreme importance When compromise is needed This is just a temporary draft Figure 3 26 The values of the grading system and its definition an
16. cope of the Eco Refitec database is to share and make available all the technological eco innovations developed during the project In this respect a friendly tool to facilitate the upload in the database the eco innovation processes modules materials and structures Also was integrated a full accessible catalogue that includes all eco innovation processes materials modules and ship retrofit practices from the database In order to keep the target group informed about the latest eco innovation processes materials modules and ship retrofit practices included in the database four periodic newsletters will be conceived The newsletter will be generated automatically with the information from the database and will be sent to target group by e mail Another module of the database is a tool to publish the information from the database using self described XML In this way the project will support the community to develop new applications using information extracted from the Eco Refitec database The module for adding items in the database is extended with an automatic updating tool based on appropriate meta data ontologies standards markets supply chain that is developed in order to collect information published on the web This toll will also pay an important role to determine the index of trust of items included in the database This is described in more details in chapter 4 Assessment of data from the Database 3 How to use the Database
17. d explanation Second Level decision Equal Importance Equal importance ue Equal importante EE Select Sub Crteria v Weighting Factor Calculation 0 4 05714 0 2759 0 1818 0 2 0 2857 0 5517 0 3636 0 2 O07 14 0 1379 0 3636 0 2 0714 0 0345 0 0908 Criteria Precentage Emniormental 34 02 Consistency Evaluation consseneyimaenco 02026 onson Rato 0 This 15 just a temporary draft Figure 3 27 The values calculated by the system for the second level of the hierarchy eco R E E ITe C ERLCA DB User Manual Third Level decision Economic Equal Importance Equal Importance Equal Importance Equal Importance Weighting Factor Calculation T Criteria 0 5025 0 6438 0 4093 0 3 0 1658 0 2146 0 4093 0 3 0 1658 0 0708 0 1364 0 3 0 1658 0 0708 0 045 0 1 Criteria Precentage 2 Ylaste Emissions 355 Treatment Cost Consistency Evaluation BSResesees esses Consistency Index Ch 1272 Consistency Ratio CR This is just a temporary draft Figure 3 28 The third level of decision for the economic criteria Show Explanations Third Level decision Enviormental Equal importance Equal importance Equal inportance Equal importance Weighting Factor Calculation 01818 01429 2 0 3077 025 02105 01818 01429 04 01538 025 02105 01818 01429 04 0 0769 0125 02105 01818 0 1429 04 0 0769 0 0625 01053 01818 01429 01 00769 0
18. d users to login and add edit or delete information as it will be described below 3 2 1 Overview The page includes a short overview of the project database and its functions In addition it contains the links to the online survey which has the purpose of gathering data regarding the impact of the database 3 2 2 Database Catalogue The Database Catalogue is split into four main sub pages Eco innovation processes for ship retrofit co innovation structures and materials for ship retrofit Eco innovation modules for ship retrofit Database search engine By accessing one of these pages the user can view comprehensive information of the specific items that are included in the database Overview Database Catalogue Best practices Yalue Engineering Panel of Experts Newsletter Tools Survey Eco Innovation Processes for Ship Retrofit Q Login User Password Shielded metal arc im gt E Welding welding SMAW ESAB Caddy Arc 251i View Shielded metal arc Stickmate LX 235 LOGIN Welding welding SMAW Hobart AC 160 DC talos Welding TIG welding Lincoln Electric Invertec V311 T View AC DC TIG Welder Contact Q Project Name Figure 3 4 Database Catalogue view for not registered users Also according to the user access rights he or she can contribute to the database by proposing the input of new items When logged in the Add new button process material structure or module appea
19. eco R E ITe C ERLCA DB User Manual ERLCA DB User Manual eco R E F l Te C ERLCA DB User Manual Contents RR MAIO eli io OT soe ca crednantactscnecdouzaustonaaceareactnaeispscassauet E RR 3 2 Qhescope ofthe DADAS asc dosage en RES mene aee 3 3 How TO USE the Database sta sosecxrstitdeasatanedesnnoiidansvatevunsteidansatanctennbbsidaesnabarnnsieldceentansteemeessteest 4 3 1 a ASS SOCO sas sis ean sh anaca cc chacascn vac gacccndeesiganaa seca nieesacenccqassanteuananteanbacsesereneoccasece 4 32 WEB FCCC 55S NE oe rss cher onscreen E dato umacaneasos E E 6 3 2 1 Ey unia cora o ta e E a 7 3 2 2 Database Catalo DO serena r Oe ee 7 3 2 3 DoD OS E Escadas sareteandidanavehaboneens sated iauionndiaaeenenee ses 19 3 2 4 NV aN 1 ce CHINO 4 555 RO REED E 19 3 2 5 Pate WOT E RDNS scene sesccossesstaseiccsenamcamacerysesquesieausasaioctesaecustacereseaguesieaudasaieetesaecannent 24 3 2 6 NENS EUC tec att eset a ias tona E R E 25 3221 SOON ahs cae E E E ann po DE ERR USD JR RN 26 3 2 8 IY o TEE AEE E EEE E T T A TAT 26 3 2 9 Pe OU SUI ce eter E E E A E E N A E T 28 Be a TOE oo E E EE SD aa art 30 3 Rele S eanan ee a 30 eco R E F ITe C ERLCA DB User Manual 1 Introduction The database was developed under the Eco REFITec project which was financed by the European Commission under the Framework 7 programme The small or medium scale enterprise focused research Project ECO REFITEC Eco innovative refitting technologies and processes for shipbu
20. er E Sai inside this issue Eco innovative refitting technologies and eco REFITec Shipyard opportunities and challenges regarding greening existing fleet processes for shipbuilding industry i Development of eco innovation retrofitting practices and database promoted by European Repair Design tools for evaluation and management of eco innovation retrofit processes Shipyards and life cycle analysis Project Acronym ECO REFITEC Project Reference 266265 Click to Download Newsletter Call ID FP 7 SST 2010 RTD 1 Start Date 2011 01 01 Figure 3 34 The actual archive of newsletters 3 2 7 Tools This section offers tools for importing and exporting data from the database in the form of xml files For this go to the Tools menu and depending on your user right access you can import or export data The export function is available for both registered and unregistered users and is displayed in the top part of the tools page The web application can export the information from the database in xml format The user has the possibility to choose which information they want to export by selecting it from the menu tree from the left side of the page After the information 1s selected press the xml button to export The import function is available only for registered users as the information that will be imported needs to be checked by the administrator Until approved the information is not available to the public The i
21. er will need to have very good IT knowledge in the field of code writing and scripting In this respect a friendly interface must be developed usually like an application or website The scope of this application is to offer a user friendly view of the items included in database to offer possibilities for adding new data modify existing data export data Beside of these basic capabilities a database interface must offers to the user application and context of using the data stored in the database In respects of these considerations in the Eco Refitec project we decided to use an open source database management system and we choose the MySQL DBMS because of its scalability and flexibility high performance high availability robust transactional support web and data warehouse strengths strong data protection comprehensive application development management easiness open source freedom all of these correlated with the lowest total cost of ownership As the interface we developed a web application where the user have the capabilities to access the information by using the database catalogue contribute to the database and perform value analyses on the data included in the database Further on the users will have access to the best eco R E F ITe C ERLCA DB User Manual practices developed in the project and will have the possibilities to access the life cycle assessment for the test cases developed in the Eco Refitec project The main s
22. hanks for taking a few minutes of your time for this survey In case of problems with filling the questionnaire please turn to the survey helpdesk caes univ ovidius ro Figure 3 36 The first page of the eco REFITec Database Design Survey The user guide for filling the survey form is displayed step by step on the survey webpage eco R ITe C ERLCA DB User Manual 3 2 9 Account settings In order to experience full access to the database and its tools the users need to login by means of a username and a password which are provided by the administrator of DB Web Access Login User Password Figure 3 37 The login form If the login is unsuccessful an error will be displayed Login im Incorrect username and password User Password Figure 3 38 Incorrect username and password When the users are logged into the DB Web Access a welcome back message appears Welcome back You are successful logged in as Laurentiu Qancea Account Settings logout Figure 3 39 You are successful logged in eco R ITe C ERLCA DB User Manual In the first phase of the registration on the DB Web Access the users are given a default username and password After the login the users have the possibility to update their information by accessing the Account Settings option located 1n the lower left corner of the login box By pressing the Account Settings button there 1s opened the Account Settings page
23. ilding industry promoted by European Repair Shipyards aims to improve the competitiveness of the European shipyards and SME s involved in shipbuilding ship repair amp recycling The project will help repair shipyards and ship operators to perform a refitting of the existing fleet through technological development and new tools helping shipping benchmark their performance while improving the retrofit processes and products and assessing environmental and life cycle cost impacts 2 The scope of the Database A database is a system intended to ORGANIZE STORE and RETRIEVE large amounts of DATA easily It consists of an organized collection of data for one or more uses typically in digital form The data are typically organized to model relevant aspects of reality for example the ship repair processes modules materials and structures in a way that supports processes requiring this information for example finding a specific equipment for a specific work for ship repairing The term database is correctly applied to the data and their supporting data structures and not to the database management system DBMS The database data collection with DBMS is called a database system A database management system DBMS consists of software that operates databases providing storage access security backup and other facilities Usually DBMS does not have a very friendly interface and in order to operate the database by using a DBMS the us
24. lity of returning at any time to edit the information he or she supplied to the database Note The users can edit only the information that was entered from their account Overview Database Catalogue Best practices Yalue Engineering Panel of Experts Add a new material for ship retrofit Step 2 Please enter the information regarding the material Please note If you could not find a proper field where to insert the information please press on the add new field button and proposed another field If you just added a new category of materials it is possible to dont have any available fields Please be free and propose fields for this category of materials You can come back to this item in order to continue editing it by typing the follwoing address http 927 55 144 224 ecorefitec index php task addmodule step amp id 4 amp passkey b73 bi70bb00 ef3555d7918eb181da c Name Website URL PT Add new field Save Figure 3 15 Wizard for adding a new material for ship retrofit Step 2 In the second part of the page the chosen structure material category will be displayed Next there will be a series of available properties to be filled The properties are generated automatically based on the structure material description template The structure material description template contains the list of recommended fields necessary for uploading a structure material This template is dynamic and the user could request to
25. ll analyze the proposal and will validate or dismiss it 3 2 4 Value Engineering In the first part a tutorial can be found regarding the general introduction for Value Engineering and the approach that has been used In the second part the tool displayed can perform the value analysis of the existing processes modules and materials and structures found in the database In order to access the tool click on the Value Engineering menu A wizard will be displayed In the first step you need to define your priorities The system will analyze your priorities and will calculate the weighting factors Also the system will recommend a default set of values for the weighting factors which is calculated by using a learning loop algorithm having the inputs the previous inputs for the weighting factors The weighting factor are calculated by using the Analytic hierarchy process AHP developed by Thomas L Saaty and it is based on a hierarchy of decisions and priorities The hierarchy of decisions and priorities for the AHP will be defined in the deliverable D 2 2 Value Engineering of Technological eco R IF ITe Cc ERLCA DB User Manual Eco innovation for ship retrofit that will be delivered on month 30 June 2013 and it is not the scope of this deliverable D 2 3 In the picture below we took as the example the hierarchy of decisions and priorities defined for processes in the draft version of the D 2 2 Show Expl
26. logue Best practices Yalue Engineering Panel of Experts Newsletter Tools Survey Add a new module for ship retrofit Q Welcome back e Step 1 Please choose the category of the module You are successful logged in as Laurentiu Oancea Category Please select from this drop down list v Account Settings logout Please select from this drop down list Balast Water Management System Contact Q et Figure 3 19 Wizard for adding a new module for ship retrofit Step 1 Choose a category Please note that if you add a new type of module in the first phase it will have the status of proposed This is done in order to assure that only reliable data is introduced The approval is given by the administrator of the database while in the meantime the user can proceed to the next step If at this first step there is no selection or the proposal of a new process category an error will be displayed and you will not be able to proceed to the next step In the second step the user is able to input detailed information for the module The first part of the page shows a note with a few instructions on how to fill the form Overview Database Cataloque Best practices Yalue Engineering Panel of Experts Add a new module for ship retrofit Q Step 2 Please enter the information regarding the module Please note f you could not find a proper field where to insert the information please press on the add new field butt
27. lso ba ast or if you search ballast water equipment you can use ballast equipment Another symbol is 2 which can be used to replace one letter only e g if you want to search ballast you can use bal ast 3 2 3 Best practices In this section information in different formats can be found uploaded by registered users and mostly regarding the best practices for processes structures and materials and modules 3 2 3 1 Add a new best practice When logged in go to Best practices In the upper right corner you will find the Add new best practice button The wizard will be launched In this section the registered user has the option to write a best practice in a web text editor or to upload a document related to the best practice In the first step the user needs to enter administrative information related to the best practice including the organization which implemented it location where it was implemented time period when it was implemented and a short description In the second step the user should add detailed information related to the best practice This can be added in a web text editor or in the form of a document which can be uploaded After the user presses the submit button the best practice submission will be saved into the database and will have the status of proposed The administrator of the database in collaboration with the Panel of Experts wi
28. mported data needs to be in xml format 3 2 8 Survey In order to access this section click on the Survey menu This page is dedicated to the Eco REFITec Data Base design survey It contains background information and the objectives of the Eco REFITec project and the aim of the database Here the users have the possibility to subscribe to the newsletter by clicking the Subscribe to Newsletter button Eco REFITEC Data Base design Survey eco REFITec ECO REFITEC DB Design Survey Background Due to the IMO and EU recentiy developed measures to prevent pollution from ships and shipyards respectively such as those aimed at reducing atmospheric pollution and addressing climate change and global warming the European Repair Shipyards are facing a major challenge The retrofitting options and environmental upgrades of existing vessels are certain to form an increasingly significant component of additional work within what is already a very buoyant and competitive sector However the ability of the European shiprepair sector to meet the needs of the shipping industry cannot be taken for granted Efforts in research development and innovation RDI are needed as key drivers of success it is a powerful instrument to improve products and processes to maintain the technology bases and to ensure the proper level of skilled people to work in the maritime sector By using the technological knowledge eco innovation process that it is
29. on Modules for Ship Retrofit eco REFITec ERLCA DB User Manual Overview Database Catalogue Best practices Value Engineering Panel of Experts Eco Innovation Modules for Ship Retrofit Q Add a new module into the DE Module type Module name Supplier Balast Water Management system Electro Cleen TECHCROSS INC View Hamann AG Degussa Bate eet TENN SEDNA BWMS GmbH withdrawn from View 3 Y the market Figure 3 17 Catalogue for Eco Innovation Modules for Ship Retrofit In the upper right corner you will find the Add new module into the DB button By clicking on it a step by step wizard will be launched Overview Database Catalogue Best practices Yalue Engineering Panel of Experts Newsletter Tools Survey Add anew module for ship retrofit Welcome back Step 1 Please choose the category of the module You are successful logged in as Laurentiu Oancea Category Please select from this drop down list x Account Settings logout If the category of module it s not in the list above please enter the name of the category in the field below Contact Q Figure 3 18 Wizard for adding a new module for ship retrofit Step 1 In the first step the user has the option to choose an existing module or if there is the need to add a new module which is not present in the dropdown list it can added in the provided field below the drop down box eco R ITe Cc ERLCA DB User Manual Overview Database Cata
30. on and proposed another field lf you just added a new category of modules it is possible to dont have any available fields Please be free and propose fields for this category of modules You can come back to this tem in order to continue editing it by typing the folkwoing address http 92 55 144 224 ecorefitec index php task addmodule amp ste p amp id 3 amp passkey a3091388 abdcbhee0630902494e0130b Figure 3 20 Wizard for adding a new module for ship retrofit Step 2 In addition as the new module is added a direct link to the information is provided allowing the user the possibility of returning at any time to edit the information he or she supplied to the database Note The users can edit only the information that was entered from their account In the second part of the page the chosen module category type will be displayed Next there will be a series of available properties to be filled The properties are generated automatically based on the module description template The module description template contains the list of recommended properties necessary for uploading a module This template is dynamic and the user could request to add a new property If the administrator approves this the property will be added to the template of the specific module category eco R E ITe Cc ERLCA DB User Manual Category Balast Mater Management System Module name By whl Wanufacture Country Pd Process Pd Web
31. opean Repair Shipyards are facing a major challenge The retrofitting options and environmental upgrades of existing vessels are certain to form an increasingly significant component of additional work within what is already a very buoyant and competitive sector However the ability of the European shiprepair sector to meet the needs of the shipping industry cannot be taken for granted Efforts in research development and innovation RDI are needed as key drivers of success itis a powerful instrument to improve products and processes to maintain the technology bases and to ensure the proper level of skilled people to work in the maritime sector By using the technological knowledge eco innovation process that it is already available in Europe not only in the waterborne sector repair shipyards will be more competitive and it will allow to keep and increase their Eco innovative refitting technologies and processes for shipbuilding industry promoted by European Repair Shipyards Project Acronym ECO REFITEC Project Reference 266268 Call ID FP7 55T 2010 RTD 1 Start Date 2011 01 01 End Date 2013 12 31 Duration 36 months Activity code Sustainable Surface Transport SST Strengthening Competitiveness 85T 2010 5 1 1 Figure 3 3 Database Web Access Welcome Page eco R E ITe Cc ERLCA DB User Manual In order to further access the database and to input new data the DB web access offers the possibility for registere
32. ring Panel of Experts j Add a new material for ship retrofit Step 1 Please choose the type of the material Material type Please select from this drop down list Ifthe type of material it s not in the list above please enter the name of the type of material in the field below Figure 3 14 Wizard for adding a new material for ship retrofit Step 1 In the first step the user has the option to choose an existing structure material or if there is the need to add a new structure material which is not present in the dropdown list it can be added in the provided field below the drop down box eco R IF ITe Cc ERLCA DB User Manual Please note that if you add a new type of structure material in the first phase it will have the status of proposed This is done in order to assure that only reliable data is introduced The approval is given by the administrator of the database while in the meantime the user can proceed to the next step If at this first step there is no selection or the proposal of a new structure material category an error will be displayed and you will not be able to proceed to the next step In the second step the user is able to input detailed information for the structure material The first part of the page shows a note with a few instructions on how to fill the form In addition as the new structure material is added a direct link to the information is provided allowing the user the possibi
33. rovided for the description of the property The value field is optional but if you type a value it will be saved This value can be edited later as well For example if the new property is Approval date the description should be detailed such as The date of approval by IMO and the value could be 10 22 2012 or 10 22 2012 If you want to save the information entered you should press the Save button from the lower left corner of the form 3 2 2 2 Add new structure or material When logged in go to the Database Catalogue and from the drop down menu list choose the Eco Innovation Structures and Materials for Ship Retrofit eco REFITec ERLCA DB User Manual Overview Database Cataloque Best practices Yalue Engineering Panel of Experts Eco Innovation Structures and Materials for Ship Retrofit Add a new structure Add anew material into the DE into the DG Materials EE E E Test category Test Material Test Material supplier View Structures EE E E Test structure category name of the structure CAT of the structure ted suppliers Edit Figure 3 13 Catalogue for Eco Innovation Structures and Materials for Ship Retrofit In the upper right corner you will find the Add new structure into the DB and the Add new material into the DB buttons By clicking on one of the buttons a step by step wizard will be launched Overview Database Cataloque Best practices Yalue Enginee
34. rs in the upper right corner Overview Database Catalogue Best practices Yalue Engineering Panel of Experts Newsletter Tools Survey Eco Innovation Processes for Ship Retrofit Q Welcome back im seen You are successful logged in as the DB Laurentiu Oancea Account Settings logout Shielded metal arc ae z Welding welding SMAW ESAB Caddy Arc 251i view Contact Q Shielded metal arc Stickmate LX 235 welding welding sMaw Hobart AC 160 DC is Project Name Invertec 311 T View Welding TIG welding Lincoln Electric AC DC TIG Welder Edit Eco innovative refitting technologies and processes for shipbuilding industry promoted by European Repair Shipyards Figure 3 5 Database Catalogue view for registered users eco R E ITe Cc ERLCA DB User Manual 3 2 2 1 Add new process When logged in go to the Database Catalogue and from the drop down list choose the Eco innovation processes for ship retrofit Overview Database Cataloque Best practices Yalue Engineering Panel of Experts Eco Innovation Processes for Ship Retrofit Q Add new process into the DE s Shielded metal arc E a Welding welding SMAW ESAB Caddy Arc 251i view Shielded metal arc Stickmate amp LX 235 wakimg welding SMAW aani AC 160 DC mew E p Invertec Y311 T View Welding TIG welding Lincoln Electric AC DC TIG Welder Edit Figure 3 6 Page for viewing existing processes and adding new ones
35. site URL Pd The date when itwas commercially available Units installed PT Projected Production units Approval resolution by IMO for Active Substances Method Basic The date for active substance Basic approval Approval resolution for Active Substances Method Final Approval by IMO The date for active substances method final approval by IMO The Date for Landbased System testing The Date for Shipboard System testing Test site PT The Date for Type Approval Certificate Approval by Administration of withdrawn from the market Figure 3 21 Wizard for adding a new module for ship retrofit Step 2 Fields In order to add a new field you simply need to click on the Add new field button from the lower right corner of the form When you press the button the initial form will be extended and the Add new field form will be displayed eco R E Te Cc ERLCA DB User Manual Add a new field Field name Required O Yes Ono Description Value Figure 3 22 Wizard for adding a new module for ship retrofit Step 2 Add a new field In the Field name text box you need to enter the property name Following this you need to choose if this property field is mandatory to be filled or not for the other modules There is also a box provided for the description of the property The value field is optional but if you type a value it will be saved This value can be edited later as well For ex
36. y requirements in terms of ISO TS 14048 data documentation format 4 ISO TS 14048 2002 Technical Specification Environmental management Life cycle assessment Data documentation format 5 Saaty Thomas L Peniwati Kirti Pittsburgh Pennsylvania RWS Publications 2008 Group Decision Making Drawing out and Reconciling Differences 6 http lca jrc ec europa eu Icainfohub databaseList vm 7 http www gabi software com support gabi gabi lci documentation
37. zard for adding a new process for ship retrofit Step 1 Choose a category Please note that if you add a new type of process in the first phase it will have the status of proposed This is done in order to assure that only reliable data is introduced The approval is given by the administrator of the database while in the meantime the user can proceed to the next step If at this first step there is no selection or the proposal of a new process category an error will be displayed and you will not be able to proceed to the next step In the second step the user is prompted to input the process type This can be done by using a process which already exists or by using the second field to propose a new process type Overview Database Catalogue Best practices Yalue Engineering Panel of Experts Add a new process for ship retrofit Q Step 2 What type of proccess do you want to add Process type Please select from this drop down list vi lf the type of process it s not in the list above please enter the name of the process type in the field below Newsletter Tools Survey Welcome back You are successful logged in as Laurentiu Oancea Account Settings logout Contact Q Figure 3 9 Wizard for adding a new process for ship retrofit Step 2 If at this second step there is no selection or the proposal of a new process type an error will be displayed and you will not be able to proceed to the
Download Pdf Manuals
Related Search