This report describes the purpose, design, development and analysis of SQLTips, an online instructional delivery framework and set of instructional modules relating to advanced features and performance tuning of Oracle's Structured Query Language (SQL). SQLTips was developed using Wiki, server-side software that allows users to edit web pages with almost any browser. The report includes a literature review of existing SQL instructional materials and a review of instructional theory. The report also includes a description of the formative evaluation process and results. These results show that SQLTips is easy and enjoyable to use. Based on a scale of 1 to 7 with 7 being the most positive, the 10 modules comprising SQLTips averaged a 6.1 for ease of use and a 6.2 for enjoyability. Posttest results also showed an average increase of 46% upon completion of the instruction. The report also contains a critique of the project.

No description available.

No description available.

Traditional test oracles have two problems. Firstly, several test oracles are needed for a single software program to perform different functions and maintaining a large number of test oracles is tedious and might be prone to errors. Secondly, testers usually test only the important criteria of a web application, since its time consuming to check with all the possible criteria. Ontologies have been used in a wide variety of domains and they have also been used in software testing. However, they have not been used for test oracle automation. The main idea of this thesis is to define a procedure for how ontology-based test oracle automation can be achieved for testing web applications and minimize the problems of traditional test oracles. The proposed procedure consists of the following steps: first, the expected results are stored in ontology A by running previous working version of the web application; second, the actual results are stored in ontology B by running the web application under test at runtime; and finally, the results of both ontology A and B are compared. This results in an automated test oracle comparator. Evaluation includes how the proposed procedure minimizes the traditional test oracle problems and by identifying the benefits of the defined procedure.

「甲骨塗辭」乃指在甲骨刻辭筆畫中塗以朱、墨，以往學者將之稱為「塗朱/墨」或「填朱/墨」，這類刻辭在刻寫完成之後，以朱砂或墨填入刻痕。其中，塗朱甲骨色彩鮮明奪目，很早就受到學者注意，其目的有美觀、宗教意涵、重要訊息的不同說法。然而，受限於甲骨著錄多為黑白拓本形式、早期彩色印刷不發達，目前甲骨學界尚無學者對塗辭做出專門且深入的研究。所幸，近年來出版之甲骨著錄附有彩色相片，部分甲骨收藏單位架設數位資料庫，如中研院史語所，所能蒐羅之資料備於完善，為甲骨塗辭研究奠定基礎。 本文以「塗朱甲骨」作為主要討論對象，試圖將辭例或形狀完整的塗朱卜辭進行分類。首先於第二章探討塗朱甲骨的年代以及塗朱甲骨的幾項特徵，包含：牛胛骨骨面塗朱卜辭、犯兆塗朱卜辭、塗朱記事刻辭。第三章及第四章則以塗朱甲骨的形態進行討論，分別以顏色及辭例的完整度作為分類標準。以顏色劃分塗朱甲骨可分為三類：僅見塗朱者、朱墨褐三色同版者、朱墨或朱褐同版者。以辭例完整度可分成八類。 / The incised characters on oracle bones rubbed with cinnabar or ink are called cinnabar inscriptions or ink inscription. The vermillion colored cinnabar used on the coloring of oracle bones is said to have religious messages or aesthetic purposes. Previously limited by the immature color printing and computer technology, oracle bones inscriptions were mostly rubbing editions in black and white, and thus there are few in-depth studies on the coloring of oracle bone inscriptions. But now a corpus of oracle bones is taking form, such as editions with color pictures and digitalization of oracle bones images by Institute of History and Philosophy, Academia Sinica. This paper aims to examine the cinnabar inscriptions on oracle bones, discuss their characteristics in different periods, and categorize them into three categories based on colors, and eight categories based on the intactness of the inscriptions.

由於背甲數量較為稀少，再加上背甲表面多盾紋、齒縫，不似腹甲、胛骨光滑平整，卜辭釋讀顯得較為困難，因此鮮少引起學者的注意，專以此議題為研究的文章遠比腹甲、卜骨稀少。背甲刻辭數量雖然較腹甲少，但若以拼綴完整的大片背甲來看，其字數及內容重要性並不亞於腹甲。經過筆者通盤整理後，發現王卜辭背甲數量並不少，總計約有六千二百餘版。本文在分組分類的基礎下，對這一批背甲進行相關研究。 本文分為七章，第一章介紹研究背景及目的、研究方法，以及目前學界研究殷墟背甲之概況。第二章至第六章，分別針對 組、賓組、出組、何組、黃類的背甲卜辭從事相關研究。研究內容包括：背甲卜辭的分類與整理、背甲文例的歸納，以及背甲事類討論。除此之外，本文也會根據各類組所呈現的不同的內容，逐一進行細步之分析。第七章則綜合前幾章的研究成果，並提出相關結論。 / Research in tortoise shell inscription hardly drew attention to the scholars owing to the interpretation difficulties of shield lines and seams on the surface and the amount of tortoise shell is few. Comparing with the smooth surface tortoise plastron and shoulder blade, few tortoise shell studies were carried out. However, as far as the importance is concerned, the content meaning and number of words in a fully joined together tortoise shell is equivalent to tortoise plastron. After sorting out in this study, a great amount, about 6,200 pieces, of royal oracle bone inscription was discovered. This research in tortoise shell is studied under the foundation of group classification. Seven chapters are concluded in this thesis. The research background and purpose, research method and the description of current academic research in Shang Dynasty will be introduced in chapter 1. The tortoise shell inscription of Shi groups, Bin groups, Chu groups, He groups and Huang groups are researched in subsequent chapter 2 to chapter 6. The content in this research includes the classification of tortoise shell inscription, the inductive inference of the grammar of turtle carapaces inscriptions and a discussion of tortoise shell category. Besides, a detailed analysis is carried out according to the different contents for each group. Finally, the conclusion of this study was made in chapter 7 base on the former research achievements.

Šiame darbe apžvelgiama esamų GIS sprendimų privalumai ir trūkumai, tiriamos skaitmeninių žemėlapių įmonių taikomosiose programose panaudojimo galimybės. Analizuojama Oracle DBVS programinė įranga, siekiant įrodyti, kad ji turi reikiamas funkcijas erdvinių duomenų valdymui. Apibendrinus analizės rezultatus, pasiūlomas naujas GIS sprandimas, kuris leidžia atvaizduoti įmonės aprašomuosius duomenis skaitmeniniame žemėlapyje dinamišku būdu, nežinant jų struktūros ir minimizuojant programavimo darbus. Dinamiškos GIS koncepcijai realizuoti suprojektuojama nauja dinamiškos GIS architektūra ir suprogramuojamas trūkstamas duomenų integravimo komponentas. Dinamiškam duomenų susiejimui užtikrinti, duomenų integravimo komponento veikimas pagrindžiamas veiklos taisyklių koncepcija. Dinamiškam erdvinių ir aprašomųjų duomenų susiejimui pademonstruoti, dinamiškos GIS architektūra realizuojama naudojant oracle programinę įrangą, duomenų integravimo komponentas sukonfigūruojamas mapViewer naudojimui. Dinamiškos GIS testavimui sukurta testavimo sąsaja, kuri leidžia tiesiai internetiniame puslapyje rašyti veiklos taisykles ir matyti rezutatus žemėlapyje. Į oracle duomenų bazę importuoti egzistuojsntys erdviniai duomenys ir testavimo tikslais dalis duomenų buvo sukurti rankiniu būdu. / This work reviews advantages and weaknesses of existing GIS solutions, explores usage of digital maps for rendering specific enterprise data in digital maps. Oracle DBMS software was also analyzed to prove that it has all necessary components for spatial data manipulation. After summarizing analysis results we offer new GIS solution, which allows rendering enterprise data on the map in dynamic way without knowing enterprise data structure and minimizing programmer work. To implement a dynamic GIS conception a new dynamic GIS architecture and the missing component design for representing business data in a map are created. To ensure dynamic integration and simple usage of component, dynamic integration component functionality is based on business rules conception. To demonstrate dynamic enterprise and spatial data integration on the map, dynamic GIS architecture was implemented using Oracle software by configuring data integration component to use Oracle mapViewer. For dynamic GIS testing, test interface was created with an ability to write business rules directly in web page and see the integration results. Existing spatial data was imported into Oracle DB and some spatial data for testing purposes was created manually.

La sécurité routière est une priorité mondiale, européenne et française. Parce que les véhicules légers (ou simplement “les véhicules”) sont évidemment l’un des acteurs principaux de l’activité routière, l'amélioration de la sécurité routière passe nécessairement par l’analyse de leurs caractéristiques accidentologiques. Si les nouveaux véhicules sont développés en bureau d’étude et validés en laboratoire, c’est la réalité accidentologique qui permet de vraiment cerner comment ils se comportent en matière de sécurité secondaire, c’est-à-dire quelle sécurité ils offrent à leurs occupants lors d’un accident. C’est pourquoi les constructeurs souhaitent procéder au classement des générations de véhicules en fonction de leurs niveaux de sécurité secondaire réelle. Nous abordons cette thématique en exploitant les données nationales d’accidents corporels de la route appelées BAAC (Bulletin d’Analyse d’Accident Corporel de la Circulation). En complément de celles-ci, les données de parc automobile permettent d’associer une classe générationelle (CG) à chaque véhicule. Nous élaborons deux méthodes de classement de CGs en termes de sécurité secondaire. La première produit des classements contextuels, c’est-à-dire des classements de CGs plongées dans des contextes d’accident. La seconde produit des classements globaux, c’est-`a-dire des classements de CGs déterminés par rapport à une distribution de contextes d’accident. Pour le classement contextuel, nous procédons par “scoring” : nous cherchons une fonction de score qui associe un nombre réel à toute combinaison de CG et de contexte d’accident ; plus ce nombre est petit, plus la CG est sûre dans le contexte d’accident donné. La fonction de score optimale est estimée par “ensemble learning”, sous la forme d’une combinaison convexe optimale de fonctions de score produites par une librairie d’algorithmes de classement par scoring. Une inégalité oracle illustre les performances du méta-algorithme ainsi obtenu. Le classement global est également basé sur le principe de “scoring” : nous cherchons une fonction de score qui associe à toute CG un nombre réel ; plus ce nombre est petit, plus la CG est jugée sûre globalement. Des arguments causaux permettent d’adapter le méta-algorithme évoqué ci-dessus en s’affranchissant du contexte d’accident. Les résultats des deux méthodes de classement sont conformes aux attentes des experts. / Road safety is a world, European and French priority. Because light vehicles (or simply“vehicles”) are obviously one of the main actors of road activity, the improvement of roadsafety necessarily requires analyzing their characteristics in terms of traffic road accident(or simply “accident”). If the new vehicles are developed in engineering department and validated in laboratory, it is the reality of real-life accidents that ultimately characterizesthem in terms of secondary safety, ie, that demonstrates which level of security they offer to their occupants in case of an accident. This is why car makers want to rank generations of vehicles according to their real-life levels of safety. We address this problem by exploiting a French data set of accidents called BAAC (Bulletin d’Analyse d’Accident Corporel de la Circulation). In addition, fleet data are used to associate a generational class (GC) to each vehicle. We elaborate two methods of ranking of GCs in terms of secondary safety. The first one yields contextual rankings, ie, rankings of GCs in specified contexts of accident. The second one yields global rankings, ie, rankings of GCs determined relative to a distribution of contexts of accident. For the contextual ranking, we proceed by “scoring”: we look for a score function that associates a real number to any combination of GC and a context of accident; the smaller is this number, the safer is the GC in the given context. The optimal score function is estimated by “ensemble learning”, under the form of an optimal convex combination of scoring functions produced by a library of ranking algorithms by scoring. An oracle inequality illustrates the performance of the obtained meta-algorithm. The global ranking is also based on “scoring”: we look for a scoring function that associates any GC with a real number; the smaller is this number, the safer is the GC. Causal arguments are used to adapt the above meta-algorithm by averaging out the context. The results of the two ranking procedures are in line with the experts’ expectations.

This master's thesis is devoted to the studies of possibilities, which can be used for representation of moving objects data and for querying such spatio-temporal data. It also shows results of the master's thesis created by Ing. Jaroslav Vališ, that should be used for the solution of this master's thesis. But based on the theoretical grounds defined at the beginning of this work was designed and implemented new database extension for saving and querying spatio-temporal data. Special usage of this extension is demonstrated in an example application. This application uses the database extension for the implementation of its own database functions that are domain specific. At the conclusion, there are presented ways of the farther development of this database extension and the results of this master's thesis are there set into the context of the following project, doctoral thesis "Moving objects database".

A comprehensive methodology of hydraulic testing in fractured rocks is presented. The methodology utilizes geological and geophysical information as background. It consists of conventional single-hole packer tests in conjection with a newly developed cross-hole packer test. The cross-hole method involves injecting fluid into a packed-off interval in one borehole and monitoring hydraulic head variations in packed-off intervals in neighboring boreholes. Borehole orientation is unrelated to the principal hydraulic conductivity directions which, therefore, need not be known a priori. The method yields complete information about the directional nature of hydraulic conductivity in three dimensions on a scale comparable to the distance between the test boreholes. In addition to providing all six components of the hydraulic conductivity tensor, the cross-hole method also yields the specific storage of the fractured rock mass. While the theory behind this method treats the rock as a homogeneous, anisotropic, porous medium, the test provides detailed information about the degree to which such assumptions may actually be vaild in the field. The method may also be useful as a tool for detecting, in the vicinity of the test area, major fractures or faults that have not been intercepted by boreholes. Preliminary results from a granitic site near Oracle in southern Arizona are presented together with details of the instrumentation designed and constructed specifically for that site.