Welcome to www.msunderestimated.com
|
Web Hosting - Databases, What Are They and Do You Need One?
'Database' is one of the most commonly used terms that one encounters in web site design. Yet, what they really are and whether they're essential is often not clear to novices.
A database is a collection of organized data, stored in files that have a specific structure. It's that organization and structure that allows for easy and rapid storage and retrieval.
The need for a database generally only arises when you have a certain amount of information and that information needs to have some structure. If you have a half-dozen names and addresses to store, a database is usually overkill. If you have a blob of data with no relationships between any of the items in that blob, maintaining a database is usually more trouble than it's worth.
Maintain a database? Yes, like other complex systems a database, to be effective, needs to be designed properly at the outset then kept 'tuned' for good performance. The alternative is to gradually allow the database to become more and more disorganized. That leads to difficulty in use, poor speed of retrieval and more frequent failures.
With MySQL, Access or MS SQL Server, the three most common choices of database product for web sites today, setting up a database is relatively simple. Even those with limited technical skill can get one up and running just by following some simple instructions. But some thought should be given to how you want the information organized, and to maintaining the system during its lifetime.
Suppose you have a set of names, addresses, email addresses, products purchased, date purchased and amount. If you have only a few dozen records it matters very little how these pieces are arranged and related. A database usually isn't even warranted in this scenario. Once you have several thousand or more records, it matters a lot. Speed, the ease of expanding the set of attributes (like adding, say, product category), and other issues come into play.
Even those with little technical expertise, but a willingness to exert logical thought and invest some time, can build a very robust database. Think about how you would organize a set of data (called 'tables'). Should Name, Address, and Product be in the same table? Or should the personal information be stored in one table and any product information (product, price, ...) in another?
Some experimentation may be needed to get it right, but the choices have an impact on how easy the tables are to maintain. It also affects the speed with which programs can fetch old data and store the new.
Having a database also introduces new maintenance issues for the server administrator, since backups usually need to be done differently. Recovering a failed database is usually more complicated than simply re-copying files from yesterday. Ask your hosting company what tools and skills they have for dealing with any database system you consider.
It's true that introducing a database creates more complexity and the need for additional thought and administrative effort. At a certain level, professional expertise will be needed. But clearly the advantages outweigh the costs in many cases. Companies large and small eventually use databases to store and organize data. At some point, you may be fortunate enough to be one of them.
Job Hunt Challenges for the Over 50 Crowd If you have just recently lost a job or maybe are not happy with the job you are currently holding, you are going to be on the hunt for a new job. Hunting for new job is never easy, whether it is your first or your tenth job. You know that it takes a good amount of preparation till you might hold another permanent job. But for the older crowd, especially the crowd over fifty, the challenge of finding a new job is even greater. Explore some of the facts why it is more challenging to find a job after 50. Starting out by the age factor, many companies want young and dynamic employees that are open to new and challenging tasks. Many employers believe that a person over 50 is set in his or her ways and therefore not able to tackle the same great tasks that might open up as a young, fresh out of college open minded person. A person over 50 is closer to retirement and might not want to take any risks as a young career fresh from school employee. Risks are sometimes what a company needs to get forward, new ideas, new thinking. Another reason is the salary competition. If you are over 50 and looking for another job, you most likely have a lot of experience in you sector. Experience usually is measured in money and the salary for an experienced person is generally higher than a starter salary. While experience is desired, some companies can just not afford to hire somebody for 10-20 thousand dollars more than they can get the fresh from college employee. If you lost your job, you might accept one of the lower salaries, but while you are in the application process, the human resource person reading your résumé does not have that information about you. Some of the bigger companies get scared by the fact that you are really close to retirement and if there are certain retirement plans and structure in place at a company, they might not want to hire you. You could retire within 10-15 years or less and then the company is stuck with paying you retirement payments. Hiring a younger person instead guarantees them no retirement payments or plans for retirement in general for the next 20-30 years. From the employer’s side, these are great savings for their pocket. Another reason often seen from employers as a reason not to hire a person over 50 is that the person they are hiring might be more prone to sickness and take more sick days than a young person. Why would they think that? Statistics have shown them that the tendency for time off due to sickness is greater for people crossing the age threshold of 50 years versus younger people. Be honest, being over 50 means for most people more aches and pains all over the body. You are more tired and get exhausted quicker. So if you do get a chance to go to an interview when looking for a new job, you need to make the best out of it. Besides all the factors mentioned above, a person that is over 50 and is looking for a job can be a great addition to any company and you need to make sure that you let your interviewer know that. An interview is a great challenge and can be mastered quite well if keeping these thoughts that employers have in mind. Emphasize the fact that you do bring experience and connections. Let them know that if they hire you, they get a person that at least is settled in life. You have had all your children, or did not want any, but at least you will not be missing because of pregnancy, birth of a child, and sickness of a young child or similar events. Let your Resume Speak Volumes for that Next Big Job Before you even get through the door of any job interview, there is already one document that has done the talking for you – your resume. A good resume can mean the difference between getting the call of the interview and waiting by phone, and a well written, thoughtful resume can make you stand out over and above other applications with similar skills and work experience. Let your resume give you the edge on that next big job by following a few simple tips. When you sit down to write your resume, you need to plan it out before you start typing. There are two main formats for a resume: the chronological format, in which you simply list your job history, starting with your most recent or current job and moving backwards, and the functional format, in which you highlight your skills and experience rather than specific jobs and specific employers. The chronological format is definitely the most common, and many employers prefer this kind of resume, but choose the format this is going to show off your skills in the best light. If your work history is a choppy and a chronological format resume would only draw attention to that, use the functional format. The key is to choose the format that will give you the best chance of getting noticed for the job and to stick with the format throughout your resume. No matter which resume format you choose to use, the top of your resume should always include your name, contact information and work objectives. Name and contact information is pretty straight forward, although experts do recommend that if you have a “gender neutral” name that you include a helpful “Mr.” or “Ms” to clear up any confusion. Your work objectives should be your career goals. For instance, if you want to manage a small team of sales people, then say that, so your potential employers know that you are moving in a certain direction with your career and not simply apply for jobs willy-nilly. After your work objective comes your work experience. List your jobs in reverse chronological order. Instead of simply creating a bullet pointed list your work related tasks, look for a way to frame all of your responsibilities so that they sound like you showed leadership and problem solving capabilities. For instance, if you were in charge of keeping the expensive accounts in order, say that you were in charge of troubleshooting monthly expense account records, saving the company hundreds of dollars every month. If you have a few blips in your work history, be clear about what you were doing in the downtime. If you were raising children, traveling, or in school, say that you were. If you weren’t really doing anything, put as positive a spin on things as you can without lying. Never leave gaps in your work history unaddressed on your resume. After your work history, it is time to list your education credentials. If you didn’t finish a degree, say how much college work you completed and highlight any coursework relevant to the job. If your college degree or post grad work is in progress, say when you expect to be finished. This is another place where gaps matter. If there is a gap in your education history, again say what you were doing in that time, referring back to your work history where appropriate. You can overcome these gaps as long as you don’t pretend that they don’t exist. Round out your resume by listing any awards and professional memberships you may hold. Don’t get into your hobbies unless they are specifically related to the position for which you are applying. Personal details like religion and race have no place on your resume and you are not required to disclose your age. Instead, let your experience do the talking. |