Coursera: Introduction to Databases Part 1

     Introduction to Databases is taught by Jennifer Widom and hosted by Coursera as a self paced class.  As someone who mainly does front-end developing I feel this class should be very helpful for me to add some new set of skill to my array. I also think this class will help better prepare me later down the road  for my plans to take the SQL certifications. This is article is part of a series of other articles that will be on the class , but this article particularly is about XML, DTD and Json.
    When I first started this article it was a single entity but as I got through more of the class the article was a little more too much for me to maintain as well as keep track of since I went out of order with what the had class. I think the topic that most interested me for this class was learning about triggers. However so far this article is about nothing new but I felt it was important to document. 

XML - eXtensible Markup Language
An alternative to structuring data, similar to html. also has a streaming format. An Implied ordering, self describing schema. 

      Three basic structures
  • Tag
  • Attribute
  • Text
Well-formed XML must follow these rules (along with others):
  • There must be exactly one top level element.
  • All opening tags must be closed.
  • All elements are properly nested i.e., there are no interleaved elements.
  • Attribute values must be enclosed in single or double quotes.
     Parsed XML 
  • DOM - programmatic model for the xml hierarchy 
  • SAX - stream xml model
     Displaying XML
  • XSL - extensible stylesheet language
  • CSS
  • In the XML snippet, the info element has one address subelement and two phone subelements, in that order. Thus, in the DTD the list of components for INFO must include ADDR, ADDR*, ADDR+, or ADDR? followed by PHONE* or PHONE+. Interspersed with these may be any elements that are not required to appear-- that is, any components with a ? or *. Thus, we might also have components like NAME* or MANAGER? at any point in the list.

     Resources
DTD - Document Type Definition
This section was wrapped in with XML but I thought it was important enough to look at separately. 
Grammar-like language for specifying elements, attributes, nesting, ordering, #occurreneces.

      DTD Vs. XSD
  • Pros: for DTD
    • Programs can assume structure, CSS/XSL
    • Specifications - data exchange
    • Documentation
  • Cons: XSD benefits.
    • Flexibility
    • Irregular 
  • A #REQUIRED attribute must appear in every element.
  • An attribute can have types CDATA, ID, or IDREF(S), but not #PCDATA.
  • The incorrect choices (i.e., the snippets that could appear in a DTD), are either optional attributes (#IMPLIED) or are required attributes of a proper type.
  • According to the DTD, an A element has within it one or more B subelements, and then a C element. Within the C element is zero or one B elements followed by exactly one D element. In terms of regular expressions, the tag sequences we can see are:
     Resources
Json - Javascript Object Notation 
Human-readable, useful for data change and serializing data object. Represents   semistructured data.

     Basic constructs (recursive)
  • Values - number, string, boolean
  • Objects - set of label pairs, {}
  • Arrays - []
     Differences from Relational
  • Structure - nested set os arrays
  • Schema- "self -describing" 
  • Queries -  Nothing widely used.(Maybe in the future)
  • Order - Arrays.
  • Implementation - Coupled with Programming languages.
     Json vs. XML
  • XML has more verbosity
  • XML has more  complexity (more information)
  • XML has DTD, XSD and Json has Json Schema for validity.
  • XML is more clunky for Prog. Interface.
  • Querying: (all are very early and not standardized )
    • Json: Json Path, Json Query, JAQL
    • XML: XPath, XQuery, XSLT
     Concepts for Json
  • A complex, irregular, and possibly dynamic structure database needs the flexibility of JSON to be warranted.
  • A database with a fixed structure suggesting relational, but it is in a nested array, list, and label-value structure suggests JSON but either may be suitable.

Popular posts from this blog

Aspetcore: NLog with Postgresql

This Article is base ASP.Net Core 2 and the latest version of Nlog. 1. Install NLog and the Postgresql Package Using NuGet to install the package into your ASP.NET Core project: PM > Install-Package NLog.Web.AspNetCore PM > Install-Package Npgsql 3. Register NLog Add in your Startup.cs  public void Configure ( IApplicationBuilder app, IHostingEnvironment env, ILoggerFactory loggerFactory ) { ... env.ConfigureNLog( "nlog.config" ); ... // make sure Chinese chars don't fk up Encoding.RegisterProvider(CodePagesEncodingProvider.Instance); //add NLog to ASP.NET Core loggerFactory.AddNLog(); //add NLog.Web app.AddNLogWeb(); } 4. Add to Your Controller Add a logger object to your Controller. private readonly ILogger<YourController> _logger; Modify the constructor to use it public YourController ( ILogger<YourController> logger = null ) { if ( null != logger) { _logger = logger; ...
Read more

Mongodb Cheatsheet

This cheat sheet is based on the latest version of mongodb, which initial had setup and didn't encounter any problems. However that all changed when I was working remote and forgot I disabled the port no my network, rather than with the server. So I went pointing around where I didn't need to and ended up messing things up. The Best tutorial out there is of course on digital ocean for my setup on ubuntu 16.04 , this articles isn't so much about getting setup. I just wanted to include it because I found myself looking back at it to see if I missed a step. Bugs/Problems Now comes all the messed up things I found and had to deal with. firewall - Port seems to be open, but connection refused try using 0.0.0.0 in the bin_ip for the /etc/mongo.conf try sudo ufw disable and check to see if it works without the firewall (probably still wont but worth a shot), then just sudo ufw enable. Make sure port 27017 is open. Then check this  linux - Connection refused to MongoDB e...
Read more

Installing Windows on Acer chromebook 15 cb3-532

Much of my notes are just small problems I faced (what's new!) haha. Either way this was a really fun project to do for a friend and I got excited once I research all the information. You can find instruction videos but what helped me the most was the coolstar website. Sadly they don't have parameters in the url so I can link the machine I used in this article. -  https://coolstar.org/chromebook/windows-install.html Scared of messing with the bios? Don't be!    So you need to first remove the screw to put a legacy bios on the machine. Its easy to backup the chrome os one and with the same steps to change it. You can go back in and revert to the chrome version bios. Its that last part that had me worried and its very easy to do.  Problems getting into Developer Mode?   Follow the instructions to the letter, during the step to disable the OS verification, press Ctrl-D to boot into os. If you hear two beeps I would go back to set one. I got in a loo...
Read more