Tag: databases

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.

That time I tried to get a job in Antarctica

Carl Setzer

Back in the mid-80s I came across a job opportunity in Antarctica. An expedition was looking for database managers. I’d just finished up a technical program for Information Processing. I’d built dBase databases, and pushed the information through Lotus, then used Word Perfect and (I think) Pagemaker to build presentations. I note some additional skills, like I’d converted an electronic typewriter so that it was a printer. I could print letter quality docs straight from my PC. In 1986 that was a unique thing.

I had a vision of the whole journey. Very wrong, of course. Laden with naivete. If I’d pulled that off, though…so much would’ve been different. 
I was certain I was a great fit for the job, and that I would get it.

I didn’t get the job. 

Back then, I was lucky to received a typed postcard (perhaps a simple 3 x 5 card) acknowledging receipt. Though I received the “No Thanks” letter a few weeks later, it was still pretty cool. The disappointment strong, yet without bitterness.

Looking back, it’s striking how much job hunting has changed. Starting with research. Now, with Google, I could’ve learned about the lead scientists, the focus of their research; I didn’t even know their names! 

The typed responses tell me they probably processed a handful of applications. I read about this in an article somewhere. There were no online job boards. A job board was, literally, a bulletin board with job postings on it. They evolved to binders in college placement offices, (and other spots, too). Nowadays, with the online job-search eco-system they’d have hundreds, if not thousands of applicants. An upside: the acknowledgement and decline processes should be fully automated. And the larger recruit pool gives them a better chance at finding a more specific skill set. But, still, thousands of applicants…

It’s striking how different life is now. But it doesn’t FEEL that different. Well, not until I look back. Not that much simpler, though, as opposed to the adage air “simpler times”. The complexities were different. I’m happy, for the most part, with the path of our evolution.