Browsing articles tagged with " NoSQL"

Tutorial: 7 Databases in 170 Minutes – NoSQL Now!

Apr 17, 2016   //   by Karen Lopez   //    //  No Comments

NoSQLNow logo

Level: Intermediate
We’ve been busy keeping relational data consistent, high quality, and available. But over the last few years, new database and datastore technologies have come to the enterprise with different data stories. Do we need all our data to be consistent everywhere? What does data quality mean for analytics? Will we need relational databases?Learn how traditional and new database technologies fit in a modern data architecture. We will talk about the underlying concepts and terminology such as CAP, ACID and BASE and how they form the basis of evaluating each of the categories of databases. Learn about graph, Hadoop, relational, key value, document, columnar, and column family databases and how and when they should be considered. We’ll show you demos of each.

Finally, we will wrap up with 7+ tips for working with new hybrid data architectures: tools, techniques and standards.

Use code ‘DATACHICK’ to save $50 to $200 on registration.

 

Panel: Will the DBA Job of the Future Still Involve DBAs? – SQL Saturday Huntington Beach

Apr 2, 2016   //   by Karen Lopez   //    //  No Comments

SQL Saturday HB logo

Although technologies have been changing rapidly since the creation of databases, the basic tasks that a database administrator (DBA) has performed have been a stable foundation of professional database design and support. But now NoSQL technologies, the cloud, and new SQL Server features are affecting DBA jobs, tasks, and careers.

Our panel of SQL Server experts share their current experiences in the data profession. They share what they believe you should be working towards now and in the future.

7 Databases in 170 Minutes: Workshop at NoSQLNow!

Jan 26, 2016   //   by Karen Lopez   //   Blog, Database, Database Design, DLBlog, Events, NoSQL, Speaking, Training  //  No Comments

image

My friend Joey D’Antoni ( @jdanton | blog ) and I will be giving a workshop at NoSQLNow! about new database and datastore technologies like Hadoop, Neo4j, Cassandra, Vertica, Document DB, and others.  This will be a fast-paced, demo-heavy, practical sessions for data professionals.  We’ll talk about where a modern data architecture would best use these technologies and why it’s not an either/or question for relational solutions in a successful enterprise. And, as always, our goal is to make the time we spend fun and interactive.   This session will be a great starting point for some other session on Monday that go into data modeling for NoSQL as well as for all the other in-depth, database-specific talks the rest of the week.

Sunday, April 17, 2016
Level:
Intermediate

imageWe’ve been busy keeping relational data consistent, high quality, and available. But over the last few years, new database and datastore technologies have come to the enterprise with different data stories. Do we need all our data to be consistent everywhere? What does data quality mean for analytics? Will we need relational database?

Learn how traditional and new database technologies fit in a modern data architecture. We will talk about the underlying concepts and terminology such as CAP, ACID and BASE and how they form the basis of evaluating each of the categories of databases. Learn about graph, Hadoop, relational, key value, document, columnar, and column family databases and how and when they should be considered. We’ll show you demos of each.

Finally, we will wrap up with 7+ tips for working with new hybrid data architectures: tools, techniques and standards.

 REGISTER

Use code “DATACHICK” to save:

$100 off for  Tutorials Only + Seminar Only Registration and $200 off for Full Event, Conference+Tutorials, Conference +Seminar, and Conference Only Registration.

Super early registration ends 29 January, so take advantage of both discounts now (yes, they stack!).

Yeah My Mama She Told Me Don’t Worry About Your JOINs

Dec 5, 2014   //   by Karen Lopez   //   Awesome, Blog, Data, Fun, NoSQL, Parody, Snark, WTF  //  1 Comment

BarbieBoutTheDataMed

(with apologies to Meghan Trainor)

Because you know
I’m all about the data
‘Bout the data, no trouble
I’m all about the data
‘Bout the data, no trouble
I’m all about the data
‘Bout the data, no trouble
I’m all about the data
‘Bout the data

Yeah, it’s pretty clear, I ain’t NoSQL
But I can love it, love it
Like I’m supposed to do
‘Cause I still got zoom zoom that in the database
With all the right facts in all the right places

I see the newbies are workin’ that drawing slop
We know that shit ain’t real
C’mon now, make it stop
If you got data models, just raise ’em up
‘Cause a Zachman Framework is perfect
From the bottom to the top

Yeah, my mama she told me don’t worry about your joins
She says, “Data likes a little quality to keep it right.”
You know I won’t be no schemafree denormal Barbie doll
So if that’s what you’re into then go ahead and move along

Because you know I’m
All about the data
‘Bout the data, no trouble
I’m all about the data
‘Bout the data, no trouble
I’m all about the data
‘Bout the data, no trouble
I’m all about the data
‘Bout the data
Hey!

BarbieIT

I’m bringing quality facts
Go ahead and tell polyschematics that
Normalized data, I know you think it’s slow
But I’m here to tell ya
Transactional data’s perfect from the bottom to the top

Yeah my mama she told me don’t worry about your joins
She says, “Data likes a little quality to keep it right.”
You know I won’t be no schemafree denormal Barbie doll
If eventual consistency’s your thing then move along

Because you know I’m
All about the data
‘Bout the data, no trouble
I’m all about the data
‘Bout the data, no trouble
I’m all about the data
‘Bout the data, no trouble
I’m all about the data
‘Bout the data

Because you know I’m
All about the data
‘Bout the data, no trouble
I’m all about the data
‘Bout the data, no trouble
I’m all about the data
‘Bout the data, no trouble
I’m all about the data
‘Bout the data

Because you know I’m
All about the data
‘Bout the data, no trouble
I’m all about the data
‘Bout the data, no trouble
I’m all about the data
‘Bout the data, no trouble
I’m all about the data
‘Bout the data
‘Bout the data, ’bout the data
Hey, hey, ooh
You know you love the data

Barbie 2010-12-30 002

Big Data, NoSQL and Data Modeling: Big Challenges in Data Modeling

Jun 24, 2014   //   by Karen Lopez   //   Blog, Data, Data Modeling, Database, Database Design, Events, NoSQL, Speaking  //  1 Comment

Database table

Big data and NoSQL have led to big changes In the data environment, but are they all in the best interest of data? Are they technologies that "free us from the harsh limitations of relational databases?" as I recently blogged about at Dataversity.net?

In this month’s webinar (register now), we will be answering questions like these, plus:

  • Have we managed to free organizations from having to do data modeling?
  • Is there a need for a data modeler on NoSQL projects?
  • If we build data models, which types will work?
  • If we build data models, how will they be used?
  • If we build data models, when will they be used?
  • Who will use data models?
  • Where does data quality happen?
  • Are there NoSQL technologies for which data modeling will never apply?

Finally, we will wrap with 10 tips for data modelers in organizations incorporating NoSQL in their modern data architectures.

Join NoSQL expert extraordinaire Dan McCreary ( blog ) and others (including YOU!) as we talk about the future of data modeling and data modelers this Thursday, 26 June, at 2PM EDT.

We’ll also have some prizes to give a way, so plan on attending live.

 

(BTW, don’t get me started on the lame modeling styles/naming standards in stock photography.  Maybe I should start making some for Getty Images?)

SQL Server 2014: New Datatype

Apr 1, 2014   //   by Karen Lopez   //   Blog, Data Modeling, Database Design, DLBlog, Fun, Parody, Snark, Space, SQL Server, WTF  //  18 Comments

image

Today is the general availability release date for the newest version of SQL Server, aptly named SQL Server 2014.  I’m excited about many of the new features being rolled out today, but the ones that will impact data architects, modelers and database designers are the new datatypes that will be introduced.  But first, for those of you who have their heads stuck in the deep piping and spit-managing of databases, some background about datatypes:

A datatype is a categorization of data items, based on the range and types of data that it can contain and a set of actions that can be validly taken against that data.

As such, applying a datatype to a column in a database makes it work as another type of constraint.  A tinyint column can’t hold my Starbucks name (Kitty) because it constrains the values to integers and only a subset of all integers, for example.

The number and type of datatypes (yes, I’m being meta there) varies depending on the strength and quality of the tequila the DBMS product management teams were drinking at their last Vegas Blow Out team building retreat, as called for in the ISO Standards for databases, AKA

ISO/IEC JTC 1/SC 32 – Data management and interchange.  

One of the things that developers and DBAs will tell you is that choosing the right datatype is important for performance reasons.  And by that, they mean the smallest datatype you can fit most of the data in. And maybe a bit smaller.  Soooo much bad info out there, I know.  When Knowledge Conquers Fear, we can love our data.  Thank the Cosmos you have me here to help you out.

What’s new in SQL Server 2014: A New Datatype

This new datatype is exciting for me as a data & space enthusiast.  The new feature finally allows modern database designers to properly specify the constraints for tracking time and location data in the same column. Yes, this means that your developers and DBAs no longer have to use comma-delimited values in their relational database designs when they need to track how much time and personal space they need to get up to speed on professional database design.  And it’s big enough to store that many man-hours.  Yeah. I said that.

BTW, it seems that Stack Overflow is *the* place to find info on how to implement comma-delimited values in database columns.  Kids, don’t get your database design knowledge from random forums on the Internet.

Anyway, back to the news!

The new feature makes so much sense with Microsoft’s push to the Cloud, it’s embracing of NoSQL technologies and all.  It’s AWESOME.

 

spacetime (Transact-SQL)

Defines a time and location in a universe.

SQL Server 2014

spacetime Description

Property

Value

Syntax

spacetime [(fractional seconds precision)], (universe, 5DGeometry)

Usage

DECLARE @MySpacetime spacetime (1000, 2014.12.0.2000.8,  image )

CREATE TABLE Table1 ( Column1 spacetime (1000, 2014.12.0.2000.8

image ) )

Time Range

to +∞ and beyond
(I hope you have lots and lots of memory and storage)

Space Ranger

@cmdr_hadfield

image

Universe Range

Please check data.NASA.gov for the up-to-date listing of known Universes Multiverses, as this changes beyond Microsoft control. There is no control. There is no center.

5DGeometry Range

[you’ll need a 5D monitor to view this range.]

Timezone offset range

Thank Venus, no, nope, never. We are scientists here. Use Multiuniversal Universal Time Coordinates (UTMC).

Daylight saving aware

Oh, for Carl’s sake. Do you really think something like spacetime needs to be sullied by DST?

Storage size

If you have to ask, you don’t ever need to use this datatype. Seriously.

Accuracy

+/- 10 Plancks. Depending on how far your server is from the Sun. Earth’s Sun, that is.

Default value

1989-05-15 12:00:00.1000  2014.12.0.2000.8 SNAGHTML5a35643

Calendar

Hubble

SQL Azure Windows Azure Dammit!
Microsoft Azure DB Support
Yes, of course.  But only in Premium plans and higher. 

 

Special Considerations and Gotchas

Some gotchas with this new datatype:

  • Due to the highly multi-dimensional, multiuniversal nature of this datatype, there isn’t any backwards compatibility.  Unless, of course, you can fold spacetime and go back and change earlier versions of SQL Server. But if you could do that, you wouldn’t be reading my blog, would you?
  • Just like the confusion over timestamps, you can’t really treat this like a date or time datatype.  It’s special.  And spatial. 
  • This means you can’t convert it to date, time, datetime, timestamp or spatial datatypes, either.
  • The 5D geometry thing is way too complex to explain in a single blog post.  But for those of you that managed to stick it out through some college level math, it involves parsecs (the correct usage of the term) and the double declining balance method of space depreciation.  In this first rollout of spacetime, the geometry completely ignores most OctoDeca Bands.  Except for Miller tracks.
  • You can’t use normal date and geometrical math on data in the columns. You can bend or fold the values, but since space has no center, and time has no beginning or end, spacetime has no beginning or end. It is infinite.  So the usual infinity rules apply.
  • This datatype is only available via O365, but that makes sense since as announced today, SQL Server 2014 is also only available via O365 subscriptions.
  • This datatype is only available at O365 plans at U3 and higher.  Wait, I don’t think I should have said anything about the new Universe O365 plans.  Forget I said anything.  That’s probably not going to be a rule in our universe.  Seriously.  No NDA broken.  I think.

 

Note

Some of this post may have been inspired by some bad veggie April Fish (poisson d’avril) I had last night.   If you want to get some real information about the new features of SQL Server 2014, you probably shouldn’t read random blogs on the internet on launch day.  Especially when it’s 1 April.

Did you catch all the special references in this post?  Let me know.

I Welcome You All to Cloud Cuckoo Land! #NoSQLKitty

Mar 5, 2014   //   by Karen Lopez   //   Awesome, Blog, Data, Fun, NoSQL, Parody, Snark  //  1 Comment

I introduce to you, NoSQKitty

 

image

With this dialog, I had to do this. I had no choice, really.  Trust me. Just ask Biznis Kitty.

Emmet: I’m just gonna come right out, I have no idea what’s going on or what this place is at all.
Unikitty: Hi! I am Princess Unikitty, and I welcome you all to Cloud Cuckoo Land!
Emmet: So there are no signs or anything. How does anyone know what not to do?
Unikitty: Here in Cloud Cuckoo Land, there are no rules. There’s no government, no baby sitters, no bedtimes, no frowny faces, no bushy moustaches, and no negativity of any kind.
Lucy: You just said the word "no" like a thousand times.
Unikitty: And there’s also no consistency.
Batman: [the clown and the lizard man are dancing around him] I hate this place.

Every single line in that scene had me choking on my popcorn.  There’s a blog post in each one.  No rules? Nope, not in schemaless.  No signs? Nope.  No bedtimes? Nope, none. As a matter of fact, I want to make up t-shirts with each of these lines. Everything is Awesome about them.

I’m not anti-cloud, at all.   Nor am I anti-NoSQL (Hey, I know that’s a double negative.  Don’t blame me that the name NoSQL seriously needs rebranding.)    Plus, with a Starbucks name of Kitty, this is *so* my character.  Cloud Cuckoo Land and all.

*And I really do get what eventual consistency is all about. I know it means there is consistency. I know when it’s perfect for solving a problem.  I’m just quoting Unikitty.  Blame her.  But watch out for Angry Kitty if you do that.

Pages:12»

Subscribe via E-mail

Use the link below to receive posts via e-mail. Unsubscribe at any time. Subscribe to www.datamodel.com by Email


Categories

Archive

UA-52726617-1