Week 11: DBMS and its advantages

Database management system

A database management system (DBMS) is a software package with computer programs that control the creation, maintenance, and use of a database. It allows organizations to conveniently develop databases for various applications by database administrators (DBAs) and other specialists. A database is an integrated collection of data records, files, and other objects. A DBMS allows different user application programs to concurrently access the same database. DBMSs may use a variety of database models, such as the relational model or object model, to conveniently describe and support applications. It typically supports query languages, which are in fact high-level programming languages, dedicated database languages that considerably simplify writing database application programs. Database languages also simplify the database organization as well as retrieving and presenting information from it. A DBMS provides facilities for controlling data access, enforcing data integrity, managing concurrency control, and recovering the database after failures and restoring it from backup files, as well as maintaining database security.

Reference:

http://en.wikipedia.org/wiki/Database_management_system

ADVANTAGES OF DBMS

The DBMS (Database Management System) is preferred ever the conventional file processing system due to the following advantages:

1.Controlling Data Redundance

Avoid duplication of same data in different files and wastage of storage space. Reduce the time to keep the same data.

2. Elimination of Inconsistency

Remove the duplication of data in multiple file to eliminate inconsistency.

3. Better service to the users

Centralizing the data in the database so that user can obtain new and combined information easily .

4. Flexibility of the System is Improved

Changes are made more easily in a centralized database

5. Integrity can be improved

DBMS used by a number of users at a time. It is essential to enforce integrity-constraints.

6. Standards can be enforced

Standardizing stored data formats is usually desirable for the purpose of data inter¬change or migration between systems.

7. Security can be improved

Different checks can be established for each type of access (retrieve, modify, delete etc.) to each piece of information in the database.

8. Organization's requirement can be identified

It is the responsibility of the DBA (Database Administrator) to structure the database system to provide the overall service that is best for an organization.

9. Overall cost of developing and maintaining systems is lower

It is much easier to re¬spond to unanticipated requests when data is centralized in a database . The cost of  developing and maintaining DBMS application programs to be far lower than for similar service using conventional systems.

10. Data Model must be developed

Perhaps the most important advantage of setting up of database system is the requirement that an overall data model for an organization be build.

11. Provides backup and Recovery

Centralizing a database provides the schemes such as recovery and backups from the failures including disk crash, power failures, software errors which may help the database to recover from the inconsistent state.

Reference:

http://dbmsbasics.blogspot.com/2008/05/advantages-of-dbms.html

Week 10: Cataloguing of Non-Book Materials

Some of the example of the non book materials are like:

a.        Sound recordings

b.       Video recordings

c.        Cartographic materials

The general information the contain in non –book materials are:

a.        Title and statement of responsibility:

·                     Transcribe only statements of responsibility that relate to the intellectual content of the work

b.       Publication information:

·                     Date of publication:

c.        Physical description:

·                     Extent of item

·                     Give the playing time of the recording as stated:

·                     Dimensions:

d.       Notes

·                     Nature of performance

·                     Source of title proper

·                     Edition and history

·                     Publishers’ numbers

·                     Contents

·                     Summary

The example of term of non-book materials

VHS tapes           videocassette

DVCam tapes     videocassette

DVDs     videodisc

Laser discs           videodisc

VCDs     videodisc

floppy disk          computer disk

CD-ROM              computer optical disc

DVD-ROM           computer optical disc

CD(music or spoken)      sound disc

cassette tapes sound cassette

Reference :

http://www.dartmouth.edu/~library/catmet/procedures/books/bks-w-nonbk.html

http://www.neoslibraries.ca/document/Tech/CatNon-Book.pdf

Week 9: Short Review of DBMS- Scopus

Short review on Data Base Management System in UTM : Scopus

a.    Features of the system

Features and functionality designed to support and improve researchers’ workflow, including:

• A simple and intuitive interface.
• Linking to full-text articles and other library resources.
• Author Identifier to automatically match an author’s published research including the h-index.
• Citation Tracker to simply find, check and track citations in real-time.
• Affiliation Identifier to automatically identify and match an organization with all its research output.
• Journal Analyzer provides a quick insight into journal performance.
• Alerts, RSS and HTML feeds to stay up-to-date.
• Document Download Manager to easily download and organize multiple full-text articles simultaneously.
• Interoperability with SciVerse ScienceDirect, Reaxis and ProQuest’s CSA Illumina.
• Data export via bibiliographic managers such as RefWorks, EndNote and BibTeX.

b.    How system can help UTM to effectively manage the date and information of staff or students?

Using Scopus as a researcher you can:

• Find out who is citing you, and how many citations an article or an author has received.
• Analyze citations for a particular journal issue, volume or year.
• Use this information to complete grant or other applications quickly and easily.
• Use the refine results overview to quickly see the main journals, disciplines and authors that publish in your area of interest.
• Uncover important and relevant articles that you may otherwise miss.
• Check out the work and citations of other authors.
• Click on the cited by and reference links to track research trends and make connections. You can do this within or across disciplines you are interested in.

Using Scopus as an editor you can:

• Find and evaluate referees and authors for review papers and thematic issues.
• Identify and contact potential editorial board members.
• Monitor journal trends, for example by comparing the current aims and scope of a journal with citation patterns to see if a shift has occurred.
• Review the performance and coverage of new journals quickly, and at your desktop without waiting for them to be indexed in other databases. New journals are covered and citation links created to and from them on a regular basis.

Using Scopus as a librarian you can:

• Offer an easy-to-use, reliable abstract and citation database to your users.
• Link your users quickly and accurately to the full-text articles you've invested in.
• Increase the visibility of and access to other library resources.
• Ensure your users search peer-reviewed, indexed content.
• Analyze highly-cited articles to inform your collection management decisions.

c.    Disadvantages of the system

1.    Overlap issue

·         Meho & Yang (2007) conducted a large-scale comparison between Web of Science, Scopus (Elsevier’s alternative to Thomson ISI’s Web of Science) and Google Scholar covering citations of over 1,000 scholarly works of all 15 faculty members of the School of Library and Information Science at Indiana University Bloomington between 1996 and 2005.

·         The overlap between Web of Science and Scopus was 58.2%.

·         The overlap between Google Scholar and the union of Web of Science and Scopus was only 30.8%.

·         Google Scholar produced more than twice as many citations as Web of Science and nearly twice as many citations as Scopus.

2.    Unique citations

·         Meho & Yang (2007) conclude that Google Scholar can help identify a significant number of unique citations. These unique citations might not significantly alter one’s citation ranking in comparison to other academics in the same field and might not all be of the same quality as those found in the Web of Science or Scopus.

Reference :

http://www.info.sciverse.com/Home

http://www.harzing.com/pop_gs.htm

Week 9: Number building

Only a fraction of potential DDC numbers are included in the schedules. It is often necessary to build or synthesize a number that is not specifically listed in the schedules. Such built numbers allow for greater depth of content analysis. There are four sources of notation for building numbers:
(A) Table 1 Standard Subdivisions;
(B) Tables 2–6;
(C) other parts of the schedules; and
(D) add tables in the schedules.
Number building is initiated only upon instructions in the schedules (except for the addition of standard subdivisions, which may take place anywhere unless there is an instruction to the contrary). Number building begins with a base number (always stated in the instruction note) to which another number is added.

Week 8: Example of cataloging non-book materials

CD-ROM 1

Mathematics year 3 : length [CD-ROM].

         Kuala Lumpur: Bahangian Teknologi Pendidikan, 2004.

­­­­­­­­­­­­­­­­ 1 CD-ROM ;

Suitable for year three pupils based on Mathematics year three syllabus.

System requirements are windows 95 or higher and at least 16MB RAM.

1. Mathematics. 2. Length.

CD-ROM 2

Science form 2: lever [CD-ROM].

         Kuala Lumpur: Bahangian Teknologi Pendidikan, 2003.

­­­­­­­­­­­­­­­­ 1 CD-ROM ;

Suitable for form 3 student.

System requirements are pentium windows 95 or upper

At least 16MB RAM or more.

1. Science. 2. Lever.

CD-ROM 3

Science form 3 : blood circulatory [CD-ROM].

         Kuala Lumpur: Bahangian Teknologi Pendidikan, 2003.

­­­­­­­­­­­­­­­­ 1 CD-ROM ;

About the systemic and pulmonary blood circulatory system.

Minimum system requirements are Pentium, Windows 95 or upper and at least 16MB RAM.

1. Science. 2. Blood Circulatory System.

Week 8: Example of materials in seriels and other non-books materials

Hi classmates.
Kindly download the note for Week 8 : materials in seriels and non-book materials.

Week 7: Example of number building

BOOK 1

728.09595

 WAN

Wan Hashimah Wan Ismail.

House in malaysia: fusion of the east and west/ Wan Hashimah Wan Ismail.-Skudai: Universiti Teknologi Malaysia, 2005.

            xvii,  84p.: ill. ; 25cm.

Includes index.

Bibliography: p.85-87
ISBN 983-52-0362-8

1. Dwellings--Malaysia--Designs and plans.  2.Architecture, Malay.  3. Architecture, Chinese.  4. Architecture and state—Malaysia.

             I. Title.

09 Geographical Treatment

595 Malaysia

BOOK 2
     

910.285

TAH

Taher Buyong.
         Spatial statistic for geographic information science/ Taher Buyong.-Skudai: University Teknologi Malaysia,2006.

­­­­­­­­­­­­­­­­ xi,  296p.: ill. ; 26cm.

         Includes index.
         Bibliography: p.267
         ISBN 983-52-0393-8

        1. Geographic information system--statistical methods. 2. Spatial analysis (statistics).
        I. Title. 

285 Data Processing Computer Application

BOOK 3

363.6809595

JAM

Jamil Abu Bakar.
         A design guide of public parks in malaysia/Jamil Abu Bakar.-Skudai: University Teknologi Malaysia, 2002.
     

xii, 144p.: ill. ; 25cm.

         Includes index.
         Bibliography: p.129-134
         ISBN 983-52-0274-5

        1. Parks-Malaysia-Designs and plans. 2. National parks and reserves-Malaysia-Designs  

and plans.
 I. Title.

0.68 Park and recreation services

09  Geographical Treatment

595 Malaysia