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.
Fair Use Copyright Law Don’t Overstep the Fair Use Copyright Law Many people are interested in the fair use copyright law. The fair use copyright law enables people to use portions of material that is copyrighted for the purposes of criticism or as commentary. The hard part for many people is understanding what is permissible under the fair use copyright law and what is not permissible. Anyone who writes or publishes should brush up on what is allowed and what is not allowed. Using another person’s words to make news reports, to use as a comment or criticism or to use for research, scholarship, or for educational uses that are nonprofit are generally considered fair use. In these instances, the fair use copyright law allows one person or author to make use of another person or author’s work without asking permission to do so. In situations that do not fall within these specifications you are probably violating someone’s copyright if you use their work – especially if you are using another person’s work for economic or commercial gain. When you are trying to see if you can use another’s words, you should keep a few things in mind. The answer to the following questions will help you gage whether you would be violating a copyright. First, are you transforming someone else’s work or are you copying it? Second, are you going to be making any financial gains from your work that would compete with the original copyright holder? Third, do you have the author’s permission to quote their work? Just because you list the author and give credit to him or her does not protect you from infringing upon someone’s copyright. Fourth, how much of the original author’s work are you using? If you are using a substantial amount of another’s work, you are probably in direct violation of their copyright. Many publishing companies have set rules on how much material they will allow to be quoted in other sources. Some of these ranges start at 100 words or less. However, there are truly no standards to go by, so be careful. You can not assume that keeping your copying fewer than 50 words will allow you to pass under the radar – especially if the original piece is hovering around 125 words itself! Lastly, what portion of another’s work are you using? If it is the meat of the book and the most important part of the book, you are probably in direct violation of the owner’s copyright. With a little common sense it is not hard to decide if you are violating someone’s copyright. People who are truly interested in staying within the guidelines of the fair use copyright law usually do a good job of doing so. Many people push the fair use copyright law right up to the line, while others will blatantly cross over it without giving a second thought to the repercussions. When these people are summoned to court to answer for their vagrant disregard for the property and copyright of another they are usually sorry. Sorry they got caught! It is very important that people who take advantage of the fair use copyright law are held accountable for their actions. Without accountability many more people would follow in their footsteps and use another’s works as their own. Ways to Quit your Job Yet Still Maintain Positive Ties Just as there are ways to get jobs, there are also ways to leave jobs--especially one where you have cultivated relationships. Moving on to a new position does not mean that you have to leave on bad terms. Get the job you want without leaving your current job on bad terms. Choosing to leave one job for another one is a decision that is often unavoidable. In order to progress in life, changing jobs may be necessary. Whether it is increased pay, more room for advancement or a better work environment, changing jobs is a natural part of life. While some employees leave jobs because they are unhappy, other employees leave because they simply need or want a new job. These employees may have great working relationships with their employees and co-workers. They may even have good personal relationships with these people. Extenuating circumstances like friendships can make it difficult to move from one job to another. However, this necessary move can be made without destroying ties that are important to you. Being professional and careful when leaving your job can make leaving much easier. First of all, do not tell anyone you are planning one leaving. No matter how close you are to your co-workers, keep your intentions quiet. Arrange interviews during times that do not conflict with your current job. You do not want to miss work for an interview. Remember your current employer is an excellent reference for you. Maintain your good reputation at your current job. Continue to do a good job and care about your particular position. Using the company phones, e-mail or fax machine to contact your new potential employer is not appropriate. Use your own devices to contact the interviewer. Until you have the new job, things should be business as usual on your current job. Also, never give your notice at your current job until you are sure that you have the other job. Having to retract a two-week notice because you prematurely gave it is a sure way to cause friction. Once your new job is secure and you have given your tow week notice, continue to be a good employee. Be on time for work and complete your projects. Remember, no matter what your new job is, you have obligations to your current job. Write out your notice. Compose a nice letter thanking your boss and co-workers and provide two or more weeks notice. By giving a written and dated letter no one will be able to dispute the length of your notice. Also, you will be providing a professional and considerate notice. Allow your co-workers and bosses to say goodbye to you. If they want to take you out for a drink on your last day, oblige them. Enjoy celebrating an end of an era. You may keep in contact afterwards but you probably won’t be working together again. Let them know that you realize this and that you leaving is not personal. Sometimes, no matter what you do, some people are not going to be okay with you leaving a job. There will always be someone who thinks that you getting another job is not a good idea for you. This is especially true for co-workers or bosses who you have a relationship with. Some of that is probably coming for the fact that they will miss you being around the office. Others can be envious of your boldness. It takes a lot to leave a comfy work environment for a challenging job. There is no way to please everyone. In these cases, just remain positive and ignore any backlash you may face. |