Database

Predavanja so razvrščena po abecednem vrstnem redu naslova predavanj.

Področja, na katerih delujejo Oracle DBA-ji, postajajo iz leta v leto bolj obsežna. Zaradi tega je včasih težko slediti vsem novostim, kar pa je nujno, če želimo ostati v koraku s časom.

Na predavanjih domačih in tujih predavateljev se bomo dotaknili tako klasičnih kot modernih Oracle DBA tematik, pogledali bomo tudi na področje PostgreSQL in MySQL podatkovnih baz. Oracle DBA tematike bodo še vedno dobro zastopane - slišali bomo nasvete glede analize AWR poročil, uporabe optimizer hintov, priporočila glede upravljanja z baznimi statistikami, pogledali, kaj nam ponuja področje strojnega učenja, slišali novosti na področju Cloud-a in dobili nasvete glede migracij podatkovnih baz v Cloud. Zanimivo bo tudi za udeležence, ki morda še ne poznate možnosti, ki jih ponuja CMAN, na dvournem predavanju pa bomo dobili lep pregled brezplačnih orodij, s katerimi si lahko pomagamo pri vsakodnevnih DBA opravilih. Slišali bomo tudi o zadnjih novostih iz Oracle Open World-a.

Poleg vsega naštetega, bomo v sklopu konference gostili predavanja Oracle Groundbrakers EMEA Tour 2019, kjer bomo med drugim obravnavali danes zelo aktualno temo preobrazbe kariere DBA-ja v podatkovnega inženirja, dotaknili se bomo tudi online nadgradnje aplikacij z uporabo Edition-Based Redefinition (EBR).

Nabor predavanj z DBA tematikami je tako zelo raznovrsten in vsekakor zanimiv in uporaben za vsakega DBA-ja!

Luke Davies

AWR monitoring and mining


Luke Davies
The Pythian Group

The Automatic Workload Repository (AWR) is often only used to when you have been notified that there is or has been a problem.

Read more...
Jan Karremans

Cloud demystified, what remains after the fog has lifted.


Jan Karremans
EnterpriseDB

So, you've been ordered to land the airplane in thick fog, zero visibility and you're praying the ILS has got it right. That's how most IT managers feel after their CIO/CEO told them to 'put everything in the cloud, it's cheaper’.

Read more...
Jan Karremans

Comparing PostgreSQL to Oracle - The best kept secrets to success


Jan Karremans
EnterpriseDB

There is a lot of disruption going on at the present time. These changes range from ""the adoption to big data"", through “migration to the cloud” and focus shifts within businesses.

Read more...
Neil Chandler

Database Stats. Doing It Right, The Easy Way


Neil Chandler
Chandler Systems

Oracle Statistics are critical to the optimizer and your system performance, whether on-premises, in the Cloud or Autonomous.

Read more...
Kamran Aghayev

From DBA to Data Engineer - How to survive a career transition?


Kamran Aghayev
AzerCell Telecom

As the companies move into more complex systems of data management, the role of data engineer becomes extremely important. Working with big data sets requires a much higher technical bar than just managing relational databases.

Read more...
Jakob Holešek

Hints - Zakaj, Kje, Kdaj, Kaj, Kako in Kdo


Jakob Holešek
UBS Business Solutions AG, London Branch

Hints - kratka navodila o tem, kako naj se poizvedba izvaja - so na voljo za uporabo in zlorabo že kar nekaj časa. Dovoljujejo nam predpisati način izvedbe poizvedbe - ker verjamemo, da je boljši, kot jo predlaga naš predragi optimizer.

Read more...
Marcin Przepiorowski

How to make your daily routine, code and database more efficient


Marcin Przepiorowski
Delphix

Our daily life bringing us a lot of challenges in both personal and professional aspects. Fast-changing technology and more pressure from business bring a lot of pressure to IT which have to deliver a project on time. It will is only possible if IT shops start using automation in every phase of work.

Read more...
Sergej Rožman

Izgubite podatke, ne da bi to kadarkoli opazili


Sergej Rožman
ABAKUS plus d.o.o.

Ste že kdaj izgubili podatke?

Pred časom smo prikazali nekaj scenarijev, kako lahko izgubimo podatke, tudi če vse naredimo prav in celo po priporočilih. Vas zanima, kako je s tem v novejših verzijah Oracla - 12, 18, 19?

Read more...
Ludovico Caldara

Long live to CMAN! Or Oracle still cares about CMAN: you should do it too!


Ludovico Caldara
CERN

The Oracle Connection Manager (CMAN) is the Swiss-army knife for database connections. It can be used for security, routing, high availability, single-point of contact...

Read more...
Robert Korošec

Novosti iz OOW 2019 s področja Oracle Database, Autonomous Database ter BigData


Robert Korošec
Oracle Software d.o.o.

Na Oracle konferenci Open World 2019, September 2019, bodo predstavljene novosti, ki ji bodo vsebovale prihajajoče verzije Oracle baze (Oracle 20c) in Autonomous Database za podatkovna skladišča (ADWH) in Transakcijsko procesiranje (ATP).

Read more...
Matheus Boesing

Oracle Database Migration and Consolidation Techniques


Matheus Boesing
The Pythian Group

Migrating and Consolidating databases or servers is a regular task for DBAs all over the world, caused mostly by hardware upgrades, RAC revision, application decommissioning and other strategic decisions.

Read more...
Urh Srečnik

Oracle Grid Infrastructure: Concepts and Fancy Features


Urh Srečnik
Abakus Plus d.o.o.

I’ll start off by explaining the core concepts of Grid Infrastructure and its relation to Oracle RAC. Afterward, we’ll dive into a few specific features/characteristics, possibly accompanied by a quick live showcase. Hopefully, by the end of this presentation, you’ll agree that GI is not overly complicated and that it carries a lot of functionality that you can make use of - even if you use it to manage only Oracle Standard Edition databases.

Read more...
Patrick Jolliffe

Plug It In! MySQL Authentication with Windows via PAM


Patrick Jolliffe
Li & Fung Trading Ltd

We love open source but in our work, we also have to get open source products to work nicely in with Microsoft Windows.

Read more...
Matej Železnik

Postgres HA with Patroni+etcd vs. Citus


Matej Železnik
Parsek d.o.o.

V modernih rešitvah "single points of failure" ne pridejo v poštev, zato je potrebno na vseh nivojih rešitve poskrbeti za redundanco. Če je to pri aplikacijskih strežnikih mogoče nekoliko bolj preprosto, pa se na nivoju podatkovne baze ponavadi pojavijo težave.

Read more...
Nelson Calero

Using SSL in the Oracle Database without surprises


Nelson Calero
The Pythian Group

Nowadays databases require to use secure connections to communicate with clients, from application users through listener services, internal features (Apex, OEM), to consuming external services from the database (eg.: sending emails from PL/SQL).

Read more...

Vsebina iskanje