Enterprise Data Management

Enterprise Data Management
There are various terms that are associated with Enterprise Data Management. Some of these terms are uml, olap, oltp, Data Warehouse, Data Mart and Multi-Tier Architecture. Subsequently, these terms were covered during the five week course of DMB405 and will be explained in further detail throughout the course of the paper. Although the paper will not be all inclusive to the detail of each term, it will touch upon the definition, their use and their place in Enterprise Data Management. The first term that will be discussed is uml and how it relates to the subject at hand.
uml is the industry acronym for the Universal Modeling Language. The Universal Modeling Language is used for software, business, hardware and organizational object structuring. In 1997, with the help of three men and their teams, uml was created and adopted as an industry standard by the Object Management Group (omg). The Universal Modeling Language is a collaboration of many different people and numerous modeling approaches put together as one unified standard for the purpose of enterprise data management. Not only is it now an industry standard in the United States, but also internationally. uml was created so there were not so many different modeling approaches to arrive at similar conclusions and solutions. Too many approaches can be confusing because things are not uniform. With the creation of a universal standard for modeling, diagramming and conceptual illustration, all stakeholders can in effect, be part of the process and understand the project more thoroughly. The standard creates a common theme amongst the vast array of data that makes up a complicated project and brings it to a level that all can partake in during the analysis and developmental stages.
Online Analytical Processing (olap) ??is an approach to quickly provide the answer to analytical queries that are dimensional in nature.? olap is part of the database system in that it allows for relational reporting and data mining. The capabilities of olap in the enterprise data management are great. It allows for effective business reporting in sales, marketing, performance management, budgeting, financial management and forecasting. Online Analytical Processing is a variant of the more traditional Online Transaction Processing (oltp) that was used prior to the introduction of olap. Although both olap and oltp both are used to produce data warehouses, oltp is considered the ?old mindset? that focused far too much on data structure with tightly controlled planning, schedules and milestones. olap, on the other hand, takes a far less structured approach to data processing. olap takes a more experimental approach to the methodology and is considered far more effective in completing the project. This type of newer approach can benefit the organization in the long run and leaves more room for more creative design.
The next term, as it relates to enterprise data management, is Data Warehouse. A data warehouse is a large collection of logical data that has been stored from many other operational databases, for the purpose of data analysis and collection. The information in the data warehouse allows the organization to go back and collect data in order to help them make better quality decisions based upon the findings. In addition, the use of a data warehouse can be for archival purposes and because of its nature, allows for more flexible and efficient data storage and research. It also allows the user to get a more unique look at the overall data instead of looking at the information from a day-to-day perspective. This gives the corporation the ?big picture? verses a small cross-section of daily activities and operations. A data warehouse is very beneficial, overall, because it allows for an organization to store their large volumes of data centrally and have the ability to strategically look at it when the reporting need arises. Because the data can become quite large, even for the warehouse, the ability to break it all down farther into data marts is essential.
Since data warehouses can become large, there is a need to break the information down even farther into smaller logical units. These smaller logical units are called Data Marts. Data Marts allow for greater efficiency and reporting by categorizing and storing data together that is more similar in relevance. Like the data warehouse, the data mart is designed to create a snapshot of the information, but there is a distinct difference between the two. The difference is that a data mart is designed based upon the predetermined use by the organization. If the organization has special and specific analysis requirements, they can create a data mart to collect and categorize specific data to meet their needs. Usually, a data mart is just a collection of databases based upon a specific subject or department. Unlike the data warehouse which contains all the databases of the enterprise, the data mart is smaller and more subject or focus orientated.
The last key term used for this paper is Multi-Tier Architecture. Multi-tier architecture usually refers to some sort of client-server setup found in an enterprise networked environment. The use of a multi-tiered architecture allows for greater scalability by incorporating a database server, application server and the client machine on the network. By adding the database server in a multi-tiered environment, processing functions are shifted more from the client or workstation and onto the database server. This allows for a more controlled system that is easier to upgrade and maintain. The database and the Database Management System (dbms) are centrally located on the database server and from there, can be distributed to other computers. Using this type of setup alleviates network congestion, improves processing, requires less demanding workstations, and makes it easier for the end-user and IT personnel by way of setup, maintenance and administration. This in turn benefits the organization as a whole as less time, money and effort are required to keep the systems running.
Overall, there are many aspects to enterprise data management. This paper has briefly covered some of the elements that are associated with the management of data in the workplace. All these elements, uml, olap, Data Warehouses and Marts and Multi-Tiered architecture play an important and significant role in managing data. Data is essential to the livelihood of the organization and understanding the role and place of each aspect is crucial. Realizing there are industry standards for modeling and diagramming help keep all stakeholders on the same project page. Proper use and approach of olap is key along with the setup and utilization of data warehouses and marts. Finally there is the architecture you use to tie it all together. Each area builds upon the other and is successive steps in the stages of the Systems Development Life Cycle. Although each is different, they all share a common interest. This interest is to work together to complete a whole data system that the entire corporation can use effectively and enjoy.

Enterprise Data Management 8.5 of 10 on the basis of 2677 Review.