Saturday, October 26, 2013

Site Update

1. Quote of the Week
Can any one guide me, how to search specific value in all database table? in output we required tables and columns name.

2. To Laugh or Cry?
Go On, Live a Little. Denormalize Your Data

3. Online

My October post @All Analytics
Big Data Uber Alles
A follow-up exchange to previous exchanges on my post E/RM Is Not a Data Model.
What is a Data Model And which “Data Model” do you prefer
My own follow-up is forthcoming here.

4. I've done some house cleaning and found some links that I accumulated at various points in time that I deemed worth reading, but which fell victims to lack of time. They may be interesting or useful to others, so I list them here.

On relational technology:

5. And now for something completely different: the wastebasket and the barber.

Sunday, October 20, 2013

SQL Server, Relational Databases and Primary Keys

I attended a presentation so named by Ami Levin hosted by the local SQL Server user group for three reasons: as the author of A Matter of Identity: Keys--a chapter in my book PRACTICAL CONCEPTS IN DATABASE MANAGMENT--and numerous articles on the subject, including on this site; interest in presentations on data fundamentals, let alone relational ones, that are extremely rare and usually flawed; and curiosity how fundamentals are presented by product specialists, particularly when the state of foundation knowledge is poor. What follows are my observations, thoughts and quibbles, in the order in which they came up in the presentation.

Saturday, October 12, 2013

Site Update

1. Quote of the Week
... MongoDB, or RavenDB ... are excellent for non-relational, loose schema databases. Databases always have schemas, the data is the schema, inherently in dbs like Raven & Mongo.

2. To Laugh or Cry?
Easy Steps to a Complete Understanding of SQL

3.  Three online exchanges on my E/RM post in which in participated.
Entity-Relationship Model Not a Data Model
Entity-Relationship Model Not a Data Model
Entity-Relationship Model Not a Data Model
The last one is an excellent validation that many data professionals erroneously believe they know and understand the RM--which prevents them from appreciating its value and doing something about it. It also demonstrates that schooling is not education.

I may tackle some of the comments in a future post.

4.  How much would you bet against my suspicion that there is little/superficial, if any, relational
background to this?
SQL Database for Beginners
6.  And now for something completely different

 From article on Marissa Meyer:
They say her obsession with the user experience masks a disdain for the money-making side of the technology industry. There is some truth to what they say ... Mayer joined Google as a programmer and rose to become the executive in charge of the way Google search and many other popular Google products looked to web users ... She obsessed over pixels; their hue, shade, and placement. She co-authored a handful of patents, including an important one for Google: "Graphical user interface for a universal search engine." By 2005, Mayer moved into management, overseeing the look and feel of Google's most important products ... But being in charge of how Google products should look, Mayer's job was, basically, to relate with Google's millions of users. How would she do that? ... The first is that she would recreate the technological circumstances of her users in her own life. ...  Mayer's second method was to lean on data. She would track, survey, and measure every user interaction with Google products, and then use that data to design and re-design.
Wow, and after all this the user interface of all Google's online services sucks, they are buggy and there is practically no user support? Imagine what will happen without Marissa Meyer there!

And, oh, the cultural sophistication of the technology elite. Helps understand their output.
2013 Tour de Coop Chickens, Beehives & Homesteads Silicon Valley Funcheap