79 questions
0
votes
1
answer
44
views
theta values for gradient descent not coherent
i made a gradient descent code but it doesnt seem to work well
import numpy as np
from random import randint,random
import matplotlib . pyplot as plt
def calculh(theta, X):
h = 0
h+=theta[0]*X ...
1
vote
0
answers
55
views
mean cost per game in Guided Cost Learning
In this algorithm, which is an implementation of the paper "Guided Cost Learning: Deep Inverse Optimal Control via Policy Optimization" from Chelsea Finn, Sergey Levine and Pieter Abbeel, ...
- 19
0
votes
0
answers
82
views
How can we use costcla package if we have installed python v3.9.7 ? If I degrade python to v3.5 then I hav to change version of tf, cuda and cudnn too
I am working on LSTM model and using cuda and cudnn in tensorflow. CUDA version is 11.2, cuDNN version is 8.1, tf version is 2.5 and python version is 3.9. I have to use costcla library of PyPi but it ...
3
votes
1
answer
529
views
How to optimize the electric vehicle charging cost using Gekko?
from gekko import GEKKO
import numpy as np
import matplotlib.pyplot as plt
m = GEKKO()
m.options.SOLVER = 1
m.options.IMODE = 3
Num_car = 1
TOU = [64.9,64.9,64.9,64.9,64.9,64....
- 31
1
vote
0
answers
59
views
How do you inspect candidate logical plans of cost-based SQL optimizer in spark (scala)?
For a project, I want to find a way to select the top-K resolved logical plans given a SQL query in spark, based on a cost-based optimizer. Is anyone aware of a spark SQL cost-based optimizer that ...
- 11
0
votes
1
answer
246
views
How to add costs to routes in Anylogic?
I am creating a model in Anylogic to simulate the container transportation between a port and the hinterland (in a GIS map). I have data on how many trucks are driving between each customer zone and ...
- 125
1
vote
1
answer
359
views
Oracle Hash Join - Probe Table: Index over Partition?
Both Table P (Parent) and C (Child) have 10 partitions on cat and 316 subpartitions on effective_date.
Table P has the following index create index ix_p_cat on p (cat);.
How is it possible that an ...
- 550
1
vote
2
answers
236
views
Oracle Avoid Wasteful Join Back?
Suppose we have three tables (A, B, and C) as defined in the contrived example below where A and B are related to (have foreign keys in) C.
Suppose, we want values from all three tables and predicate ...
- 550
0
votes
1
answer
135
views
MySql Query optimizer
If I have a query like this
select * from student
inner join courses on courses.id = student.course_id
where student.gpa >= 3.0
order by student.gpa
limit 50;
How would Mysql execute this query ...
- 13
0
votes
1
answer
498
views
Monitoring Cpu, iops and memory on Azure
I want to monitor the cpu/iops/memory usage for my appliation in an azure vm. I need to run it different times for different families to chose the best fit for my app. Should I use Azure monitor or a ...
- 33
0
votes
0
answers
95
views
Cost: calling if vs calling function
I am trying to come up with an optimized solution where I need to loop through 1000's of records in an excel sheet.
I have scenarios like:
if (!lei.renewalDate) {
lei.renewalDate = new Date(...
- 4,391
0
votes
0
answers
191
views
Maximize sum of subset of arrays under given cost
I have an array of n Objects with an int 'value' and another int 'cost'. I want to get the subset of size k (k < n) of that array that maximizes the sum of the values. For instance...
Value - Cost
...
- 11
4
votes
1
answer
100
views
Estimator in Oracle
In Oracle's documentation, for the estimator in optimizer, there is a schema like this:
https://docs.oracle.com/database/121/TGSQL/img/GUID-22630970-B584-41C9-B104-200CEA2F4707-default.gif
Normally, ...
- 921
3
votes
0
answers
409
views
Spark CBO not showing rowcount for queries having partition column in query
I'm working on Spark 2.3.0 using Cost Based Optimizer(CBO) for computing statistics for queries on done on external tables.
I have a created a external table in spark :
CREATE EXTERNAL TABLE IF ...
- 3,790
0
votes
1
answer
147
views
Why Query Cost is So different for same type of Query?
Here is my SQL query in SQL Server 2008.
Three identical queries, with different approaches
Declare @UploadDetailID nvarchar(500) = '62703,62709,67161,67167,74580,76728,76774,76777,89001,116048,...
- 328
0
votes
0
answers
414
views
spark collect columns statistics for a specific partition
How can I tell spark to only collect column statistics for a specific partition?
WARN SparkSqlAstBuilder: Partition specification is ignored when collecting column statistics: PARTITION(myPart='...
- 17.9k
1
vote
1
answer
771
views
Parameter estimates using FME ODE model fitting in R
I have a system of ODE equations that I am trying to fit to generated data, synthetic or lab. The final product I am interested in is the parameter and it's estimated error. We use the R package FME ...
- 53
0
votes
1
answer
788
views
Min cost flow with edge investment cost
I want to use a python Min-Cost Flow solver to be able to construct new networks. This means that I have an initial complete graph, with the vertices being either suppliers or having a demand. Using ...
1
vote
0
answers
77
views
GradientDescentOptimizer is giving less accuracy (~0.10) compared to AdamOptimizer(0.95) in convolutional neural net in Tensorflow
I am building a convolutional neural network for classifying MNIST data. I m using 2 conv layer and 2 fully connected layer.
import tensorflow as tf
from tensorflow.examples.tutorials.mnist import ...
- 21
0
votes
1
answer
811
views
Cost-sensitive loss function in Tensorflow
I'm doing research for cost-sensitive neural network based on Tensorflow. But because of the static graph structure of Tensorflow. Some NN structure couldn't be realized by myself.
My loss function(...
3
votes
1
answer
1k
views
MySql Select - row subtract previous row
I'm trying to extract stats from DB.
Table's structure is:
UpdatedId product_name revenue
980 Product1 1000
975 Product1 950
973 Product1 900
970 Product1 ...
- 159
-2
votes
1
answer
52
views
Is there a way to inform classifiers in R of the relative costs of misclassification? [closed]
This is a general question. Are there classifiers in R -- functions that perform classification implementing classification algorithms-- that accept as input argument the relative cost of ...
- 51
1
vote
4
answers
252
views
Is it better to access several times a value at array[i] or to stock this value in a variable (v=array[i]) and access this variable v instead? [duplicate]
I'd like to know if it costs more to access several times a value at array[i] or to stock the value as a new variable (v=array[i]) and access the variable v several times instead ?
for example (in ...
- 11
0
votes
2
answers
1k
views
Vectorized form Derivation of Multiple Linear Regression Cost Function
Can some one with expertise explain how the following vectorized format of multiple linear regression is derived from given independent variable matrix with intercept X and dependent variable matrix Y,...
- 1,927
1
vote
1
answer
2k
views
How to limit BigQuery query size for testing a query sample through the web user-interface?
I would like to know if it is possible to limit the bigquery query size when running a query through the web user-interface?
My idea is just to test the query but instead of querying all my tables; ...
- 93