155 results on '"MS SQL Server"'
Search Results
2. DISTRIBUTED WAREHOUSING FOR VIBRATIONAL SIGNALS ANALYSIS SYSTEM
- Author
-
V. E. Bazarevsky
- Subjects
ms sql server ,Electronics ,TK7800-8360 - Abstract
Article covers the methods of vibration signals long implementations analysis as well as complex analysis of large amounts of signal data. Several architectural pattern applications of signal and analytical data warehouses for decision support system that evaluates the vibration characteristics of the objects are proposed. The ways of extending and embedding third-party functionality in MS SQL Server engine are recommended. more...
- Published
- 2019
Catalog
3. Obsługa danych temporalnych na platformie MS SQL Server i Azure SQL Database.
- Author
-
ŁACHECIŃSKI, Sebastian
- Subjects
TEMPORAL databases ,DATABASES ,POSSIBILITY - Abstract
Copyright of Przegląd Elektrotechniczny is the property of Przeglad Elektrotechniczny and its content may not be copied or emailed to multiple sites or posted to a listserv without the copyright holder's express written permission. However, users may print, download, or email articles for individual use. This abstract may be abridged. No warranty is given about the accuracy of the copy. Users should refer to the original published version of the material for the full abstract. (Copyright applies to all Abstracts.) more...
- Published
- 2020
- Full Text
- View/download PDF
4. Performance Analysis of .NET Based Object–Relational Mapping Frameworks
- Author
-
Gruca, Aleksandra, Podsiadło, Przemysław, Kozielski, Stanislaw, editor, Mrozek, Dariusz, editor, Kasprowski, Pawel, editor, Małysiak-Mrozek, Bożena, editor, and Kostrzewa, Daniel, editor
- Published
- 2014
- Full Text
- View/download PDF
5. CORRELATION BETWEEN STORAGE DEVICE AND BACKUP AND RESTORE EFFICIENCY IN MS SQL SERVER.
- Author
-
Kuyumdzhiev, Ivan and Nacheva, Radka
- Subjects
SQL ,STORAGE ,SOLID state drives ,DATABASES - Abstract
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 this is the logical choice when reducing downtime is a primary concern for the organisation. This paper categorizes storage devices in use as well as main backup types in 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 selection of a storage device for efficient backup and restore in MS SQL Server. The 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. [ABSTRACT FROM AUTHOR] more...
- Published
- 2019
6. Development of a distributed personal data storage using cryptography technology
- Subjects
WPF ,EDM ,cryptography ,MS SQL Server ,ÐÐÐ ,кÑипÑогÑаÑÐ¸Ñ ,C# ,С# - Abstract
Ð¦ÐµÐ»Ñ ÑабоÑÑ â ÑоздаÑÑ ÑиÑÑÐµÐ¼Ñ Ð¾Ð±Ð¼ÐµÐ½Ð° и Ñ ÑÐ°Ð½ÐµÐ½Ð¸Ñ Ð¿ÐµÑÑоналÑнÑÑ Ð´Ð°Ð½Ð½ÑÑ , заÑиÑÑованнÑÑ Ñ Ð¿Ð¾Ð¼Ð¾ÑÑÑ ÑÐµÑ Ð½Ð¾Ð»Ð¾Ð³Ð¸Ð¸ кÑипÑогÑаÑии. ÐÑа ÑиÑÑема Ð¿Ð¾Ð·Ð²Ð¾Ð»Ð¸Ñ Ð¿ÐµÑедаваÑÑ Ð¸ полÑÑаÑÑ ÑазлиÑнÑе иденÑиÑикаÑоÑÑ Ð¿Ð¾Ð»ÑзоваÑелей, ÑÑÐ¾Ð±Ñ Ð°Ð²ÑоÑизоваÑÑ Ð¸Ñ Ð² ÑÐ²Ð¾Ð¸Ñ ÑиÑÑÐµÐ¼Ð°Ñ . ÐÑо в ÑÐ²Ð¾Ñ Ð¾ÑеÑÐµÐ´Ñ Ð¿Ð¾Ð¼Ð¾Ð¶ÐµÑ Ð¾Ð¿ÑимизиÑоваÑÑ Ð²ÑÐµÐ¼Ñ Ð¾ÐºÐ°Ð·Ð°Ð½Ð¸Ñ ÑÑлÑг в ÑазлиÑнÑÑ Ð±ÑÑокÑаÑиÑеÑÐºÐ¸Ñ ÑиÑÑÐµÐ¼Ð°Ñ , по ÑÑÑи, обÑединив Ð¸Ñ Ð² однÑ. ÐадаÑи, коÑоÑÑе ÑеÑалиÑÑ Ð² Ñ Ð¾Ð´Ðµ ÑабоÑÑ: ÐпÑеделÑлаÑÑ Ð¿ÑедмеÑÐ½Ð°Ñ Ð¾Ð±Ð»Ð°ÑÑÑ. РазÑабаÑÑвалаÑÑ Ð°ÑÑ Ð¸ÑекÑÑÑа пÑогÑаммного обеÑпеÑениÑ. СоздавалÑÑ Ð°Ð»Ð³Ð¾ÑиÑм пеÑедаÑи даннÑÑ . ÐÑбÑÐ°Ð½Ñ ÑÐµÑ Ð½Ð¾Ð»Ð¾Ð³Ð¸Ð¸, коÑоÑÑе иÑполÑзовалиÑÑ Ð² ÑазÑабоÑке. Сама ÑиÑÑема делиÑÑÑ Ð½Ð° ÑзлÑ. ÐаждÑй Ñзел ÑоÑÑÐ¾Ð¸Ñ Ð¸Ð· ÑÑÑÑ ÑаÑÑей. ÐеÑÐ²Ð°Ñ ÑаÑÑÑ â ÑÐµÐ³Ð¼ÐµÐ½Ñ Ñ ÑанилиÑа. Ðн пÑедÑÑавлÑÐµÑ Ñобой банк даннÑÑ , коÑоÑÑй ÑÐ¸Ð½Ñ ÑонизиÑÑеÑÑÑ Ñ Ñакими же банками из ÑазнÑÑ Ñзлов. ÐаждÑй ÑÐµÐ³Ð¼ÐµÐ½Ñ ÑодеÑÐ¶Ð¸Ñ Ð² Ñебе иденÑиÑнÑй и полнÑй Ð½Ð°Ð±Ð¾Ñ Ð´Ð°Ð½Ð½ÑÑ . ÐÑоÑой â инÑоÑмаÑÐ¸Ð¾Ð½Ð½Ð°Ñ ÑиÑÑема ÑÑбÑекÑа, она аккÑмÑлиÑÑеÑ, маÑÑÑÑÑизиÑÑÐµÑ Ð¸ пеÑеÑпаковÑÐ²Ð°ÐµÑ Ð·Ð°Ð¿ÑоÑÑ, оÑвеÑÑ Ð¸ пакеÑÑ Ð¸Ð½ÑоÑмаÑии, коÑоÑÑе могÑÑ Ð¿ÑедназнаÑаÑÑÑÑ, как и ÑегменÑÑ Ñ ÑанилиÑа, Ñак и ÑÑеÑÑÐµÐ¼Ñ ÑÑаÑÑÐ½Ð¸ÐºÑ Ñзла â ÑиÑÑеме полÑзоваÑелÑ/пÑоизводиÑÐµÐ»Ñ Ð´Ð°Ð½Ð½ÑÑ . ÐÑа ÑиÑÑема либо ÑоздаÑÑ Ð¸Ð½ÑоÑмаÑÐ¸Ñ Ð¾ Ñеловеке, либо запÑаÑÐ¸Ð²Ð°ÐµÑ Ð´Ð»Ñ Ð°ÑÑенÑиÑикаÑии его внÑÑÑи ÑÐ²Ð¾Ð¸Ñ ÑиÑÑем. ÐлиенÑ-ÑеÑвеÑÐ½Ð°Ñ ÑаÑÑÑ Ð½Ð°Ð¿Ð¸Ñана на ÑзÑке C#, даннÑе пÑеобÑазÑÑÑÑÑ Ð² пакеÑÑ JSON ÑоÑмаÑа и пеÑедаÑÑÑÑ Ð¿Ð¾ пÑоÑÐ¾ÐºÐ¾Ð»Ñ TCP. ÐÐ»Ñ ÑиÑÑÐ¾Ð²Ð°Ð½Ð¸Ñ Ð¸ÑполÑзÑÑÑÑÑ ÐºÐ²Ð°Ð»Ð¸ÑиÑиÑованнÑе подпиÑи, коÑоÑÑе ÑоздаÑÑÑÑ Ñ Ð¿Ð¾Ð¼Ð¾ÑÑÑ ÑдоÑÑовеÑÑÑÑего ÑенÑÑа. РаÑÑиÑÑованнÑе даннÑе Ñ ÑанÑÑÑÑ ÑолÑко в ÑиÑÑÐµÐ¼Ð°Ñ Ð¿Ð¾Ð»ÑзоваÑелÑ/пÑоизводиÑÐµÐ»Ñ Ð´Ð°Ð½Ð½ÑÑ . Ð¡ÐµÐ³Ð¼ÐµÐ½Ñ Ñ ÑанилиÑа Ñ ÑÐ°Ð½Ð¸Ñ ÑолÑко в заÑиÑÑованном. ÐнÑоÑмаÑÐ¸Ð¾Ð½Ð½Ð°Ñ ÑиÑÑема ÑÑбÑекÑа Ñ ÑÐ°Ð½Ð¸Ñ ÑолÑко логи пеÑедаÑи даннÑÑ Ð¸ аккÑмÑлиÑÑÐµÑ Ð·Ð°ÑиÑÑованнÑе даннÑе в Ñом ÑлÑÑае, еÑли доÑÑавиÑÑ Ð¸Ñ Ð² нÑжнÑе ÑиÑÑÐµÐ¼Ñ Ð½Ðµ пÑедÑÑавлÑеÑÑÑ Ð²Ð¾Ð·Ð¼Ð¾Ð¶Ð½Ñм из-за ÑÐµÑ Ð½Ð¸ÑеÑÐºÐ¸Ñ Ð½ÐµÐ¿Ð¾Ð»Ð°Ð´Ð¾Ðº., The purpose of the work is to create a system for the exchange and storage of personal data encrypted using cryptography technology. This system will allow you to transmit and receive various user IDs to authorize them in their systems. This, in turn, will help to optimize the time of rendering services in various bureaucratic systems, in fact, combining them into one. Tasks that were solved during the work: The subject area was determined;Software architecture was developed; The data transfer algorithm was created;Selected technologies that were used in the development. The system itself is divided into nodes. Each node consists of three parts. The first part is the storage segment. It is a data bank that is synchronized with the same banks from different nodes. Each segment contains an identical and complete set of data. The second is the information system of the subject, it accumulates, routes, and repackages requests, responses and packets of information that can be intended for both the storage segment and the third participant of the node â the user/data producer system. This system either creates information about a person, or requests to authenticate him inside its systems. The client-server part is written in C#, the data is converted into JSON format packets and transmitted over TCP. For encryption, qualified signatures are used, which are created with the help of an authentication center. The decrypted data is stored only in the systems of the user/data producer. The storage segment is stored only encrypted. The subject's information system stores only data transmission logs and accumulates encrypted data in the event that it is not possible to deliver them to the necessary systems due to technical problems. more...
- Published
- 2022
- Full Text
- View/download PDF
7. Development of a web application for learning the C# language based on unit tests
- Subjects
unit test ,MS SQL Server ,модÑлÑнÑй ÑеÑÑ ,Web application ,Blazor ,веб-пÑиложение ,коан ,ASP.NET Core ,teaching programming ,koan ,обÑÑение пÑогÑаммиÑÐ¾Ð²Ð°Ð½Ð¸Ñ - Abstract
Тема вÑпÑÑкной квалиÑикаÑионной ÑабоÑÑ: «РазÑабоÑка веб-пÑÐ¸Ð»Ð¾Ð¶ÐµÐ½Ð¸Ñ Ð´Ð»Ñ Ð¾Ð±ÑÑÐµÐ½Ð¸Ñ ÑзÑÐºÑ C# на базе модÑлÑнÑÑ ÑеÑÑов». Ð Ñ Ð¾Ð´Ðµ данной ÑабоÑÑ Ð±Ñло ÑазÑабоÑано веб-пÑиложение Ð´Ð»Ñ Ð¾Ð±ÑÑÐµÐ½Ð¸Ñ ÑзÑÐºÑ C# на базе модÑлÑнÑÑ ÑеÑÑов. РпеÑвой главе пÑоиÑÑ Ð¾Ð´Ð¸Ñ Ð°Ð½Ð°Ð»Ð¸Ð· пÑедмеÑной облаÑÑи, пÑоводиÑÑÑ ÑÐ°Ð·Ð±Ð¾Ñ ÑÑÑеÑÑвÑÑÑÐ¸Ñ Ð°Ð½Ð°Ð»Ð¾Ð³Ð¾Ð² и ÑоÑмиÑÑÑÑÑÑ ÑÑÐµÐ±Ð¾Ð²Ð°Ð½Ð¸Ñ Ðº веб-пÑиложениÑ. Ðо вÑоÑой главе опиÑÑваÑÑÑÑ ÑÑÑеÑÑвÑÑÑие Ð¿Ð¾Ð´Ñ Ð¾Ð´Ñ Ðº ÑÐ¾Ð·Ð´Ð°Ð½Ð¸Ñ Ð²ÐµÐ±-пÑиложений, ÑзÑки пÑогÑаммиÑованиÑ, ÑÑеймвоÑки и меÑÐ¾Ð´Ñ Ñ ÑÐ°Ð½ÐµÐ½Ð¸Ñ Ð´Ð°Ð½Ð½ÑÑ . ÐбоÑновÑваеÑÑÑ Ð²ÑÐ±Ð¾Ñ Ð¸Ð½ÑÑÑÑменÑов ÑазÑабоÑки. Ð ÑÑеÑÑей главе опиÑÑваÑÑÑÑ ÑвÑзи Ð¼ÐµÐ¶Ð´Ñ ÑÑÑноÑÑÑми Ð±Ð°Ð·Ñ Ð´Ð°Ð½Ð½ÑÑ , а Ñакже демонÑÑÑиÑÑеÑÑÑ Ð¸ опиÑÑваеÑÑÑ Ð¿Ð¾Ð»ÑзоваÑелÑÑкий инÑеÑÑейÑ. Ð ÑеÑвÑÑÑой главе пÑоиÑÑ Ð¾Ð´Ð¸Ñ Ð¾Ð¿Ð¸Ñание некоÑоÑÑÑ ÑÐµÑ Ð½Ð¸ÑеÑÐºÐ¸Ñ ÑеÑений пÑи ÑазÑабоÑке. Рв пÑÑой главе пÑиводÑÑÑÑ ÑезÑлÑÑаÑÑ ÑеÑÑиÑÐ¾Ð²Ð°Ð½Ð¸Ñ Ð²ÐµÐ±-пÑÐ¸Ð»Ð¾Ð¶ÐµÐ½Ð¸Ñ Ð¿Ð¾Ð´ полÑзоваÑелÑми Ñ ÑазнÑми ÑолÑми., The subject of the graduate qualification work is «Development of a web application for learning the C# language based on unit tests». In the course of this work, a web application was developed for teaching the C# language based on unit tests. In the first chapter, the subject area is analyzed, the existing analogues are analyzed, and the requirements for the web application are formed. The second chapter describes the existing approaches to creating a web application, programming languages, frameworks and data storage methods. The choice of certain development tools is substantiated. The third chapter describes the relationships between the entities of the database, and also demonstrates and describes the user interface. In the fourth chapter there is a description of some technical solutions during development. The fifth chapter presents the results of testing a web application under users with different roles. more...
- Published
- 2022
- Full Text
- View/download PDF
8. Database recovery techniques in Microsoft SQL server
- Author
-
Şahinaslan, Ender, Şahinaslan, Önder, Maltepe Üniversitesi, Mühendislik ve Doğa Bilimleri Fakültesi, and Şahinaslan, Önder
- Subjects
MS SQL sunucu ,bozulma ,data backup ,MS SQL server ,corruption ,veri tabanı kurtarma ,veri tabanı ,veri yedekleme ,database ,database recovery - Abstract
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. more...
- Published
- 2022
9. Компьютеризация технологии международного книгообмена
- Subjects
ms windows ,ms sql server ,Bibliography. Library science. Information resources - Abstract
The article describes the possibilities of the authors' software package for automation of all technological library processes, connected with book exchange (processing orders from partners, the formation of proposals for partners, registration of receipts, sending books, etc.). The system is realized in the MS WINDOWS environment and based database management system MS SQL SERVER-2005. It is put into operation in the VGBIL. more...
- Published
- 2010
10. Database and Web Application for a Shop
- Author
-
Milički, Magda and Vrdoljak, Boris
- Subjects
TEHNIČKE ZNANOSTI. Računarstvo ,narudžbe ,proizvodi ,kupci ,customers ,baza podataka ,administratori ,products ,online shop ,MS SQL Server ,TECHNICAL SCIENCES. Computing ,orders ,internet trgovina ,admins ,ASP.NET MVC ,database - Abstract
Tema ovog završnog rada bila je izrada web-aplikacije za trgovinu. Ovim završnim radom koncipirana je baza podataka i web-aplikacija koja se bavi internet trgovinom. Kupci mogu naručivati proizvode koje internet trgovina nudi, dok administratori pregledavaju pristigle narudžbe te ih izvršavaju. Administratori dodaju nove proizvode, mijenjaju ih ili brišu iz baze podataka. Baza podataka implementirana je korištenjem MS SQL Servera koji služi za upravljenje relacijskim bazama podataka, a web aplikacija izrađena je pomoću C#, ASP.NET MVC, HTML, CSS, JavaScript i jQuery tehnologija. Završni rad opisuje izrađenu bazu podataka, opis funkcionalnosti aplikacije te korisničke upute. The main topic of this paper was the development of a Web Application for a Shop. Working on this task, a database and Web Application for a shop were implemented. Customers can easily order groceries this store is offering and admins can see all of the orders that were created and deliver them to the customers. Admins can add, modify or delete new products from the database. The databse was implemented using MS SQL Server, which is used to manage relational databases and Web Application was created using C#, ASP.NET MVC, HTML, CSS, JavaScript and jQuery technologies. This paper describes the implemented database, a description of the application's functionality and instructions for users. more...
- Published
- 2021
11. Program za vođenje personalne evidencije / Application program for personnel files
- Author
-
Miroslav Stojanović, Damir Kopčanski, and Igor Jozić
- Subjects
personalna evidencija ,MS SQL Server ,MS Access ,MS Visual C++ ,ADO ,OLE DB ,Automation ,personnel files ,automation ,Military Science ,Engineering (General). Civil engineering (General) ,TA1-2040 - Abstract
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. more...
- Published
- 2002
- Full Text
- View/download PDF
12. Replikacija baze podataka u sustavu SQL Server
- Author
-
Antunović, Viktor
- Subjects
replikacije baze podataka ,MS SQL Server ,MS SQL Server replikacija ,transakcijska replikacija ,P2P replikacija - Abstract
U kontekstu sustava za upravljanje bazama podataka, replikacija predstavlja proces kopiranja i distribucije podataka iz jedne baze u drugu, a zatim i sinkronizaciju između baza podataka radi održavanja konzistentnosti i integriteta podataka. U radu su istražene i predstavljene različite tehnike replikacije, s različitim pristupima problemu sinkronizacije, koje su omogućene u sustavu MS SQL Server. Konkretno, opisane su najvažnije značajke replikacije snimkom, replikacije spajanjem i transakcijske replikacije. S ciljem demonstracije učinaka P2P transakcijske replikacije, u radu je implementirano i testirano ogledno rješenje koje emulira uslugu kritičnog sustava. Sustav obuhvaća dva poslužitelja s konfiguriranom replikacijom baze podataka i eksternu aplikaciju koja generira i šalje podatke u obje baze, te omogućava nadgledanje podataka u bazama oba poslužitelja. U tako realiziranom sustavu provedena je analiza utjecaja veličine podataka i frekvencije unosa podataka na učinak replikacijskog mehanizma. Pokazano je kako oba faktora na odgovarajući način utječu na brzinu replikacije, pri čemu, očekivano, veličina podataka predstavlja faktor sa značajnijim utjecajem. more...
- Published
- 2021
13. РАЗРАБОТКА МЕДИЦИНСКОЙ ИНФОРМАЦИОННОЙ СИСТЕМЫ С ЭЛЕМЕНТАМИ ПОДДЕРЖКИ ПРИНЯТИЯ РЕШЕНИЙ В КАРДИОЛОГИИ
- Subjects
диагностическая модель ,веб-приложение ,Angular ,web application ,машинное обучение ,NET ,information system ,machine learning ,MS SQL Server ,атеросклероз ,atherosclerosis ,diagnostic model ,информационная система ,Python - Abstract
Предлагаемое исследование посвящено описанию медицинской информационной системы (МИС), разработанной с целью сопровождения врача-кардиолога при обследовании и лечении пациентов с профильной патологией (заболеваниями сердечно-сосудистой системы). Данная система предоставляет возможности мониторинга и хранения показателей состояния здоровья пациента, а также назначения медицинских консультаций и плановых посещений. Система включает модуль искусственного интеллекта, на данный момент предоставляющего возможности по ранней диагностике и прогнозированию риска магистрального атеросклероза у всех обратившихся пациентов, а также по прогнозированию смертности пациентов, перенесших инфаркт миокарда. Данный программный продукт разработан на основе платформы .NET с использованием Angular, СУБД MS SQL Server и моделей машинного обучения на языке Python., The study describes a health information system (HIS) developed for the purpose of accompanying a cardiologist during the examination and treatment of patients with special pathology (diseases of the cardiovascular system). This system provides opportunities for monitoring and storing indicators of the patient's health status as well as assigning medical consultations and scheduled visits. The system includes an artificial intelligence module, which currently provides opportunities for early diagnosis and prediction of the risk of major atherosclerosis in all patients who have applied, as well as for predicting the mortality of patients who have suffered a myocardial infarction. The software is developed on the basis of .NET using Angular, MS SQL Server DBMS and Python machine learning models., Международный научно-исследовательский журнал, Выпуск 8 (110) 2021, Pages 69-76 more...
- Published
- 2021
- Full Text
- View/download PDF
14. Identification and enumeration of contacts based on localization data to reduce the risk of infection
- Author
-
Knīss, Rainers, Seļāvo, Leo, and Latvijas Universitāte. Datorikas fakultāte
- Subjects
Microsoft Power BI ,SQL Server Integration Services ,MS SQL Server ,Datorzinātne ,Covid-19 - Abstract
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. more...
- Published
- 2021
15. Аналіз ефективності реалізації алгоритмів Data mining з використанням сервісу Microsoft SQL Server
- Author
-
Капшук, Олег Олексійович
- Subjects
MS SQL Server ,Data mining ,004.42 ,Microsoft Visual Studio - Abstract
Робота виконана на 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. more...
- Published
- 2020
16. Online Courses .NET MS SQL SERVER
- Author
-
Αλέπης, Ευθύμιος, Σχολή Τεχνολογιών Πληροφορικής και Επικοινωνιών. Τμήμα Πληροφορικής, and Πληροφορική
- Subjects
NET ,Εκπαιδευτική πλατφόρμα ,MS SQL SERVER ,REST API ,Online courses - Abstract
Η εφαρμογή 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. more...
- Published
- 2020
- Full Text
- View/download PDF
17. Система аналізу та планування роботи підприємства з виробництва подоовочевої продукції
- Author
-
Моргаль, Олег Михайлович
- Subjects
WPF ,плодоовочеве підприємство ,аналіз ,ІС ,004.94 ,MS SQL Server ,максимізація прибутку та обсягу ,планування ,симплекс метод ,CodeFirst - Abstract
Проєкт містить 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. more...
- Published
- 2020
18. GRAPH DATABASE MANAGEMENT SYSTEMS AND GRAPH THEORY
- Author
-
informatics, Pavlinska , Varaždin, Croatia, Sonja Ristić, Robert Kudelić, Kornelije Rabuzin, and Bevanda, V.
- Subjects
Theoretical computer science ,Graph database ,Computer science ,Management system ,Graph theory ,Neo4j ,MS SQL server ,Oracle ,Cypher ,computer.software_genre ,computer ,MathematicsofComputing_DISCRETEMATHEMATICS - Abstract
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. more...
- Published
- 2020
- Full Text
- View/download PDF
19. Database security methods
- Subjects
ms sql server ,ÑиÑÑование ,row level security ,Ð¼Ð¾Ð´ÐµÐ»Ñ Ð´Ð¾ÑÑÑпа ,Ð±Ð°Ð·Ñ Ð´Ð°Ð½Ð½ÑÑ ,access model ,data security ,заÑиÑа инÑоÑмаÑии ,database ,encryption - Abstract
ÐÐ°Ð½Ð½Ð°Ñ ÑабоÑа поÑвÑÑена меÑодам заÑиÑÑ Ð¸Ð½ÑоÑмаÑии. Ð ÑеоÑеÑиÑеÑкой ÑаÑÑи ÑÑого пÑоекÑа вÑполнено иÑÑледование и анализ меÑодов обеÑпеÑÐµÐ½Ð¸Ñ Ð±ÐµÐ·Ð¾Ð¿Ð°ÑноÑÑи в ÑиÑÑÐµÐ¼Ð°Ñ ÑпÑÐ°Ð²Ð»ÐµÐ½Ð¸Ñ Ð±Ð°Ð·Ð°Ð¼Ð¸ даннÑÑ . ÐÑÑледÑÑÑÑÑ ÑÑÑеÑÑвÑÑÑие Ð¼ÐµÑ Ð°Ð½Ð¸Ð·Ð¼Ñ Ð¾Ð±ÐµÑпеÑÐµÐ½Ð¸Ñ Ð±ÐµÐ·Ð¾Ð¿Ð°ÑноÑÑи в MS SQL Server. РпÑакÑиÑеÑкой ÑаÑÑи ÑабоÑÑ Ð±Ñла Ñеализована ÑиÑÑема безопаÑноÑÑи Ñ ÐºÐ¾Ð¼Ð¿Ð»ÐµÐºÑнÑм Ð¿Ð¾Ð´Ñ Ð¾Ð´Ð¾Ð¼., This work is dedicated to information protection methods. In the theoretical part of this project, a study and analysis of security methods in database management systems were done. The existing security mechanisms in MS SQL Server were examined. In the practical part of the work, a security system with an integrated approach was implemented. more...
- Published
- 2020
- Full Text
- View/download PDF
20. Система автоматизації діяльності навчально-наукових лабораторій
- Author
-
Лабжинський, Володимир Анатолійович
- Subjects
трьохрівнева архітектура ,Entity Framework ,LINQ ,MS Sql Server - Abstract
Мета роботи - створити систему автоматизації діяльності навчально-наукових лабораторій. Вибір трьохрівневої архітектури додатку для роботи було зроблено, оскільки дана архітектура забезпечує, більшу масштабованість (за рахунок горизонтальної масштабованості сервера додатків і мультиплексування з'єднань) і велику конфігурованість (за рахунок ізольованості рівнів один від одного). У результаті було розроблено систему автоматизації діяльності навчальнонаукових лабораторій, яка полегшує роботу співробітників лабораторій та допомагає уникнути багатьох помилок та недоліків, які можуть виникати при роботі. 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. Цель работы - создать систему автоматизации деятельности учебно-научных лабораторий. Выбор трехуровневой архитектуры приложения для работы было сделано, поскольку данная архитектура обеспечивает большую масштабируемость (за счет горизонтальной масштабируемости сервера приложений и мультиплексирования соединений) и большую конфигурируемость (за счет изолированности уровней друг от друга). В результате была разработана система автоматизации деятельности учебно-научных лабораторий лабораторий, которая облегчает работу сотрудников лабораторий и помогает избежать многих ошибок и недостатков, которые могут возникать при работе. more...
- Published
- 2020
21. Öğretim Yænetim Sistemleri ıçin Örnek Veri Tabanı Tasarımı.
- Author
-
DEPERLİOĞLU, Ömer and SARPKAYA, Yılmaz
- Subjects
DATABASE design ,SYSTEMS design ,DISTANCE education ,SQL ,DECLARATIVE programming languages ,WINDOWS (Graphical user interfaces) - Abstract
Copyright of International Journal of InformaticsTechnologies is the property of Institute of Informatics, Gazi University and its content may not be copied or emailed to multiple sites or posted to a listserv without the copyright holder's express written permission. However, users may print, download, or email articles for individual use. This abstract may be abridged. No warranty is given about the accuracy of the copy. Users should refer to the original published version of the material for the full abstract. (Copyright applies to all Abstracts.) more...
- Published
- 2009
22. Audit trail provision in a data warehouse
- Author
-
Vozlič, Darko and Kežmah, Boštjan
- Subjects
revizijska sled ,MS SQL Server ,audit trail ,udc:004.657(043.2) ,revidiranje ,GDPR ,zmogljivost ,auditing ,performance - Abstract
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. more...
- Published
- 2019
23. ETL za skladišta podataka - Microsoft SQL Server 2017 Integration Services
- Author
-
Antolić, Sofija
- Subjects
skladišta podataka ,ETL ,MS SQL Server - Abstract
Microsoft SQL Server 2017 Integration Services (u literaturi skraćeno SSIS) je platforma za izgradnju kompleksnih ETL rješenja za poslovna skladišta podataka. Sastoji se od brojnih gotovih funkcija i zadataka koje uz pomoć grafičkog sučelja možemo posložiti u kompleksne ETL procese koje nazivamo SSIS paketima. Cilj rada je opisati Microsoft SQL Server 2017 Integration Services, počevši od stavljanja pojma u kontekst objašnjenjem temeljnih pojmova uz koje je vezan (skladišta podataka, ETL, poslovna inteligencija). Nakon teoretskog dijela, ideja je na praktičnom primjeru prikazati i opisati uporabu i svrhu SSIS-a, kao i većinu njegovih funkcionalnosti. more...
- Published
- 2019
24. Correlation Between Storage Device and Backup and Restore Efficiency in MS SQL Server
- Author
-
Ivan Kuyumdzhiev and Radka Nacheva
- Subjects
MS SQL Server ,Data_FILES ,Backup and Restore Performance ,Databases Performance Tests ,Storage Media - Abstract
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. more...
- Published
- 2019
25. Migración y desarrollo de aplicación Web Responsive para control y creación de informes de producción en la empresa Ford España S.L., basada en tecnología .NET y Microsoft SQL Server
- Author
-
Pallás Caballero, Juan, Boronat Segui, Fernando, Universitat Politècnica de València. Departamento de Comunicaciones - Departament de Comunicacions, Universitat Politècnica de València. Escuela Politécnica Superior de Gandia - Escola Politècnica Superior de Gandia, Hernández Moya, David, Pallás Caballero, Juan, Boronat Segui, Fernando, Universitat Politècnica de València. Departamento de Comunicaciones - Departament de Comunicacions, Universitat Politècnica de València. Escuela Politécnica Superior de Gandia - Escola Politècnica Superior de Gandia, and Hernández Moya, David more...
- Abstract
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. more...
- Published
- 2018
26. Migración y desarrollo de aplicación Web Responsive para control y creación de informes de producción en la empresa Ford España S.L., basada en tecnología .NET y Microsoft SQL Server
- Author
-
Hernández Moya, David
- Subjects
NET ,MS SQL Server ,Grado en Ingeniería de Sistemas de Telecomunicación, Sonido e Imagen-Grau en Enginyeria de Sistemes de Telecomunicació, So i Imatge ,production control ,aplicació web ,web app ,INGENIERIA TELEMATICA ,responsive design ,control de producción ,Ford España - Abstract
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. more...
- Published
- 2018
27. UTJECAJ RAZVOJA SUSTAVA MS SQL SERVER NA STABILNOST POSLOVNIH APLIKACIJA I BAZA PODATAKA
- Author
-
Stjepan Vidačić, Mario Špicar, Assistant Professor Iva Gregurec, PhD, Associate Professor Antun Biloš, PhD, Assistant Professor Martina Tomičić Furjan, PhD, Assistant Professor Ivan Kelić, PhD, and Assistant Professor Davorin Turkalj, PhD more...
- Subjects
MS SQL server, SQL baza, migracija SQL baze, informacijski sustav, poslovne aplikacije ,MS SQL server ,SQL baza ,migracija SQL baze ,informacijski sustav ,poslovne aplikacije ,SQL base ,migration of SQL base ,information system ,business applications - Abstract
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. more...
- Published
- 2018
28. Database and Web Application for Monitoring Sports Results
- Author
-
Šmitran, Marko and Vrdoljak, Boris
- Subjects
sportski rezultati ,MS SQL Server ,sports results ,statistics ,TECHNICAL SCIENCES. Computing ,TEHNIČKE ZNANOSTI. Računarstvo ,statistika ,C# ,ASP.NET Core ,Bootstrap - Abstract
Tema ovog završnog rada je bio izraditi bazu podataka i web-aplikaciju za praćenje sportskih rezultata. Sustav pohranjuje podatke o sportašima, timovima, mečevima, natjecanjima te statistike sportaša i timova. Proces izrade odvijao se u dva koraka. Prvo je bilo potrebno oblikovati model entiteti-veze i relacijski model baze podataka te ju potom implementirati. Baza je ostvarena na lokalnom računalu korištenjem MS SQL Server-a (2014). Nakon toga bilo je potrebno izraditi web-aplikaciju za prikaz, unos, brisanje i izmjenu podataka iz baze korištenjem programskog jezika C#. Aplikacija je izrađena korištenjem radnog okvira ASP.NET Core (1.1.2) te radnog okvira Bootstrap (3.3.7) koji je korišten za izradu prikaza korisničkog sučelja. This thesis focuses on developing a database and web application for tracking sports results. System stores data about athletes, teams, matches, results, competitions and individual athlete statistics as well as team statistics. This process consisted of two parts. First, an entity-relationship model and relationship model of the database were designed and then it was implemented. Database was created on the local host using MS SQL Server (2014). After that web application which displays and allows modification of database data was built using programming language C#. Application was built using ASP.NET Core (1.1.2) framework and Bootstrap (3.3.7) framework which was used for designing user interface. more...
- Published
- 2017
29. Možnosti analytických nástrojů v prostředí MS SQL Serveru
- Author
-
Mazáčová, Markéta
- Subjects
in-memory ,MS SQL Server ,SQL Server Analysis Services ,multidimenzionální model ,business intelligence ,OLAP ,tabulární model ,Azure Analysis Services - Abstract
The thesis compares the development time and performance of two types of Microsoft analytical models created in Visual Studio that are deployed on the local analytics servers and the Azure cloud server. Theoretical research will be summarizing business intelligence and data warehouses components, Microsoft tools for business intelligence realization and features using in-memory database technologies. The practical part introduces the AdventureWorks demonstration database,describes the implementation of both analytical models and compares both models with respect to the time-consuming development, performance and suitability of deployment. more...
- Published
- 2017
30. Data Warehouse performance comparing Relational Database Management Systems and the Hadoop-based NoSQL Database system
- Author
-
Al-Wattar, Nazar
- Subjects
- Big data, Business intelligence, Data warehouse, Hadoop, MS SQL server, RDBMS
- Abstract
One of the biggest problems that many companies face nowadays is dealing with the huge volumes of data that they generate daily. In the data-driven world all data needs to be stored, organized and analyzed to get the required information that will help the administration to make the right decision to support the next step of the company. Big Data and Business Intelligence have become very popular terms in the business field, where Big Data highlights the tools that are used to manage the huge volume of data. One of the Big Data tools is the Data Warehouse, which is used to manipulate the massive amount of data, while the Business Intelligence (BI) focuses on how we can analyze information from the huge volumes of data that support companies in decision making In this thesis, we will compare the implementation of the DW concepts using the Relational Database Management Systems (RDBMS), specifically, SQL Server DB over the Hadoop system, and then analyze the resource (CPU and RAM) consumption. I prove that using the Hadoop system speeds up the process of manipulating these huge volumes of data with very low cost, based on the nature of the Hadoop system that is efficient in processing all kinds of structured, semi-structured, unstructured or raw data with minimum cost and high efficiency in manipulating and storing massive amounts of data. more...
- Published
- 2020
31. Uvedba davčnih blagajn v aplikacijo s podedovanimi tehnologijami
- Author
-
PERKO, FLORJAN and Ciglarič, Mojca
- Subjects
aplikacija ,davčne blagajne ,online services ,legacy application ,podedovane tehnologije ,external program ,fiscal cash register ,zunanji program ,IS MODIS ,MS SQL server ,spletne storitve ,PowerBuilder ,strežnik MS SQL ,application - Abstract
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. more...
- Published
- 2016
32. SOFTWARE SOLUTION FOR SELECTION OF MEDICAL PLANTS
- Author
-
Granda, Primož and Rajkovič, Uroš
- Subjects
MS SQL Server ,zdravilne rastline ,healing plants ,Eclipse - Abstract
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. more...
- Published
- 2016
33. Обзор современных СУБД
- Subjects
серверные СУБД ,MS SQL Server ,СУБД ,Oracle ,настольные СУБД ,DB2 ,IBM - Abstract
в данной статье авторами рассматриваются наиболее актуальные в настоящее время системы управления базами данных. В работе дается определение термину, а также краткая характеристика СУБД. Исследователями выявляются функции, выделяются основные группы СУБД. more...
- Published
- 2016
34. Návrh databáze pro připojení systému SAP jako zdroje dat pro webovou aplikaci
- Author
-
MARHOUN, Lukáš
- Subjects
ComputingMilieux_MANAGEMENTOFCOMPUTINGANDINFORMATIONSYSTEMS ,Hardware_MEMORYSTRUCTURES ,ERP system ,T -SQL ,uložené procedury ,MS SQL Server ,user defined functions ,uživatelské funkce ,stored procedures ,Relační databáze ,Relational database ,T-SQL ,SAP ,ERP systém SAP ,SAP BW - Abstract
The thesis deals with connecting SAP ERP system via local database system MS SQL Server using the tools SAP BI, data synchronization between systems and advanced usage of T-SQL language for preparing data for web applications and reports written in PHP. The thesis contains a brief overview of the SAP system and the possibility of connecting to the SAP system. The general principles of described solution can be used in conjunction with other systems and programming languages. more...
- Published
- 2016
35. Обзор современных СУБД
- Author
-
Карманович Иван Игоревич, Орский гуманитарно-технологический институт (филиал) ФГБОУ ВО «Оренбургский государственный университет», Модин Вадим Сергеевич, Карманович Иван Игоревич, Орский гуманитарно-технологический институт (филиал) ФГБОУ ВО «Оренбургский государственный университет», and Модин Вадим Сергеевич more...
- Abstract
в данной статье авторами рассматриваются наиболее актуальные в настоящее время системы управления базами данных. В работе дается определение термину, а также краткая характеристика СУБД. Исследователями выявляются функции, выделяются основные группы СУБД. more...
- Published
- 2016
36. Analysis and Design Business Intelligence solutions for ATOZ group
- Author
-
Machaj, Maroš, Pour, Jan, and Horníček, Martin
- Subjects
MS SQL Server ,BI (Business Inteligence) ,BI (Business Intelligence) ,OLAP ,ETL (data pump) ,ETL (dátová pumpa) ,DWH ,dimensional modeling ,Dimenzionální modelování - Abstract
The main objective of this work will be the analysis of BI solution for this company, which deals with the publication of professional journals and the organization of conferences. BI solution should be used by company management. In order to achieve the objective of this work it was necessary to contact the company with IT professionals and employees who have access to the IS company. It was also necessary to consult the requirements for BI solutions for a company with a higher-ranking employees of the company. Thanks to these consultations it was possible to create the skeleton for the analysis of the company and on these grounds the new key indicators were created. To these indicators then new dimensions were added as well. The practical part consists of two parts, namely the analysis of a specific BI solution for the company. The work will include a small sample of BI solution for BI benefits. This solution includes designing the data warehouse, ETL and pilot solution. The contribution of this work is to design BI for publishing (advertising) company. The company is quite specific, so another company for which it would be suitable as well, is difficult to find. more...
- Published
- 2015
37. Web-aplikacija za grupnu komunikaciju u stvarnom vremenu
- Author
-
Juretić, Damir and Botički, Ivica
- Subjects
grupna komunikacija ,SignalR ,MS SQL Server ,group communication ,TECHNICAL SCIENCES. Computing ,TEHNIČKE ZNANOSTI. Računarstvo ,ASP.NET MVC - Abstract
Cilj ovog diplomskog rada bila je izrada web aplikacije za grupnu komunikaciju u stvarnom vremenu. Web aplikacija omogućava grupnu komunikaciju u stvarnom vremenu te njezinim korisnicima omogućava kreiranje grupa, registraciju novih korisnika, definiranje uloga korisnika za pojedinu grupu korisnika, uređivanje podataka o korisnicima, sigurnu komunikaciju između više korisnika u stvarnom vremenu te pregled raznih statističkih izvještaja. Aplikacija je zamišljena kao sredstvo komunikacije namijenjeno prvenstveno poslovnim korisnicima. S druge strane, njezin intuitivan dizajn čini je dostupnom i prihvatljivom svakoj vrsti korisnika koji su jednostavno u potrazi za brzim i lakšim načinom razmjene informacija. Web aplikacija Cakula dostupna je na web adresi https://cakula.azurewebsites.net . The aim of this master thesis was to build web application for real time group communication. Web application allows users to create groups, the registration of new users, define user roles for specific group of users, edit user data, secure communication between multiple users in real time and review various statistics reports. The application is designed as a communication tool intended for business users. On the other hand, its intuitive design makes it accessible and acceptable to every kind of users who are simply looking for a quick and easy way of exchanging information. Cakula website is available on web address https://cakula.azurewebsites.net . more...
- Published
- 2015
38. Business Intelligence v prostředí informačního systému QI
- Author
-
Blažek, Tomáš
- Subjects
MS SQL Server ,Business Intelligence ,Informační systém QI - Abstract
This work provides a survey of creation of the Business Intelligence by using QI information system data. The work concisely describes Business intelligence functions and its user's environment. QI system and the way of data storage are also defined in this dissertation. The following chapters describe the design and implementation of Business Intelligence itself over the actions made by registered employees. The proposal describes the design of a data storage system, a method of obtaining the necessary data from the QI information system, ETL process design, OLAP cubes design, and how to interpret the information in the form of reports. The last chapter then describes the realisation of all the proposed districts in MS SQL Server. more...
- Published
- 2015
39. Ladění fyzického návrhu databáze v SQL Serveru
- Author
-
Bača, Radim, Stodůlka, Petr, Bača, Radim, and Stodůlka, Petr
- Abstract
Tato diplomová práce pojednává o ladění fyzického návrhu databáze v SQL Serveru. SQL Server má k dispozici nástroj Database Engine Tuning Advisor, sloužící pro nalezení optimálního fyzického návrhu. Jedním z cílů této práce je ukázat, že intuitivní návrh člověka bude často lepší než návrh, který nalezne Database Engine Tuning Advisor. Dalším cílem bude vytvoření aplikace, která umožní otestovat a porovnat více fyzických návrhů pro databázi. Nakonec provedeme porovnání fyzických návrhů pro TPC-H Benchmark databázi, které byly získány jak nástrojem SQL Serveru, tak člověkem., This master's thesis is about automated physical database design and tuning in SQL Server. SQL Server has a Database Engine Tuning Advisor tool used to find the optimal physical database design. One of the goals of this work is to show that the intuitive physical database design built by man will often be better than the design found by Database Engine Tuning Advisor. Another goal will be to create an application for testing and comparing of other physical database designs. Finally, we will compare the TPC-H Benchmark database designs created by both the SQL Server tool and the human designer., Ve zpracování, Import 22/07/2015 more...
- Published
- 2015
40. SIGP - Sistema integrado de gestão do parque
- Author
-
Catarino, Bruno André Pinhal and Laranjeiro, Carlos Nuno Bizarro e Silva
- Subjects
maker ,IOS e Web Based ,MS SQL Server ,Outdoor ,Android - Abstract
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. more...
- Published
- 2014
41. Nadzorne plošče na portalu Microsoft SharePoint
- Author
-
Dolgan, Mirjam and Mahnič, Viljan
- Subjects
računalništvo ,OLAP ,data warehouse ,computer science ,magisteriji ,podatkovno skladišče ,udc:004(043.2) ,portal ,MS SQL Server ,ETL process ,proces ETL ,MS Office SharePoint ,performance dashboards ,business performance management ,upravljanje učinkovitosti poslovanja ,business inteligence ,master's degree ,strežnik MS SQL ,poslovno obveščanje ,nadzorne plošče - Published
- 2014
42. Izrada relacijske baze podataka na MS SQL Server 2008 platformi
- Author
-
Del Vechio, Romano
- Subjects
relacijska baza ,MS SQL Server - Abstract
U radu je na konkretnoj programskoj podršci za izradu baze podataka pokazan pristup izradi programskog rješenja za prikupljanje i obradu podataka za aplikaciju Recepture koja se koristi u tvrtki AgroCroatia Nova d.o.o.. Sustav je izrađen pomoću programske podrške MS SQL Server 2008. Podacima u bazi se upravlja preko korisničkog sučelja, te su u radu prikazani alati i metode koji se koriste za prikupljanje, pretvorbu i integraciju informacija. Izradom rada je obihvaćen opis problematike upravljanja informacijama, organiziranje, sinkroniziranje, arhiviranje i sakupljanje podataka unutar MS SQL Server 2008 te automatizirano prikupljanje podataka i izrada izvještaja. Cilj rada je dobivanje uvida u značajke ovakvog pristupa i načina izrade programskog rješenja. more...
- Published
- 2012
43. Comparison between C# and Java : in implementation of a university desktop app
- Author
-
Sabet, Shahrooz
- Subjects
Net ,DB ,Programvaruteknik ,MS SQL server ,Software quality ,Software Engineering ,NetBeans ,Desktop application ,C# ,Java ,MS Visual studio - Abstract
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. more...
- Published
- 2012
44. Srovnání výkonu vybraných SŘBD
- Author
-
Bednář, Pavel, Stodůlka, Petr, Bednář, Pavel, and Stodůlka, Petr
- Abstract
V této bakalářské práci se budu zabývat výkonnostním porovnáním vybraných SŘBD, jelikož jich v dnešní době existuje velké množství. Každé z těchto SŘBD disponuje odlišným výkonem prováděných dotazů a uložených procedur. Cílem této práce je srovnání několika významných SŘBD pro různé typy dat a dotazů. Tato práce se bude zaměřovat na SŘBD jako je Oracle a MS SQL Server. Budou zde popsány typy tabulek a indexů nad oběma SŘBD. Dále pak popis měřených transakcí a následně výsledky a porovnání z tohoto měření., In this master thesis I will discuss the performance comparison of selected DBMS, since there exists nowadays a large amount. Each of these DBMS has a different performance of queries and stored procedures. The goal of this work is to compare several major DBMSs for different types of data and queries. This work will be focus on the DBMS such as Oracle and MS SQL Server. There will describe the types of tables and indexes both DBMS. Furthermore, the description of the measured transaction and then comparing results of this measurement., Ve zpracování, Import 26/06/2013 more...
- Published
- 2013
45. Business Intelligence in MS Dynamics AX 2009
- Author
-
Hubáček, Filip, Pour, Jan, and Derfler, Václav
- Subjects
MS SQL Server ,nákladové účetnictví ,Reporting ,Cost Accounting ,OLAP ,MS Dynamics AX ,Business Intelligence - Abstract
The subject of the diploma thesis entitled "Business Intelligence in Microsoft Dynamics AX" is to analyze the functionality of the ERP system Microsoft Dynamics AX 2009 in the area of Business Intelligence and Reporting with the reflection of the current market position of the company. The goal is to set the basic definition of the relationship between ERP and Business Intelligence systems, further defining the possibilities of MS Dynamics AX in BI in the terms of their practical use and also to describe the fundamental technological aspects. The aim of the work is evaluation and definition particular steps during implementation based on methodology MS Sure Step 2010 together with description of deployment process. As a reflection of insufficient coverage of some of the areas is mentioned solution of the company Circon Circle Consulting. Also is realized proposal for BI for AX cost accounting module, including designing data mart, ETL and report with respect to specifics, such as the parent-child hierarchies and many-to-many relationship between fact tables and dimensions. The contribution of this work is mainly evident for the consultants of the system, to who is provided insight into the important and for users attractive functionality and also is offered possible implementation process. Technically oriented readers may appreciate the solutions for Cost Accounting and potential approaches to the concept of data mart or other areas where they meet the above-mentioned aspects. more...
- Published
- 2010
46. Application of BI in system for skill increasing
- Author
-
Laušman, Jakub, Novotný, Ota, and Svoboda, Zdeněk
- Subjects
MS SQL Server ,Database ,OLAP Cube ,Business Intelligence ,OLAP Kostky ,Dynamické flash grafy ,Dynamic flash graph ,MySQL ,databáze - Abstract
This Diploma thesis deals with the analysis and proposal of the pilot BI solution for the company Svoboda & Partner CZ s.r.o., engaged in the automechanic expertise. Fundamental objectives of this work focus particularly on the above mentioned pilot BI solutions and partial objectives deal with an analysis of the company and its needs, arising from business strategy and market analysis applications available to support the visualization of transaction reporting. These objectives have been achieved by analyzing the company's business model in chapter seven, further analysis of needs and problems within the company in chapter eight. Before the analysis, the diploma thesis deals with a survey of available applications that offer functionality of dynamically generated graphs to aid visualization of transaction reporting in chapter six and finally a major analysis and preparation of pilot BI and transaction reporting for this business which you can find from chapter 9 to chapter eleven. Contribution of this work for the company will be a complete analysis and delivery of all necessary documents in order to decide whether the above BI solutions to the company implement or not. In the case of a positive decision of the company, it is expected that thanks to BI solutions the ways of looking at corporate data can be more expanded, more precise and more operational management of the company, achieving better performance, higher profits and more efficient decision-making based on better data for decision making. more...
- Published
- 2010
47. Replikacja danych na urządzenia przenośne
- Author
-
Harężlak, Katarzyna
- Subjects
replikacja danych ,mobilne bazy danych ,synchronizacja ,rozwiązywanie konfliktów aktualizacji danych ,MS SQL Server - Abstract
W pracy analizowano możliwość zastosowania mobilnych serwerów baz danych do stworzenia środowiska rozproszonej bazy danych z wykorzystaniem mechanizmów replikacji danych. Szczególną uwagę zawrócono na aspekty związane z inicjalizacją repliki na urządzeniu przenośnym oraz cykliczną jej synchronizację z serwerem centralnym. Badania prowadzone były w środowisku wykorzystującym narzędzia firmy Microsoft: SQL Server 2005 oraz SQL Server Mobile., Studia Informatica, Vol 30, No 2A (2009) more...
- Published
- 2009
- Full Text
- View/download PDF
48. Corporate reporting on platform MS SQL Server
- Author
-
Štěrba, Ladislav, Pitka, Lukáš, and Adámek, Karel
- Subjects
Business Intelligence ,Reporting ,MS SQL Server - Abstract
The thesis dicusses the business reporting using the Microsoft SQL Server 2008 R2 platform. The first part examine the technical aspects of the problem and studies the Integration Services, Reporting Services and Analysis Services applications as well as the possibilities of their integration with other business information systems. The second part analyses the possibilities of using the Microsoft's Business Intelligence by a business establishement and its gainings. It also presents several practical examples of application. more...
- Published
- 2009
49. Applying Business Intelligence tools for the Financial and Property Analysis of Municipalities
- Author
-
Horký, Martin Bc., Novotný, Ota, and Ing. Petr Toth, Ph.D.
- Subjects
XML ,integrační služby ,Finanční a majetková analýza municipalit ,datový sklad ,XSLT ,OLAP ,Business Intelligence ,dimenzionální analýza ,Financial and Property Analysis of Municipalities, Business Intelligence, Data Warehouse, Dimensional Analysis, OLAP, Integration Servises, MS SQL Server, Excel, ProClarity ,MS SQL Server - Abstract
This master thesis deals with the software support of one Financial and Property Analysis of Municipalities (FAMA). The co-author of this method is Doctor Petr Toth from the Institute of Public Administration and Regional Development at University of Economics in Prague. The method is supported by Microsoft Access database application and two C++ applications ArisDestiller and Prognoza at present time. The aim of this thesis is to evaluate the present software support of Financial and Property Analysis and implement an alternative solution based on Business Intelligence tools. Chosen part of analysis is implemented in the pilot project using Microsoft SQL Server 2005 environment. The thesis focuses mainly on using integration tools for XML data. The contribution of the thesis is to implement data warehouse, which uses the municipalities‘annual bills in XML format from the database of Ministry of Finance of the Czech Republic. The Financial and Property Analysis method and the current software support are discussed in the first half of this thesis. The other half of the work is dedicated to the Business Intelligence pilot project. Both means of software support are reviewed and compared from various perspectives in the conclusion. more...
- Published
- 2008
50. Applying Business Intelligence tools for the Financial and Property Analysis of Municipalities
- Author
-
Horký, Martin, Novotný, Ota, and Toth, Petr
- Subjects
XML ,integrační služby ,Finanční a majetková analýza municipalit ,MS SQL Server ,Data Warehouse ,Integration Servises ,XSLT ,Business Intelligence ,ProClarity ,OLAP ,Dimensional Analysis ,dimenzionální analýza ,Financial and Property Analysis of Municipalities ,datový sklad - Abstract
This master thesis deals with the software support of one Financial and Property Analysis of Municipalities (FAMA). The co-author of this method is Doctor Petr Toth from the Institute of Public Administration and Regional Development at University of Economics in Prague. The method is supported by Microsoft Access database application and two C++ applications ArisDestiller and Prognoza at present time. The aim of this thesis is to evaluate the present software support of Financial and Property Analysis and implement an alternative solution based on Business Intelligence tools. Chosen part of analysis is implemented in the pilot project using Microsoft SQL Server 2005 environment. The thesis focuses mainly on using integration tools for XML data. The contribution of the thesis is to implement data warehouse, which uses the municipalities'annual bills in XML format from the database of Ministry of Finance of the Czech Republic. The Financial and Property Analysis method and the current software support are discussed in the first half of this thesis. The other half of the work is dedicated to the Business Intelligence pilot project. Both means of software support are reviewed and compared from various perspectives in the conclusion. more...
- Published
- 2008
Discovery Service for Jio Institute Digital Library
For full access to our library's resources, please sign in.