Welcome to www.kstreetproject.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.
Free Copyright Music Free Copyright Music Means Deeper Well for Artist Inspiration Free copyright music is often mistaken with domain free music or music in which the copyright has expired. A copyright is in place for the lifetime of the author plus 70 years. If there are more than one writer's for the music, the copyright will be in effect for 70 years after the death of the last surviving contributor. While this rule was set in place in order to ensure that the heirs of the author would also benefit from the royalties after the music's writer or composer was no longer living it is important to remember that these laws are the current laws and music written at different points in time are most likely subject to different copyright laws. When searching for free copyright music it is always a good idea to search through music that is very old rather than focusing your search on more recent musical selections as they will most likely still be under copyright protection. It is important to remember when using free copyright music or public domain music that you must be certain the copy you are using is within the copyright period. Any music that was published before 1922 is public domain music. This does not however include derivatives or new versions of that music which may still be under copyright protection. Finding a copy of the music with the copyright date included, if that date is prior to 1922 is the best route to ensure that you are in compliance with current copyright laws and not infringing on someone else's copyright. It is also important to keep in mind that written music is protected differently than recorded music. Almost every sound recording that has been copyrighted in the United States is protected until 2067. If you absolutely need a sound recording you should either purchase one or make one of your own. There are some free copyright music that will allow free use of the music whether written or recorded, you must be thorough in your search for this music however as it quite rare. Another thing to consider is that copyright laws in the United States are different than they are in other countries and if you wish to use music that is or was under copyright in another country you must follow the laws that apply to the particular piece of music you wish to perform. Free copyright music is available in almost every country and many genres; the trick is in finding great sources where you can easily find this music. There is a project called Mutopia, which operates like project Gutenberg. Mutopia provides free copyright music rather than books however. The Gutenberg project also has a section that is devoted to free sheet music in addition to its wonderful resources for books. Each of these projects provides excellent resources for those who find themselves in need of free copyright music for whatever reason. Whether you are a musician who is seeking inspiration from the music of old or hoping to find a composition, which you can rearrange and make your own, there are many ways in which you can go about achieving your goals that will not violate current copyrights. The key is in learning the laws both where you live and in any countries in which the music you seek to modify. By choosing selectively and listening to your options with an open mind and seeing things with a creative eye, you will find a huge world of opportunity available to you as a musician. Isn't it amazing how free copyright music can have such an effect on your ability to create music that you may someday copyright? Software company patent A Software Company Patent is the Door to a World of Confusion There is no universal understanding of exactly what a software company patent is. In general, owning a patent allows a company certain rights (or exclusivity) for a prescribed amount of time. Individuals or corporations seeking a patent must apply for a patent in each and every country in which they wish to have one. Unlike copyrights, patents are not automatically granted to applicants and can take quite a while in order to be approved. Another thing to remember, particularly with a software company patent, is that a patent may issue in one or more of the countries in which you've applied but not all of them. The real problem lies in the fact that there really is no central agreement about what a software company patent actually grants among any of the nations so those who are awarded patents may not be getting exactly what they think they are getting in the process. With no universal agreement there really can't be universal enforcement about the laws and the rights surrounding a software company patent. The growth of Internet business and e-commerce in general has led to many patent applications for software, particularly software that was designed for specific business applications. The problem is that while the cases are granted and successfully tried and defended in some countries, other countries offer no enforcement or legal recourse for those who do not honor the software company patent even if the patents were granted in those countries. The fine line between nations about what is and isn't patentable is another challenge when it comes to establishing and honoring patents. In other words, the issue of a software company patent is a rather confusing process at best. Patents differ greatly from copyrights, which are issued automatically and recognized and enforced internationally. Copyrights protect the source code of software from being copied and registration is generally not required in order for your work to be protected. Lately there is a new term, copyleft, which is an obvious play on words and represents the rights to not only redistribute the works that are covered by this but also to modify and freely distribute those modifications. This term is very much in the spirit of many open source types of software and music. The catch for copyleft protection is that the newly created work be distributed in the same manner and spirit in which it was received. In other words if you were freely given the software, then you must freely provide the improvements and modifications you made to that software. Of course this is a long way from the idea of a software company patent. It is also important that you are sure you understand exactly what you are applying for as far as your patent goes. Different countries will grant patents for different things and those are closely regulated and carefully regarded when it comes to software-know what you are applying for and understand what you are being granted. A software company patent means different things to different people in different places and it nearly impossible to get other countries to honor a patent that they would not have granted at the same time they shouldn't expect other countries to honor patents based on their decision to do so either. One unfortunate circumstance surrounding patents is that there seems to be an unequal and obvious disparity between the haves and the have not's. Patent enforcement for software, unlike literature and music is largely subjective. In literature and music, it is rather obvious that the copyright has been abused or that the work has been copied, this isn't as simple with software which is one other reason that software company patent is such a hotly debated subject in the software industry. |