BDExamenes

BD

BD - Logical structuring of the database

We go to the mess. Let's start by explaining the relational model that sustains at the conceptual level of the database, yes, I am talking about the entity-reference diagram:

The document entity represents all saved exams:

• ID_DOC: Each file is univocally identified by its hash Sha1.
• NOM_DOC: The corresponding name of the stored exam.
• Route_doc: The corresponding route to the exam in the Jungle of Directors .

The TAG entity represents a label that classifies an element of the Document Entity:

• NOM_TAG: It is the unique name or identification of each label.
• Type_tag: category in which the label is located, 5: year, course, subject, grade and other are considered.
• Preference: Indicates the use of a label, to greater preference, greater use of the label and therefore more importance will be in the classification.

The doctag entity represents in Duplas the association of a document to a tag and vice versa, also adds a new attribute: proven .

At the external level of the database are the views . The first is, in terms of the relational algebra, the natural only of the document table, the doctag table and the TAG table.

BD - Implementation

The database administrator is by SQLite simplicity, in the near future it will be carried to MySQL. The code corresponding to the creation of the database is found in the Createdb.py file within the DBTools folder.

BD - Structure of the Jungle of Directors

Each exam file is stored in the depths of the director of directories according to the following criteria: Degree to which the exam belongs, course of the subject of the exam, subject of the exam and year of the course in which the exam is carried out. In case of not being able to determine the year or be this prior to 2011-2012, the value of the year is UNKN (of Unknown, unknown) or before (previously to the origin of the world to the year 1112).

For example, if we have an exam of the 1st course , year 2013-2014 , subject hechizos and potions of the degree in dark arts and a type test of such asnostatura that we do not know what year is it But they have to Telarañas , his jungle routes would be:

• Dark Arts/1/Héchizos y Pócimimas/1314/exam
• Dark Arts/1/Héchizos y Podos/unkn/type_test

BD - Update

Once new files have been added to the director of directories, it is enough to run the following command in the project root folder: make db . This command will automatically search and delete the duplicated files of the director of directories , in addition to classifying the new files in the database.

BD - Web interface

The logic of the server, that is, a code aimed at running on the server during the interaction of a user with the web interface is implemented in PHP and is located in the PHP directory. The logic of the interface is distributed in two directories: CSS and JS and the HTML files. To program in CSS it has been used {Less} , so it is necessary to compile the CSS/Style.less file, on the other hand the JavaScript code is minified using UGLIFYJS . These operations are carried out running make css and make js .

BD - Units

Python:

• Peewee
• Pil
• Pyoc

PHP:

• Managed with Composer , consult the PhP/Composer.json file. The Tesseract for PHP library requires the installation of Tesseract OCR and the Spanish language package.
• Manually administered: Image Magick and Pdo both have to be enabled in the PHP configuration file, PHP.INI, which is usually found in the Board of Directors /etc .

JavaScript:

• Jquery UI
• Dropzonejs
• UGLIFYJS

CSS:

• {Less}