Browse Prior Art Database

Methods and Apparatus for High-Performance Access to Database Data

IP.com Disclosure Number: IPCOM000201082D
Original Publication Date: 2010-Nov-08
Included in the Prior Art Database: 2010-Nov-08
Document File: 4 page(s) / 148K

Publishing Venue

Siemens

Related People

Juergen Carstens: CONTACT

Abstract

Accessing databases with large amount of stored data via SQL (Structured Query Language) commands or other techniques often comes along with the disadvantage that defragmented database tables lead to major performance drawbacks. In addition, database indexes, which show "aging" effects due to lots of operations (insertions, deletions of records) within database tables, lead to major performance drawbacks. Furthermore, database jobs, which perform internal processing, like aggregating or compressing historical data, slow down the execution of requests to the database. Experience showed that at least one of these effects leads to major performance drawbacks and cause even simple requests to take a long time.

This text was extracted from a PDF file.
This is the abbreviated version, containing approximately 44% of the total text.

Page 01 of 4

(This page contains 01 pictures or other non-text object)

(This page contains 00 pictures or other non-text object)

Methods and Apparatus for High-Performance Access to Database Data

Idea: Bernd Steiner, DE-Nuremberg

Accessing databases with large amount of stored data via SQL (Structured Query L commands or other techniques often comes along with the disadvantage that defragm tables lead to major performance drawbacks. In addition, database indexes, wh effects due to lots of operations (insertions, deletions of records) within database performance drawbacks. Furthermore
aggregating or compressing historical data, slow down the execution of requests to Experience showed that at least one of these effects leads to major perfor
cause even simple requests to take a long time.

Existing attempts to solve these problems in order to improve performance are
specific tuning and optimization mechanisms like table indexes, partitioning, etc., improving performance of the PL/SQL procedures, which perform internal aggregation and com
raw values, and disabling of all unneeded database jobs, which run in the backgrou
slow down the database. However, all of these attempts did not boost performance requests to the database became significantly faster. An example from the current version of t "Historical Archive System" of a power system control can be taken into account as

A novel method for high-performance access to database data is proposed. In orde solution, some background information is provided. Producers like field devices, whi measurement values or other producers, send their values to processes, which t
data to a database for storage. Consumers, w
statements or call PL/SQL (Procedural Language/Structured Query Language) proce database in order to obtain the requested data. Experience showed that especially
data is usually requested. For example, in the area of Control Center software
data is stored in databases, consumers usually like to view trend curves of measur
current day and the last days. Further, they like to create reports of the current and the last Data older than one or two month is seldomly requested.

The novel solution is based on the idea to perform a caching of the incoming data in files) in parallel to the transfer of the incoming data into the database (see Figure 2
data is on one hand written to files, and on the other hand, written to the database structure of the files needs is well designed and optimized for high-performance ac contained data. It is well-known that file access is much faster than database access. Thi is used in this solution.

It is configurable how long the cached
deleted ("Retention Period"). Once the Retention Period is elapsed, the files are d be only accessed via querying the database, w
layer (Data Access API (Application Programming Interface)), which allows applica data, accesses the data in the following way: If the data to be requested is youn Retention Period", the data will be retrieved with high perf...