Search

Enformasyona dayalı büyük verilerin paylaşıldığı günümüzde verinin korunması, saklanması ve erişilmesi kritik öneme sahiptir. Korunan bir veri ihtiyaç duyulduğunda erişilebilir olmalıdır. Dijitalleşme ve dijital dönüşüm veri saklama ve depolama teknolojilerinde büyük değişimlere neden olmaktadır. Veri yedek alma araçlarının boyutları küçülürken kapasiteleri yükselmekte, daha uygun maliyette ve daha hızlı güvenilir teknolojilere doğru ilerlemektedir. Tüm bu olumlu gelişmelere rağmen verilerin saklandığı cihaz ve sistemler üzerinde bozulma problemleri yaşanmaktadır. Bunun sonucunda veri erişim sorunları oluşmaktadır. Bu sorun veriye dayalı işlemlerin gerçekleştiği bir kurumda iş süreçlerinin durması demektir. Çalışmada geçen her bir sürenin kuruma vereceği hasar oldukça büyüktür. Diğer taraftan bankacılık, eğitim, savunma, sağlık, sigorta, tarım, telekomünikasyon gibi sektörlerde veriler genellikle Microsoft SQL, My SQL, Postgre SQL ve Oracle benzeri ilişkisel veri tabanlarının biri veya birkaçı üzerinde tutulur. Bu veri tabanları veya sunucular üzerinde yaşanabilecek bir bozulma olayı karşısında verinin hangi teknik, süreç ve yöntemlerle nasıl kurtarılması konusunda yeni araştırmalara ihtiyaç vardır. Bu konu dijital veri altyapıların sürekliliğinin sağlanması bakımından kritik öneme sahiptir. Veri tabanı erişiminde yaşanabilecek ani bir kesinti karşısında hızlı bir çözüm üretilememesi durumunda iş sürekliliğinde ciddi sorunlara neden olur. Microsoft veri tabanı kullanımında karşılaşılan bozulma nedenleri, bunlara karşı alınabilecek önlemler, tutarlılık kontrolleri ve veri tabanı kurtarma yöntemleri araştırılmıştır. Büyük veri merkezlerinde kullanılan Microsoft SQL sunucusunda veri tabanı kurtarma senaryolarına dayalı teknik ve yöntemler incelenmiştir. Veri tabanında yaşanabilecek bir bozulma problemin en kısa sürede en az hasarla atlatabilmenin yöntemleri anlatılmış, VT kurtarma senaryoları üzerinden uygulama pratikleri çalışılmıştır. Bu çalışma aynı zamanda öğrenci, araştırmacı ve teknik çalışanlar için bir kılavuz niteliğindedir., In today's world where information-based big data is shared, protecting, storing and accessing data is of critical importance. Protected data should be accessible when needed. Digitization and digital transformation cause great changes in data storage and storage technologies. While the size of data backup tools is getting smaller, their capacity is increasing, and they are moving towards more cost-effective and faster reliable technologies. Despite all these positive developments, there are problems of corruption on the devices and systems where the data is stored. As a result, data access problems occur. This problem means that business processes stop in an institution where data-based transactions take place. The damage to the drying of each time spent in the study is quite large. On the other hand, in sectors such as banking, education, defense, health, insurance, agriculture, telecommunications, data is usually kept on one or more of the relational databases such as Microsoft SQL, My SQL, Postgre SQL and Oracle. There is a need for new research on how to recover data with which techniques, processes and methods in the face of a corruption event that may occur on these databases or servers. This issue has a critical importance in terms of ensuring the continuity of digital data infrastructures. If a quick solution cannot be produced in the face of a sudden interruption in database access, it will cause serious problems in business continuity. The causes of corruption in the use of Microsoft database, the measures that can be taken against them, consistency checks and database recovery methods are investigated. Techniques and methods based on database recovery scenarios in Microsoft SQL server used in large data centers are examined. Methods of overcoming a corruption problem in the database with the least damage in the shortest time are explained, and application practices are studied through VT recovery scenarios. This study also serves as a guide for students, researchers and technical staff.

Kontaktu identificēšana un uzskaitīšana, izmantojot lokalizācijas datus, dod iespēju samazināt inficēšanās risku. Ātra iespēja uzskaitīt un identificēt potenciālos kontaktus starp cilvēkiem dod iespēju ātri ierobežot Covid-19 izplatību starp cilvēkiem. Bakalaura darbs norit projekta “Multdisciplināra pieeja Covid-19 un citu nākotnes epidēmiju monitorēšanai, kontrolei un ierobežošanai Latvijā” ietvaros, kur tiek analizēti izsekošanas sensoru dati telpā. Darbā tiek izstrādāts un testēts datu ielādes modelis, kas dod iespēju veikt attiecīgās datu transformācijas un atlasīšanas, lai precīzi identificētu un uzskaitītu cilvēku kontaktus telpā. Tiek apskatītas dažādas vizualizācijas kā izkliedes diagrammas un karstuma kartes, lai precīzāk noteiktu cilvēku pārvietošanos telpā. Risinājums izmanto MongoDB datubāzi, Microsoft Power BI datu analīzes rīku, MS SQL Server datubāzi un SQL Server Integration Services ielādes pakotnes., Identifying and counting contacts using location data makes it possible to reduce the risk of infection. A quick way to list and identify potential human contacts allows you to quickly limit the spread of Covid-19 in the field. The bachelor's thesis is carried out within the framework of the project “Multidisciplinary approach to monitoring, control and control of Covid-19 and other future epidemics in Latvia”, where the data of tracking sensors in space are analyzed. The work develops and tests a data loading model, which allows to perform the relevant data transformations and selections to accurately identify and list human contacts in the room. Various visualizations are considered, such as scatter plots and heat maps, to more accurately determine the movement of people in a room. The solution uses MongoDB database, Microsoft Power BI data analysis tool, MS SQL Server database and SQL Server Integration Services packages.

Робота виконана на 98 сторінках, містить 61 ілюстрацій, 22 таблиці. При підготовці використовувалася інформація з 33 джерел. Актуальність теми На сьогоднішній день даних, які потрібно аналізувати стає все більше і більше. Компанії мають великі обсяги інформації, але мати інформацію замало, потрібно ще й знати якими саме способами її обробляти та аналізувати. Саме тому дане дослідження має великі перспективи, оскільки розуміння кожного алгоритму Data mining та області його кращого використання буде або спрощувати аналіз для таких компаній, або давати більшу точність отриманих результатів. Мета та задачі дослідження Метою даної роботи є реалізація та дослідження ефективності реалізації алгоритмів Data mining, які надає сервіс MS SQL Server та Microsoft Visual Studio, щоб зрозуміти для яких конкретних задач та з яким об’ємом даних буде кращим той чи інший алгоритм. Рішення поставлених завдань та досягнуті результати В роботі розглянуто алгоритми (алгоритм кластеризації, алгоритм дерева прийняття рішень, алгоритм лінійної регресії, алгоритм взаємозв'язків, спрощений алгоритм Байеса, алгоритм нейронної мережі, алгоритм кластеризації послідовностей, алгоритм часових рядів), які надає сервіс MS SQL Server та Microsoft Visual Studio, реалізовано кожний з них. Обрано задачі (прогнозування дискретного атрибуту, прогнозування безперервного атрибуту, прогнозування послідовності, знаходження груп спільних елементів в транзакціях), які потрібно реалізувати та обрано алгоритми відповідно до специфіки завдань. Реалізовано алгоритми Data mining. В ході аналізу оцінки ефективності реалізації алгоритмів було сформовано рекомендації щодо їх використання для різних задач. Об’єкт досліджень Алгоритми Data mining в середовищі MS SQL Server і Microsoft Visual Studio. Предмет досліджень Ефективність реалізації алгоритмів Data mining в середовищі MS SQL Server і Microsoft Visual Studio. Методи досліджень Для розв’язання зазначеної проблеми в роботі проведено порівняння реалізованих алгоритмів Data mining, виділено задачі на основі яких буде проведено аналіз та виділено основні функціональні особливості кожного алгоритму. Наукова новизна Наукова новизна полягає в тому, що після реалізації кожного алгоритму для конкретної задачі встановлено, який саме алгоритм краще підходить для кожної задачі, щоб в майбутньому малі компанії, які будуть займатися аналізом поведінки реципієнтів могли відразу обрати алгоритми, які їм потрібні. Практичне значення одержаних результатів За результатами проведеного аналізу ефективності реалізації алгоритмів Data mining було сформовано рекомендації щодо їх використання малими компаніями. The work is done on 98 pages, contains 61 illustrations, 22 tables. Information from 33 sources was used in the preparation. Topicality Today, the data that needs to be analyzed is becoming more and more. Companies have large amounts of information, but it is not enough to have information, you also need to know exactly how to process and analyze it. That is why this study has great prospects, because understanding each Data mining algorithm and the areas of its best use will either simplify the analysis for such companies, or give greater accuracy. Purpose The purpose of this work is to implement and study the effectiveness of the implementation of Data mining algorithms provided by MS SQL Server and Microsoft Visual Studio, to understand for which specific tasks and with what amount of data will be the best algorithm. Solution The algorithms (clustering algorithm, decision tree algorithm, linear regression algorithm, interconnection algorithm, simplified Bayesian algorithm, neural network algorithm, sequence clustering algorithm, time series algorithm) that MS S Server provides to the service each of them is implemented. Tasks (prediction of a discrete attribute, prediction of a continuous attribute, prediction of a sequence, finding groups of common elements in transactions) are selected, which need to be implemented and algorithms are selected according to the specifics of the tasks. Data mining algorithms are implemented. In the course of the analysis of the evaluation of the efficiency of the algorithms implementation, recommendations on their use for various tasks were formed. The object of research Data mining algorithms in MS SQL Server and Microsoft Visual Studio. The subject of research Efficiency of implementation of Data mining algorithms in the environment of MS SQL Server and Microsoft Visual Studio. Research methods To solve this problem, the paper compares the implemented data mining algorithms, highlights the tasks on the basis of which the analysis will be performed and highlights the main functional features of each algorithm. Scientific novelty The scientific novelty is that after the implementation of each algorithm for a specific task, it is determined which algorithm is best suited for each task, so that in the future small companies that will analyze the behavior of recipients can immediately choose the algorithms they need. The practical significance of the results obtained. Based on the results of the analysis of the effectiveness of the implementation of Data mining algorithms, recommendations for their use by small companies were formed.

Η εφαρμογή OnlineCourses είναι μια πλατφόρμα όπου παρέχει βίντεο- εξ αποστάσεως μαθήματα σε χρήστες. Καθηγητές από ολόκληρο τον κόσμο πάνω σε ειδικότητες της επιστήμης των υπολογιστών και του λογισμικού παρέχουν μαθήματα είτε δωρεάν είτε επί πληρωμή. Έτσι οι χρήστες μπορούν να έχουν εύκολη πρόσβαση είτε από τον υπολογιστή είτε από tablet ή κινητό. Αυτός ο τεχνικός σχεδιασμός αφορά μόνο το backend κομμάτι και υπάρχει αναλυτική περιγραφή της λειτουργίας του Web API όπου παρέχει τις κατάλληλες πληροφορίες στο UI με την μορφή JSON., The web application OnlineCourses is an education e-learning platform which provides video tutorials to several users. Instructors around the world with specialty in computer science and software development provide courses either free or with a low cost. User can enroll these courses from their computer, tablet or smart phone. This document is the technical documentation of the Web API. It contains only the backend part of the web application. This part provides the appropriate information in JSON format to the UI.

Проєкт містить 77 с. тексту, 42 рисунків, 3 таблиці, посилання на 17 літературних джерел, 2 додатки. Об`єкт розроблення: інформаційна система аналізу та планування роботи підприємства з виробництва плодоовочевої продукції. Мета дипломного проекту: створення інформаційної системи для підприємства з виробництва плодоовочевої продукції, яка надає можливості аналізу економічних показників, обчислення оптимального плану виробництва продукції для максимізації прибутку або обсягу, детальне порівняння результатів. У дипломному проєкті розроблено ІС. Графічний інтерфейс користувача спроектований на основі всіх останніх тенденцій. Система проста в використанні, має швидке та надійне з’єднання з базою даних, надає аналіз важливих показників. Методи оптимізації розроблені за допомогою найкращих, з точки зору математичного програмування, алгоритмів. На рахунку з цим, значну увагу було виділено впровадженню системи в структуру підприємства, що сприяє виконанню майже всієї роботи програмою. Отримані результати можуть бути корисними при оптимізації роботи підприємства. Дана система може застосовуватися на будь-якому підприємстві з виробництва плодоовочевої продукції та на схожих по внутрішній структурі підприємствах. The project contains 77 pages, 42 figures, 3 tables, links to 17 literary sources, 2 appendices. The object of development: the information system of analysis and planning of the enterprise for the production of fruits and vegetables. The aim of the diploma project: creation an information system for the enterprise for the production of fruit and vegetables, which provides opportunities for analysis of economic indicators, calculation of the optimal production plan to maximize profits or volume, detailed comparison of results. IS has been developed in the diploma project. The graphical user interface is designed based on all the latest trends. The system is easy to use, has a fast and reliable connection to the database, provides analysis of important indicators. Optimization methods are developed using the best algorithms, in terms of mathematical programming. On account of this, considerable attention was paid to the implementation of the system in the structure of the enterprise, which contributes to the implementation of almost all the work of the program. The obtained results can be useful in optimization the work of the enterprise. This system can be applied at any enterprise on production of fruit and vegetable production and at the enterprises similar on internal structure.

In recent years, graph databases have become far more important. They have been proven to be an excellent choice for storing and managing large amounts of interconnected data. Since graph databases (GDB) rely on a graph data model based on graph theory, this study examines whether currently available graph database management systems support the principles of graph theory, and, if so, to what extent. We also show how these systems differ in terms of implementation and languages, and we also discuss which graph database management systems are used today and why.

Мета роботи - створити систему автоматизації діяльності навчально-наукових лабораторій. Вибір трьохрівневої архітектури додатку для роботи було зроблено, оскільки дана архітектура забезпечує, більшу масштабованість (за рахунок горизонтальної масштабованості сервера додатків і мультиплексування з'єднань) і велику конфігурованість (за рахунок ізольованості рівнів один від одного). У результаті було розроблено систему автоматизації діяльності навчальнонаукових лабораторій, яка полегшує роботу співробітників лабораторій та допомагає уникнути багатьох помилок та недоліків, які можуть виникати при роботі. The purpose of the work is to create a system of automation of educational and scientific laboratories. The choice of a three-tier application architecture for work was made because this architecture provides greater scalability (due to the horizontal scalability of the application server and connection multiplexing) and greater configuration (due to the isolation of levels from each other). As a result, a system for automating the activities of educational and research laboratories has been developed, which facilitates the work of laboratory staff and helps to avoid many mistakes and shortcomings that may occur during operation. Цель работы - создать систему автоматизации деятельности учебно-научных лабораторий. Выбор трехуровневой архитектуры приложения для работы было сделано, поскольку данная архитектура обеспечивает большую масштабируемость (за счет горизонтальной масштабируемости сервера приложений и мультиплексирования соединений) и большую конфигурируемость (за счет изолированности уровней друг от друга). В результате была разработана система автоматизации деятельности учебно-научных лабораторий лабораторий, которая облегчает работу сотрудников лабораторий и помогает избежать многих ошибок и недостатков, которые могут возникать при работе.

V diplomskem delu smo najprej analizirali trenutno veljavno zakonodajo na področju Republike Slovenije in EU, ki ureja področje revizijske sledi in dostopov do podatkov. Ob tem smo preučili tudi pojem revizijske sledi, od definicije do glavnih lastnosti, ki nam jih ponuja pri kasnejšem odkrivanju sprememb oz. vpogledov v podatke. Zatem smo analizirali problem dostopa končnih uporabnikov do podatkov, kjer smo se osredotočili predvsem na dostopne pravice, zavarovanje občutljivih osebnih podatkov in pogodbeno obdelavo. Sledil je postopek kreiranja revizijske sledi v MS SQL Server, kjer smo uporabili integrirano funkcionalnost revidiranja. Na koncu smo izvedli še testiranje zmogljivosti in ugotovili, da sama funkcionalnost dejansko vpliva na sistem in ga v določenih točkah dodatno obremeni. In our thesis we have analyzed the current legislation in the Republic of Slovenia and the EU, that manages the affairs of audit trail and data availability. We have studied the meaning of audit trail, everything from definition to main characteristics. Then we analyzed the problem of accessing end-users to data, where we primarily focusing on access rights. After that we followed with creating an audit trail in MS SQL Server with integrated audit functionality. After all performance testing, we have found that auditing affects on system performance.

The importance of the process of restoring a database requires precise examination of all factors that affect it. Considering the decline of the price of SSD and its better read and write speeds it seems that the logical choice when reducing downtime is primary concern for the organisation. This paper categorizes storage devices in use as well as the main backup types in the MS SQL Server. Tests are conducted to evaluate the impact of the storage device on backup and restore efficiency. In this regard, the purpose of the research is to examine problems associated with the selection of a storage device for efficient backup and restore in MS SQL Server. Conducted tests showed some surprising results regarding SSD’s efficiency. The reason these findings are important is that they could be used as a guideline for choosing proper storage device for an organisation’s needs. ACM Computing Classification System (1998): H.2.7, I.3.1, D.4.2. Mathematics Subject Classification – MSC2020: 68P15.

El siguiente TFG consiste en realizar la actualización de una parte de la aplicación web interna de la empresa Ford España S.L, concretamente, la parte utilizada para el control de producción y creación de informes. Para llevar a cabo la actualización, primero, se realizará la migración de los datos a una nueva estructura de base de datos (basada en Microsoft SQL Server), consiguiendo, de este modo, la optimización de su funcionamiento. A continuación, se migrarán algunas de las páginas de la aplicación web, previamente diseñadas en ASP classic y VBscript, a tecnología .NET. Por último, se realizará un diseño Responsive para dicha aplicación, es decir, su interfaz gráfica deberá ajustarse visualmente al tamaño de pantalla del dispositivo en que se visualice., The following work consists of updating a part of the internal web application of the Ford España S.L. company, specifically, the one for production control and reporting. First, the migration of the data to a new database structure (based on Microsoft SQL Server) will be carried out, thus achieving operation optimization. Then, some of the web application pages, previously designed in ASP classic and VBscript, will be migrated to .NET technology. Finally, a Responsive design will be made for that web application, i.e., its graphical user interface should be visually adjusted to the screen size of the device in which it is displayed.

Ubrzani razvoj sustava MS SQL server i produkcije novih verzija tog sustava u zadnjih 20-tak godina ima značajan utjecaj na stabilnost poslovnih SQL baza podataka i pripadajućih aplikacija, te poslovnih informacijskih sustava (IS) u cjelini. Produkcije verzija MS SQL servera od 6.0, 6.5, 7.0, 2000, 2005, 2008, 2012, 2014, 2016, 2017 ukazuju na činjenicu kako se vrijeme između produkcije dvije verzije tog sustava skratilo sa nekoliko godina na jednu godinu. Temeljem navedenog postavlja se čitav niz pitanja kao što su: što navedeni ubrzani razvoj znači za aktivne poslovne SQL baze podataka, da li je kontinuirana nabava i instalacija novih verzija MS SQL servera za postojeće korisnike nužna, da li je od strane proizvođača tog sustava osigurana 100% kompatibilnost i mogućnost rutinske migracije postojećih SQL baza na novi sustav MS SQL server ili tu postoje određeni problemi, kako to dugoročno utječe na stabilnost IS-a poduzeća korisnika i sigurnost poslovnih baza podataka, koji su realni troškovi korisnika uzrokovani kontinuiranom produkcijom novih verzija MS SQL servera, koji su potencijalni rizici za korisnike itd. U navedenom smislu prvi cilj ovog rada je dati povijeni pregled verzija MS SQL servera, sa ključnim novostima koje su donosile nove produkcijske verzije, posebno sa stajališta kompatibilnosti SQL baza prethodnih verzija tog sustava. Drugi cilj je prijedlog optimalne i racionalne dinamike zanavljanja sustava MS SQL server koje bi se korisnici tog sustava trebali pridržavati sa ciljem praćenja razvoja tehnologije, ali uz minimalne rizike i troškove. Treći cilj je prijedlog metodike migracije aktivne SQL baze podataka sa postojeće na novu verziju MS SQL servera koja treba osigurati stabilnost poslovnih baza podataka i aplikacija, te poslovnog IS-a u cjelini., The rapid development of MS SQL server system and the manufacture of its new versions over the past twenty years has had a significant impact on the stability of business SQL databases and pertaining applications, and also on the business information systems (IS) in general. The manufacture of MS SQL servers 6.0, 6.5, 7.0, 2000, 2005, 2008, 2012, 2014, 2016, 2017 points to the fact that the time elapsed between two versions of that system has shortened from several years two to one year. This raises a number of questions, such as: how does this accelerated development affect the active business SQL databases?; is the continual procurement and installation of new versions of MS SQL servers something that users absolutely need?; does the manufacturer guarantee a 100% compatibility and option of routine migration of the existing SQL bases to the new MS SQL server system or there are certain problems that the user may expect?; how will, in the long run, that affect the stability of users' IS and the safety of business databases?; what is the real cost for the users of continual production of new versions of MS SQL servers?; what are potential risks for the users thereof?; etc. In the sense of the above, the primary goal of this paper is to provide a historical overview of the versions of MS SQL servers, including major novelties that the new versions bring about, particularly in terms of compatibility with the SQL bases of the previous versions of that system. Secondly, the paper aims to propose optimal and rational dynamic of substituting one version of MS SQL server system with another, which the users should do if they want to keep up with the development of technology, but with minimum risks and expenses. The third goal is to propose the methodology of migration of the active SQL database from the currently used version to a new version of the MS SQL server so as to ensure stability of business database and applications, and the business information systems in general.

V diplomski nalogi je predstavljen IS MODIS s podedovanimi tehnologijami, v katerega smo vgradili vmesnik za davčno potrjevanje računov. Predstavljene so zahteve zakonodajalca za davčno potrjevanje računov. Predstavljen je problem uporabe tehnologij za vzpostavitev TLS seje, klicanje spletnih storitev, elektronsko podpisovanje in preverjanje sporočil, v PowerBuilderju 9.03 in 12.5. Opisan je IS MODIS, njegova struktura in osnovno delovanja sistema. Predstavljeni so objekti, ki nastopajo v IS MODIS. Prikazana in popisana sta funkcionalna diagrama procesa in podatkovna modela procesa izdaje računov v začetnem stanju in končnem stanju. Zbrane so vse potrebne spremembe na aplikaciji in na podatkovni bazi. Opisani so novi objekti in njihove funkcije. Popisani so objekti, ki jih je bilo treba samo dopolniti oz. v katere je bilo treba vgraditi določene klice novih funkcij in objektov, bodisi kontrolnih funkcij bodisi samega zunanjega progama za komunikacijo in pošiljanje podatkov na FURS. Predstavljena je rešitev klica zunanjega programa s parametri ukazne vrstice, ki skrbi za komunikacijo z ISFU. Na koncu je opisano umeščanje modula v produkcijsko okolje, popisane so težave v začetni fazi delovanja ter opisane dodatne dodelave, ki so jih zahtevale stranke oz. zakonodajalec. Navedene se tudi nekatere izboljšave oziroma predlogi za lažje vzdrževanje in nadgrajevanje IS MODIS. The diploma thesis presents IS MODIS with legacy technologies, into which an interface for the fiscal verification of invoices has been integrated. The statutory requirements for the fiscal verification of invoices are presented. The problem of using said technologies for establishing a TLS session, for calling online services, for digital signature and verification of messages in PowerBuilder 9.03 and 12.5 is presented. IS MODIS is described, its structure and the system's basic operation. The objects which appear in IS MODIS are presented. Two process flow and data flow diagrams for the process of issuing invoices in the initial and final state are shown and explained. All of the necessary modifications to the application and database are mentioned, followed by a description of new objects and their functions. The objects which had to be supplemented or into which specific calls to new functions and objects had to be integrated (either to control functions or to the external program for communication and sending of data to the Financial Administration of the Republic of Slovenia) are listed. A solution for calling an external program, which communicates with ISFU, using command line parameters is presented. In the conclusion a description of the installation of the module into the production environment, a list of problems in the initial stage of operation, and a description of the add-ons requested by clients or the legislator are given, followed by a number of improvements or suggestions for easier maintenance and upgrading of IS MODIS.

Vsakodnevno se srečujemo z različnimi tegobami kot so: prebavne težave, kolcanje, prehlad, piki žuželk ipd. Na voljo so razni zdravilni napitki, zdravila različnih vrst ter zdravilne rastline, ki nam lahko odpravijo ali pa oblažijo tegobe. Po navadi nas tegobe presenetijo in nanje nismo pripravljeni, ne vemo, kako bi si pomagali, pa čeprav imamo morda rešitev ves čas v bližini. Z zdravilnimi rastlinami kot so čebula, peteršilj, česen, bazilika ipd, si lahko olajšamo ali pa celo odpravimo tegobe. Problem se pojavi, ko ne vemo, katero zdravilno rastlino bi uporabili za lajšanje tegob, ker ne poznamo njihovih učinkov. Če bi se hoteli podučiti, bi morali prebrati kar nekaj knjig, kar pa je zelo zamudno. Z namenom, da bi si lažje pomagali pri lajšanju tegob, smo naredili raziskavo na spletu in knjižnicah, da bi našli knjigo ali pa spletno stran, ki vsebuje čim več podatkov. Našli smo knjigo z naslovom »Ščepec védenja«, ki vsebuje preglednico s tegobami in zdravilnimi rastlinami ter natančnejšimi opisi zdravilnih rastlin. Vendar pa ostaja iskanje po knjigi in preglednici zamudno in je težko najti željeno vsebino, ko jo potrebujemo. Odločili smo se, da izdelamo namizno aplikacijo, s katero si lahko hitreje pomagamo pri odpravljanju tegob. Namizna aplikacija s preprostim uporabniškim vmesnikom vsebuje zdravilne rastline s katerimi si lahko lajšamo različne tegobe. Izdelali smo jo s pomočjo odprtokodnega okolja Eclipse, medtem ko smo za podatkovno bazo zdravilnih rastlin in tegob uporabili MS SQL Server. Testiranje delujoče prototipne rešitve je izvedlo pet oseb, ki so različnih starosti in stroke, podali so mnenje o uporabnosti ter videzu aplikacije. Izkazalo se je, da prototipna rešitev lahko služi kot pripomoček k uporabi knjige »Ščepec védenja« ter skrajša zamudno iskanje po spletu ali ostalih knjigah o zdravilnih rastlinah in tegobah. Everyday we are faced with a variety of health ailments like hiccups, cold, insect bites, gastrointestinal problems, etc. To alleviate this problems we can select between healthy drinks, medicine and healing plants. Usually health disorders are unpredicted and may surprise us when we are not prepared, so we do not have enough knowledge to solve our problems. Healing plants like onion, parsley, garlic, basil, etc. can alleviate or even heal the some of the most common or specific health ailments. There is a vast knowledge about healing plants and their usage, however most of the data is still found in hard copy, which makes it even harder to identify the right solution or health plant. After we the research on internet, web pages suitable for ease of use and self-help and for books in libraries, we found the book »Ščepec védenja«. Book contains table of healing plants and health ailments and precise description of healing plants. Searching through the book and the table for useful information’s is still long process, so we decided to build a desktop application for easier search of health ailments for self-helping. Desktop application with simple graphical user interface includes healing plants for ease self-helping. The main framework for building the application was open source environment Eclipse, for the database of healing plants and health ailments we used MS SQL server. At the end five persons of different age and profession, tested the program and they give an opinion on graphical user interface’s appearance and its usability. Test analyses showed that desktop application can be as addition to the book, mainly because it provides a faster search for the right healing plant than looking into the books or searching the web.

в данной статье авторами рассматриваются наиболее актуальные в настоящее время системы управления базами данных. В работе дается определение термину, а также краткая характеристика СУБД. Исследователями выявляются функции, выделяются основные группы СУБД.

Dissertação de Mestrado em Engenharia Informática apresentada à Faculdade de Ciências e Tecnologia da Universidade de Coimbra Com o objectivo de melhorar os processos internos nas áreas de controlo do ciclo de vida dos suportes de publicidade de exterior (outdoors), bem como gerir o parque instalado, a empresa Espaços pretendeu desenvolver um sistema (Sistema Integrado de Gestão do Parque - SIGP) de modo a automatizar os procedimentos específicos do seu negócio. A aplicação é web based, no entanto, algumas funcionalidades podem ser utilizadas em dispositivos móveis que utilizem os sistemas Android e IOS. A aplicação criada possui não só a capacidade de gestão do parque instalado, o registo das características de um suporte, a criação de uma rede de suportes e respetivos preços de comercialização, como também permite integrar funcionalidades que cobrem todo o ciclo de vida do suporte: angariação, montagem, venda e respetiva afixação e eventual desmontagem do outdoor. Está também prevista a funcionalidade de gestão e controlo das atividades de manutenção preventiva e corretiva do suporte. A aplicação irá comunicar com o backoffice da empresa Espaços baseado em PHC (sistema ERP de faturação e financeiro). Esta integração irá enviar os dados necessários para o PHC poder emitir faturas. Os dados mestre relativos ao negócio específico da empresa estarão na posse do sistema construído ficando o PHC com a função de faturar e realizar o respetivo reflexo contabilístico. O sentido de integração é SIGP -> PHC, evitando-se assim integrações bidirecionais entre as duas aplicações. A abordagem proposta pela Softwell Europe (SE) consiste em realizar este desenvolvimento através do Maker®, plataforma que permite criar de uma forma muito rápido aplicações específicas aos processos de negócio das empresas. Esta plataforma, como será especificado no restante deste documento, permite criar de forma ágil não só aplicações web based, mas também aplicações móveis que, no limite, podem adaptar-se a qualquer tipo de necessidade de negócio. A metodologia proposta integra-se dentro do conceito RAD (Rapid Application Development), que permite de uma forma iterativa desenvolver a aplicação em conjunto com os utilizadores de negócio fomentado grande aproximação entre os programadores e os conhecedores do negócio. Com o desenvolvimento desta aplicação a empresa conseguiu o aumento da produtividade das atividades de gestão do parque de outdoors instalado. Através do ambiente integrado é conseguida de uma forma automática a obtenção de dados de negócio essenciais para a tomada de decisões táticas e operacionais. No futuro pretende-se igualmente que este ambiente permita a obtenção dos dados necessários para a tomada de decisões estratégicas nomeadamente a nível comercial e de localização geográfica de futuros suportes integrantes do parque instalado.

This thesis is about comparison between C# and Java in implementation of a university desktop application. In .Net world the prominent IDE is MS Visual studio and DB is MS SQL server. In Java domain we have several IDEs and techniques to approach the problem. The knowledge to choose between these techniques to use is as much as important if a programmer can gain it, he can apply it in many other software engineering domains like a personal management system, library system, etc. Therefore the importance of a descriptive and applied experience is showing itself up. This thesis has started with a discussion to choose NetBeans IDE and application definition, and use case modeling then it goes through comparison and implementation part. The comparison will go in depth for each use case in this project in its implementation in C# and Java and see which techniques are used. This includes comparison between these two apps in Software quality factors.

Analysis of already created heat metering and billing systems are made. Lacks and advantages of existing systems are overlooked and considered for add-on model development. Heat metering and billing functions are described and solution is presented. MS Navision and MS SQL Server technologies usability aspects where analyzed. The functionality of MS Navision where compared with described heat metering and billing functions and the fit-gap where made. Product was built as a specific add-on module for MS Navision Attain. The most important goals of product where heat energy billing integration with financial management and flexible data model for program adaptation to methodology changes of heat energy billing. Data model flexibility analysis where done and compatibility to requirements was established. MS Navision and MS SQL server functions performance testes where run and recommendations for choosing platform are made.

U radu je opisan Program za multikorisnički rad u mrežnom okruženju, koji je namenjen za vođenje personalne evidencije u okviru jedinice. Program je razvijen tako da u mrežnom okruženju radi sa bazom podataka, Microsoft SQL Server, a kada je mreža nefunkcionalna da radi lokalno sa MS Access, i da omogući automatsko ažuriranje podataka iz lokalne u glavnu bazu podataka. Prva verzija programa razvijena je i nalazi se u fazi probnog rada., The paper presents an application program for personnel files of a unit. The application works in multi-user and network environment. It is developed to work with the Microsoft SQL Server database in network environment and to work with the MS Access database when network is not functional and to allow data synchronization between the local and the main database. The alpha version of the application program is finished and it is on a test drive now.

Prosjektet har gått ut på å finne ut om vektorteknologier som Macromedia Flash 5 fungerer til dynamisk presentasjon av multimediell informasjon. Det ble utviklet en prototype på en dynamisk informasjonskanal for å teste ut problemstillingen. Systemet ble bygd opp med en MS SQL Server-database til lagring av informasjon. Macromedia Flash 5 ble benyttet til visuell presentasjon av innholdet i databasen og ASP ble benyttet til kommunikasjon mellom databasen og Flash. Systemet skulle kunne håndtere tekst, lyd, bilde og video. Informasjonskanalen skulle hente opp informasjon i tilfeldig rekkefølge fra databasen. Denne rekkefølgen skulle imidlertid kunne overstyres av informasjon som det var ønskelig å vise på et bestemt tidspunkt. Informasjonen skulle presenteres på en TV-skjerm. Det må påpekes at gruppa, ved prosjektets start, var klar over at applikasjonen Macromedia Generator benyttes som et mellomledd på serveren mellom en dynamisk Flashfil og en database. Macromedia Generator er et kostbart verktøy og studentene fikk fra flere hold høre at det var noe ustabilt i bruk. Studentene var derfor interessert i å finne ut om det var mulig å oppnå det samme ved å bare bruke ASP i kombinasjon med Flash.