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
What are called multilevel indices? Indices with two or more levels are known as multilevel indices.

Desirable Properties Of Decomposition Decomposition is a process of dividing a relation into its projections that will not be disjoint. Please remind the Relational projection

A domain is a set of permissible values that can be given to an attribute. So each attribute in a table has a definite domain. Values to these attributes cannot be assigned outside

What are the authentication modes in SQL Server? How can it be changed? Windows mode and Mixed Mode - SQL and Windows. To alter authentication mode in SQL Server click Start, P

What is a data dictionary?  A data dictionary is a data structure which keeps Meta data about the structure of the database i.e.  the schema of the database.

What is completeness constraint on generalization? Define the variation between total and partial design constraint. Give an example each.       Ans: Completeness Constraints

What it creates while a primary key is combined with a foreign key? It creates Parent-Child relation ship between the tables that connect them while a primary key is combined w

construct a b-tree for the following set of key values 2,3,5,7,11,17,19,23,29,31.assume that the tree is initial empty and the values are added in ascending order

Define and differentiate between ordered indexing and hashing. Ans: Ordered indexing: To gain fast random access to records in a file, we can make of an index structure. Every

What is a view?  Make a view of EMP table named DEPT 20, to display the employees in department 20 and their annual salary.  Ans:  View is a virtual table that does not consist