Ontologies in education – state of the art Stancin, Kristian; Poscic, Patrizia; Jaksic, Danijela
Education and information technologies,
11/2020, Letnik:
25, Številka:
6
Journal Article
Recenzirano
Ontologies are used with great success in education because they allow to formulate the representation of a learning domain by specifying all concepts involved, relations between concepts and all ...properties and conditions that exist. The goal of this paper is to present the field of ontologies and give an overview of recent research in the field, in the context of education. As this paper presents a literature review, papers from the last five years were collected from the IEEE Xplore database, analysed and categorized based on the use of ontologies for: curriculum modelling and management, describing learning domains, learning data, and e-learning services. From the collected papers, a slightly growing trend in the contribution of ontologies to educational systems can be observed. Most studies used ontologies for describing learning domains, and some of the 95 collected papers could not fit in just one category because a system used more than one ontology. Throughout the work, the following contributions have been made: the term ontology was defined, the most common types of ontologies and commonly used methodologies for building ontologies were identified, and an overview of existing systems that use ontologies in the domain of education was given.
Napad ubacivanjem SQL izraza jedna je od najozbiljnijih prijetnji sigurnosti aplikacija zasnovanih nad bazom podataka. Ona omogućuje napadaču da stekne kontrolu nad bazom podataka aplikacije, čime ...napadač dobiva mogućnost izmjene podataka. Mnoga se istraživanja usmjeravaju na ovaj problem. Brojni su autori predložili različite pristupe za otkrivanje i sprječavanje ove ranjivosti, no koliko je ovaj problem i dan danas prisutan govori i činjenica da ni ti pristupi ne predstavljaju
u potpunosti uspješno rješenje. U ovom radu opisano je nekoliko vrsta napada ubacivanjem SQL izraza te različiti alati i metode koji mogu pružiti određenu prevenciju i obranu od tih napada. Predložene su različite metode za rješavanje problema napada ubacivanjem SQL izraza u obliku opsežnih pregleda varijacija napada ubacivanjem SQL izraza te njihovih opisa i primjera, kako bi se bolje spoznao njihov štetan utjecaj i krajnje posljedice. Štoviše, u radu je dan i kratak pregled prijedloga pojedinih autora vezanih uz prevenciju i obranu od napada ubacivanjem SQL izraza. Na kraju je iznesen zaključak uz objektivan pregled i analizu cjelokupnog istraživanja. Glavni doprinos rada je pregled dosadašnjih istraživanja i pristupa vezanih uz: a) prevenciju napada ubacivanjem SQL izraza i b) obranu od napada ubacivanjem SQL izraza.
SQL injection is one of the most serious security threats to applications that have their own database. In fact, it allows the attacker to gain control of the application database by giving attacker the ability to modify the data. Many researchers have been trying to solve this problem. They have suggested different approaches to detect and prevent this vulnerability, but even these approaches do not fully represent a successful solution. This paper introduces several types of SQL injection attacks, as well as various tools and methods that can provide some prevention and defense against these attacks.
Various methods have been proposed to address the problem of SQL injection attacks in the form of extensive reviews of variations of SQL injection attacks. Also, descriptions and examples were offered in order
to understand their adverse impact and the consequences better.This paper also provides a brief overview of what some authors suggest when it comes to preventing and defending from SQL injection. Finally, a conclusion is drawn with an objective review and analysis of the overall
research. The main contribution of the paper is an overview of the research available so far, limited to relational databases and categorized on: a) prevention of SQL injection and b) defence from SQL injection.
Data Warehouse and Data Quality - An Overview Brajković, Helena; Jakšić, Danijela; Poščić, Patrizia
Central European Conference on Information and Intelligent Systems,
01/2020
Conference Proceeding
Odprti dostop
Almost every company today is collecting and storing data for later analysis and business decision making in some kind of repository, usually a data warehouse. In order for decision to be timely and ...accurate (content-wise), it should be based on high quality data. Data quality policies and standards can be applied to every data warehouse. However, every data warehouse is unique and there is a need to consider a lot of criteria to achieve the best outcome. The goal of this paper is mostly to give an overview of data quality issues in a data warehouse, explain different criteria and categories for data quality and show some causes and consequences of saving low quality data in the data warehouse. The main contribution of this paper is, consequently, an overview of data quality issues in the context of data warehouses and an insight into some new and emerging research areas in the field of data warehouse quality.
Queryng data in NoSQL databases Babić, Andrea; Jakšić, Danijela; Poščić, Patrizia
Zbornik Veleučilišta u Rijeci,
2019, Letnik:
7, Številka:
1
Journal Article
Recenzirano
Odprti dostop
The goal of this paper is to give an overview of fundamental concepts and types of NoSQL databases, to show some examples of database queries,
some related research, and the implementation of those ...queries in an original practical example. The introduction is a brief representation and description of the NoSQL database. There are also several comparisons of NoSQL database with the relational database. The next chapter contains a review of the basic NoSQL databases and their prototypes. In each of the following subchapters, the types of NoSQL databases are described in more detail and various queries which can be performed over them are presented. In the last chapter there is also a practical example of querying one of these databases.
Zadatak rada bio je istražiti NoSQL baze podataka, fokusirati se na izvođenje upita nad njima, opisati neke od dosadašnjih istraživanja te prikazati izvršavanje tih upita na vlastitom praktičnom primjeru. U uvodu su ukratko predstavljene i opisane NoSQL baze podataka. Prikazano je i nekoliko usporedbi s relacijskom bazom podataka. U idućem poglavlju možemo vidjeti pregled osnovnih NoSQL baza podataka te njihove prototipe. U svakom od sljedećih potpoglavlja detaljnije su opisane vrste NoSQL baza podataka i prikazani razni upiti koji se mogu izvoditi nad njima, a u posljednje poglavlje uključen je i vlastiti praktični primjer izvođenja upita nad jednom od tih baza.
Rad prikazuje usporedbu i analizu triju alata za modeliranje baza podataka – MySQL Workbench (MW), Open ModelSphere i Dia. Uvriježena mišljenja su da je MW spor, da Open ModelSphere nije dizajnerski ...lijep, a
dodavanje atributa zahtjevno, te da je Dia najbolji i najjednostavniji alat od ponuđenih. Alate ćemo usporediti i testirati na istom primjeru kako bismo iz prve ruke vidjeli jesu li uvriježena mišljenja točna te slažemo li se s njima. Nakon analize različitih mišljenja i međusobne usporedbe alata, glavni doprinos ovog rada je sama usporedba i analiza te zaključak da sva tri alata imaju svoje prednosti i mane, a na korisniku je da izabere koji će alat odabrati za daljnje korištenje.
This paper provides a comparison and analysis of three database modeling
tools – MySQL Workbench (MW), Open ModelSphere and Dia. The general opinion is that MW is slow, Open ModelSphere does not have a nice graphic design interface and it is complicated to add an attribute, and Dia, on the other hand, is the best and the
simplest modeling tool there is. We will compare and test these three modelling tools on the same example to see at first hand if the general opinion is correct and conclude to what extent we agree with them. After
analysing different opinions and mutual tool comparison, the main contribution of this paper is tool differentiation and analysis, along with the conclusion that all three modeling tools have their advantages and disadvantages, and the user is the one who gets to choose the modeling tool for further use.
This scientific article describes design planning and development of the business database application “Laundry“ for an association named “Terra“ in the city of Rijeka. The idea for a business
...application came during a conversation with the “Oaza“ association employee in Rijeka. Application design planning was preceded by interviewing people which was indispensable in order to make a list of user requirements.These user requirements were needed for developing a relational database in Clarion, Entity – relationship model and for relation model. This article contains pictures as examples of the most important parts of the application made in Clarion program with a matching description. The work resulted in a complete application for the business system association “Terra’s Laundry“ in Rijeka. When the application was done, the meeting was arranged so that the application could be presented to “Terra’s Laundry’s“ employees. At the presentation of the application the employees were expected to comment and say what should be changed, added or removed from the application. In line with what was said at the meeting, the application was modified and finally it was ready to be installaled on the “Terra’s Laundry“ main computer. It was also necessary to install a program for automatic backup in order to make its security copy on daily basis.
The paper describes a research on collecting user requirements from international users in order to develop a document repository based on metadata, for collecting, storing, searching and analysing ...relevant cultural and socioeconomic documents. This research is a part of wider research within the project called MESOC that aims to propose, test and validate an innovative and original approach to measure the societal value and impact of culture, cultural policies and cultural practices. The main contributions of this paper are: a) a set of user requirements in the cultural domain collected from international users, b) a data model and database for the document repository, and c) a metadata model used to satisfy the user requirements.
After conducting a systematic literature review in the field of embedded systems development, a multilayer conceptual network is created to represent the relationship between the classification ...criteria for embedded systems development methodologies. For this purpose, an object-oriented data model is defined in Python and mapped to a relational SQLite and a non-relational MongoDB data model. After generation, the two models are populated using the Naive Bayes algorithm in the validation process. Generated relational and non-relational models support the relationship between the classification criteria for embedded systems development methodologies. As a result, this directed network is graphically represented by a multi-layer conceptual network, and generated queries, on relational and non-relational models, provide the possibility of a deeper understanding of defined classification criteria interdependence.
This paper presents a detailed overview of business intelligence and analysis tools that enable data-based decision-making. There are many self-service tools on the market today, and the paper ...compares three that were named leaders in Gartner's 2022 report: Power BI, Tableau, and Qlik. The research aims to compare these tools based on defined criteria and show their advantages and disadvantages, with a special focus on the use for educational purposes.