Data WareHouse

Query and reporting tools are divided in to two parts.

• Reporting tools
• Managed query tools

Reporting tools further dividing in to two parts.

• Production reporting tools will let companies generate regular operational reports or support high level batch job, such as calculating and printing paychecks.
• Report writer, on the other hand, are expensive desktop tools designed for end users.

Managed query tools protect end users from complexities of SQL and database structure by inserting a Meta layer between user and the database.

Meta layer is software that provides subject oriented view of database and support point-and-click creation of SQL.

These tools are designed for easy-to-use point–and-click and visual navigation operations that either accept SQL or generate SQL statements to query relational data stored warehouse.

Some of these tools are used to format the received data in to easy-to-read report.

Labels: Data WareHousing

# posted by Kunal @ 11:02 PM

Share It: