Parallel Query Processing

1. What are the advantages of Parallel Query Processing?
2. What are the main system criteria for Parallel Query Processing?
3. When shouldn't you implement Parallel Query Processing?
4. What needs to be considered for determining the degree of parallelism in oracle server?
5. What is data skew?
6. What is done during the parallelization step in parallel query execution?

Distributed Database Questions

1.  How does the distribution of data across multiple databases effect the normalization process?
2.  What is a distributed database system?
3.  What are the advantages and disadvantages of distributed databases?
4.  What is concurrency control in relation to a distributed database system?
5.  What is/are the main differences between distributed databases and non-distributed databases?

Data Grid Questions

What are the three challenges data grids must overcome?

What are some examples of cloud computing platforms?

What does the map() function do?

What does the reduce() function do?

What are the problems with conventional relational databases in grid computing?

What is required of the data in order to parallelize processing?

Project Submission

There was an error in the original document posted on the project submission. Please re-download this document to make sure you have the correct version.

Congrats 495 Students

Congratulations to the 495 students on such great research this semester. I hope those of you that attended enjoyed the presentations. Some very interesting work.

Final Project Submission

Final project submission information is available at:
http://cs.winona.edu/faculty/nanderson/485/FinalProjectSubmission.doc

Please note that this is due by 8AM next Monday and that no late work will be accepted for the final project. Of course, earlier submission is encouraged.

Rochester CS Club Meeting

The CS club here in Rochester will be meeting at 3:00pm on Monday May 4th in SH 101. There will be officer elections and pizza. If you are interested in being involved in the club next year, please be there.

Is MySQL dead?

Here are some thoughts on the Oracle/Sun deal: http://blogs.zdnet.com/BTL/?p=16598

Database is #2

Here is an article talking about the IT skills in highest demand right now:
http://www.networkworld.com/news/2009/040609-10-tech-skills.html?tc=car

Search Engine Questions

How does a search engine work?

What does it mean to parse a website when searching?

What data is stored by the search engine?

What is a metasearch and how does it work?

What does Search Engine Optimization do?

Homework 9

Homework 9 is available at:
http://cs.winona.edu/faculty/nanderson/485/Homework9.doc

Multimedia database questions

1. What is a multimedia database

2. Why use compression in a multimedia database

3. What are the two types of multimedia databases

4. What are the three layers for a multimedia database architecture

5. Name the three types of multimedia data queries

DataMining Pres Questions...

Q) What is data mining?

Q) What hardware does data mining require?

Q) What is Genomic Databases used to find?

Q) What is an algorithm used in Genomic Databases?

Q) What is an ethical issue with data mining

Q) What is a solution to ethical problems of data mining on the net?

Questions for Compression

Questions:

1. Briefly describe some of the core terms in compression.
2. What is the difference between lossy and lossless compression.
3. Huffman encoding chooses new bit representations for data, how does it assign the new representations?
4. Name and briefly describe an audio compression technique.
5. Name one of the modes of JPEG and describe it.
6. List some of the features brought by MPEG-2 over MPEG-1.
7. Describe the main concept introduced by MPEG-4.
8. What are some of the advantages of leaving data compressed in a database?

Mobile Database Management

1.Define some of the requirements of mobile database management

2.What are some of the limitations of the mobile database management

3.List  some of the key applications of mobile databases management

4.What are some of the major database vendors offering these products

5.Type of mobile database architecture that are available

Note to Those Giving Presentations

If you are giving a presentation today, please don't forget to post your questions ASAP.

Homework 8

Available at:
http://cs.winona.edu/faculty/nanderson/485/Homework8.doc

Homework 7

Available at:
http://cs.winona.edu/faculty/nanderson/485/Homework7.doc

Questions for Today's Presentation

1. What is EDI?
2. Why use it?
3. How does it work?
4. What does it take to implement?
5. Who is using it?

What are the advantages of adding tiers?
Why does tiered architecture provide coupling, portability, and code-reuse?
What are the disadvantages of adding tiers?
What are the jobs of each tier?
What are the benefits of using a database in a multi-tiered architecture (vs. files)?

Questions for Tiered Software Presentation. Apr 1.

Research Questions

You all should have submitted 5-7 questions, with answers, that you will address during your presentation as part of homework 5. Before you presentation, please post those questions (without answers) to the blog so other students can use them for note taking.

Test2 + Final Exam Schedule

What is the schedule for Test2 and the Final Exam?

Homework 6

Available at:
http://cs.winona.edu/faculty/nanderson/485/Homework6.doc

Homework 5

Available at:
http://cs.winona.edu/faculty/nanderson/485/Homework5.doc

Presentation Date Sign-Up

The following presentation dates are available:
April 1, 8, 15, and 22

Please respond with a comment giving:
1. Your selected date
2. Group name and presentation title

A maximum of 3 groups may sign up per day. Once three groups have selected a date, you must select a different one. This will happen on a first-come-first-served basis.

HW4 Correct Solution for Use on Take Home Exam

A simple but complete student solution to homework 4 is available today at:
http://cs.winona.edu/faculty/nanderson/485/FastFoodOrder.java

Tomorrow

Just a reminder that our exam is tomorrow. I will be in Rochester tomorrow for office hours and class. A proctor will be in Winona to administer the exam there.

Research Presentations

Is there an overall time line for these presentations in one document somewhere? For example, when are the outlines tentatively going to be due? When are presentations actually happening? When do we get to choose dates? What are all of the deliverables for this assignment and tentative due dates? How many milestones and what will they consist of?

I'm sure some of this has been discussed, but it would be nice to see it in writing somewhere that can be easily accessed.

Thanks.

Midterm 1 Review

Available at:
http://cs.winona.edu/faculty/nanderson/485/Midterm1Review.doc

Autoincrement

As some of you may know, Firebird does not offer autoincrement like MySQL. For Firebird you must use generators, which is Firebird-speak for sequences. I'll post some code later. Or if anyone else has some code to post, feel free.

Table named order

Just a piece of advice.
Im not sure how firebird deals with this but i am using mySQL with phpMyAdmin and if anyone is having trouble getting the itemID in the order table to references it in the menuItem table it is because ORDER is a reserved word. You are going to have to change the name of the table to something else.

HW #4 Discussion

I'm working on HW #4 and just want to see if I am on the right track.

The first part of the HW says to create schema's for

menuItem(id, name, description, cost);
order(id, ordernum, itemid);

Now, I'm taking this to mean create 2 tables named 'menuItem' and 'order' with the following columns and given primary keys 'id.'

Am I on the right track?

Other folks may use this thread for hw #4 discussion as well : )

Homework Frustration

Based on conversation with other students, I don't think I'm the only one who came out of the go_team and webwork database assignments feeling frustrated and bewildered. I'm curious to know what the learning objectives were for those projects because I'm pretty sure I missed them. I pretty much felt like I was blindly guessing at what someone else was doing. I really don't know what skills I may have developed during the process.

Any feedback from other students?

JDBC Example from Class

Available at:
http://cs.winona.edu/faculty/nanderson/485/JDBCGettingStarted.java

Homework 4

Homework 4 is available at:
http://cs.winona.edu/faculty/nanderson/485/Homework4.doc

Distributed Database Research

Hello, I need a partner. I was wondering if anyone would be interested in doing research into distributed databases.  I am interested in doing a brief overview of distributed databases. Then describing distributed databases with an emphasis on performance. Also a section on how to best create applications that can properly interface with distributed database systems, and how this application should be different due to the distribution of data.  A section on how distributed database design is effected by this distribution of data; namely the effects it has on normalization.  Since normalization in theory is good but in practical situations it may not be best. This section could describe denormalization of a database, what it is for, and when it is needed.    If anyone wants to be my partner just let me know!  If you have any other ideas let me know too, I am open to any modifications of these ideas.

Research Partner

Is anyone in Winona need Research Partner?? Please let me know. Thank you~!!

JDBC driver

Here is a link to the JDBC driver to use for mySQL. You have to extract it and put the .jar file in your folder ...java/jre1.6(whatever version you have)/lib/ext

Here is a really good tutorial on learning how to get started using JDBC for mySQL
http://www.developer.com/java/data/article.php/3417381

Research Partner Wanted

Is anyone in Winona interested in doing "Genomic Databases" for the project?

Research Presentation

Below is a link to information on the research presentation for this course. The first milestone (selecting a topic and writing a statement on your topic) is due in one week.

http://cs.winona.edu/faculty/nanderson/485/ResearchPresentation.doc

Firebird Multiset or Array???

Does anyone know how Firebird uses MULTISET or ARRAY datatypes? I can't find anything...

Homework 1

Have you sent back the homework 1 assignments? If so, what email did you send them to?

Rochester Room Change

Due to the less than ideal set up of the Rochester room, I requested a room change and was able to get ST114. This will be the new classroom in Rochester for the rest of the semester.

Some Links

General Info for Firebird:
http://www.firebirdsql.org/refdocs/langrefupd20.html

General Info for MySQL:
http://dev.mysql.com/doc/refman/5.1/en/index.html

Trigger Info for Firebird:
http://www.firebirdsql.org/refdocs/langrefupd20-create-trigger.html

Trigger Info for MySQL:
http://dev.mysql.com/doc/refman/5.1/en/trigger-syntax.html

Homework 3

Homework 3 is available at:
http://cs.winona.edu/faculty/nanderson/485/Homework3.doc

FlameRobin

Here is the link to FlameRobin's website.

Homework Submission

Due to the two campus issue, electronic-only submission will be fine for homework 2 and future homework assignments unless otherwise noted. Logistics make hard copy submissions difficult. Feel free to submit a hardcopy if you would like additional feedback on your homework.

Tomorrow's Class

Just a reminder that I will be in Rochester tomorrow for class. During office hours Winona students may reach me by posting here on the blog (recommended, especially if he question may apply to others), via email, or on the phone.

Homework 2 Modification

On homework 2, for question 1 you can skip the portion of the question that asks you to add the list of 4 rows to the table and identify whether they work correctly. It is not very interesting to do this without having some data previously in the table. We will discuss this more in class.

Questions?

The blog is very quiet. How is homework 2 going?

Some students have noticed that the syntax we used in class for examples does not match their DBMS. You will find this frequently, as different DBMS's have different syntax, especially as we get into some of the more complex features of database systems. You will have to tweak things to match your system.

Homework 2

Homework 2 is available at:
http://cs.winona.edu/faculty/nanderson/485/Homework2.doc

Homework 1 Submission

Please submit your first homework via email and bring a hard copy to class. The subject line of your email should be:
CS485 HW1 submission your name

Question Regarding Assignment 1

For this assignment, are we allowed to work in groups?

MSDNAA Info

Some of you have asked about how to download the Visio software. You can get this as well as a lot of other software for free through the MSDNAA for educational use.

There are two ways to get a hold of MSDNAA software. One is to login here: http://msdn06.e-academy.com/elms/Storefront/Home.aspx?campus=wsu_csc. The most software (including Visio, Microsoft Access, etc) is available this way. At the beginning of the semester, you should have been emailed your login info. If you can't find this, enter your email address and click on the password reminder link to get it sent again.

However, the easier method is to grab the software you need out of the folders provided by the CS department. This only works on campus or using a VPN to campus at home. The path is then: \\csci\msdnaa$. However, only selected software is available here. You might want to check here first, then go to the master source if what you are looking for isn't available.

Homework 1

Homework 1 is available at:
http://cs.winona.edu/faculty/nanderson/485/Homework1.doc

Please post any questions you have here, on the blog.

ER Diagram Stencil for Visual Studio

Ben created this nifty stencil for Visio in last semester's cs385 class. It makes creating electronic ER diagrams much simpler. Thanks Ben!

http://cs.winona.edu/faculty/nanderson/485/ER_Diagram.vss

Computer Science Student Resource Site

Chi suggested this site in our algorithms class. There is a lot of good stuff to be had.

Check it out here: http://williamstallings.com/StudentSupport.html

Syllabus

The course syllabus is available at:
http://cs.winona.edu/faculty/nanderson/485/CS485_Syllabus.doc

Welcome

Welcome to the course blog for CS485, Advanced Database System. This will be a useful medium for distribution of course materials and schedule information, but even more importantly it will be an area for discussion and collaboration among students. This is the place to post any questions you have about the course and course materials.