(DataBase Management System) Software that controls the organization, storage, retrieval, security and integrity of data in a database. It accepts requests from the application and instructs the operating system to transfer the appropriate data. The major DBMS vendors are Oracle, IBM, Microsoft and Sybase (see Oracle database, DB2, SQL Server and ASE). MySQL is a very popular open source product (see MySQL).
DBMSs may work with traditional programming languages (COBOL, C, etc.) or they may include their own programming language for application development.
DBMSs let information systems be changed more easily as the organization's requirements change. New categories of data can be added to the database without disruption to the existing system. Adding a field to a record does not require changing any of the programs that do not use the data in that new field.
Major Features of a DBMS
Data Security
The DBMS can prevent unauthorized users from viewing or updating the database. Using passwords, users are allowed access to the entire database or a subset of it known as a "subschema." For example, in an employee database, some users may be able to view salaries while others may view only work history and medical data.
Data Integrity
The DBMS can ensure that no more than one user can update the same record at the same time. It can keep duplicate records out of the database; for example, no two customers with the same customer number can be entered.
Interactive Query
A DBMS provides a query language and report writer that lets users interactively interrogate the database. These essential components give users access to all management information as needed. See query language and report writer.
Interactive Data Entry and Updating
A DBMS typically provides a way to interactively enter and edit data, allowing you to manage your own files and databases. However, interactive operation does not leave an audit trail and does not provide the controls necessary in a large organization. These controls must be programmed into the data entry and update programs of the application.
This is a common misconception about using a desktop computer DBMS. Creating lists of data for a user's own record keeping is one thing. However, although complete information systems can be developed with such software, it cannot be done without understanding how transactions and files relate to each other in a business system (see Database Design below). In addition, some type of programming is required, whether at a graphical drag and drop level or by using traditional languages.
Data Independence
When a DBMS is used, the details of the data structure are not stated in each application program. The program asks the DBMS for data by field name; for example, a coded equivalent of "give me customer name and balance due" would be sent to the DBMS. Without a DBMS, the programmer must reserve space for the full structure of the record in the program. Any change in data structure requires changing all application programs.
Database Design
A business information system is made up of subjects (customers, employees, vendors, etc.) and activities (orders, payments, purchases, etc.). Database design is the process of organizing this data into related record types. The DBMS that is chosen is the one that can support the organization's data structure while efficiently processing the transaction volume.
Organizations may use one kind of DBMS for daily transaction processing and then move the detail to another DBMS better suited for random inquiries and analysis.
Overall systems design decisions are performed by data administrators and systems analysts. Detailed database design is performed by database administrators.
Hierarchical, Network & Relational
Information systems are made up of related files: customers and orders, vendors and purchases, etc. A key DBMS feature is its ability to manage these relationships.
Hierarchical databases link records like an organization chart. A record type can be owned by only one owner. In the following example, orders are owned by only one customer. Hierarchical structures were widely used with early mainframe systems; however, they are often restrictive in linking real-world structures.
In network databases, a record type can have multiple owners. In the example below, orders are owned by both customers and products, reflecting their natural relationship in business.
Relational databases do not link records together physically, but the design of the records must provide a common field, such as account number, to allow for matching. Often, the fields used for matching are indexed in order to speed up the process.
In the following example, customers, orders and products are linked by comparing data fields and/or indexes when information from more than one record type is needed. This method is more flexible for ad hoc inquiries. Many hierarchical and network DBMSs also provide this capability.
Object Databases
Certain information systems may have complex data structures not easily modeled by traditional data structures. An "object database" can be employed when hierarchical, network and relational structures are too restrictive. Object databases can easily handle many-to-many relationships.
Intelligent Databases
All DBMSs provide some data validation; for example, they can reject invalid dates or alphabetic data entered into money fields. But most validation is left up to the application programs.
Intelligent databases provide more validation; for example, table lookups can reject bad spelling or coding of items. Common algorithms can also be used such as one that computes sales tax for an order based on zip code.
When validation is left up to each application program, one program could allow an item to be entered while another program rejects it. Data integrity is better served when data validation is done in only one place. Mainframe DBMSs were the first to become intelligent, and all the others followed suit.
DBMS and OS Interaction
This diagram shows the interaction between the DBMS with other system and application software running in memory.
DBMSs may work with traditional programming languages (COBOL, C, etc.) or they may include their own programming language for application development.
DBMSs let information systems be changed more easily as the organization's requirements change. New categories of data can be added to the database without disruption to the existing system. Adding a field to a record does not require changing any of the programs that do not use the data in that new field.
Major Features of a DBMS
Data Security
The DBMS can prevent unauthorized users from viewing or updating the database. Using passwords, users are allowed access to the entire database or a subset of it known as a "subschema." For example, in an employee database, some users may be able to view salaries while others may view only work history and medical data.
Data Integrity
The DBMS can ensure that no more than one user can update the same record at the same time. It can keep duplicate records out of the database; for example, no two customers with the same customer number can be entered.
Interactive Query
A DBMS provides a query language and report writer that lets users interactively interrogate the database. These essential components give users access to all management information as needed. See query language and report writer.
Interactive Data Entry and Updating
A DBMS typically provides a way to interactively enter and edit data, allowing you to manage your own files and databases. However, interactive operation does not leave an audit trail and does not provide the controls necessary in a large organization. These controls must be programmed into the data entry and update programs of the application.
This is a common misconception about using a desktop computer DBMS. Creating lists of data for a user's own record keeping is one thing. However, although complete information systems can be developed with such software, it cannot be done without understanding how transactions and files relate to each other in a business system (see Database Design below). In addition, some type of programming is required, whether at a graphical drag and drop level or by using traditional languages.
Data Independence
When a DBMS is used, the details of the data structure are not stated in each application program. The program asks the DBMS for data by field name; for example, a coded equivalent of "give me customer name and balance due" would be sent to the DBMS. Without a DBMS, the programmer must reserve space for the full structure of the record in the program. Any change in data structure requires changing all application programs.
Database Design
A business information system is made up of subjects (customers, employees, vendors, etc.) and activities (orders, payments, purchases, etc.). Database design is the process of organizing this data into related record types. The DBMS that is chosen is the one that can support the organization's data structure while efficiently processing the transaction volume.
Organizations may use one kind of DBMS for daily transaction processing and then move the detail to another DBMS better suited for random inquiries and analysis.
Overall systems design decisions are performed by data administrators and systems analysts. Detailed database design is performed by database administrators.
Hierarchical, Network & Relational
Information systems are made up of related files: customers and orders, vendors and purchases, etc. A key DBMS feature is its ability to manage these relationships.
Hierarchical databases link records like an organization chart. A record type can be owned by only one owner. In the following example, orders are owned by only one customer. Hierarchical structures were widely used with early mainframe systems; however, they are often restrictive in linking real-world structures.
In network databases, a record type can have multiple owners. In the example below, orders are owned by both customers and products, reflecting their natural relationship in business.
Relational databases do not link records together physically, but the design of the records must provide a common field, such as account number, to allow for matching. Often, the fields used for matching are indexed in order to speed up the process.
In the following example, customers, orders and products are linked by comparing data fields and/or indexes when information from more than one record type is needed. This method is more flexible for ad hoc inquiries. Many hierarchical and network DBMSs also provide this capability.
Object Databases
Certain information systems may have complex data structures not easily modeled by traditional data structures. An "object database" can be employed when hierarchical, network and relational structures are too restrictive. Object databases can easily handle many-to-many relationships.
Intelligent Databases
All DBMSs provide some data validation; for example, they can reject invalid dates or alphabetic data entered into money fields. But most validation is left up to the application programs.
Intelligent databases provide more validation; for example, table lookups can reject bad spelling or coding of items. Common algorithms can also be used such as one that computes sales tax for an order based on zip code.
When validation is left up to each application program, one program could allow an item to be entered while another program rejects it. Data integrity is better served when data validation is done in only one place. Mainframe DBMSs were the first to become intelligent, and all the others followed suit.
DBMS and OS Interaction
This diagram shows the interaction between the DBMS with other system and application software running in memory.
 | Reproduced with permission from Computer Desktop Encyclopedia. Copyright (c) 1981-2008 The Computer Language Company Inc. All rights reserved. |
Additional Resources
- Thinking about multicore and software
- Thinking about multicore and softwareThanks! NT:)RE: Thinking about multicore and softwarePaul,Provided a link to this blog on http://www.multicoreinfo.com , which is a website for resources related to multicore processors.Independent JobsIn the Enterprise, dual core makes sense for handling anti-virus, encryption, and other annoying security overhead functions. When you start...
- Discussion threads 2008-06-09
- Build your own Google
- Build your own GoogleA similarity that cannot be ignored...That bee looks like my brother Tom.Weird.Maybe if acquired by a large vendorI'd like to see both companies acquired and merged together by a larger vendor say HP. These two companies are the future of hardware because they contain open source...
- Discussion threads 2008-06-05
- MSCashBook (bin)
- MS Cash Book is a 'Double Entry Account System' designed for small businesses. It consists of general ledger, payments and receipts, profit and loss, balance sheet, GST reports, journal entries and other customizable reports are available. The whole package is currently designed for use in New Zealand, however it can...
- Software downloads 2008-05-30
- The Oracle Tax is progressive
- The Oracle Tax is progressiveYou get what you pay for.It is not just the tools.Having dealt with DB2, Informix, MySQL, Oracle, PostgreSQL and Sybase over the last 20 years, I'm more than willing to pay the DB2/Oracle/... Tax.The FOSS dbms engines are still playing catch up in terms of features....
- Discussion threads 2008-04-04
- Gartner report forecasts bad news, good news for open source
- The Gartner Group has released a preview of a forthcoming report, The State Of Open Source 2008, that contains both good news and bad news for open source. The report is expected to be released next month. First, the bad news: ...
- Blog posts 2008-04-01
- Google Sites: evaluate first and don't believe the hype
- Google Sites: evaluate first and don't believe the hypeHow's all this Google specific?So...''" if you want to show financial data to an end user, you will have to allow Google’s servers a pass through your firewall to make the web service call.That’s a basic security issue. Nothing...
- Discussion threads 2008-02-29
- SAP and Microsoft: No Marriage Needed
- The Sunday New York Times started a little blogo-versy going about whether Microsoft should have made an offer to buy SAP instead of Yahoo. It's an interesting thought, if revisiting history is your idea of interesting. But if you're living in the present, as many of my fellow bloggers (Vinnie...
- Blog posts 2008-02-25
- News to know: Black Hat; VoIP design flaws; Vista SP1; Apple
- Notable headlines: Nate McFeters: Black Hat, Day 1: Cracking GSM and skimming ATMs George Ou: Design flaw in wireless VoIP handsets endanger the enterprise Mary Jo Foley: Microsoft fleshes out small-, mid-size Windows server plans Microsoft suspends distribution of Vista SP1...
- Blog posts 2008-02-21
- H-Store: Complete destruction of the old DBMS order?
- H-Store: Complete destruction of the old DBMS order?Odd titleSeems an odd title for the article, since it almost reinforces the need for a backup/storage RDBMS along with the new H-Store.I do think the H-Store sounds like a great idea with enormous potential for certain applications, but is hardly the "complete...
- Discussion threads 2008-02-20
- H-Store: Complete destruction of the old DBMS order?
- Guest Post: Curt Monash reports from the front lines of a database revolution. Mike Stonebraker created much of the database management industry. Now he wants to blow it up. Via a project called H-Store [pdf file], he proposes to manage high-end OLTP databases entirely in...
- Blog posts 2008-02-20
- Microsoft declares its modeling love with a new language, 'D'
- Microsoft declares its modeling love with a new language, 'D'or maybeOr maybe its time to start using a managed language, professional IDE, and the .NET Framework to solve all the problems you mentioned above and many more! VB.NET or C# offer much better options than yesterday's languages.Not Invented Here[i]Maybe it's...
- Discussion threads 2008-02-05
- SAP-BusinessObjects: what was unsaid
- SAP-BusinessObjects: what was unsaidSAP sales of ORCL DBMSDennis, Unfortunately, you're dead wrong about SAP reselling $1bn of ORCL databases per year. Its not even close to that amount, even including maintenance fees.Ok thenThat is what I've been advised on many occasions and have no reason to disbelieve it. If...
- Discussion threads 2008-01-16
- Wide finder redux
- Wide finder reduxUgliest code contest?Murph, you're making my head hurt.Machine Setup"Notice first that for this to work as fast as possible your T2 has to be properly set up - with lots of swap split across the two fastest internal disks and ZFS configured for all external storage - something...
- Discussion threads 2007-12-20
- US-CERT warns of Microsoft Access Database attacks
- US-CERT warns of Microsoft Access Database attacksOh Nelly ,,,This is a no show . According to the Microsoft Zealots/Shills and what have you nots , that if this hasn't exploited their machine then it is non-existant .Just in, Hackers use code to Hack computers...Umm, can you say DUH?Affects ONLY one...
- Discussion threads 2007-12-12
- Smart Email Verifier (exe)
- Smart Email Verifier will check every e-mail address from a given mailing list and determine if e-mails are still valid. It does three levels of checking; first it will check the e-mail syntax, next it will verify the existence of the SMTP mail server and finally e-mail box on the...
- Software downloads 2007-12-12
- Enterprise software is crappy and it isn't going to change any time soon
- Enterprise software is crappy and it isn't going to change any time soonJava is the front end bloatJava is the front end bloat and it is a programming shortcut in the sense the developer doesn't have to write as much code.As for database performance, it's actually not the network or...
- Discussion threads 2007-12-10
- CompareData (msi)
- CompareData is a native Windows cross-dbms application that allows you to visually compare and synchronize data between two SQL databases using ODBC drivers. You can retrieve all/some data for a table/view from two databases and compare the data visually to see differences highlighted on the screen. You can also compare...
- Software downloads 2007-12-10
- Oracle's wall-to-wall software suite
- Oracle's wall-to-wall software suiteI don't understand the point of this middleware stuffYou have data, protected by constraints against inconsistency (an area where Oracle's DBMS product is, to be frank, embarrassingly weak) and you have programs that access and modify that data.What on earth is the point of middleware? I believe...
- Discussion threads 2007-11-18
- DataTime Reporting Solution - Universal (zip)
- Visual Query builder. Easy ETL and Data transfer from any DBMS to any DBMS. Universal Reporting / Charting from any DBMS. Data Integration for federate DBMSes. Database explorer, data dump. Excel, Text export from any DBMS- Excel multiple sheet merger or joiner. Version 23 Sept 2007 includes unspecified updates.
- Software downloads 2007-11-14
- Alventis (exe)
- Alventis Database is a Universal Information Manager that can record all your valuable data: free-form rich text notes, contacts, tasks, inventory, budget, employee records, resumes, sales leads, real estate records, personal collections. The number of table formats and data-entry forms is unlimited. Full-text indexing ensures that your searches are lightning-fast....
- Software downloads 2007-11-01
Premier Vendor Content Whitepapers, webcasts & resources from our Power Center Sponsors
- Which solar technology will survive?
-
At the Cleantech Forum in San Francisco, Todd Glass of Heller Ehrman moderates a discussion, among tech execs, on the various solar technologies making a difference in the green movement.
- Watch the video >>
- New entries posted to Know Issues, Best Practices and Workarounds Wiki
-
Latest Topics: Running virtual machines and DHCP can cause Intel® AMT to be inaccessible; Wildcard certificates are currently not supported for remote; Dell 755 returns a duplicate UUID during activation configuration.
- See the latest entries on the Intel Wiki >>
- The Cisco Mobility Resource Center is your source for FREE mobility solutions
-
The Cisco Mobility Resource Center offers FREE videos, downloads, podcasts and more, all designed to help small and medium businesses get mobile connectivity solutions, improve productivity and drive sales and revenue.
- New mobility solutions at the Cisco Mobility Resource Center
-
-
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 »
