Scope of traffic data management, Database Management System

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.

Posted Date: 3/18/2013 2:42:00 AM | Location : United States

Related Discussions:- Scope of traffic data management, Assignment Help, Ask Question on Scope of traffic data management, Get Answer, Expert's Help, Scope of traffic data management Discussions

Write discussion on Scope of traffic data management
Your posts are moderated
Related Questions
One-to-many : An entity in A is related with any number of entities in B. An entity in B is related with at the most one entity in A. Example: Relationship between faculty and d

List the set operations of SQL? 1) Union 2) Intersect operation 3) The except operation

Distributed And Client Server Databases Introduction This unit tells the distributed database systems which are primarily relational and one important execution model: the

Differentiate between a unique key and a primary key. - By default, clustered index on column are created by primary key while nonclustered index are created by unique key.

1) Define a job scheduling strategy that will meet business requirement of reporting availability by 6am CST for the following cubes? Show the job scheduling dependencies in a pict

Ask q“A database will be made to store information about patients in a hospital. On arrival, each patient’s personal details (name, address, and telephone number) are recorded wher

This constraint shows that the key attribute value in each tuple must be unique, i.e., no two tuples have the similar value for the key attribute. This is because the value of the

In the architecture of a database system which external level used? In the architecture of a database system view external level used.

Using the questions found at the end of Chapter 9 in your textbook, complete this homework activity. Students will submit a Word document answering questions 2, 3, and 4.