Sign Up Now
Get instant access to over 1 million+ study documents
OR
Already registered? click here to login
By creating your account, you agree to our terms of service, privacy policy and student honor code.
¶ … Enterprise DBMS
Implementing an Enterprise Database Management System
Enterprise Database Management Systems (DBMS) are the catalyst and foundation of many of the enterprise software applications, platforms and enterprise systems in place today. Having progressed from being a relational database in the past to often being used as the foundation for complex process workflow and transaction systems (Casati, Castano, Fugini, 2001) the DBMS architecture has taken on a central role in enterprise computing. The intent of this paper is to analyze the DBMS implementation critical success factors in enterprises, in addition to analyzing the advantages and disadvantages of enterprise DBMS systems and platforms.
Analysis of DBMS Implementation in the Enterprise
In many respects the critical success factors of Enterprise Resource Planning (ERP) systems reflect or mirror those for DBMS systems, as the latter systems are often platforms for ERP applications (Lungu, Velicanu, Botha, 2009). When DBMS systems are implemented, it requires the entire culture of a company or organization to change. As a result, the major forces or catalyst of successful change have little to do with technology and are instead more focused on changing processes and systems to make them more efficient. The critical success factors for the implementation of DBMS systems include endorsement and active support from the CEO of the business, the active participation...
All three of these factors, when managed well, can lead to successful DBMS system development and customization to the needs of a given business or enterprise. Not done well, especially the areas of change management and redefining the workflows of how people do their jobs, can lead to significant resistance and even creative resistance in the form of rejecting the new system, refusing to use it and reverting to manual approaches instead (Remus, 2007). The impact of the CEO and executives' buy-in and endorsement of the system is the single biggest catalyst for successful change management occurring over time however (Remus, 2007).
For a DBMS implementation to go well and accomplish the system objectives, all three of these factors need to be continually worked on and fine-tuned to the needs of the company. The process-based integrations must also be completed and tested to ensure the DBMS is delivering the right response to queries and request for information (Casati, Castano, Fugini, 2001). In addition the applications being support must also be tested and a specific change management plan created to ensure support for the various departments using specific applications in key departments. An example of this type of dynamic can be found with a Customer Relationship Management (CRM)…
References
Fabio Casati, Silvana Castano, MariaGrazia Fugini. (2001). Managing Workflow Authorization Constraints through Active Database Technology. Information Systems Frontiers: Special Issue: Information Systems Frontiers on Workflow, 3(3), 319.
Tim Gouldson. (2001, January). CRM drives need for bigger, better data warehouse. Computing Canada, 27(1), 15.
Lungu, I., Velicanu, M., & Botha, I.. (2009). Database Systems - Present and Future. Informatica Economica, 13(1), 84-99.
Mercioiu, N., & Vladucu, V.. (2010). Improving SQL Server Performance. Informatica Economica, 14(2), 55-60.
management system (DBMS) is a program that provides the user with access to the data and also helps them in transforming their raw data into meaningful information. The database management system (DBMS) is therefore a collection of programs that helps in the management of data structure as well as in the control of access to the data that is stored in the database. The DBMS systems help users in
These factors further accelerate the value and TCO of databases over time. Describe the features, tools, and utilities of Structured Query Language (SQL). How can tasks be automated with SQL? SQL has specifically been designed with features, tools and utilities to enable programmers to support nth-tier data architectures in addition to legacy client-server computing scenarios. The development and continual improvement of the features, tools and utilities of SQL for automating tasks
Unit Three writing assignment: How are partner relationship management (PRM) and employee relationship management (ERM) related to customer relationship management (CRM)? As the primary objective of CRM is to provide businesses with a 360 degree view of their customers, Partner Relationship Management (PRM) is used for providing companies a 360 degree view of their distribution channel partners. Employee Relationship Management (ERM) systems also use the same foundation of CRM, yet the
Database Administrator for Department Store Scenario The department store has expanded in the local region by opening five more bookstores, and the bookstore has launched a series of marketing campaign to increase sales and attract new customers. The objective of this technical report is to develop a plan to create and maintain an enterprise-wide database system that will assist the bookstore to hold the inventory and sales data. The database design will
These personal productivity systems also tend to be islands of customer data that need to be integrated into larger customer information systems to be effective (Zahay, 2008). Enterprise-class DBMS are capable of integrating to broader process workflows due to their underlying technical design. In addition, these DBMS are often used for more advanced customer strategies including data mining, business analytics of customer bases, and the development of long-term loyalty
Enterprise Database Management System This master's level paper discusses The Use Of Enterprise Database Management System and outlines the ways in which an enterprise DBMS may be used by a Government contracting Company to expand its business. The paper also highlights the attracting features and functionality offered by a DBMS. The Use Of Enterprise Database Management System Every organization in the world today stores, retrieves and manages colossal amount of data. The