Home‎ > ‎3 pm class page‎ > ‎

Kirk,Barbra Joan



Enterprise Database Management Systems (Enterprise DBMS)

Here is the link defining Database Management Systems, cited through Wikipedia: DBMS. Wikipedia also features Enterprise Database Management. Utilizing both assists in properly defining the phrase Enterprise Database Management Systems (Enterprise DBMS).

Formal Definition and Classification of DBMS and Performance Techniques for educational purposes via www.cs.wustl.edu.      

Enterprise DBMS attempt to standardize a practice, or many practices, within a company amongst a network of users and their corresponding computers. The database supports different applications to be operating at all times. DBMS have evolved over the years, to include various styles, such as navigational, relational, SQL, subject oriented, and the 20th century's most recent, NoSQL systems (Wikipedia, 2011). Data is placed in the most compact physical way possible to be read by computers seeking the specific data, often categories by topic. The video above illustrates an DBMS example (a library) and explains how to read diagrams, such as the diagram featured below from DiscussTech.org (Link to image on discusstech.org)

YouTube Video





The program users are the master of the database. Learning how they manage the databases is better understood by examining the type of management system and determining the specific objective users are looking to obtain. One example of this is located on DiscussTech.org titled Difference Between DBMS and RDMS 

While many general, but informative details regarding Enterprise DBMS are located via the links, being in touch with how these database systems exist in the world today will be functional knowledge moving forward. Available Enterprise DBMS on the market today include Microsoft Access, Filemaker, DB2, and Oracle.

Microsoft Access was one of the pioneering systems to store, organize, and easily retrieve data for nearly any situation. The latest version is now titled Microsoft Office Access. DB2 is IBM's version of Microsoft Access, officially termed IBM DB2 Enterprise Server Edition (
Wikipedia, 2011).The newly innovated IBM compatible Filemaker has gained greater awareness, having originally been designed for Macintosh software systems (Wikipedia, 2011). Oracle is well-recognized for there work with DBMS, officially titled Oracle RDBMS. A short tutorial for Oracle Corporations database work is featured below, having made great strides in computer science arena.
 

Oracle Architecture - IN 10 Mins!

One DBMS does not have to be the sole controller for the database. Rather, depending on the size of the database and how it is attempting to assist, more than one DBMS can coexists.


While companies can still achieve results with legacy systems, databases management systems of today are proving to be more and more helpful in managing data. The importance of the databases communication with it's sources is anticipated to become more and more streamlined with the language of SQL. Nonetheless, the modeling language of each database models that of its corresponding database management system (Wikipedia, 2011). With the Enterprise DBMS of today, it would be difficult to envision data management in the workplace without them. 


                                                                                                                            

 

 


Comments