Free Essay

Database Management Improvement Strategies

In: Computers and Technology

Submitted By Tumisei
Words 743
Pages 3
Tasks improve the quality of datasets
According to (Shankaranarayan & Even, 2009) specific tasks that could be performed to improve the quality of datasets using SDLC are:
Auditing. Quality defects occur during data processing (e.g., due to miscalculation, or mismatches during integration across multiple sources), or after data is stored (e.g., due to changes in the real-world entity that the data describes). Addressing these defects requires auditing records, monitoring processes, and detecting the existence of defects.
Correction. It is often questionable whether the detected defects are worth correcting. Correction might be time consuming and costly (e.g., when a customer has to be contacted, or when missing content has to be purchased). One might hence choose to avoid correction if the added value cannot justify the cost.
Prevention. Certain methods can prevent data defects or reduce their occurrences during data acquisition, for example, improving data acquisition user interfaces, disallowing missing values, validating values against a value domain, enforcing integrity constraints, or choosing a different (possibly, more expensive) data source with inherently cleaner data

Data Refinement: Datasets are refined at regular intervals and database is checked for the orphan accounts if any in the system. Orphan accounts may result into dangerous issues so it should be handled carefully.
Data Governance implementation: Data Governance Maturity model can be implemented. This will help in achieving the optimization for the datasets.

Actions to optimize record selections and to improve database
According to (Shankaranarayan & Even, 2009), actions that should be performed in order to optimize record selections and to improve database performance from a quantitative data quality are:
Error Detection and correction: Errors may be detected by comparing data to a correct baseline. Errors may also be detected by checking values and by examining time-stamps associated with data. This error detection can be done manually or automated.
Process Control and Improvement: Total Data Quality Management (TDQM) methodology suggests a continuous cycle of data quality improvement which includes defining quality requirements, measuring along these definitions, analyze results, and improve data processes accordingly.
Process Design: Data processes can be built from scratch or, existing processes redesigned, to better manage quality and reduce errors

Maintenance plans and activities to improve data quality
Maintenance:
According to (Porrill, Noria, 2013) the maintenance plans to improve data quality are
• Analyzing the maintenance requirements at regular intervals
• Short-term scheduling of planned maintenance work
• Long-range maintenance planning

• Sorting and grouping of checklists
• Feedback and reporting

Activities
According to (Porrill, Noria, 2013) the activities that to implement to improve data quality are
• Verify the sources of data and assign the responsibilities. Conduct some form of analysis to identify the appropriate maintenance tasks to implement and create a checklist. Streamline the groups of task in an iterative manner.
• Define the metrics for measuring data quality.
• . Feedback information is captured and the information can be summarized on a report and an appropriate course of action is taken in response to each feedback, failure or observation from the data reviews.

Method efficient for planning proactive concurrency control methods
Keep the Integrity of Your Database Secure by Querying Your Transaction Log File: Record all operations to the database transaction log file especially if the system runs on Full Recovery Model. This will allow the system take advantage of a few simple queries to double-check who is running which command in the database. Online Transaction Processing database (OLTP) can be used for the given scenario using two-phase locking and write-ahead logging. (Shebbeare, 2010)

Method to ensure transactions does not produce record-level locking

Authorization and authentication mechanism should be used user’s role level to minimize security risks with in a multiuser environment. The verify method can be used to plan out system effectively and ensure that the number of transactions do not produce record-level locking while the database is in operation. Transaction Log files should be used to verify who accessed the database and at what time.

.

References

Phil Nousak, R. P. (n.d.). A Scorecard approach to improving Data Quality. Retrieved from http://www2.sas.com: http://www2.sas.com/proceedings/sugi27/p158-27.pdf
Porrill, D. (2013). Retrieved from Noria: http://www.reliableplant.com/Read/338/effective-maintenance-plan
Ramsin, R., & Paige, R. (2008). Process-centered review of object oriented software development methodologies.
Shankaranarayan, G., & Even, A. (2009). Dual Assesment of Data Quality in customer databaase.
Shebbeare, H. (2010). Retrieved from Microsoft: https://technet.microsoft.com/en-us/security/gg483744.aspx

Similar Documents

Premium Essay

Space Management

...SPACE MANAGEMENT A GOOD PRACTICE GUIDE A report on ways in which space management and space utilisation can be improved, based upon the work with the University of Wales Swansea January 2002 CONTENTS SUMMARY..................................................................................................................................................................3 INTRODUCTION......................................................................................................................................................4 PURPOSE OF THE GUIDE............................................................................................................................................ 4 THE PROBLEM.........................................................................................................................................................4 INTRODUCTION.......................................................................................................................................................... 4 THE PROBLEM A REAS.............................................................................................................................................. 5 THE SOLUTION........................................................................................................................................................7 SPACE M ANAGEMENT CONTEXT ........................................................................................................

Words: 8807 - Pages: 36

Free Essay

History of Lowes

...you to one of these two retail giants. The home improvement industry has evolved from small regional and locally owned hardware stores to these superstores. The top two in the industry are Home Depot and Lowe’s. Each has their eye on moving into international markets, each has superstores in all 50 states and each has evolved along different paths to reach their current positions. According to Fortune 500 Home Depot, Inc. is ranked at #25 and the second largest retailer in the US after Wal-Mart. Home Depot Inc. has its corporate headquarters in Atlanta Georgia. What began in 1979 as two 60,000-foot stores that resembled warehouses has grown to about 2,200 stores across North America, Puerto Rico, and China. Home Depot Inc. is publicly traded on the New York Stock Exchange as NYSE:HD. At the end of 2008 Home Depot Inc. employed 331,000 people. Home Depot sales recorded and posted in 2009 are $71,288.0 mil. Home Depot Inc. is the number one home improvement retailer with Lowe’s coming in second place with sales posted in 2009 at $48, 230.0 mil.. Founded in 1946 Lowe’s went from a small hardware store to the ninth largest retailer in the US. Lowe’s went public in 1961 and began trading on the New York Stock Exchange as NYSE:LOW in 1979. According to Fortune 500 Lowe’s Companies, Inc. is ranked at #47. Lowe’s Companies, Inc. are headquartered in Mooresville North Carolina. Lowe’s competes with Home Depot, Inc. (home improvement) and Sears (appliances) they are second to......

Words: 8092 - Pages: 33

Free Essay

Management Information Systems

...The Trusted Information Payoff: Productivity, Performance, and Profits Building an information framework to ensure effective data management produces information that is true, has integrity, and can be trusted. This leads to a continuous improvement culture that can increase employee productivity, improve operational performance, and grow profitability. Karim N. Sidi and Dale A. Hutchinson L arge organizations, especially those that have grown through consolidation, mergers, and acquisitions, are often fraught with incompatible systems and data sources that are costly and difficult to manage. The systems usually do not avail efficient extraction, aggregation, and sharing of data within or across the boundaries of the business process. To address this problem, organizations can turn to an information management framework that facilitates managing raw data to create useful information that can be shared across the organization. SEPTEMBER/OCTOBER 2013 INFORMATIONMANAGEMENT 35 sist of a mix of home-grown, functionspecific applications and third-party systems built by disconnected teams without a shared reference for data definition. The solution – forethought and planning to create well-defined data standards – may appear obvious from an architectural perspective but may not be so easy to accomplish. The steps described below will help. Establish Processes, Rules, Policies Identifying the “truth” first and foremost requires that business processes, rules, and......

Words: 2061 - Pages: 9

Premium Essay

Communication

... Deepika Ettem Wilmington University Table of Contents Introduction..4 Background……………………………………………………………………………………4 Four key systems at Minitrex………………………………………………………………… 5 Recommendations……………………………………………………………………………..7 Conclusion……………………………………………………………………………………..8 References……………………………………………………………………………………..9 Table of Contents Fig 3.1 Information Flows…………………………………….....……...…………….5 CRM AT MINITREX Introduction Customer Relationship Management (CRM) is an IT organization which main motto to gather more information about the customer requirements and to increase Business by rectifying defaults of the organization by satisfying customers. The business improvement it’s all depending on the sales, marketing and management of finances. When customer believes either the organization or sales person it only works out with maintain relationships with customers by adding new customers to the company. To increase the customers first should gather the information of drawbacks and in which services the customers are uncomfortable. It helps in marketing and sales department to sell the company’s products with good communication. Background Georges Degas is the director of sales at Minitrex. It is the company which is based on two divisions finance and insurance. Mariella Hopkins look after financing division and funded...

Words: 1210 - Pages: 5

Premium Essay

Itil Foundation Guide

............................................................................................................ 5 General Exam Tips......................................................................................................................................... 6 What’s On the Exam ..................................................................................................................................... 7 ITIL Core Concepts ...................................................................................................................................... 12 Services ................................................................................................................................................... 12 Service Management .............................................................................................................................. 12 ITIL as a Good Practice Framework ......................................................................................................... 12 The Service Lifecycle ............................................................................................................................... 12 Processes................................................................................................................................................. 13 ITIL Processes by Lifecycle Phase...

Words: 9056 - Pages: 37

Premium Essay

Individual Marketing Paper

...Individual Marketing Research Paper MKT-421 Individual Marketing Research Paper Kudler Fine Foods While developing the Kudler Fine Foods marketing campaign strategy it is critical to identify areas which will need additional marketing research. By identifying areas for needed additional market research, Kudler Fine Foods can better target its marketing strategy and tactics. By analyzing competitive intelligence, Kudler Fine Foods can better assess opportunities within its current marketing strategy. Background Kudler Fine Foods was founded in 1998 when its first store was built by Kathy Kudler. The company maintains its main base in San Diego, California and services the neighborhoods of La Jolla, Del Mar, and Encinitas. Each store has more than 16,000ft of modernized groceries and fresh organic specialty foods. Kudler Fine Foods prides itself on offering high quality foods, both domestic and imported. The company maintains specific strategic practices to introduce planning unrealistic goals and objectives. Although the company services a niche market in a minimal geographic area, the grocery industry is inherently competitive. The success of the company is attributed to its high standards in human resources and inventory control. By identifying additional areas for marketing research and analyzing competitive intelligence, Kudler Fine Foods will be able to expand its operations and establish more......

Words: 1318 - Pages: 6

Premium Essay

Mcki

...[pic] Corporate Information and Knowledge Management Strategy 2008 Contents Executive Summary 3 Introduction 5 Information and Knowledge Management Defined 6 The Case for Information and Knowledge Management 7 Information and Knowledge Management as a Cultural Issue 9 IKM Strategy 2003-2006 - Progress to Date 9 IKM Strategy Vision and Objectives 10 Strategy Action Plan 11 To recognise information and knowledge as corporate resources 11 To ensure information and knowledge are accurate and reliable 12 To improve access to information and knowledge 13 To facilitate the sharing and application of knowledge within the Council and across Services 13 To encourage and support the creation and nurture of knowledge 14 Implementation Plan 15 Approach 15 Roles and Responsibilities 15 Deliverables and Outcomes 16 Skills 17 Next Steps 17 References 17 Executive Summary Introduction ▪ Information and knowledge are valuable resources that must be managed with as much care and attention as the traditional resources of people, money, and buildings. Indeed, it is an asset that should be used effectively to the benefit of the Council and its community. ▪ The proposed strategy will help to ensure all information and knowledge created and used within the council is accessible to all and will ensure that......

Words: 5953 - Pages: 24

Premium Essay

Mis Project

...MANAGEMENT INFORMATION SYSTEM IMPLEMENTATION Abstract Table of Contents Page 1. Company Background 4 - 5 2. Business Problem Statement 5 - 6 A. Identification of Issues B. Desired State of Problem C. Obstacles 3. High-Level Solution 6 - 8 A. Introduction a. Solution Outline b. Summation 4. Implementation Benefits 8 - A. Management Information System (MIS) Presentation B. MIS Projections a. Database Management System (DBMS) b. Cloud Computing c. E-commerce and The Internet 5. Benefits/Technical Approach X XXX X XXX X 6. Business Process Changes X XXX X XXX X 7. Solutions X XXX X XXX X 8. Recommendations X XXX X XXX X 9. Implementation Plan X XXX X XXX X 10. Project Summary X XXX X XXX X Company Background The Knitter’s Lounge & Café (KL&C) is a modern approach to arts and crafts. It began as an innovative conceptual idea for a café style retail arts and crafts store in 2010 after the owner and Chief Executive Officer (CEO) visited a number of yarn shops and realized a need for a shop that bade more than the common knitting and crocheting supplies found in traditional arts and crafts establishments. The first store is located in Sandy Springs, a suburb of Atlanta, GA. Sandy Springs is an affluent community nestled along Cobb County with the Chattahoochee River to the......

Words: 1770 - Pages: 8

Premium Essay

Disadvantages Of Project Management

...1.1Project Schedule In project management, a calendar is a posting of a venture's breakthroughs, exercises, and deliverable, generally with planned begin and completion dates. Those things are regularly evaluated regarding asset distribution, plan and span, joined by conditions and booked occasions. A timetable is ordinarily utilized within venture arranging and task portfolio management parts of project management. Elements on a schedule may be closely related to the work breakdown structure (WBS), a calendar is a posting of a venture's developments, exercises, and deliverable, generally with proposed begin and completion dates. Those things are frequently assessed regarding asset portion, plan and term, connected by conditions and planned...

Words: 2083 - Pages: 9

Premium Essay

Project Proposals for Computerized Inventory Management System

...ERP Implementation Life Cycle An ERP implementation life cycle refers to the distinct stages in which an organization carries out an ERP implementation. Typically, we advise mid-market manufactures to move through the following seven stages: * Pre-Implementation * Project Planning * Product Education * Design Configuration * Development and Test * Go-Live * Post-Implementation The concept of an ERP implementation life cycle is on the minds of many mid-market manufacturers as this calendar year comes to an end.  Many process and discrete manufacturers are heading into active ERP projects in the New Year, and considering what it means to enter into the various phases of an ERP implementation. The Start of the ERP Implementation Life Cycle is Pre-Implementation While it’s tempting to gloss over the preparatory activities that should take place in the “pre-implementation” phase, our team advises manufacturers to take special care in this first phase of ERP implementation life cycle. Tasks that are part of pre-implementation form a solid foundation for the ERP project.   We advise that manufacturing companies carefully manage this phase, because success at this early stage increases the likelihood of success at “go-live.” Typical best practices take place in the following areas: * Vendor Due Diligence - These are tasks found at the end of the technology evaluation cycle, involving vendor due diligence, site visits, ERP vendor customer......

Words: 5161 - Pages: 21

Premium Essay

Risk Managment Plan for Smartphone

...Risk Management Plan For Smartphone | | | 2/24/2013 | | * Table of Contents 1 Introduction 4 1.1 Purpose 5 1.2 Objectives 5 1.3 Risk Management Scope 5 1.4 Background 5 1.5 Supporting Products 6 1.6 Referenced Products 6 2 Roles and Responsibilities 6 2.1 Roles and Responsibilities 6 2.2 Support Infrastructure Tools 8 2.3 Training 8 3 Risk Management Process 9 3.1 Identity 9 3.2 Analyze 10 3.2.1 Probability of Occurrence 10 3.2.2 Probability of Impact 10 3.2.3 Risk Factor 11 3.3 Plan Response 12 3.4 Monitor/Control 13 3.4.1 Communication 14 3.4.2 Reporting 15 3.4.3 Performance Measurement 16 3.4.4 Continual Process Improvement 16 3.4.5 Audit 16 Document Revision History | Date | Version | Updates Provided By: | Summary of Updates | 02/03/2013 | 1.0 | Komal Shah | New document | | | | | | | | | | | | | Product/Project Manager’s Signature Your signature indicates that risk management plan has been plan has been prepared with input from content experts and is in compliance with applicable project standards Written By: Dept. #: Date: Komal Shah – Project Manager Reviewer’s Signature Your signature indicates that as content expert, you have reviewed this document and it accurately and completely reflects the requirements necessary to......

Words: 3606 - Pages: 15

Premium Essay

Bsa502 Team Final Paper

...an information technology consulting team working for Riordan Manufacturing, Team C will review, assess and make recommendations for improvements to the company’s business infrastructure. These recommendations will include software in the following business areas: human resources, operations, and logistics, legal, and finally, sales, and Marketing. Riordan Manufacturing Inc. like most companies can benefit from process improvements and the implementation of software solutions to improve its human resources, operations and logistics, and legal processes. Human Resources Focus According to Nickels, McHugh, and McHugh (2010), attracting and keeping the best employees is one of the fundamental goals of human resources management. People are the most valuable resource in any organization because their knowledge and creativity translate to products and services that business models depend on. Riordan Manufacturing Inc. faces some challenges with human resources management and is in need of some solutions. Existing Human Resource Management Systems (HRMS) in Riordan manufacturing Inc. * Employee Database * Payroll System * Training and Development System * Recruitment and Selection system * Hiring System * Compensation System * Compliance System * Performance management system Recommended Human Resources Management Systems (HRMS) Oracle HRMS Oracle HRMS is part of Oracle’s E-business suite with several sub-modules that Riordan can benefit......

Words: 3263 - Pages: 14

Premium Essay

Risk

... but as a Team Leader, you do not have the authority to implement any of these ideas. You have recently undertaken a Risk Assessment and Workforce Planning Exercise to identify ways of filling the skills gap and improving Customer Service at Fynntown City Council. There are three major parts to the Customer Service Improvement Initiative: 1. Restructuring the Customer Service Centre to deliver an 80% first Point of Contact Resolution Rate (it is estimated that this will reduce complaint calls by 75%) 2. Introducing a Workforce Management Plan that identifies and rewards talent 3. Installation of a new Database across all of Council that will house all constituent and business details, customer call histories, a knowledge base with information and FAQs, and performance reports (this forms a sub-project of the larger project with the IT Manager, Jim Pertwhistle, as the Project Manager). A budget of $175, 000 plus $25,000 contingency requiring Project Sponsor Authority and Mayoral Authority has been allocated. The project must be completed in a timeframe of 365 days. You are required to manage the implementation of this Customer Service Improvement Initiative. Using the Project Brief and any communications with the Project Sponsor, define the project using the FCC Project Charter Template provided. The Project Charter...

Words: 7560 - Pages: 31

Premium Essay

Customer Experience from Good to Great

...“A PROJECT REPORT ON ROLE OF HR IN TRANSFORMING CUSTOMER EXPERIENCE FROM GOOD TO GREAT” Submitted by PRATEIK DAS 10IMBA049 DEPARTMENT OF BUSINESS ADMINISTRATION UTKAL UNIVERSITY ORISSA. Declaration I, PRATEIK DAS hereby declare that the project titled “Role of HR in transforming customer experience from Good to Great” is an original record of work under taken by me for the summer internship project .I have completed the project under the supervision of, Dr Jyotirmayee Choudhury,Faculty Human Resource Department of Business Administration and Sarvana Sampath S Manager Human Resources at Manipal Health Enterprises Bangalore. Signature: Place Date Student Name Registration no. Department of Business Administration ACKNOWLEDGEMENTS No project can be completed without acknowledging the help and the support of the people who have helped in its successful completion. Their help, support, guidance and patience have been the key drivers for the project. ,I would like to express my gratitude to Mr. Ganesh Selvaraj, GM and Head Human Resource for giving me the opportunity to work as an intern in Manipal Health Enterprises. His words of encouragement have been an catalyst for working better. I would sincerely......

Words: 6313 - Pages: 26

Premium Essay

Work Example

...Introduction In the expansion of Acme Home Improvements to Mexico City, an information system management plan needs to be established in order to oversee employment and management, as well as meet the needs of Acme’s stakeholders including employees, customers, suppliers, shareholders and investors. The plan has a goal of improving aspects such as sales and marketing, budgeting, planning, hiring and training all while using technology to assist in the assignment of roles, and to discover correlations between profits, performance, and competitors. System Objectives & Information Requirements of Stakeholders The goals and scope of the Information Systems plan is to identify how the plan will help each stakeholder group obtain the necessary information, data, and equipment required in order to complete the tasks associated with each group. A stakeholder is someone that has put a level of trust and interest into a business, project, or idea. Regarding the Acme Mexico City project (AMC), the stakeholders consist of those employed by AMC, buyers of the product, suppliers, and their shareholders and investors. All of the needs of the stakeholders will be met by the AMC information system, which will help to organize departments such as human resources, marketing, operations management and sales. Human Resources is defined as a department which “maintains policies, plans and procedures for the effective management of employees” (Baltzan, 2011). This includes the hiring......

Words: 1558 - Pages: 7