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

Define ssn of salesman by using database of business trips, Consider the su...

Consider the subsequent relations for a database which keeps track of business trips of salespersons in a sales office: SALESPERSON (SSN, Name, start_year, Dept_no) TRIP (SSN, Fr

Database models, why are older data models are being replaced by new data m...

why are older data models are being replaced by new data models

Differentiate between various levels of data abstraction, Differentiate bet...

Differentiate between various levels of data abstraction? Data Abstraction - Abstraction is the procedure to hide the irrelevant things from the users and represent the rele

Express types of information available in mysql, Express types of informati...

Express types of information available in MySQL? Information as regards the result of queries:  This includes number of records affected by any SELECT or UPDATE or DELETE st

State the meaning of self-transition, What is self-transition? ...

What is self-transition? If there is a transition which goes back to same state, it is known as "self- transition." With a trigger action exit action would be executed f

Define data conversion, Define data conversion? Helpful to load data in...

Define data conversion? Helpful to load data into temporary staging tables. Then can write SQL code to do much of data processing. SQL code is simpler and faster to write than

Data analyzing and desing, Critically explained the benefits and limit...

Critically explained the benefits and limitations of different database technologies with proper examples

Improve efficiency in query evaluation, Question: AirwaysCentre, an int...

Question: AirwaysCentre, an international airline booking company currently uses a relational database system for their operations, which includes the following relations: P

What are advantages of using an index and disadvantages, What are the advan...

What are the advantages of by using an index and what are its disadvantages ? In difference, if the search key of a secondary index is not a candidate key, it is not sufficient

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