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-2009 The Computer Language Company Inc. All rights reserved. |
Additional Resources
- FAA hit with network glitch; Flight plans go manual
- Another glitch with a linux network? Its hard to believe people still use it for anything critical like the FAA and flight tracking. Its a toy OS and should not be used when the lives of people are dependent upon it.Cisco supplies the network backboneIt will be interesting to see...
- Discussion threads 2009-11-19
- SOA promotes a sea change for the US Coast Guard
- So what are they?I mean the 25 Service Oriented Initiatives. So far I count two in your first two installments. So why should I care? Well, I suspect anything that has to do with the Homeland Security bureaucracy, an agency that really is surplus to others already...
- Discussion threads 2009-11-18
- RazorSQL 5.0.2 (Mac)
- Query, edit, browse, and manage all major databases from one database tool. RazorSQL OSX is a universal database query tool, programming and sql editor, database navigator, and administration tool with built-in connection capabilities for DB2, Derby, Firebird, FrontBase, HSQLDB, Informix, Microsoft SQL Server, MySQL, OpenBase, Oracle, PostgreSQL, SQL Anywhere, SQLite,...
- Software downloads 2009-11-18
- DatAdmin Personal 3.4.2 (Windows)
- Easy and quick database administration, natively supports MSSQL, MySQL, SQLite, Postgre SQL, MS Access. Also can be used to create and restoring backups, transfer data between databases, tables or files (supported formats are XML, CSV, HTML, Excel), edit database schema. Other functions: run queries, view data in tables of any...
- Software downloads 2009-11-17
- RazorSQL 5.0.1 (Windows)
- Query, edit, browse, and manage all major databases from one database tool. RazorSQL is a database query tool, SQL editor, database browser, and administration tool with built-in connection capabilities for DB2, Derby, Firebird, FrontBase, HSQLDB, Informix, Microsoft SQL Server, MySQL, OpenBase, Oracle, PostgreSQL, SQL Anywhere, SQLite, and Sybase. Any other...
- Software downloads 2009-11-16
- The stupid network will get a hearing
- Leave my bits aloneIf I pay for unlimited service up to a certain speed that's what I expect to get. The fee I pay is supposed to cover the level of service I order. If a company is investing in a service I didn't buy, they neeed to get their...
- Discussion threads 2009-11-13
- Greenland becomes green land; Brazil gets good news
- Yes we know it is all lies...http://whatreallyhappened.com/WRHARTICLES/globalwarming.htmlhttp://www.climatechangefraud.com/Did the dinosaurs pass some gas and causethe ice age? I guess they should have beentaxed for passing gas!;)Do you do any actual research?Or do you just try to scare people into thinking the way you do?Greenland is one of the worst examples you...
- Discussion threads 2009-11-12
- Biz Timesheet Manager 3.0 (Windows)
- Track the time spent by your employees on your projects, jobs, contracts, etc. Easy to use and affordable. All your employees will learn to use this program within a couple of minutes only. No need for your employees to fill out time sheets by hand. Everything is now done automatically....
- Software downloads 2009-11-12
- Passwordstate 4.0 (Windows)
- Passwordstate 4.0 is a web-based solution for secure management of passwords, for both individuals and teams of people. 256bit AES data encryption, code obfuscation and enterprise scalability makes it the Enterprise Password Manager of choice. Track Personal and Shared Password Lists -Track passwords for individuals, or create Shared Password Lists...
- Software downloads 2009-11-11
- Why I'm letting someone else run my Exchange 2010 server
- Microsoft officially released Exchange Server 2010 today. I could go download the code from my MSDN or TechNet account and install it in-house. Instead, I'm planning to let someone else handle the heavy lifting for me, and I suspect I have a lot of company. The biggest objection to a...
- Blog posts 2009-11-09
- 60 Minutes: We're not ready for a cyber war
- Just like 9/11 thousands will have to die Before we give a damn. It's really a shame.and everything workshow's that possible?Unfortuantely, it will take a disasterIn the US, until disater strikes no one will do anything. Once it does happen then there will be screaming for heads to role....
- Discussion threads 2009-11-09
- Easeus Partition Master Server Edition 4.1.1 (Windows)
- Magic Partition Software - Easeus released upgraded version Easeus Partition Master Server Edition with new features: adds Windows 7 support. Easeus Partition Master Server Edition is the best value server partition software to optimize disk space usage and provide you with powerful partition and hard disk management to increase the...
- Software downloads 2009-11-08
- MetriQ Professional 8.1 (Windows)
- MetriQ automated time tracking software is perfect for automated timesheet administration and time software. Features MetriQ's patent-pending time capture software engine that accurately and reliably tracks time and duration spent working on applications and files on your computer. MetriQ time and billing software removes the need for staff to complete...
- Software downloads 2009-11-06
- Survey: IT workers eyeing security certifications
- No government healthcareIf the Gov goes with this socialist health_care scheme it will be the end of the free market.With Billions in waste from fraud in medicare/medicade and welfare running rampant with no checks in place.All we need is this community leader telling people we need to go TRILLIONS more...
- Discussion threads 2009-11-05
- vTask Studio (formerly VistaTask) 7.70 (Windows)
- vTask Studio gives you the opportunity to control every aspect of your computer, such as the keyboard, mouse and Web actions, without needing to write any programming code. vTask Studio is useful in many different scenarios, such as software quality assurance testing, IT administration jobs, repetitive data entry, program installations,...
- Software downloads 2009-11-05
- DreamCoder for MySQL Free Edition 5.0.3.0 (Windows)
- DreamCoder for MySQL Freeware is an excellent tool for managing the MySQL database server. This tool is ideal for people who are learning about the database and who need basic server functionality. DreamCoder for MySQL Free Edition enhances productivity and simplifies your database development and administration process with a functionality...
- Software downloads 2009-11-05
- Navicat Lite 8.2.16 (Windows)
- Navicat Lite is a multi-connections Database Administration tool allowing you to connect to MySQL, PostgreSQL and Oracle databases simultaneously within a single application, making database administration to multiple kinds of database so easy. Support of multi-connections to MySQL, PostgreSQL and Oracle servers. Support of transferring data between different servers. Support...
- Software downloads 2009-11-04
- Navicat Premium 8.2.16 (Windows)
- Navicat Premium is a multi-connections Database Administration tool allowing you to connect to MySQL, PostgreSQL and Oracle databases simultaneously within a single application, making database administration to multiple kinds of database so easy. Support of multi-connections to MySQL, PostgreSQL and Oracle servers. Support of transferring data between different servers. Support...
- Software downloads 2009-11-04
- CAMEO 2.1 (Mac)
- CAMEO is a system of software applications used widely to plan for and respond to chemical emergencies. It is one of the tools developed by EPA?s Chemical Emergency Preparedness and Prevention Office CEPPO and the National Oceanic and Atmospheric Administration Office of Response and Restoration NOAA, to assist front-line chemical...
- Software downloads 2009-11-03
- Obamicans rebranding NHIN-Connect as the Health Internet
- Hey look. A tech storyYou don't want me to write about policy so here's a tech story and we get...crickets. I guess the market is saying write more policy stories, isn't it? I'm sorry...... I'm still trying to figure out what an "Obamican" is.(But you get extra points for using...
- Discussion threads 2009-11-02
Neighboring Terms
Premier Vendor Content Whitepapers, webcasts & resources from our Power Center Sponsors
- 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 >>
- 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 >>
- Reduce risk. Reduce complexity. Increase reliability.
-
A simplified IT environment isn't just less complex. It's also more reliable. Standardize on a single Linux platform with SUSE Linux Enterprise from Novell, and get the world's most interoperable Linux
- Learn more >>
- Save time with automated shipping solutions
-
The Business Essentials Guide provides you useful tools and templates to help grow your business and save you time with automated shipping solutions.
- Visit the UPS Business Essentials Guide
Meet Doc
-
-
Here to help you with your Document Management Needs
- Doc is an enigma. Born to a Russian ballerina and a German electrical engineer, he grew up in various locations in the United States. He’s seen the insides of more brands, versions, and generations of printer and printer-related hardware than almost anyone.
- To learn more about this mysterious figure check out his blog on ZDNet and his Workspace on TechRepublic. You’ll be glad you did.
-
Produced by
ZDNet and -
