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
The Public Knowledge Project Support Forum is moving to http://forum.pkp.sfu.ca

This forum will be maintained permanently as an archived historical resource, but all new questions should be added to the new forum. Questions will no longer be monitored on this old forum after March 30, 2015.

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 3072 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: 10015
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 3060 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: 10015
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 2999 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: 10015
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 2938 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: 10015
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 2858 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: 10015
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 2738 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: 10015
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 2164 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 0 guests