(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-2009 The Computer Language Company Inc. All rights reserved. |
Additional Resources
- MightyQuery 1.0.1 (Windows)
- MightyQuery is a single user SQL database management software working with data stored as comma separated values (.csv, .txt) in plain, flat, textual files. It is serverless, self-contained, simple and effective SQL DBMS for querying CSV files. In contrast to most database systems, MightyQuery does not require neither server installation,...
- Software downloads 2009-10-27
- Friendly SQL 1.3 (Windows)
- Friendly SQL for Oracle is a lightweight, zero-configuration Oracle client featuring a SQL Editor and Visual Database Client Browser. With enterprise-friendly features like Microsoft Office integration, saved password encryption, and fully cancelable operations, Friendly SQL enables users to quickly and easily work in any Oracle 8i or higher database. **...
- Software downloads 2009-10-09
- DB Solo 3.7.5 (Windows)
- DB Solo is a powerful database development and management tool for developers and DBAs. DB Solo has an intuitive user interface that allows you to explore and manage your database objects as well as execute your own ad-hoc queries. DB Solo supports most major relational database products available today including...
- Software downloads 2009-09-02
- DB Solo 3.7.5 (Mac)
- DB Solo is a powerful yet affordable cross-platform database development and management tool for both developers and DBAs. With its rich feature set, it is comparable to tools that are orders of magnitude more expensive. DB Solo has an intuitive user interface that allows you to explore and manage your...
- Software downloads 2009-08-31
- CompareData 1.5.1 build 120 (Windows)
- 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 2009-08-11
- Salesforce.com: rethinking the database
- While attending Fortune's Brainstorm event, several of us took the opportunity to sit down with Parker Harris, Salesforce.com co-founder and EVP technology. To say it was our first outing as Irregulars with the company, Parker was remarkably open and congenial, often straying into territory that would otherwise drive hyper controlling...
- Blog posts 2009-07-28
- What should SAP do with its $5bn war chest?
- What should SAP do with its $5bn war chest?SAP should continue to kick Microsofts ERP butt!Time for MS to go down. MS purchased Great Plains low level ERP and Navision mid level ERP and just painted pretty pictures on the interface.SAP can with my help add real business support to...
- Discussion threads 2009-07-06
- Nehalem-EX - 8 cores, 16 threads, 2.3 billion transistors, very cool!
- Nehalem-EX - 8 cores, 16 threads, 2.3 billion transistors, very cool!Um, that should be good enough I guessntIntel needs to spec a backplaneIt would be nice if Intel would speck out an 8x backplane that processor modules could plug into. That way multiple manufactures could build compatible modules and backplanes.With...
- Discussion threads 2009-05-27
- DTM Data Modeler 1.08.05 (Windows)
- DTM Data Modeler is a CASE tool for database developers that supports both forward and reverse engineering. It is an easy-to-use tool allowing you to work both with logical and physical data models in the form of an entity-relationship diagram. The product is intended for database architects and developers and...
- Software downloads 2009-05-26
- Where Platform-as-a-Service (PaaS) must go next
- More Robust Apps Needed NOW! Platform-as-a-Service is hot these days. Vendors like NetSuite and salesforce.com have their clouds as to players like Amazon and Google. Cloud providers like to promote their capabilities to application developers and, in doing so, create an ecosystem full of low-cost applications for...
- Blog posts 2009-05-08
- Kickfire: Released for all the right reasons, but with the worst timing?
- Kickfire's hardware-accelerated MySQL appliance blows the doors off monster Oracle database servers in equivalent TPC-H benchmarks in a tiny fraction of the cost, space, storage and power usage. Last week, during their press briefings the future of the company looked bright indeed. There's only one...
- Blog posts 2009-04-21
- Australian Firm Gains Performance and Scalability With Migration to SQL Server
- Having a successful product can place lots of pressure on IT. That's what BT Financial Group BT found after the company's Wrap application for managing investment portfolios proved so popular that the influx of new customers threatened to outpace the capacity of its application infrastructure, based upon a 32-bit Database...
- Case studies 2009-04-01
- Top Ten SAS DBMS Performance Boosters for 2009
- It has been debated that performance and portability are orthogonal. The author feels that the point where these two cross can be shown on a graph with software and/or usage techniques that are portable in nature. For example, some of the options discussed are global to SAS and can be...
- White papers 2009-03-18
- MySQL vs PostgresSQL
- MySQL vs PostgresSQLStability vs. AbilityUnsurprisingly, my reaction to this post is to relate it back to what we were discussing about competition and the "evolution" of software in the previous Talkback.Murph, I think you're arguing at cross purposes here. Elsewhere you argue that competition is good because otherwise we'd all...
- Discussion threads 2009-03-17
- IPTunnelManager 1.5 (Windows)
- The program IPTunnelManager is used for IP tunneling with the options for compressing and encrypting traffic. Thus, the program makes it possible to create a secure connection for any application or service using TCP/IP (HTTP, FTP, SMTP, POP, NNTP, SNPP, Telnet, etc.). It is especially important for those TCP/IP services...
- Software downloads 2009-02-10
- Webcast: Best Practices in Pervasive BI: Proven Strategies for Self Service BI in a Tough Economic Climate
- Business intelligence BI is not just about reporting anymore. It is migrating from being a back and middle-office tool for productivity and efficiency gains to being a major, strategic corporate asset used for competitive differentiation. This Webcast will explore how BI technologies, architectures, and approaches are evolving across multiple dimensions....
- Webcasts 2009-01-28
- S-GATE: Data-Level Access Control for Heterogeneous DBMS Environments
- The attendee of this webcast will learn why Guardium S-GATE is the only cross-DBMS technology that blocks privileged users from accessing sensitive data - without disrupting applications or changing database configurations. The attendee will learn how S-GATE provides preventive controls that complement "After-the-fact" detective controls such as monitoring and audit...
- Webcasts 2009-01-01
- Thomson Peterson's Gets Performance Boost by Using ScaleOut StateServer
- Thomson Peterson's is a leading provider of live, online, and print educational solutions for students, families, schools, and educators in the areas of test preparation, admissions, financial aid, and career guidance. Thomson Peterson's stored their session-state data for their online applications in a DBMS, but needed to speed up user...
- Case studies 2009-01-01
- How Dell IT Simplified Database Security for SOX, PCI, SAS 70
- The attendee of this webcast will learn how to simplify database security and compliance - without impacting performance or creating more work for the DBAs and security teams. The attendee will also learn how Dell's IT group replaced its homegrown scripts and native database auditing with Guardium's automated, cross-DBMS platform...
- Webcasts 2009-01-01
- Vulnerability Assessment and Change Audit System
- Identifying database vulnerabilities such as unpatched systems and misconfigured privileges - and preventing unauthorized changes - enables organizations to proactively address a range of internal and external threats, while addressing SOX and PCI compliance requirements. The attendee of this webcast learn about Guardium 7's Vulnerability Assessment VA scanning module and...
- Webcasts 2009-01-01
Premier Vendor Content Whitepapers, webcasts & resources from our Power Center Sponsors
- 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 >>
- The best support in the Linux business
-
If Linux is going to power your mission-critical applications, you'd better have the best support known to business. Novell was rated the top provider of Linux technical support.
- 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 >>
- Keep Up With The Latest In Document Management with The DocuMentor.
-
Doc delivers the scoop on today's enterprise content management, printer maintenance, and all other issues related to document management. It's the DocuMentor Blog.
- Learn more >>
-
-
Smart Tech
Expert advice on innovations in healthcare and the green technologies that make it happen.
Find out more
-
Smart Business
Discussion and advice on management issues that revolve around making your world smarter and more useful.
More Smart Advice
-
Smart People
The best and worst moves in the management and strategy trenches.
Learn More
