Revised September 1999
Project Start Date: Wed 12/2/98
Project Finish Date: Tue 8/15/00
ID |
Task Name |
Duration |
Start |
Finish |
Resources |
% Complete |
1 |
Support Databases |
89 wks |
Wed 12/2/98 |
Tue 8/15/00 |
|
31% |
2 |
Meetings and Coordination |
56.6 wks |
Wed 12/2/98 |
Fri 12/31/99 |
JPP[20%] |
42% |
3 |
Ongoing support |
56.6 wks |
Wed 12/2/98 |
Fri 12/31/99 |
JPP[20%] |
42% |
4 |
Create/maintain Web Pages for each experiments database support effort |
283 days |
Wed 12/2/98 |
Fri 12/31/99 |
|
25% |
5 |
Support Mail Lists for user information and support questions for each experiment |
283 days |
Wed 12/2/98 |
Fri 12/31/99 |
|
75% |
6 |
Produce Tutorials, examples, and other reference documentation |
283 days |
Wed 12/2/98 |
Fri 12/31/99 |
|
25% |
7 |
Oracle Database Administration |
89 wks |
Wed 12/2/98 |
Tue 8/15/00 |
JPP[250%] |
35% |
8 |
Deploy Data Base Server Computers |
52 wks |
Wed 12/2/98 |
Tue 11/30/99 |
|
41% |
9 |
CDF Offline Prototype |
52 wks |
Wed 12/2/98 |
Tue 11/30/99 |
|
50% |
10 |
CDF Online Development |
0.2 wks |
Wed 12/2/98 |
Wed 12/2/98 |
|
0% |
11 |
CDF Offline Production |
0.2 wks |
Wed 12/2/98 |
Wed 12/2/98 |
|
0% |
12 |
CDF Online Production |
0.2 wks |
Wed 12/2/98 |
Wed 12/2/98 |
|
0% |
13 |
D0 Offline Development |
52 wks |
Wed 12/2/98 |
Tue 11/30/99 |
|
50% |
14 |
D0 Offline Production |
52 wks |
Wed 12/2/98 |
Tue 11/30/99 |
|
25% |
15 |
D0 Online Development |
0.2 wks |
Wed 12/2/98 |
Wed 12/2/98 |
|
0% |
16 |
D0 Online Production |
0.2 wks |
Wed 12/2/98 |
Wed 12/2/98 |
|
0% |
17 |
Deploy Oracle Client Software for General Distribution - Solaris, IRIX, NT, OSF1, Linux |
60.6 wks |
Wed 12/2/98 |
Fri 1/28/00 |
|
100% |
18 |
Oracle 8.0.5 |
63 days |
Wed 12/2/98 |
Fri 2/26/99 |
|
100% |
19 |
Oracle 8.1.5 |
4 wks |
Sat 1/1/00 |
Fri 1/28/00 |
|
100% |
20 |
Oracle 8.1.6 |
0 wks |
Wed 12/2/98 |
Wed 12/2/98 |
|
100% |
21 |
Document/Test installation Procedures by Instance |
105 days |
Wed 12/2/98 |
Tue 4/27/99 |
|
100% |
22 |
Server Deployment and Support |
89 wks |
Wed 12/2/98 |
Tue 8/15/00 |
|
25% |
23 |
Document Server Installation Requirements by Machine/Instance |
174 days |
Wed 12/2/98 |
Mon 8/2/99 |
|
50% |
24 |
Deploy Oracle Instances/Repositories - for each Server Platform above |
52 wks |
Wed 12/2/98 |
Tue 11/30/99 |
|
28% |
25 |
Administer Computers |
52 wks |
Wed 12/2/98 |
Tue 11/30/99 |
JPP |
0% |
26 |
Install Instances |
34.8 wks |
Wed 12/2/98 |
Mon 8/2/99 |
|
70% |
27 |
Identify Instance Support Levels |
0.5 wks |
Wed 2/3/99 |
Fri 2/5/99 |
|
50% |
28 |
Document Migration Plans |
8 wks |
Mon 2/15/99 |
Fri 4/9/99 |
|
20% |
29 |
Migrate Demo to Development |
155 days |
Mon 2/1/99 |
Fri 9/3/99 |
|
80% |
30 |
Migrate Dev to Production |
135 days |
Mon 4/19/99 |
Fri 10/22/99 |
|
0% |
31 |
Migrate Production to Integration |
135 days |
Mon 4/19/99 |
Fri 10/22/99 |
|
0% |
32 |
Database Access |
2 wks |
Mon 3/22/99 |
Fri 4/2/99 |
|
0% |
33 |
Identify Database Role Patterns |
1 wk |
Mon 3/22/99 |
Fri 3/26/99 |
|
0% |
34 |
Implement Database Roles |
1 wk |
Mon 3/29/99 |
Fri 4/2/99 |
|
0% |
35 |
Database Backup/Recovery |
13 wks |
Mon 3/1/99 |
Fri 5/28/99 |
|
50% |
36 |
Define backup requirements |
2 wks |
Mon 3/1/99 |
Fri 3/12/99 |
|
100% |
37 |
Prototype Backups |
4 wks |
Mon 3/15/99 |
Fri 4/9/99 |
|
70% |
38 |
Deploy Backups |
3 wks |
Mon 4/12/99 |
Fri 4/30/99 |
|
50% |
39 |
Plan Recovery Tests/Procedures |
1 wk |
Mon 5/3/99 |
Fri 5/7/99 |
|
10% |
40 |
Perform Recovery Tests |
3 wks |
Mon 5/10/99 |
Fri 5/28/99 |
|
5% |
41 |
Replication for CDF |
12 wks |
Tue 2/16/99 |
Mon 5/10/99 |
|
69% |
42 |
Define Requirements |
3 wks |
Tue 2/16/99 |
Mon 3/8/99 |
|
75% |
43 |
Prototype |
3 wks |
Tue 3/9/99 |
Mon 3/29/99 |
|
100% |
44 |
Implement |
3 wks |
Tue 3/30/99 |
Mon 4/19/99 |
|
60% |
45 |
Test |
3 wks |
Tue 4/20/99 |
Mon 5/10/99 |
|
40% |
46 |
Database Upload/Download for D0 |
12 wks |
Mon 1/3/00 |
Fri 3/24/00 |
|
0% |
47 |
Requirements and Implementation |
12 wks |
Mon 1/3/00 |
Fri 3/24/00 |
|
0% |
48 |
Evaluate Advanced Queueing |
4 wks |
Tue 2/1/00 |
Mon 2/28/00 |
|
0% |
49 |
Parallel Server |
50 wks |
Wed 9/1/99 |
Tue 8/15/00 |
|
0% |
50 |
Test raw partitions on fncduh2 |
4 wks |
Wed 12/1/99 |
Tue 12/28/99 |
|
0% |
51 |
Database Tuning and Monitoring |
50 wks |
Wed 9/1/99 |
Tue 8/15/00 |
|
0% |
52 |
Deploy OEM repository |
2 wks |
Mon 11/1/99 |
Fri 11/12/99 |
|
0% |
53 |
Provide Web access to information |
20 wks |
Mon 11/1/99 |
Fri 3/17/00 |
|
0% |
54 |
Shareware or Remote Site Databases |
50.6 wks |
Thu 7/1/99 |
Mon 6/19/00 |
|
12% |
55 |
Evaluate Shareware/Free databases |
12.4 wks |
Thu 7/1/99 |
Fri 9/24/99 |
JPP |
50% |
56 |
MSQL - no support to be provided for this |
4 wks |
Thu 7/1/99 |
Wed 7/28/99 |
|
100% |
57 |
MYSQL |
4 wks |
Mon 8/16/99 |
Fri 9/10/99 |
|
25% |
58 |
Microsoft Access |
4 wks |
Mon 8/30/99 |
Fri 9/24/99 |
|
25% |
59 |
Recommend shareware/free database management system |
18 days |
Mon 1/3/00 |
Wed 1/26/00 |
|
0% |
60 |
Evaluate Migratory Oracle Database - nomadic db |
20 wks |
Tue 2/1/00 |
Mon 6/19/00 |
|
0% |
61 |
Evaluate Linux-Oracle for remote use |
26 wks |
Wed 9/1/99 |
Tue 2/29/00 |
|
5% |
62 |
Support for Database Application Development Tools |
38.2 wks |
Wed 12/2/98 |
Wed 8/25/99 |
JPP[20%] |
65% |
63 |
Deploy Designer 2000 licences |
28.6 wks |
Mon 2/8/99 |
Wed 8/25/99 |
|
59% |
64 |
Installation |
60 days |
Mon 2/8/99 |
Fri 4/30/99 |
|
100% |
65 |
Education and Documentation |
83 days |
Mon 5/3/99 |
Wed 8/25/99 |
|
30% |
66 |
Understand role of Developer 2000 in our development process |
14.8 wks |
Wed 12/2/98 |
Mon 3/15/99 |
|
100% |
67 |
Use for static-table maintainance for SAM databases |
23 days |
Wed 12/2/98 |
Fri 1/1/99 |
|
100% |
68 |
Decide Whether to Purchase Additional Licenses |
1 day |
Mon 3/15/99 |
Mon 3/15/99 |
|
100% |
69 |
CDF Databases - design, interface, review and deploy |
32.6 wks |
Wed 12/2/98 |
Fri 7/16/99 |
JPP |
24% |
70 |
Hardware |
10 wks |
Wed 2/3/99 |
Tue 4/13/99 |
|
75% |
71 |
Calibration |
20 wks |
Wed 12/2/98 |
Tue 4/20/99 |
|
25% |
72 |
Run Conditions |
8 wks |
Mon 5/10/99 |
Fri 7/2/99 |
|
10% |
73 |
Production/ Data Handling(RCP) |
8 wks |
Mon 5/10/99 |
Fri 7/2/99 |
|
10% |
74 |
Luminosity - part of Data File Catalog |
8 wks |
Mon 5/24/99 |
Fri 7/16/99 |
|
0% |
75 |
Slow Controls |
8 wks |
Wed 12/2/98 |
Tue 1/26/99 |
|
0% |
76 |
Trigger - Levels 1-3 |
8 wks |
Mon 1/11/99 |
Fri 3/5/99 |
|
10% |
77 |
Alignment |
8 wks |
Mon 5/10/99 |
Fri 7/2/99 |
|
0% |
78 |
Data File Catalog |
8 wks |
Thu 2/4/99 |
Wed 3/31/99 |
|
75% |
79 |
D0 Databases - design, database server, application inerface, deploy |
35.6 wks |
Wed 12/2/98 |
Fri 8/6/99 |
JPP |
25% |
80 |
Hardware DB |
10 wks |
Wed 2/3/99 |
Tue 4/13/99 |
|
60% |
81 |
Calibration DB |
21 wks |
Mon 2/8/99 |
Fri 7/2/99 |
|
26% |
82 |
Create ER Diagram and design for detector databases |
4 wks |
Mon 2/8/99 |
Fri 3/5/99 |
|
30% |
83 |
Analysis of Usage, Size and I/o requirements for each detector |
4 wks |
Mon 3/8/99 |
Fri 4/2/99 |
|
50% |
84 |
SMT |
4 wks |
Mon 3/8/99 |
Fri 4/2/99 |
|
50% |
85 |
Design and implementation of Database Server |
3 wks |
Mon 4/5/99 |
Fri 4/23/99 |
|
40% |
86 |
Documentatation |
4 wks |
Mon 4/26/99 |
Fri 5/21/99 |
|
20% |
87 |
Maintenance and Reporting tools |
5 wks |
Mon 5/31/99 |
Fri 7/2/99 |
|
0% |
88 |
Run DB |
25 wks |
Mon 2/15/99 |
Fri 8/6/99 |
|
0% |
89 |
Trigger |
14.6 wks |
Mon 4/26/99 |
Wed 8/4/99 |
|
89% |
90 |
Requirements Analysis |
33 days |
Mon 4/26/99 |
Wed 6/9/99 |
|
100% |
91 |
Database Design |
38 days |
Mon 6/14/99 |
Wed 8/4/99 |
|
80% |
92 |
Alignment |
15.6 wks |
Wed 12/2/98 |
Fri 3/19/99 |
|
16% |
93 |
Prototype |
3 wks |
Wed 12/2/98 |
Tue 12/22/98 |
|
30% |
94 |
Create ER Design |
8 wks |
Mon 1/25/99 |
Fri 3/19/99 |
|
30% |
95 |
Analysis of processes and functions |
2 wks |
Wed 12/2/98 |
Tue 12/15/98 |
|
0% |
96 |
Design Database |
1 wk |
Wed 12/2/98 |
Tue 12/8/98 |
|
0% |
97 |
Implementation of scripts for data import and manipulation |
2 wks |
Wed 12/2/98 |
Tue 12/15/98 |
|
0% |
98 |
Implementation of reports and data export |
3 wks |
Wed 12/2/98 |
Tue 12/22/98 |
|
0% |
99 |
Documentation |
2 wks |
Wed 12/2/98 |
Tue 12/15/98 |
|
0% |
100 |
File and Event Catalog - in SAM |
1 day |
Wed 12/2/98 |
Wed 12/2/98 |
|
0% |
101 |
RCP |
16 wks |
Mon 2/1/99 |
Fri 5/21/99 |
|
8% |
102 |
Create ER Diagram and design for detector databases |
4 wks |
Mon 2/1/99 |
Fri 2/26/99 |
|
30% |
103 |
Analysis of Usage |
1 wk |
Mon 3/1/99 |
Fri 3/5/99 |
|
0% |
104 |
Design and implementation of Database interface packages |
4 wks |
Mon 3/8/99 |
Fri 4/2/99 |
|
0% |
105 |
Design and implementation of Database Server |
3 wks |
Mon 4/5/99 |
Fri 4/23/99 |
|
0% |
106 |
Documentatation |
2 wks |
Mon 4/26/99 |
Fri 5/7/99 |
|
0% |
107 |
Maintenance and Reporting tools |
2 wks |
Mon 5/10/99 |
Fri 5/21/99 |
|
0% |
108 |
Luminosity |
19.6 wks |
Wed 12/2/98 |
Fri 4/16/99 |
|
5% |
109 |
Create ER Diagram and design for detector databases |
2 wks |
Mon 3/1/99 |
Fri 3/12/99 |
|
0% |
110 |
Analysis of Usage online and offline with data handling |
2 wks |
Mon 4/5/99 |
Fri 4/16/99 |
|
25% |
111 |
Design and implementation of Database interface packages |
1 day |
Wed 12/2/98 |
Wed 12/2/98 |
|
0% |
112 |
Design and implementation of Database Server |
2 wks |
Wed 12/2/98 |
Tue 12/15/98 |
|
0% |
113 |
Documentatation |
2 wks |
Wed 12/2/98 |
Tue 12/15/98 |
|
0% |
114 |
Maintenance and Reporting tools |
2 wks |
Wed 12/2/98 |
Tue 12/15/98 |
|
0% |
115 |
Help design OCS Database |
8 wks |
Wed 3/1/00 |
Tue 4/25/00 |
JPP |
10% |
116 |
Review Database Designs |
4 wks |
Wed 3/1/00 |
Tue 3/28/00 |
|
0% |
117 |
Middleware Connectivity/API Tools |
10.6 wks |
Wed 12/2/98 |
Fri 2/12/99 |
JPP |
90% |
118 |
Package and put into Kits |
10.6 wks |
Wed 12/2/98 |
Fri 2/12/99 |
|
90% |
119 |
dbi-perl |
1 wk |
Wed 12/2/98 |
Tue 12/8/98 |
|
100% |
120 |
orapython |
1 wk |
Wed 12/2/98 |
Tue 12/8/98 |
|
100% |
121 |
Python-odbc |
1 wk |
Wed 12/2/98 |
Tue 12/8/98 |
|
100% |
122 |
Jdbc |
1 wk |
Wed 12/2/98 |
Tue 12/8/98 |
|
100% |
123 |
Fnorb |
3 wks |
Mon 1/25/99 |
Fri 2/12/99 |
|
80% |
124 |
Orbacus - OB, JTC and JOB |
1 wk |
Fri 2/5/99 |
Thu 2/11/99 |
|
80% |
125 |
Joint Development Tools |
82.6 wks |
Wed 12/2/98 |
Fri 6/30/00 |
|
20% |
126 |
Tools to migrate data between Central and Distributed databases at Remote Inistutions |
58.2 wks |
Mon 5/3/99 |
Mon 6/12/00 |
JPP |
0% |
127 |
Map (and simplify?) Schema from Oracle to Shareware DB |
3 wks |
Mon 8/2/99 |
Fri 8/20/99 |
|
0% |
128 |
Develop data export application |
200 days |
Tue 9/7/99 |
Mon 6/12/00 |
|
0% |
129 |
Migration between Online and Offline Databases |
100 days |
Mon 5/3/99 |
Fri 9/17/99 |
|
0% |
130 |
Synchronization between Central and Distributed Databases at Fermilab |
2 wks |
Mon 9/20/99 |
Fri 10/1/99 |
|
0% |
131 |
Deployment |
2 wks |
Mon 9/6/99 |
Fri 9/17/99 |
|
0% |
132 |
CORBA Object Server |
63.2 wks |
Fri 1/1/99 |
Fri 3/17/00 |
JPP |
49% |
133 |
Develop Server Tools |
143 days |
Fri 1/1/99 |
Tue 7/20/99 |
|
75% |
134 |
Develop Client Integration |
50 days |
Fri 1/1/99 |
Thu 3/11/99 |
|
75% |
135 |
Rewrite in C++ |
20 wks |
Mon 11/1/99 |
Fri 3/17/00 |
|
0% |
136 |
Reporting Tools |
78 wks |
Mon 1/4/99 |
Fri 6/30/00 |
JPP |
2% |
137 |
Evaluation and deployment |
33 wks |
Mon 1/4/99 |
Fri 8/20/99 |
|
5% |
138 |
Crystal Reports |
35 days |
Mon 7/5/99 |
Fri 8/20/99 |
|
5% |
139 |
Practical Extraction and Reporting Language |
35 days |
Mon 1/4/99 |
Fri 2/19/99 |
|
5% |
140 |
Java/JDBC |
35 days |
Mon 7/5/99 |
Fri 8/20/99 |
|
5% |
141 |
Report Generation |
225 days |
Mon 8/23/99 |
Fri 6/30/00 |
|
0% |
142 |
Object/Relational Mapping Tools |
31.2 wks |
Wed 12/2/98 |
Wed 7/7/99 |
|
53% |
143 |
Object/Relational Mapping and APIs |
31.2 wks |
Wed 12/2/98 |
Wed 7/7/99 |
|
53% |
144 |
CDF Libraries |
31.2 wks |
Wed 12/2/98 |
Wed 7/7/99 |
|
50% |
145 |
JDBManager Prototype |
4 wks |
Mon 1/25/99 |
Fri 2/19/99 |
JPP[50%] |
80% |
146 |
JDBManager Production and Support for Online |
12 wks |
Wed 12/2/98 |
Tue 2/23/99 |
JPP |
30% |
147 |
Calibration OCI Wrappers |
4 wks |
Thu 6/10/99 |
Wed 7/7/99 |
JPP[50%] |
80% |
148 |
D0 APIs and Applications |
8 wks |
Fri 4/2/99 |
Thu 5/27/99 |
|
60% |
149 |
dbgen.py |
8 wks |
Fri 4/2/99 |
Thu 5/27/99 |
JPP |
60% |
150 |
Integration with D0 persistency mechanism DOOM |
0 wks |
Mon 4/5/99 |
Mon 4/5/99 |
|
10% |