A collection of records pertaining to one of the main subjects of an information system, such as customers, employees, products and vendors. Master files contain descriptive data, such as name and address, as well as summary information, such as amount due and year-to-date sales. Contrast with transaction file.
Following are the kinds of fields that make up a typical master record in a business information system. There can be many more fields depending on the organization. The "key" fields below are the ones that are generally indexed for matching against the transaction records as well as fast retrieval for queries. The account number is usually the primary key, but name may also be primary. There can be secondary indexes; for example, in an inverted file structure, almost all the fields could be indexed. See transaction file for examples of typical transaction records.
Following are the kinds of fields that make up a typical master record in a business information system. There can be many more fields depending on the organization. The "key" fields below are the ones that are generally indexed for matching against the transaction records as well as fast retrieval for queries. The account number is usually the primary key, but name may also be primary. There can be secondary indexes; for example, in an inverted file structure, almost all the fields could be indexed. See transaction file for examples of typical transaction records.
EMPLOYEE MASTER RECORD
key Employee account number
key Name (last)
Name (first)
Address, city, state, zip
Hire date
Birth date
Title
Job class
Pay rate
Year-to-date gross pay
CUSTOMER MASTER RECORD
key Customer account number
key Name
Bill-to address, city, state, zip
Ship-to address, city, state, zip
Credit limit
Date of first order
Sales-to-date
Balance due
VENDOR MASTER RECORD
key Vendor account number
key Name
Address, city, state, zip
Terms
Quality rating
Shipping method
PRODUCT MASTER RECORD
key Product number
key Name
Description
Quantity on hand
Location
Primary vendor
Secondary vendor
 | Reproduced with permission from Computer Desktop Encyclopedia. Copyright (c) 1981-2008 The Computer Language Company Inc. All rights reserved. |
Additional Resources
- Unstructured transparency - the management methodology that pulls us through the crunch?
- I've just spent a couple of fascinating days at the HCL Global Meet in Orlando, Florida. As the name suggests this was a very international gathering of HCL's partners, clients, staff and thoughtleaders in the management and collaboration space. I've written before about...
- Blog posts 2008-11-19
- Commercial vendor of spyware under legal fire
- Just like every decent marketer out there, vendors of commercial malware tools are very good at positioning their tools. However, their pitches often contradict with themselves in a way that what's promoted as a Remote Administration Tool, has in fact built-in antivirus software evading capabilities, rootkit functionality and tutorials on...
- Blog posts 2008-11-18
- iPhone vs. Android development: Day 2
- Welcome to day 2 of a 5-day course on iPhone programming presented by Big Nerd Ranch. During the course I'll be blogging about the differences between Android and iPhone development. [Read: Day 1, Day 3, Day 4, Day 5] Yesterday we learned about creating...
- Blog posts 2008-11-18
- iPhone vs. Android development: Day 1
- As I mentioned last week I've started learning more about developing for the Apple iPhone. This week I'll be sharing my experiences during a 5-day course on iPhone programming presented by Big Nerd Ranch. In particular, I'll be pointing out differences between Android and iPhone development. [Read:...
- Blog posts 2008-11-17
- Asus launches 'world's fastest' smartphone
- Yes, you read correctly: Asus has unveiled its latest smartphone, which, it claims is the "fastest business PDA phone in the world." Them's big words coming from a mobile underdog. That's because the juice behind the shell of the Asus P565 is an 800MHz...
- Blog posts 2008-11-17
- Adobe pushes Flash forward; Bolsters SAP partnership
- Adobe's MAX 2008 conference kicks off Monday and the shindig's theme is pretty simple: Extend its Flash platform into every software nook and cranny that it can by enlisting developers everywhere. Adobe's goal of reaching everyone with Flash isn't new, but the company every year makes more...
- Blog posts 2008-11-17
- OLPC is dead...What Kindlenomics taught us
- Fellow ZDNet blogger, Jason Perlow, wrote a neat piece suggesting that, if electronic versions of most college textbooks existed, it wouldn't take many semesters for the average undergraduate to pay for the Kindle on which to read them. In fact, with a fair amount of arm-waving, it wasn't too...
- Blog posts 2008-11-16
- BearingPoint's Q3 earnings call - part 1
- To BE or not BE Several news groups and Wall Street firms covered BearingPoint's BE Q3 results this week but one point was not well covered, if at all. Look at this bullet point that is at the bottom of a list of points BE...
- Blog posts 2008-11-14
- Whatever happened to the 'middle' in middleware?
- Quote of the week: "In the mid 1990s, 'middle' meant 'the gaps between applications and software components.' Middleware was technology you turned to in order to try to build distributed systems: transaction processing middleware, database middleware, object middleware... Middleware was a technological concept. ...Now, 'middle' means...
- Blog posts 2008-11-14
- Sun plugs holes in StarOffice
- Two weeks after the OpenOffice.org team shipped patches for code execution flaws in office suite, Sun Micrososystems has followed up with a high-priority update for StarOffice, which is based on the open-source code. Sun's patch, available for Windows, Linux and Solaris, address highly-critical vulnerabilities that could expose...
- Blog posts 2008-11-14
- Adventures in CA Support Day 2
- As I pointed out in the post Adventures in CA support, I received a routine message from CA telling me that my subscription to their CA Internet Security Suite was coming to an end and I needed to purchase an update. When I did and installed the updated software, problems...
- Blog posts 2008-11-14
- Adventures in CA support
- I received an Email notice this morning that my support agreement with CA for their Internet Security Suite was ending and that I should pay for an update. Since I'm well aware of how long a Windows XP system will survive on the network without a security breach, I dutifully...
- Blog posts 2008-11-13
- Qualcomm's Kayak "PC alternative" pictured
- Here's a picture of Kayak, the "PC alternative" for emerging markets that Qualcomm announced yesterday. It looks pretty much the way the company described it: sort of a cross between the Apple Mac Mini--bring your own monitor, keyboard and mouse--and the OLPC's XO laptop with its...
- Blog posts 2008-11-13
- Google Chrome vulnerable to data theft flaw
- Google has seeded a new version of its Chrome browser to developers with fixes for a pair of security issues that could expose users to data theft. The issue, rated as a "moderate" risk could allow hackers to use HTML files to steal arbitrary files from a...
- Blog posts 2008-11-13
- Getting started with iPhone development
- I've been doing Android development for some time, and before that I experimented with Palm and Blackberry, so I figured it was time for some hands-on iPhone programming as well. In this article I'd like to share a few of my initial experiences. Apple released the first...
- Blog posts 2008-11-13
- Firefox security makeover: 11 vulnerabilities, 4 critical
- Mozilla has released a new version of its flagship Firefox browser to fix a total of 11 vulnerabilities that expose users to code execution, information stealing or denial-of-service attacks. Four of the 11 flaws covered with the new Firefox 3.0.4 are rated "critical" because of the risk...
- Blog posts 2008-11-12
- JobBlogs: Facebook for business
- I've been a little busy over the last few weeks, but it hasn't all been drinking and partying. I've been looking into JobBlogs, which has a highly innovative SaaS appliance, which blends together customer relation management and project management, with social media within business as a main selling point, into...
- Blog posts 2008-11-12
- Press "Upload" on that Video: "Point Is Not To Bust People,'' Says NBC
- The point is to actually make fair use -- fair and creative use -- use of someone's professionally produced content, if you're going to post a video online. The executive vice president and general counsel of NBC Universal, Rick Cotton, this afternoon said that 99 percent of...
- Blog posts 2008-11-12
- Managing Internet growth
- The Internet is growing by 1 zettabyte a year, fueled by images, videos, gaming, and peer to peer file sharing. Pieter Poll, CTO of Qwest, asks whether this is growth manageable.
- Whiteboards 2008-11-12
- Encyclopedia: Offline Wikipedia viewer for iPhone
- If you're a fan of Wikipedia and own an iPhone or iPod touch check out Patrick Collison's Encyclopedia (US$7.99, iTunes Link). After launching the app you can download a complete copy of Wikipedia to your iPhone for offline viewing. It's great for people that fly a lot or otherwise would...
- Blog posts 2008-11-12
Neighboring Terms
Premier Vendor Content Whitepapers, webcasts & resources from our Power Center Sponsors
- Do more. Sacrifice less
-
"Intel® Xeon® processor-based servers are optimized for virtualization and allow IT to load more virtual machines without sacrificing speed. They can also help you save time and money while delivering great performance, flexibility, and headroom for growth.
- See the benefits of hardware-based virtualization >>
CIO Sessions
- Check out our video interviews with leading CIOs today!
-
Differentiating Technorati from Google Technorati VP of Engineering: Dorion Carroll 11:50 -
On the Issues: From Net neutrality to bandwidth caps Qwest CTO: Pieter Poll 11:50 -
How to process over 300 million transactions per day Visa CIO: Michael Dreyer 11:30 -
Adopting collaboration tools in the enterprise Cisco CIO: Rebecca Jacoby 12:35 - All CIO Sessions »
