Podcasts about dml

DML explains the true meaning of Memorial Day.

Topics for today's podcast will include: Trump visits the Middle East Trump's trade deals with China The Qatari airplane gifted to Trump to replace Air Force One And an important announcement from DML

In this episode, Lois Houston and Nikita Abraham, along with Nick Wagner, focus on GoldenGate's terminology and architectural evolution.   Nick defines source and target systems, which are crucial for data replication, and then moves on to explain the data extraction and replication processes.   He also talks about the new microservices architecture, which replaces the classic architecture, offering benefits like simplified management, enhanced security, and a user-friendly interface. Nick highlights how this architecture facilitates easy upgrades and provides a streamlined experience for administrators.   Oracle GoldenGate 23ai: Fundamentals: https://mylearn.oracle.com/ou/course/oracle-goldengate-23ai-fundamentals/145884/237273 Oracle University Learning Community: https://education.oracle.com/ou-community LinkedIn: https://www.linkedin.com/showcase/oracle-university/ X: https://x.com/Oracle_Edu   Special thanks to Arijit Ghosh, David Wright, Kris-Ann Nansen, Radhika Banka, and the OU Studio Team for helping us create this episode.   ---------------------------------------------------------------   Episode Transcript:   00:00 Welcome to the Oracle University Podcast, the first stop on your cloud journey. During this series of informative podcasts, we'll bring you foundational training on the most popular Oracle technologies. Let's get started! 00:25 Nikita: Welcome to the Oracle University Podcast! I'm Nikita Abraham, Team Lead of Editorial Services with Oracle University, and with me is Lois Houston: Director of Innovation Programs. Lois: Hi there! Thanks for joining us again as we make our way through Oracle GoldenGate 23ai. Last week, we discussed all the new features introduced in 23ai and today, we'll move on to the terminology, the different processes and what they do, and the architecture of the product at a high level. 00:56 Nikita: Back with us is Nick Wagner, Senior Director of Product Management for Oracle GoldenGate. Hi Nick! Let's get into some of the terminology. What do we actually call stuff in GoldenGate? Nick: Within GoldenGate, we have our source systems and our target systems. The source is where we're going to be capturing data from, the targets, where we're going to be applying data into. And when we start talking about things like active-active or setting up GoldenGate for high availability, where your source can also be your target, it does become a little bit more complex. And so in some of those cases, we might refer to things as East and West, or America and Europe, or different versions of that. We also have a couple of different things within the product itself. We have what we call our Extract and our Replicat. The Extract is going to be the process that pulls the data out of the database, our capture technology. Our Replicat's going to be the one that applies the data into the target system, or you can also look at it as a push technology. We have what we call our Distribution Path. Our Distribution Path is going to be how we're sending the data across the network. A lot of times when customers run GoldenGate, they don't have the luxury of just having a single server of GoldenGate that can pull data from one database and push data into another one. They need to set up multiple hops of that data. And so in that case, we would use what we call a Distribution Path to send that data from one system to the next. We also have what we call a Target Initiated Path. It's kind of a subset of your Distribution Path, but it allows you to communicate from a less secure environment into a more secure environment.  02:33 Lois: Nick, what about parameter names. I've seen them in uppercase…title case…does that matter?  Nick: GoldenGate has a lot of parameters. This is something you'll see all over the place within GoldenGate itself.  These parameters are in your Extract and Replicat parameter files during your distribution path parameter files. Parameters for GoldenGate are case insensitive.  Within your own environments, you can set it up to have lowercase, mixed case, whatever you want, but just be aware that they are case insensitive. GoldenGate doesn't care, it's just for readability. And then we also have something called trail files. Trail files is where GoldenGate stores all the data before we're able to apply it into that target system. Think about it as our queuing mechanism, and we're queuing everything outside the database so that we're not overloading those database environments. And that's some of the terminology for the product itself. We also have microservices within GoldenGate. 03:31 Nikita: And at the heart of everything is the Service Manager, right? Talk to us about what it is and what it does. Nick: The service manager is responsible for making sure that everything else is up and running. If you are familiar with GoldenGate classic architecture, this is kind of similar to a GoldenGate manager where that process was there to make sure that processes were running the trail files, or excuse me, that certain error logs were getting written out. If a process went down, the manager would restart that process. The service manager is performing a lot of those same functions. Now attached to the service manager, we have our configuration service. This is new in GoldenGate 23ai. This configuration service is going to allow you to set up GoldenGate for highly available environments. So you can build HA into GoldenGate itself using the configuration service. 04:22 Lois: And what does this configuration service do? Nick: This configuration service essentially moves the checkpoint files that used to be on disk into a database so that everything can be stored inside of a database.  Also attached to the service manager, we have the performance metric service. This is a service that is going to be gathering all the performance metrics of GoldenGate. So it's going to tell you how fast things are going, what the latencies are, how many bytes per second we're reading from, the transaction logs or writing to our trail files. How quickly a distribution path is sending data across a network. If you want to know any of your lag information, you'll get it from the performance metrics server. We also have the receiver service and the distribution service. These two work hand in hand to establish network communication between two GoldenGate environments. So on what we call our source system, we have a distribution service that's going to send the data to our target system. On the target system, a receiver service is going to receive that data and then rewrite the trail files. We also have the administration service that's responsible for authentication and authorization of the users, as well as making sure that people have access to the right information. 05:33 Nikita: Ok. Moving on the deployment, how is GoldenGate actually deployed, Nick? Nick: GoldenGate is kinda nice. So the way that the product is installed is you install the GoldenGate environment and that's what we call our service manager deployment under a specific GoldenGate home. So the software binaries themselves get installed under a home, we'll say U01/OGG23AI. Now once I've installed GoldenGate once, that's my OGG home. I can now have any number of service managers and deployments tied to that same home.  06:11 Lois: Ok, let's work with an example to make this simpler. Let's say I've got a service manager that's going be responsible for three different deployments: Accounting, Finance, and Sales. Nick: Each of these deployments is going to reside in its own directory. Each of these deployments is going to have its own set of microservices. And so this also means that each of these deployments can have their own set of users. So the people that access the GoldenGate accounting deployment can be different than the ones that access the sales deployment. This means with this distribution of roles that I can have somebody come in and administer the sales database, but they wouldn't have any information or any access to accounting or finance. And this is very important, it allows you to really pull that information apart and separate it. Each of these environments also has their own set of parameter files, Extract process, Replicat process, distribution services, and everything. So it's a very nice way of splitting things up, but all having them tied to the same GoldenGate home system. And this home is very important. So I can take a deployment, let's say my finance deployment, and if I want to move it to a new GoldenGate home and that GoldenGate home is a different version, like let's say that my original home is 23.4, my new GoldenGate home is 23.7, I simply stop that GoldenGate deployment. I stopped at a finance deployment. I changed its OGG home from 23.4 to 23.7. I restart the deployment, that deployment is automatically upgraded to the new environment and attached to the new system. So it makes upgrading very, very simple, very easy, very elegant. 07:53 Nikita: Ok. So, we've spoken about the services…some of the terminology. Let's get into the architecture next. Nick: So when we talk about the architecture for GoldenGate, we used to have two different architectures. We had a classic architecture and a microservices architecture. Classic architecture was something that's been around since the very beginning of GoldenGate in the late '90s. We announced that, that architecture was deprecated in 19c. And Oracle deprecated means that feature is no longer going to be enhanced and it'll be patched selectively. And at some point in the future, it'll be entirely desupported. Well, GoldenGate 23ai is that future. And so in 23ai, the classic architecture is desupported, that means that it's no longer in the build at all. And so it's just microservices architecture. 08:41 Lois: Is there a tool to assist with this migration?  Nick: We do have a migration utility that will convert an old classic architecture into the new microservices architecture. But there is quite a bit of learning curve to the new microservices architecture. So it's important that we go through how it works in the changes. 09:04 Are you looking to optimize your implementation strategies and improve efficiency? We have a solution for you! Our new Oracle Fusion Cloud Applications Foundations training and certification program. You'll learn to leverage Oracle Modern Best Practice (OMBP) to re-imagine business processes using advanced technologies in Oracle Fusion Cloud Applications such as AI, mobile, analytics, and more. Visit mylearn.oracle.com to get started today.  09:37 Nikita: Welcome back! Nick, what are the benefits of this microservices architecture?  Nick: It's got that simplified lifecycle for patching and upgrading. A lot of the GoldenGate patches that you get, especially these bundle patches, are complete installs as well. So you can go into My Oracle Support and download a complete install of a patch and that way, you don't have to use old patch to apply them. The only time you'll be using old patch is for one-off patches or smaller patches that need to be applied to your GoldenGate system. The microservices product has the same trusted Capture and Apply process that Classic did. There's almost no changes between the two except on how they communicate with their parent processes. And so the same logic that you use to pull data from Oracle or to apply data into Oracle is all the same. 10:25 Lois: And has the interface been upgraded as well? Nick: We've added a really nice, easy to use web interface for the microservices version of GoldenGate. Not only is this web interface work with all your standard browsers, but it's also mobile friendly too. So I can actually control and administer GoldenGate right through my mobile device. It also has new secure remote administration. This is something that the classic architecture was really missing. And so in the classic architecture, to use the command line interface, you had to log into the database server where GoldenGate was installed. Now, the command line interface, as well as the web interface and the REST API, all use remote administration and authentication. So that means that I can install the new command line interface or what we call admin client on my laptop locally and I can connect to any GoldenGate deployment as long as I have the username and password for that deployment. It's also more secure. GoldenGate microservices can also be deployed on premise or in OCI as a service and now also on these third-party clouds like Azure and Google Cloud. And it's also easier for developers to integrate in with the APIs themselves. Everything that GoldenGate does through the admin client as well as the web UI can all be traced. The REST API calls for GoldenGate are all fully published so you can get them right directly from the documentation, you can build your own web interface if you want to. So it makes it very easy. The REST APIs are also streamlined. With a single REST API call, I can do something like add an Extract process, create it, set up my parameter file, and set up the trail files all with a single API command. Whereas in the past, it would require multiple command line interface commands to do that same thing. So it's extremely elegant, very advanced. 12:16 Nikita: What does the microservices architecture look like? I know it's a bit complicated when we're not actually looking at a diagram of it, but just a high level, can you explain the different parts of it? Nick: It's pretty straightforward. But essentially what you've got on each system is a service manager. That service manager is then going to have a number of processes or services beneath it. It'll have the configuration service that stores the checkpoint information for GoldenGate. It'll have the administrative service for the authentication and users, the distribution service to send the data across a network, a receiver service to receive that information, performance metrics to get the performance statistics out of GoldenGate. And then of course, you also have your Extracts and Replicats that capture and apply technology. Each of those Extracts and Replicats will then connect to a database on the Extract side of things. That Extract is going to write to trail files. Those trail files are then going to be sent across the network where they're rebuilt on the target system and the Replicat's going to consume them and apply them into the target database. So the Replicat behaves almost like an end user. So it's taking that trail file data and simply converting it to DML operations, insert, update, delete, or a DDL operation in the case of Oracle, alter table, create table, et cetera, to go into that target database.   13:39 Lois: To look at a diagram of this architecture and learn about it in more detail, check out the Oracle GoldenGate 23ai Fundamentals course on mylearn.oracle.com. So, Nick, if I'm looking to deploy GoldenGate, what should I primarily keep in mind? Nick: So as you go to install GoldenGate and you look at a deployment, there's a couple of important environment variables that you want to make sure you're aware of. So one of the first ones is your OGG_Home. This environment variable is extremely important. This is the location of the GoldenGate software itself. And I want to stress how important it is to always use version numbers when you're setting up your GoldenGate home. When you go to install the software, if you're installing GoldenGate 23.5, use 23.5 within the home directory structure. If you're installing GoldenGate 23.7, use 23.7 inside that directory structure. 14:33 Nikita: Right… that way I'll always know which versions are which, and it'll make it really easy to upgrade and move from one version to the next. Ok, got it. What else, Nick? Nick: There's a couple other important directories. You have your OGG_ETC_HOME. This is where things like the configuration files are going to reside, parameter files, all your certificates for security, including the wallets where we store the credentials for not only the database accounts, but also for the GoldenGate user accounts as well. We have our GoldenGate variable home directory or VAR home. This is where all the GoldenGate log files are residing. And these are the log files that allow you to see what's going on in GoldenGate for auditing purposes. Anytime anybody makes a change to GoldenGate, you're going to see information go into the log files on what was happening and how it was working and what they did, what time they did, what command they issued. Another big important feature about these log files is it also gives you error information and troubleshooting details. So if you ever need to find out what happened in GoldenGate, what went wrong, you would look at these log files to find out that information. And then you also have your OGG_DATA_HOME. This is where those trail files are going to go. Essentially, this is kind of the queuing or overflow for GoldenGate. There's a couple of other additional components. We've got the admin client. This is our command line utility. If you don't want to use a web browser or prefer a command line utility, you can use the admin client. The admin client is also fully scriptable. So if you wanted to write scripts that would go off and automate things in GoldenGate, you can do that. A lot of customers did that with GGSCI in the classic architecture. You can do the same thing now with the admin client. The other component is the microservices security authentication and authorization services. These handle communication security, especially making sure that any passwords or usernames and everything like that is all encrypted. And instead of using an actual username and password, everything through the product is going to be done through an alias. And then it also handles all the authorization authentication, permissions, user accountability, and roles within GoldenGate. 16:39 Lois: Anything else you'd like to talk about before we wrap up for today, Nick? Nick: I also wanted to take a minute to talk about the REST API. All the microservices provide REST APIs to administer them and all of these are fully documented. They can be used by any client that can make REST API calls. So if you wanted to use Python, cURL, a web browser, you can do that as well. They're all just HTTP or HTTPS calls, get, put, patch, the standard REST API standards. And then GoldenGate does provide our admin client as well as a WebUI that use these REST APIs under the covers if you ever wanted to get a more advanced look at how it works. 17:18 Nikita: Well, that's all the time we have for today. Thanks for joining us, Nick.  Lois: Yes, thanks Nick. We look forward to having you back next week to talk with us about security strategies and data recovery. Nikita: And if you want to learn more about the topics we discussed today, head over to mylearn.oracle.com and take a look at the Oracle GoldenGate 23ai Fundamentals course. Until next time, this is Nikita Abraham… Lois: And Lois Houston, signing off!  17:43 That's all for this episode of the Oracle University Podcast. If you enjoyed listening, please click Subscribe to get all the latest episodes. We'd also love it if you would take a moment to rate and review us on your podcast app. See you again on the next episode of the Oracle University Podcast.

In a new season of the Oracle University Podcast, Lois Houston and Nikita Abraham dive into the world of Oracle GoldenGate 23ai, a cutting-edge software solution for data management. They are joined by Nick Wagner, a seasoned expert in database replication, who provides a comprehensive overview of this powerful tool.   Nick highlights GoldenGate's ability to ensure continuous operations by efficiently moving data between databases and platforms with minimal overhead. He emphasizes its role in enabling real-time analytics, enhancing data security, and reducing costs by offloading data to low-cost hardware. The discussion also covers GoldenGate's role in facilitating data sharing, improving operational efficiency, and reducing downtime during outages.   Oracle GoldenGate 23ai: Fundamentals: https://mylearn.oracle.com/ou/course/oracle-goldengate-23ai-fundamentals/145884/237273 Oracle University Learning Community: https://education.oracle.com/ou-community LinkedIn: https://www.linkedin.com/showcase/oracle-university/ X: https://x.com/Oracle_Edu   Special thanks to Arijit Ghosh, David Wright, Kris-Ann Nansen, Radhika Banka, and the OU Studio Team for helping us create this episode. ---------------------------------------------------------------   Episode Transcript: 00:00 Welcome to the Oracle University Podcast, the first stop on your cloud journey. During this series of informative podcasts, we'll bring you foundational training on the most popular Oracle technologies. Let's get started! 00:25 Nikita: Welcome to the Oracle University Podcast! I'm Nikita Abraham, Team Lead: Editorial Services with Oracle University, and with me is Lois Houston: Director of Innovation Programs. Lois: Hi everyone! Welcome to a new season of the podcast. This time, we're focusing on the fundamentals of Oracle GoldenGate. Oracle GoldenGate helps organizations manage and synchronize their data across diverse systems and databases in real time.  And with the new Oracle GoldenGate 23ai release, we'll uncover the latest innovations and features that empower businesses to make the most of their data. Nikita: Taking us through this is Nick Wagner, Senior Director of Product Management for Oracle GoldenGate. He's been doing database replication for about 25 years and has been focused on GoldenGate on and off for about 20 of those years.  01:18 Lois: In today's episode, we'll ask Nick to give us a general overview of the product, along with some use cases and benefits. Hi Nick! To start with, why do customers need GoldenGate? Nick: Well, it delivers continuous operations, being able to continuously move data from one database to another database or data platform in efficiently and a high-speed manner, and it does this with very low overhead. Almost all the GoldenGate environments use transaction logs to pull the data out of the system, so we're not creating any additional triggers or very little overhead on that source system. GoldenGate can also enable real-time analytics, being able to pull data from all these different databases and move them into your analytics system in real time can improve the value that those analytics systems provide. Being able to do real-time statistics and analysis of that data within those high-performance custom environments is really important. 02:13 Nikita: Does it offer any benefits in terms of cost?  Nick: GoldenGate can also lower IT costs. A lot of times people run these massive OLTP databases, and they are running reporting in those same systems. With GoldenGate, you can offload some of the data or all the data to a low-cost commodity hardware where you can then run the reports on that other system. So, this way, you can get back that performance on the OLTP system, while at the same time optimizing your reporting environment for those long running reports. You can improve efficiencies and reduce risks. Being able to reduce the amount of downtime during planned and unplanned outages can really make a big benefit to the overall operational efficiencies of your company.  02:54 Nikita: What about when it comes to data sharing and data security? Nick: You can also reduce barriers to data sharing. Being able to pull subsets of data, or just specific pieces of data out of a production database and move it to the team or to the group that needs that information in real time is very important. And it also protects the security of your data by only moving in the information that they need and not the entire database. It also provides extensibility and flexibility, being able to support multiple different replication topologies and architectures. 03:24 Lois: Can you tell us about some of the use cases of GoldenGate? Where does GoldenGate truly shine?  Nick: Some of the more traditional use cases of GoldenGate include use within the multicloud fabric. Within a multicloud fabric, this essentially means that GoldenGate can replicate data between on-premise environments, within cloud environments, or hybrid, cloud to on-premise, on-premise to cloud, or even within multiple clouds. So, you can move data from AWS to Azure to OCI. You can also move between the systems themselves, so you don't have to use the same database in all the different clouds. For example, if you wanted to move data from AWS Postgres into Oracle running in OCI, you can do that using Oracle GoldenGate. We also support maximum availability architectures. And so, there's a lot of different use cases here, but primarily geared around reducing your recovery point objective and recovery time objective. 04:20 Lois: Ah, reducing RPO and RTO. That must have a significant advantage for the customer, right? Nick: So, reducing your RPO and RTO allows you to take advantage of some of the benefits of GoldenGate, being able to do active-active replication, being able to set up GoldenGate for high availability, real-time failover, and it can augment your active Data Guard and Data Guard configuration. So, a lot of times GoldenGate is used within Oracle's maximum availability architecture platinum tier level of replication, which means that at that point you've got lots of different capabilities within the Oracle Database itself. But to help eke out that last little bit of high availability, you want to set up an active-active environment with GoldenGate to really get true zero RPO and RTO. GoldenGate can also be used for data offloading and data hubs. Being able to pull data from one or more source systems and move it into a data hub, or into a data warehouse for your operational reporting. This could also be your analytics environment too. 05:22 Nikita: Does GoldenGate support online migrations? Nick: In fact, a lot of companies actually get started in GoldenGate by doing a migration from one platform to another. Now, these don't even have to be something as complex as going from one database like a DB2 on-premise into an Oracle on OCI, it could even be simple migrations. A lot of times doing something like a major application or a major database version upgrade is going to take downtime on that production system. You can use GoldenGate to eliminate that downtime. So this could be going from Oracle 19c to Oracle 23ai, or going from application version 1.0 to application version 2.0, because GoldenGate can do the transformation between the different application schemas. You can use GoldenGate to migrate your database from on premise into the cloud with no downtime as well. We also support real-time analytic feeds, being able to go from multiple databases, not only those on premise, but being able to pull information from different SaaS applications inside of OCI and move it to your different analytic systems. And then, of course, we also have the ability to stream events and analytics within GoldenGate itself.  06:34 Lois: Let's move on to the various topologies supported by GoldenGate. I know GoldenGate supports many different platforms and can be used with just about any database. Nick: This first layer of topologies is what we usually consider relational database topologies. And so this would be moving data from Oracle to Oracle, Postgres to Oracle, Sybase to SQL Server, a lot of different types of databases. So the first architecture would be unidirectional. This is replicating from one source to one target. You can do this for reporting. If I wanted to offload some reports into another server, I can go ahead and do that using GoldenGate. I can replicate the entire database or just a subset of tables. I can also set up GoldenGate for bidirectional, and this is what I want to set up GoldenGate for something like high availability. So in the event that one of the servers crashes, I can almost immediately reconnect my users to the other system. And that almost immediately depends on the amount of latency that GoldenGate has at that time. So a typical latency is anywhere from 3 to 6 seconds. So after that primary system fails, I can reconnect my users to the other system in 3 to 6 seconds. And I can do that because as GoldenGate's applying data into that target database, that target system is already open for read and write activity. GoldenGate is just another user connecting in issuing DML operations, and so it makes that failover time very low. 07:59 Nikita: Ok…If you can get it down to 3 to 6 seconds, can you bring it down to zero? Like zero failover time?   Nick: That's the next topology, which is active-active. And in this scenario, all servers are read/write all at the same time and all available for user activity. And you can do multiple topologies with this as well. You can do a mesh architecture, which is where every server talks to every other server. This works really well for 2, 3, 4, maybe even 5 environments, but when you get beyond that, having every server communicate with every other server can get a little complex. And so at that point we start looking at doing what we call a hub and spoke architecture, where we have lots of different spokes. At the end of each spoke is a read/write database, and then those communicate with a hub. So any change that happens on one spoke gets sent into the hub, and then from the hub it gets sent out to all the other spokes. And through that architecture, it allows you to really scale up your environments. We have customers that are doing up to 150 spokes within that hub architecture. Within active-active replication as well, we can do conflict detection and resolution, which means that if two users modify the same row on two different systems, GoldenGate can actually determine that there was an issue with that and determine what user wins or which row change wins, which is extremely important when doing active-active replication. And this means that if one of those systems fails, there is no downtime when you switch your users to another active system because it's already available for activity and ready to go. 09:35 Lois: Wow, that's fantastic. Ok, tell us more about the topologies. Nick: GoldenGate can do other things like broadcast, sending data from one system to multiple systems, or many to one as far as consolidation. We can also do cascading replication, so when data moves from one environment that GoldenGate is replicating into another environment that GoldenGate is replicating. By default, we ignore all of our own transactions. But there's actually a toggle switch that you can flip that says, hey, GoldenGate, even though you wrote that data into that database, still push it on to the next system. And then of course, we can also do distribution of data, and this is more like moving data from a relational database into something like a Kafka topic or a JMS queue or into some messaging service. 10:24 Raise your game with the Oracle Cloud Applications skills challenge. Get free training on Oracle Fusion Cloud Applications, Oracle Modern Best Practice, and Oracle Cloud Success Navigator. Pass the free Oracle Fusion Cloud Foundations Associate exam to earn a Foundations Associate certification. Plus, there's a chance to win awards and prizes throughout the challenge! What are you waiting for? Join the challenge today by visiting visit oracle.com/education. 10:58 Nikita: Welcome back! Nick, does GoldenGate also have nonrelational capabilities?  Nick: We have a number of nonrelational replication events in topologies as well. This includes things like data lake ingestion and streaming ingestion, being able to move data and data objects from these different relational database platforms into data lakes and into these streaming systems where you can run analytics on them and run reports. We can also do cloud ingestion, being able to move data from these databases into different cloud environments. And this is not only just moving it into relational databases with those clouds, but also their data lakes and data fabrics. 11:38 Lois: You mentioned a messaging service earlier. Can you tell us more about that? Nick: Messaging replication is also possible. So we can actually capture from things like messaging systems like Kafka Connect and JMS, replicate that into a relational data, or simply stream it into another environment. We also support NoSQL replication, being able to capture from MongoDB and replicate it onto another MongoDB for high availability or disaster recovery, or simply into any other system. 12:06 Nikita: I see. And is there any integration with a customer's SaaS applications? Nick: GoldenGate also supports a number of different OCI SaaS applications. And so a lot of these different applications like Oracle Financials Fusion, Oracle Transportation Management, they all have GoldenGate built under the covers and can be enabled with a flag that you can actually have that data sent out to your other GoldenGate environment. So you can actually subscribe to changes that are happening in these other systems with very little overhead. And then of course, we have event processing and analytics, and this is the final topology or flexibility within GoldenGate itself. And this is being able to push data through data pipelines, doing data transformations. GoldenGate is not an ETL tool, but it can do row-level transformation and row-level filtering.  12:55 Lois: Are there integrations offered by Oracle GoldenGate in automation and artificial intelligence? Nick: We can do time series analysis and geofencing using the GoldenGate Stream Analytics product. It allows you to actually do real time analysis and time series analysis on data as it flows through the GoldenGate trails. And then that same product, the GoldenGate Stream Analytics, can then take the data and move it to predictive analytics, where you can run MML on it, or ONNX or other Spark-type technologies and do real-time analysis and AI on that information as it's flowing through.  13:29 Nikita: So, GoldenGate is extremely flexible. And given Oracle's focus on integrating AI into its product portfolio, what about GoldenGate? Does it offer any AI-related features, especially since the product name has “23ai” in it? Nick: With the advent of Oracle GoldenGate 23ai, it's one of the two products at this point that has the AI moniker at Oracle. Oracle Database 23ai also has it, and that means that we actually do stuff with AI. So the Oracle GoldenGate product can actually capture vectors from databases like MySQL HeatWave, Postgres using pgvector, which includes things like AlloyDB, Amazon RDS Postgres, Aurora Postgres. We can also replicate data into Elasticsearch and OpenSearch, or if the data is using vectors within OCI or the Oracle Database itself. So GoldenGate can be used for a number of things here. The first one is being able to migrate vectors into the Oracle Database. So if you're using something like Postgres, MySQL, and you want to migrate the vector information into the Oracle Database, you can. Now one thing to keep in mind here is a vector is oftentimes like a GPS coordinate. So if I need to know the GPS coordinates of Austin, Texas, I can put in a latitude and longitude and it will give me the GPS coordinates of a building within that city. But if I also need to know the altitude of that same building, well, that's going to be a different algorithm. And GoldenGate and replicating vectors is the same way. When you create a vector, it's essentially just creating a bunch of numbers under the screen, kind of like those same GPS coordinates. The dimension and the algorithm that you use to generate that vector can be different across different databases, but the actual meaning of that data will change. And so GoldenGate can replicate the vector data as long as the algorithm and the dimensions are the same. If the algorithm and the dimensions are not the same between the source and the target, then you'll actually want GoldenGate to replicate the base data that created that vector. And then once GoldenGate replicates the base data, it'll actually call the vector embedding technology to re-embed that data and produce that numerical formatting for you.  15:42 Lois: So, there are some nuances there… Nick: GoldenGate can also replicate and consolidate vector changes or even do the embedding API calls itself. This is really nice because it means that we can take changes from multiple systems and consolidate them into a single one. We can also do the reverse of that too. A lot of customers are still trying to find out which algorithms work best for them. How many dimensions? What's the optimal use? Well, you can now run those in different servers without impacting your actual AI system. Once you've identified which algorithm and dimension is going to be best for your data, you can then have GoldenGate replicate that into your production system and we'll start using that instead. So it's a nice way to switch algorithms without taking extensive downtime. 16:29 Nikita: What about in multicloud environments?  Nick: GoldenGate can also do multicloud and N-way active-active Oracle replication between vectors. So if there's vectors in Oracle databases, in multiple clouds, or multiple on-premise databases, GoldenGate can synchronize them all up. And of course we can also stream changes from vector information, including text as well into different search engines. And that's where the integration with Elasticsearch and OpenSearch comes in. And then we can use things like NVIDIA and Cohere to actually do the AI on that data.  17:01 Lois: Using GoldenGate with AI in the database unlocks so many possibilities. Thanks for that detailed introduction to Oracle GoldenGate 23ai and its capabilities, Nick.  Nikita: We've run out of time for today, but Nick will be back next week to talk about how GoldenGate has evolved over time and its latest features. And if you liked what you heard today, head over to mylearn.oracle.com and take a look at the Oracle GoldenGate 23ai Fundamentals course to learn more. Until next time, this is Nikita Abraham… Lois: And Lois Houston, signing off! 17:33 That's all for this episode of the Oracle University Podcast. If you enjoyed listening, please click Subscribe to get all the latest episodes. We'd also love it if you would take a moment to rate and review us on your podcast app. See you again on the next episode of the Oracle University Podcast.

DML goes live to go over Trump's first 99 days in office.

DML and Denny discuss President Trump's last peace deal offer to Ukraine and Russia, resistance from radical judges, and liberals weaponizing Jesus' name.

DML breaks down Trump's potential plan for future tax cuts and much more.

DML and Denny discuss Democrats flying down to El Salvador, the second Signal scandal with Sec. Hegseth, and the death of Pope Francis.

W czwartym odcinku podcastu odpowiadamy m.in. na poniższe pytania: - Jakie największe, najbardziej szkodliwe bzdury słyszymy na temat AI? - Na czym polega tzw. uczenie maszynowe? Czym uczenie maszyn różni się od uczenia ludzi? - Czym są tzw. głębokie sieci neuronowe? Jak sztuczne "neurony" mają się do prawdziwych? - Czym są sieci konwolucyjne (CNN)? Jak mają się do rekurencyjnych (RNN)? Jak działa architektura transformer? - Czym są halucynacje? Z czego wynikają? Dlaczego nie umiemy ich wyeliminować? - Czym jest właściwie AGI? Dlaczego nie wiadomo o czym rozmawiamy? Linki: - Eric Larson o "Imitation Game" w "The Myth of AI": https://www.jstor.org/stable/j.ctv322... - Satya Nadella o deeskalacji oczekiwań wobec AI: https://www.dwarkesh.com/p/satya-nadella - Japoński program rozwoju komputerów piątek generacji: https://www.sciencedirect.com/science... - Wizualizacja działania DNN: • Neural Network 3D Simulation - Wizualizacja działania LLM: • Transformers (how LLMs work) explaine... - O halucynacjach generatywnych wyszukiwarek: https://www.cjr.org/tow_center/we-com... - Goeffrey Hinton o świadomości maszyn: • ‘Godfather of AI' predicts it will ta... - Poglądy Francois Cholleta: / fran%25c3%25a7ois-chollet-wie-co-m%25c3%25... - Roger Penrose o niekomputacyjności umysłu: • Asking a Theoretical Physicist About ... - Ostatni test ludzkości: https://agi.safe.ai/ Special Guest: Gniewosz Leliwa.

I'm angry! A Once-UndocumentedImmigrant Speaks from the Heart-- Live Work with Sunny, Part 1 Sunny Choi is a beloved member of the TEAM community. He grew up in Hong Kong before emigrating with his family to the United States when he was 11 years old. He graduated from UCLA with a major in engineering, completed a master's degree in Engineering Management at Stanford, and developed a successful career in high tech Silicon Valley companies. However, he left his work to pursue additional graduate training in clinical social work because he discovered that his strongest call was to help individuals who were being marginalized by American culture and suffering. He then obtained an MSW degree with a specialty in Community Mental Health from California State University. We were fortunate when Sunny discovered and joined our free Stanford TEAM CBT training group, and blossomed into an expert TEAM therapist and beloved colleague and friend. Today, Dr. Jill Levitt and I worked with Sunny because he requested a session to work on his own troubled feelings concerning the recent political developments. He emphasized that he wanted to do personal work, rather than focusing too heavily on the current political controversies and battles. You can find the Daily Mood Log (DML) that Sunny prepared just prior to his session if you click here As you can see, at the top of his DML, he described the upsetting event as tearing up when he was teaching a class and discussing a case of a transgender Mexican American man, and he began reflecting on his own memories of growing up as a gay male and undocumented immigrant. Sadness and anger were the two strongest negative feelings (rated 70 and 80, respectively on a scale from 0 to 100), although he was also moderately anxious, guilty, rejected, hopeless, and frustrated. You can also see the ten negative thoughts he recorded on his DML, and how strongly he believed each one, on a scale from 0 (not at all) to 1000 (completely.). During the session he added three more thoughts: 11.  I (shouldn't be) living such a happy and pleasurable life when others are suffering. 70% 12.  I should be helping others more. 80% 13.  I have to figure out the correct way to be thinking and feeling. 50% At the start of the session, he said that he felt vulnerable and nervous discussing such personal feelings, memories, and thoughts. He also said that after doing much personal and professional work, he was generally happy and loving, but felt profoundly disturbed when he thought about so many people who are suffering. He said, “Many of my clients are being deported. And those who are gay are worried that they'll lose access to their medications.” These were the kinds of thoughts that triggered his feelings of guilt. During the empathy phase, Jill mentioned that she felt honored to be talking to Sunny today and proud to be a member of a community where you can reach out when you're suffering. She added that she felt torn, as I did, because it seemed to us that many of his negative thoughts were realistic, and not distorted, and that it makes sense to feel sad, anxious, worried, and angry. For example, his first negative thought on his DML was, “The world is much more unstable and dangerous now.” Sunny emphasized that most of the time he does feel happy, especially when involved with friends and family, and doing the things he loves. But then he gets confused and guilty, wondering if it is right to feel happy when things are looking so dark for so many people. It certainly makes sense to feel unhappy when, as Sunny said, some of his clients and friends have lost their jobs and people in the LGBTQ+ community are afraid they'll get deported. And we're all afraid to speak up and talk about diversity, which has become a dirty word that can get you into trouble. And when Sunny thinks about this, he feels profound sadness and compassion. But as previously noted, this has caused confusion for Sunny, and he struggles with feelings of guilt about the fact that he is truly happy so much of the time. He's happy about his beautiful life, his marriage, and more—this, in fact, is his happiest he's ever been. Here's how he puts it: “I used to be undocumented. The experience and the hostility and bias I confronted traumatized me. And when I heard Trump talk about all the ‘murders and rapists' invading our country from Mexico, I became tearful. I feel angry—they don't think we're human. “I want people to be more compassionate. . . . To say we're rapists and criminals, it's not okay. . . it's mean, and it's very harmful to mental health. . . . It's like repeatedly poking at someone who is recovering from a terrible wound, and it hurts.” Jill was touched, and found Sunny's vulnerability heart-warming, beautiful, and refreshing. Rhonda reminded us that unless we are Indigenous Native Americans, all Americans are descended from immigrants. In my own case, all my ancestors came from Sweden in the late 1800s during the potato famine. Sunny pointed out the European immigrants have not been discriminated against in the same way as the Africans, Asians, Latinos, Islamic, and dark-skinned individuals: “Let's be open. It's racism. I felt it right from the start.” Sunny gave us an A+ on empathy, and then we worked to set the agenda for the session. What did Sunny hope to get from the session? What did he want help with? What changes was he hoping for? He said: “Maybe my feelings are appropriate, but some may be too intense. My goal is to find peace; to have hope, and to try to do something to help. . . I want to feel proud of who I am and what I stand for. I want to try to be loving and compassionate, even to people who don't have the same beliefs and values. . . . Although that can be incredibly challenging!” When you listen to today's podcast, you will hear the T = Testing and E = Empathy portions of the session. Next week, you will hear the A = Paradoxical Agenda Setting and M = Methods portions along with the conclusion, including the final T = Testing to evaluate his end of session scores on the Brief Mood Survey and Evaluation of Therapy Session. Thank you for joining us. Rhonda, Jill, Sunny, and I appreciate all of you!

DML goes solo to talk about Miss Mary, China, and the hypocrisy infecting America.

DML and Ryan discuss Pam Bondi's recent warning to those involved in the Tesla attacks, Pete Hegseth's take on combat role standards in the military, and much more.

DML and Ryan discuss the Social Security fraud Elon Musk has found and much more.

DML gives an update on Miss Mary and everything that's unfolded over the past few days. Then, he and Denny dive into new revelations in the text messaging scandal, Trump's latest round of tariffs, Kristi Noem's surprising trip to El Salvador, and another radical decision from Judge Boasberg.

DML sits down with Denny to answer your questions over a wide range of topics.

DML and Denny discuss Trump's order to call back Secret Service protection from Hunter Biden, Adam Kizinger taunts Trump, Conor McGregor's message to Ireland, and a French politician is demanding the Statue of Liberty back

DML and Denny discuss VP Vance's trip to the border and upcoming problems with Trump's deportation plan, as well as the sanctuary city mayors testifying before Congress.

DML and Denny discuss President Trump's epic speech last before a joint session of Congress and featured guests. They also discuss the Democrats' wicked behavior throughout the event, but also focus on the touching moments such as Trump's honoring of murder victim Jocelyn Nungaray and cancer survivor DJ Daniels.

President Trump's reactivation of tariffs today has prompted Taiwan's Semiconductor Manufacturing Company to pledge a $100 billion investment into America. DML and Denny discuss the future impacts of Trump tariffs and his objective to bring manufacturing back to the U.S., such as the recent announcement of Honda shifting production out of Mexico.

Denny interviews DML on the journies throughout his career, activism, and life. They discuss his early days starting a computer company, going to filmmaking school after 9/11, anchoring a successful television show, and starting a media company through his passion for saving and fixing the country.

DML and Denny discuss the ongoing delays and drama of the Epstein case file release and how the NY FBI is obstructing the evidence. They also discuss Trump's renewed fight with Venezuela over their handling of taking back illegal aliens, and Zelensky visits the White House today to sign a deal.

DML and Denny discuss President Trump's historic first Cabinet meeting of his second term, as well as the media's latest attacks on Elon Musk and DOGE.

DML and Denny discuss President Trump's new initiative to eliminate the national debt through an ambitious immigration plan involving a "Gold Card." Plus, Tulsi Gabbard and Kristi Noem are weeding out the traitors and the incompetent in their departments.

DML and Denny discuss French President Macron visiting President Trump at the White House, the closing of the migrant shelter at Roosevelt Hotel, and Gov. DeSantis hints at Florida's future leader.

DML and Denny discuss saying goodbye to a Trump hater, federal workers returning to the office full-time, a landmark decision by Apple, and a breakthrough in AI and health.

For this week's Life After 50, DML interviews Patrick Asare, the Ghanaian author of the award-winning and bestselling memoir The Boy from Boadua: One African's Journey of Hunger and Sacrifice in Pursuit of a Dream. At 63, Asare is a proud immigrant who deeply appreciates America and brings a wealth of knowledge on sociocultural, political, and geopolitical issues. A passionate speaker, he inspires audiences by sharing his remarkable journey and perspectives that have earned him widespread global recognition.

DML and Denny will discuss CPAC, Trump's conference with African Americans, and Kash Patel is confirmed.

DML and Denny discuss Trump fighting congestion pricing, Trump calling out Zelensky, and the budget plan for Trump's agenda.

DML and Denny will discuss Hannity's interview of Trump and Musk, Trump's new plan for tariffs, an executive order on IVF, and Stephen Miller's updates on deportations.

DML and Denny will discuss the peace talks in Saudia Arabia over the Russia-Ukraine war, the auditing proposal of Fort Knox, and a new ad campaign to combat illegal immigration.

DML and Denny will discuss the media's reaction to the Munich Conference, Trump at the Daytona 500, latest DOGE cuts, and censorship's impact on free speech.

Alec Lace joins DML to discuss the significant changes happening in the White House concerning the press corp.

DML and Denny will discuss Trump and Musk's press conference on DOGE from the Oval Office, Trump's meeting with the King of Jordan, and the old limestone mine used to process federal retirements by hand.

DML and Denny discuss Trump's new tariffs, deputizing the IRS, radical judge intervention, and the FBI tipping off Tren de Aragua members on deportation raids.

DML interviews Bill Antle, a multimillionaire who saved a major company, piloted nuclear submarines, and worked with a presidential candidate. He's 80 but living like he's 40, and has many incredible stories to share.

DML and Denny discuss Trump's words on God at the National Prayer Breakfast, incoming tax cuts, the end of USAID, and... who is 'Big Balls'? Plus, Kamala Harris' unedited 60 Minutes interview answers.

DML and Denny discuss President Trump signing the EO to protect women's sports from transgender madness, plus a radical Democrat is filing impeachment articles, again. And an update on the Epstein client list.

DML and Denny discuss Trump taking over the Gaza Strip with Israel, Democrats target DOGE, and more updates on key confirmations of Trump cabinet members.

DML and Denny discuss the termination of USAID, a new deal with El Salvador, and a governor's admission about harboring a potential illegal alien.

DML and Denny discuss Trump's implementation of tariffs on Canada, Mexico, and China, as well as the DNC's newly elected leadership.

DML and Denny discuss Trump's press conference on the aircraft collision and the confirmation hearings of Tulsi Gabbard, Kash Patel, and RFK Jr.

DML and Denny discuss the first press briefing of the Trump administration, Kristi Noem's raids with ICE in NYC, and Trump's buyout proposal to federal workers.

DML and Denny discuss Trump's interview on Hannity, Elon Musk's callout of Stargate, and AOC's “advice” illegal immigrants to avoid ICE, and much more.

DML and Denny discuss ICE's first phase of deportations, Trump's $500 billion infrastructure announcement & the National Prayer Service controversy

DML and Denny delve into the events surrounding Trump's Inauguration Day and the tragic killing of a Border Patrol agent by an illegal alien in Vermont.

In this episode of Life After 50, DML speaks with Kim Netling, a Board Certified and Licensed Acupuncture Physician. As a liver transplant and cancer survivor, Kim shares her inspiring journey and how it led her to help others navigate chronic health challenges. Specializing in Functional Neurology and NAET, she treats conditions like PTSD, TBI, allergies, autoimmunity, concussions, vertigo, autism, and the side effects of cancer treatments such as chemotherapy-induced nausea, peripheral neuropathy, and dry mouth from radiation therapy. Kim's holistic approach focuses on healing, balance, and personalized care. Discover the transformative power of acupuncture and natural medicine in overcoming critical and chronic health issues.

On this episode of Life After 50, DML sits down with Fr. Barrett, a writer and leader focused on ministry through character, academics, leadership, and community building. With degrees in English Literature from The University of the South (Sewanee), Education Administration from Fordham University, and Divinity from Trinity Episcopal School for Ministry, Fr. Barrett shares insights on restoring America's faith and connection with God.

DML and Denny discuss the ongoing fires that have engulfed major areas of California, such as the Pacific Palisades and Hollywood Hills, and more. They also debate how much is Gov Newsom and the DEI fire department to blame?

DML and Denny discuss Trump's escalating rhetoric on acquiring Greenland and Canada to become part of the U.S., as well as regaining control of the Panama Canal. They also discuss DeSantis' planned nomination to fill Rubio's senate seat, and the raging wind fires in California.

DML and Denny discuss Mark Zuckerberg's apology video, where he announces that Facebook and Instagram will be shifting toward a pro-free-speech approach.