Welcome to www.tetheredmommy.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.
Prayers, Ploys and Passions: The Poetry that Gets Published (published poetry) Some people may tell you that poetry doesn’t get published. Published poetry is only that written by people who have already died. That is not true however. Poetry is not as frequently found as other kinds of writing, but it is a genre that is still alive and well in today’s publishing world. If you are a poetry writer, you are also probably a poetry reader. You of all people know that poetry publishers are still out there. There are specific types of poetry that tend to get published though. There are special interest outlets for other types, but in general, what gets published gets repeatedly published as time goes on. There are three main categories that currently published poetry falls into. Those categories encompass the most important interests of people today. Prayers and Matters of Faith The first category of published poetry involves faith. There are people that subscribe to all different kinds of faith and it is that belief that is at the core of many people’s lives. Atheists are a minority in the world. Since faith is such an important part of so many people’s understandings of the world, it is no surprise that it draws poetic words from those who believe. It started long ago. The Bible, for example, is full of poetry. Those people who first knew God were inclined to speak of him through the illustrative voice of poetry. Today people are the same way. Such is their deep experience with God that they must express their emotions with an emotional type of writing. Since so many people have personal experiences with God, those who do not write are interested in reading the writings of others. For that reason, matters of faith, and especially expressive prayers placed in poetry get published. Ploys and Plans for the Nation National interest is also of major interest to most people. As a group of people head through their lives, united with others of the same nationality, they must want to know where the group as a whole is headed. Much of the published poetry in this category contains hopes and dreams for a country’s future and expected path through history. More of the poetry in this category though is in protest of how a nation has forged its path as it has grown. Frustration with events beyond one’s control elicits words that can only have their full meaning in poetry. Since those of a nation are united with each other, poetic commentaries about that nation are of interest to everyone. They help each person express their feelings and frustrations and hopes for their home country. Passion and the Human Condition of Love People are obviously not only connected to each other as citizens of the same country. People need each other in a much more personal sense than that. A third major category of published poetry is that which contains expressions of love between people. Love poems are a genre that dates back, again, to biblical times. Romantic love has always been a popular theme within poetry because of the passion that can be displayed with poetic devices. Other kinds of love are also well expressed in verse. The love of a mother for her child or that of a friend for another friend is a common topic in poetry. Humans thrive on love. That is why poetry about love gets published. Published poetry does fall into three major categories. It appears in books and anthologies, but also in magazines and even greeting cards. As long as a poem is effective in describing a common human reaction to life, it will probably be passed along from person to person. Poetry is a beloved form of writing that connects people to one another. As long as humanity feels, poetry will continue to be published. Understand Group Publishing (group publishing) When you want to have one your books published, you will work hard to get your book finished and then you will seek out a publisher. Sometimes it is very hard to find the right publisher, but the good news is that there are several different types of publishers that you can use to get your works on the market. Large companies are not your only option. The world of publishing difficult to break into and if you get an acceptance letter--that is only the start. There are many types of publishing companies out there and they all have a different way of publishing their products. Here is a look at some of the more common types of publishing including group publishing. Group Publishing: Group publishing is the process in which a large company publishes your work in the name of a larger company. For example, there are big name publishing companies out there. They operate smaller group publishing companies. The larger publishing company serves as a kind of umbrella over the smaller group publishing companies. Sometimes these companies operate several smaller companies that produce different genres of writing and books. This is also sometimes called trade publishing. For example, a large publishing group may produce best selling adult novels, but may also operate under a smaller name to produce certain non-fiction books, cookbooks or children’s books. Group publishing is a popular way to publish a book. Educational Publishing: Besides trade publishing, there is also educational publishing. These are companies that deal specifically with educational material. They may deal with only college textbooks, or they might deal with textbooks and materials for grades K-12. Besides textbooks, these companies might also produce other forms of educational material, which include posters, workbooks, CD-ROMS, software, testing material and maps. There are several big name educational publishing companies. University publishing—University Press: This type of publishing is not like group publishing and it is not the same as scholarly publishing. These types of companies are usually non-profit and are run by universities, colleges and even sometimes museums or other organization. These usually publish books by scholars and other specialists and they usually are used within the university system. Sometimes these books do get published by a larger trade publish; however, they do not market these types of books. Independent publisher: Independent publishers are often the best way to get your book published if you cannot find a publisher to produce your book. These are generally smaller companies that are privately owned. Many times, these companies only publish a handful of books each year and they usually are about certain subjects. They have the freedom to publish just about anything they wish. Software and other Media: You might not consider software and other types of media as being a publisher, but they are. Think of all the e-books, CD-ROMs and even books on tape that are on the market. These have to be published, too. These types of companies are often associated with larger trade publishers. In fact, many large publishing companies have their very own media publisher in house to take care of this type of publishing. It is a very large business and these types of publishers are just as important and lucrative as the large trade publishers. As you can see, there is a whole world of publishers out there waiting to get your book or other media published. If you do not have luck with a large trade publisher or group publisher, then don’t give up. Keep looking and the different types of companies out there until you find one that wants to work with you and your book. |