Database Management Systems (DBMS)
Using the Web, review one of the products listed below. Then summarize for us:
- What is a DBMS?
- What are the main features and functions of the software you selected?
- In what companies has that database management system (DBMS) been implemented, and for what purpose?
- According to the information that you found, what are three strengths and weaknesses of the product you chose?
The three products you may select from are (select only one to discuss):
- Relational DBMS
- Object DBMS
- Multidimensional DBMS
Guidelines and Points:
- make your original posting within four days of class session by 11:55 p.m. EST
- make 1 or more responses to classmates (see rubric below for grade details) by next class by 11:55 p.m. EST
- See the grading rubric below for details.
I need a respond to :
Joshua
What is a Database Management System or DMBS? A DMBS is a specialized software that can create, handle, and control a database. It is a life-saving tool in order to properly manage data within a database in an organized and professional manner. The one specialized software related to DMBS that I selected for this discussion, was Relational Database Management System. The main primary function of the Relational DMBS is allowing the user to identify and work with data that is in RELATION with another piece of data that is stored within the same database.
Many companies, surprisingly, use a Relational Database Management System in today’s world. One prime example of a company using this DMBS is Oracle! Oracle is considered to be one of the most commonly used Relational Database Management System companies to this very day! Microsoft Access is another very common and popular source that uses a Relational Database Management System.
Here are three great benefits of the Relational DMBS that I found to be quite helpful –
Speed, Accessibility, and Efficiency.
While having a Relational Database Management System running, you have three great things that will help you significantly, having that accessibility-ready for you whenever, and the speed that comes with the service will allow you to see the data quickly! And finally having that efficiency in your database is truly a great thing to have in itself while running a databse.
And here are three sad disadvantages of the Relational DMBS that I found to be very important to know –
Expensive Software, Time Consuming, Stressful.
If you wish to achieve a proper working Relational Database Management System, you have to know that it will take a lot of time in order to properly work, and some software needed can be expensive depending on the service you wish to have. And lastly, it can be stressful to be set up.
Post 1
Can I have a respond to this : Salih,A DBMS is a tool, a set of programs and functions to efficiently view and modify data in databases. The main features of a relational DBMS include functions such as tables, columns, rows, primary keys, foreign keys, and entity relationships.In almost every company today, there exists a form of a database. To maneuver this database the utilization of a database management system is implemented. Take Amazon for example. Every time someone orders something from their website, that item is found in a database, its quantity and its description, its price, etc. Then through trigger executions, code runs to modify the data that directly corilates with this item and with your shopping cart. It allows them to keep track of shipment, shipping, stock, and feedback from users.Strengths is that it these kinds of databases can support refrential integrity, which means that the information is synchronized between tables to make sure that its correct and up to date. Another one is the unique key identifiers which allow us to make use of quick index searches rather than reading all of the information one by one to find what we are looking for. thirdly, it is easier to work with compared to its legacy counterparts. Weaknesses is that it is not as machine efficient as its legacy counterparts, they cannot handle complex data, and cannot carry out business intelligence processes on their own.
0 comments