Oregon Department of Education

Getting Started - An Overview of the OSS Database


Our initial challenge was to merge the information we had into an enterprise database that could relate the different groupings together.

SAMPLE DATABASE

This simple example should provide some insight re: how we grouped our data.
  • GROUP 1 - Let’s say that we wanted to group PRACTICAL THINGS used by people everyday. We would first create a primary first level group.

    We could identify major areas, such as Food, Shelter, Jobs, Recreation. For this example we will select Food.

    First Level (category): FOOD

  • GROUP 2 - Next we would indentify groupings found under the food category, such as Milk, Meat, and Fruit. For this example we will choose FRUIT.

    Second Level (category): FRUIT

  • GROUP 3 - Next we would indentify groupings found under the fruit category, such as Grapes, Apples, Bananas. For this example we will choose GRAPES.

    Third Level (category): GRAPES

  • Details - Beneath the bottom level we would store various types of information related to grapes, such as planting, harvesting, packaging, and sales.

OREGON SKILL SETS DATABASE

The simple example above relates to the OSS data as follows:
  • GROUP 1 - We wanted to gather information related to CAREERS. We started by creating a first level group called Career Learning Areas.

    We identified major career learning areas such as Agriculture, Business, and Health. For this example we will select Business.

    First Level (Career Learning Area): BUSINESS

  • GROUP 2 - The next level of grouped information is called Clusters. We identified groupings found under the business cluster, such as Business Management, Finance, and Marketing. For this example we will choose the Marketing cluster.

    Second Level (Cluster): MARKETING

  • GROUP 3 - The next level of grouped information is called Focus Areas. We identified groupings found under the marketing focus area, such as Buying and Merchandising, E-Marketing, and Promotion. For this example we will choose E-Marketing.

    Third Level (Focus Area): E-Marketing

  • Details - Beneath the bottom level we stored various types of information related to E-Marketing, such as what you would need to know (Knowledge and Skill Sets), possible occupations, and types of High School and Community College programs that would be related to E-Marketing.

CONCLUSION

These information groups were put into an enterprise database (the Oregon Skill Sets database) and we created three primary searches that enable our visitors to find and view information in different ways.

SEARCHING THE OSS DATABASE

Which search method will give you the results you are searching for?

OSS SEARCH CHART

Career Areas Career Areas Quick ViewQuick View Super SearchSuper Search
Displays a detailed description of CLA, Cluster, and Focus AreaXX 
Displays related News and EventsX  
Displays video links directly on page without searchingX  
Displays links to videos by searching  X
Displays related external links and other additional resourcesX  
Displays occupations related to Focus Areas directly on the page X 
Displays occupations that match your key word search  X
Displays all programs related to Focus Areas directly on the page X 
Displays programs matching your key word search  X
Allows searching of all OSS misc links  X
Allows selection of any/all areas to search  X
All clicking, no typingXX 
Enables an XML export of your filtered search XX
Contains links to external sitesX X



Contacts
  • Ron Dodge Email    (503) 947-5653
    Secondary/Post-Secondary Transitions - Ed. Specialist, Business & Management