Scope of traffic data management, Database Management System

Assignment Help:

A TDMS project plan is not a typical Information Technology project plan; therefore, a traffic data project has several unique characteristics:

  • Traffic data management systems project's objectives are by and large defined in general statements. It is significant that the requirements for the traffic data developments are not be very explicit. If they are very definite, they may affect the way the traffic data project is designed, to the point of "not including" factors that seems unrelated but may be key to the analysis being carried out.
  • One of the major reasons for describing the scope of the project is to avoid invariable change throughout the life cycle as new requisites occur.
  • The key purpose of the TDMS project is for data analysis but not to muddle up operational objectives with the traffic data project's informational objectives.

The project will be developed in Oracle in all aspects. The Oracle 10g Database's Enterprise Edition will be used for the server. For development of ETL, and metadata repository Oracle 10g Warehouse Builder will be used. Report builder or discoverer will be used to create the reports that will be available using any web browser. The system will also be responsible for the data to clean on a regular basis. The operational data will be held in transaction-based systems with some function like equipment basic data, management and staff current data. Audit trial will also be managed.

When tables are created there will be some advanced indexing techniques will be used which will improve the data retrieval and overall performance of the system. Some views are to be created for the purpose of the enhancing the performance of the data.


Related Discussions:- Scope of traffic data management

Design a query plan for distributed query, (a) Design a query plan for the ...

(a) Design a query plan for the following distributed query: An application at site B wants to compute a join of STUDENT ? Id=StudId TRANSCRIPT where STUDENT (Id,Major) is at site

Create an entity relationship diagram, Cyber Transit Ltd keeps up-to-date i...

Cyber Transit Ltd keeps up-to-date information on the processing and current position of each dispatched item. Dispatched items are the main concern of the Cyber Transit product tr

View serialiabilty-labelled precedence graph, how to construct labelled pre...

how to construct labelled precedence graph for view serialiability.please explain insteps with one solved examples

Queries, Write a query that display ename annual salary and comm from emp t...

Write a query that display ename annual salary and comm from emp table

Can a filed occur in several field groups, Can a filed occur in several fie...

Can a filed occur in several field groups. Yes.  But it leads to redundant data redundancy.

What is system catalog or catalog relation, What is system catalog or catal...

What is system catalog or catalog relation? How is better known as? A RDBMS maintains a explanation of all the data that it contains, information about every relation and index

Example on relational database schema, Question: The following relation...

Question: The following relational database schema corresponds to a part of a database used by the Registry Department of a university. DEPARTMENT (d#, d-name, head-of-dept)

Improved performance, Improved performance: As the data is located near the...

Improved performance: As the data is located near the site of its demand, and given the inherent parallelism because of multiple copies, speed of database access may be good for di

Architectural standard, Architectural standard: Designation : Archit...

Architectural standard: Designation : Architect , Consultant Job Profile : As a part of Oracle Fusion Middleware at Satyam, I am involved with Presales, Delivery, A

Describe the host language, Describe the host language? Host Language:...

Describe the host language? Host Language: You could write applications along with SQL statements embedded inside a host language. The SQL statements give the database inter

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd