preview

Database Analysis : Olap And Database Administration

Best Essays
Open Document
CHAPTER 14: OLAP AND DATABASE ADMINISTRATION
14.1 LEARNING OBJECTIVE AND OUTCOMES The basics objective to create a well-designed database using basic database commands. lt also provide how to manipulate the stored data and return meaningful results to help analyze the data stored. Upon completion of this chapter, they will be able to:
• Create, read, update, and delete data using basic SQL commands.
• Perform relational joins and transactions on SQL tables.
• Aggregate data through functions and conditionals.
• Perform sub queries and manipulate views.
• Create stored procedures within SQL.
• Summarize data using PIVOT and UNPIVOT.
• Demonstrate knowledge of data indices and information schemas.
• Create a full-fledged blog database.…show more content…
It is consider as a specialists that an OLAP system which contains an information on server that allows quick access to data (atomic data and derived data) and facilities calculations. Because OLAP tools work with multidimensional data models, perform complex analytical queries, ad hoc and has a high processing speed, some scholars have suggested that they rather be called FASMI (Fast Analysis of Shared Multidimensional Information) . Thus, Nigel and Richard Creeth Pendle, from the idea that "18 or even 12 rules are too much "wanted to define the characteristics of OLAP applications in a simple way and thus propose FASMI test, five key words:
1) Key word "speed" - users have earlier access to data at any time (basically the smooth running of a company is assured of making correct decisions to be taken quickly based on data that is stored in a warehouse data, the speed of access becomes a necessity). If simple analysis response time is one second, and for more complex analysis, response time may be longer than 20 seconds;
2) key word "analysis" - OLAP system should provide the user to perform various tests with the help of mathematical methods or statistical. Virtually, should provide the opportunity definition of ad-hoc calculations making reports in any form without the use of professional programming languages.
3) key word "shared" - allowing data to be accessed by many concurrent users
Get Access
Related
Get Access