Data’s After Life


, , , , , , , , , , , ,

When we are born, a birth certificate is usually created with our Name, Date, Weight, Length, Parents names, location, etc..  It is also at this point that our Health Record begins tracking injections, infections, operations, procedures, prescriptions, reactions…

When / If we join or are entered into some religious group, records are kept of the group name, location, and other pertinent information.  This “membership” will also keep track of events specific to the organization: Bat Mitzvah, Baptism, Weddings, Death notices.

As we proceed through our education, data is collected about where we attended, what courses we took, what grades we achieved and what disciplinary actions might have been taken / necessary.  And there are records for the costs and debts we incur.  Those Student Loan records will follow us forever, whenever, however we try to lose them.

And, again, during our education, we take / make notes on paper or electronically and we retain some of these notes for studying in preparation to take exams where we get Grades and notices from our Instructors about how to improve or maintain our level of achievement

Once we graduate from schools or leave before we might have graduated, we join other communities: The Military, Religious Orders, Jobs of one kind of another.  These events are when the real interesting data events start to unfurl.

Employment records keep track of Titles, Achievements, Income, Employments Benefits and Costs, Taxes (Paid or Owed), Hirings, Firings, Performance Assessments, Remediation Steps taken or suggested, …

Self employment must keep track of Expense, Income, Tax Payments, Deductions and regulatory tax filing whether we are employed or self employed.

While employed we create info in files or on paper reflecting the content and intent of our positions.  Some of these records are stored on our employers’ media since they are “works for hire” and others are retained in files (paper or electronic) in our own locations: file cabinets, folders, baskets, trash bins or hard drives / cloud drives.

Some of us write books, recipes, instructions, blogs, articles, clippings, critiques, editorials.  These materials are retained, published, sold, held for posterity, hoarded.

There are hard drives and manila folders all over the world that contain treasures and trash containing the data of our lives.  There is value and potential wasted time in the content of these files.  But, who uses these values?  What happens to all that learning, discovery, insight, … if no one has access to all this data?

What will happen to your data when you no longer have access to it?

What is the After Life or our Data?  Who could benefit from our information?  Who will benefit from yours once you have no more need of it?


With Great Data, comes Great Opportunity


, , , , , , , , , , , , , ,

There once was a line in a movie: “With Great Power Comes Great Responsibility.”

My take on that is that the more Data we receive, the more Opportunity we get to use that data.

Big Data, the Internet of Things, Business Intelligence and the current evolution in newer, faster, fresher data puts responsibility and opportunity squarely in our laps or IDE’s (Interactive Development Environments) if you will.

What, if anything, are we doing to prepare for these opportunities and responsibilities?

I would really like to hear your thoughts on how we prepare.

The Path To Inkc Profile


, , , , , , , ,

  • How many ways would you be willing to collect income:
    • Full Time Employment with Salary and Benefits?
    • Part Time Employment paid by the Hour or Piece of Work?
    • Signed Master Service Agreement(s) for predefined services, rate and duration?
    • Signed Purchase Order(s) for your product offering(s)?
    • Incorporation of your own new company and the creation of new jobs for yourself and others?
    • Royalty / Investment Income?
  • Do you still think that you only need ONE Source of Income to survive in our current world?

I don’t expect that many people could manage all of these incomes sources (or others), but wouldn’t it be nice if you could maintain two or more of these?  And, IF one of your new income sources were to “dry up” for a time, wouldn’t it be nice that you could have the others to keep you going?

If the answers to these questions intrigue you, reach out to me for an initial free review: William (Bill) Gutches at 610.662.5658 or .

My Social Media Web Presence techniques and Business Planning experiences coupled with your passion for your products and/or services have the potential to get you in a position where two or more of these income sources can be sustained.  Please let me know if you are interested in talking to me about these possibilities.

William (Bill) Gutches ► Social Media ☑ Web and Blog Content ☑ Income Search Coach ☑Business Planning Coach ☑ Contact Info: ☛  ☛  610.662.5658

Testing Centric Life Cycle


, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,

Could there be such a thing as a Testing Centric Life Cycle?

What would it have to look like to be Testing Centric?  Wouldn’t we have to ask questions of each Deliverable to prove that it somehow supports what we believe our end goal to be not knowing all that they might be in the earlier stages?  How would we construct these questions to ask of our Life Cycle Deliverables so that the answers would be good indications of our reasons to proceed?

Imagine if we were to create a Statement of Work for a project intended to build a new business application for an organization.  If we wanted to TEST this SOW, what questions would we ask of it that could help us understand that its content was supportive of our end goals?

It might be possible for us to start asking questions about the Scope described in this Statement of Work:

  1. Does the scope indicate where our input data will be coming from?
  2. Does the scope explain how our product / application will affect the data?
  3. Does it show how the affected data will provide additional value over our inputs?
  4. Can we tell from the scope what external events and/or operators our application will have to respond to?
  5. Can we predict how we will have to maintain the data collected, modified, reported, used to accomplish the intended functions of our product / application?
  6. Is it Orthogonal?  (Not a trick question; read other portions of this blog!)

If we accept the notion that each Deliverable in the path of our project plan must answer questions that relate to its completeness and its alignment with previous deliverables, then the Test Centric Life Cycle Model can be strongly directed by the premise behind Orthogonality:

  • All modeling perspectives MUST be reflected in all Other Modeling perspectives so that when each component and its related model components are removed, nothing remains in any of the models
  • Model perspectives should address, at least, the following disciplines or viewpoints:
    • Event Diagram
    • Process Diagram
    • Data Model Diagram
    • State Transition Diagram

Do you think, dear reader, that this thread of discussion should continue or be dropped?

Please Respond / Comment on this post OR Reply to me at

Thanx, bgbg

Orthogonal Dependencies


, , , , , , , , , , , , , , , , , , , , , , , , ,

  • When an Event occurs that your application must respond to
    • a Process is performed
      • Each Process takes the data from an Event and Stores it in a Data Store
        • Where it’s State is established
  • There are Data States that require your application responds to
    • By Performing a Process
      • Which collects the related Data and makes changes
        • Where the State of the Data records are changed
  • And there are Business Transactions that require your application to
    • Perform a Process
      • That gather relevant Data and makes updates to these Data
        • Where the State of the Data Records are changed

Build a set of models that leave no Event, State, or Transaction without response and you have built a Complete Solution.

Infrastructure Project Management


, , , , , , , , , , , , , , , ,

There could be hundreds or thousands of components to change, migrate, upgrade, affect somehow in an Infrastructure Project.

There might be a very finite list of things to apply to each set of the Infrastructure and these changes will have to be applied in the same manner for each component.

Once you set up a process for applying these changes OR migrating servers, data bases, web apps, etc., this process will need to be repeated with Quality, Precision, Dependency and BOREDOM for each of the components that will be affected.

It would be much more important to manage the BOREDOM than the other aspects once your team gets started making these changes.  Of course, in some cases, you COULD acquire propagation software that would execute a script to make your changes over and over again and, therefore, reduce the BOREDOM.

But, what else could we as Project Managers do to increase the likelihood of consistent, reliable results?

Did you say: “What’s a WalkThrough?”?


, , , , , , , , , , , , , , , , , , , , , , , , , , , , ,

For some, a walk through has to do with looking at a new apartment or house that they are thinking about moving into.  For others, it could be an opportunity to STEP all over somebody else’s work.

For me, many years ago, when Programmers used Coding Pads and had to handle very large decks of cards so they could get their programs compiled for Desk Checking, a Walk Through was a very important part of preparing to write that program along with flowcharting, doing record and print layouts, and trying to figure out just exactly what the user might want considering how little  they would have actually said to me about what they need this program to do for them.

So, a typical Walk Through scenario could be something like this:

  • User wants a new report from an existing file of data
  • User tells programmer’s boss what they need and boss writes down what he/she thinks they asked for
  • Boss calls out to programmer

Watch this space: I’m writing AGAIN!!!


, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,

I just want you all to know that I have started writing again. Recently, I have spent a lot of time NOT writing (did have some other things to take care of, and still do), but it appears I have the bug again!

So, I want to let all of you, my readers, know that I am starting again with new materials AND I also want you to know that I have several blogs I am writing on:

Project Management Handbook:

BG Opinions:

Sixty Somethin:

Please check these out and I hope that you continue to enjoy reading, and please send me your comments or suggestions at or some of my other email addresses for these blogs.

Thanx, bgbg

Wordle me: Business Analyst


, , , , , , , , , , , , , , , , , , , , ,

Check this out…

Wordle: WHG BA Wordle

Thanx, bgbg

On Conceptual Modeling: 1984; Brodie, Mylopolous, Schmidt


, , , , , , , , , , , , , , , , , , , , , , , ,

From a recent review of this book (see Blog Post Title), I have a question:

Main Question:  Is it more efficient to build the indexes in support of invisible keys or to store this same data in each row of a set of tables?

What is an Invisible Key?

A row of data must have fields included that uniquely identify each individual row.  For example, a row in a “Person” data object will be identified by some combination of fields containing: Name, Tax identifier, Country of Origin, Birth Date, etc.  No one of these data fields would be enough to uniquely identify each “Person” in the object, but a combination will usually work well.

Each of these fields has a certain specific size or number of characters allowed at a maximum or absolute size: Birth Date could be represented by the following data pattern: yyyymmdd; whereas the Tax Identifier could be different sizes depending on the Country of Origin.

The notion of Invisible Key is that even though these data fields are used to uniquely identify each row in an object, the specific data values for each row of data, the birth date field, do not have to be physically present in the row in order to find it in a search or inquiry.  As a simple example, let’s use the Birth Date field to describe how this is possible.

The date field, as described above, has 8 characters in it which we should agree can identify each and every Birth Date for the foreseeable past and future.  This statement should be true from January 1, 0000 through and including December 31, 9999.  The dates prior to the first recordable year would need another representation that we will not include in these discussions.  And, the dates beyond December 31, 9999 will need a conversion/expansion similar to the Y2K efforts which some of us may remember.

The allowable values in each of the characters in our Birth Date field are limited to a range of numbers from Zero (0) to Nine (9) only.  If we were to build a data base that would maintain an individual index for each of these data characters so that each of these indices has a list of all data rows that have a Zero in position one, One in position one, Two in position one, etc. through Nine in position one; and repeat these lists for each position in our data field: Position One through Eight, then we can select the lists of indices that we will want to look for in a search:

  • Year 2010 will use a search for:
    • All records where Birth Date Position One equals “2”
      and Birth Date Position Two equals “0”
      and Birth Date Position Three equals “1”
      and Birth Date Position Four equals “0”
    • The result of this search will be a list of all record locations that contain 2010 in the first four positions of Birth Date!

Using this type of inverted list index, we can extract any Birth Date or range of Birth Dates based on the content and record locations in the Indices rather than requiring that that same content be present in each row of data!

As far as the original question, I would like to know how much space would be required to maintain the List Indices for all these data positions versus how much space will be required to maintain these same data in both an index structure AND the data rows themselves.

If we take the inventory of fields proposed earlier and guess at their physical sizes then each row of data represents (and could contain) the following number of characters:

  • Last Name                   Char (25)
  • Middle Name                Char (15)
  • First Name                   Char (15)
  • Country of Origin         Char (25)
  • Tax Identifier               Char (15)
  • Birth Date                    Char (8)

For a total number of positions of: 103 characters.

Multiplying this number of positions by the number of “People” in our data collection could be a staggering sum of physical space in a data object.  For example, ten thousand (10,000) people in an “Employee” data base would require over One Million (1,030,000) characters.  That may not be a ‘staggering’ number but what if we are talking about the “person” data for an Electronic Medical Records data object servicing a National or Global Health Care application?  Three hundred billion people (300,000,000,000) would require almost 31 Giga Bytes (30,900,000,000,000 characters)!  And, this is just for the data values that might need to be indexed.

So what would it take in physical space to represent the indices for these same data fields/values?

The simple truth about THAT is that I don’t know enough about physically building indices to answer THAT question.  Can you?  Please?

The answer to this question, in my opinion, can have a significant effect on the approach and the ability of the technical community to respond to the organizational demands for an ever increasing amount of data for their analytical needs.

“I’m just asking…”