Posts

Showing posts from September, 2020

KNN - K Nearest neighbours

Machine Learning models make predictions from the past data available. KNN is one of the simplest Supervised ML algorithm mostly used for Classification. It classifies based on how its neighbors are classified. KNN stores available cases and classifies new cases based on similarity measure Choice of K - sqrt(N)  Lazy learning algorithm How does (kids) teach kids to learn differentiate between cat & dog:  type of claws, ear length, sound(bark vs meow), plays around vs not kids identify given animal based on feature classification Uses Cases: Recommended systems- biggest use case in real-time online shopping, OTT platforms, advertisement  Content Search- documents having similar topics from billions of documents Image & video recolonization Height, weight -> derive T shirt size  Predict dog category Predict Over weight or not based on height & weight   Predict Over Diabetes  Pregnancies, Glucose, BP, Skin thickness, insulin, BMI, diabetes pede...

DB-REST access

 ACL(Access control list) ORDS(Oracle REST Data Service) It is a list of access control entries to restrict the hosts that are allowed to connect to the Oracle database. ACLs are created using dbms_network_acl_admin and dbms_network_acl_utility packages.  Calling WebServices from Oracle PLSQL:   Links https://www.youtube.com/watch?v=avBgGPw0_sA&t=16s  https://slobaray.com/2015/02/05/calling-web-services-from-oracle-plsql/ http://www.dba-oracle.com/t_advanced_utl_http_package.htm  https://gist.github.com/ser1zw/3757715 https://www.oradev.com/utlhttp.html https://docs.oracle.com/cd/F49540_01/DOC/server.815/a68001/utl_http.htm In Oracle we have a package called UTL_HTTP. By using this package we can call web services using a POST method and get a response from it. To use any web services we need to register the URL in our DB by assigning it to the Access Control List (ACL). Here is the below code which need to be executed under SYS user, so that we can ut...