Posts

Consultant - Understanding the Job

Image
What does the consultant do? Solve Business Problem. But, it is very deep term. Management Consultant is content ambassador. They are the bridge between complex client context and massive knowledge with experts. They are also responsible for the network stream. In the case of cement plant - should the client close the plant? As a consultant from McKinsey, I need to find it. As a consultant, you analyze a problem and break it into smaller parts. So, for the above problem, we would try exploring ways to improve sales and cut costs. Ex: To cut costs may be logistics is the biggest factor, so as a consultant we talk to logistic partners of the company. Duties of a consultant as a content ambassador? (Very Important) -           Gather content - research internal databases, research internet, study reports by independent parties, interview experts, interview clients, interview customers, mystery shopping, data analyzing, surveying. -           To create Final product (

Working with docker

Image
Docker Image :  Building a Docker Image  by docker file – includes the build and all the dependencies,  Container : Running the created docker image as a container on the Docker by using run command.  Docker Daemon – The background application which manages building, running and distributing docker containers. Docker Client – The command line tool that helps to interact with docker daemon. Docker Hub : It is a registry(repository) of Docker Images similar to github repositories of branches and projectes. Hence, once a image is build, it can be pushed to the docker hub and can be pulled and run as a container. docker build -t rishoo2019/cheers2019 . docker run -it --rm rishoo2019/cheers2019 docker pull docker images – Displays all the container images present on the docker docker ps = Displays all the containers currently running docker ps -a = Displays all the containers that we ran, also there remanents docker run -it busybox sh Running the run command with the

Working with Git Repositories Using GitHub Desktop

Image
Using GitHub Desktop Clone GitHub repository Open the GitHub Desktop application. In the file menu select clone repository. The popup modal displays the list of repositories accessible in your GitHub. Select the repository and click clone. The desktop application gives you an option to open the cloned repository in VS Code. Read More . Pull GitHub Repository (GitHub Desktop) Inside GitHub desktop to pull the changes from the origin, we set the "Current repository" to GitHub repository we want to pull changes from. Then we set the "Current branch" to "master" or else set the current branch to any specific branch we want to pull the changes from. After selecting the appropriate "Current repository" and "Current branch" we now click “Fetch Origin”. Then after the Origin Fetch has completed we go into the "repository" option in the main menu and click "Pull". This will pull the n

Opting classic row modeling or EAV data modeling?

Few of the circumstances are listed below where EAV scores over conventional tables: ·          The data type of individual attributes varies. Like in above example EAV is used because the requirements vary from client to client like some may want an extra address like added to existing address format. ·          The categories of data are numerous, growing or fluctuating, but the number of instances (records/rows) within each category is very small. Here, with conventional modeling, the database’s Entity-Relationship Diagram might have hundreds of tables: the tables that contain thousands/ millions of rows/instances are emphasized visually to the same extent as those with very few rows. The latter are candidates for conversion to an EAV representation. Other Related Links: EAV(Entity-Attribute Value) Model EAV versus Row modeling Downsides of EAV data model over class row model Opting classic row modeling or EAV data modeling?

Downsides of EAV data model over class row model

Flabbiness : Flexibility is great with EAV, but there will be no structure any longer. Typically, the reliability on the built-in database features such as referential integrity is lost. To guarantee that a column takes values only in acceptable range, integrity check needs to be coded inside the application . Inefficient queries:  In cases where one would be required to execute a simple query returning 20 columns from a single table in classic row modeling technique, in EAV one ends up with 20 self-joins, one for each column. It makes for illegible code and dreadful performance as volumes grow .  Features unavailability : Much of the machinery of modern relational databases will be unavailable and will need to be recreated by the development team. For e.g. System tables, graphic query tools, fine grained data security etc. Other standard tools are much less useful :  Cursors in database functions do not return rows of user data since the data must first be pivoted. U

EAV versus Row modeling

Image
Following are main features/downsides EAV has over classic row modeling technique. A row-modeled table is  homogeneous. I t will always carry same type of data in contrast to  EAV modeled  table where this cannot be an issue. The data type of the value column/s in a row-modeled table is pre-determined by the nature of the facts it records. In contrast, in an EAV table, the conceptual data type of a value in a particular row depends on the attribute in that row. A Row modeling technique data increase only in one direction i.e. from Upside-down whereas in EAV data model data increase in both directions i.e. from upside down as well as from left-right. Other Related Links: EAV(Entity-Attribute Value) Model EAV versus Row modeling Downsides of EAV data model over class row model Opting classic row modeling or EAV data modeling?

Scrum a Agile Approach

Image
Scrum is a software engineering which falls under agile software development. It consists of series of steps and predefined roles. The roles are as follows: Scrum Master is the one who manages the development process Ex: Project Manager. Team is the one who do the analysis, design, implementation, testing etc. Product Owner is one for whom the product is being developed. The scrum follows sprints (short term plans), each sprint lasts between one or four weeks. The sprint consists of set of tasks which are to be completed in a specific time frame. Before each sprint a team meeting takes place and the tasks to be completed in sprint are identified, followed by estimation of total time the each task in sprint may consume to commit. A key principle of Scrum is its recognition that during a project the customers can change their minds about what they want and need (often called requirements churn), and that unpredicted challenges cannot be easily addressed in a tradition