Understanding Database Scalability – Vertical and Horizontal

https://blog.sqlauthority.com/2016/04/29/understanding-database-scalability-vertical-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();

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