Welcome to oslab.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.
Events of copyright infringement The Events of Copyright Infringement: Innocent People Infringing Accidentally Copyright infringement is in the news a lot lately – it’s hard to miss stories about kids being carted off to jail or seriously fined for downloading music or movies off the internet. I’ve even heard about a lady was fined for tens of thousands of dollars because of the events of copyright infringement – her grandson downloading music, and she couldn’t prove it wasn’t her. The events of copyright infringement are complicated – and not easy to define. Surfing the internet has its advantages and disadvantages, that’s for sure. We’re able to find useful information quickly, but how close are we pertaining to copyright laws? Do we even know what is and is not acceptable? A couple of the more pertinent questions have been asked below: If you hear a great new band, and then download a song from MySpace, is that legal or not? The events of copyright infringement are not only limited by Kazaa, Morpheus, or some other file sharing peer to peer (P2P) service. If you download a song - no matter if you’re on a website or a MySpace page - and it isn’t coming from the artist themselves, you may want to think about downloading it. Chances are, if it’s not coming from them, you can’t have it – unless it is under a Creative Commons License. Creative Commons gives the exact ways in which you can use the license – and many times those are completely free and legal to download – so make sure you check if it’s under a CC License. If I’m writing a paper, or article, and I want to quote another website, can I? First of all, did you know the minute you write or create something, you hold the copyright to it? ESPECIALLY if you’re writing it online – it’s very easy to track things in the internet page. So, if you’re writing a blog, all the things you’ve written (no matter good or bad) are there permanently, thanks to archive.org, and you can review last versions of your web pages. Sometimes, people we can use – rather heavily – someone else’s work in our own, and think we’re small and anonymous. That no one will notice by the time you get it down – you’re just ‘borrowing’ it. Before you begin quoting anyone’s website – from CNN to your local neighborhood hardware store – you need to ask the person who holds the copyright if you can. Usually, they’ll let you if you attribute to them. Depending who you talk to, you’ll either have to pay royalties or license rights to republish. If you don’t ask before you quote, you’re beginning the events of copyright infringement and you are opening yourself up for a lawsuit. As you can see, the events of copyright infringement can begin at any time, beginning with normal ‘everyday’ activities. It’s just as easy to infringe on as it is to be infringed upon. Make sure you check your copyright using CopyScape or some other service, and you can check your work against other works on the internet, and make sure that you’re not infringing someone or vice versa. In this day it’s easy to protect yourself from getting infringed upon, and the events of copyright infringement are easy to track. It’s easy for innocent people to get caught in copyright infringement, like children they didn’t know what they could and couldn’t do. Make sure, in all you do, that you’re striving to do the best you can, and you’ll be certain not to fall victim to your own infringing demons. Publishing a Book is the Final Frontier (book publishing) Many authors begin their careers intending to publish a book. Book publishing is a difficult task to accomplish. It takes many months of work and extensive preparation. A book involves intricately woven ideas. A book is a project. In that project is contained many other projects. Most people are not prepared for the intensive process that is involved in creating a full, coherent book. If book publishing is something that you are interested in trying, there are a few things you should keep in mind. First, writing a book is like nothing you have ever done before. It will take extensive and intensive work and development. It will also probably include much of everything you know, and more. Read on for more clarity. Uncharted Territory Book publishing is like a new land that has never been explored before. Of course, there are several book authors out there. They have been around for centuries. Unlike other areas of expertise though, book writing is not something that will be the same process for several different people. As you set out to write a book, you will be able to follow some basic guidelines, but getting your ideas from your head to the page will be an invention of your very own. Not only will you have to get the information onto the page, but you will have to write in a way that thousands or even millions of readers will be able to relate to and understand. Again, that will be a process that will take experimentation and trials. As you begin the process of writing your first book, as well as subsequent books, expect to work and rework. One Idea Is Not Enough Part of the reworking process is the changing of direction within the writing. Many beginning writers aspire to book publishing. They have an idea and vague plan to turn the idea into book. Picture your first grader telling you that she wants to write a book about horses. There is certainly enough information that people want to know about horses to fill several books, but the vague idea is not enough for an adult writer to create publishable work. To write a book, you will need to start with a topic. You may or may not be an expert on the subject. After you have the first vague ideas, you will need to start asking yourself questions. Answering those questions will hopefully lead you to more questions, and so on. Even if your original idea is completely unique and will lead you to write new information that the world does not yet have access to, you will need to add to that original idea for an intriguing finished product. If you are not an expert, or if you do not already know any new information, it will take even more time and effort in order to produce a unique piece of writing. Fiction is the same as non-fiction. Many stories have been told before. If you want to publish, you will need to come up with an engaging and new journey for your readers to take. Using Previously Published Work Now that we have covered the requirement for intricate and new ideas, there is also room in a book for old ideas. Your readers will need a starting place within your writing that is familiar and known. As you are putting together your ideas for a complete book, you will probably publish smaller pieces of work in magazines and newspapers. It is ok, as long as you cite yourself, to reuse some of that work. In that way, you can be publishing as you go along while still making progress towards your end goal in book publishing. After several months or even years, you will have poured out your effort and knowledge into a finally completed and whole book. |