Building A Financial Website – Part 2 (Architectural Design)

It is very essential to have a mental picture of how the application will be structured and how the various components will interact with each other before proceeding to even write a single line of code. This point cannot be overemphasised especially in projects that involve other collaborators or programmers. If you are a lone … Continue reading Building A Financial Website – Part 2 (Architectural Design)

Advertisements

Building A Financial Website – Part 1 (Overview)

For those who live in this space where stock trading, foreign exchange (forex) trading, etc. is their daily bread, trading data/information comes in handy for them, but at the end of the day, developers like us have to build those platforms. The good thing about developers is that we get to work in a space … Continue reading Building A Financial Website – Part 1 (Overview)

Finding Duplicate Records In a Database Table

Ideally business rules, that can be re-enforced at the database layer, should be implemented at the database layer to ensure that the integrity of the data can be relied on and does not lead to an unexpected behaviour from the application. Rules such as validation rules, e.g., which fields/columns cannot be null, etc. common sense … Continue reading Finding Duplicate Records In a Database Table

Import An Oracle Dump File

These are the steps I normally follow when restoring Oracle dump files for the purposes of my work. I prefer to logically keep the restored entities logically and physically separate through the use of tablespace and associated datafile(s) respectively. Create and assign the user to the earlier defined tablespace. If I want the created user … Continue reading Import An Oracle Dump File