There are also three types of data retrieval to consider. Each type has is own result reporting system, Push and Pull methods makes use of a small database which contains stored precalculated information extracted from a much larger raw data database. With the Ad Hoc method the user himself makes inquiries which are difficult to preconceive. He or she needs to have access to the main raw data database itself. This method is more compute intensive, and requires the attention of the database administrator to guarantee secure access .
Information is pre-calculated via frequent or nightly updates using templates.
This generates stored aggregates, such as daily sales of items in multidimensional cubes. The aggregates are used to create reports pulled up by users to answer frequently asked standard questions. The generated reports may be used to push information to user to answer Frequently Asked Questions. Relational databases store related data in the rows of a database. Object oriented databases are subdivided as smaller category files , for examples for employees, products, inventory, sales etc.