Technology

Oracle, the worlds most complete, open and integrated business software that consolidates the business application in a fast, reliable and scalable database grids. BlazeDream comprises a challenging pool of programmers, who are competent enough to toil on the relational database management system. Our programmer’s technology ability pans a very broad spectrum in oracle database. BlazeDream programmers provides flexibility and choice to our clients across IT infrastructure.
Our expertise handles projects using techniques:
Oracle PL/SQL for ETL Process
ETL, the term refers to Extract, Transform and Load. It is a process to send the business data of the client as EDI (Flat files) from various sources needed to load the data into Oracle DB in a secured manner. This is greatly achieved using PL/SQL methods like Bulk collect to make the ETL process more effectively.
Oracle Schedulers and mail
Oracle Scheduler is used to schedule jobs running inside the database such as PL/SQL procedures or blocks and outside the database such as shell scripts. Also, we create job chains which are used to check the events of the recurring job chains. Schedulers are mainly used to send alert mails to the customers and to schedule the ETL process.
EDI to Customers
BlazeDream create EDI (Flat files any desired format) files to customers for their internal processing. The files are created from the oracle tables to any desired formats and placed in a server for their use. We also FTP the files (from PL/SQL) to any desired location irrespective of the operating system (windows & UNIX)
Oracle as Datawarehouse
As we mainly support logistic solution, their will be huge transactions every day, so it will be very difficult to run management reports from the normalized database. In order to get the reports quicker, we implement the following things
- Partitioning the tables
- Materialized Views
- Denormalized the data (Fact and dimension table)
Performance Tuning
To make the application effective, tuning process should be done periodically. We do list of process to make the application robust.
- SQL Tuning (adding Hints, rewrite joins)
- Use of Bind variables
- Creating index whenever needed
- Explain plan (to find the cost of the query)
- Proper PL/SQL code (use of bulk collect)




