Database Design - Scheduling

[Xiaobing]

Hi All,

Would anyone give me some advice on how to design a system which involves scheduling?

The scenario is we have many system RESOURCEs for PROJECTs. A project have a starttime and endtime. System resources are objects to support the running of the project. e.g. A project may have one or many CT MACHINE(s), one or many DDI NUMBER(s), one or many PROCESSOR(s), and so on. Any system resource can only be used by one project at a certain time. That means I have to design a system which does not allow allocating one resource to two projects which overlap. How should I impletement this? It doesn't seem right to create a TIME table where one row identifies one minute.

Thanks in advance,

Xiaobing

[John Marks]

This month's issue of SQL Server magazine has an article on designing a scheduling system. It is written by Michelle Poolet.


------------
Xiaobing at 11/8/01 7:45:52 AM

Hi All,

Would anyone give me some advice on how to design a system which involves scheduling?

The scenario is we have many system RESOURCEs for PROJECTs. A project have a starttime and endtime. System resources are objects to support the running of the project. e.g. A project may have one or many CT MACHINE(s), one or many DDI NUMBER(s), one or many PROCESSOR(s), and so on. Any system resource can only be used by one project at a certain time. That means I have to design a system which does not allow allocating one resource to two projects which overlap. How should I impletement this? It doesn't seem right to create a TIME table where one row identifies one minute.

Thanks in advance,

Xiaobing

[Xiaobing]

Thanks John.


------------
Xiaobing at 11/8/01 7:45:52 AM

Hi All,

Would anyone give me some advice on how to design a system which involves scheduling?

The scenario is we have many system RESOURCEs for PROJECTs. A project have a starttime and endtime. System resources are objects to support the running of the project. e.g. A project may have one or many CT MACHINE(s), one or many DDI NUMBER(s), one or many PROCESSOR(s), and so on. Any system resource can only be used by one project at a certain time. That means I have to design a system which does not allow allocating one resource to two projects which overlap. How should I impletement this? It doesn't seem right to create a TIME table where one row identifies one minute.

Thanks in advance,

Xiaobing