Remote DBA Expert Understands The Importance Of Choosing Database For Analytics

Wazzup Pilipinas!

Whenever the analytics questions run into edges of latest tools, it is time to head towards database for analytics. It is not a clever idea to construct scripts to query production database. Chances are high that you might delete vital info accidentally if you have engineers or analysts poking around over there. At that point, you need separate form of database for analysis. Which is the right one to choose?

While working with lots of customers to get DB up, the most interesting criteria are the amount of data you possess, type of data to analyze, focus of your engineering team and how fat you need it.

Types of data for analyzing:
Check out for the data you are planning to analyze. Will it fit well into columns and rows or would it be more appropriate into Word Doc? When it comes to Excel, relational database like MySQL, Postgres, Amazon Redshift or even BigQuery might be the ones to consider.

These are relational structured databases, which are amazing when you are aware of the data to receive and how it might links together. It basically works on ways in which rows and columns relate.

For major user analysis, relational database will be the perfect one for you. Some user traits like emails, names and billing plans will get nicely into table just like user events and the significant properties.

In case, the data fits better on paper, you might have to check for non-relational database or NoSQL like Mongo or Hadoop.

The non-relational ones work well with larger data points of semi-structured plans. Some classic examples of semi-structured data are social media, email, books, audio and visual aids, and even geographical data.

In case you are working on larger amount of text mining, image or language processing, you may have to visit non-relational data stores. You can get information on that from RemoteDBA.com now.

The amount of data to work with:

You need to know the amount of data you are planning to get hands on. The more amount you have, the non-relational database will be the most helpful option for that. NoSQL is not going to impose any kind of restraints on incoming data, which will definitely allow you to write a lot faster.

For <1TB, you can use Postgres MySQL. Then you have Amazon Aurora for 2TB – 64TB. Amazon Redshift and GoogleBigQuery are the major databases for 64TB to 2PB. And lastly you have Hadoop for covering all the data sizes as mentioned right now.

Well, there is no strict limitation as each database can handle an amount depending on multiple factors. For under 1TB data, Postgres helps in offering a good performance ratio price. But it might slow down around 6TB.

In case, you are looking for MySQL but with a bit more upscale, you have Aurora, which can go up to 64TB. In case of petabyte scale, Amazon Redshift is the best bet as it can be well-optimized for running analytics for up to 2PB.

In case, you are looking for parallel processing or more MOAR data, you can always try out for Hadoop.

The focal center of your engineering team:

Another important question asked by experts from RemoteDBA.com during database discussion is to check on the engineering team and its focus center. The smaller this team might get, the higher are your chances to need engineering focusing on building product and not on database management and pipelines. The number of people dedicated to work on your project will affect your options more.

With engineering resources, you have vast array of choices. You can either opt for non-relational or relational database. Relational DBs are likely to take less time for managing when compared to NoSQL.

If you have engineers working on setup but cannot find any help with the maintenance, you can focus on using Google SQL, Postgres or even Segment Warehouse any day over Aurora, Redshift or BigQuery.

When you have enough time in hand for maintenance, then you can select BigQuery or Redshift for faster queries at larger scale.

Relational database covers another advantage. SQL can be used for query. SQL is known among engineers and analysts and quite easier to learn when compared to other programing languages.

Moreover, running analytics on semi-structured data will require object oriented programming based background or a code based science background.

With some recent inventions of analytics tools like Hunk or Slamdata, analyzing such database types will always need help of an advanced data scientist or analyst.

How fast you are in need of data:
Even though real time analytics is quite popular nowadays for covering cases like system monitoring and fraud detection, moist analyses will not even need real time data or even immediate insights. Whenever you are answering questions like what causes users to churn or how people are currently moving from app to website, accessing data with slight lag is more or less ok. Your data won’t change every minute.

So, if you are planning to deal with after-the-fact analysis, you have to go for database as designed under hood for accommodating larger data amount and to read and join data quickly. That will make queries work faster than usual.

This step might also load data fast reasonably only if you have someone resizing, vacuuming and even monitoring the cluster.

In case you are direly in need of real-time data, you have to check for some unstructured database, such as Hadoop. You can easily design that database for loading rather quickly even when queries can take long time to scale, based on RAM usability, disk space availability and how the data has been structured.

Once you are sure of the right database to use, it is important to figure out ways to get you data involved with database. It is hard for newbies to actually build scalable data pipeline. That’s why experts are always down to offer some crucial help. It takes time to find the right team, but once available, their services are worth it.

Get a Grip on Your Phone with PopSockets

Wazzup Pilipinas!

The hit mobile phone grip is now available in the Philippines.


The PopSockets Story

In 2010, Philosophy professor David Barnett had a problem: when getting his groove on listening to music on his phone, his earphones got tangled. In a moment of genius, he glued a button to the back of his phone to keep the cord neatly wrapped – this was the moment when the seed for PopSockets was planted. Fast forward to today, that simple button had expanded into a simple device that really did work great as a cord wrap, but also as a handy phone grip and a phone stand too.


So What’s A PopSockets Grip?

It’s that simple thing you never knew you needed but now can’t live without. PopSockets Grip offers a secure grip for texting or snapping that perfect selfie, and propping your phone up for catching the latest video. Double PopSockets Grips are great for competitive mobile gamers who want a solid grip on the base of their phone to put their twin thumbs into action. They are also a great tool to store untangled earphones by simply winding them over the knobs. With the PopSockets Mount, you can hang your phone just about anywhere. Your PopSockets Grip slides easily into the Mount for hands free function while driving, video chatting and more.

It may have started out of David’s garage but PopSockets soon became a commercial success. It is a huge hit with many fans including celebrities such as Kendall and Kylie Jenner, Fifth Harmony, Serena Williams, Gigi Hadid, Jared Leto and Michael Phelps. The company has sold over 35 million PopSockets Grips and Mounts in 2017 and is on track to double that number to 70 million this year, including its expansion into the Philippine market.


PopSockets are phone grips and stands that are collapsible, customizable, and re-positionable. PopSockets have over 100 designs priced at PHP 499 for the original designs, PHP 749 for the licensed designs (such as Harry Potter and Marvel) and the designs that are made of premium materials such as leather, metal and wood.

PopSockets Grips have over 100 various original designs priced at P499. It is also available in designs made with premium materials such as Vegan Leather, Metal and Real Wood for P749. Licensed designs from well-known franchises such as Harry Potter and Marvel, which will be available in the next coming months, are also priced at P749. PopSockets also offers combo pack comprised of 1 black PopSockets Grip and 1 mount for only P749. You can also purchase PopSockets Mounts on its own for P499.
PopSockets is now available at leading local retail stores Urbanize, Elecom, Bratpack and, Rustan’s Department Stores. For more information about PopSockets, follow us on Facebook and Instagram @PopSockets.PH

EURO-II Option Enhances Competition Among Oil Players

Wazzup Pilipinas!

Department of Energy Secretary Afonso Cusi again clarified that the Department’s directive for oil companies to provide Euro-II compliant diesel fuel - is meant to provide a cheaper diesel alternative, particularly for those operating older vehicles in the public transport sector.

“The DOE is actively finding ways to help control inflation. Bringing in Euro-II compliant diesel fuel gives our countrymen an additional option. Euro-II diesel matches diesel engines without the catalytic converter. These are usually the 2015, 2014 and earlier models of vehicles,” Sec. Cusi said.

In particular, the Energy Chief said those owning older vehicle models from 2015 below, particularly in the transport sector, would benefit from additional savings that the Euro-II diesel fuel would provide.

“With rising prices, each centavo of savings counts,” Sec. Cusi noted.

To ensure proper implementation of the Energy Secretary’s directive, the DOE-Oil Industry Management Bureau (OIMB) required all oil companies to submit their respective implementation programs by the 24th of August 2018.

In their respective implementation plans, the oil companies are expected to indicate the participating retail outlets, the date of intended implementation and other related information for the provision of an additional diesel fuel alternative.

Likewise, the DOE assured consumers that it would continue the stringent monitoring of the quality of fuels being sold in the country.

"We empower our consumers when we give them the ability to choose. We are enhancing the competition among the suppliers. This is what the Euro-II diesel option is all about,” Sec. Cusi said.