Y. Richard (Yng-Yuh Richard) Wang.

Connectivity among information systems online

. (page 2 of 2)
Online LibraryY. Richard (Yng-Yuh Richard) WangConnectivity among information systems → online text (page 2 of 2)
Font size
QR-code for this ebook


combines brokerage services, checks, credit card, and savings account features).

(4) Inter-model - which involves combining separate models to make more
comprehensive models (e.g., combine economic forecasting model with optimal
distribution model to analyze the impact of economic conditions on distribution).

As mentioned earlier in the PAS application (Figure 1), in order to find
companies interviewing at Sloan that are auto manufacturers, alumni/students from
these companies, and recent information about these companies, all the five
databases in the four organizations need to be accessed. CIS/TK can be applied to
facilitate this process through its query processor architecture. Moreover, its
knowledge processing component can be employed to perform complex heuristic
reasoning.

The versatility of CIS/TK for a diversity of applications reflects our research
perspective. A comparison of CIS/TK with some related state-of-the-art systems [1,
6, 7, 8, 10, 15,17, 18, 23] will clarify the point, as discussed below.

The capability of the CIS/TK ensemble include: query processing facility, local
database access, multiple remote database access in concert, rules and objects,
instance identification facility, semantic reconciliation facility, global schema
builder, application model builder, and user query builder.

Each feature per se is interesting. However, the major benefit comes from the
capability of the holistic ensemble, as a result of the interfaces and tools built into



18



the tool kit, to facilitate the delivery of timely knowledge and information to the end-
user.

We compare CIS/TK with some representative products or prototypes from the
related research areas: Schema Integration [1, 8], Distributed DBMSs [6, 7, 10, 15],
and Object-Oriented Databases [17, 18, 23]". Note that none of the other systems
were specifically designed for timely delivery of knowledge and information which
require multiple independent disparate databases to work together within and'or
across organizational boundaries, as Table 1 manifests. Therefore, it is not
surprising that no single system includes the comprehensive set of capabilities
incorporated in CIS/TK which are required to accomplish that goal.

CONCLUDING REMARKS

The CIS/TK ensemble is a unique and innovative system for delivering timely
knowledge and information in an inter-organizational setting. In the rapidly
changing, complex, and competitive global market, the capability to dynamically
align corporate strategy with information technology in the organizational context is
a critical issue facing the executive. CIS/TK is aimed at providing such a dynamic IT
platform for supporting knowledge and information intensive applications.

Our focus is on real, nontrivial, and exciting problems challenging today and
tomorrow's IS executives. The operational prototype we have implemented clearly
demonstrates the feasibility of such an innovative concept. In the near term, we plan
to extend the system through the following tasks: (1) design and implement facilities
for credibility analysis, conflict resolution, and further concept inferencing; (2)



4. Also private communications with researchers at CCA on MULTIBASE and PROBE, and
Ontologic, Inc. on Vbase.,



19



develop more efficient local query processors and communication servers; and (3)
demonstrate the feasibility of CIS/TK to interface with geographically disparate ofT-
the-shelf products or customized systems, such as Reuter's Dataline, Textline, and
Newsline databases. We believe that this effort will not only contribute to the
academic research frontier but also benefit the business community in the
foreseeable future.



20



E

■*-•
■D

n

a:



u

ai

c
'^

Ql

E
o






CO

Q
O
O


LU

<

CO

>




a;

>


0)

>


o

2


>


o

z


O

z


O

z


o

z


o

z


o

z


O

z


O

z


o

z


Commercial 1
Efficiency 1


CQ

Q
O
O


LU

or

a

1—

o


a;

>


0)

>


O

z


di

>


0;

>


o

z


o

z


o

z


o

z


o

z


o

z


o

z


o

z


Q c

4, O

> E


03

Q
O

O


LU

CQ
O


>


0)

>


>


>


o

z


o

z


o

z


o

z


o

z


o

z


o

z


o

z


o

z




o

0) ^

O Q

a; Q

♦-^

I


LU
<

59

1—
—1


>


4/S

0;

>


>


o

z


o

z


o

z


o

z


>


o

z


o

z


o

z


o

z


o

z


a;

C 0)


3
O
0) ^

H

E Q
o

X


LU 1—

? a


>


11

>


0;

>-


o

z


o

z


o

z


o

z


>


o

z


o

z


o

z


o

z


o

z


E ^
E 5

51


Schema
Integration


s: >


o


O


o


o

z


o

z


a;

>


o

z


V/1

>-


1/1

>


o

z


o

z


o

z


o

z


2i §

E 2

O CT

< £






a;

>


>


>


0)

>


V/1

a;

>


>-


a;

>


0)

>


a;

>


>


>


T5

c
c


c
c

a.




<

UJ

<

I

u

<

UJ

in

LU


LU

_J

<

X

LU


c

*/>
Q^

o
a.

L_
til

D

o


<

CO

Q

o

1


on
Of

<

GO

Q

o
E

0;
Q-

"5


0)

-D

o


a;
a:


113
u-

CT

C

a
a

03
^j
13

Q


c
o

5 )^

c
2

c


E
o


'5

OQ

E

.

a

3


"5

Q-

13
13

■o

"!u
c
o

c
u

CI

L-

o


13

o

13

k-

1^


o

c

*/l

o
^ o



rsi



REFERENCES

1. Batini, C. Lenzirini, M. and Navathe, S.B. A Comparative Analysis of
Methodologies for Database Schema Integration. ACM Computing Surveys ,
Vol. 18, No. 4, (December 1986), pp. 323 - 363.

2. Benjamin, R.I., Rockart, J.F., Scott Morton, M.S., and Wyman, J. Information
technology: a strategic opportunity. Sloan Management Review, Vol. 25, No. 3,
(Spring 1985), p. 3-10.

3. Benson, R.J. and Parker, M. M. Enterprise-Wide Information Management: An
Introduction to the Concepts. IBM Los Angeles Scientific Center, G320-2768,
(May 1985).

4. Cash, J. I., and Konsynski. B.R. IS Redraws Competitive Boundaries. Harvard
Business Review , (March-April 1985), 134-142.

5. Clemons, E.K. and McFarlan, F.W., Telecom: Hook Up or Lose Out. Harvard
Business Review , (July- August, 1986).

6. Dayal, U. and Hwang, K. View Definition and Generalization for Database
Integration in Multidatabase System. IEEE Transactions on Software
Engineering, Vol. SE-10, No. 6, November 1984, pp. 628-644.

7. Deen, S. M., Amin, R.R., and Taylor M.C. Data integration in distributed
databases. IEEE Transactions on Software Engineering , Vol. SE-13, No. 7, (July
1987) pp. 860-864.

8. Elmasri R., Larson J. and Navathe, S. Schema Integration Algorithms for
Federated Databases and Logical Database Design. Submitted for Publication,
1987.

9. Frank, W.F., Madnick, S.E., and Wang, Y.R. A Conceptual Model for Integrated
Autonomous Processing: An International Bank's Experience with Large
Databases. Proceedings of the 8th Annual International Conference on
Information Systems (ICIS) , (December 1987), pp. 219-231.

10. Goldhirsch, D., Landers, T., Rosenberg, R., and Yedwab, L. MULTIBASE:
System Administrator's Guide. Computer Corporation of America, Cambridge,
MA, (November 1984).

11. Horton, D.C. An Object-Oriented Approach Towards Enhancing Logical
Connectivity in a Distributed Database Environment. Master's Thesis, Sloan
School of Management, MIT, (May 1988).

12. Ives, B. and Learmonth, G.P., The Information Systems as a Competitive
Weapon. Communications of the ACM . Vol. 27(12), (December 1984), pp. 1193-
1201.

13. Kerschberg, L. Ed. Expert Database Systems, Proceedings from the First
International Workshop . The Benjamin/Cummings Publishing Company (1986).

14. Levine, S., Interfacing Objects and Database. Master's Thesis, Electrical
Engineering and Computer Science, MIT, (May 1987).

15. Lyngbaek, P. and McLeod D. An approach to object sharing in distributed
database systems. The Proceedings of the 9th International Conf. on VLDB ,
(October, 1983).



22



16. Madnick, S.E. and Wang, Y.R. Evolution Towards Strategic Applications of
Databases Through Composite Information Systems. To Appear in the Journal
of Management Information Systems , (Fall, 1988).

17. Manona, F. and Dayal, U. PDM: An Object-Oriented Data Model Proceedings
International Workshop on Object-Oriented Database Systems . Pacific Grove,
CA. (September 1986) pp. 18 - 25.

18. Ontologiclnc. Vbase Integrated Object System. 47 Manning Rd., Billerica, MA
01821 (November 1987).

19. Porter, M. and Millar, V.E., How information gives you competitive
advantages. Harvard Business Review (July-August 1985) p. 149-160.

20. Rincon, M. N., Integrating systems for financial institutions services using
Composite Information Systems. Master's Thesis, Sloan School of Management,
MIT, (May 1987).

21. Rockart, J.F. and Scott Morton, M.S., Implications of changes in information
technology for corporate strategy. Interfaces , Vol. 14, No. 1 (January-February,
1984), pp. 84-95.

22. Stefik, M. and Bobrow, D.G. Object-Oriented Programming: Themes and
Variations. The AI Magazine . Vol. 6, No. 4, (Winter 1986), pp. 40 - 62.

23. Stonebraker M. and Rowe, L.A. (ed) The POSTGRES Papers. No. UCB/^RL
M86/85 (June 1987) UC Berkeley, 94720.

24. Wang, Y.R. and Madnick, S.E. Facilitating Connectivity in Composite
Information Systems. To Appear in ACM Database .



( ^ ■ J U / /

23



w>



^



Date Due "^



AUG OS 19^^



Lib-26-f;7



MIT I [RRARIF*;



3 TDflD DOS 37t. MD2





2

Online LibraryY. Richard (Yng-Yuh Richard) WangConnectivity among information systems → online text (page 2 of 2)