StudentShare
Contact Us
Sign In / Sign Up for FREE
Search
Go to advanced search...
Free

Database System Specifications in Mayo Clinic Medical Center - Case Study Example

Cite this document
Summary
The paper "Database System Specifications in Mayo Clinic Medical Center" highlights that the Mayo Clinic Medical Center’s database is aimed to offer better business support. In this scenario, we will cover all business working and handling areas approximately…
Download full paper File format: .doc, available for editing
GRAB THE BEST PAPER93.3% of users find it useful
Database System Specifications in Mayo Clinic Medical Center
Read Text Preview

Extract of sample "Database System Specifications in Mayo Clinic Medical Center"

DATABASE SYSTEM SPECIFICATIONS Database System Specifications Affiliation Table of Contents 3 2. Introduction 3 3. Business Overview 3 4. Problem Situation 4 5. Proposed Solution 5 6. Advantages of New System 5 7. Recommended database application 6 8. Database Resource Required 6 9. Data warehousing and Data mining 7 10. Database quality, integrity, and security 7 10.1. Database Quality 8 10.2. Database Integrity 8 10.3. Database Security 8 11. Role of the database administrator 9 12. Design of the DBMS 9 13. Database System queries, forms, and reports 10 13.1. Forms 10 13.2. Reports 11 14. Conclusion 11 15. References 12 1. Abstract Information has turned out to be a most significant and vital resource of any business. Database is considered as the main technology to manage and store this limited resource. Presently databases are the vital need for every corporation or business. Indeed, the databases are vital for the business and corporate management. When any damage to this business resource occurs then the whole business can go down or may function improperly. Through seeing this huge development in technology and its potential advantages to the business “Mayo Clinic Medical Center” has decided to implement a new database system technology. This paper presents a detailed analysis of basic areas of the new technology. 2. Introduction Data and information are the most valuable resources for any business or corporation. Therefore, the development and implementation of databases to store this valuable business for corporate working has turned out to be a major part of almost every corporation or business sector. In addition, this development and implementation of the databases has offered great advantages to the organizations for an effective management of their business activities. This paper throws light on the development and analysis of a database system for “Mayo Clinic Medical Center” that is health care business with a variety of off-site campuses interacting within its health system. This business is operating through different working and business problems. The main objective behind this research is to outline the problem areas and then suggesting most suitable solution for these problems. 3. Business Overview Business Name: Mayo Clinic Medical Center Business Area: Heath Care Business Present Working Structure: Decentralized Mayo Clinic Medical Center is a health care business that is working through a chain of off-site campuses. The working of this business is traditional in nature and relying upon the manual ways of data and information handling. In this business, there is an utmost need of a constant link among the distant working teams and main campuses. To serve this purpose, they need well qualified staff and suitable office structure. Now the management of the Mayo Clinic Medical Center has decided to establish a new database technology framework for the corporate. The main intention of the Mayo Clinic Medical Center management is to potentially improve the overall corporate performance and working capabilities. 4. Problem Situation As discussed above the business of Mayo Clinic Medical Center is currently running through manual ways. In such scenario, the overall workload and working style is more rigid. All these problems lead to less effective working performance. At present, the data of business is paper based or semi automated which is stored in MS-Excel sheets. Under these circumstances, the problem they are facing is the amount of data that is huge. Thus, they can’t perceive and conclude some valuable information from this data. This data seems to have no worth because it is really hard to extract some valuable facts and figures from this data. The business of the Mayo Clinic Medical Center is currently facing critical problems in the following areas of information management: Event handling Business decision making Huge data management Daily operations handling Response and management Business data analysis Business planning Resource handling Facility analysis HR management 5. Proposed Solution The effective management of the above stated operations is possible through the implementation of new database system. This will facilitate while developing and planning information for new employments. As Chou, Bindu, & Chou (2005) stated that corporate information is the base of each corporate critical decision making (Chou, Bindu, & Chou, 2005). In this scenario, the Mayo Clinic Medical Center needs to develop a database to store this huge information in an effective way as compared to presently stored data. For effective management of the Mayo Clinic Medical Center, the new database system needs to be web based system which will certainly increase efficiency to monitor, collect, enter and run customizable reports for each site’s data or as an organization as a whole. In this scenario, we have decided to implement a web based solution that is a relation database system with suitable graphical user interface at front end that will be available for all workers of business for the purpose of entering, analysis, updating and sharing of data. 6. Advantages of New System The new system at Mayo Clinic Medical Center is aimed at offering a better business and corporate working support. In this scenario, some of the main advantages of this business system are outlined below. These are the main facilities and advantages those will be attained through the new technology of an online database system: (Hoffer, Prescot, & Topi, 2009; Turban, Leidner, McLean, & Wetherbe, 2005) Back-office information management Web based data handling Finance management Human Resource management In time business information New Technology based infrastructure Easy way of working Better data collection Easy management of data Minimum conflicts among data formats Easy data sharing among all the divisions of the corporate Less or no dirty data In time handling of operations Enhanced decision making Effective data sharing among all business divisions and staff 7. Recommended database application The proposed database will be SQL Server based database that will facilitate for an effective management and handling of overall business data. The main purpose of this database is to capture and manage business operational data and properly handling incoming and outgoing business information. In our case, we will use the “Crystal Reports” software for business reports preparation and overall analysis of the business data. 8. Database Resource Required In this area, I will outline some of the main resources which will be required for the overall database development: Cost - $2000 Software: Win XP, SQL Server 2005, PHP, Crystal Reports, CASE tools for designing Hardware: P-4 System with 512MB RAM and 20GB hard disk space 9. Data warehousing and Data mining In scenario of Mayo Clinic Medical Center business, the management will always desire effective business decisions. In this regard we need a reliable technology that is able to facilitate the effective business handling and in time assessment for dealing some of the main business problems. Data warehousing and data mining techniques are really necessary for effective business intelligence. For an effective enterprise resource plans and decision making, organizations need more effective business reporting and intelligence. In the scenario of Mayo Clinic Medical Center business the data warehouse and data mining based business intelligence system will offer better support for corporate decision making. This system will offer competitive advantage over other organizations through the effective business decision making. In addition, this system will offer quality data management and in time decision making. This system will also offer quality business support through quality data management. These paradigms will be used to manage huge business data of Mayo Clinic Medical Center that can be used for a lot of other business tasks which are almost impossible to handle with simple database systems (Turban, Leidner, McLean, & Wetherbe, 2005; Inmon, 2002; Laudon & Laudon, 1999). 10. Database quality, integrity, and security Considering the database quality we need to evaluate the performance of new web based system. This performance can directly be related to database quality, database integrity and database security. For ensuring overall business system’s performance and working efficiency we need to consider all these areas so that we can ensure effective system support to the business: 10.1. Database Quality For business database system the database quality is one of the main aspects that are mostly needed for an effective business analysis and decision making. In this regard, the database quality can be achieved through well defined database design. The effective database design is the key to make an enhanced database system with quality data (Hoffer, Prescot, & Topi, 2009). 10.2. Database Integrity Regarding the database integrity we need to make the overall database a single entity of contrail. The traditional business working of the Mayo Clinic Medical Center business is operated through the de-centralized business arrangement. In case of new web based technology platform implementation, we can achieve better business support because this system is a centralized data repository. The main advantage of this centralized data repository is an effective and more enhanced management. We can also apply effective security parameters to this data repository. 10.3. Database Security Dawson, Vimercati, Lincoln, & Samarati (2001) stated that despite advances in the area of legal access control in database systems, currently information repositories are becoming vulnerable to data association attacks and interference that results in severe information leakage. With no support for copying beside these attacks, sensitive business information is quite open to others for misuse. The capability to defend information disclosure besides similar offensive outflow would be a huge benefit to public, governmental as well as private institutions. Nowadays all these issues require more security and then making portions of their data obtainable for external release (Dawson, Vimercati, Lincoln, & Samarati, 2002). Some of the main database security issues can be database hacking, virus attack, illegal database intrusion, data deletion or wrong entry. All these problems can create a huge damage to the business database and a huge business problem. Under these circumstances, we need to take some effective actions regarding safety of the business data. These actions can be the deployment of the security firewall, effective password based security, anti-virus programs and enhanced administrative controls (Baker & Wallace, 2007; Ghosh & Swaminatha, 2001). 11. Role of the database administrator The traditional role of database administrator is presently changing. The Mayo Clinic Medical Center’s database administrator will be a most important person for the handling of overall business database setup. However, at the present, database administration deals with the modeling of data as well as treating data as an organizational resource. Database administration also deals with the accomplishment of the different kinds of databases that are in use. Database administration is generally carried out by a data administrator. The major role of database administrator is to perform as a technical designer as well as manager of the database (Hoffer, Prescot, & Topi, 2009). 12. Design of the DBMS Database design has really high importance in the overall system design and effective management of the business. The design of the database is the first step toward the successful development of the database system. A more normalized database design will offer minimum data redundancy. Minimum data redundancy means that our system will offer more enhanced performance by taking less space and less processing power. Another main advantage of the effective database design is the support for business process. A database system which is more aligned to business working and operation can offer better business handling operational support (Hoffer, Prescot, & Topi, 2009). 13. Database System queries, forms, and reports Mayo Clinic Medical Center’s database is aimed to offer better business support. In this scenario, we will cover all business working and handling areas approximately. Now I will outline some of main queries, forms and reports that will be used by the database system for the Mayo Clinic Medical Center business: 13.1. Forms Few types of forms that we will require regarding the Mayo Clinic Medical Center business handling and operation are: Employees Data Entry form Clients Data Entry form Business dealing Data Entry form Business process Data Entry form Business projects Data Entry form Business resources Data Entry form Business Davison Data Entry form Daily transactions Data Entry form 13.2. Reports Few types of reports that we will require regarding the Mayo Clinic Medical Center business handling and operation are: Business resources summary Report HR analysis Report Business revenue periodic Report Business liabilities Report Business clients dealing Report 14. Conclusion In this analysis report, I have outlined innovative database technology implementation at Mayo Clinic Medical Center business. In this report, I have outlined some of the main aspects of the database implementation, operation and deployment. I hope this research report will offer deep insight into the new database development. 15. References Baker, W. H., & Wallace, L. (2007). Is Information Security Under Control?: Investigating Quality in Information Security Management. IEEE Security and Privacy , 5 (1), 36-44. Chou, D. C., Bindu, H., & Chou, A. Y. (2005). BI and ERP integration. Information Management & Computer Security Volume 13, Issue 5 , 340-349. Dawson, S., Vimercati, S. D., Lincoln, P., & Samarati, P. (2002). Maximizing Sharing of Protected Information. Journal of Computer and System Sciences Volume 64, Issue 3 , 496-541. Ghosh, A. K., & Swaminatha, T. M. (2001). Software Security and Privacy Risks in Mobile e-commerce. Communications of the ACM , Volume 44 Issue 2 , 51-57. Hoffer, J. A., Prescot, M. B., & Topi, H. (2009). Modern Database Management” Ninth Edition. Pearson. Inmon, W. H. (2002). Building the Data Warehouse (3rd ed.). New York: Wiley. Laudon, K. C., & Laudon, J. P. (1999). Management Information Systems, Sixth Edition. New Jersey: Prentice Hall . Turban, E., Leidner, D., McLean, E., & Wetherbe, J. (2005). Information Technology for Management: Transforming Organizations in the Digital Economy . New York: Wiley. Read More
Cite this document
  • APA
  • MLA
  • CHICAGO
(Database System Specifications in Mayo Clinic Medical Center Case Study, n.d.)
Database System Specifications in Mayo Clinic Medical Center Case Study. Retrieved from https://studentshare.org/information-technology/1568662-database-design-project
(Database System Specifications in Mayo Clinic Medical Center Case Study)
Database System Specifications in Mayo Clinic Medical Center Case Study. https://studentshare.org/information-technology/1568662-database-design-project.
“Database System Specifications in Mayo Clinic Medical Center Case Study”. https://studentshare.org/information-technology/1568662-database-design-project.
  • Cited: 0 times

CHECK THESE SAMPLES OF Database System Specifications in Mayo Clinic Medical Center

Supply Chain Management (SCM) Practices

With many years in operations management during his 34-year tenure at General Motors, Brown understood that the employees must have a firm grip on three crucial aspects before initiating the conversion to a lean enterprise:- everyone must understand why the company is dedicated to the lean philosophy and what's in it for them;- the employees must understand the system; - they must understand that there are a number of techniques in the toolbox to implement the system....
15 Pages (3750 words) Essay

Human Resource Management and the Importance of Leadership

First, the importance of getting the right people in position, strategic approach in analyzing the labour market, potential of temporary or contract employees within an industry, the best recruitment approaches, selection… od like reviewing and completing job, person specification, interviewing, testing and assessing will be thoroughly discussed followed by tackling issues related to implementing flexible hiring approaches and stress management to improve the work experience and motivation of the After exploring the salary structure and job performance evaluation, the best ways to increase employees' salary in accordance to the company's profit earnings will be explained....
20 Pages (5000 words) Essay

Automated data reconciliation of the clinical and safety databases

Data cleaning takes place according to the specifications of data validation (Dwivedi & IGI Global, 2009).... A clinical database defined as s closed system while a safety database as an open system.... A safety database on the other hand, is an open system due to its continuous reception of new SAEs or updates of SAEs that already exist concerning any clinical trials even when they are locked (Van et al 2012).... Serious Adverse Event, SAE, and Adverse Event, AE, reconciliation compares specific data between two databases; a clinical database and a safety database....
30 Pages (7500 words) Thesis

The Longstreet Clinics - History, Workforce, Systems Integration, and Operations Mechanisms

The first president in TLC, John Browning, puts it “the purpose was to deliver more efficient and higher quality medical care in a changing environment.... TLC set on its operations in 1994, with the merging of a few physicians, who negotiated and reached into an agreement of coming up with a multispecialty clinic that would simply focus on the provision of quality health care to the community.... TLC did adopt such a system, incorporating major specialists in their fraternity....
11 Pages (2750 words) Research Paper

How Clinical Governance and Research Governance Can Help a Clinical Scientist

nbsp; It also involves working towards improving the quality of medical information, reducing the variations in practice, involving the patients and the public and improving teamwork in health care facilities.... A series of failures in the health care system to provide solution led to health care reforms in the UK....
12 Pages (3000 words) Case Study

Mayo Clinic in Minnesota SWOT Analysis

The research paper intends to discuss the demographic information of Minnesota, on which mayo clinic is situated and will also reveal a SWOT analysis.... The research focuses on identifying the stakeholders and determining the strategies for gaining the commitment of the clinic … The author states the major weakness of mayo clinic is that the clinic operates in a non-profitable manner, which can be regarded as one of the prime factors accountable for its financial weakness....
8 Pages (2000 words) Research Paper

Health Information Exchange

Existing medical and Medicare programs, initiatives as well as new programs that the Affordable Care Act authorizes focus on new payment models.... This is often tremendous to the improvement of health care quality, reduces the costs of paving way for increased interoperability and sharing of information between patients, payers, providers and other stakeholders as well as reducing medical errors.... The paper “Health Information Exchange” evaluates transforming the delivery of healthcare into a system that is value-based and patient-centered....
10 Pages (2500 words) Research Paper

UMUC Family Clinic

The operations and data should be stored in an internal data storage center with a minimum of five terabytes.... To achieve this objective integration of most recent technologies is the key to ensuring that the goal is achieved and promoting the competitiveness of the center in the healthcare industry.... This case study "UMUC Family clinic" focuses on coming up with a plan on how and which electronic health records (EHR) system will be implemented via an account of the UMUC Family clinic....
7 Pages (1750 words) Case Study
sponsored ads
We use cookies to create the best experience for you. Keep on browsing if you are OK with that, or find out how to manage cookies.
Contact Us