This blog post will provide an overview on the following topics: What is Amazon Redshift? Amazon Redshift Data warehouse Data Warehouse System Architecture Connecting SQL Client to Amazon Redshift Database Connecting to a DB Instance by Running Postgre SQL DB Engine Testing as a part of Amazon warehouse Amazon Redshift – a shift from conventional […]
Innovation + Product Development
Generalization or Specialization? What Makes a Better Developer?
If I want to improve my career as a developer. Would it be better to grow into a very specialized Python guru or a Full-stack Developer? Should I use my time to master a specific programming language? Or should I learn a wide range of languages? Should I become as specialist in a particular topic? […]
Spark as ETL
Introduction: In general, the ETL (Extraction, Transformation and Loading) process is being implemented through ETL tools such as Datastage, Informatica, AbInitio, SSIS, and Talend to load data into the data warehouse. The same process can also be accomplished through programming such as Apache Spark to load the data into the database. Let’s see how it […]
Mobile Automation Test Tool Selection & Framework Library Design
In the last blog (Mobile Automation Test Framework Introduction and Design) we discussed some basic knowledge about automation framework and how to set up a proper automated testing framework. In this article, I will introduce how to select a suitable automation tool and how to design the framework library. First, we need to define some […]
Difficult Choices in Software Development Outsourcing: Choosing an Onshore Freelance Team or a Dedicated Nearshore Team
Highlighting the pros and cons of choosing an onshore freelance team versus working with a dedicated nearshore team in a software development outsourcing engagement. A recent prospective client of ours scratched her head while deciding whether to hire a software team through an on-demand freelance website, or to search abroad for a proper company that she could use […]
Mobile Automation Test Framework Introduction and Design
Mobile devices are becoming more important than ever in our society. The demand for automated testing on mobile APPs is becoming significantly greater than before. This blog will discuss how to set up a mobile automated testing framework that is easy to create test scripts and maintain upon requirement change. First, this blog will introduce […]
Think You’re Ready for Microservices? Here’s What to Consider Before Taking the Leap
?This article first appeared in Information Week. In the ever-changing tech industry, companies know they have to ride some swift rapids to stay afloat. In fact, agility is perhaps one of the most important keys to business success – because if a company takes too long to react to change, a new innovative startup will […]
Contingency Plan vs Mitigation Plan
SAFETY IS NOT A RESULT OF LUCK; IT COMES FROM PREPARATION A Contingency Plan is a designed plan which takes into account a number of possible future events or circumstances where a mitigation plan is the step to reduce adverse effects. That’s still not a clear message, is it? CAUTION IS THE PARENT OF SAFETY […]
NoSQL – CouchDB vs Couchbase
It has been a trend to employ NoSQL database in the modern application system development for either local or cloud platforms. We know that NoSQL stands for “Not the SQL relational database”, but more accurately, it is “Not only the SQL relational database.” NoSQL database can handle structured datasets well in the traditional way, but […]
Migrating Oracle Database into AWS
Oracle Database Migration using Data Pump from an external server into an AWS EC2 instance or RDS You can use Oracle Data Pump for several scenarios in AWS: Import data from an Amazon EC2 instance with an Oracle database to an Oracle DB instance Import data from a database on an Oracle DB instance to […]
How to Facilitate Multiple Oracle Services in One Linux Server
Docker is an open platform that gives customers the ability to deploy multiple o/s containers on any give host. This allows for the deployment of multiple environments without having to incur the overhead of having a virtual machine for each environment. Docker uses Linux o/s facilities like namespaces, groups and union capable file systems to […]
How to Use R Visuals in Power BI
With the evolution of cloud technology, more organizations are planning to move their BI platform to cloud such as Azure or AWS. In Azure, PowerBI is pretty straightforward and popular, and with Power BI Desktop, you can perform analytical and statistical analysis and create compelling visuals by integrating with R. You can host those R […]