PostgreSQL Performance Monitoring

VividCortex is the easiest, safest, and most detailed way to monitor PostgreSQL. Unlike other tools that just capture a few status metrics or check that a SELECT 1 query executes OK, VividCortex measures every query, every process, and every metric on your entire system, down to the microsecond, in industry-leading 1-second resolution, with no performance impact to the system itself.

Spark Streaming Programming Guide

Spark Streaming is an extension of the core Spark API that enables scalable, high-throughput, fault-tolerant stream processing of live data streams. Data can be ingested from many sources like Kafka, Flume, Twitter, ZeroMQ, Kinesis or TCP sockets can be processed using complex algorithms expressed with high-level functions like map, reduce, join and window. Finally, processed data can be pushed out to filesystems, databases, and live dashboards.

Drill Down to Ask Why, Part 1

Suppose that you work for an airline as a fare planner.

.. Imagine five ways in which the fare planner might ask why. I’ll arrange these in order of increasing breadth and complexity:

  1. Give me more detail. Run the same yield report, but break down the high-level routes by dates, time of day, aircraft type, fare class and other attributes of the original yield calculation.
  2. Give me a comparison. Run the same yield report, but this time compare to a previous time period or to competitive yield data if it is available.
  3. Let me search for other factors. Jump to nonyield databases, such as a weather database, a holiday/special events database, a marketing promotions database or a competitive pricing database to see if any of these exogenous factors could have played a role.
  4. Tell me what explains the variance. Perform a data mining analysis, perhaps using decision trees, examining hundreds of marketplace conditions to see which of these conditions correlates most strongly with the drop in yield (explaining the variance in data mining terminology).
  5. Search the Web for information about the problem. Google or Yahoo! the Web for “airline yield 2008 versus 2007.”

 

How Companies Can Use Sentiment Analysis to Improve Their Business

If you have 1 to 10 articles, the most effective way to measure sentiment is to simply read them. But what happens if you have 50,000? This is where automated sentiment can provide some directional insight and set the tone for further analysis.

.. You should aim to uncover important phrases like “bad quality,” “crashes too often,” and “won’t start.” This can and should affect your product design, customer service, marketing messaging and social media outreach. Can you discover if there are particular influencers driving the negative conversation and do anything to reach out to them?

.. If you need to neutralize the mentions that hurt your brand the most, you should drill down into negative mentions, identify the content coming from the most influential people in your industry, understand how far each tweet traveled, and how many people were impacted by this content.

.. The Holy Grail of Social CRM is the ability to close the analytical loop between publicly expressed sentiment, engagement action, subsequent purchase intent, and ultimately, product purchase.

.. Because you now have a history on this person, and your system cross-references his/her social media profiles across several platforms, you are able to track this person’s affinity and sentiment towards your brand over time, monitor their purchase intent, and note their influence on others’ purchase decisions.