Finalized Presentation/Action Plan
harleyteam34
PresentationfortheChiefInformationOfficerCIO.pptxJamie Vaughan
10 Dec 2017
Southern new Hampshire university
PERFORMANCE AND DATABASE EFICICIENY
QUERY DESIGN
The data retrieval will be improving speed with the performance tuning.
When looking a specific counties like Everstone county, there needs to be specific performance tuning, that will increase the direction the database will head towards, knowing the traffic numbers, this will make the client more efficient.
There will be random look-ups for the county of Everstone, that will increase the rate of access for the records that are in the database.
QUERY DESIGN
When looking at the response to check on a query for King county the provision will server the user the best results.
It is important to be able to know how to help when looking for performance queries by using the JOIN and WHERE clause when indexing.
If there are unused or unnecessary columns that are in the records, they need to be deleted, if not they will cause errors, there needs to be statements selected that will create loads for the database.
Outer join needs to be used less than inner join for the database.
QUERY DESIGN
When looking at the database, if there are errors coming up it is usally because there are inputting data information or there are redundancy issues.
To avoid redundancy on the database, normalization will be used to ensure integrity.
Redundancy will be avoided when using the proper use of foreign keys.
Everstone county will use a more centralized control of data, this will ensure no redundancy with data.
QUERY DESIGN
When creating records the locking technique needs to be used, this will help the DMBS from creating an update from another table or pull the wrong information into another process.
The database Everstone will have time stamping on all records, this will let everyone know who is doing what to the records and ensure that the data stays intact. This process will let the users to be able to cancel the process if need be.
QUERY DESIGN
Using multi-user environment will work best in the Everstone database.
The database will need to use the locking technique, the database will be maintained, another user can’t change the way the data is perceived but still allow multi-user access.
The database needs to setup as separate storage for the database for better functions for processing.
Splitting the database into different storage areas will better let Everstone ensure that multi-user can be employed effectively.
MULTIPLE USER ACCESS
The Everstone county database needs to work best in a multi-user environment.
Locking technique will ensure that a record being accessed by another process or user in the database is not retrieved by another process, this will help maintain database ,multi-user access.
Splitting the database will separate the data storage functions from the data processing functions.
Hence, splitting the database of Everstone county will go a long way in ensuring that a multi user environment is effectively supported.
References
Ong, S. K., Nee, A. Y. C., & Xu, Q. L. (2008). Design reuse in product development modeling, analysis and optimization. Hackensack, NJ: World Scientific.
Theobald, M. (2006). TopX: Efficient and versatile top-k query processing for text, structured, and semistructured data.
