by Software Expert
9/18/2008 3:09:00 AM
You may never directly see the underlying database structure that holds your company's valuable data but what you can't see may be unnecessarily costing you time and money. Database "normalization" is a technical term which describes how the tables, fields, and data relationships are structured in a database. Databases can be under-normalized or over-normalized and finding the right balance of normalization is essential when designing a custom database solution.
Why should you care about normalization? Under-normalized databases typically represent business data relationships poorly and commonly have individual pieces of data duplicated in multiple locations. This means that poorly designed databases cost more to maintain! If you ever found that you had to maintain one piece of data in more than one place in your application then you may have an under-normalized database.
Over-normalized databases typically represent data "too well." How is that possible? The data in an over-normalized database is typically spread out over many tables in a very abstract way which can result in database activity being very inefficient. If you notice your database seems slow, even when performing simple tasks such as reporting, you may be over-normalized!
Checking a database's normalization is a key component of Entrance Software's Software Audit and provides great insight into the design and quality of a software application.
by Software Expert
9/8/2008 7:49:00 AM
Many clients do not understand why they should pay for an up-front "scoping" exercise that does not directly result in software being delivered. "Scoping" allows both the software buyer and the software developer to get on the same page by establishing well-defined expectations for the outcome of the project. Proper scoping is crucial to a successful, on-time and on-budget software project.
To begin a scoping exercise, a Project Manager will identify the key people involved in defining and ultimately using the software product. The Software Project Manager meets with these stakeholders, documents the existing business processes, discusses ways in which the processes may be improved as a result of the proposed software project, and identifies any other functional requirements of the software. After the meetings are completed, the Project Manager creates a scoping document which describes the solution to be build based on the information gathered.
With a scoping document in hand, a software consultant is able to easily develop an effort estimate to implement the project. Scoping projects typically cost no more than 10% to 15% of the actual cost to develop and implement the software solution. As such, a scoping project can generally give a software buyer an "order of magnitude" estimate of the resulting project. Most importantly, however, a detailed scope provides clear direction to the software architects and developers who will be implementing the solution, avoiding unnecessary "back-and-forth" with the software buyer's staff and ensuring that the resulting software solution precisely meets the buyer's needs. The result: better results and reduced project risk.
by Software Expert
9/2/2008 8:00:00 AM
Outgoing messages, automated attendants, out-of-office emails, online customer service - each of these tools is technology automation at its best ... or is it? In my business, it's easy to let technology get out of hand and lose sight of the primary goal: serving the customer! I make it a point to exercise technology, but I don't let it run away with my business.
by Software Expert
8/28/2008 8:13:00 AM
Many business owners start companies because they like to ask difficult questions, such as, "Why is it done that way?" and are not satisfied with answers like, "Because that is the way it has always been done." However, they are often guilty of drinking their own Kool-Aid. They believe that they are smart, capable and "can do that in an Excel spreadsheet." The sooner they welcome change, which includes technological advancements, the easier their business process will be.
by Software Expert
8/25/2008 8:06:00 AM
In the hit movie "Jerry Maguire," Tom Cruise's character declares, "Show me the money!" Well, if Jerry wanted to be a successful entrepreneur, he should have been shouting, "Show me the metrics!" One of my last programming jobs - before I created my own company - was for a company who had the catch phrase, "You can't manage what you can't measure." Without the ability to quantify your business through metrics, sometimes called KPIs (Key Performance Indicators), the business is totally reliant on the instinct of the owner.