Thursday, August 29, 2024
Wednesday, August 28, 2024
Tuesday, August 27, 2024
Sunday, August 25, 2024
Analyzing Code with ChatGPT
I wonder if this approach could augment or replace such things as Profilers or (SQL) Execution Plans.
Saturday, August 24, 2024
Using AI for Software Maintenance
As someone who has used ChatGPT & Copilot for migrating a suite of Spark Streaming applications last year from Java 8 to Java 17, as well as for addressing GitHub Dependabot issues, I can attest to the plausibility of this report:
Friday, August 23, 2024
Data Monetization Estimation
 |
| William Thomson, Lord Kelvin |
"When you can measure what you are speaking
about, and express it in numbers, you know something about it, when you cannot
express it in numbers, your knowledge is of a meager and unsatisfactory kind; it may be
the beginning of knowledge, but you have scarcely, in your thoughts advanced to
the stage of science.”Estimating Data Value
Introduction
Column Value Model
Alternative Models
Data Volume Model
Time Dependent Model
Weighted Schema Model
Lecture on "Electrical Units of Measurement" (3 May 1883), published in Popular Lectures Vol. I, p. 73
Estimating Data Value
Introduction
There has been a lot of interest in data monetization over
the last decade or so and this discussion is meant as a way of thinking about
estimating the potential value of data and in contradistinction to realization
of that value. Think of this as an
analogue of a geological survey without any guarantee of finding economically
viable mines; an attempt at a quantitative analysis of what value data have
along the lines that the late Lord Kelvin had suggested.
Column Value Model
We assume a
company’s value to be a combination of human, physical, and data capital; a
fully automated company with no human resources is a pipedream, a company must
have physical assets to conduct business (be they rented) and must make
decisions based on some information or other.
(For simplicity, Goodwill valuation is excluded from this model).
So we start
with the following formula for the company’s valuation and the proceed to give
an estimate of its data assets in a more defined manner.
Company Valuation = Human Capital + Physical Capital +
Data Capital
Assume all
three parts have the same value and the company’s valuation is $ 3 billion:
Data Capital = Company Valuation/3 = $ 1 Billion
In this
model, we would like to estimate the average value of each column of data in
all the relational schemas that the company uses, i.e.
Let us
further assume that there are 50 relational schemas in this company, that they
each have 50 tables of 20 columns each.
This gives a total of 50,000 columns in total that yields an average
value of $ 20,000 per column. In this
approach, all columns are considered to be of equal value; be they customer
names (let us say) or such ubiquitous columns as “Last Updated Date”.
We can then
proceed to estimate an Average value for each Schema
Alternative Models
Data Volume Model
In this model, the value of each schema is estimated based
on its data volume. That is:
The total Data Valuation will be divided by this number, an average value per Gigabyte is extracted, and the value of each schema is then computed by multiplying its data volume by that average number.
Time Dependent Model
Another model is one with time-dependent variable weights
for value of each part of the company’s valuation, i.e.:
Valuation = h(t) Human Capital + p(t) Physical Capital + d(t)
Data Capital
With
constrains:
h(t) + p(t) + d(t) = 1 and h(t) ≥ 0, p(t) ≥ 0, d(t) ≥ 0
Weighted Schema Model
In this
model, we are capturing the importance of each schema – via the factor a(n) –
and the historical data volume available for each Schema by the second sum and
the factor b(m).
The exp(1-m)
is intended to model the aging and staleness of the data.
Friday, August 9, 2024
3D Printed Houses
From The Daily Telegraph of the UK
The walls of the houses are literally printed by a gigantic machine. (I have reproduced the article below, as it may be behind a pay wall.)
The finished product looks like a prefab house to me, but much sturdier, since the walls are made of concrete!...
___________
Watch: 3D-printer
completes final homes in world’s largest printed neighbourhood
Printing offers a
faster, cheaper and less wasteful way to build new housing
8 August 2024 •
In Texas, a towering
45ft robot is putting the finishing touches on what is thought to be the
world’s largest 3D-printed neighbourhood.
Icon, the developer
behind the project, is printing off its 100th house at Wolf Ranch in Georgetown
this summer, less than two years after kicking off the project.
It takes around three
weeks for work on each home to be completed.
Concrete powder, water,
sand and other additives are mixed together and pumped into a 4.75 tonne
printer called Vulcan.
The mixture is then
piped like icing through a nozzle along a pre-programmed path, layer-by-layer.
The resulting appearance of the walls is likened to corduroy.
Printing off homes in
this way is faster,
cheaper, requires fewer workers and minimises waste, according to the company.
Senior project manager
Conner Jenkins said: “It brings a lot of efficiency to the trade market. Where
there were maybe five different crews coming in to build a wall system, we now
have one crew and one robot delivering that scope. [There’s] the same advantages
for the supply chain system.
“We hope that as we
[consolidate] these different systems, we can bring down volatility in the
housing market.”
Printed homes at Wolf
Ranch are priced from around $450,000 (£353,510) to roughly $600,000. They
range from 1,500 to 2,000 sq ft and consist of either three or four bedrooms in
a single-storey floorplan.
Residents Lawrence
Nourzad and Angela Hontas, who bought a printed home at the ranch earlier this
summer, compared their new house to a “fortress”.
Mr Nourzad said the
walls are solid enough to “go head-on with maybe an F2, F3 tornado and be pretty resilient”. They were praised for keeping the
interior cool in the Texas heat, but criticised for causing connectivity
problems.
Mr Nourzad said: “These
are really strong, thick walls. That’s what provides a lot of value for us as
homeowners. But signal doesn’t transfer through these walls very well.”
The walls are designed
to be resistant to water, mould, termites and extreme weather.
While the walls are
printed, the foundation and metal roof are installed through traditional
construction methods.
For its next project,
Icon has been contracted by Nasa to built shelters and landing pads that are
suitable for the Moon’s surface.
_________
|
|
Watch: 3D-printer completes
final homes in world’s largest printed neighbourhood Printing offers a
faster, cheaper and less wasteful way to build new housing |
Subscribe to:
Posts (Atom)
About Me
- Babak Makkinejad
- I had been a senior software developer working for HP and GM. I am interested in intelligent and scientific computing. I am passionate about computers as enablers for human imagination. The contents of this site are not in any way, shape, or form endorsed, approved, or otherwise authorized by HP, its subsidiaries, or its officers and shareholders.