What we're about

AIOUG is a non profit organization started by like minded users who think such a community is required in India where the amount of Oracle user base is humongous. The idea of this group is to share what the Oracle users have learned from using Oracle technology over the years with fellow users who have similar interest. - See more at: http://www.aioug.org/

AIOUG Chennai Chapter is the local chapter of AIOUG.

Website : http://www.aioug.org/

Facebook Page : https://www.facebook.com/AIOUG.Chennai.Chap...

Upcoming events (3)

Using MongoDB or MySQL in a microservice architecture? We use both!

Needs a location

Session Abstract: When building a cloud-native SaaS solution, you can pick whatever technology you like, with no legacy constraints your choice. For Parta, we selected both MongoDB and MySQL in our technology stack. The session will discuss the Parta architecture and show the microservices and database setup. Then you will learn what criteria we used to select a database. Next, the two technologies are compared from a development and administration perspective. Last but not least, we will dive into some potential enhancements from an architectural perspective.

Speakers:Lonneke Dikmans
Founder, Vennster

Lonneke Dikmans is a founder at Vennster. She has been working as a developer and architect with Oracle tools since 2000 and has hands-on experience with Oracle Fusion Middleware and Oracle PaaS products like Oracle Blockchain Cloud Service, Oracle Kubernetes Engine, Oracle Cloud Infrastructure, and Mobile Cloud Service, API Platform Cloud Service. Lonneke started her career as a Java Developer and has since moved to Javascript (Node.js Oracle JET, Ionic React) Lonneke is a Groundbreaker Ambassador and Oracle Ace Director in Oracle Fusion Middleware. She publishes frequently online and shares her knowledge at conferences and other community events.

Registration Link:https://bit.ly/3LoWABO

If you are AIOUG Member – Click Register Button
If you are a Non-AIOUG Member – Please sign up for “Starter (FREE) Membership* and Register

Thanks,
Team AIOUG.

Function calls in SQL - Black Box for the Optimizer?

Needs a location

Session Abstract: Functions in SQL are a useful and popular feature that is often used. However, little attention is often paid to performance aspects. A function call or an expression in a WHERE condition is a challenge for the query optimizer that often leads to unsuitable execution plans and bad response times. For PL/SQL functions called from SQL, the situation is even more complex. If used incorrectly, they can lead to massive performance degradation.
In this presentation, I will show different possibilities to support the optimizer in function calls to generate better execution plans. Furthermore, I will explain how PL/SQL functions can be used optimally in SQL queries and which performance killers must be avoided. Of course, all this will be demonstrated with live examples and stories from the field.

Speakers:Dani Schnider
Senior Principal Consultant, Trivadis AG

Dani Schnider works as Senior Principal Consultant for Trivadis, a Swiss IT consulting company. He finished his studies in computer science at ETH Zurich in 1990. Since 1994, he is developing data models and applications with Oracle databases, since 1997 mainly in data warehousing projects.
Most of his time he is doing jobs for customers in the design, data modeling, ETL development, architecture reviews, and performance optimization of Oracle data warehouses. He is a teacher for several Oracle training at Trivadis and co-author of the (German) books «Data Warehousing mit Oracle - Business Intelligence in der Praxis» and «Data Warehouse Blueprints»
Dani is Oracle ACE Director and writes about Data Warehousing with Oracle on his blog https://danischnider.wordpress.com.

Registration Link: https://bit.ly/3P7HhjV

If you are AIOUG Member – Click Register Button
If you are a Non-AIOUG Member – Please sign up for “Starter (FREE) Membership* and Register

Thanks,
Team AIOUG.

Trust,but verify approach to securing access to Oracle Database

Needs a location

Session Abstract: Trust-but-verify is a key security control for many compliance regulations. In this session, you will learn how you can use Unified Auditing in Oracle Database to implement this approach in a smart and practical way while minimizing performance and storage impact on the database. Try hands-on configuring simple unified audit policies with LiveLabs workshop practice in this session. Join this session and become subject matter experts for implementing this key security control in your organizations.

Speakers:Angeline Janet Dhanarani
Principal Product Manager - Core Database Auditing, Oracle Audit Vault and Database Firewall (AVDF), Oracle

Angeline is the Senior Principal Product Manager for Oracle Database (Security), responsible for outbound product management in APAC and India. Angeline also manages inbound product management of core Oracle RDBMS auditing features and the database activity monitoring (DAM) solutions on Oracle Data Safe cloud service, working closely with the engineering team to define the product strategy and roadmap. With 18+ years of experience, she has been involved in many customer engagement activities for over a decade at Oracle and helped customers adopt Oracle Database security solutions to meet their corporate security and regulatory requirements.

Registration Link: https://bit.ly/38xK3ON

If you are AIOUG Member – Click Register Button
If you are a Non-AIOUG Member – Please sign up for “Starter (FREE) Membership* and Register

Thanks,
Team AIOUG.

Past events (190)

Live SQL Coding Challenge

Needs a location

Photos (299)

Find us also at