Tag: data

The Business of Data

Carl Setzer

This quarter I’ve heavily focused on data. Of my three classes, one is on SQL and another is focused on database theory and design. As part of the theory and design class, I’ve been thinking a bit about Business Intelligence (BI) systems.

What are BI systems?

Business Intelligence Systems are tools that enable management (and other people) to analyze business activities. This includes past and current activities. Additionally, these tools are extremely valuable in predicting future behavior. They enable organizations to assess their effectiveness, strategize and plan for the future, as well as control various elements of the business. Ultimately, their function is to assist and guide decision-making. 

How do BI systems differ from transaction processing systems?

Transaction processing systems, aka: operational systems, facilitate and monitor primary business operations such as sales, purchasing, and inventory control. They are involved in the ongoing stream of daily business operations. Operational systems are, generally, the core program of the business. 

Business Intelligence Systems focus on management’s decision-making and analysis needs. Often, BI systems are disconnected from operational databases. BI systems pull their data from three possible sources:

  1. From the data within the operational database. However, they do not modify, insert or delete the operational data. It’s critical that analytics remain separate from the operational system. 
  2. From data that have been extracted from the operational system. This database might be completely different from the operational, including being a different DBMS, or even a non-database tool like Excel.
  3. BI systems can also analyze data purchased from third-party data vendors. 

I am finding data systems to be incredibly fascinating. Though it is one of the “areas of the future”, that’s not the whole thing. I see how valuable data is to, well, everyone. There are so many ways to benefit any organization and so many ways to misuse it.

DNA, Technology and Unintended Consequences

Carl Setzer

From Wired Magazine: “There’s No Such Thing as Family Secrets in the Age of 23andMe”

This looks at the fascinating intersection of biological tech with democratized data, laden with so many “unintended consequences” in the DNA market (is it right to call this a “market”?).

I believe there was no way to guess these issues would come up when humanity first developed medical insemination. DNA databases and the commodification of DNA data: I doubt we could’ve guessed this coming about 10 years ago, much less in the 1970s.

Many, many questions, so few answers. The way forward seems murky. I guess it always is.

Packet Transfer

Carl Setzer

Drifting, tired,
Mind wandering aimlessly,
Pointlessly, disjointed thoughts colliding,
Packets of disconnected data
Glance off each other,
Ultimately unimpacted,
Though perhaps slowed.

Data Saturation and Sanity

Carl Setzer
pile of covered books

I, like so many others, have hit the wall: data overload. There’s SO much out there, interesting and readily available. Free, or so for all practical intent; very few barriers. Not too long ago, price helped keep this in check. Our resources to spend on magazines, newspapers and the like naturally limited out data-stream. Yes, we had free at libraries, but content was still limited (by the fiscal concerns of libraries as well as any particular mag being used or destroyed by another patron) and there was the time commitment. Clearly the topography has changed.

Content commodified: for creatives, this might be horrifying. I have a bit of that reaction. But this condition needs to drive a focus on quality. We content creators need to create the best stuff we can. And be aware of the subjective nature of “best”.

But “best” can still be buried within a sea of adequate. The tools for navigating this are still being crafted. I consider the hundreds of email I delete a day. All those newsletters I subscribed to. I’m interested in them, value the quality, yet am pushed past my time limits and am simply stuck. Then there’s my Google reader steam I haven’t so much as looked at in ages. And social media? Besides Facebook, I’m not trying to keep up with everything. I can’t read every Tweet. And I don’t have thousands in my stream. Much less Google+, Quora, LinkedIn, et masse. Nope: no keeping up with all of this without sacrifice.

I haven’t come close to mastery. Though I’ve explored ideas, from Franklin-Covey to Getting Things Done…still the feeling remains. Ignoring streams isn’t a satisfying solution. I tend to binge and purge.

What about you? You got this down? How go you triage your data-stream?