Package ch.epfl.lbd.database.objects

Examples of ch.epfl.lbd.database.objects.RelationalTable.loadObject()

42
43
44
45
46
47
48
49
50
51
52
     
      RelationalTable fact = new RelationalTable(tableName_fact,columns_fact);
      RelationalTable spaceDimension = new RelationalTable(tableName_space_dim,columns_space_dim);

      //load the tables used to create dimensions and cubes
      spaceDimension.loadObject(connection);
      fact.loadObject(connection);
     
      //TODO: load data inside table using FileReader and RelationalTable classes

      RelationalTable episodeFacts   = new RelationalTable("trdw_episode_facts");
View Full Code Here
50
51
52
53
54
55
56
57
58
59
60
      //TODO: load data inside table using FileReader and RelationalTable classes

      RelationalTable episodeFacts   = new RelationalTable("trdw_episode_facts");
     
      spaceDimension.loadObject(connection);
      episodeFacts.loadObject(connection);
     
      //define the space dimension
     
      Level environmentLvl = new MondrianLevel("Environment",spaceDimension,"environment_name");
      LevelProperty envNameProp = new MondrianLevelProperty(  "Environment Name",
View Full Code Here
48
49
50
51
52
53
54
55
56
57
58
    destinationConnection.openConnection();
   
    //LOAD TABLES
    source.loadObject(sourceConnection);
    destination.setTypes(source.getTypes());
    destination.loadObject(destinationConnection);
   
    double size = source.size();
    logger.info("source table size is "+size);
   
    logger.info("populating destination table");
View Full Code Here
36
37
38
39
40
41
42
43
44
45
46
    destinationConnection.openConnection();
   
    //LOAD TABLES
    source.loadObject(sourceConnection);
    destination.setTypes(source.getTypes());
    destination.loadObject(destinationConnection);
   
    double size = source.size();
    logger.info("source table size is "+size);
   
    logger.info("populating destination table");
View Full Code Here
25
26
27
28
29
30
31
32
33
34
35
    //RelationalTable table = new RelationalTable(tableName,columns);
    RelationalTable table = new RelationalTable(tableName);

    OracleConnection connection = new OracleConnection("src/connections.properties","connection1");
    connection.openConnection();
    table.loadObject(connection);
   
    logger.info("table size is "+table.size());
   
    for(int count = 0 ; count < ROWS_TO_FETCH ; count ++ ){
      Object[] data = table.getNextRow();
View Full Code Here
44
45
46
47
48
49
50
51
52
53
54
    String[] columns2 = {"NAME","TIMEDATE","VALUE"};
    String tableName2 = "TEST";
   
    RelationalTable table2 = new RelationalTable(tableName2,columns2);
    table2.setForced(true);
    table2.loadObject(connection);
    Object[] values = new Object[3];
    values[0] = "name1";
    DateFormat formatter = new SimpleDateFormat("yyyy.MM.dd.HH.mm.ss");
        Date date = (Date)formatter.parse("2002.01.29.08.36.33");
View Full Code Here
32
33
34
35
36
37
38
39
40
41
42
   
    RelationalTable facts = new RelationalTable("trdw_episode_facts");
    RelationalTable spaceDimension = new RelationalTable("trdw_space_dimension");
   
    facts.loadObject(connection);
    spaceDimension.loadObject(connection);
       
    openTables.add(spaceDimension);
    openTables.add(facts);
   
    PresenceCube presenceCube = new PresenceCube(facts);
View Full Code Here
26
27
28
29
30
31
32
33
34
35
36
      OracleDataWarehouse dw = new OracleDataWarehouse("SIMONE","DW_2");
      dw.loadObject(connection);
     
      //create oracle dimension
      RelationalTable timeDimension = new RelationalTable("TIMEDIMENSIONTEST");
      timeDimension.loadObject(connection);
     
      OracleLevel yearLevel = new OracleLevel("YEAR 3",timeDimension,"YEAR");
      yearLevel.setDescription("the year of shipment");
      OracleLevel monthLevel = new OracleLevel("MONTH 3",timeDimension,"MONTH");
      monthLevel.setDescription("the month of shipment");
View Full Code Here
25
26
27
28
29
30
31
32
33
34
35
      //opening the database connection
      connection.openConnection();
     
      RelationalTable timeDimension = new RelationalTable("trdw_time_dimension");
     
      timeDimension.loadObject(connection);
     
      Level yearLevel = new MondrianLevel("Year",timeDimension,"year");
      LevelProperty timeStamp = new MondrianLevelProperty("TimeStamp",LevelProperty.TYPE_TIMESTAMP,timeDimension,"timestamp");
      yearLevel.addProperty(timeStamp);
     
View Full Code Here
36
37
38
39
40
41
42
43
44
45
46
     
      RelationalTable spaceDimension   = new RelationalTable("trdw_space_dimension");
      RelationalTable episodeFacts   = new RelationalTable("trdw_episode_facts");
     
      spaceDimension.loadObject(connection);
      episodeFacts.loadObject(connection);
     
      //define the space dimension
     
      Level environmentLvl = new MondrianLevel("Environment",spaceDimension,"environment_name");
      LevelProperty envNameProp = new MondrianLevelProperty(  "Environment Name",
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.