The Truth, the whole Truth, and Nothing But the Truth

PDFPrintE-mail

Almost everyone has had some experience during which two or more people have been working on the same task at the same time.  In such cases, it is often hard to determine who has the “master copy” of the project, and changes made by one individual can easily get lost or overwritten by changes made by someone else working on the same thing.  If, for example, you and I are both given the same spreadsheet and told to perform some analysis and report on the results, it would be very difficult to combine both of our changes and different calculations after the fact to create a single report, and we would likely come up with different conclusions.  Now imagine that we are not working with a spreadsheet, but with millions of pieces of data across an enterprise, and there are not only you and I, but hundreds of other individuals and systems manipulating the data, all at the same time.   Because situations like this happen every day within large organizations, it is of utmost importance to establish a comprehensive trusted source of data in order to maintain systems that are complete, consistent, and correct. An organization will have established a trusted source of “master” data across the enterprise when its information systems provide a single version of every item of shared data that is consistent with the rest of the data in the system – and when everyone who needs a data item knows where to go to find that authoritative version.  While establishing such a trusted source is extremely important, there are obstacles and challenges that threaten the trusted source in numerous ways:
  • A user may be confronted with conflicting information from different sources and not offered any help in interpreting or resolving the differences.  Worse, the user may happen on one version of the data, never suspect that different (and perhaps truer) versions exist, and make decisions based on inaccurate information.
  • The information obtained by a user is often incomplete, because the missing information is stored in a system that is “too many clicks away” from the portal through which the user is accessing the data.
  • There is a lot of redundant data entry.
  • Sources sending information into the enterprise database often have conflicts.
  • Attempts to achieve a single trusted source by multi-directional synchronization of independent databases (containing, for example, order and return information) present the danger that timing problems may cause valid data to be overwritten by invalid data.
Even if a database contains a single definitive copy of all the data, those data are of no use unless the user application’s interface and other user aids enable people to find the information they need, when and where they need it.  The master database needs accurate, legible, documented, understandable, and up-to-date models to support the development of user interfaces and aids that make this data available to its users. Finally, once a user has obtained the one true version of some piece of data, one more thing has to happen to turn the data into valid and valuable information:  The user must accurately understand what it means.  Standardizing procedures and processes across the enterprise can help an organization to ensure that users understand the data:
  • Standard codings, terminology, and classifications for crucial shared entities (accounts, projects, etc.) need to be developed, adopted and put into common use.
  • Time-tagging data items can prove useful in informing users how up-to-date they are.
  • Educating new users of an application (and educating current users of a changing application) on the meaning and timeliness of the information they will be obtaining through that application is an essential component of maintaining the integrity of the database and the enterprise.

Finding the single source of truth

With the proliferation of silos and channels comes the problem of knowing whose version of the “truth” is correct: where did it originate, and how trustworthy is it? The first part of any information management effort should be to ascertain the owner and original source of each type of data in an information flow. Only this “single source of truth” should be accessed for that data by all the other organizations in the system. It is also important to pay attention to the management of metadata and master data to improve transparency into the lineage and quality of data.  Organizations need to consolidate systems that provide data for similar business processes, identifying and resolving duplicate data and incomplete data, so that data is entered and updated consistently in one place...the single source of truth.

Add comment


Security code
Refresh

Email Newsletter icon, E-mail Newsletter icon, Email List icon, E-mail List icon Enter your email address to sign up for our Newsletter

Sign up now

captcha
TEChanges - Agility by Design

January Puzzle

A traveler gets lost on a deserted island and finds himself surrounded by a group of n cannibals.

Each cannibal wants to eat the traveler but, as each knows, there is a risk. A cannibal that attacks and eats the traveler would become tired and defenseless. After he eats, he would become an easy target for another cannibal (who would also become tired and defenseless after eating).

The cannibals are all hungry, but they cannot trust each other to cooperate. The cannibals happen to be well versed in game theory, so they will think before making a move.

Does the nearest cannibal, or any cannibal in the group, devour the lost traveler?

Show solution...

Solution

The short answer is the traveler’s fate depends on the parity of the group. If there is an odd number of canibals, the traveler will be eaten, but if there is an even number, the traveler will survive.

To prove this, we will consider small groups and use mathematical induction to explain the solution for larger groups.

Case n = 1: this is an obvious case. If there is one cannibal, the traveler will be eaten. It doesn’t matter that the cannibal will get tired because there are no other cannibals around as a threat.

Case n = 2: this is a more interesting case. Each cannibal wishes to each the traveler, but each knows he cannot. If either cannibal eats the traveler, then he will become defenseless and the other one will eat him. So each cannibal uses backwards induction to realize that the only strategy is to not eat the traveler. The hapless traveler finds a bit of luck, therefore, and actually survives.

Case n = 3: this is where the problem gets interesting. The best strategy is for the closest cannibal to make a move and eat the traveler. The cannibal will be defenseless after eating, but ultimately he will be safe. Why is that? The reasoning is due to induction: once the cannibal eats the traveler, the resulting situation has 2 unfed cannibals and the 1 defenseless cannibal. But as we just showed above, when there are 2 unfed cannibals, neither will make a move for fear of being eaten by the other! Thus the first cannibal to make a move will be safe as the remaining 2 cannibals block each other.

We can prove the higher cases using mathematical induction. If the number n is odd, then the closest cannibal can safely eat the traveler because the remaining number of unfed cannibals is even (and by induction, with an even number of unfed cannibals no one makes a move). If the number n is even, then no cannibal will eat the traveler, for if he did, the remaining number of cannibals would be odd, meaning he will get eaten by the induction hypothesis.

Success Tips for Oracle Project Management

  • Create a standard for documentation at the beginning of your project, and hold team members accountable for completing documentation requirements as well as keeping them at and above the standards required.
  • Before promulgating user documentation or training, it’s also a good idea to choose a representative from the among the business users base to review materials first.
  • If you are not sure about the resources and budget required, obtain several estimates from people that have experience with the same size and scope of your project.
  • Be explicit, before beginning the project, what internal resources are required for execution. This includes people, infrastructure, hardware, and software.
  • Help the project champion understand the impact your project will have on the organization and how its successful completion will make him or her an internal hero or heroine for supporting it.
  • Break up your project into smaller projects (try for projects that can be completed in 4-6 months, especially early on) to get success and demonstrate momentum.
  • Make sure that your testing includes reports, upstream and downstream interfaces, customizations, enhancements, and workflows.
  • Ensure that comprehensive transition reports and meetings between departing and incoming personnel are completed.
  • Instead of spending time and resources implementing third-party reporting, consider consolidating multiple instances, moving to a global chart of accounts (CoA), and/or standardizing on a consistent calendar.
  • Include governance, risk, and compliance management as part of the project plan.
  • Finally, celebrate the successes. Too many projects focus on defects, failures, or small cost over-runs without looking at the big picture and what was accomplished.

The Analyst Corner

John Van Decker, Research VP of Gartner, states:

"A single chart of accounts allows consistency in financial reporting across the enterprise by standardizing on common metrics and reporting structures, reduces dependencies on a separate financial consolidation system, and significantly reduces the costs incurred with ongoing, complex conversions and translations."