|
|
|
Customer: Lawrence Livermore National Laboratory
Application: Data Warehouse Project
- 10,000 Users
Reference: Case Study: The Distributed Smalltalk Survival Guide
by Terry Montlick --
The LLNL Data Warehouse
Business: With an average of 10,000 people working on-site connected
to the LLNL intranet, Lawrence Livermore National Laboratory is one of
America's premier government science and technology labs. Volumes of business
data is managed by the Administrative Information Systems Department in
support of the LLNL business processes, and that data needs to be accessible
to each of the 10,000 people daily. Over 12,000 financial reports must be
generated every month within the space of only three days. Managers throughout
the lab have to be able to access their project data on an ad-hoc basis
including business domains such as Procurement and Human Resources. Fiscal
year-end reporting, for accountability to the Department of Energy, must
also be done. These tasks were all included in the scope of the Data
Warehouse Project.
Solution: An object interaction diagram was created from initial use
cases, and an object model was produced. From the object model, major components
were identified by their behavior. The team found places where data brokers
were needed for all business objects. The backbone was chosen to be CORBA,
and the components were defined and assigned to development teams who then
performed further analysis and built the components. Web-based deployment
was chosen to minimize software distribution needs and reduce application
rollout costs and deliver cross-platform portability. A capability known
as User Reporting Attributes (URA) was defined allowing people to create,
maintain, and report using their own data associated with key institutional
data objects such as accounts, people, and purchase orders.
Using PROMIA Visual EIS an ad-hoc reporting framework was produced that
provided controlled access to every warehouse business object. Support for
high-volume batch reporting, ad hoc queries, on-line browser based drill
down reporting and general search capabilities were all delivered with
PROMIA's Visual EIS.
The project is in production producing over 12,000 electronic reports
per month to over 10,000 users. High-volume year-end processing was
successfully completed in November 1999.
Statements: "PROMIA's Visual EIS and CORBA ORBs enabled us to cut
months off of our development schedule, bring the project in much earlier,
and keep within budget guidelines. PROMIA's support has been responsive
and has helped us through many integration issues."
--Mike Piscotty, Data Warehouse Project Manager
Back to Top.
|
|
|
|
