Database Management System (DBMS)


DBMS means "Database Management System."A DBMS is a set of software programs that controls the system organization, storage, management, and retrieval of data in a database. DBMSs are categorized according to their data structures or types. The DBMS accepts requests for data from an application program and instructs the operating system to transfer the appropriate data. The queries and responses must be submitted and received according to a format that conforms to one or more applicable protocols. When a DBMS is used, information systems can be changed more easily as the organization's information requirements change.A DBMS allows different user application programs to concurrently access the same database. DBMSs may use a variety of database models, such as the relational model or object model, to conveniently describe and support applications.

Well known DBMSs include Oracle, IBM DB2, Microsoft SQL Server, PostgreSQL, MySQL and SQLite. A database is not generally portable across different DBMS, but different DBMSs can inter-operate to some degree by using standards like SQL and ODBC to support together a single application. A DBMS also needs to provide effective run-time execution to properly support (e.g., in terms of performance, availability, and security) as many end-users as needed.

Many DBA's think that RDBMS is a Client Server Database system but thats not the case with RDBMS.
Yes you can say DBMS does not impose any constraints or security with regard to data manipulation it is user or the programmer responsibility to ensure the ACID PROPERTY of the database whereas the rdbms is more with this regard bcz rdbms define the integrity constraint for the purpose of holding ACID PROPERTY.

People who read this post also read :



10 comments:

I really happy to say its an interesting post to read I learned new information from your blogs. you are doing a great job.keep it up!!
Home Tutors in Lucknow | Home Tutors Lucknow

Really appreciate your post, and you explain each and every point very well. Thanks for sharing this information.
Master data management companies

Thanks for sharing this informative article in detail on Database Management System. If you have any requirement to Hire Database Managers for your project. Please visit us.

Great article, thank you for sharing the information.
Best Data Management Company/a>

Discover the ideal ERP software for small businesses. Streamline operations, boost efficiency, and drive growth with our tailored ERP solutions. Explore now for enhanced business management!

Post a Comment

Share

Twitter Delicious Facebook Digg Stumbleupon Favorites More