Back To CourseRelational Databases Tutorial
10 chapters | 112 lessons
As a member, you'll also get unlimited access to over 75,000 lessons in math, English, science, history, and more. Plus, get practice tests, quizzes, and personalized coaching to help you succeed.Try it risk-free
Michelle has been an academic librarian for over twenty years. She has a Master’s Degree in Library Science from the University of Wisconsin-Madison.
Have you ever had to research a topic for work or school and you received thousands of Internet results? Did you know that there is a more efficient and effective way to search? A subject database is a collection of specialized information with a narrow focus. The best part of a subject database is that it can help refine your search results, saving you lots of time.
In the corporate world, subject databases, such as Dun & Bradstreet, are used daily by millions of business professionals. Businesses pay for the databases and they can be costly. But what if you do not work for a business? How can you get access to the subject databases in your field?
Your library can help. Libraries provide access to books, magazines, and a host of other resources and services. Government, public, and school libraries provide subject databases just for your research. Through subject databases you can research everything from Ancestry (genealogy) to Zinio (online magazines).
One type of subject database is a bibliographic database, which is any subject database that contains information and references to library materials. If you're a college student, your academic library may have bibliographic databases that have been hand-selected for your major or field of study. Let's say that you are studying to be a teacher. The ERIC database has all education-related information.
One of the best features of ERIC and other subject databases is that they contain a controlled vocabulary, which is an organized list of terminology used to index and retrieve information. This tool helps you find the best and most appropriate terms for your search, which are listed in a resource called a thesaurus. Subject databases for every field exist. Many have the full text of the journal article available for you to view, print, or even e-mail.
You might be pleasantly surprised about what types of material subject database libraries have. Some libraries now have streaming music and video as part of their subject databases package. eBook packages are popular as well.
Using a subject database can be beneficial for your research. The first advantage is that assistance is available from a librarian. Be sure to look for the ''ask a librarian'' button with your library name or logo, where a real librarian is able to help you with your research. In many cases, your search will be magically e-mailed to the librarian so they can best help you.
In addition to research help, library subject databases are streamlined. They often lack distracting advertisements. Since the databases require a subscription through your library, there's no need for ads. The subject databases are like a gift card, which has been pre-paid for you by your library. All you need to do is log in with your username and password, known as the authentication process. Once your identity is verified, you will be given the 'green light' or authorization to use the resource.
Although many of us use the Internet daily, have you ever wondered how it really works? When we contrast the Internet with subject databases, we can get a clearer picture of how they both work. Subject databases are orderly. The databases contain records, which then contain fields. The Internet lacks this kind of structure. Tools such as Internet spiders crawl the web to gather the information for search engines. In addition, subject database are known for their quality information because, in a subject database, all of the information has been specifically selected. In fact, only published books and articles are included. On the Internet, anyone can self-publish.
Cost is another difference. While most Internet searching appears to be free, the Internet often relies on advertisements for revenue, which could create biases. Although there are many disadvantages to using the Internet for research, limiting by file type is invaluable, especially for keeping current in your field. With a few keystrokes, you can bring up presentations and videos.
Many steps and planning go into creating a subject database. After identifying the need for a database, the content and audience are determined. Then the best format for the information is decided, along with planning the user interface. One of the last steps is to make the authentication process so that people can do research in their pajamas, even at 2 a.m.
As part of the subject database design, a query processor is set up. The query processor helps the searcher have the best experience they can by providing alternative spellings and related terms. The query processor might also save the search so that when it's asked again, the search will run more quickly.
As you can see, many decisions go into setting up a subject database. Selecting the right type of database model is an important decision. Each model has a unique strength. Flat databases are one-dimensional and are best for plain text information. Objects are represented in an object-orientated model, rather than text. In a hierarchical model, the database relationship is not one-to-one. This is a very old-fashioned model that was used in first generation computers. A network model is complex but difficult to keep current. The best database model for a subject database is the relational model, since all the different components must interact.
A subject database is a collection of specialized information with a narrow focus and is a research tool that can save you both time and money. Through libraries you can access a world of subject databases on every topic, including bibliographic databases that contain information and references to library materials, such as books and articles. Many of the bibliographic databases feature a controlled vocabulary, an indexed list of specialized terminology, which is another way to target your searches. The good news is that most, if not all, subject databases are available to use from any location, through an authentication process. To make sure that you have the best search experience, a relational database model should be used.
To unlock this lesson you must be a Study.com Member.
Create your account
Already a member? Log InBack
Did you know… We have over 160 college courses that prepare you to earn credit by exam that is accepted by over 1,500 colleges and universities. You can test out of the first two years of college and save thousands off your degree. Anyone can earn credit-by-exam regardless of age or education level.
To learn more, visit our Earning Credit Page
Not sure what college you want to attend yet? Study.com has thousands of articles about every imaginable degree, area of study and career path that can help you find the school that's right for you.
Back To CourseRelational Databases Tutorial
10 chapters | 112 lessons
Next LessonDesign for Databases & SQL