Dissertação (mestrado)—Universidade de Brasília, Instituto de Ciências Exatas, Departamento de Ciência da Computação, 2016. / Submitted by Albânia Cézar de Melo (albania@bce.unb.br) on 2017-02-15T12:23:44Z No. of bitstreams: 1 2016_JaneAdrianaSouza.pdf: 1805634 bytes, checksum: be4f8c819c44b36ff04c685db1485101 (MD5) / Approved for entry into archive by Raquel Viana(raquelviana@bce.unb.br) on 2017-03-17T17:00:26Z (GMT) No. of bitstreams: 1 2016_JaneAdrianaSouza.pdf: 1805634 bytes, checksum: be4f8c819c44b36ff04c685db1485101 (MD5) / Made available in DSpace on 2017-03-17T17:00:26Z (GMT). No. of bitstreams: 1 2016_JaneAdrianaSouza.pdf: 1805634 bytes, checksum: be4f8c819c44b36ff04c685db1485101 (MD5) / Nos últimos anos, novos modelos de banco de dados, chamados NoSQL (Not Only SQL) estão sendo considerados alternativas para a gestão de grandes volumes de dados - Big Data, pois gerenciam e armazenam os dados de forma eficiente, possuem alta escalabilidade, disponibilidade e desempenho satisfatório. A administração de bancos de dados implica na execução de tarefas, tais como criação de bases e objetos, atribuição de privilégios, realização de backups, dentre outras atividades. A execução dessas tarefas de administração em bancos de dados NoSQL exige um maior nível de conhecimento por parte dos administradores de bancos de dados (DBA), e expõe questões relacionadas à falta de familiaridade desses profissionais nos ambientes NoSQL. De forma a contribuir nesse campo de estudo, a presente dissertação apresenta a solução NoSQL2 para execução de tarefas de administração, usando a linguagem SQL (Structured Query Language), que funciona em diferentes Sistemas Gerenciadores de Bancos de Dados (SGBD) NoSQL. O NoSQL2 permite aos DBAs se desvincularem das particularidades de formas de acesso de cada NoSQL, pois disponibiliza recursos para conversão de comandos da sintaxe SQL para a sintaxe proprietária do banco de dados NoSQL. / New database models, called NoSQL (Not Only SQL) are considered appropriate alternatives for managing and storing Big Data due to their efficiency, high scalability, availability and performance. Database administration effects tasks such as creating databases and objects, attributing priorities and performing backups. The execution of these tasks, in NoSQL databases, require that DBA (database administrators) have a high level of knowledge, and often exposes problems with the DBA unfamiliarity of the NoSQL environments. In order to contribute to the scholarship in this field, this paper presents the middleware NoSQL2 to perform management tasks using the SQL language, which runs on different NoSQL databases. The NoSQL2 allows DBA to disassociate themselves from the particularities of access forms of each NoSQL, since provides resources for converting SQL commands to the proprietary NoSQL database syntax.

Examensarbetet har utförts åt det nystartade företaget Idop AB:s vägnar och har inneburit en vidareutveckling av ett befintligt webbaserad bokningssystem för det specifika företaget. Huvudsyftet har varit att leverera en webbaserad bokningskalender där uthyrare kan lägga ut sina objekt samtidigt som intressenter kan boka dessa objekt. Dessa objekt kan omfattas av till exempel lägenheter, stugor och så vidare. Då projektet kräver att utvecklare och kund har ett nära samarbete valdes Skalning Agil metod som är en Agil metod, för att bäst uppnå detta syfte. Utvecklingen utav bokningssystemet skedde i en .NET miljö där programmeringsspråket var C#. För datalagring hade företaget Idop valt SQL server och interaktion med databasen sker genom Entity Framework. Resultatet av projektet blev en bokningskalender där uthyraren lägger ut sina lediga objekt för uthyrning under specifika datum samt uppger pris för den lediga perioden. Även intressenterna har nu möjlighet att preliminär boka ett specifikt objekt vid önskat datum. I rapporten förekommer mer detaljerad beskrivning av ovanståendenämnda punkter samt slutsatsen av projektet. / This project has been carried out on the recently started company Idop AB's behalf and has led to a further development of an existing webbased booking system for the mentioned company. The main goal has been to deliver a web-based booking calendar where advertiser can place their items while stakeholders can book these items. These items may be subject to such houses, cottages and so on. The project requires developers and customers to work closely, Scaling Agile Methods which is an agile method, was chosen for this purpose in order to best achieve this aim. The development of the booking system was written in a .NET environment in which the programming language was C#. For database, the company Idop AB had chosen SQL server and for interaction with the database Entity Framework. The outcome of the project was an online based booking calendar where the owners outsource their vacant properties for rent during specific dates and report the prices for the vacant period. The stakeholders are now able to make a preliminary booking of a specific object at the desired date. The report present more detailed description of the above mentioned points and the conclusion of the project.

No description available.

Static analysis of database design and implementation is not a new idea. Many researchers have covered the topic in detail and defined a number of metrics that are well known within the research community. Unfortunately, unlike the use of metrics in code development, the use of these metrics has not been widely adopted within the development community. It seems that a disjunction exists between the research into database design metrics and the actual use of databases in industry. This paper describes new metrics that can be used in industry to ensure that a database's current implementation supports long term scalability, to support easily developed and maintainable code, or to guide developers towards functions or design elements that can be modified to improve scalability of their data systems. In addition, this paper describes the production of a tool designed to extract these metrics from SQL Server and includes feedback from professionals regarding the usefulness of the tool and the measures contained within its output. / text

No description available.

No description available.

Den här rapporten hanterar ett uppdrag från företaget Logica gjort som ett examensarbete på utbildningen Högskoleingenjör inom Datateknik, programmet Webbutveckling/Programmering och datanät, på Tekniska Högskolan i Jönköping. Uppdraget gick ut på att kontrollera om ett system skrivet i programmeringsspråket PL/SQL går att konvertera till Java. Programmet i fråga var ett reskontrasystem. Syftet med projektet var att företaget skulle kunna konvertera deras system på ett så kostnadseffektivt och tidsbesparande sätt som möjligt. Frågor som rapporten har tagit upp är huruvida det finns konverteringsverktyg som kan göra detta och om i så fall det finns några “Best-practises” angående detta. Vi har undersökt detta genom informationssökning om olika verktyg samt om de båda språken. För att verifiera de olika verktygens funktionalitet har ett antal olika tester med konvertering utförts. De tester som har genomförts visar på att en konvertering mellan PL/SQL och Java kan fungera, men då under standardiserade former. Till denna kategori hörde dock inte Logicas applikation, som förlorade all sin funktionalitet under processen i ett av testen och genereringen av användbar kod var minimal. Vi kom fram till att i det här fallet var en konvertering ej möjlig att rättfärdiga i ett kostnadsperspektiv.

Stuttgart, Univ., Diplomarb., 2004.

The thesis analyses tools, which offers Oracle Database 11g R2 for tuning SQL statements. Tools are then used in reporting section of real banking system to optimize SQL statements. Then are created test cases and results are analyzed with categorization to prove successful optimization. In the end are evaluated benefits of the optimization and created advices for next progress in optimization.

Diploma thesis is focused on elaboration of database solution for saving measured data. In theory part analyses database query language and database management system Microsoft SQL Server 2017. Further in theory part is focused on programming environment for application development using C# .NET. Thesis includes database solution for saving measured data, service console application for saving data into the database and user application for creating new measuring, representation of data and user administration.