Sat Jul 20 23:44:37 2024
EVENTS
 FREE
SOFTWARE
INSTITUTE

POLITICS
JOBS
MEMBERS'
CORNER

MAILING
LIST

NYLXS Mailing Lists and Archives
NYLXS Members have a lot to say and share but we don't keep many secrets. Join the Hangout Mailing List and say your peice.

DATE 2014-09-01

HANGOUT

2024-07-20 | 2024-06-20 | 2024-05-20 | 2024-04-20 | 2024-03-20 | 2024-02-20 | 2024-01-20 | 2023-12-20 | 2023-11-20 | 2023-10-20 | 2023-09-20 | 2023-08-20 | 2023-07-20 | 2023-06-20 | 2023-05-20 | 2023-04-20 | 2023-03-20 | 2023-02-20 | 2023-01-20 | 2022-12-20 | 2022-11-20 | 2022-10-20 | 2022-09-20 | 2022-08-20 | 2022-07-20 | 2022-06-20 | 2022-05-20 | 2022-04-20 | 2022-03-20 | 2022-02-20 | 2022-01-20 | 2021-12-20 | 2021-11-20 | 2021-10-20 | 2021-09-20 | 2021-08-20 | 2021-07-20 | 2021-06-20 | 2021-05-20 | 2021-04-20 | 2021-03-20 | 2021-02-20 | 2021-01-20 | 2020-12-20 | 2020-11-20 | 2020-10-20 | 2020-09-20 | 2020-08-20 | 2020-07-20 | 2020-06-20 | 2020-05-20 | 2020-04-20 | 2020-03-20 | 2020-02-20 | 2020-01-20 | 2019-12-20 | 2019-11-20 | 2019-10-20 | 2019-09-20 | 2019-08-20 | 2019-07-20 | 2019-06-20 | 2019-05-20 | 2019-04-20 | 2019-03-20 | 2019-02-20 | 2019-01-20 | 2018-12-20 | 2018-11-20 | 2018-10-20 | 2018-09-20 | 2018-08-20 | 2018-07-20 | 2018-06-20 | 2018-05-20 | 2018-04-20 | 2018-03-20 | 2018-02-20 | 2018-01-20 | 2017-12-20 | 2017-11-20 | 2017-10-20 | 2017-09-20 | 2017-08-20 | 2017-07-20 | 2017-06-20 | 2017-05-20 | 2017-04-20 | 2017-03-20 | 2017-02-20 | 2017-01-20 | 2016-12-20 | 2016-11-20 | 2016-10-20 | 2016-09-20 | 2016-08-20 | 2016-07-20 | 2016-06-20 | 2016-05-20 | 2016-04-20 | 2016-03-20 | 2016-02-20 | 2016-01-20 | 2015-12-20 | 2015-11-20 | 2015-10-20 | 2015-09-20 | 2015-08-20 | 2015-07-20 | 2015-06-20 | 2015-05-20 | 2015-04-20 | 2015-03-20 | 2015-02-20 | 2015-01-20 | 2014-12-20 | 2014-11-20 | 2014-10-20 | 2014-09-20 | 2014-08-20 | 2014-07-20 | 2014-06-20 | 2014-05-20 | 2014-04-20 | 2014-03-20 | 2014-02-20 | 2014-01-20 | 2013-12-20 | 2013-11-20 | 2013-10-20 | 2013-09-20 | 2013-08-20 | 2013-07-20 | 2013-06-20 | 2013-05-20 | 2013-04-20 | 2013-03-20 | 2013-02-20 | 2013-01-20 | 2012-12-20 | 2012-11-20 | 2012-10-20 | 2012-09-20 | 2012-08-20 | 2012-07-20 | 2012-06-20 | 2012-05-20 | 2012-04-20 | 2012-03-20 | 2012-02-20 | 2012-01-20 | 2011-12-20 | 2011-11-20 | 2011-10-20 | 2011-09-20 | 2011-08-20 | 2011-07-20 | 2011-06-20 | 2011-05-20 | 2011-04-20 | 2011-03-20 | 2011-02-20 | 2011-01-20 | 2010-12-20 | 2010-11-20 | 2010-10-20 | 2010-09-20 | 2010-08-20 | 2010-07-20 | 2010-06-20 | 2010-05-20 | 2010-04-20 | 2010-03-20 | 2010-02-20 | 2010-01-20 | 2009-12-20 | 2009-11-20 | 2009-10-20 | 2009-09-20 | 2009-08-20 | 2009-07-20 | 2009-06-20 | 2009-05-20 | 2009-04-20 | 2009-03-20 | 2009-02-20 | 2009-01-20 | 2008-12-20 | 2008-11-20 | 2008-10-20 | 2008-09-20 | 2008-08-20 | 2008-07-20 | 2008-06-20 | 2008-05-20 | 2008-04-20 | 2008-03-20 | 2008-02-20 | 2008-01-20 | 2007-12-20 | 2007-11-20 | 2007-10-20 | 2007-09-20 | 2007-08-20 | 2007-07-20 | 2007-06-20 | 2007-05-20 | 2007-04-20 | 2007-03-20 | 2007-02-20 | 2007-01-20 | 2006-12-20 | 2006-11-20 | 2006-10-20 | 2006-09-20 | 2006-08-20 | 2006-07-20 | 2006-06-20 | 2006-05-20 | 2006-04-20 | 2006-03-20 | 2006-02-20 | 2006-01-20 | 2005-12-20 | 2005-11-20 | 2005-10-20 | 2005-09-20 | 2005-08-20 | 2005-07-20 | 2005-06-20 | 2005-05-20 | 2005-04-20 | 2005-03-20 | 2005-02-20 | 2005-01-20 | 2004-12-20 | 2004-11-20 | 2004-10-20 | 2004-09-20 | 2004-08-20 | 2004-07-20 | 2004-06-20 | 2004-05-20 | 2004-04-20 | 2004-03-20 | 2004-02-20 | 2004-01-20 | 2003-12-20 | 2003-11-20 | 2003-10-20 | 2003-09-20 | 2003-08-20 | 2003-07-20 | 2003-06-20 | 2003-05-20 | 2003-04-20 | 2003-03-20 | 2003-02-20 | 2003-01-20 | 2002-12-20 | 2002-11-20 | 2002-10-20 | 2002-09-20 | 2002-08-20 | 2002-07-20 | 2002-06-20 | 2002-05-20 | 2002-04-20 | 2002-03-20 | 2002-02-20 | 2002-01-20 | 2001-12-20 | 2001-11-20 | 2001-10-20 | 2001-09-20 | 2001-08-20 | 2001-07-20 | 2001-06-20 | 2001-05-20 | 2001-04-20 | 2001-03-20 | 2001-02-20 | 2001-01-20 | 2000-12-20 | 2000-11-20 | 2000-10-20 | 2000-09-20 | 2000-08-20 | 2000-07-20 | 2000-06-20 | 2000-05-20 | 2000-04-20 | 2000-03-20 | 2000-02-20 | 2000-01-20 | 1999-12-20

Key: Value:

Key: Value:

MESSAGE
DATE 2014-09-07
FROM Ruben Safir
SUBJECT Subject: [NYLXS - HANGOUT] Do you have the magic answer
So in the first week of grad school we are assigned this database book
which, IMO, is so poorly written that it is about worthless. So this is
two of the homework questions. Read my answers very carefully because
otherwise you might miss the entire point of this exercise



1.3. Discuss the main characteristics of the database approach and how
it differs from traditional file systems.

The database approach uses and abstraction layer of the database to
allow for flexible access of data without having to define detailed
storage information within applications. It centralized database access
and promotes use of the data among multiple users. A database approach
to data storage and usage functions to reduce redundancy, improve data
integrity, allows controlled access to multiple users and orchestrates
and facilitates limited and differing views of the data in the
miniworld. It integrates all the users of the database's miniworld into
a single coherent universe of related data. Philosophically, databases
might be evil and the root of much of the worlds problems as it mandate
conformity through autocratic rulemaking and centralizing information,
and now the databases even have their own tiggers, but such musing is
not covered in the textbook.

1.4. What are the responsibilities of the DBA and the database designers?

DBA's help construct databases, and install and maintain the DBMS
software and hardware as needed. They monitor the system and control
user access and permissions.

Database Designers create database designs, schemas and relationships to
data, hopefully to the needs of the miniworld of real people and
organizations for which their proposed database catalogs are supposed to
describe. They have also been known to sprinkle pixie dust all over
staff meetings and then disappear when you need them to explain exactly
what they proposed in the UML mockup when the database administrator is
trying to construct that which they think they designed.

1.5 What are the different types of database end users? Discuss
the main activities of each.

According to the text:

Stand Alone Users who have a moderate level of knowledge of the
backend and programming interface of a database system that they
use.

Causal End Users: Knowledgeable end users who use sophisticated
querying languages for occasional and very individualized views
and manipulation of the database. This would be a high level
personnel who has to access the database for an unforeseen
organizational purpose or some such. This would be, for example,
the type of person who deleted sections of the Nixon White House
Tapes prior to giving them to Congress.

Naive or Parametric Users: This is generally the core audience,
and the workers who daily use of the database in order to
perform an organizations mission. They use canned transactions.

Sophisticated End Users: These are personnel of unusual talent
who can often knowthe dbms as well as you do and might be doing
scientific research, business analysis, engineering et al.



  1. 2014-09-01 Elfen Magix <elfen_magix-at-yahoo.com> Re: [NYLXS - HANGOUT] Math and Computer Sciences
  2. 2014-09-01 Ruben Safir <mrbrklyn-at-panix.com> Re: [NYLXS - HANGOUT] Math and Computer Sciences
  3. 2014-09-02 Ruben Safir <mrbrklyn-at-panix.com> Subject: [NYLXS - HANGOUT] Linux Jobs at CBS
  4. 2014-09-02 Ruben Safir <mrbrklyn-at-panix.com> Subject: [NYLXS - HANGOUT] More Linux Jobs
  5. 2014-09-02 Ruben Safir <mrbrklyn-at-panix.com> Subject: [NYLXS - HANGOUT] I've looked at Clouds from both sides now...
  6. 2014-09-02 Ron Guerin <ron-at-vnetworx.net> Re: [NYLXS - HANGOUT] I've looked at Clouds from both sides now...
  7. 2014-09-02 Ruben Safir <mrbrklyn-at-panix.com> Subject: [NYLXS - HANGOUT] http://wiki.scribus.net/canvas/Get_Started_With_Scribus:1
  8. 2014-09-02 Ruben Safir <mrbrklyn-at-panix.com> Re: [NYLXS - HANGOUT] Ruby groups
  9. 2014-09-03 Ruben Safir <mrbrklyn-at-panix.com> Subject: [NYLXS - HANGOUT] Fwd: Invitation: An Evening with Bjarne Stroustrup
  10. 2014-09-03 Ruben Safir <mrbrklyn-at-panix.com> Subject: [NYLXS - HANGOUT] Fwd: [New discussion] All presentations from YAPC::EU - Sofia, Bulgaria
  11. 2014-09-04 Ruben Safir <mrbrklyn-at-panix.com> Subject: [NYLXS - HANGOUT] weird ruby syntax
  12. 2014-09-04 Ruben Safir <mrbrklyn-at-panix.com> Subject: [NYLXS - HANGOUT] Fwd: Re: [Israel.pm] salsa20 encryption
  13. 2014-09-04 Ruben Safir <mrbrklyn-at-panix.com> Subject: [NYLXS - HANGOUT] mod_perl job
  14. 2014-09-04 Ruben <mrbrklyn-at-panix.com> Subject: [NYLXS - HANGOUT] Fwd: We are currently hiring for a System Administrator!
  15. 2014-09-05 Elfen Magix <elfen_magix-at-yahoo.com> Re: [NYLXS - HANGOUT] http://wiki.scribus.net/canvas/Get_Started_With_Scribus:1
  16. 2014-09-05 Elfen Magix <elfen_magix-at-yahoo.com> Re: [NYLXS - HANGOUT] Math and Computer Sciences
  17. 2014-09-07 Ruben Safir <mrbrklyn-at-panix.com> Subject: [NYLXS - HANGOUT] Anyone want to go to Florida?
  18. 2014-09-07 Ruben Safir <mrbrklyn-at-panix.com> Subject: [NYLXS - HANGOUT] Do you have the magic answer
  19. 2014-09-07 Ruben Safir <mrbrklyn-at-panix.com> Subject: [NYLXS - HANGOUT] Oracle STILL dumb as still
  20. 2014-09-07 Paul Robert Marino <prmarino1-at-gmail.com> Re: [NYLXS - HANGOUT] Oracle STILL dumb as still
  21. 2014-09-07 Paul Robert Marino <prmarino1-at-gmail.com> Re: [NYLXS - HANGOUT] http://wiki.scribus.net/canvas/Get_Started_With_Scribus:1
  22. 2014-09-07 Ruben Safir <mrbrklyn-at-panix.com> Re: [NYLXS - HANGOUT] Oracle STILL dumb as still
  23. 2014-09-07 Ruben Safir <mrbrklyn-at-panix.com> Re: [NYLXS - HANGOUT] http://wiki.scribus.net/canvas/Get_Started_With_Scribus:1
  24. 2014-09-07 eminker-at-gmail.com Re: [NYLXS - HANGOUT] Oracle STILL dumb as still
  25. 2014-09-07 Ron Guerin <ron-at-vnetworx.net> Re: [NYLXS - HANGOUT] http://wiki.scribus.net/canvas/Get_Started_With_Scribus:1
  26. 2014-09-07 Paul Robert Marino <prmarino1-at-gmail.com> Re: [NYLXS - HANGOUT] http://wiki.scribus.net/canvas/Get_Started_With_Scribus:1
  27. 2014-09-07 Ruben Safir <mrbrklyn-at-panix.com> Re: [NYLXS - HANGOUT] http://wiki.scribus.net/canvas/Get_Started_With_Scribus:1
  28. 2014-09-07 Ruben Safir <mrbrklyn-at-panix.com> Re: [NYLXS - HANGOUT] Oracle STILL dumb as still
  29. 2014-09-07 Chris Knadle <Chris.Knadle-at-coredump.us> Re: [NYLXS - HANGOUT] http://wiki.scribus.net/canvas/Get_Started_With_Scribus:1
  30. 2014-09-08 Ruben Safir <mrbrklyn-at-panix.com> Subject: [NYLXS - HANGOUT] Great Lectures
  31. 2014-09-08 Ruben Safir <mrbrklyn-at-panix.com> Subject: [NYLXS - HANGOUT] startup demonstration show
  32. 2014-09-08 Ruben Safir <mrbrklyn-at-panix.com> Re: [NYLXS - HANGOUT] Oracle STILL dumb as still
  33. 2014-09-08 Ruben Safir <mrbrklyn-at-panix.com> Subject: [NYLXS - HANGOUT] Re: Letter of recomendation
  34. 2014-09-08 Ruben Safir <mrbrklyn-at-panix.com> Subject: [christopher.league-at-liu.edu: Re: [NYLXS - HANGOUT] Oracle STILL dumb
  35. 2014-09-09 Ruben Safir <mrbrklyn-at-panix.com> Subject: [NYLXS - HANGOUT] LIU Free Software
  36. 2014-09-12 From: <mrbrklyn-at-panix.com> Subject: [NYLXS - HANGOUT] Advanced linux privacy
  37. 2014-09-14 Ruben Safir <mrbrklyn-at-panix.com> Subject: [NYLXS - HANGOUT] Fwd: realloc limitations
  38. 2014-09-14 Ruben Safir <mrbrklyn-at-panix.com> Subject: [NYLXS - HANGOUT] Fwd: realloc limitations
  39. 2014-09-14 Ruben Safir <mrbrklyn-at-panix.com> Subject: [NYLXS - HANGOUT] Apache Security tips
  40. 2014-09-14 Chris Knadle <Chris.Knadle-at-coredump.us> Re: [NYLXS - HANGOUT] Apache Security tips
  41. 2014-09-15 Ruben Safir <mrbrklyn-at-panix.com> Re: [NYLXS - HANGOUT] Apache Security tips
  42. 2014-09-15 From: "Paul Robert Marino" <prmarino1-at-gmail.com> Re: [NYLXS - HANGOUT] Apache Security tips
  43. 2014-09-15 Ron Guerin <ron-at-vnetworx.net> Re: [NYLXS - HANGOUT] Apache Security tips
  44. 2014-09-15 Chris Knadle <Chris.Knadle-at-coredump.us> Re: [NYLXS - HANGOUT] Apache Security tips
  45. 2014-09-15 einker <eminker-at-gmail.com> Re: [NYLXS - HANGOUT] Apache Security tips
  46. 2014-09-15 Ruben Safir <mrbrklyn-at-panix.com> Subject: [NYLXS - HANGOUT] [ruben-at-mrbrklyn.com: lost directory indexes]
  47. 2014-09-15 Ruben Safir <mrbrklyn-at-panix.com> Subject: [NYLXS - HANGOUT] [ruben-at-mrbrklyn.com: Re: lost directory indexes]
  48. 2014-09-15 Ruben Safir <mrbrklyn-at-panix.com> Re: [NYLXS - HANGOUT] Apache Security tips
  49. 2014-09-15 Ruben Safir <mrbrklyn-at-panix.com> Re: [NYLXS - HANGOUT] Apache Security tips
  50. 2014-09-15 Chris Knadle <Chris.Knadle-at-coredump.us> Re: [NYLXS - HANGOUT] Apache Security tips
  51. 2014-09-15 Ruben Safir <mrbrklyn-at-panix.com> Re: [NYLXS - HANGOUT] Apache Security tips
  52. 2014-09-15 Ruben Safir <mrbrklyn-at-panix.com> Re: [NYLXS - HANGOUT] Apache Security tips
  53. 2014-09-15 From: "Paul Robert Marino" <prmarino1-at-gmail.com> Re: [NYLXS - HANGOUT] Apache Security tips
  54. 2014-09-15 Ron Guerin <ron-at-vnetworx.net> Re: [NYLXS - HANGOUT] Apache Security tips
  55. 2014-09-15 Ruben Safir <mrbrklyn-at-panix.com> Re: [NYLXS - HANGOUT] Apache Security tips
  56. 2014-09-15 Ruben Safir <mrbrklyn-at-panix.com> Subject: [NYLXS - HANGOUT] [ruben-at-mrbrklyn.com: Re: lost directory indexes]
  57. 2014-09-15 From: "Paul Robert Marino" <prmarino1-at-gmail.com> Re: [NYLXS - HANGOUT] Apache Security tips
  58. 2014-09-15 Chris Knadle <Chris.Knadle-at-coredump.us> Re: [NYLXS - HANGOUT] Apache Security tips
  59. 2014-09-15 Ruben Safir <mrbrklyn-at-panix.com> Re: [NYLXS - HANGOUT] Apache Security tips
  60. 2014-09-15 Ruben Safir <mrbrklyn-at-panix.com> Re: [NYLXS - HANGOUT] Apache Security tips
  61. 2014-09-15 Ruben Safir <mrbrklyn-at-panix.com> Subject: [NYLXS - HANGOUT] [ruben-at-mrbrklyn.com: AddHandle perl-script *]
  62. 2014-09-16 Ruben Safir <mrbrklyn-at-panix.com> Subject: [NYLXS - HANGOUT] [ruben-at-mrbrklyn.com: Re: AddHandle perl-script *]
  63. 2014-09-16 Ruben Safir <mrbrklyn-at-panix.com> Re: [NYLXS - HANGOUT] Apache Security tips
  64. 2014-09-16 Ruben Safir <mrbrklyn-at-panix.com> Subject: [NYLXS - HANGOUT] Fwd: Why Life Is A Lot More Fun When We Stop Trying to Be Perfect
  65. 2014-09-16 Elfen Magix <elfen_magix-at-yahoo.com> Subject: [NYLXS - HANGOUT] Medical Update 9/16; Health Scare
  66. 2014-09-17 From: "Paul Robert Marino" <prmarino1-at-gmail.com> Re: [NYLXS - HANGOUT] Apache Security tips
  67. 2014-09-17 Chris Knadle <Chris.Knadle-at-coredump.us> Re: [NYLXS - HANGOUT] Apache Security tips
  68. 2014-09-17 Ruben Safir <mrbrklyn-at-panix.com> Re: [NYLXS - HANGOUT] Apache Security tips
  69. 2014-09-17 Ruben Safir <mrbrklyn-at-panix.com> Re: [NYLXS - HANGOUT] Medical Update 9/16; Health Scare
  70. 2014-09-17 Ruben Safir <mrbrklyn-at-panix.com> Re: [NYLXS - HANGOUT] Apache Security tips
  71. 2014-09-17 Ruben Safir <mrbrklyn-at-panix.com> Subject: [NYLXS - HANGOUT] Binary Calculator
  72. 2014-09-17 Chris Knadle <Chris.Knadle-at-coredump.us> Re: [NYLXS - HANGOUT] Apache Security tips
  73. 2014-09-17 Ruben Safir <mrbrklyn-at-panix.com> Re: [NYLXS - HANGOUT] Apache Security tips
  74. 2014-09-18 Ruben <mrbrklyn-at-panix.com> Subject: [NYLXS - HANGOUT] Fwd: Re: lost directory indexes
  75. 2014-09-19 Ruben Safir <mrbrklyn-at-panix.com> Re: [NYLXS - HANGOUT] Apache Security tips
  76. 2014-09-20 From: <mrbrklyn-at-panix.com> Subject: [NYLXS - HANGOUT] Systemd nightmare
  77. 2014-09-21 Ruben Safir <mrbrklyn-at-panix.com> Subject: [NYLXS - HANGOUT] Fwd: Re: realloc limitations
  78. 2014-09-21 Ruben Safir <mrbrklyn-at-panix.com> Subject: [NYLXS - HANGOUT] Cellular Linux Revolution
  79. 2014-09-21 Ruben Safir <mrbrklyn-at-panix.com> Re: [NYLXS - HANGOUT] Cellular Linux Revolution
  80. 2014-09-22 Ruben Safir <mrbrklyn-at-panix.com> Subject: [NYLXS - HANGOUT] [wietse-at-porcupine.org: Postfix syntax overhaul, snapshot 20140921]
  81. 2014-09-23 Ruben Safir <mrbrklyn-at-panix.com> Subject: [NYLXS - HANGOUT] jboss
  82. 2014-09-23 eminker-at-gmail.com Re: [NYLXS - HANGOUT] jboss
  83. 2014-09-23 eminker-at-gmail.com Re: [NYLXS - HANGOUT] jboss
  84. 2014-09-23 Ruben Safir <mrbrklyn-at-panix.com> Subject: [NYLXS - HANGOUT] New Linux Lite Machines
  85. 2014-09-23 Ruben Safir <mrbrklyn-at-panix.com> Subject: [NYLXS - HANGOUT] more systemd tutorials
  86. 2014-09-23 einker <eminker-at-gmail.com> Re: [NYLXS - HANGOUT] New Linux Lite Machines
  87. 2014-09-23 einker <eminker-at-gmail.com> Re: [NYLXS - HANGOUT] New Linux Lite Machines
  88. 2014-09-23 Ruben Safir <mrbrklyn-at-panix.com> Subject: [NYLXS - HANGOUT] New Puppets?
  89. 2014-09-23 Ruben Safir <mrbrklyn-at-panix.com> Re: [NYLXS - HANGOUT] New Linux Lite Machines
  90. 2014-09-23 Ruben Safir <mrbrklyn-at-panix.com> Subject: [NYLXS - HANGOUT] Radio keeping you to your councel
  91. 2014-09-23 Ruben Safir <mrbrklyn-at-panix.com> Re: [NYLXS - HANGOUT] New Linux Lite Machines
  92. 2014-09-23 Ruben Safir <mrbrklyn-at-panix.com> Subject: [NYLXS - HANGOUT] Negitive binary representations
  93. 2014-09-24 Ruben Safir <mrbrklyn-at-panix.com> Subject: [NYLXS - HANGOUT] Happy Rosh Hashona
  94. 2014-09-24 Ruben Safir <mrbrklyn-at-panix.com> Subject: [NYLXS - HANGOUT] core dump
  95. 2014-09-28 mrbrklyn-at-panix.com Subject: [NYLXS - HANGOUT] [wolfgang-at-rosenauer.org: Re: [opensuse] Running old version]
  96. 2014-09-29 Ruben Safir <mrbrklyn-at-panix.com> Fwd: [NYLXS - HANGOUT] [wolfgang-at-rosenauer.org: Re: [opensuse] Running
  97. 2014-09-30 Ruben Safir <mrbrklyn-at-panix.com> Subject: [NYLXS - HANGOUT] opensuse 13.1
  98. 2014-09-30 einker <eminker-at-gmail.com> Re: [NYLXS - HANGOUT] opensuse 13.1

NYLXS are Do'ers and the first step of Doing is Joining! Join NYLXS and make a difference in your community today!