Infrastructure Improvements in 2020 Yoel Kortick Senior Librarian

Contents • Introduction • Oracle Database In Memory • Upgrade to OAS (Oracle Analytics

Introduction • During 2020 two major changes are taking place on the infrastructure level for Analytics: 1. Upgrading the Analytics Database Architecture to Oracle Database In Memory 2. Upgrading the OBI (Oracle Business Intelligence) which is used by Analytics to OAS (Oracle Analytics Server) and Data Visualization (DV) © 2019 Ex Libris | Confidential & Proprietary 3

Oracle Database In Memory © 2019 Ex Libris | Confidential & Proprietary 4

Oracle Database In Memory • The purpose of the move to Oracle Database In Memory is to improve performance. • The In Memory architecture includes optimizations to make running complex queries much faster than was previously possible. • At the current time (Feb. 2020) "Oracle Database in Memory" has been installed on instances NA 06 and NA 04. • Other instances will receive the "Oracle Database in Memory" throughout 2020. © 2019 Ex Libris | Confidential & Proprietary 5

Oracle Database In Memory • Before the decision was made to use the "Oracle Database in Memory" we partnered with a large live Alma Consortium to test it. This allowed us to first check if this change would be beneficial to the Alma user community. • The tests showed A. A significant improvement in the time reports ran B. The ability to successfully run reports which previously "timed-out" © 2019 Ex Libris | Confidential & Proprietary 6

Oracle Database In Memory • Before installing the "Oracle Database in Memory" on instances NA 06 and NA 04 we did "Before" tests so that we could see if "After" there were significant improvements. • The table on next slide shows some specific numbers from the network zone institutions of three different consortia, comparing the time taken to complete reports, both "Before" and "After". • Surely you will agree that the improvement in time to run the reports is extremely encouraging. © 2019 Ex Libris | Confidential & Proprietary 7

Oracle Database In Memory Report Percent of overdue returns per institution Unavailable Portfolios Items created per institution Seconds to run before 14 242 227 Seconds to run after 10 22 2 Seconds Improve 4 220 225 % Improve 29 91 99 1, 067 61 60 345 160 38 3 8 907 23 57 337 85 38 95 98 Consortia Network Dashboard Tab: Borrowing Requests 58 7 51 88 Consortia Network Dashboard Tab: Overdue Returns 3 1 2 67 Consortia Network Dashboard Tab: Lending Requests 7 2 5 71 Consortia Network Dashboard Tab: Logins to Alma 123 69 54 44 Consortia Network Dashboard Tab: Items Created 328 13 315 96 Unavailable Portfolios 1, 400 44 1, 356 97 Unavailable Portfolios 1, 790 40 1, 750 98 Active Titles by Institution 1, 820 5 1, 815 100 Electronic Portfolios purchased by date LC Range and held by institutions Cataloger Activity items added in Oct listed by call number of missing items © 2019 Ex Libris | Confidential & Proprietary 8

Oracle Database In Memory • The table below shows some specific reports run by network zone institutions where "Before" the report failed and "After" it succeeded. • To state that this is a major improvement is an understatement. Second to run before Second to run after All titles with LC Classification Code HQ in titles subject area includes institution Timed out 53 All titles with subject engineering in titles subject area Timed out 35 High Request Load Timed out 109 All titles with LC Classification Code HQ in titles subject area includes institution Timed out 30 High Request Load Timed out 479 Report © 2019 Ex Libris | Confidential & Proprietary 9 Seconds Improve Not applicable Not applicable % Improve 100 100 100

Oracle Database In Memory • The table below shows some specific numbers from the institutions that are not network zone institutions. • Again, surely you will agree that the improvement in time to run the reports is extremely encouraging. Report Seconds to run before Seconds to run after Seconds Improve % Improve 595 116 25 10 570 106 96 91 Music Assigned to Missing 2, 274 2 2, 272 100 Music Due In 30 Days Report 2, 273 4 2, 269 100 Recent Acquisitions that Need Replacement Cost Bib Records without Holdings 1, 738 2, 417 5 960 1, 733 1, 457 100 60 Title level overlap analysis Dashboard. Tab: Overlap P and E with "word from subject" "engineer" and all other defaults All titles with subject engineering in titles subject area © 2019 Ex Libris | Confidential & Proprietary 10

Upgrade to OAS (Oracle Analytics Server) and Data Visualization (DV) © 2019 Ex Libris

Upgrade to OAS (Oracle Analytics Server) and Data Visualization (DV) • The purpose of the upgrade to OAS (Oracle Analytics Server) and Data Visualization (DV) is provide a more modern and extensive set of tools for evidence based decision making. • Many new features are included, such as (but not only) • The ability to use an input file with Alma and Primo data in analytics • Perform Forecasts • Identify Trends • Many new visualizations © 2019 Ex Libris | Confidential & Proprietary 12

Upgrade to OAS (Oracle Analytics Server) and Data Visualization (DV) • Examples of the OAS (Oracle Analytics Server) and Data Visualization (DV) as used with Alma and Primo Analytics can be seen in these blogs. • The OAS (Oracle Analytics Server) and Data Visualization (DV) is currently (Feb. 2020) being used by 14 institutions as early adopters. • Other institutions will receive the OAS (Oracle Analytics Server) and Data Visualization (DV) throughout 2020. © 2019 Ex Libris | Confidential & Proprietary 13