standards - DBMSs

standards - DBMSs definition - computer

Database management systems (DBMSs) have their own proprietary formats for storing data. For example, a header record with a unique format that contains identification data is typically placed at the beginning of each file. Codes may also be embedded in each record.

Most DBMSs have an import and export capability that converts popular database formats into their proprietary format. If not, the program usually can import and export a plain EBCDIC or ASCII file, which is stripped of all proprietary codes and can be used as a common denominator between both systems. If conversion facilities cannot be found, a custom program can be written to convert one database format into another if documentation describing the old format is available.

The application program "talks" to the database in the SQL language typically. In theory, that means any application program requesting data in SQL would work with any DBMS that supports it. Like everything else however, there are dialects of SQL. Whatever special features exist within the DBMS, proprietary syntax is needed to activate them, thus automatically making one DBMS incompatible with another.



Computer Desktop Encyclopedia THIS DEFINITION IS FOR PERSONAL USE ONLY
All other reproduction is strictly prohibited without permission from the publisher.
Copyright © 1981-2009 by Computer Language Company Inc. All rights reserved.

Comments
Improve this definition.
Do you have more to add? Share your linguistic knowledge or observation.
/Register to save your comments.