Follow Slashdot blog updates by subscribing to our blog RSS feed

 



Forgot your password?
typodupeerror

Comment Let it go (Score 1) 582

If things get bad enough for infrastructure such as digital phone and data to go offline then we've got greater problems that POTS couldn't handle anyway. If maintaining POTS is slowing adoption of faster internet infrastructure then it should go. It was fun and I have fond memories of modem connection sounds but... the 1K chunks of files coming over were excruciating to endure.

Fiber Optic right to the home firewall/router is what I'd like to see.

Comment Re:I don't think encoding/decoding are fundamental (Score 0) 182

I used to adhere to the Theory of Entropy. Made sense at the time kinda like the flat world and Earth being the center of everything.

With a greater understanding of Physics and Cosmology, I've come to realize that the Earth is not flat nor the center of everything. With the realization that Energy is neither created nor destroyed only converted - the Theory of Entropy is disrupted in my mind and therefore proven false.

Now, discounting Entropy doesn't mean I deny that systems have a tendency to reach a Steady State where a perceived equilibrium has been established.

Comment Re:Well, I have a theory (Score 1) 182

To me, there are only four primary dimensions.

Length, Width, Height and Time.

The L*W*H dimensions ARE space. No need for a space dimension.

Time is a measurement used to delineate Frames.

I would say, do not limit yourself to only thinking in 2 dimensions as you cannot live in them. It takes 3. I will say that it also takes a bit more thought to see the world or understand it in 3 dimensions. One should try.

Comment Universe does compute - per se. (Score 1) 182

I think whether or not the Universe computes is relative.

What is it you're trying to compute? If you are trying to compute the dynamics of the Universe then the Universe does compute. It computes itself better than any other model.

If you are talking about abstractions then probably computers do very well give proper instruction and dataset.

To get a computer to compute the universe is like trying to force a very large round peg into a very small square hole.

Comment Re:Learn some terminology (Score 1) 106

You are correct. Access in it's simplest form is NOT a true database in that it is not a first class server of data per se. It can be used in a multi-user fashion though. You have multiple users running Access and a client program which is linked to a common Access database file on the network. All the intelligence except for data validation is implemented in the client. Back in the old days (the 90's), Access did not have row-locking but locked chunks of the database. Concurrency was a major issue and required code to bulldoze it's way into a record pessimistic lock so it could store data without stomping on someone else's update. The trick was to pad out the chuck to be one record in size. Wasteful of space but good for performance. These days, the ability to lock an actual row means less space wasted in the database - potentially saving gigabytes in a table with millions of records.

Access is more a Swiss Army Knife type of user database tool than a mission critical system. I wouldn't dream of using it for anything but data analysis of smaller sets of data, reporting and prototyping of client frontsides.

Comment Database efficiency considerations (Score 1) 106

Let's see - proper RDBMS considerations:
Proper normalization of data
Efficient keying for relating data. Compound keys can be difficult to work with.
Use of simplest possible recordset type for working with data.
Understanding of boolean logic and sets. Needful for creating efficient SQL queries.
Understanding of a particular RDBMS's optimization techniques/order of operations.
Data validation to prevent GIGO.
Record locking schemes to prevent inconsistent updates - transactions should be used to minimize impact.
Learn those things which your chosen RDBMS does NOT do well and find a way to optimize or work around them.

Comment Re:what keeps us from switching ? (Score 2) 372

I'd call SQL a special purpose language designed for managing relational databases.

Technically, plopez is correct. SQL is the scripting language, with version differences between implementations, to the native interface for a particular RDBMS. Many RDBMS provide access to that native interface bypassing SQL.

Slashdot Top Deals

Interchangeable parts won't.

Working...