brijesh-deb

• Challenges with traditional database
  • Not a good fit for large data volume(petabyte of data) with varying data types(images, video, text etc.)
  • Cann't scale for large data volume
  • Scale up is limited by memory and processing (CPU) capabilities
  • Scale out is difficult to achieve
  • Sharding causes operational problems; eg- managing shard failure
  • Consistency is a bottleneck for scalability in RDBMS
• In case of NoSQL consistency is relaxed.

Types of NoSQL

• Key/Value store: Redis, Couchbase

brijesh-deb

5 C's of leadership

• Competence
• Courage and Confidence
• Communication skills (written and oral)
• Consistency
• Compass: integrity

Engineering Manager

• Responsible for
  • Planning
• Decision Making

brijesh-deb

• MongoDB is a document database.
• MongoDB is the most relational non-relational database
• Parallel between Relation and MongoDB
  • Database : Database
  • Table : Collection
  • Row: Document
  • Index : Index
  • Join : Lookup
  • Foreign Key : Reference or Embedded Document
• Multi-table transaction : Single document transaction

brijesh-deb

Database

• Database Basics
• Database Index
• NoSQL
• MongoDB

Cloud

• Spring Cloud: Netflix
• AWS Sol Arch Associate
• SpringBoot
• Microservices Pattern - External

brijesh-deb

Setup CF CLI

• Download exe from https://github.com/cloudfoundry/cli/releases
• Extract and run cf_installer.exe
• Verify
  • Cf --version
• Loging to Predix Account
  • Cf login -a https://api.system.aws-usw02-pr.ice.predix.io

Basic Commands

• Login to cf : cf login
• Display all services in the catalog: cf marketplace or cf m

brijesh-deb

• Predix
• AWS
• Git
• Blank SpringBoot Service
• Maven
• Postman
• Eclipse
• Linux
• Jenkins
• SonarQube

brijesh-deb

RabbitMQ Setup

• Erlang
  • Uninstall old installation (optional)
  • Install otp_win64_20.3.exe (as administrator)
  • Add environment variable ERLANG_HOME=C:\rabbitmq\erl9.3
• RabbitMQ
  • Install rabbitmq-server-3.7.4.exe in C:\rabbitmq\rabbitmq_server-3.7.4 (as administrator)
  • Add environment variable RABBITMQ_BASE= C:\rabbitmq\rabbitmq_server-3.7.4
  • Copy .erlang.cookie from C:\Windows to C:\Users[User Name]
  • Start command prompt (Run as Administrator)

brijesh-deb

Shadow information

• Shadow information is any data that objects need to maintain, above and beyond their normal domain data, to persist themselves.  This typically includes primary key information, particularly when the primary key is a surrogate key that has no business meaning, concurrency control markings such as timestamps or incremental counters, and versioning numbers.

Scaffolding

• Scaffolding is a technique supported by some model-view-controller frameworks, in which the programmer may write a specification that describes how the application database may be used. The compiler uses this specification to generate code that the application can use to create, read, update and delete database entries, effectively treating the template as a "scaffold" on which to build a more powerful application.

Mapping Inheritance structure to database

• Scenario: Person is the parent class of Customer and Employee. Further Executive is the child class of Employee.
• ***Map entire class hierarchy to a single

brijesh-deb

Why use index ?

• The whole point of having an index is to speed up search queries by essentially cutting down the number of records/rows in a table that need to be examined.
  • SELECT * FROM Employee WHERE Employee_Name = 'Jesus'
• In absence of index, for searching column value, all rows in the database table has to be scanned. This is called full table scan.

What is an index?

• An index is a data structure (most commonly a B- tree) that stores the values for a specific column in a table. An index is created on a column of a table. So, the key points to remember are that an index consists of column values from one table, and that those values are stored in a data structure. The index is a data structure – remember that.

What kind of data structure is an index?

• B- trees are the most commonly used data structures for indexes. The reason B- trees are the most popular data structure for indexes is due to the fact that they are time efficient – because look-ups, deletions, and insertions can all

brijesh-deb

Using Elastic Beanstalk

• Pre-requisite
  • Default VPC
• Steps
  • Create the project jar file [mvn clean install]
  • Go to AWS Beanstalk
  • Click "Get Started"
  • Enter
    • Application Name: [Name]
• Platform: Java