Home > Articles > Software Development & Management

Like this article? We recommend

Today's Answers

How the 5 Questions are answered in today's world of corporate information varies to some degree based on the emphasis an organization places on the information. For example, organizations that place substantial priority on research and its resulting product development, inventions, or industry breakthroughs always make research data, its conclusions, and the required documentation well organized and available. Generally, these organizations have research libraries that are managed and controlled by librarians well versed in the cataloguing and retrieval of research data. Even when the research data is in a variety of formats (text documents, statistical studies, and application databases), the librarians generally know where everything is and have search mechanisms, including at least a company intranet.

Answers to the 5 Questions get a bit more complicated once a research effort results in product development. The types of data that we track and the reasons that we track them vary immensely. Using the pharmaceutical industry as an example, no longer are the scientific experiments the sole domain of the scientists, but the results now move into clinical trials and may become part of a drug's marketing package. Federal law requires specific information (for example, type of research, profiles of participants, length of trials, and specific results) to support the drug approval process and to be available for inclusion in packaging of approved drugs. Consider the twist of purpose for the research data once the resulting drug (pharmaceutical product) is manufactured and marketed. Consider also how the original research data looks when it becomes part of the marketing information collection. Finally, consider how easy or hard it would be to include this information as part of the answer to Question 1, "What data do we have?" Most pharmaceutical organizations re-create the data, or minimally copy it over with each phase of the drug development process—new purpose, new software, new database, ... new metadata?

What about organizations that do not have a research arm? Consider retailers without manufacturing, whose products are acquired from wholesalers or are packaged only within the retail organization. The eventual product line may not represent the items purchased from the supplier (wholesaler, distributor, manufacturer). The typical order-entry system contains the full array of products, with variations (colors, sizes, shapes, and so on) and pricing options (single unit, altered unit, customized unit, bulk orders, and so on). If an item is for sale, the data surrounding the sale is available ... or is it? In the domain of the order-entry system, the data a user or customer wants is available. Again, remember that information and data can be distinct and variable. If the results of this order-entry system were going to be captured for the purposes of decision support, however, some of the required information (for example, answers to the remaining four questions) would not be obvious. Furthermore, depending on the purpose of the information gathering, some information requirements may constitute information above and beyond the data itself (consider the fourth question, "How did it get there?").

What if I am a developer looking for the specifics on how to translate order-entry data to meet the needs or demands of the customer, whether an individual or a commercial customer? Generally, answers to the 5 Questions share similar qualities. They are narrowly focused and address the perspective of the individual or group that supplied the answers. Even within data management organizations, the answers to these questions reflect a narrowed scope based usually on the inability to physically address specific islands of data (depending on, for example, their physical platforms or surrounding software packages). Ironically, even data management organizations that implemented metadata repositories, data dictionaries, or information directories restricted the boundaries of coverage in most cases. These efforts, originated in the IT department, are usually not geared toward business users' requirements, access, or relevance.

Tunnel vision is also obvious when we address the answers to each question from the viewpoint of today's information implementations.

What Data Do We Have?

A true answer to this question would result in a card catalog of an organization's data organized by major subject area. In today's common implementations, business users are forced to go right to the data they seek via shortcuts on their screens. But if there is a need to go beyond that immediate scope (and there always is), generally phone calls are the only way to find out exactly what other data is available.

What Does It Mean?

If an organization is progressive and methodical, a "data dictionary" is created by documenting each data element at the time it is defined, which typically happens during a data modeling phase, but this represents an ideal situation. Many organizations purchase data processing or information management software and have no data planning or data management function associated with its installation. Likewise, the definition of the data elements within the package is left to off-the-shelf vendor values. The majority of organizations, however, do not have data dictionaries. In these scenarios, the details behind the data elements are typically tracked individually (by the business users or by the developers). Many databases start springing up, each containing a miniworld of metadata, ranging from data element names and definitions to data tracking documentation, many of which include substantial information about the source of the data. In reality, many organizations do not have official databases that track these things; as a result, many "databases" are implemented, each of which represents a particular perspective of the data's meaning, and none of them maintained from a global or central framework.

Where Is It?

The answers to this question depend directly on what "it" is that we are looking for and who we are. The answers also depend on what organizations are aware of in terms of data and how easy it is to find it. Since client/server computing took the reins off controlled data definition and storage, it is virtually impossible to locate all of it. For example, if "policy" data is not associated with a "policy" term, the only way to find all policy data is to look for it after all data has been categorized manually. Of course, computer search engines will find instances of the word policy in all kinds of data stores, but they have to be there. In today's corporate world, the answers to the question can vary depending on the type, location, and name of the data.

Type of Data

Ironically, it is fairly easy to find nonoperational data such as documents, application programs, and presentation graphics, assuming that the names are reasonable and the contents contain the main qualifier. Operational data, which is generated by transactions and the supporting processing, is typically located based on its identity. Unfortunately, the names of these data elements can range from accurate logical business names to short, programmer/DBA–developed identifiers to software package vendor identifiers. Based on this common problem, many "scanners" now exist that search physical data stores based on contents.

Location of Data

Where data is determines how easy it is to find. If it exists in a structured database that has its own metadata-based directory and that is accessible via a shortcut on everyone's desktop, then, sure enough, it will be found. If it is sitting in a privately developed desktop database that resulted from one business user's design and requirements, it may never show up in anyone's search. If it is on another server that can be remotely accessed and it has a common term as part of its name, it may turn up in an access query. Finally, if it is a specific type of file with its own access procedure, as populated in a standard model (see Figure 3), it will be located. Only you know how likely these situations are in your organization, but, unfortunately, not everyone who looks for data understands that, even though data exists, it may never be found.

Data Association/Data Naming

Of course, if the data you are looking for concerns customer addresses and it is named "Party Location," how likely is it that you will find it? Without predicting odds, organizations geared toward data location and fulfillment usually offer sets of standard names and aliases as well as standard subject-area categories to help identify data that may not have obvious names. Again, if the rules exist but they are not followed, or people are not even aware of them, the effort results in more harm than good. One of the worst things that can happen is the return of a subset of information when the receiver is not aware that he or she is seeing a subset.

How Did It Get There?

The answer to this question can be extremely simple or very broad. What one will never know, however, is whether a simple answer should really be broader. The advent of data warehousing began to put much emphasis on the "source" of data, yet, in most major corporations, "data webs" have existed for quite some time, in many cases unbeknownst to the data analyst or documenter. The answer to this question is often restricted to the amount of information capable of fitting into a predetermined and presized Source field. If a particular data element has more than one source, it is up to the documentation specialist to determine how to report all of them or, in most cases, to choose the most recent source of that data element. In neither scenario does the information do any good for the data recipient because the true beginnings of the data are never documented. As a result, the business analyst will never know, for example, that "Gross Income" started from the Accounting System and was then massaged three times through three different accounting spreadsheets before it reached the report being documented

How Do I Get It (Go Get It for Me!)?

Because information gathered in response to this question is often either supplied by a technical person or is a "freebie" (that is, software provides the capability), this is probably the only question that appears to be answered accurately on all accounts. As mentioned earlier, operating systems are typically based on an underlying model that provides point-and-click access to anything that has been defined consistently and in conformance with certain rules (see Figure 3).

Ironically, however, the more accurate this answer is, the less likely it is to be of service. This is the reason the question is answered to begin with. Historically, if someone looked for and actually found data, the way it was found was important. In today's world, however, someone can receive data without any idea how it was accessed. In fact, the route to the data is often "hidden" or "included" as part of the software being used to locate the data. Only when we cannot find the data or, more often, have no choice as to what data to use or what software to assist with the location process, do we always make a point of learning how to access it. More and more organizations and vendors are focusing on documenting the path to and method of obtaining data. Nevertheless, in most scenarios, the resulting documentation represents an isolated subset of the 5 Questions or all of the five questions for an isolated group of data (see Figure 4).

Figure 4 Viewing the Five Questions in isolation.

InformIT Promotional Mailings & Special Offers

I would like to receive exclusive offers and hear about products from InformIT and its family of brands. I can unsubscribe at any time.

Overview


Pearson Education, Inc., 221 River Street, Hoboken, New Jersey 07030, (Pearson) presents this site to provide information about products and services that can be purchased through this site.

This privacy notice provides an overview of our commitment to privacy and describes how we collect, protect, use and share personal information collected through this site. Please note that other Pearson websites and online products and services have their own separate privacy policies.

Collection and Use of Information


To conduct business and deliver products and services, Pearson collects and uses personal information in several ways in connection with this site, including:

Questions and Inquiries

For inquiries and questions, we collect the inquiry or question, together with name, contact details (email address, phone number and mailing address) and any other additional information voluntarily submitted to us through a Contact Us form or an email. We use this information to address the inquiry and respond to the question.

Online Store

For orders and purchases placed through our online store on this site, we collect order details, name, institution name and address (if applicable), email address, phone number, shipping and billing addresses, credit/debit card information, shipping options and any instructions. We use this information to complete transactions, fulfill orders, communicate with individuals placing orders or visiting the online store, and for related purposes.

Surveys

Pearson may offer opportunities to provide feedback or participate in surveys, including surveys evaluating Pearson products, services or sites. Participation is voluntary. Pearson collects information requested in the survey questions and uses the information to evaluate, support, maintain and improve products, services or sites, develop new products and services, conduct educational research and for other purposes specified in the survey.

Contests and Drawings

Occasionally, we may sponsor a contest or drawing. Participation is optional. Pearson collects name, contact information and other information specified on the entry form for the contest or drawing to conduct the contest or drawing. Pearson may collect additional personal information from the winners of a contest or drawing in order to award the prize and for tax reporting purposes, as required by law.

Newsletters

If you have elected to receive email newsletters or promotional mailings and special offers but want to unsubscribe, simply email information@informit.com.

Service Announcements

On rare occasions it is necessary to send out a strictly service related announcement. For instance, if our service is temporarily suspended for maintenance we might send users an email. Generally, users may not opt-out of these communications, though they can deactivate their account information. However, these communications are not promotional in nature.

Customer Service

We communicate with users on a regular basis to provide requested services and in regard to issues relating to their account we reply via email or phone in accordance with the users' wishes when a user submits their information through our Contact Us form.

Other Collection and Use of Information


Application and System Logs

Pearson automatically collects log data to help ensure the delivery, availability and security of this site. Log data may include technical information about how a user or visitor connected to this site, such as browser type, type of computer/device, operating system, internet service provider and IP address. We use this information for support purposes and to monitor the health of the site, identify problems, improve service, detect unauthorized access and fraudulent activity, prevent and respond to security incidents and appropriately scale computing resources.

Web Analytics

Pearson may use third party web trend analytical services, including Google Analytics, to collect visitor information, such as IP addresses, browser types, referring pages, pages visited and time spent on a particular site. While these analytical services collect and report information on an anonymous basis, they may use cookies to gather web trend information. The information gathered may enable Pearson (but not the third party web trend services) to link information with application and system log data. Pearson uses this information for system administration and to identify problems, improve service, detect unauthorized access and fraudulent activity, prevent and respond to security incidents, appropriately scale computing resources and otherwise support and deliver this site and its services.

Cookies and Related Technologies

This site uses cookies and similar technologies to personalize content, measure traffic patterns, control security, track use and access of information on this site, and provide interest-based messages and advertising. Users can manage and block the use of cookies through their browser. Disabling or blocking certain cookies may limit the functionality of this site.

Do Not Track

This site currently does not respond to Do Not Track signals.

Security


Pearson uses appropriate physical, administrative and technical security measures to protect personal information from unauthorized access, use and disclosure.

Children


This site is not directed to children under the age of 13.

Marketing


Pearson may send or direct marketing communications to users, provided that

  • Pearson will not use personal information collected or processed as a K-12 school service provider for the purpose of directed or targeted advertising.
  • Such marketing is consistent with applicable law and Pearson's legal obligations.
  • Pearson will not knowingly direct or send marketing communications to an individual who has expressed a preference not to receive marketing.
  • Where required by applicable law, express or implied consent to marketing exists and has not been withdrawn.

Pearson may provide personal information to a third party service provider on a restricted basis to provide marketing solely on behalf of Pearson or an affiliate or customer for whom Pearson is a service provider. Marketing preferences may be changed at any time.

Correcting/Updating Personal Information


If a user's personally identifiable information changes (such as your postal address or email address), we provide a way to correct or update that user's personal data provided to us. This can be done on the Account page. If a user no longer desires our service and desires to delete his or her account, please contact us at customer-service@informit.com and we will process the deletion of a user's account.

Choice/Opt-out


Users can always make an informed choice as to whether they should proceed with certain services offered by InformIT. If you choose to remove yourself from our mailing list(s) simply visit the following page and uncheck any communication you no longer want to receive: www.informit.com/u.aspx.

Sale of Personal Information


Pearson does not rent or sell personal information in exchange for any payment of money.

While Pearson does not sell personal information, as defined in Nevada law, Nevada residents may email a request for no sale of their personal information to NevadaDesignatedRequest@pearson.com.

Supplemental Privacy Statement for California Residents


California residents should read our Supplemental privacy statement for California residents in conjunction with this Privacy Notice. The Supplemental privacy statement for California residents explains Pearson's commitment to comply with California law and applies to personal information of California residents collected in connection with this site and the Services.

Sharing and Disclosure


Pearson may disclose personal information, as follows:

  • As required by law.
  • With the consent of the individual (or their parent, if the individual is a minor)
  • In response to a subpoena, court order or legal process, to the extent permitted or required by law
  • To protect the security and safety of individuals, data, assets and systems, consistent with applicable law
  • In connection the sale, joint venture or other transfer of some or all of its company or assets, subject to the provisions of this Privacy Notice
  • To investigate or address actual or suspected fraud or other illegal activities
  • To exercise its legal rights, including enforcement of the Terms of Use for this site or another contract
  • To affiliated Pearson companies and other companies and organizations who perform work for Pearson and are obligated to protect the privacy of personal information consistent with this Privacy Notice
  • To a school, organization, company or government agency, where Pearson collects or processes the personal information in a school setting or on behalf of such organization, company or government agency.

Links


This web site contains links to other sites. Please be aware that we are not responsible for the privacy practices of such other sites. We encourage our users to be aware when they leave our site and to read the privacy statements of each and every web site that collects Personal Information. This privacy statement applies solely to information collected by this web site.

Requests and Contact


Please contact us about this Privacy Notice or if you have any requests or questions relating to the privacy of your personal information.

Changes to this Privacy Notice


We may revise this Privacy Notice through an updated posting. We will identify the effective date of the revision in the posting. Often, updates are made to provide greater clarity or to comply with changes in regulatory requirements. If the updates involve material changes to the collection, protection, use or disclosure of Personal Information, Pearson will provide notice of the change through a conspicuous notice on this site or other appropriate way. Continued use of the site after the effective date of a posted revision evidences acceptance. Please contact us if you have questions or concerns about the Privacy Notice or any objection to any revisions.

Last Update: November 17, 2020