The analysis, classification and maintenance of an organization's data and data relationships. It includes the development of data models and data dictionaries, which, combined with transaction volume, are the raw materials for database design.
Although data administration and database administration are separate functions, both are typically combined into one department and are often performed by the same people. However, "data" administration deals with the modeling of the data and treats data as an organizational resource, while "database" administration deals with the implementation of the types of databases that are in use. The person who performs "data" administration functions is a "database analyst" or "data administrator," the latter being an earlier title for the job. The person who handles "database" administration, which is the technical design and management of the database, is the "database administrator."
Data Are Complex
The flow of data/information within a company is complex since the same data are viewed differently as they move from one department to the other.
For example: When a customer places an order, the order becomes a commission for sales, a statistic for marketing, an order to keep track of in order processing, an effect on cash flow for financial officers, picking schedules for the warehouse, and production scheduling for manufacturing.
Users have different requirements for interrogating and updating data. Operations people need detail, management needs summaries. Database design must take this into consideration.
Although data administration and database administration are separate functions, both are typically combined into one department and are often performed by the same people. However, "data" administration deals with the modeling of the data and treats data as an organizational resource, while "database" administration deals with the implementation of the types of databases that are in use. The person who performs "data" administration functions is a "database analyst" or "data administrator," the latter being an earlier title for the job. The person who handles "database" administration, which is the technical design and management of the database, is the "database administrator."
Data Are Complex
The flow of data/information within a company is complex since the same data are viewed differently as they move from one department to the other.
For example: When a customer places an order, the order becomes a commission for sales, a statistic for marketing, an order to keep track of in order processing, an effect on cash flow for financial officers, picking schedules for the warehouse, and production scheduling for manufacturing.
Users have different requirements for interrogating and updating data. Operations people need detail, management needs summaries. Database design must take this into consideration.
 | Reproduced with permission from Computer Desktop Encyclopedia. Copyright (c) 1981-2008 The Computer Language Company Inc. All rights reserved. |
Additional Resources
- Spam coming from free email providers increasing
- After analyzing three weeks of spam data between June 13 to July 3, 2008, Roaring Penguin Software Inc. found evidence that spam originating from the top three fre email providers (Gmail, Yahoo Mail and Hotmail) is increasing, with spammers in favor of abusing Gmail's privacy preserving feature of not including...
- Blog posts 2008-07-18
- WSO2 adds data services and security features in Mashup Server 1.5
- The latest version from the Mountain View, Calif., and Sri Lanka company adds WSO2 Data Services and security features for enterprise-class service composition. Mashup Server 1.5 is built on the WSO2 Web Services Application Server based on Apache/Axis 2. It can be used as an individual service development and deployment...
- Blog posts 2008-07-18
- My Awesome IT Job: Senior security engineer, VoIP carrier
- Hey, we all complain about work from time to time; we've all had lousy jobs. But before you call it a day and head off to the support group that meets at the bar, here are a few words from IT pros that love their work. "I...
- Blog posts 2008-07-18
- Obama calls for comprehensive cyber-security measures; looks for a national cyber ninja
- Update: It would seem that Richard Stiennon agrees with me on the concept of a group of experts to advise, also on keeping away from spending ridiculous amounts of money. Cyber-terrorism... ah, what a fancy buzz word that is. Defined on Wikipedia as: "The premeditated use...
- Blog posts 2008-07-18
- Immobile Apple
- It's 11:33 a.m. Friday. Approximately 66 and a half hours since Apple Support acknowledged receipt of my request for help on syncing calendar and contact data from my iMac to the "cloud,'' i.e., MobileMe servers wherever they are. Re-request sent after 48 hours. Still...
- Blog posts 2008-07-18
- The green tech edition of ‘what I did on my summer vacation'
- How would you like to spend your summer break doing some groundbreaking green technology research? IBM has hired a couple of hundred college students worldwide to lend their brains to projects across the company's 13 research labs, including several focused on solving problems related to making data...
- Blog posts 2008-07-18
- News to know: Google, Microsoft; AMD; Cybercrime arrest
- Notable headlines: Earnings wrap: Larry Dignan: Can Dirk Meyer save AMD? News.com: AMD's Ruiz steps off the roller coaster Google earnings fall short; says it can thrive in down economy. Techmeme Sam Diaz: IBM: Big Blue beats expectations Microsoft: $60 billion...
- Blog posts 2008-07-18
- From Chapter one: Data Processing and the IBM Mainframe
- The controls that developed around the 360 environment were all predicated on the primary concerns expressed by Finance management: that nothing interrupt processing critical to Finance. Thus virtually all of them derive from, or are subsidiary to, the service level agreement. by Paul Murphy
- Blog posts 2008-07-18
- Techie's green pet: IDC develops new report card for tech asset recyclers
- Does your IT services company make the grade when it comes to retiring and disposing of technology assets in the greenest way possible? Researcher IDC has come up with a new certification and weighting system for IT assess disposal functions that it is calling the Green Recycling...
- Blog posts 2008-07-17
- GE's Enterprise Collaboration Backbone
- General Electric, the venerable multinational that was founded in 1878 in New Jersey, have at their core a hugely sophisticated enterprise collaboration system that is arguably the largest in the world. I was able to see Dr Sukh Grewal, Manager of GE's 'SupportCentral' collaboration...
- Blog posts 2008-07-17
- Second version of NASDAQ MarketReplay application released
- Last week NASDAQ released version two of their Market Replay AIR application and added a couple of interesting features as well as provided some details of how the service works. Market Replay is available as a paid service and the downloadable client comes with the service. The goal of the...
- Blog posts 2008-07-17
- SAP 'Mittelstand' customers upset at new maintenance charges
- Following on from yesterday's announcement of a hike in SAP maintenance charges, the German title Computerwoche implies that the powerful 'Mittelstand' group in the German SAP user group are far from happy. Under the title: "Higher maintenance costs upset SAP customers ," Computerwoche interviewed Gunther Rheinhart, executive member of the...
- Blog posts 2008-07-17
- More iPhone 3G observations
- After almost a week with the new iPhone 3G I have some additional thoughts that I wanted to share on my experiences: As I previously mentioned, AT&T's 3G coverage is completely non-existent in my area, despite AT&T's coverage viewer claiming that I'm blanketed in 100 percent 3G....
- Blog posts 2008-07-17
- Silverlight suit: Microsoft's conduct is "unlawful" and "willful"
- Silverlight suit: Microsoft's conduct is "unlawful" and "willful"SilverliteSo... the point of this article is... ???Since Silverlight came from Microsoft...and Microsoft is the biggest name in software, it becomes way to easy for those jealous of Microsoft's success to tear down or discredit them with frivilous lawsuits. What if Silverlight came...
- Discussion threads 2008-07-17
- The edge-centric Internet
- The edge-centric InternetRE: Edge Centric InternetSir,RE: The edge-centric InternetYour idea sounds good from the stand point of greenness. I would be curious as to how the ISP and myself would go about securing such data stored on a drive in my pc. Right now i have 5 pc's in my...
- Discussion threads 2008-07-17
- In America money is life
- In America money is lifeWhat a crock[i]while the U.S. is both rich and powerful, it is “woefully behind when it comes to providing opportunity and choices to all Americans to build a better life.”[/i] OK, let me get this straight. There is someplace else in the world that...
- Discussion threads 2008-07-17
- News to know: Google; Microsoft; eBay; SAP; Apple
- Notable headlines: Larry Dignan: Google's second quarter: What to expect Deb Perelman: The Techie Hall of Shame Phil Wainewright: How much is a unit of cloud computing? Joe McKendrick: Seven SOA experts explain how to 'just do it' Robin...
- Blog posts 2008-07-17
- User beware: Electronic documents can reveal far more than you want
- The WYSIWYG mentality can be dangerous when users fail to understand what underlies the visible presentation of electronic data. This chapter from Blown to Bits: Your Life, Liberty, and Happiness After the Digital Explosion explores the premise that "What you see is not what the computer knows" -- focusing...
- Book chapters 2008-07-17
- Code OnTime Generator (exe)
- Code OnTime Generator is a unique general purpose free code generator for Microsoft.NET. Built as an open platform with XML, XPath, XSLT, and AJAX, the tool redefines the way you think and approach the code generation. The built-in Code DOM compiler will transform your program coded in XML into Visual...
- Software downloads 2008-07-17
- TSUK 1-Click MAC Backup (zip)
- Backup all your precious documents, photos, and music to our online data centre. Never lose your data again. Safe in the knowledge your important data is security protected. After initial upload only changes will then be uploaded. This version is the first release on CNET Download.com.
- Software downloads 2008-07-17
Neighboring Terms
Premier Vendor Content Whitepapers, webcasts & resources from our Power Center Sponsors
- ZDNet video: Intel® vPro™ technology and Cost Savings
-
Randy Nystrom, an IT systems engineer at Intel, shows how vPro saves time and money by diagnosing PC problems remotely. (1 of 4 new videos with Intel engineers on ZDNet).
- Watch the video and more at Intel's Power Center >>
- Learn how collaboration fuels success with this FREE Economist report
-
According to a new study from the Economist, future success belongs to those who collaborate effectively. Learn how successful collaboration can improve profits, problem-solving, and competitive differentiation.
- Visit Cisco's Collaboration Resource Center today!
-
-
Tasty Baking’s new LEED factory
0:57
Tasty Baking CIO: Brendan O’Malley
-
Balancing act: innovation vs. reliability
1:28
Facebook VP of technical operations: Jonathan Heiliger
-
Securing data at E-Loan
1:47
E-Loan CIO: Jay Shah
-
When crops are scarce
1:47
Del Monte Foods CIO: Marc Brown
- View all CIO Vision Series Videos »
