81T47 DISTRIBUTED DATABASES & OBJECT ORIENTED DATABASES
UNIT-I:
Distributed databases features - distributed database management systems - review of databases and nomputer n~tworks, levels of
distribution transparency. reference architecture, type of data fragmentation, distribution transparency for read only applications and
update applications. distributed database access primitives and integrity constraints.
UNiT-Il:
Distributed database design, a frame work for distributed database design, the design of database fragmentation, the allocation of
fragments. translation global queries to fragment queries, equiv~tlenpe ttansformation for queries. transforming global qUeries into
fragment queries. distributed grouping and aggregate function evaluation, parametric queries
UNIT-Ill:
Query optimization, problems in query Optiintza~i0fl. objectives in query process optimization. simpler representation of queries,
model fo~ query ootiniization,- join query, general queries, 'concept of two phase commit, resolving dmsrHbumcd transaction.
concept of replication, snapshot on replication and multimaster replication. conflict resolution in multimaster replication,
concurrency control and database recovery in d~tributed databases.
UNIT-lV~
The evolution of object oriented concepts. object-oriented concepts, characteristics of an objectoriented data mode!, object schemas,
class-subclass relationships. interobject relationships, late and early binding, support for vcrsioning. Similarities & differences
between 00DM and other data models, features of air object-oriented databases management system, OODBMS architectural
approaches-extended relational model approach, semantic database approach, object oriented database programming language
extension approach. DBMS generator approach. obiect definition language and object query language.
UNIT-V:
OODBMS architectures, performance issues in OODBMS. application selection for OODBMS, database design for an object
relational database management system (ORDBMS). structured types & ADTs. object identity, extending ER mode!. using nested
collections, storage and access methods, query processing, query optimisation. design and architecture of POSTGRES. distributed
computing in CORBA and BiB.
TEXTBOOKS:
I. Distributed data bases principles and systems by Ceri & Pelagatti (McGraw Hill Pub!.)
2. Fundamentals of Database System by Eliniskv & Navathe (3Td Ed. Addison W,.elsey)
3. Object Oriented Database System - Approaches & Architectures by C.S.R. P~ablui (PHE Pub.)
REFERENCE BOOKS:
I. Database System - Design Jinpicinentation & Management by Peter Rob & Carlos Coronel. (Course Tech.)
2. Database Management Svstenis by Raghu Ramakrishnan & Johannes Gehrke.(McGraw Pub.)
3. Oracle Si Distributed Database Replication Manual.
81T48 WEB TECHNOLOGIES
UNIT-1
Basic tools of internet access, emaiL ftp. news. ww~\. anarchie, introduction to internet programming, sockets
: connections, atiributesm donmins. types and protocols (sockets), creating and closing sockets, socket
communication. client server application using C on linux
platform. .1
UNIT-Il:
Standard use for www documents on internet. HTTP. MIME. SGML. DTD. MTNL, URL, URI. HTML tags
special chatacters im ~ ibiLs forms thL h\ pLrllnks I-fJ'ML URLs serving HTML pages.
UNIT-Ill:
CGI : CGT prograrnrni1~g using C.
UNIT-IV :
XML basics, understanding markup languages. sructures and syntax, valid Vi. well formed XML, DTD
(document type Definition) classes.
UNIT-V:
Scripting XML, XML processor. parent child reJarionship XML as a data, data type in XML, XML
namespaces, linking with XML simple link. the HTML way. XSL : XML. with stie:
style sheet basics, XSL basics. XSL SN he sheets
TEXTBOOKS:
I. XML in action web technology by William J. Pardi (P1-LI Pub.)
REFERENCE BOOKS:
I. Step by Step XML by Michael J. Young (Pill Pub.)
2. Designing Interactive Web sites by James L. Mohier & John M Duff (Thomson Learning)
PRACTICALS based on above syllabus
1. Socket programming and CGI using C' on linux platform.
2. HTML, XML web page designing.
81T47 DISTRIBUTED DATABASES & OBJECT ORIENTED DATABASES
UNIT-I:
Distributed databases features - distributed database management systems - review of databases and
computer n~t~vorks, levels of distribution transparency. reference architecture, type of data
fragmentation, distribution transparency for read onl~ applications and update applications. distributed
database access primitives and integrity constraints
UNiT-lI
Distributed database design, a frame work for distributed database design, the design of database
fragmentation, the allocation of fragments. translation global queries to fragment queries, equivalence
ttansformation for queries. traiistbrniing global queries into fragment queries. distributed grouping and
aggregate function e'.'aluanon. parametric queries
UNIT-Ill:
Query optimization, problems in query optimization. objectives in query process optimization, simpler
representation of queries, model to: query optimization,- join query, general queries, concept of two
phase commit, resolving disviburcd tran~action. concept of replication, snapshot on replication and
multimaster replication, conflict resolution in ~nu1timaster replication, concurrency control and
database recovery in d~tributed databases.
UNIT-IV
The evolution of object oriented concepts. object-oriented concepts, characteristics of an objectoriented
data model, object schcmas, class-so bclass relationships. interobject relationships, late and
early binding, support for versioning. Similarities & differences between 00DM and other data models,
features of an object-oriented databases management system. OODBMS architectural approachesextended
relational model approach, semantic database approach, object oriented database
programming language extension approach. DBMS generator approach, object definition language
and object query language.
UNIT-V:
OODBMS architectures, performance issues in OODBMS, application selection for OODBMS,
database design for an object relational database management system (ORDBMS). structured types &
ADTs. object identity. extending Ek model, using nested collections, storage and access methods,
query processing, query optimisation. design and architecture of POSTGRES. distributed computing in
CORBA and EJB.
TEXTBOOKS:
I. Distributed data bases principles and systems by Ceri & Pelagatti (McGraw Hill Pubi.)
2. Fundamentals of Database System by Elmiskv & Navathe (3~ Ed. Addison W,elsey)
3. Object Oriented Database System - Approaches & Architectures by C.S.R. P~abhu (Pt-il Pub.)
REFERENCE BOOKS:
I. Database System - Design Implementation & Management by Peter Rob & Carlos Coronel,
(Course Tech.)
2. Database Management Systems h~' Raghu Ramakrishnan & Johannes Gehrke,(McGraw Pub.)
3. Oracle 8i Distributed Database Replication Manual.
81T50/1 ENTERPRICE RESOURCE PLANNING
UNIT-I:
INTRODUCTION Business needs and ERP, ERP as an overview, entries as an overview, Benefits of ERP, ERP and
related technologies, ERP architecture, business process reengineering, data warehousing, data mining, on line analytical
processing supply choice management.
UNIT-ii:
ERP ll'~WLEMENTATJON : Client server architecture and ERP, ERP implementation life cycle, implementation
m~hodologies, ER? implementation - The hidden cost, organizing implementations, vendors, consultants and users, contracts with
vendors, consultants and employees, proj ect management and monitoring. After ERP iinplementatiou.
UNIT-Ill:
THE BUSINESS MODULE : Business models in an ER? package, finance, manufacturing human resource, plant
maintenance, materials management, quality management sales and distribution.
UNIT-IV:
Selection of ERP, SWOT anaiysis of various ER? products supply chain enabled ERP.
UNITT-V:
ER? and Electronic Data Interchange (EDI) integration, ERP in manufacturing and nonnianufactunng industries.
TEXT BOOKS:
1. ER.P Demystifled by Aleris Leon (TMH Pub.)
2. Enterprise Resource Planning by Parag Diwan and Sunil Sharma (Pentageon Pren.)
UNIT-I:
Distributed databases features - distributed database management systems - review of databases and nomputer n~tworks, levels of
distribution transparency. reference architecture, type of data fragmentation, distribution transparency for read only applications and
update applications. distributed database access primitives and integrity constraints.
UNiT-Il:
Distributed database design, a frame work for distributed database design, the design of database fragmentation, the allocation of
fragments. translation global queries to fragment queries, equiv~tlenpe ttansformation for queries. transforming global qUeries into
fragment queries. distributed grouping and aggregate function evaluation, parametric queries
UNIT-Ill:
Query optimization, problems in query Optiintza~i0fl. objectives in query process optimization. simpler representation of queries,
model fo~ query ootiniization,- join query, general queries, 'concept of two phase commit, resolving dmsrHbumcd transaction.
concept of replication, snapshot on replication and multimaster replication. conflict resolution in multimaster replication,
concurrency control and database recovery in d~tributed databases.
UNIT-lV~
The evolution of object oriented concepts. object-oriented concepts, characteristics of an objectoriented data mode!, object schemas,
class-subclass relationships. interobject relationships, late and early binding, support for vcrsioning. Similarities & differences
between 00DM and other data models, features of air object-oriented databases management system, OODBMS architectural
approaches-extended relational model approach, semantic database approach, object oriented database programming language
extension approach. DBMS generator approach. obiect definition language and object query language.
UNIT-V:
OODBMS architectures, performance issues in OODBMS. application selection for OODBMS, database design for an object
relational database management system (ORDBMS). structured types & ADTs. object identity, extending ER mode!. using nested
collections, storage and access methods, query processing, query optimisation. design and architecture of POSTGRES. distributed
computing in CORBA and BiB.
TEXTBOOKS:
I. Distributed data bases principles and systems by Ceri & Pelagatti (McGraw Hill Pub!.)
2. Fundamentals of Database System by Eliniskv & Navathe (3Td Ed. Addison W,.elsey)
3. Object Oriented Database System - Approaches & Architectures by C.S.R. P~ablui (PHE Pub.)
REFERENCE BOOKS:
I. Database System - Design Jinpicinentation & Management by Peter Rob & Carlos Coronel. (Course Tech.)
2. Database Management Svstenis by Raghu Ramakrishnan & Johannes Gehrke.(McGraw Pub.)
3. Oracle Si Distributed Database Replication Manual.
81T48 WEB TECHNOLOGIES
UNIT-1
Basic tools of internet access, emaiL ftp. news. ww~\. anarchie, introduction to internet programming, sockets
: connections, atiributesm donmins. types and protocols (sockets), creating and closing sockets, socket
communication. client server application using C on linux
platform. .1
UNIT-Il:
Standard use for www documents on internet. HTTP. MIME. SGML. DTD. MTNL, URL, URI. HTML tags
special chatacters im ~ ibiLs forms thL h\ pLrllnks I-fJ'ML URLs serving HTML pages.
UNIT-Ill:
CGI : CGT prograrnrni1~g using C.
UNIT-IV :
XML basics, understanding markup languages. sructures and syntax, valid Vi. well formed XML, DTD
(document type Definition) classes.
UNIT-V:
Scripting XML, XML processor. parent child reJarionship XML as a data, data type in XML, XML
namespaces, linking with XML simple link. the HTML way. XSL : XML. with stie:
style sheet basics, XSL basics. XSL SN he sheets
TEXTBOOKS:
I. XML in action web technology by William J. Pardi (P1-LI Pub.)
REFERENCE BOOKS:
I. Step by Step XML by Michael J. Young (Pill Pub.)
2. Designing Interactive Web sites by James L. Mohier & John M Duff (Thomson Learning)
PRACTICALS based on above syllabus
1. Socket programming and CGI using C' on linux platform.
2. HTML, XML web page designing.
81T47 DISTRIBUTED DATABASES & OBJECT ORIENTED DATABASES
UNIT-I:
Distributed databases features - distributed database management systems - review of databases and
computer n~t~vorks, levels of distribution transparency. reference architecture, type of data
fragmentation, distribution transparency for read onl~ applications and update applications. distributed
database access primitives and integrity constraints
UNiT-lI
Distributed database design, a frame work for distributed database design, the design of database
fragmentation, the allocation of fragments. translation global queries to fragment queries, equivalence
ttansformation for queries. traiistbrniing global queries into fragment queries. distributed grouping and
aggregate function e'.'aluanon. parametric queries
UNIT-Ill:
Query optimization, problems in query optimization. objectives in query process optimization, simpler
representation of queries, model to: query optimization,- join query, general queries, concept of two
phase commit, resolving disviburcd tran~action. concept of replication, snapshot on replication and
multimaster replication, conflict resolution in ~nu1timaster replication, concurrency control and
database recovery in d~tributed databases.
UNIT-IV
The evolution of object oriented concepts. object-oriented concepts, characteristics of an objectoriented
data model, object schcmas, class-so bclass relationships. interobject relationships, late and
early binding, support for versioning. Similarities & differences between 00DM and other data models,
features of an object-oriented databases management system. OODBMS architectural approachesextended
relational model approach, semantic database approach, object oriented database
programming language extension approach. DBMS generator approach, object definition language
and object query language.
UNIT-V:
OODBMS architectures, performance issues in OODBMS, application selection for OODBMS,
database design for an object relational database management system (ORDBMS). structured types &
ADTs. object identity. extending Ek model, using nested collections, storage and access methods,
query processing, query optimisation. design and architecture of POSTGRES. distributed computing in
CORBA and EJB.
TEXTBOOKS:
I. Distributed data bases principles and systems by Ceri & Pelagatti (McGraw Hill Pubi.)
2. Fundamentals of Database System by Elmiskv & Navathe (3~ Ed. Addison W,elsey)
3. Object Oriented Database System - Approaches & Architectures by C.S.R. P~abhu (Pt-il Pub.)
REFERENCE BOOKS:
I. Database System - Design Implementation & Management by Peter Rob & Carlos Coronel,
(Course Tech.)
2. Database Management Systems h~' Raghu Ramakrishnan & Johannes Gehrke,(McGraw Pub.)
3. Oracle 8i Distributed Database Replication Manual.
81T50/1 ENTERPRICE RESOURCE PLANNING
UNIT-I:
INTRODUCTION Business needs and ERP, ERP as an overview, entries as an overview, Benefits of ERP, ERP and
related technologies, ERP architecture, business process reengineering, data warehousing, data mining, on line analytical
processing supply choice management.
UNIT-ii:
ERP ll'~WLEMENTATJON : Client server architecture and ERP, ERP implementation life cycle, implementation
m~hodologies, ER? implementation - The hidden cost, organizing implementations, vendors, consultants and users, contracts with
vendors, consultants and employees, proj ect management and monitoring. After ERP iinplementatiou.
UNIT-Ill:
THE BUSINESS MODULE : Business models in an ER? package, finance, manufacturing human resource, plant
maintenance, materials management, quality management sales and distribution.
UNIT-IV:
Selection of ERP, SWOT anaiysis of various ER? products supply chain enabled ERP.
UNITT-V:
ER? and Electronic Data Interchange (EDI) integration, ERP in manufacturing and nonnianufactunng industries.
TEXT BOOKS:
1. ER.P Demystifled by Aleris Leon (TMH Pub.)
2. Enterprise Resource Planning by Parag Diwan and Sunil Sharma (Pentageon Pren.)
0 comments:
Post a Comment