Specialized Database Presentation
Team B:
Chappell Grant,
John Hainline
Linda Hannigan
DBM/384 Special Purpose Databases
Brando Sumayao
Specialized Database Presentation
•
•
•
•
•
•
•
•
•
•
Executive Overview
Strategic Goal
Proposal
Comparison of different database and purposes
SQL concepts relative to spatial and temporal databases
Uses of databases in the business environment
Description of the information retrieval process in relations to the specialized databases
Differences between Online Transaction Processing (OLTP) and Online Analytical
Processing (OLAP)
Define knowledge management and how it’s used within our organization
Conclusion
Executive Overview
The IT Strategic Plan is a visionary approach which will assist with various measurable advances which will progress the company towards our key initiatives and strategic goals over a modest two-year time frame.
Strategic Goal
Return on Investment (ROI):
• Standardize processes to increase revenue by 5%.
• Reduce technology variance to eliminate 10% of IT spend.
• Improve business operations and standardization to reduce IT operating costs by 10%.
Proposal
The use and benefits of specialty databases within the organization can help streamline the business processes.
Accurate and relevant data is critical to the success the organizations sales and marketing efforts. To maximize return on investment, using and analyzing the organizations data will help reach the customers and prospects cost effectively and efficiently.
Comparison of different database and purposes
•
•
•
•
•
Data Warehouse
Spatial
Relational
Distributed
Specialty
SQL concepts relative to spatial and temporal databases • SQL defines several functions to get the current date and time.
• SQL allows comparison operations on all the types of data and it allows both arithmetic and comparison operations on the various numeric types.
• SQL also provides a data type called interval, and allows