Welcome to www.fmbb.net
|
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.
The Makings of a Magazine: Do They Include You? (writing magazine articles) Magazines are everywhere. They are published on nearly every subject you can imagine, in duplicate and triplicate and more. All that a start-up magazine needs is a niche and an audience. While there may be hundreds of cooking magazines out there, a new one could come up if it should cover cooking for your pets. In fact, there may already be such a magazine in existence. The niche is cooking for pets. The audience is those people who want the healthiest foods for their pets and are willing to put the time and effort into making it for them. If you are interested in writing magazine articles, you’ll be sure to find one that is perfectly suited to your interests and abilities as a writer. Because there are so many magazines, it won’t be difficult to find one that you will enjoy becoming a part of. What You Should Know Magazines survive on advertising. The advertisers pay because the content is good enough that readers will invest in the glossy covers again and again. The best way to find a healthy magazine is to look through the racks for thick publications. They will only be full of content if they are full of advertisements. The big magazines can afford to pay their writers more, but they can also afford to pay only the best writers. Even though there is quite a lot of space to fill with content, you may have a hard time getting published in major magazines at first. Smaller magazines do not have quite the readership and so they also do not have quite the advertisement content. The space will be limited and the pay will be lower, but these magazines will be more open to new writing talent nonetheless. The More You Know, the Better When it comes to a writing career, the more you know the better off you will be. It is not hard to figure out that you will have the best chances for publication if you can write on a variety of topics. You should not limit yourself to a small area of expertise. Work to become an expert in every topic you come across. There is no possible way of course to be an expert in every area of human knowledge, but it will help you in writing magazine articles to learn every new piece of information that you can. For example, if you were to send a query to a health and fitness magazine about writing a short piece about general mountain biking tips they may accept it. They may also then request additional information about the pros and cons of using a road bike on mountain trails. If you only know about mountain bikes, you’ll be stuck. If you have worked on broadening your horizons though, you’ll be able to produce the work that the magazine editor requires. Getting On Staff Querying magazines is a way to get published, but if you need a more stable job, you may be interested in getting on staff with a magazine. Writing magazine articles is a talent. If you can consistently bring an editor what he is looking for, you might have a chance. To improve your chances, in addition to writing effectively, it will help to have some significant education behind you. If you are serious about making it to the masthead of your favorite magazine, it’s time to go to school. A degree will help your credibility as a writer and will help you open doors into the magazine publication world. Writing magazine articles takes a special kind of writer. You have to have a feel for what people are interested in reading about. The magazine content will help you understand how to write for a particular magazine and audience. You can also improve your chances of writing accepted articles by improving your knowledge base. Don’t be picky about what you’re willing to learn and you could go very far in the writing business. Extra! Extra! Getting into the Newspaper Business (writing news articles) The news is now and those who write it know the stories first. Getting into the newspaper business can be difficult because of the competitive nature of the news. The successful reporter needs to be organized, efficient and able to work under extreme pressure. The flip side is that a newspaper writer is almost always a celebrity. If he or she works for a large newspaper, his name may be known all over the country. If he only works for a small town paper, that town will recognize his name. Writing news articles involves ups and downs, so read on to learn more about it. Newspaper Overview A newspaper office is an interesting place to be. Bright and early at eight o’clock in the morning, the office is quiet and dark. As the rest of the world is counting down the minutes to quitting time, the reporters’ desks start to fill up with hurried typing and flipping through notes. Well after dark, the last stories get wrapped up and put to bed. They may have been changed a couple of time as new developments occurred. Some stories written will make it to the front page. Some stories though will get significantly cut or cut from the paper all together. Writing news articles may be very rewarding, but it also requires a different kind of lifestyle than most careers. Becoming a Reporter If you are interested in writing news articles, you may also be interested in learning a little bit more about what is involved in becoming a reporter. Writing is a very important piece of being a successful reporter. Writing news articles involves close attention to journalistic style. Most full time reporters have journalism degrees. Those that don’t have learned to imitate the style with precision. A good journalist must learn the art of interviewing a subject. Freelancing If the full time reporting job is not for you, look into writing news articles on a freelance basis. It will help if you develop a relationship with the editor of the newspaper you intend to write for. Since so many people want to see their names in print, it can be hard to break into the freelance newspaper business. Writing news articles on a freelance basis requires a good eye for newsworthy topics as well as a thorough and fair representation of the facts. Freelancing takes practice. Don’t be discouraged if the editor doesn’t like your work initially. If you keep trying, you’re bound to stumble onto something great. Once you are in and an editor likes you, you’ll be able to work more freely. What’s News? Before you are ready for writing news articles, you should be ready to judge for yourself what news is and what it is not. Regular reporters are assigned stories to write, so they rarely have to come up with topics on their own. Freelancers write their stories and then try to sell them. The first rule about deciding what is news is that if someone asks you to write about it, it’s not news. You should have to dig up the good stories. If you need inspiration, just start talking to people. Get to know a few of the prominent people in your community. Build relationships and keep asking questions. The stories will come out eventually. You can also take a tour of your community with your eyes wide open. Look for anything suspicious, dangerous or exceedingly beautiful. Take your camera wherever you go just in case you happen to be an eyewitness to something newsworthy. Writing news articles can be done as a career or as a freelance pursuit. Whichever you choose, you’re sure to lead a life with some adventure. The news is always happening and it’s always something new. |