The Best Online Storage

0 comments

The Collection Of the best Online Storage

  1. Live Mesh Beta
    It's fast, easy to use and has a nice GUI. Some features is missing now because it's a beta version.
    You can share everything with your friends as easy as you do in your LAN. But you need have your friends registered with this service.
  2. SkyDrive
    It's the same with Live Mesh with larger storage. You can share your files with public.
    Need a registry to use it.
  3. Google Sites
    a service creating a website for personal.

The uploading websites I met during surfacing

  • Reaching from englishtips.com, not to need to wait for a few seconds counted down to get the download link.

Read more...

DB2 References

0 comments

Contents

Introduction

Schema

Index

Referential integrity relationships

Trigger


 

Introduction

This is a place to talk about the DB2 concepts most simply and the easiest-to-understand

Everything will be try to talk about as simplest as possible

Schema

Schema is similar as packages or namespace. It helps to keep the related objects (tables, views, indexes) together

How to create a schema? Please find in IBM website.

Index

What is the benefit of indexes?

Referential integrity relationships

Keep the data consistent through the related tables

  • Primary Key
  • Foreign Key
    • On Delete of Restrict
      what does it mean?

Trigger

Trigger is a method that allows you to do a specific action in the cases:

  • Update
  • Insert

Notes: You're possible to check the conditions before triggering a action, as well as specify which time to do it (before, after …)

How to create a trigger?

How to specify what aspects trigger an action?

Database physical directories and files

    I don't care how they are organized, it's should be just some files that I can bring it to other machine, because I don't need to use the backup or restore function.

Read more...