Apr 15

AI Algorithms – 4: KNN, K-Means

Apr 15

AI Algorithms – 3: Logistic/Linear Regression

Apr 15

AI Algorithms – 2:SVF, RBF

Apr 14

AI Algorithms – 1: Overall AI Topics

Apr 13

Examples: Data Science and Machine Learning Applications

• Stock Price Prediction

• Covid19 spread prediction

• Flu Spread Prediction

• Predict when inflation will be lower

• Healthcare which demographics are vulnerable for a specific disease

• Predict/forecast doctors need in 10 years

• Sales Forecast

• Fraud Detection

Apr 09

MongoDB: Array Operations

Try these Array Operations:

db.posts.find({}, {_id:0, category:1, tags:1});
db.posts.updateMany({category:'Event'}, {$addToSet:{tags:"Tech"}});
db.posts.updateMany({category:'Event'}, {$push:{tags:"Tech Event"}});
db.posts.updateMany({category:'Event'}, {$pull:{tags:"Tech"}});
db.posts.updateOne( { likes: 4 }, { $pop: { tags: -1 } } )
db.posts.updateMany({}, {$pull:{tags:["Tech"]}});
 db.posts.updateMany({}, {$pull:{tags:"Tech"}});
db.posts.updateMany({}, {$pull:{tags:{$in:["Tech", "Tech Event"]}}});
Run it several times: db.posts.updateMany({}, {$push:{tags:"Tech Event"}});
Check data: db.posts.find({}, {tags:1, _id:0});
Pull and then check data: 
db.posts.updateMany({}, {$pull:{tags:{$in:["Tech", "Tech Event"]}}});
db.posts.find({}, {tags:1, _id:0});

Use data from the URL below: https://www.w3schools.com/mongodb/mongodb_mongosh_insert.php

db.posts.insertMany([  
  {
    title: "Post Title 2",
    body: "Body of post.",
    category: "Event",
    likes: 2,
    tags: ["news", "events"],
    date: Date()
  },
  {
    title: "Post Title 3",
    body: "Body of post.",
    category: "Technology",
    likes: 3,
    tags: ["news", "events"],
    date: Date()
  },
  {
    title: "Post Title 4",
    body: "Body of post.",
    category: "Event",
    likes: 4,
    tags: ["news", "events"],
    date: Date()
  }
])

Theory/Concept:

Apr 09

Try: MongoDB Regular Expresssions

^ : starts with

$ : Ends with

.* : any char, any number of times

/i : case insensitive

Try the following Queries

•db.posts.find( { title: { $regex: /4$/ } } );

•db.posts.find( { category: { $regex: /^T.*/ } } );

• db.posts.find( { category: { $not: /^p.*/ } } );

•db.posts.find( { category: { $regex: /^ev/i } } );

•db.posts.find( { category: { $regex: /^ev/ } } );

•db.posts.find( { category: { $regex: /^Ev/ } } );

•db.posts.find( { category: { $regex: /^Ev.*t$/ } } );

•db.posts.find( { category: { $regex: /^Ev*t$/ } } );

Use Data from the Following URL:

https://www.w3schools.com/mongodb/mongodb_mongosh_insert.php

db.posts.insertMany([  
  {
    title: "Post Title 2",
    body: "Body of post.",
    category: "Event",
    likes: 2,
    tags: ["news", "events"],
    date: Date()
  },
  {
    title: "Post Title 3",
    body: "Body of post.",
    category: "Technology",
    likes: 3,
    tags: ["news", "events"],
    date: Date()
  },
  {
    title: "Post Title 4",
    body: "Body of post.",
    category: "Event",
    likes: 4,
    tags: ["news", "events"],
    date: Date()
  }
])

Apr 09

Oracle Auditing

To Know:

•WHAT IT IS?

•WHY WE NEED

•WHAT CAN WE AUDIT

•WHAT ORACLE AUDITS ON Its OWN

•WHERE AUDIT DATA ARE KEPT

•HOW TO SET CUSTOM AUDIT

•HOW TO SEE WHAT AUDITS ARE SET

•HOW TO SEE THE AUDIT TRAIL

Check:

https://docs.oracle.com/cd/E11882_01/server.112/e10575/tdpsg_auditing.htm#TDPSG50511

Activity: Using Audit Trail Views to Investigate Suspicious Activities

https://docs.oracle.com/cd/B19306_01/network.102/b14266/cfgaudit.htm#i1010026

Apr 04

Oracle pfile, spfile

Ref: https://www.devopsschool.com/blog/oracle-tutorials-what-is-pfile-and-spfile/

Apr 04

Oracle : Auditing Database Activity

7 Auditing Database Activity

This chapter contains:

Ref: https://docs.oracle.com/cd/E11882_01/server.112/e10575/tdpsg_auditing.htm#TDPSG50511