Wyniki wyszukiwania - BazTech

1

Database optimization for improvement of existing systems

Wosiak A., Koper R.

Journal of Applied Computer Science

|

2015

|

Vol. 23, nr 2

101--118

EN

Due to the increasing volume of data, which is the result of market globalization and the computer development of the largest commercial enterprises, performance problems at the database level in existing systems become common and are a top priority. In this research database optimization methods were presented, taking into account the constraints deriving from the existing system architecture. Both technical and business constraints were considered. The increase in efficiency in each case was assessed by the time required to perform a particular database operation. The numbers of disk reads and buffer gets, as the technical factors of efficiency growth, were determined when possible.

2

Tools and methods for optimization of databases in Oracle 10g. Part 3, Theory in practice

Barczak A., Zacharczuk D., Pluta D.

Studia Informatica : systems and information technology

|

2014

|

Vol. 1-2(18)

24--36

EN

The article base on knowledge from earlier two parts. It shows how to effectively use the knowledge about database optimization methods, and how to verify and confirm the validity of the decisions in the process.

3

Tools and methods for optimization of databases in Oracle 10g. Part 2, Tuning of hardware, applications and SQL queries

Barczak A., Zacharczuk D., Pluta D.

Studia Informatica : systems and information technology

|

2014

|

Vol. 1-2(18)

5--21

EN

Article provides information on effective optimizing of Oracle. Discussed aspects are: hardware and statistics tools on which one can build the optimal SQL code.

4

The influence of indexing methods on effective functioning of the database

Barczak A., Zacharczuk D., Korzeniecka A.

Studia Informatica : systems and information technology

|

2013

|

Vol. 1-2(17)

5--18

EN

The article describes the different types of indexes. Their characteristic determines whether and when they can be used to improve database performance. Then studies are performed using different indices for different situations. The conclusions of the study can be serve as a guide to correct use of indexes.

5

Some remarks on optimization impact on database security

Miodek K., Podlaski K., Sobieski Ś., Zieliński B.

Studia Informatica

|

2011

|

Vol. 32, nr 2B

249-258

EN

One of the most important factors of real live business applications are speed and reliability. The question that arises during development states: what is more important: efficiency of servers or security of database/application. One of the biggest databases used in the University of Łódź for its applications must have restricted access to data. On the other hand, although it is used by many people concurrently cannot be overloaded. Security rules are based on views created for every user, which gives scalability and flexibility. Unfortunately this approach has security vulnerabilities which is presented in this article.

PL

W zastosowaniach biznesowych bardzo często, jako najważniejsze wskaźniki jakości rozwiązania, wskazuje się szybkość działania oraz niezawodność. W trakcie tworzenia takich rozwiązań pojawia się dylemat: wydajność serwera czy też jego bezpieczeństwo? Przed podobnym dylematem stanęli twórcy jednej z największych baz danych użytkowanych na Uniwersytecie Łódzkim, gdyż aplikacje ją używające musiały posiadać bardzo ograniczony dostęp do danych, a ponieważ aplikacje te używane są przez wiele osób, to istnieje problem przeciążenia bazy danych. Reguły bezpieczeństwa zostały oparte na widokach tworzonych dla każdego użytkownika, co daje dużą skalowalność i elastyczność rozwiązania. Niestety, takie rozwiązanie posiada pewne niedostatki związane z bezpieczeństwem, które zostały omówione w niniejszej publikacji.