•An effective way to leverage emerging technologies to solve some common complex problems which are currently being done manually. A cool way to utilize ML/AI along with Natural Language processing to scan large volumes of text. The primary goal is to identify Keywords and frequency of keywords that relate to diseases using tokenization and Lemmatization models. Opensource Models like FuzzyWuzzy logic and Document Frequency Terms (DFT) were extensively used.
•Our Business Operations at Kaiser captures long texts and unstructured data for each research subject (about 6000 to 10000 of them a year) that they work on. This unstructured data is captured in long text fields and sometimes runs into multiple pages for each subject. We created models to scan through volumes of texts, identify Keywords using python Spacy models, and have the models predict the area of and type of study.
•Tools used: Python, SQL, Oracle Cloud Analytics, Oracle Cloud reporting, and Data Science services from Oracle

Speaker: Pratap Madgula and Tony Schollum, Kaiser Permanente

Presented at INSYNC 21

Session ID: 100720

Business rules define the requirements of the organization such as what constitutes valid data. A PL/SQL Table API provides a centralized location for the code you write to represent those business rules. This technique has many benefits including better performance, reduced cloud database costs, simplification of user interface code, and more secure applications, and it can be used for any development environment: APEX, ADF, MAF, JET, MAX, VB Studio, Java, JavaScript, or any other framework.

Attend this session to hear about the benefits of this kind of centralized code in more detail as well as some advice about how to incorporate it into your development practices. The presentation focuses on the code components and strategies relevant to using a PL/SQL Table API and the methods used to call it. It also describes and demonstrates methods for automatically generating a large part of the code and shows examples of generated code as well as code that calls the Table API.

Presented at INSYNC 21

Session ID: 100730

Efficient applications require the best performance from all components used to implement the application. If you are using cloud services, tuning of some components is out of your control, but regardless of your use of cloud, your job as an application developer is to ensure that your database code runs as efficiently as possible. It is so much easier to create highly-performant code in the first place than it is to have to fix the code later when you find that it is not performing well.

At this session, you will hear an introduction to (or a review of) a set of PL/SQL coding techniques that help performance. Although these techniques have been known for years, if you are relatively new to the language you may not have been exposed to them. Examples of these techniques include: caching local variables, iteration handling, reducing context switching, datatype selection, and various methods for handling data manipulation. Sample code will illustrate the principles.