A novel approach for intelligent distribution of data warehouses

Data Storing in Intelligent and Distributed Data Warehouse using Unique Identification Number

“…The purpose of other columns in modified Common table i.e., second column to the last column is same, as discussed in [1]. In a nutshell, from a row of Common table shown in Figure 1 the Location Name in each level of a hierarchy of IDDW and the generated UIN corresponding Location Name is obtained.…”

“…Such users enter the Location Name in only those text boxes and rests are left blanked. For both type of users a unique ID consisting of number of digits [1] is auto-generated serially at the level of IDDW. The Location ID is generated for each Location Name entered by user in the text boxes, respectively.…”

“…The 8-Level hierarchal structure is shown again in Figure 10. The number of levels and name of each level is same in both the 8-Level hierarchal structure shown in the [1] and Figure 10. The number of levels is 8 and their names from top are as Y for Year, S for State, U for University, I for Institute, D for Department, C for Category, P for Position and ID for Unique id, respectively.…”

“…IDDW is a -Level hierarchal distributed data warehouse proposed in [1]. In this paper an efficient approach of data storage in IDDW is proposed.…”

“…The data is entered by the user and stored in the Common table of located data warehouse in IDDW. The proposed approach requires the restructuring of a Common table previously used in IDDW [1]. The various other modules are also needed in the proposed approach each of which are designed and implemented.…”