The international database for certified reference...

COMAR Central SecretariatAUTUMN SEMINAR 2003 Finland

The international database for certified reference materials

Thomas SteigerRita Pradel

Federal Institute for Materials Research and Testing (BAM) Germany

Use of CRMs

Certified reference materials:

• are measurement benchmarks

• ensure reliability and comparability

• provide traceability in chemical analysis

• are required in quality assurance (ISO 17025)

One main problem for users:

• How to find the proper CRM needed?

Ways out:

• catalogues of producers

• websites of producers

• COMAR database

Main topics

• What is COMAR ?

- a short overview and history

• Information about CRM in COMAR

• How to get access to COMAR ?

• Examples for searching by- CRM name or description- country or producer- physical property- conventional property- field of application- composition of elements or molecules

• Statistics

What is COMAR?

COMAR has been developed to assist users in finding the reference materials they need

Software and performance

• Oracle 8.1 database, internet interface PHP 4.0

• Browser independent (Microsoft, Netscape, Opera)

• CRM information language is English

• Navigation language can be multilingual

• Update rights are given to the national or international coding centres

• CRM classification by harmonised catalogues

History

• French Laboratoire National d' Essais (LNE) proposed an index Code of Reference Materials in the late 1970s

COde MAteriaux Reference --> COMAR

• COMAR was improved and established in the mid 80s by LNE (France), LGC (United Kingdom) and BAM (Germany)

- not free of charge

- floppy disks were updated and distributed once a year

• Today COMAR is supported by 16 national or international coding centres

- free of charge for users since March 2003

- available via internet and can be directly updated

COMAR coding centres

AGAL/NARL Australia NCM Bulgaria

BAM Germany NIST USA

BIS India NITE Japan

CANMET Canada NMi The Netherlands

GUM Poland NRC-CRM China

IRMM European Union SMU Slovakia

LGC United Kingdom SP Sweden

LNE France UNIIM Russian Federation

Statistics September 2003

10452 CRMs from 248 producers in 25 countries

Australia Germany South Africa

Austria India Spain

Brazil Japan Sweden

Bulgaria Mexico Switzerland

Canada Mongolia The Netherlands

China Poland Ukraine

Finland Russia-Federation United Kingdom

France Slovakia United StatesEuropean and international institutions:IRMM/BCR IAEA WHO

Distribution of CRM by fields of application - September 2003

Ferrous13%

Inorganic10%

Organic5%

Biological3%

Industrial18%

Quality of life11% Non ferrous

Physical properties

Contained CRM information

Producer complete address of the producerAdditional information (purchase, experts, QMS) (pdf files, if available)CRM name e.g. BAM-376Description e.g. pure copper, Cu 99,5Application description e.g. intended usePackaging / storage e.g. 40 g bottle; storage at -20 °CForm of material e.g. discChemical compositionElements e.g. Ag 163.0 µg/gMolecules (CAS-No.) e.g. alpha-HCH (319-84-6) 32.0 µg/kgPhysical/conventional propertiesPhysical properties (ISO-No.) e.g. Activity / 9-33 4 - 400 kBqConventional properties e.g. Flash point /ISO 1516 10.3 - 9.8 °CData files certificate, report, references (if available)Quality CRM, RM, setting-up sample, pharmacopoeiaStatus available, out of stock, under development

Login screen

http://www.comar.bam.de/home

click button "Sign Up"click button "Sign Up"

Sign Up Screen for registration

Start screen for users

Search by CRM name

% = wildcard

click button "Apply Filter" to start the search

click button "Show Results"

Search by CRM name - show results

Search by CRM name - print preview

Search by CRM name - show results

Detailed information of the CRM (1)

Additional producer information

Detailed information of the CRM (2)

Certificate of the CRM "BAM-P123"

CRM search by descriptione.g. soil and sediment

click button "+" to open input fields

type „soil“ in the field description

click button "Apply Filter" to start the search

button "+" to open the description fields

Boolean operators: A = andN = notO = or

note: in the first line A and O = and

button "Apply Filter" to start the search

Search by country or producer

mark country and producer and click button

"Apply Filter" to open the catalogues

Search by country or producer e.g. Germany

select the country

click button "+"

select the producer

Search by physical propertye.g. dynamic viscosity ISO No. 3.23 [30-70Pa.s]

select the physical property from the catalogue click button "+"

limit the search by the criteria minimum and maximum value

click button "Apply Filter" to start search

Search by fields of applicatione.g. quality of life / foodstuffs

select "quality of life" from the catalogue click button "+"

select "foodstuffs" from the catalogue click button "+"

mark country and producer click button "Apply Filter" to open the catalogues

Search by Fields of Applicatione.g. Quality of Life / Foodstuffs

Search by composition / elemente.g. oxygen and nitrogen in steel

select "O" from the catalogue click button "+"

click button "+"

select "N" from the catalogue

limit the search by the criteria minimum and maximum value

click the button "Apply Filter"

mark "Main Application" and click the button "Apply Filter"

mark "Molecule / CAS_No."and click button "Apply Filter" to open the catalogue

Search by composition /molecule namee.g. alpha-HCH and beta-HCH

Search by composition / molecule namee.g. alpha-HCH and beta-HCH

type "HCH" and click button "+"

select "alpha-HCH/319-84-6" from the catalogue click button "+"

select "beta-HCH/319-85-7" from the catalogueclick button "+"

Search by composition / CAS_No.e.g. p,p’-DDE CAS 72-55-9

mark "Molecule / CAS-No." type the CAS_No.

click button "Apply Filter"

select "p.p'-DDE /72-55-9" click button "+"

select "4,4'-DDE/72-55-9" click button "+"

change the operator and click "Apply Filter"

Amount of CRMCountry 31.10.2003Australia 4Austria 93Brazil 61Bulgaria 212Canada 377China 1008European Union (IRMM) 714Finland 3France 1188Germany 888India 59Japan 870Mexico 27Mongolia 17Poland 76Russian Federation 708Slovakia 233South Africa 59Spain 14Sweden 253Switzerland 253The Netherlands 81UK 2265Ukraine 12USA 1031SUM of CRMs 10506

Development of user accounts

date number of users

2003-03-17 52

2003-04-22 104

2003-06-12 301

2003-07-31 441

2003-08-29 539

2003-09-30 747

2003-10-31 756

User's origin

further users of unknown origin (e.g.: .com, .org)

Argentina Estonia Korea South KoreaAustralia Finland Latvia SlovakiaAustria France Luxemburg SloveniaBelgium Germany Malaysia SpainBrazil Greece Mexico SwedenBulgaria Guatemala Mongolia SwitzerlandCanada Hong Kong Netherlands TaiwanChile India New Zealand TurkeyChina Ireland Norway UKCuba Israel Poland UkraineCzechia Italy Portugal USADenmark Japan Russia Vietnam

Access and search

date COMAR login and search approx. number of access17.03. - 30.04.2003 COMAR login 37417.03. - 30.04.2003 viewed search results 146801.05. - 30.06.2003 COMAR login 64201.05. - 30.06.2003 viewed search results 157001.07. - 31.08.2003 COMAR login 60001.07. - 31.08.2003 viewed search results 187801.09. - 31.10.2003 COMAR login 80801.09. - 31.10.2003 viewed search results 266517.03 - 31.10.2003 COMAR login 242417.03 - 31.10.2003 viewed search results 7581

You are kindly invited to visit and use COMAR !http://www.comar.bam.de

The international database for certified reference...

Documents

Transcript of The international database for certified reference...

การประเมินผลการใช้งาน Reference Database 2006 โดย วนิดา จันทนทัศน์

Symfoware Certified Professional データベース V9koitto.cocolog-nifty.com/blog/files/symfo-database-v9-1.pdf · 4.3.3 データベースのロード 76 4.4 保守・運用 77

Oracle Databaseリファレンス, 11gリリース1（11.1）...Oracle Database リファレンス, 11g リリース1（11.1） 部品番号: E05771-04 Oracle Database Reference, 11

Oracle Certified Professional (OCP) 10gfresno.ulima.edu.pe/sf/sf_bd011030.nsf/Actividades...Los instructores resolverán las dudas y consultas de los alumnos en ... Oracle Database

dba10g cg new - files.cnblogs.comfiles.cnblogs.com/files/minbear/Oracle_10g_DBA_考试说明.pdf · Oracle Database 10g Administrator Certified Master Paths . ... Workshop II Oracle

DATABASE RELASIONAL - kumoro.staff.ugm.ac.idkumoro.staff.ugm.ac.id/.../uploads/2008/12/database... · DATABASE RELASIONAL ¾Aplikasi manajemen database mengenal dua macam bentuk database:

Reference materials for GM testing...European Commission, Joint Research Centre, Reference Materials Unit Certified Reference Materials 2019 2.2 Matrix Materials 2.2.1 Certified for

Doradzamy, projektujemy, tworzymy, wdrażamy i … · • Oracle Database: SQL Certified Expert • Oracle Java 7/8 Certified Programmer ... • acle SOA Suite 11g/12cOr Certified

Migrando dados de um Oracle XE / Standard / Enterprise para um … · 2020. 4. 16. · 2015 Oracle Database 12c Certified Implementation Specialist ... 2000 Oracle PL/SQL Developer

RELATIONSHIP BETWEEN THE SPECIFIC SURFACE AREA … · Alumina 5.4 ± 0.2 Titania 8.1 ± 0.3 Table 1. Certified specific surface area of the reference materials used in the study.

KSAP certified

BAT TREE HABITAT KEY DATABASE REPORT 2016battreehabitatkey.co.uk/wp-content/uploads/2016/08/Bat-Tree... · BAT TREE HABITAT KEY DATABASE REPORT 2016 Reference as: Andrews H & Gardener

Certified Expert

€¦ · Web viewCzy osoba posiada certyfikat Oracle Database 12c Administrator Certified Professional, Oracle Real Aplication Clusters 12c Certified Implementation ...

Database-as-a-Service (DBaaS) Reference Architecture with ... · Database-as-a-Service (DBaaS) Reference Architecture with VMware and Tintri WHITE PAPER ! Authors:) VLSS:DeanBolton)

Gov · Web viewOracle Database 12c Performance Tuning Certified Expert; Ing. Ondřej Páleníček Specialista na správu aplikačních serverů Oracle Certified Associate, Oracle

Oracle OCP: Oracle Database 12c Administrator Certified Professional Study Guide

ASIS Norway - Certified Protection Professional (CPP) · 2018. 11. 29. · Certified Protection Professional (CPP)KVALIFISERINGSKRAV Sertifiseringen Certified Protection Professional

Oracle Certification Program 의모든것 - DBGuide.net · 2007-02-09 · Oracle Database 10g DBA OCM hhOracle Database 10g Administrator Certified MasterOracle Database 10g Administrator

Experience Certified

Oracle Databaseリファレンス, 11gリリース1（11.1）...Oracle Database リファレンス, 11g リリース1（11.1）部品番号: E05771-04 Oracle Database Reference, 11