join 2
play

JOIN 2 . Alexander Wagner, for JOIN 2 Overview > Fraunhofer - PowerPoint PPT Presentation

Jun 07, 2023 •770 likes •1.23k views

Invenio for Fraunhofer Fraunhofer IRB Stuttgart, 18.09.2017 JOIN 2 . Alexander Wagner, for JOIN 2 Overview > Fraunhofer requirements > What happened in 2016? Fraunhofer IRB | Stuttgart, 18.09.2017 | Page 2 > Who is JOIN 2 ? Alexander

  1. Invenio for Fraunhofer Fraunhofer IRB Stuttgart, 18.09.2017 JOIN 2 . Alexander Wagner, for JOIN 2

  2. Overview > Fraunhofer requirements > What happened in 2016? Fraunhofer IRB | Stuttgart, 18.09.2017 | Page 2 > Who is JOIN 2 ? Alexander Wagner, for JOIN 2 |

  3. Overview > Fraunhofer requirements > What happened in 2016? Fraunhofer IRB | Stuttgart, 18.09.2017 | Page 2 > Who is JOIN 2 ? Alexander Wagner, for JOIN 2 |

  4. Overview > Fraunhofer requirements > What happened in 2016? Fraunhofer IRB | Stuttgart, 18.09.2017 | Page 2 > Who is JOIN 2 ? Alexander Wagner, for JOIN 2 |

  5. Part I: Who is JOIN 2 .

  6. Partner JOIN Stuttgart, 18.09.2017 | Fraunhofer IRB | authority records OpenAccess, records, ca. User + ca. Online an 7 Installationsn for Museum Zitadelle Jülich Deutsches Elektronen-Synchrotron RWTH Aachen Maier-Leibniz-Zentrum, Garching GSI Helmholtzzentrum für Schwerionenforschung Forschungszentrum Jülich internal production Deutsches Krebsforschungszentrum Page 4 ≈ 2000 + 3000 > ≈ 5000 + 1000 ≈ 1050 ≈ 300 + 1000 ≈ 9000 Alexander Wagner, for JOIN 2 |

  7. Partner Deutsches Elektronen-Synchrotron Stuttgart, 18.09.2017 | Fraunhofer IRB | authority records OpenAccess, records, ca. User + ca. Online an 7 Installationsn for Museum Zitadelle Jülich RWTH Aachen Maier-Leibniz-Zentrum, Garching GSI Helmholtzzentrum für Schwerionenforschung Forschungszentrum Jülich internal production Deutsches Krebsforschungszentrum Page 4 ≈ 2000 + 3000 > ≈ 5000 + 1000 ≈ 1050 JOIN 2 ≈ 300 + 1000 ≈ 9000 Alexander Wagner, for JOIN 2 |

  8. Partner Maier-Leibniz-Zentrum, Garching Stuttgart, 18.09.2017 | Fraunhofer IRB | Online an 7 Installationsn for Museum Zitadelle Jülich Deutsches Elektronen-Synchrotron RWTH Aachen GSI Helmholtzzentrum für Schwerionenforschung Forschungszentrum Jülich internal production Deutsches Krebsforschungszentrum Page 4 ≈ 2000 + 3000 > ≈ 5000 + 1000 ≈ 1050 JOIN 2 ≈ 300 + 1000 ≈ 9000 ca. 20 . 000 + 5000 User ca. 355 . 000 records, 43 . 800 OpenAccess, ≈ 117 . 000 authority records Alexander Wagner, for JOIN 2 |

  9. Installations Alexander Wagner, for JOIN | Fraunhofer IRB | Stuttgart, 18.09.2017 | Page 5

  10. Installations Fraunhofer IRB | Stuttgart, 18.09.2017 | Page 5 Alexander Wagner, for JOIN 2 |

  11. OpenAccess Repository Ranking 2015 > 181 repositories from D/AT/CH > 160 German repositories > 6. JuSER (76/100 points) > 17. pubdb (72/100 points) Many issues are non-technical, but organizational (policies etc.) http://repositoryranking.org/ Fraunhofer IRB | Stuttgart, 18.09.2017 | Page 6 Alexander Wagner, for JOIN 2 |

  12. OpenAccess Repository Ranking 2015 > 181 repositories from D/AT/CH > 160 German repositories > 6. JuSER (76/100 points) > 17. pubdb (72/100 points) Many issues are non-technical, but organizational (policies etc.) http://repositoryranking.org/ Fraunhofer IRB | Stuttgart, 18.09.2017 | Page 6 Alexander Wagner, for JOIN 2 |

  13. Systems background > 2.x is not recommended for use Stuttgart, 18.09.2017 | Fraunhofer IRB | Complexity(Zenodo)) Complexity(CDS) > 3.0 is not ready for use (Complexity( JOIN ) > 1.2 caused major performance issues > 1.1.7 all JOIN -instances Invenio versions: > Running on Debian, FreeBSD, Redhat, Scientifjc Linux > MySQL or MariaDB > Python 2.6 (while compatible with 2.4) Current Status: Page 7 As a community JOIN 2 is slower then CERN. Alexander Wagner, for JOIN 2 |

  14. Systems background > 2.x is not recommended for use Stuttgart, 18.09.2017 | Fraunhofer IRB | Complexity(Zenodo)) Complexity(CDS) > 3.0 is not ready for use (Complexity( JOIN ) > 1.2 caused major performance issues > 1.1.7 all JOIN -instances Invenio versions: > Running on Debian, FreeBSD, Redhat, Scientifjc Linux > MySQL or MariaDB > Python 2.6 (while compatible with 2.4) Current Status: Page 7 As a community JOIN 2 is slower then CERN. Alexander Wagner, for JOIN 2 |

  15. Systems background > 2.x is not recommended for use Stuttgart, 18.09.2017 | Fraunhofer IRB | Complexity(Zenodo)) Complexity(CDS) > 3.0 is not ready for use (Complexity( JOIN ) > 1.2 caused major performance issues Invenio versions: > Running on Debian, FreeBSD, Redhat, Scientifjc Linux > MySQL or MariaDB > Python 2.6 (while compatible with 2.4) Current Status: Page 7 As a community JOIN 2 is slower then CERN. > 1.1.7 all JOIN 2 -instances Alexander Wagner, for JOIN 2 |

  16. Systems background Current Status: > Python 2.6 (while compatible with 2.4) > MySQL or MariaDB > Running on Debian, FreeBSD, Redhat, Scientifjc Linux Invenio versions: > 1.2 caused major performance issues > 2.x is not recommended for use Fraunhofer IRB | Stuttgart, 18.09.2017 | Page 7 As a community JOIN 2 is slower then CERN. > 1.1.7 all JOIN 2 -instances > 3.0 is not ready for use (Complexity( JOIN 2 ) ≈ Complexity(CDS) ≫ Complexity(Zenodo)) Alexander Wagner, for JOIN 2 |

  17. Part II: Fraunhofer Requirements JOIN 2 .

  18. > Operating system (Ubuntu or Debian, both fjne) > Database (MySQL/MariaDB) > Checksums for documents (md5, Invenio is largely OAIS compliant) > Programming languages (Python, JavaScript, Perl) > Authentication (LDAP, Shibboleth, local) > Extensibility (python, but cooperative !) Fraunhofer IRB | Stuttgart, 18.09.2017 | Page 9 Technical requirements — met by JOIN 2 > JOIN 2 release cycle: monthly (automatised roll out) Alexander Wagner, for JOIN 2 |

  19. > Community: 7 productive instances, 3 in preparation (Prod: DESY, DKFZ, FZJ, GSI, MLZ, MZJ, RWTH, Prep: DZNE(?), JINR, UWH(?)) > Software docs (mainly pydoc: RTFS) > Languages: DE, EN, but not in all areas (i. e. submission forms are english) > PI Minting (DOI via DataCite, Handle, not (yet): URN) Fraunhofer IRB | Stuttgart, 18.09.2017 | Page 10 Technical requirements — partly met by JOIN 2 > Templating (own system, JOIN 2 implements the templates) Alexander Wagner, for JOIN 2 |

  20. > Bibliographic records via web (every user, simplifjed by importers) > Single item importer: DOI (CrossRef and DataCite) Inspire, WoS, PubMed ISBN (GBV, LoC) Data reuse ( j oin, part, recid, link) > Append full texts (No restriction on fjle formats) > Grant assignment (= Funding-IDs) > Collection structure (however, difgerent concept!) Fraunhofer IRB | Stuttgart, 18.09.2017 | Page 11 Submission — met by JOIN 2 Alexander Wagner, for JOIN 2 |

  21. No Batch upload > Poor data (missing normalizations, e. g. journals) > Missing data (Funding, especially local schemes, experiments etc.) > Need for manual cataloguing ( b ibedit requires STAFF rights, cumbersome for normalized entries) > De-duping necessary > Only one proof reader web submission is much more effjcient Fraunhofer IRB | Stuttgart, 18.09.2017 | Page 12 Submission — not met JOIN 2 Alexander Wagner, for JOIN 2 |

  22. No Batch upload > Poor data (missing normalizations, e. g. journals) > Missing data (Funding, especially local schemes, experiments etc.) > Need for manual cataloguing ( b ibedit requires STAFF rights, cumbersome for normalized entries) > De-duping necessary > Only one proof reader web submission is much more effjcient Fraunhofer IRB | Stuttgart, 18.09.2017 | Page 12 Submission — not met JOIN 2 Alexander Wagner, for JOIN 2 |

  23. No Batch upload > Poor data (missing normalizations, e. g. journals) > Missing data (Funding, especially local schemes, experiments etc.) > Need for manual cataloguing ( b ibedit requires STAFF rights, cumbersome for normalized entries) > De-duping necessary > Only one proof reader web submission is much more effjcient Fraunhofer IRB | Stuttgart, 18.09.2017 | Page 12 Submission — not met JOIN 2 Alexander Wagner, for JOIN 2 |

  24. > Grants Local funding schemes possible > Record linking (e. g.. Book and chapter, proceedings and article, article and data) > DDC from journal (automatic, STAFF could change) > Author identifjcation (ORCiD ready) Fraunhofer IRB | Stuttgart, 18.09.2017 | Page 13 Content — met by JOIN 2 EU funding: automatically available (OAI harvesting via JOIN 2 ) Grants are shared in JOIN 2 > Journal normalization (shared authority base of ≈ 75 . 000 journals, automatic update) Alexander Wagner, for JOIN 2 |

  25. > Keyword suggestions (free and normalized) > Series normalization (however, possible) Fraunhofer IRB | Stuttgart, 18.09.2017 | Page 14 Content — not met by JOIN 2 Alexander Wagner, for JOIN 2 |

  26. > Bibliographic formats (BibTeX, EndNote (XML, Text), RIS) > DC Simple (BASE/OpenAIRE compliant DC v3 for repositories) > DataCite v3 (exposes ORCiD, thus can feed ORCiD) > ORCiD (requires membership, currently only Jülich) > schema.org (GSBLST, HD, HB) > Google Scholar (However, no way to submit to GoogleScholar any more) Visibility … …is pretty good, especially in search engines. JOIN -instances feed the institutes websites directly. Fraunhofer IRB | Stuttgart, 18.09.2017 | Page 15 Output — met by JOIN 2 Alexander Wagner, for JOIN 2 |

Download Presentation
Download Policy: The content available on the website is offered to you 'AS IS' for your personal information and use only. It cannot be commercialized, licensed, or distributed on other websites without prior consent from the author. To download a presentation, simply click this link. If you encounter any difficulties during the download process, it's possible that the publisher has removed the file from their server.

Recommend

When to Optimize Enumerating all possible plans Selection Pushdown Join Conversion Join

When to Optimize Enumerating all possible plans Selection Pushdown Join Conversion Join

When to Optimize Enumerating all possible plans Selection Pushdown Join Conversion Join Reordering Pick a Join Algo Which Plan is the Best? Always push down selections Always convert joins Which join order??? Which join algo? What makes a

363 views • 3 slides
JOINS IN SQL By Rohit Dhanwani OBJECTIVES Define and use different types of joins INNER

JOINS IN SQL By Rohit Dhanwani OBJECTIVES Define and use different types of joins INNER

JOINS IN SQL By Rohit Dhanwani OBJECTIVES Define and use different types of joins INNER JOIN EQUI JOIN NATURAL JOIN OUTER JOIN LEFT OUTER JOIN RIGHT OUTER JOIN FULL OUTER JOIN 2 PROCESSING MULTIPLE TABLES - JOIN

416 views • 18 slides
CS411 Database Systems Join Expressions 06: SQL Kazuhiro Minami Join Expressions Products and

CS411 Database Systems Join Expressions 06: SQL Kazuhiro Minami Join Expressions Products and

CS411 Database Systems Join Expressions 06: SQL Kazuhiro Minami Join Expressions Products and Natural Joins Natural join is obtained by: SQL provides a number of expression forms that act like varieties of join in relational R

212 views • 6 slides
Executive Director dcastle@join.org / 775-461-3930 What is JOIN Inc. A non-profit 501 ( c )

Executive Director dcastle@join.org / 775-461-3930 What is JOIN Inc. A non-profit 501 ( c )

Breaking the cycle of poverty and promoting prosperity for all Nevadans Denise L. Castle Executive Director dcastle@join.org / 775-461-3930 What is JOIN Inc. A non-profit 501 ( c ) (3) Workforce Development Solution for Northern Nevada

390 views • 12 slides
enabled by Circular Economy Service Platform join CEP Be part of the future transformation join

enabled by Circular Economy Service Platform join CEP Be part of the future transformation join

New business from industrial waste & side streams - enabled by Circular Economy Service Platform join CEP Be part of the future transformation join CEP Collaborate with your partners join CEP Create a new value cluster Modular and

223 views • 18 slides
How does Hash Join work in PostgreSQL and its derivates Yandong Yao Pivotal Greenplum team

How does Hash Join work in PostgreSQL and its derivates Yandong Yao Pivotal Greenplum team

How does Hash Join work in PostgreSQL and its derivates Yandong Yao Pivotal Greenplum team yyao@pivotal.io Hash join in PostgreSQL What is JOIN An SQL join clause - corresponding to a join operation in relational algebra - combines columns

444 views • 42 slides
Please Join Us 2009 Consumer Attitudes Toward If you have not called in to join the audio

Please Join Us 2009 Consumer Attitudes Toward If you have not called in to join the audio

Please Join Us 2009 Consumer Attitudes Toward If you have not called in to join the audio portion of the Web cast, please join us now. Functional Foods/Foods For Health Toll-free Dial-In : (866) 261-2650 IFIC Functional Foods/Foods for

801 views • 68 slides
JOIN THE CLUB! Join Melbournes best CBD gym right in the heart of Collins Street and located

JOIN THE CLUB! Join Melbournes best CBD gym right in the heart of Collins Street and located

HOME | FACILITIES | 2XU OUTLET | MEMBERSHIP | SPA | CONTACT JOIN THE CLUB! Join Melbournes best CBD gym right in the heart of Collins Street and located in the 5-star premises of Grand Hyatt. Be fit, stay fit, live fit with state-of-the-art

305 views • 11 slides
Premier Barter Exchange Why Join? Here are a few reasons to Join New Customers

Premier Barter Exchange Why Join? Here are a few reasons to Join New Customers

Premier Barter Exchange Why Join? Here are a few reasons to Join New Customers guaranteed! Interest-Free Credit Line $2,500b No account receivables or bad debt. Co-Op Advertising 50% rebate on all PBE advertising.

202 views • 8 slides
What are the stakes? Join today! https://www.ucu.org.uk/join www.facebook.com/cambridgeucu

What are the stakes? Join today! https://www.ucu.org.uk/join www.facebook.com/cambridgeucu

2018 Pay and Equality Ballot: What are the stakes? Join today! https://www.ucu.org.uk/join www.facebook.com/cambridgeucu www.ucu.cam.ac.uk Twitter @CambridgeUCU What does UCU do? The trade union in HE and FE for: National bargaining

666 views • 14 slides
I/O-EFFICIENT SIMILARITY JOIN R. Pagh, N. Pham, F. Silvestri, M. Stckel Similarity Join R = Q

I/O-EFFICIENT SIMILARITY JOIN R. Pagh, N. Pham, F. Silvestri, M. Stckel Similarity Join R = Q

I/O-EFFICIENT SIMILARITY JOIN R. Pagh, N. Pham, F. Silvestri, M. Stckel Similarity Join R = Q . / r S = { ( q, x ) Q S | d ( q, x ) r } Similarity join example 1 (Record linkage) Country Name Token ID USA IBM Mircosoft 1 USA

398 views • 27 slides
CS 327E Class 3 September 23, 2019 1) Which SQL join type does this query contain? S(a: int, b:

CS 327E Class 3 September 23, 2019 1) Which SQL join type does this query contain? S(a: int, b:

CS 327E Class 3 September 23, 2019 1) Which SQL join type does this query contain? S(a: int, b: string); A. Inner Join T(c: string, d: date); B. Natural Join C. Cross Join SELECT * D. None of the above FROM T, S; 2) The following query,

581 views • 28 slides
Welcome While we wait for others to join us, please use this time to rename yourself with an E-,

Welcome While we wait for others to join us, please use this time to rename yourself with an E-,

Welcome While we wait for others to join us, please use this time to rename yourself with an E-, M-, or H- to indicate the grade level(s) you or your foundation supports. If multiple levels, please indicate the group youd like to join for

358 views • 24 slides
TO JOIN BY TELEPHONE: TO JOIN BY TELEPHONE: Phone: (5 Phone: (510) 2 ) 210-8882 0-8882 | Access

TO JOIN BY TELEPHONE: TO JOIN BY TELEPHONE: Phone: (5 Phone: (510) 2 ) 210-8882 0-8882 | Access

U.S. S. Depar Department of Jus ment of Justice Community ice Community Relation lations Ser s Service Begins at 1 vice Begins at 11:00 :00 am am TO JOIN BY TELEPHONE: TO JOIN BY TELEPHONE: Phone: (5 Phone: (510) 2 ) 210-8882 0-8882 |

369 views • 21 slides
Join restriction categories and the importance of being adhesive J.R.B. Cockett and X. Guo

Join restriction categories and the importance of being adhesive J.R.B. Cockett and X. Guo

Join restriction categories and the importance of being adhesive J.R.B. Cockett and X. Guo Department of Computer Science University of Calgary Alberta, Canada robin@cpsc.ucalgary.ca Category Theory 2007 Contents: Join restriction

425 views • 25 slides
1 the top right-hand side of the page. 2 Meeting Agenda Welcome Review of National

1 the top right-hand side of the page. 2 Meeting Agenda Welcome Review of National

Welcome to the Virtual Public Meeting for the August 4th, 2020 TO CONNECT YOUR AUDIO: Click Join with Computer Audio or Join Audio by Computer on the screen that pops up when you enter the meeting. Or, click the Join Audio

501 views • 26 slides
ALHAD .G. APTE HEAD, COMPUTER DIVISION, BHABHA ATOMIC RESEARCH CENTER MUMBAI - INDIA

ALHAD .G. APTE HEAD, COMPUTER DIVISION, BHABHA ATOMIC RESEARCH CENTER MUMBAI - INDIA

ALHAD .G. APTE

544 views • 36 slides
https://www.ocre-project.eu Supplier briefing For cloud and Earth Observation service providers

https://www.ocre-project.eu Supplier briefing For cloud and Earth Observation service providers

https://www.ocre-project.eu Supplier briefing For cloud and Earth Observation service providers to be informed about the OCRE project; its aims, approach and timeline; prepare and get involved. Give input to OCRE. We are at the starting

358 views • 24 slides
L3 Muon Reconstruction in CMS: a Status Report J.-R. Vlimant, on behalf of the HLT team 3/5/08

L3 Muon Reconstruction in CMS: a Status Report J.-R. Vlimant, on behalf of the HLT team 3/5/08

L3 Muon Reconstruction in CMS: a Status Report J.-R. Vlimant, on behalf of the HLT team 3/5/08 TSG, L3Muon, A Status Report J-R Vlimant 1 Outline Overview of the muon HLT: focusing on L3 muon reconstruction Regional seeding in the

445 views • 25 slides
The nuclear EMC effect in the deep-inelastic and the resonance region Sergey Kulagin Institute

The nuclear EMC effect in the deep-inelastic and the resonance region Sergey Kulagin Institute

The nuclear EMC effect in the deep-inelastic and the resonance region Sergey Kulagin Institute for Nuclear Research of the Russian Academy of Sciences, Moscow Talk at the XVth International Seminar on Electromagnetic Interactions of Nuclei

392 views • 37 slides
CERN and Science Clouds in Europe with TOSCA, OpenStack Heat and the Heat Translator Matt

CERN and Science Clouds in Europe with TOSCA, OpenStack Heat and the Heat Translator Matt

CERN and Science Clouds in Europe with TOSCA, OpenStack Heat and the Heat Translator Matt Rutkowski Mathieu Velten Sahdev Zala Ricardo Rocha Brad Topol mrutkows@us.ibm.com mathieu.velten@cern.ch spzala@us.ibm.com Ricardo.Rocha@cern.ch

570 views • 25 slides
Heterogeneous events selection at the CMS Experiment Felice Pantaleo CERN Experimental Physics

Heterogeneous events selection at the CMS Experiment Felice Pantaleo CERN Experimental Physics

PATATRACK Heterogeneous events selection at the CMS Experiment Felice Pantaleo CERN Experimental Physics department felice@cern.ch 10/26/2017 Document reference 2 3 4 5 6 8 9 CMS and LHC Upgrade Schedule 10 11 Is there a place for

571 views • 42 slides
General Safety Statements You are a CERT volunteer, perform those duties you feel confident

General Safety Statements You are a CERT volunteer, perform those duties you feel confident

General Safety Statements You are a CERT volunteer, perform those duties you feel confident and comfortable performing You are not expected to put yourself or others in danger at any time, notify first responders of dangerous situations

407 views • 20 slides
ICPD The CERT/Citizen Corps Registration System..And You! Individual and Community

ICPD The CERT/Citizen Corps Registration System..And You! Individual and Community

ICPD The CERT/Citizen Corps Registration System..And You! Individual and Community Preparedness Division Logging In CLICK ME! or Go to http://www.citizencorps.fema.gov/cc/secure/index.do 2 Cant Log In? Dont have an account, or

218 views • 19 slides

More recommend