Business Objects
One of the problems with modern databases is that they can be very complex, especially ERP systems. These databases can consist of scores of tables. The systems are very broad in functionality and are designed to work for any type of business. The systems support the day-to-day work of a business. However, they are not designed to provide business information. I use an ERP system at the company for which I work and it is common to join 10–12 tables and write SQL statements of 50–60 lines. Needless to say, it is extremely difficult to write SELECT statements for these types of databases. Small changes in the desired information can require hours for the business analyst to write and test the revised statements. It is a far more ...
Get Oracle SQL and PL/SQL Handbook: A Guide for Data Administrators, Developers, and Business Analysts now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
