Logo des Repositoriums

Auflistung nach Schlagwort "RDBMS"

1 - 2 von 2
  • Textdokument
    Fast Approximated Nearest Neighbor Joins For Relational Database Systems
    (BTW 2019, 2019) Günther, Michael; Thiele, Maik; Lehner, Wolfgang
    K nearest neighbor search (kNN-Search) is a universal data processing technique and a fundamental operation for word embeddings trained by word2vec or related approaches. The benefits of operations on dense vectors like word embeddings for analytical functionalities of RDBMSs motivate an integration of kNN-Joins. However, kNN-Search, as well as kNN-Joins, have barely been integrated into relational database systems so far. In this paper, we develop an index structure for approximated kNN-Joins working well on high-dimensional data and provide an integration into PostgreSQL. The novel index structure is efficient for different cardinalities of the involved join partners. An evaluation of the system based on applications on word embeddings shows the benefits of such an integrated kNN-Join operation and the performance of the proposed approach.
  • Zeitschriftenartikel
    Werkzeuge zur Performanceanalyse von Datenbankanwendungen am Beispiel von ADABAS D
    (Informatik-Spektrum: Vol. 20, No. 4, 1997) Hartmann, Jochen; Will, Liane
      Performancesteigerung ist beim Einsatz von RDBMS ein Kernthema. Während häufig noch detailliertes Know How der RDBMS-Architektur und Erfahrung dafür erforderlich sind, werden von einzelnen Datenbankherstellern Instrumente angeboten, die dem Administrator die notwendigen Analysen weitestgehend abnehmen. Dies wird am Beispiel von Adabas D und den Werkzeugen x_wizard und Diagnose Monitor gezeigt.Summary  Performance enhancement is an essential point for the usage of an RDBMS. Frequently, this requires a detailed knowledge of the architecture of the RDBMS and experience. Some database suppliers provide instruments that free the database adminitrators from the necessary analyses to a great extent. This will be illustrated by the example of ADABAS D and its tools x_wizard and Diagnose Monitor.