-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathBCNF.java
180 lines (163 loc) · 5.14 KB
/
BCNF.java
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
import java.util.*;
public class BCNF {
/**
* Implement your algorithm here
**/
public static Set<AttributeSet> decompose(AttributeSet attributeSet,
Set<FunctionalDependency> functionalDependencies) {
<<<<<<< HEAD
Set<AttributeSet> res = new HashSet<>();
Set<AttributeSet> powerset = remove(powerset(attributeSet));
System.out.println(powerset);
for (AttributeSet i:powerset){
System.out.println(i);
=======
// AttributeSet X = new AttributeSet(attributeSet);
// Set<FunctionalDependency> FD = new HashSet<FunctionalDependency>(functionalDependencies);
Set<AttributeSet> res = new HashSet<>();
Set<AttributeSet> powerset = powerset(attributeSet);
// Set<AttributeSet> powerset = new HashSet<>();
// for (AttributeSet mama : powersettemp){
// AttributeSet temp22 = new AttributeSet();
// for (Attribute ele : mama.transferToList()){
// if (!ele.toString().isEmpty()){
// temp22.addAttribute(ele);
// }
// }
// powerset.add(temp22);
//
// }
for (AttributeSet i:powerset){
>>>>>>> 53d71a355a2c9e7ecbdac71628eca762aa22f824
AttributeSet clos = closure(i,functionalDependencies);
AttributeSet closs = new AttributeSet();
for (Attribute j:clos.transferToList()){
if (attributeSet.contains(j)) closs.addAttribute(j);
}
<<<<<<< HEAD
System.out.println(closs);
=======
>>>>>>> 53d71a355a2c9e7ecbdac71628eca762aa22f824
//clos = closs;
if (i.equals(closs) || closs.equals(attributeSet)) {
continue;
}
List<Attribute> restpart1 = new ArrayList<>(i.transferToList());
for (Attribute xx:attributeSet.transferToList()){
if (!closs.contains(xx)){
restpart1.add(xx);
}
}
AttributeSet rest = new AttributeSet(restpart1);
<<<<<<< HEAD
System.out.println(rest);
=======
>>>>>>> 53d71a355a2c9e7ecbdac71628eca762aa22f824
res.addAll(decompose(closs,functionalDependencies));
res.addAll(decompose(rest,functionalDependencies));
return res;
}
res.add(attributeSet);
return res;
}
/**
* Recommended helper method
**/
public static AttributeSet closure(AttributeSet attributeSet, Set<FunctionalDependency> functionalDependencies) {
// TODO: implement me!
AttributeSet update = new AttributeSet(attributeSet);
AttributeSet newdep = new AttributeSet(attributeSet);
HashMap<String,Integer> count = new HashMap<>();
HashMap<String,Set<FunctionalDependency>> list = new HashMap<>();
for (FunctionalDependency fd : functionalDependencies){
count.put(fd.toString(), fd.getindependent().size());
Iterator<Attribute> As = fd.getindependent().iterator();
while (As.hasNext()){
Attribute A = As.next();
if (!list.containsKey(A.toString())){
Set<FunctionalDependency> tempset = new HashSet<>();
tempset.add(fd);
list.put(A.toString(),tempset);
}
else{
list.get(A.toString()).add(fd);
}
}
while (update.size() != 0){
Attribute tempA = update.transferToList().get(0);
update.transferToList().remove(0);
if (list.containsKey(tempA.toString())){
Set<FunctionalDependency> miao= list.get(tempA.toString());
for (FunctionalDependency tempX : miao){
int minus1 = count.get(tempX.toString()) -1;
count.put(tempX.toString(), minus1);
if (minus1 == 0){
AttributeSet dependX = tempX.dependent();
AttributeSet add = new AttributeSet();
for (Attribute xx : dependX.transferToList()){
if (!newdep.transferToList().contains(xx)){
add.addAttribute(xx);
}
}
for (Attribute xx2 : add.transferToList()){
update.addAttribute(xx2);
newdep.addAttribute(xx2);
}
}
}
}
}
}
return newdep;
}
public static Set<AttributeSet> powerset(AttributeSet attributeSet){
Set<AttributeSet> sets = new HashSet<>();
if (attributeSet.size()==0){
sets.add(new AttributeSet(attributeSet));
return sets;
}
List<Attribute> list = new ArrayList<>(attributeSet.transferToList());
Attribute head = list.get(0);
AttributeSet rest = new AttributeSet(list.subList(1, list.size()));
for (AttributeSet temp:powerset(rest)){
<<<<<<< HEAD
// System.out.println(temp);
=======
>>>>>>> 53d71a355a2c9e7ecbdac71628eca762aa22f824
AttributeSet newSet = new AttributeSet();
newSet.addAttribute(head);
Iterator<Attribute> tt2 = temp.iterator();
while (tt2.hasNext()) newSet.addAttribute(tt2.next());
sets.add(newSet);
<<<<<<< HEAD
// System.out.println(sets);
sets.add(temp);
// System.out.println(sets);
}
return sets;
}
public static Set<AttributeSet> remove (Set<AttributeSet> powerset){
Iterator<AttributeSet> poiter = powerset.iterator();
Set<AttributeSet> newres = new HashSet<>();
while (poiter.hasNext()){
AttributeSet next = poiter.next();
if (!next.isEmpty()) newres.add(next);
}
return newres;
}
public static void main(String args[]){
BCNF a = new BCNF();
AttributeSet attrs = new AttributeSet();
attrs.addAttribute(new Attribute("a"));
attrs.addAttribute(new Attribute("b"));
attrs.addAttribute(new Attribute("c"));
System.out.println(remove(a.powerset(attrs)));
}
}
=======
sets.add(temp);
}
return sets;
}
}
>>>>>>> 53d71a355a2c9e7ecbdac71628eca762aa22f824