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.

Music copyright infringement How Does Music Copyright Infringement Affect Me? Music copyright infringement happens all around us every day, by both well meaning people downloading music from their favorite social networking site to the guy who’s reselling MP3s. To be certain, most people who commit music copyright infringement don’t realize what’s going on, and are in turn doing something very illegal and prosecutable in the United States. Copyright Infringement, as defined by Wikipedia.org states: “Copyright infringement (or copyright violation) is the unauthorized use of material that is protected by intellectual property rights law particularly the copyright in a manner that violates one of the original copyright owner's exclusive rights, such as the right to reproduce or perform the copyrighted work, or to make derivative works that build upon it. The slang term bootleg (derived from the use of the shank of a boot for the purposes of smuggling) is often used to describe illicitly copied material.” We’ve all heard of ‘bootleg’ recordings – usually audio recordings taken from concerts and sold on home made cassettes or CDs and distributed (sometimes out of the trunk of a car) to anyone that will buy. Bootleg recordings have changed, however, as music copyright infringement has branched into video recordings. Music copyright infringement has exploded with the advent of the internet, and now people from all over the world are sharing every type of imaginable file – from eBooks to audio to music – and small label artists began feeling the pinch years ago. However, many new and older artists are beginning to see the beauty of the internet, and are offering their music for sale track-by-track on iTunes and other MP3 sales websites, as well as through their own band websites and MySpace pages. The internet has exploded in the possibilities it’s given up and coming musicians to become visible, while at the same time drastically increasing the number of music copyright infringement cases – some of which were against innocent people who just weren’t informed. Music copyright infringement cases have helped to create organizations that protect the fair use of an item, such as a song. Organizations such as CreativeCommons.com and the Electronic Frontier Foundation help individuals to know their rights under copyright acts. While there are organizations that help you understand your rights as a purchaser of copyright use, there are organizations that want to limit the ways in which you use the products you buy. It is rumored, for example, that record distribution and production companies want to limit the ways in which you use the music you buy – they don’t want you to put it on your computer or make a Mix Tape or CD from it – for fear of ‘sharing.’ It seems to me, however, when music publishers and distribution companies limit uses like this, they’re opening up a tidal wave of music copyright infringement cases. By limiting the use of purchased material, the companies are alienating their client base and pushing all their sales away from physical products and toward electronic ones – which are much harder to control. A way in which these companies tried to limit the uses was by creating a DRM program, which severely limited the where a CD could be played (on one computer, for instance). And, in one drastic measure, Sony placed a DRM program on all their CDs in the Winter of 2005, and severely crippled several networks when their ‘program’ was actually malware that seriously crippled network security. As you can see, music copyright infringement is something that is currently being fought between end users and music production and distribution companies. In this new century, we must find a way to retain copyright, and allow the customers to use the products they buy in a meaningful way, or otherwise the market will shift and the industry as we know it will be abandoned.

Copyright Infringement Statistics Copyright infringement statistics, by most standards are inflated. Most recent copyright infringement statistics cite that almost 30 percent of software is pirated in the United States of America. This means that they think 30 percent of the software on your computer is illegal… they think we’re all thieves, to an extent. However, copyright holders have good reason to worry that we’re violating their rules: the number of suspects referred to the United States attorneys with an Intellectual Property lead charge increased twenty six percent in the period between 2002 and 2004 – and there have been studies that show that this is rising. Copyright infringement statistics are difficult to come by, but it’s plain to see it’s affecting every aspect of intellectual copy. Copyright infringement statistics show that in addition to software privacy, there are a lot of violations in the music world. Copyright infringement statistics show that many unsuspecting people, from college students to thirty-something a professional, download music on a consistent basis, and often it’s not downloaded legally. Often times, someone will download a song off a MySpace or YouTube page, without giving thought to who really owns the copyright and if it’s legal for them to have it. Copyright infringement statistics, brought to us by the music recording industry, would have us believe that online infringement is seriously hurting the recording industry. A sensible person, however, would realize that with the abundance of MP3 sales sites that this will turn quickly and recording giants will see the huge profits available online. It’s already begun, you see, we have yet to see the impact of online music sales, and how it will increase revenue. I’m sure, with the huge talent pool at their disposal, the media giants will find a way to monetize the internet to their fullest advantage. Copyright infringement statistics also show that many people are downloading games off the internet. With the litany of games available to us – from complete alternate worlds such as World of Warcraft to the more mainstream “The Sims” series, people are clamoring for PC games – and for good reason. They’re fun, intelligent games that play on a system everyone has – a computer. Because of this, people are always looking for new games to play and download, and they may download a game without knowing that it’s not ‘freeware’ (as many internet games are). In addition to computer games, copyright infringement statistics also show that movies are downloaded in abundance on the internet. Many peer to peer file distribution sites and programs (such as bit torrent or Kazaa) allow for the transfer of very large files, and they’re easy to find online. Using a tool provided by one of many suppliers, users can search for any item they like – and, of course, the system is abused and people download copyrighted movies and entire DVDs instead of publicly available works. Copyright infringement also branches into written works, such as articles, books, poems, etc. Many times, a student will copy a paragraph or two without realizing the implications of such copying. While they may think of it as ‘borrowing’, if it’s used on a grander scale, the person could be opening themselves up to a large court fight, especially if it’s used commercially. As you can see, copyright infringement statistics show us that many people are using copyrighted works illegally. Do your best diligence when using another’s work – and ask for permission every time you want to use something that you haven’t created. Chances are, if you just ask the question up front you’ll save yourself from becoming another copyright infringement statistic and save yourself from a major lawsuit.