Welcome to elreno.org
|
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.
Web Hosting - Sharing A Server – Things To Think About You can often get a substantial discount off web hosting fees by sharing a server with other sites. Or, you may have multiple sites of your own on the same system. But, just as sharing a house can have benefits and drawbacks, so too with a server. The first consideration is availability. Shared servers get re-booted more often than stand alone systems. That can happen for multiple reasons. Another site's software may produce a problem or make a change that requires a re-boot. While that's less common on Unix-based systems than on Windows, it still happens. Be prepared for more scheduled and unplanned outages when you share a server. Load is the next, and more obvious, issue. A single pickup truck can only haul so much weight. If the truck is already half-loaded with someone else's rocks, it will not haul yours as easily. Most websites are fairly static. A reader hits a page, then spends some time skimming it before loading another. During that time, the server has capacity to satisfy other requests without affecting you. All the shared resources - CPU, memory, disks, network and other components - can easily handle multiple users (up to a point). But all servers have inherent capacity limitations. The component that processes software instructions (the CPU) can only do so much. Most large servers will have more than one (some as many as 16), but there are still limits to what they can do. The more requests they receive, the busier they are. At a certain point, your software request (such as accessing a website page) has to wait a bit. Memory on a server functions in a similar way. It's a shared resource on the server and there is only so much of it. As it gets used up, the system lets one process use some, then another, in turn. But sharing that resource causes delays. The more requests there are, the longer the delays. You may experience that as waiting for a page to appear in the browser or a file to download. Bottlenecks can appear in other places outside, but connected to, the server itself. Network components get shared among multiple users along with everything else. And, as with those others, the more requests there are (and the longer they tie them up) the longer the delays you notice. The only way to get an objective look at whether a server and the connected network have enough capacity is to measure and test. All systems are capable of reporting how much of what is being used. Most can compile that information into some form of statistical report. Reviewing that data allows for a rational assessment of how much capacity is being used and how much is still available. It also allows a knowledgeable person to make projections of how much more sharing is possible with what level of impact. Request that information and, if necessary, get help in interpreting it. Then you can make a cost-benefit decision based on fact. Copyright music consecutive notes Copyright Music, Consecutive Notes, and Fair Use When it comes to copyright music, consecutive notes, and lyrics are all covered under the blanket of copyright protection. Once you've registered your copyright you have legal recourse should someone steal or 'borrow' any part of your music without permission. Just so you understand, most of sites online that you visit when checking out the lyrics to your favorite song are actually infringing on the copyright of the author and the recording artist. Not only are the sites that offer lyrics guilty of infringing on the copyright music, consecutive notes and all so are the sites that offer written music, chords, and tabs. It is not legal to use any part of the song that isn't covered by 'fair use' without the express permission of the holder of the copyright. It makes things a little difficult for most people and it is often hard for many to distinguish what qualifies as fair use from what is actually copyright infringement. Copyright music, consecutive notes included keeps artists paid as most of them live on royalties rather than fat cat advances, fair use will not take those future payments from the authors for the sake of personal entertainment. Fair use was once thought to mean that if you weren't making money from the copy or use of materials then it was allowable. This is one of the arguments that was used when defending massive file sharing servers, the defense however falls flat of the law. It is illegal to share copyright music, consecutive notes, lyrics, tabs, chords, or any other part that is part of the music and covered by copyright. The fact is that the only case where the copying of music is clearly allowable is when used for non-profit education and educational research, for the purpose of criticism, commentary, and news reporting. According to the letter of the law ripping your CDs is an infringement of copyright. The result of massive file sharing has prompted new laws to address the problem and provide a more clear definition of what is not allowable as far as copyright music consecutive notes and any other part of a song are concerned. According to the amendments you must have the express permission of the performer to fix the sounds or images into any type of phonorecord, to transmit these sounds to others, or to offer to distribute, sell, or rent any of the copyrighted material. That about sums up file sharing in a nutshell and clearly establishes the practice as illegal. Artist copyright music consecutive notes, lyrics, and performances in order to protect those things from abuse, misuse, and to protect their interests. While some may be artists that perform for the sake of the art, most of them are not independently wealthy and need the income that results from the sales of their music. Many have families to feed as well as fabulous lifestyles. Regardless of their inherent needs for the funds, they've provided a service (entertainment) that we place a certain value on and they deserve to get paid for the services they provide. The copyright music, consecutive notes, new music, and future music depends on people honoring the spirit of current music copyrights. If you haven't noticed entertainers are more often than not interested in the money that is their reward for entertaining. If that wasn't the case, NFL players wouldn't make more money than many corporate CFO's. You might also have noticed that players and entertainers often stop playing and entertaining when they do not think they are getting what they are worth. If you don't recall, the NHL skipped an entire season a few years back over salary negotiations. This, more than many things, should drive home the point that if things such as copyright music consecutive notes and otherwise aren't respected and observed our favorite performers will stop producing new material for us to enjoy. |