Archive for the ‘relational database’ Category

A few good posts for MySQL and Postgres

Thought I would share a few links that I read this morning. I don’t do a lot of link posts but these three came off my RSS, one after the other, and all three are worth sharing.

The first is Will Oracle kill MySQL? Come on people! I can’t believe people are still stuck on this FUD. Ronald gives some good reasons why that is not likely. The only thing this kind of FUD really does is drive people to Postgres (and that postgres derivative that starts with an E and ends with a DB). ;-) I’m glad Ronald was able to set the record straight.

Click to continue reading “A few good posts for MySQL and Postgres”

Read the rest of this entry »

Column-oriented MySQL for VLDB

InfiniDB – Open Source BI/Analytic Database

Recently ran across some blog posts about InfiniDB, a MySQL based DW and BI analytic database from a company called Calpont. I *think* InfiniDB is their only product. I could be wrong about that, though.
There are plenty of things to like about InfiniDB – Multi-threaded and designed for multi-cpu/cores, ACID compliant, recoverable, supports SQL standards and online DDL, MVCC, dynamic data compression, and FREE! What attracted me first though was the open source implementation of the columnar storage. That’s the current biggie on VLDB, think vertica or Oracle’s ExaData.

Click to continue reading “Column-oriented MySQL for VLDB”

Read the rest of this entry »

Cool Tool Of The Week – Open Modelsphere: Open Source Data Modeling

From The Database Geek

I like playing with new tools and software so I thought I would start a new weekly series, Cool Tool of the Week. I will just cover a tool that I have used or discovered that I think is cool. I’m not necessarily endoring it, just giving it a little publicity so that others will know about it and can give it a try.

This week is the open source data modeling tool Open ModelSphere. This Open Source project is available for windows with a GPL license. It was originally known as SilverRun. I used this windows-based CASE tool when I was at Yale.

Click to continue reading “Cool Tool Of The Week – Open Modelsphere: Open Source Data Modeling”

Read the rest of this entry »

Comment by prajit on Learn Oracle – What is Oracle?

First of all, I would like to thank you for sharing this helpful article. I am doing my BSc Computer science(second year). I wanted to know more about oracle.I am thinking of getting a certificate in Oracle course; But I’m confused in which category? I would be happy if you would suggest me something! As i will be learning SQL and database in my third year, so I think it would boost my carrier too. If I’m wrong then pls correct me.

Thank you,

Prajit Nair.

!***! Entry Link:http://it.t

Click to continue reading “Comment by prajit on Learn Oracle – What is Oracle?”

Read the rest of this entry »

Comment by “ishan kumar” on Learn Oracle – What is Oracle?

sir,

I am a second year engineering student with IT branch.

I want to learn oracle upto the best level.Kndly guide me,like how should i start and provide me some good notes.

thankyou sir

!***! Entry Link:http://it.toolbox.com/blogs/oracle-guide/learn-oracle-what-is-oracle-5454!***!

Click to continue reading “Comment by “ishan kumar” on Learn Oracle – What is Oracle?”

Read the rest of this entry »

Comment by krishna on Learn Oracle – What is Oracle?

hi sir,

I am a student. Doing my masters in software engineering.

I want to learn oracle. Can u please help me in learning. LIKE where can i get correct material or notes to learn.

thanking you sir,

Krishna Reddy.Palli

!***! Entry Link:http://it.toolbox.com/blogs/oracle-guide/learn-oracle-what-is-oracle-5454!***!

Click to continue reading “Comment by krishna on Learn Oracle – What is Oracle?”

Read the rest of this entry »

Comment by “raman jotshi” on Learn Oracle – What is Oracle?

thanks for yr article

!***! Entry Link:http://it.toolbox.com/blogs/oracle-guide/learn-oracle-what-is-oracle-5454!***!

Click to continue reading “Comment by “raman jotshi” on Learn Oracle – What is Oracle?”

Read the rest of this entry »

Comment by MADHU on Learn Oracle – What is Oracle?

learn dbms and sql and pl/sql

!***! Entry Link:http://it.toolbox.com/blogs/oracle-guide/learn-oracle-what-is-oracle-5454!***!

Click to continue reading “Comment by MADHU on Learn Oracle – What is Oracle?”

Read the rest of this entry »

Comment by “brain rollas” on Learn Oracle – What is Oracle?

i am new to this site and i am using thgis opportunity to greet all my friends and brothers in here God bless you all. am brain rollas by name and i will like to know about this subject: ORACLE. feel free to email me with more information and explanation. Thanks and God bless.

!***! Entry Link:http://it.toolbox.com/blogs/oracle-guide/learn-oracle-what-is-oracle-5454!***!

Click to continue reading “Comment by “brain rollas” on Learn Oracle – What is Oracle?”

Read the rest of this entry »

XML in the Database: A Brief Overview

Oracle provides a lot of XML functionality in the database. This entry will cover the different tools Oracle provides and future entries will get into the details of each.

The three primary XML tools that oracle provides are: XML Developers Kit (XDK), XML DB and SQL Extensions for XML (SQLX and XMLType). Below is a definition of each.

XDK

The XDK is a complete XML development toolkit that was introduced for 8i. I think the first version was labeled XDK9i but the toolkit actually was available for 8i. I remember using the beta product.

Click to continue reading “XML in the Database: A Brief Overview”

Read the rest of this entry »