Welcome to www.wheelchairsoftball.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. Handling Age Difference in the Workplace for a Positive Experience People are entering the workforce younger and getting out of it later in life, according to business experts. This fact means one thing: that the age gap in some offices is getting larger, and it could be getting more difficult to manage. Age differences in the workplace don?t have to be a cause for arguments and conflict, however. Having people of different ages working together can actually be a positive experience for everyone involved, both professionally and personally. How the age difference question plays out in your office all comes down to how you handle it. Age differences have always been an issue in the workplace. A generational gap between the old guard and the up and comers has always been unavoidable, but people knew how to manage it in a world where people got one job when they were started out in the working world and stayed with that company throughout their careers. However, those days are gone for good. People tend to bounce from job to job, out of choice or out of necessity, and so that means many workers have to adjust to age differences in the office place while adjusting to new jobs, period. Even this sense of bouncing around to different jobs can inflame the age difference issue. Older people may not relate to the younger generation?s ways of moving from job to job and drive to find a career that not only makes them money but that they also love. This culture class can cause misunderstandings and tension in the workplace. What is happening more often with the changing work market is that many younger people are finding themselves in the position of managing older people. Because younger people tend to change jobs more, and because they grew up in the computer generation, they often have more qualifications than older workers. This can cause tension on both sides. Older workers can feel under appreciated and passed over for a job that should have been theirs because of seniority, and younger bosses may feel funny about telling older employees what to do, and correcting them when they make a mistake, because they are supposed to respect their elders. Is there any way to avoid these conflicts at work so that age doesn?t become an issue? The first way to make sure age isn?t an issue is to simply decide that it isn?t one. If you have younger boss, keep in mind that they were hired for a reason, and be open to the things you can learn from them. If you are in charge of managing an older team, don?t go easy on them because of their age. They won?t respect you for it, and you will only be emphasizing the difference between you. Instead, treat them as you would any other employee, while making personal allowances for some resistance to chance on their part. A certain amount of ?in my day? kind of talk is inevitable. Accept it and take it on board ? you might even learn something ? but have confidence in enforcing the decisions you make at the same time. The other best way to manage age differences in the office place is to always keep the lines of communication open. If you are a younger manager in charge of an older team, make an active effort to solicit their opinions and to be available to them when a problem arises for them. If you are an older person in the office wondering about how to relate to the younger workers, ask questions. A glimpse into their world may do wonders for your ability to understand and relate to them. Not only will you become more effective co-worker, you might even end up being friends. |