A physical unit of data that is one or more bytes in size. A collection of fields make up a record. A field also defines a unit of data on a source document, screen or report. Examples of fields are NAME, ADDRESS, QUANTITY and AMOUNT DUE.
The field is the common denominator between the user and the computer. When you interactively query and update your database, you reference your data by field name.
Fields, Data Elements and Data Items
There are several terms that refer to the same unit of storage as a field. A data element is the logical definition of the field, and a data item is the actual data stored in the field. For each data element, there are many fields in the database that hold the data items.
The Basic Unit of Storage
Technically, data elements describe the logical unit of data, fields are the actual storage units, and data items are the individual instances of the data elements as in this example. In everyday language, all three terms are used interchangeably. When you read technical documentation on database management, you run across the proper use of these terms (maybe!).
The field is the common denominator between the user and the computer. When you interactively query and update your database, you reference your data by field name.
Fields, Data Elements and Data Items
There are several terms that refer to the same unit of storage as a field. A data element is the logical definition of the field, and a data item is the actual data stored in the field. For each data element, there are many fields in the database that hold the data items.
The Basic Unit of Storage
Technically, data elements describe the logical unit of data, fields are the actual storage units, and data items are the individual instances of the data elements as in this example. In everyday language, all three terms are used interchangeably. When you read technical documentation on database management, you run across the proper use of these terms (maybe!).
 | Reproduced with permission from Computer Desktop Encyclopedia. Copyright (c) 1981-2009 The Computer Language Company Inc. All rights reserved. |
Additional Resources
- Lunar Lander for Android (Mobile)
- Lunar Lander for Android is a sample game, which was extracted from the Android's SDK. It showcases a simple 2D graphic implementation on this platform. Lunar Lander for Android is an arcade game, where the player must correctly land a lunar module exactly on the green landing pad, located on...
- Software downloads 2009-11-27
- India goes to Copenhagen
- See, it's all about wealth transfers.Now under the guise of 'climate debt'.Climate debt my ass. Nonsense.If countries want more wealth, here's the recipe:- get off your ass, and work;- good governance, no corruption.And stop blaming everything on the west.Of courseHumans seem incapable of any measure more sophisticated than money. We...
- Discussion threads 2009-11-26
- Chrome Clock 0.5.4 (Windows)
- A simple Chrome Clock extension with alarm and timer.To set the alarm time, click on the toolstrip. In the first field enter the hour of the alarm time, press Enter to go to the second field and put the number of minutes there. Press Enter one more time and the...
- Software downloads 2009-11-26
- Maintenance Parts Bin Professional 7.9 (Windows)
- MPB is not just limited to maintenance inventory. Create as many databases as you like and title each one what you will. It can be used for tracking computer parts or automobiles. You can create new databases in MPB for different departments, projects, edit field labels to suit your needs,...
- Software downloads 2009-11-26
- Need4 YouTube Download 6.0.1 (Windows)
- Need4 YouTube Download is a free tool which allows to download YouTube videos and store them on your computer. Need 4 Free YouTube Download also saves videos from video.google, metacafe and other popular video-sharing sites. Need4 Free YouTube Download saves movies in the original FLV format for further sharing and...
- Software downloads 2009-11-26
- Thanksgiving reading. Soccer and enterprise apps: the similarities and differences
- The other evening I had the pleasure of visiting Old Trafford soccer stadium. It's the home of Manchester United, arguably the most successful soccer team in living memory. Consistently at the top or near the top of the British Premier League and European Champions League in the late 20th and...
- Blog posts 2009-11-25
- East Anglia: some new angles, but no arrests for hacking
- Investigation..."If the Republicans regain control of the Senate any time soon, you can expect a full-blown Inhofe-fuelled investigation."Horrors! Imagine that, someone actually wants to INVESTIGATE to see if the "science" of global warming holds water pardon the pun? You mean people actually want to KNOW if these drastic changes to...
- Discussion threads 2009-11-25
- The Big Question podcast: Will News Corp. really pull its content from Google?
- Bare-Metal replacement with a new visionI have to say, Google is on the cutting edge and this will sell because companies can have cloud-a, cloud-b, and cloud-c ect...No different than Networks today, it is no different than Vlans.Google has the BEST developers and Open_Source resources that will prove again a...
- Discussion threads 2009-11-25
- CopanMobile for PocketPC 1.0.6 (Mobile)
- CopanMobile for Pocket PC is a very functional and easy-to-use geomatics engineering tool for computing and managing plane surveying and mapping coordinates. It does numerous coordinate geometry COGO calculations, processes and adjusts raw field survey data, computes and adjusts map traverse data, performs map or deed checks, calculates curves, areas...
- Software downloads 2009-11-25
- TIE Formation 1.2 (Windows)
- This is a 3D screen saver featuring detailed 3D models of three TIE fighters known from the Star Wars movies flying in formation in front of the Death Star. The camera rotates around the TIE formation and moves slowly up and down to reveal ever changing views of the formations...
- Software downloads 2009-11-25
- Large Hadron Collider sees first collisions
- its work and we are not dead yet damn it .... not end of the world party Won't go full power until 2012...Abotu the 21st of December. ;-)Give It Time!!It takes awhile for the microscopic Black hole to consume enough matter to destroy the planet. Let's see the mass...
- Discussion threads 2009-11-24
- Tag Backup & Restore 1.1.18 (Windows)
- If you are a serious audiophile you have invested considerable time and effort in your tags. The information they contain frequently comes from diverse, hard-to-locate sources and can often be more troublesome to replace than the music itself. Tag Backup & Restore protects your investment by backing up tags to...
- Software downloads 2009-11-24
- Insight Contact Management Pro 3.1.8 (Windows)
- Manage your contacts, set follow-up reminders, track prospects and keep history of activity using this customizable multi-user program. Create e-mail merges, labels, envelopes, and reports. List, sort, and search contacts with any combination of fields. Perform SQL query to create dynamic lists of contacts. Each contact has unlimited notes, phone...
- Software downloads 2009-11-24
- iData 3.1.9 (Mac)
- iData 3 is an easy-to-use database application for storing text and graphics. Provides several ways to retrieve and view your information. Is very flexible and user-configurable.Synchronizes datafiles to iData Mobile on the iPhone Stores data in either freeform or user-defined field-based formats. Can "grab" and store Web page addresses and...
- Software downloads 2009-11-24
- Driving Dimensions for Google SketchUp 1.2 (Mac)
- LEDAS Driving Dimensions for SketchUp is a plug-in for parametric modification of 3D geometric models in very simple and intuitive way. With Driving Dimensions one can modify any dimension (length, distance, radius, or angle) in any SketchUp model in just one click. All driving dimensions set in one model are...
- Software downloads 2009-11-24
- PhotoLab Calendar 2.1 (Windows)
- PhotoLab Calendar is a must-have schedule management tool for anyone who has a photo or video business. It supports infinite number of resources (digital services, film services) and has a well-organized navigation system. It's perfect to plan working hours, keep track of scheduled appointments and orders. It'll store the information...
- Software downloads 2009-11-24
- Microsoft tries toppling Google with a bribe
- Big CatchMySpace, Fox News, couple dozen newspapers, couple dozen magazines, other Fox channels, Sky.The major News Corp viewers will see that if they want to search, they'll Bing it.Even if people link News Corp content in Twitter or Blogs, Google can't go to those links and crawl the content on...
- Discussion threads 2009-11-23
- Can Obama make science cool?
- Give him a Nobel for Science for his science speeches!Please! Obama doesn't even deserve to be your President. All the promises he made have remained just that. What else can this world expect from a politician? And things are clear from his popularity ratings.Obama is good with one thing and...
- Discussion threads 2009-11-23
- Windows Mobile is better than you think
- My main gripeis with the antique user interface which is little more than an uninspired, miniaturized desktop GUI.The foundations seems solid enough now - it is quite decent in multi-tasking and is generally responsive.I too believe that if MS can reinvigorate the UI they still has a strong competitor. Oh...
- Discussion threads 2009-11-23
- Is Wikipedia maxed out?
- Interesting....I don't see a reason Wikipedia would max out considering that every day new younger participants are entering the field. It's timeless relevance could diminish as new and younger editors focus on more up-to-date matters as Twitter, Sexting and Cloud computing, and less on the Roman Empire, the Great Depression...
- Discussion threads 2009-11-23
Neighboring Terms
Premier Vendor Content Whitepapers, webcasts & resources from our Power Center Sponsors
- Microsoft Dynamics CRM Online - Free Six-Month Trial for Eligible Organizations
-
Microsoft Dynamics CRM Online provides fast online access, simple contact management and better sales performance for a low monthly cost - the best value on the market today.
- Learn more about the free, six-month trial offer>>
- New Online Dashboard for IT Leaders
-
Read about top issues IT decision-makers face every day, plus get cost-effective solutions to real-life IT problems.
- Learn more >>
- The more you simplify, the more you save
-
When you transition from your existing Red Hat environment to SUSE Linux Enterprise from Novell, you can recognize dramatic cost savings, perhaps as much 50%
- Learn more >>
SmartPlanet
- Thought-provoking progressive ideas on diverse topics that intersect with technology, business, and life, and matter to the world at large. Visit SmartPlanet
- More from IBM
-
- Can your business work smarter? Learn more about Lotus Symphony
- Learn how to work smarter and optimize cost using the IBM Smart SOA approach Download the eBook
- Smarter ways to make smarter products Read the brief from IBM
