August 21, 2019

Understanding Database Scalability – Vertical and Horizontal

MongoDB - Commands (document database)

show dbs
use myDB
show collections
db.createCollection("users")
db.users.drop()

Insert Documents
db.users.insertOne({ name: "Alice", age: 30 });
db.users.insertMany([
{ name: "Bob", age: 25 },
{ name: "Charlie", age: 35 }
]);

Find (Read Data)
db.users.find();
db.users.find({ age: { $gt: 25 } });
db.users.find({ name: "Alice", age: 30 });
db.users.find({}, { name: 1, _id: 0 });
db.users.find().sort({ age: -1 });
db.users.find().limit(5);

Update Documents
db.users.updateOne({ name: "Alice" }, { $set: { age: 31 } });
db.users.updateMany({ age: { $lt: 30 } }, { $set: { status: "young" } });
db.users.replaceOne({ name: "Alice" }, { name: "Alicia", age: 32 });

Delete Documents
db.users.deleteOne({ name: "Alice" });
db.users.deleteMany({ age: { $lt: 25 } });

Aggregation
db.users.aggregate([
{ $group: { _id: "$age", count: { $sum: 1 } } }
]);
db.users.aggregate([
{ $match: { age: { $gt: 25 } } },
{ $project: { name: 1, age: 1 } }
]);

Comparison Operators
$eq, $ne, $gt, $gte, $lt, $lte, $in, $nin
db.users.find({ age: { $gte: 25, $lte: 35 } });

Logical Operators
$and, $or, $not
db.users.find({ $and: [{age: {$gt: 25}}, {status: "active"}] });

Array Operators
db.users.find({ tags: { $in: ["admin"] } });
db.users.find({ tags: ["admin", "user"] });
db.users.find({ tags: { $size: 2 } });
db.users.updateOne({ name: "Alice" }, { $push: { tags: "newbie" } });

Indexes
db.users.createIndex({ name: 1 });
db.users.dropIndex({ name: 1 });
db.users.getIndexes();

March 4, 2019

RPA Tool evaluation

If you want to evaluate the RPA tool then below things need to be consider
  1. Pricing
  2. Type of application can automate
  3. Ease of use
  4. Maintenance and support of BOT
  5. Deployment of Bot and Code synch
  6. Security
  7. scalability (number of bots can deploy)
  8. Vendor experience and use cases
  9. Time require to develop a BOT
  10. Number of resources available in the market