Writing Homework Help
MIS 610 Grand Canyon University Peer Discussion Responses
I’m studying and need help with a Writing question to help me learn.
Discussion 1: Sunil Lakhanpal
Relational Database Management System (RDBMS) is a type of database management system that stores data in the form of related tables. It establishes a well-defined relationship between database tables. And the programmers can use SQL language (SQL) to manage data in RDBMS easily.
RDBMS have led the market since 70’s and over the period individuals has gained lot of expertise on the relational databases. RDBMS is very strong and well-established database management system, and there are well skilled resources are easily available in the industry. This makes more efficient option and helps companies to get the right resources onboarded to take care of their RDBMS based databases.
The RDBMS database management systems are expensive to setup and maintain. In order to setup the relational databases it generally needs to purchase special software and licenses.
And from the cost perspective and handling large and complex data some companies prefer to use other non-relational databases management systems, such as Object Oriented Database Management System (OODMS).
OODBMS system that combines the database capabilities with the object-oriented programming language capabilities. The programmer can use object-oriented concepts such as inheritance, polymorphism, encapsulation and database capabilities such as atomicity, consistency, isolation, and durability in OODBMS (Paterson J et.al, 2006). These databases provide advantages such as extensibility of systems, code reusability, licensing cost and maintainability.
In the past the data generation sources were selective and RDBMS system was well established to store such data, however post internet and IoT era there are vast sources of data generation and in different forms. And there are lot business values resides in the non-relational databases. Hence, companies are using the OODBMS database management systems to store and mine such type of data that can help the companies to grow their business exponentially
Reference:
Paterson, J., Edlich, S., Hörning, H., & Hörning, R. (2006). From RDBMS to OODBMS. The Definitive Guide to db4o, 363-392.
Discussion 2: Mentor Dimgba
Relational Database Management System, RDBMS is a type of database that stores data in a well-organized composite arrangement, comprising of rows and columns, which makes it effortless for the processing of data such as fetching, viewing, updating, deleting and manipulating the contents of the tables, as all the data in each and every table will be holding a relationship with the contents of other tables in the system and all the tables in the database system will be associated to the tables with similar properties according to Lemahieu et al., (2018). It considers the relationship between the tables by using primary keys, foreign keys, and indexes. It may be more efficient for a company to utilize an RDBMS based on workforce skill and availability. Some of the key advantages RDBMS offer include: Avoid Data Redundancy: RDBMS utilizes keys and indexes in the table to avoid any data redundancies. Suitable for Wider Range of Apps: Since RDBMS can process the complex and large amount of data, it is suitable for wider range of Apps relative to OODMS. Normalization of Tables: One can normalize tables in RDBMS system so that they follow a proper structure of rows and columns. Same is not possible in OODMS. Security for Data Integrity: DBMS doesn’t provide any security with respect to data integrity, while RDBMS defines data integrity constraint for Atomicity, Consistency, Isolation, and Durability.
Because an ODBMS stores exactly the same object model that is used at the application level, both development and maintenance costs can be reduced. With an OODMS, there is no need to develop two data models: An object model in the application and a relational model stored in the database. This is not needed because an OODMS uses the same object model as the application. Maintain two data models. An OODMS eliminates the maintenance cost of keeping the data models synchronized. Develop mapping between the relational and the object models: This is not needed because an OODMS uses the same object model as the application. Maintain the mapping between the relational and object models: An OODMS eliminates the maintenance cost of maintaining the mapping whenever there is a change to the object or relational model.
The world of data management and administration is rapidly changing as organizations digitally transform. In a presentation at Data Summit 2019, Craig S. Mullins, president & principal consultant, Mullins Consu lting, Inc., looked at how database management systems are changing and adapting to modern IT needs. In the presentation titled Database Trends 2020: The New World of Database Technologies, Mullins showed how cloud, analytics, data security, NoSQL, IoT and other trends are affecting DBAs and their roles within modern organizations. These are some of the key trends that Mullins sees: The database software market continues to grow: Dynamic DBMS (what IDC calls the NoSQL market) is expected to grow at a five-year CAGR of 30.9%. IDC still expects it to fall short of reaching 10% of total operational DBMS revenue by 2022. Also, increasingly, vendors are marketing multimodel database systems: Single DBMS can manage data using different models including relational, NoSQL, etc. Furthermore, RDBMS, database administrators always relied on scaling up or buying bigger, expensive, multiple servers as database load increased rather than scaling out or distributing the database across multiple hosts. The new breed of NoSQL databases are designed to expand transparently and horizontally to take advantage of new nodes, and they’re usually designed with low-cost commodity hardware in mind. For NoSQL, servers can be added or removed from the data layer without application downtime.
Reference
Lemahieu, W., Broucke, S. V., & Baesens, B. (2018). Principles of database management: The practical guide to storing, managing and analyzing big and small data. Cambridge University Press.
https://www.dbta.com/Editorial/News-Flashes/Key-Database-Trends-Now-and-for-the-Future-131888.aspx
Key database trends now and for the future. (2019, May 21). Database Trends and Applications. https://www.dbta.com/Editorial/News-Flashes/Key-Da…
Discussion 3: Joshua Lunsford
A relational database management system (RDBMS) uses mathematical theory in a relational data model to structure data in the form of tables consisting of rows and columns (Hoffer et al., 2017). While data in the RDBMS is defined in tabular format, an object-oriented database management system (OODMS) stores data as objects for use in object-oriented programming (timothy, 2001). It can be more efficient for a company to utilize an RDBMS because RDBMS have been around for a longer period of time, where OODMS are relatively new. RDBMS is an established technology that is well understood by many, making it easier to find the necessary workforce. RDBMS offer a great general-purpose solution to many data management tasks, along with a more simplistic structure that is more user-friendly compared to the complex structure found within an OODMS (Sabău, 2007).
OODMS can offer cost savings because it utilizes a single data model. This is not possible in a RDBMS because according to Sabău (2007), these systems usually have multiple models consisting of the “Entity Relationship diagram to model the static parts of the system and a separate model for the operations and behaviors of entities in the application.” Its more cost effective to maintain a single model because it eliminates the resources required to keep the data models synchronized. Less development work is required which means the OODMS can be managed by a smaller team.
Since the RDBMS offers a well-rounded solution for data management, it will likely continue to be an important tool for business in the future. However, the OODMS has the potential to outperform an RDBMS because it is better poisoned to handle complex interrelated data. This could encourage some companies to switch systems if their operational data becomes more complex.
References
Hoffer, J. A., Ramesh, V., Topi, H. (2017). Modern database management. Pearson Education Limited. ISBN: 978-0133544619
Sabău, G. (2007). Comparison of rdbms, oodbms and ordbms. Informatica Economica Journal. https://www.semanticscholar.org/paper/Comparison-o…
timothy. (2001, May 04). Why aren’t you using an oodms? Slashdot. https://slashdot.org/story/01/05/03/1434242/why-ar…
Talk to us support@bestqualitywriters.com