Monday, April 20, 2015

Database Location Decisions-When to share a database location between college programs.

One of the more difficult decisions to be made when deploying AccuSQL across a campus or when adding entities to an existing system is whether or not to place all entities on one database or give some, or all of them separate databases. The general criteria used to come to the best decision is often based on the following:

·         How often entities would be able to make good use of tracking data collected by other entities.
·         The level of sensitivity of the tracking data collected within an entity.
·         How the management of several databases impacts the technical staff charged with their maintenance.
·         The funding sources for each entity.
·         The scope of reporting needs for both the individual entities as well as the institution.


Based on the above criteria, the types of entities most often placed on a separate database include grant funded programs, student behavioral or health related programs, disabilities services and programs where there is no need to store all students on the student table. Types of entities that almost always share a database include student affairs departments (advising, financial aid, registration, new student orientation), student life, housing, fitness locations, honors programs, and student support programs (tutoring, mentoring, supplemental instruction). Using this criteria should result in the ability of the separated entities to report more easily to their outside funding source while the entities sharing a database location can leverage cooperation between themselves for the sake of student success. The more entities share databases, the more institution wide reporting will have the ability to address a student’s usage of resources from the moment the student registers for a new student orientation onward to when the student graduates. Institutional reporting becomes more comprehensive the more campus entities use a shared database.

Here is a list of pros and cons to consider when deciding if your department/program should have a separate database location:

Pros of a Separate Database
§  Avoids commingling student records between services offered by different funding sources.
§  Allows the program to use the unique student profile to pre-qualify prospective participants when services are offered only to eligible students.
§  Allows the program to project participation rates by tracking recruiting processes.
§  Safeguarding of sensitive records.
§  Easier report creation as filters for non-participants are not needed.

Cons of a Separate Database
§  Technical support will have to repeat updates and imports for the separate database.
§  Usage of other campus resources by participants will not be viewable in the separate database.
§  Campus partners will not be able to view usage of resources by participants in the separate database.
§  Resources available elsewhere on campus will not be included in the Individual Educational Action items for users in the separate database.
§  Individual Educational action items assigned by other programs and departments will not be viewable by users in the separate database.
§ Institutional reporting will be not be seamless and will have more opportunity for duplication issues.



26 comments:

  1. The maintainace of the location sharing program and the updates to be done are the bad things that can happen. Well there are many advantages to be kept in mind.

    ReplyDelete
  2. This comment has been removed by the author.

    ReplyDelete
  3. This is really a big and great source of information. We can all contribute and benefit from reading as well as gaining knowledge from this content just amazing
    experience Thanks for sharing such a nice information.

    DedicatedHosting4u.com

    ReplyDelete
  4. Thanks for sharing nice information with us. I like your post and all you share with us is up to date and quite informative,

    Thanks
    Cpa offers

    ReplyDelete
  5. Nice blog. OGEN Infosystem is leading Web Designing Company in Delhi, India, visit our website for web designing and SEO Services.
    Website Design Company

    ReplyDelete
  6. It’s great to have the opportunity to read a good quality article with useful information on topics of interest. I agree with your conclusion. I am waiting for your future updates.
    Get Information Accounting Homework Done
    Macroeconomics Homework Help

    ReplyDelete
  7. I think this is an informative post and it is very useful and knowledgeable. therefore, I would like to thank you for the efforts you have made in writing this article.Graphic Designing Australia

    ReplyDelete
  8. The content you have posted in the above post contains some useful knowledge which is essential for all. You are doing such a great work by providing some useful posts. You can Hire Freelance Logo Designers at talentsroot.

    ReplyDelete
  9. Thanks for sharing this, I actually appreciate you taking the time to share with everybody.
    Best Institute For Data Science In Hyderabad

    ReplyDelete
  10. Nice Information Your first-class knowledge of this great job can become a suitable foundation for these people. I did some research on the subject and found that almost everyone will agree with your blog.
    Cyber Security Course in Bangalore

    ReplyDelete
  11. Writing in style and getting good compliments on the article is hard enough, to be honest, but you did it so calmly and with such a great feeling and got the job done. This item is owned with style and I give it a nice compliment. Better!
    Cyber Security Training in Bangalore

    ReplyDelete
  12. Really nice and interesting blog information shared was valuable and enjoyed reading this one. Keep posting. Thanks for sharing.
    Data Science Training in Hyderabad

    ReplyDelete
  13. Great article with fantastic information found useful and unique content enjoyed reading it thank you, looking forward for next blog.
    typeerror nonetype object is not subscriptable

    ReplyDelete
  14. I have to search sites with relevant information ,This is a
    wonderful blog,These type of blog keeps the users interest in
    the website, i am impressed. thank you.
    Data Science Course in Bangalore

    ReplyDelete
  15. I have to search sites with relevant information ,This is a
    wonderful blog,These type of blog keeps the users interest in
    the website, i am impressed. thank you.
    Data Science Training in Bangalore

    ReplyDelete
  16. You can comment on the blog ordering system. You should discuss, it's splendid. Auditing your blog would increase the number of visitors. I was very happy to find this site. Thank you...

    Business Analytics Course in Bangalore

    ReplyDelete
  17. I really enjoy reading all of your blogs. I just wanted to let you know that you have people like me who appreciate your work. Definitely a great article. Congratulations! The information you have provided is very helpful.

    Data Analytics Course in Bangalore

    ReplyDelete
  18. I really appreciate your blog for such content database management system is very useful. nowadays database management is also using in best hospitals in india

    ReplyDelete
  19. I am glad to discover this page. I have to thank you for the time I spent on this especially great reading !! I really liked each part and also bookmarked you for new information on your site.
    Data Science Course in India

    ReplyDelete
  20. This blog is truly one of the best with unique information found valuable and resourceful.Very good work thank you.
    Data Scientist Training in Hyderabad

    ReplyDelete
  21. I want to thank you for your efforts in writing this article. I look forward to the same best job from you in the future.

    Business Analytics Course in Bangalore

    ReplyDelete