OJS OCS OMP OHS

You are viewing the PKP Support Forum | PKP Home Wiki



Analysis of the database ojs 2.4.2

OJS development discussion, enhancement requests, third-party patches and plug-ins.

Moderators: jmacgreg, btbell, michael, bdgregg, barbarah, asmecher

Forum rules
Developer Resources:

Documentation: The OJS Technical Reference and the OJS API Reference are both available from the OJS Documentation page.

Git: You can access our public Git Repository here. Comprehensive Git usage instructions are available on the wiki.

Bugzilla: You can access our Bugzilla report tracker here.

Search: You can use our Google Custom Search to search across our main website, the support forum, and Bugzilla.

Questions and discussion are welcome, but if you have a workflow or usability question you should probably post to the OJS Editorial Support and Discussion subforum; if you have a technical support question, try the OJS Technical Support subforum.

Analysis of the database ojs 2.4.2

Postby DAFER » Mon Oct 28, 2013 2:59 pm

I am conducting a study based on data base from OJS 2.4.2 and the first phase of this study found that once the software is installed, the database consists of a total of 114 entities (tables) of which begin with the following records:

1 controlled_vocabs
2 controlled_vocab_entries
3 controlled_vocab_entry_settings
4 email_templates_default
5 email_templates_default_data
6 filters
7 filter_groups
8 filter_settings
9 mutex
10 plugin_settings
11 roles
12 site_settings
13 users
14 versions

It is noteworthy that entities 1, 2, and 3 (controlled_vocabs, controlled_vocab_entries and controlled_vocab_entry_settings) may be being used to implement the Controlled Vocab (provides a way to organize information for later retrieval), But I am not sure that are implemented to achieve this purpose. Thank help me clear my doubts about these three entities.
Attachments
tablas.JPG
tablas.JPG (33.64 KiB) Viewed 2054 times
DAFER
 
Posts: 19
Joined: Mon Oct 28, 2013 2:02 pm

Re: Analysis of the database ojs 2.4.2

Postby asmecher » Mon Oct 28, 2013 3:11 pm

Hi Dafer,

These are a generic container for any kind of Controlled Vocabulary, which is basically a fixed list of possibilities. Currently it's used to store a few things:
  • Reviewer interests
  • Journal categories
Regards,
Alec Smecher
Public Knowledge Project Team
asmecher
 
Posts: 8419
Joined: Wed Aug 10, 2005 12:56 pm

Re: Analysis of the database ojs 2.4.2

Postby DAFER » Mon Oct 28, 2013 3:53 pm

Thank you very much :D
DAFER
 
Posts: 19
Joined: Mon Oct 28, 2013 2:02 pm

Re: Analysis of the database ojs 2.4.2

Postby DAFER » Mon Oct 28, 2013 4:22 pm

At this moment I am analyzing the entities:
6 filters
7 filter_groups
8 filter_settings

Of which I assume contains the filter, the filter group and their settings, but I have no certainty to be used, I appreciate some clarity in this new concern
Attachments
tabla2.JPG
tables
tabla2.JPG (36.56 KiB) Viewed 2042 times
DAFER
 
Posts: 19
Joined: Mon Oct 28, 2013 2:02 pm

Re: Analysis of the database ojs 2.4.2

Postby asmecher » Mon Oct 28, 2013 4:27 pm

Hi Dafer,

These implement the filter framework, described here.

Regards,
Alec Smecher
Public Knowledge Project Team
asmecher
 
Posts: 8419
Joined: Wed Aug 10, 2005 12:56 pm

Re: Analysis of the database ojs 2.4.2

Postby DAFER » Wed Oct 30, 2013 3:08 pm

Thank you very much asmecher. :D

Now I am analyzing the mutex entity, which only has an attribute called " i " which is the primary key. I would like an explanation for that entity(mutex).
Attachments
tabla.JPG
Table
tabla.JPG (9.6 KiB) Viewed 1981 times
DAFER
 
Posts: 19
Joined: Mon Oct 28, 2013 2:02 pm

Re: Analysis of the database ojs 2.4.2

Postby asmecher » Wed Oct 30, 2013 3:25 pm

Hi DAFER,

See http://www.xaprb.com/blog/2005/09/22/mutex-tables-in-sql/.

Regards,
Alec Smecher
Public Knowledge Project Team
asmecher
 
Posts: 8419
Joined: Wed Aug 10, 2005 12:56 pm

Re: Analysis of the database ojs 2.4.2

Postby DAFER » Thu Oct 31, 2013 2:20 pm

thank you very much for your answers :D

Now I'm analyzing plugin_settings entity, I think they are the default OJS plugins to perform certain functions, but not sure, I would like an explanation of that entity (plugin_settings).
Attachments
tabla.JPG
Table
tabla.JPG (17.96 KiB) Viewed 1920 times
DAFER
 
Posts: 19
Joined: Mon Oct 28, 2013 2:02 pm

Re: Analysis of the database ojs 2.4.2

Postby asmecher » Thu Oct 31, 2013 2:41 pm

Hi DAFER,

This holds all the plugin configuration in the system. For most plugins, it describes whether the plugin is enabled or not (setting_name='enabled'); for sidebar blocks, whether the plugin appears on the right or left sidebar (setting_name='context') and how high up on the page it is (setting_name='seq'); other plugins have other settings, depending on what they implement. The journal_id column indicates which journal the setting applies to, with journal_id=0 indicating site-wide (i.e. the page listing all journals).

Regards,
Alec Smecher
Public Knowledge Project Team
asmecher
 
Posts: 8419
Joined: Wed Aug 10, 2005 12:56 pm

Re: Analysis of the database ojs 2.4.2

Postby DAFER » Fri Nov 01, 2013 2:31 pm

I appreciate your answers :D

I'm analyzing the entities site_settings and site but I have not quite clear how it works the following (marked with black section):
Attachments
tabla.JPG
Doubts black section
tabla.JPG (43.04 KiB) Viewed 1840 times
DAFER
 
Posts: 19
Joined: Mon Oct 28, 2013 2:02 pm

Re: Analysis of the database ojs 2.4.2

Postby asmecher » Mon Nov 04, 2013 1:05 pm

Hi DAFER,

On the site homepage, it's possible to configure OJS to present a list of journals including thumbnails, titles, and descriptions. These store the administrator's preferences for each.

Regards,
Alec Smecher
Public Knowledge Project Team
asmecher
 
Posts: 8419
Joined: Wed Aug 10, 2005 12:56 pm

Re: Analysis of the database ojs 2.4.2

Postby DAFER » Tue Nov 05, 2013 2:05 pm

I appreciate your answers Smecher

I am currently analyzing the entity versions, I noticed that it contains the information of the installed plugins for metadata, blocks and citation formats. I would like you to talk a little more about this entity.
Attachments
table.JPG
entity versions
table.JPG (21.93 KiB) Viewed 1720 times
DAFER
 
Posts: 19
Joined: Mon Oct 28, 2013 2:02 pm

Re: Analysis of the database ojs 2.4.2

Postby asmecher » Tue Nov 05, 2013 6:24 pm

Hi DAFER,

Rather than add descriptions here in the forum, I've added some commentary to the XML descriptor for that table in our github repository. See https://github.com/pkp/pkp-lib/commit/d0830716b7df3786d5e18b664ce971ad376d3826.

Regards,
Alec Smecher
Public Knowledge Project Team
asmecher
 
Posts: 8419
Joined: Wed Aug 10, 2005 12:56 pm

Re: Analysis of the database ojs 2.4.2

Postby DAFER » Wed Nov 06, 2013 2:49 pm

I appreciate your help :D
DAFER
 
Posts: 19
Joined: Mon Oct 28, 2013 2:02 pm

Re: Analysis of the database ojs 2.4.2

Postby DAFER » Wed Nov 27, 2013 2:23 pm

Continuing with the analysis of the database, i have doubts about the attributes seq and enabled corresponding to the entity journals , I thank you your answer in advance.
Attachments
Captura.JPG
table journals
Captura.JPG (14.19 KiB) Viewed 1146 times
DAFER
 
Posts: 19
Joined: Mon Oct 28, 2013 2:02 pm

Next

Return to OJS Development

Who is online

Users browsing this forum: No registered users and 1 guest