Welcome to esiq.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.
Copyright Infringement Play It Safe: Making Sure You're Not Committing Copyright Infringement Copyright infringement is not an easy thing to explain. While it may seem as simple as not using someone else’s work, it’s not that easy. Thanks to the Electronic Frontier Foundation, and many other organizations, we have the ability to use others’ works – as long as we use it under ‘fair use’ laws. So what does fair use have to do with copyright infringement, and how can you utilize it? Fair use laws are the conditions in which you can use a copyrighted work without having to pay someone royalties. This includes when you use a copyrighted work for educational or instructional uses, criticism of the work, commentaries on the work, news reporting about the work, teaching on the work (including multiple copies for classroom use), scholarship uses, and research. This is talked about fully in Section 107 of the Copyright Code (commonly called Fair Use) and is available for you to read at your local library. Copyright Infringement in day-to-day life Sometimes, if you’re writing a paper for work or school, or if you are creating a Power Point presentation, you need to use someone’s work that is already in copyright. So how do you use it without committing copyright infringement? All you have to do is ask – the worst they can say is no, right? But, if they do say no, there are several items in the public domain which may help you to finish your project without having to commit copyright infringement. What is the public domain, and how does it relate to copyright infringement? Material that is not copyrighted is considered in the public domain – you cannot commit copyright infringement on works in the public domain. These works include things that the copyright has expired on, or is not copyright-able – such as government publications, jokes, titles, and ideas. Some creators (writers, musicians, artists, and more) deliberately put their work in the public domain, without ever obtaining copyright, by providing an affiliation with Creative Commons. Creative Commons allows people who create materials to forfeit some, or all, of their copyright rights and place their work either partially or fully in the public domain. So, how do I ensure I’m not committing copyright infringement? First of all, if you’re going to use someone else’s material, you may want to check the public domain to see if something is suitable for use, instead of trying to use someone else’s copyright. However, if you can’t find something suitable (and you can’t create something yourself), the next best thing (and your only legal course of action) is to find a piece that is in copyright, and contacting the copyright holder. When you contact the copyright holder, make sure you tell them what you want to use their piece for – whether it’s for your blog, podcast, or report – and ask them if you can use it. You may have to pay royalties, or an attribution in your piece, or a combination of both. The creator may also place many limitations on when and how you can use their material. Follow all these instructions they give you, and you’ll be free and clear to use their work as you want. Once you have permission to use a copyrighted work, you need to make sure you stay within the agreed-upon boundaries - if you veer outside their agreed terms, you may open yourself up for a copyright infringement lawsuit – which can be nasty, costly, and time consuming. If you’re in doubt, before contacting the copyright holder, contact a copyright lawyer to ensure you’re following the law – and protect yourself! Get the Scoop on Some Great Informative Parenting Freebies Being a parent can be hard and especially, when it is about money. So many things in life are very expensive and children often desire what they cannot have. Therefore families of average or below income have often trouble giving their children what is in or what other children have. Therefore any opportunity to get something for free in parenting hood is a great opportunity. Whether it is free advice, free literature or even free products, it is surely something that a parent can use. Where and how to find great parenting freebies? It is actually fairly easy to find parenting freebies, especially when one has access to the cyber world. The Internet is one of the greatest resources for information, products and advice. The Internet holds freebies for any stage in life, but the most for the infancy and toddler stage, as well as some resources for the young years of life before children grow into adulthood. Many of the resources that are available on the Internet are actually sponsored by different departments of the United States government. For example, the US Department of Health offers easy reader books for young children or a free CD for parents with information on the development of teenagers during their adolescents. For parents of toddlers, the Internet holds resources for free toddler magazine subscriptions, potty training success guides and guides to prevent childhood lead exposure. Many of the major issues in toddler live can be found online with advice, frequently asked questions sections, chats and forums to help parents. For later on in life, there are plenty if resources that will help parents with such things as saving for college, preventing teen pregnancy, preventing drug and alcohol abuse in the teenage years and preventing or talking about smoking with children. All the information that is available online is often also available for parents as kits that are mailed to their houses. Online pages offer forms that parents can fill to have material sent to their home mailing address. Books, CDs, DVDs, guides, and other informative material can be downloaded or requested by parents. Many parents do not know about these resources and struggle with these exact same problems that they could have help with. Some of the offers for young children, such as free music downloads for children, often include such music as classical music and therefore might make a good download for anybody who loves classical music. Even though these pages are geared at babies and toddler, it does not mean that other people cannot use this music for themselves. Other sources on the internet offer for example free descriptions to art projects, fee coloring pages that can be printed using any printer, free read along stories online and more. There are so many activities online, that parents can do with their children, or that can be used to educate children that sometimes it might be hard to choose with what to start. The Internet also offers parents the possibility to talk tot her parents and get connected without having to attend an actual meeting or playgroup. Whenever parents need advice, they can just log on to one of the many free parenting sites and ask questions. Of course answers are given by other parents and are more their thoughts and experiences rather than professional advice, but some of the pages sometimes offer advice from experts on topics and have special chat sessions for parents with these experts. Whatever kind of informative parenting freebie or product parents are looking for, the Internet might hold the answer to their questions. It often amazes parents what they can find just by typing their questions or search keywords into one of the Internet search engines. Literally hundred of answers and pages with free help might pop up and parents might have a hard time reading it all. |