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 |

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
Join Join nt Executive Committee nt Executive Committee th Sept 2017 26 th Strat Strat ta

Join Join nt Executive Committee nt Executive Committee th Sept 2017 26 th Strat Strat ta

Join Join nt Executive Committee nt Executive Committee th Sept 2017 26 th Strat Strat ta Update ta Update 26 Sept 2017 Strata IT Director Upda ate GDIP Global Programme Comms Key Focus Cyber Managing Security Workload But

577 views • 35 slides
1 The programme to kick-start your career WHY SHOULD I JOIN THIS PROGRAMME? JOIN HEYJOBS AS A

1 The programme to kick-start your career WHY SHOULD I JOIN THIS PROGRAMME? JOIN HEYJOBS AS A

1 The programme to kick-start your career WHY SHOULD I JOIN THIS PROGRAMME? JOIN HEYJOBS AS A BUSINESS DEVELOPMENT MANAGER The HeyJobs Master in Business Development STEEPEST LEARNING CURVE (MBD) is a Master modern solution sales by using the

498 views • 10 slides
Evaluation of Join Operations Ramakrishnan/Gehrke Chapter 14, Part A (Joins) 340151 Big Data

Evaluation of Join Operations Ramakrishnan/Gehrke Chapter 14, Part A (Joins) 340151 Big Data

Evaluation of Join Operations Ramakrishnan/Gehrke Chapter 14, Part A (Joins) 340151 Big Data & Cloud Computing (P. Baumann) 1 Relational Operations: Join Definition Natural join: R S := L ( C ( R S ) ) Where C:

361 views • 12 slides
Join the school band in 2021! Learn to play an instrument and join our musical team! Below is a

Join the school band in 2021! Learn to play an instrument and join our musical team! Below is a

Join the school band in 2021! Learn to play an instrument and join our musical team! Below is a list of all the instruments you can play in the school band. For more information please visit our website: www.musicpartnership.com.au Or send us an

566 views • 11 slides
50 th MedCruise General Assembly 14-17 June 2017 Gibraltar Join @ slido.com #50MedCruiseGA Join

50 th MedCruise General Assembly 14-17 June 2017 Gibraltar Join @ slido.com #50MedCruiseGA Join

50 th MedCruise General Assembly 14-17 June 2017 Gibraltar Join @ slido.com #50MedCruiseGA Join @ Slido.com #50MedCruiseGA MedCruise GA app is available in iTunes and Play Store Join @ slido.com #50MedCruiseGA Approval of Minutes Minutes of

1.24k views • 97 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 Housing & Urba ment of Housing & Urban De n Development Begins at 1 velopment Begins at 10:00 am :00 am TO JOIN BY TELEPHONE: TO JOIN BY TELEPHONE: Phone: (5 Phone: (510) 2 ) 210-8882 0-8882 | Access

1.13k views • 71 slides
#join X assembly to Box JellyBox Build: 16_X-Assembly Join In this video, we incorporate X

#join X assembly to Box JellyBox Build: 16_X-Assembly Join In this video, we incorporate X

#join X assembly to Box JellyBox Build: 16_X-Assembly Join In this video, we incorporate X assembly into the JellyBox frame. _________________________________________________________________ You'll Need: X Assembly 6" zip ties Smooth

236 views • 6 slides
4 - #join Y Assembly to the Box JellyBox Build: 15_Y-Assembly Join (link directly to the y

4 - #join Y Assembly to the Box JellyBox Build: 15_Y-Assembly Join (link directly to the y

4 - #join Y Assembly to the Box JellyBox Build: 15_Y-Assembly Join (link directly to the y assembly part t=2:00) (overview at t=0) In this video, we incorporate Y assembly into the JellyBox frame.

195 views • 6 slides

More recommend