Title Hijerarhijski i relacijski modeli kao bibliografkse baze podataka
Title (english) Hierarchical and relational models as bibliographical databases
Author Marijan Martinović
Mentor Krešimir Zauder (mentor)
Committee member Josip Ćirić (predsjednik povjerenstva)
Committee member Franjo Pehar (član povjerenstva)
Committee member Mate Juric (član povjerenstva)
Granter University of Zadar (Department of Information Sciences) Zadar
Defense date and country 2020-03-13, Croatia
Scientific / art field, discipline and subdiscipline SOCIAL SCIENCES Information and Communication Sciences
Abstract Glavni cilj ovoga rada je uspoređivanje relacijske baze podataka koje koriste SQL jezik, i neralacijske baze podataka MongoDB koja koristi JSON format. Rad istražuje način zapisivanja bibliografskih metapodataka u internacionalnim standardima ISBD i MARC. Te uspoređuje njihovu strukturu sa strukturama baze podataka. Dok je bibliografska kontrola stara tema knjižnične rasprava, te su određeni standardi odavno odlučeni za određena područja, poput ISBD-a za kataložnu i knjižničnu svrhu, te zatim MARC koji je srodan ISBD strukturi, za računalnu djelatnost. U drugu ruku relacijske baze podataka su popularne od početka prošlog stoljeća, dok su neralacijske počele sa aktivnim reklamiranjem prošlom desetljeću, još nema priznatog standarda za bibliografske podatke. SQL jezik je začet na ideji relacijskih podataka, što bi značilo da tablica sadrži kodirane podatke koji vode do drugih povezanih tablica u kojima su upisane prave vrijednosti, što je srodno MARC formatu koji također ima kodirane podatke. U drugu ruku nerelacijske baze podataka dopuštaju hijerarhičku strukturu podataka što im dopušta veću fleksibilnost. Dok su obe strukture podataka idealne na svoje različite načine, oboje imaju i svoje različite mane. Relacijske baze inzistiraju na standardiziranim podacima te ograničuju unos, dok nerelacijske nemaju nikakve standarde osim onih zadanih od strane programera. Cilj rada je doći do kojekakvog idealnog rješenja i pronaći strukturu koja bi najbolje odgovarala bibliografskim metapodacima.
Abstract (english) This work questions the nature of bibliographic data and explores their posibilities of storage in different dana structures. Relational and hierarchy structures of data both have their flaws and advantages. Advantages of storing dana in relational database come forth during storing large amount of dana which are often changed and updated, it allows change of single instance of data which is then updated through all connected data. Main difference of relational databases is the exclusion of repeating dana, which also gives relational databases an edge when it comes to memory usage. This structure makes relational databases very popular in the areas which handle large about of data changing on a regular basis. Advantages of hierachical database is the possibility of connecting all of our data to a singe object, which makes such a database much easier to use. Every object in the hierarchical database in an object in intself, while in relational database its necessary to call for data from from a number of different tables. The big flaw of this data structure is the number of repeating data is impossible to regulate. Surely the number of repeating data depents on the type of bibliographical data which we're putting in the database, if the subject is of belletristic nature, the number of authors per work is probably gonna stay around one work each, sometimes maybe more. If the subject is scientific works, where one works has up to 30-40 authors, which are repeating in the other works aswell, then we have a problem. Despite all that I believe that hierarchical structure is more ideal for bibliographic work. It describes one work in its entirety and allows of creation of new sub-categories for more specific works. Ideal solution would warrant the implementation of relational structure in areas of often used repeating data, like publisher or author. Luckly most of the databases in use today are hybrid databases, allowing just that, connecting multiple structures of data. Dataases which are imagined as NoSQL databases like MongoDB and databases using SQL shema like MySQL, overtime became hybrid databases. The conclusion of this work is that each database and shema has its own flaws and advantages, and its necessary to study the nature of data we're storing and construct a database according to data.
Keywords
ISBD
MARC
UNIMARC
SQL
NoSQL
MongoDB
JSON
BSON
FRBR
BSON
bibliografski metapodaci
podaci
baza podataka
Keywords (english)
Hierarchical models
relational models
bibliography
databases
ISBD
MARC
UNIMARC
SQL
NoSQL
MongoDB
JSON
BSON
FRBR
Language croatian
URN:NBN urn:nbn:hr:162:651389
Study programme Title: Information Sciences (single major) Study programme type: university Study level: undergraduate Academic / professional title: sveučilišni/a prvostupnik/ prvostupnica (baccalaureus/ baccalaurea) informacijskih znanosti (sveučilišni/a prvostupnik/ prvostupnica (baccalaureus/ baccalaurea) informacijskih znanosti)
Type of resource Text
File origin Born digital
Access conditions Open access
Terms of use
Created on 2021-02-05 08:39:08