Rewrite journal abbrevation repository

[koppor]

Currently, we have several maps in memory. We should use Postgres MV Store for maps!

Main reasons:

• 1 second is used for initialiatzion
• 500 MB of RAM are used for abbreviations

Task

Rewrite the whole org.jabref.logic.journals.JournalAbbreviationRepository class.

Only Postgres-Features should be used. Especially because of Fuzzy matching.

See https://stackoverflow.com/questions/7730027/how-to-create-simple-fuzzy-search-with-postgresql-only for hints.

Only maps of MVStore should be used: MVStore has caching itself, no need to build up own data structures.

[marwanemad07]

/assign-me

[github-actions]

👋 Hey @marwanemad07, thank you for your interest in this issue! 🎉

We're excited to have you on board. Start by exploring our Contributing guidelines, and don't forget to check out our workspace setup guidelines to get started smoothly.

In case you encounter failing tests during development, please check our developer FAQs!

Having any questions or issues? Feel free to ask here on GitHub. Need help setting up your local workspace? Join the conversation on JabRef's Gitter chat. And don't hesitate to open a (draft) pull request early on to show the direction it is heading towards. This way, you will receive valuable feedback.

Happy coding! 🚀

⏳ Please note, you will be automatically unassigned if the issue isn't closed within 45 days (by 12 April 2025). A maintainer can also add the "📌 Pinned"" label to prevent automatic unassignment.

[marwanemad07]

Can you tell me the way u profiled this constructor? I tested my solution using Runtime runtime = Runtime.getRuntime(); for the memory and long startTime = System.nanoTime(); for the time, I got the memory to be around 80MB in the initialization and the time almost the same because I iterate over the FullToAbbreviation map and move the abbreviations to other maps of MVStore.
Also, I think I need to create these maps in org.jabref.cli.JournalListMvGenerator to be generated once and saved in the H2 database, Can you confirm that?

[koppor]

I got the memory to be around 80MB in the initialization a

You seem to have a pretty nice JRE. Maybe you profiled the wrong main class? Are you sure you benchmarked org.jabref.Launcher#main?

Did you also use the YourKit profiler or something else?

[koppor]

Also, I think I need to create these maps in org.jabref.cli.JournalListMvGenerator to be generated once and saved in the H2 database, Can you confirm that?

Yes. In addition to rewrite of org.jabref.logic.journals.JournalAbbreviationRepository.

[marwanemad07]

Did you also use the YourKit profiler or something else?

I tried to use the Intellji profiler, but I faced some errors so I used the old way of measuring time and memory for a class but it doesn't seem accurate based on what you are saying. If you can share a resource or guide on properly profiling the project, I’d really appreciate it.

[koppor]

I tried to use the Intellji profiler, but I faced some errors

This is very vague.,,,

share a resource or guide on properly profiling the project, I’d really appreciate it.

See https://www.jetbrains.com/pages/intellij-idea-profiler/

Applied here:

1. 
2. Wait until JabRef Starts
3. Shut down JabRef
4. Ctrl+N
5. Type JARepo
6. Press Enter
7. See