Wednesday, April 28, 2010

Link to Genomic Database presentation

Genomic Database Link

Project and Class Tonight

An exciting night...the reveal of your projects. I'm looking forward to seeing the results. Christine Huyber from the Biomechnics Lab will be visiting as we discussed to tell you a little more about their lab and get a first look at your results. See you all soon.

Link to Mobile Database Presentation

Mobile database link

Sunday, April 25, 2010

Condition table question

We have a question about the Condition table. We noticed that in the old "spreadsheet" version of the data, there are 8 Condition columns. Which of the following does this mean?
1. A patient can have multiple conditions simultaneously
2. A patient can have one condition at a time and we are simply keeping track of the history

We just wanted to clear this up because it doesn't really make sense for a patient to for example be both "stable" and "critical" at the same time.

If it is option 2, should we have functionality in the UI to see a history of conditions with an associated date for each patient? Or leave this for future work?

Wednesday, April 21, 2010

Mayo Project Development

http://cs.winona.edu/faculty/nanderson/485-s10/UIAssignment4.pdf

Multimedia Databases Questions

1. What is MARS?
- Multimedia Analysis and Retrieval System

2. What are the two retrieval models in MARS?
- Fuzzy Boolean Retrieval
- Probabilistic Boolean Retrieval

3. What are the two levels of normalization in MARS?
- Intra-feature Normalization
- Inter-feature Normalization

4. What are the possible uses of MARS?
- Government and commercial use of sensing images
- Digital libraries
- Medical databases
- Special purpose databases

5. What is MOQL based off of?
- Object Query Language

Genomic Database Questions

  • What is a gene and what is it made of?
  • What is computational biology?
  • What does NCBI stand for and what main genomic database does it contain?
  • What does BLAST stand for and what does it do?
  • What is Entrez?
  • What are the two things you can search GenBank for?

Tuesday, April 20, 2010

Geographical Information Systems

Questions

  1. Name one real world use for a GIS (Geographical Information System)?
  2. What is the difference between vector and raster data?
  3. Each layer of Geographical data must be accurately placed according to their .
  4. Name one method for acquiring Geographical data.
  5. What is the standards organization for GIS (Geographical Information System)?
    1. Globally Open Geography
    2. Open Geospatial Consortium
    3. Open Geographical Standards
    4. Association for Global systems standards

Sunday, April 18, 2010

Mayo Group projects still needed

I am missing one of the group projects. We need this in order to fulfill our group assignment as well as providing feedback to each group about their instructions and their UI.

Wednesday, April 14, 2010

This Week's Mayo Project

http://cs.winona.edu/faculty/nanderson/485-s10/UIAssignment3.pdf
Virtualization Questions

What is Virtualization?
What are the main advantages to virtualization?
Where did virtualization get its start?
What are some of the drawbacks?
What is database virtualization?
Why is it useful?

Distributed Database questions

Sorry for posting this a little late.

Questions:

What are three advantages of distributed database systems?

What are two disadvantages of distributed database systems?

Describe one kind of concurrency anomaly.

Why can’t you use traditional load balancers for database servers?

Why is maintaining integrity difficult in distributed databases?

What is two-phase commit in a distributed database management system?

Search Engine

Questions:

1) What are spiders and what do they do in web crawling search engines?

2) How does indexing determine if something is more important than something else?

3) What are Meta Tags?

4) What is advantage of Turbo10?

5) What are the components of On2broker?

Friday, April 9, 2010

Mayo Project Question

We were wondering how big is the database going to be. Are we talking about hundreds, thousands or ten thousands of patients?

Wednesday, April 7, 2010

Homework 8

http://cs.winona.edu/faculty/nanderson/485-s10/UIAssignment2.pdf

ER Diagram



Here is the current ER Diagram with referringMD at patient. If anybody sees anything I forgot let me know and I'll fix it.

Saturday, April 3, 2010

Mobile Database Presentation Questions

Please note the questions below have changed as of 4/11/2010 at 8:30 pm cst ~~*~~

1. What is a femtocell?


2. The acronym PEIR stands for what environment report.

3. What are the three parties that mobile databases typically involve?

4. When it comes to mobile databases, users don't require access to truly live data.  What type of data do they truly need access to?

5. Name two possible Mobile database problems.

Thursday, April 1, 2010

mySQL server setup tips

To "make the connection" between mySQL and Razor you need to download mySQL server (I am using 5.5) and install it. Configure your instance of MySQL using the menu option (in the start menu under MySQL, MySQL server 5.5, Server Instance Config Wizard.

Here are some oif the options I used:
Detailed configuration
Developer Machine
Non-Transactional Database Only
Manual Setting
Concurrent connections: 15
Enable TCP/IP Networking
Port Number 3306
Enable Strict Mode
Standard Character Set
Check Include Bin Directory in Windows PATH
****This next step is important***
Modify Security Settings
Current root password:  - this should be left blank
New root password:  if you wish to set a password for the "root" user ID enter it here
Confirm: Re-enter the password if you entered a new root password
Execute - Make sure the Start Service on this steps completes successfully

Once this is done you can install razor and make the connection to the MySQL server instance you just configured.

Homework 7

http://cs.winona.edu/faculty/nanderson/485-s10/UIAssignment.pdf

EDI presentation

Here is my presentation on Electronic Data Interchange:

http://docs.google.com/leaf?id=0BxSOK3LMFV4bNGU2NTMxZjctMjFkNS00MzJhLWEyMzMtNmM2NWEyZWE2MDY5&hl=en

Data Compression Presentation

Here is the data compression powerpoint:

http://docs.google.com/leaf?id=0B-Z0srsHOylXMTAzNzdjODctMWMwZC00MmQ3LTg3YTEtMmVjNDdlODI5MDBl&hl=en