Written on 8 August 2014, 10:55am
Strategy vs tactics
Strategy: the overall plan, the final purpose (What?)
Tactics: the actual means used to meet an objective (How?)
The strategy is an idea, the tactics is an action taken to execute the strategy
Efficient vs effective
Effective is doing the right thing.
Efficient is doing it in the optimal way.
Efficient and effective: doing the right thing in the optimal way.
Functional vs non-functional requirements
Functional: what the system should do
Non-functional: how the system should be
Utility: fit for purpose.
Warranty: fit for use.
Business vs Functional analysis
The business analyst is responsible for the business requirements; it reports to the Business. Answering more to questions like “What?” needs to be done, based on the business “Why?” it needs to be done.
The functional/technical/systems analyst takes the “What?” from the business analyst, and they are translating it into the “How?”.
The Business Analyst gets the requirements and the Functional Analyst looks at how the technical solution can be best used to meet those requirements.
SOA vs SaaS
Service Oriented Architecture (SOA) is a software architecture design pattern based on distinct pieces of software providing application functionality as services to other applications. This is known as service-orientation. It is independent of any vendor, product or technology.
Software as a service (SaaS) is a software licensing and delivery model in which software is licensed on a subscription basis and is centrally hosted.
Oracle rownum + order by gotcha
SELECT first_name, last_name FROM employees WHERE rownum = 1 ORDER BY creation_date DESC
You probably want to do this instead:
SELECT * from ( SELECT first_name, last_name FROM employees ORDER BY creation_date DESC ) where rownum = 1
The first query takes the first row returned by Oracle and orders it by creation_date.
The second query gets the first row of the sub-query that contains the sorted records.
More on Stack Overflow