Re: [WebDNA] NoSQL: sharing some ideas

This WebDNA talk-list message is from

2013


It keeps the original formatting.
numero = 110956
interpreted = N
texte = This sounds similar to the WebDNA cart system, with the individual =20 files. On Dec 4, 2013, at 3:02 AM, christophe.billiottet@webdna.us wrote: > Sharing some ideas=85 > > I was reading about NoSQL. > > Interactive applications have changed dramatically over the last 15 =20= > years, and so have the data management needs of those apps. Today, =20 > NoSQL is increasingly considered a viable alternative to relational =20= > databases, especially as more organizations recognize that operating =20= > at scale is better achieved on clusters of standard, commodity =20 > servers, and a schema-less data model is often better for the =20 > variety and type of data captured and processed today. > > Today, most new applications (both consumer and business) use a =20 > three-tier Internet architecture, run in a public or private cloud, =20= > and support large numbers of users. > > At the database tier, relational databases were originally the =20 > popular choice. Their use was increasingly problematic however, =20 > because they are a centralized, share-everything technology that =20 > scales up rather than out. This made them a poor fit for =20 > applications that require easy and dynamic scalability. NoSQL =20 > databases have been built from the ground up to be distributed, =20 > scale-out technologies and therefore fit better with the highly =20 > distributed nature of the three-tier Internet architecture. > > Relational and NoSQL data models are very different. The relational =20= > model takes data and separates it into many interrelated tables that =20= > contain rows and columns. Tables reference each other through =20 > foreign keys that are stored in columns as well. When looking up =20 > data, the desired information needs to be collected from many tables =20= > (often hundreds in today=92s enterprise applications) and combined =20 > before it can be provided to the application. Similarly, when =20 > writing data, the write needs to be coordinated and performed on =20 > many tables. > > > > > WebDNA has all the tools to build basic NoSQL databases: > > [appendfile], [deletefile], [writefile], [createfolder], [include] =20 > etc... > > Basically, storing data in "NoSQL format" writes XML or JSON (or =20 > not) formatted files, one file per record. If the files are text =20 > files, then they are fully transportable, whatever the platform, a =20 > cloud storage being ideal. WebDNA databases as we know them just =20 > record an index of these files and few more data, whatever we want, =20= > and the place of the file, whatever the disk, whatever the server. =20 > It is not even necessary to keep all the files on the same server or =20= > in the same data center. It is fully scalable. > > I built my first NoSQL database in 2000 with WebDNA, without even =20 > knowing how to name it. It was a invoicing system and customers had =20= > to be able to recover their invoices online. Invoices were just text =20= > files, included into a design frame, with an index in a WebDNA =20 > database. > > As of today, the frame design changed, the platform changed three =20 > times and is now hosted in a cloud, and there are 385,962 invoices =20 > devided in about 100 directories. WebDNA index keeps track of the =20 > files names and paths as well as few other informations, but the =20 > WebDNA indexing database takes less than 13MB. Searching for an old =20= > invoice takes miliseconds. The cloud offers high availability and =20 > load sharing=85 > > - chris > > Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] NoSQL: sharing some ideas (Terry Wilson 2013)
  2. Re: [WebDNA] NoSQL: sharing some ideas (christophe.billiottet@webdna.us 2013)
  3. RE: [WebDNA] NoSQL: sharing some ideas ("Terry Nair" 2013)
  4. [WebDNA] NoSQL: sharing some ideas (christophe.billiottet@webdna.us 2013)
This sounds similar to the WebDNA cart system, with the individual =20 files. On Dec 4, 2013, at 3:02 AM, christophe.billiottet@webdna.us wrote: > Sharing some ideas=85 > > I was reading about NoSQL. > > Interactive applications have changed dramatically over the last 15 =20= > years, and so have the data management needs of those apps. Today, =20 > NoSQL is increasingly considered a viable alternative to relational =20= > databases, especially as more organizations recognize that operating =20= > at scale is better achieved on clusters of standard, commodity =20 > servers, and a schema-less data model is often better for the =20 > variety and type of data captured and processed today. > > Today, most new applications (both consumer and business) use a =20 > three-tier Internet architecture, run in a public or private cloud, =20= > and support large numbers of users. > > At the database tier, relational databases were originally the =20 > popular choice. Their use was increasingly problematic however, =20 > because they are a centralized, share-everything technology that =20 > scales up rather than out. This made them a poor fit for =20 > applications that require easy and dynamic scalability. NoSQL =20 > databases have been built from the ground up to be distributed, =20 > scale-out technologies and therefore fit better with the highly =20 > distributed nature of the three-tier Internet architecture. > > Relational and NoSQL data models are very different. The relational =20= > model takes data and separates it into many interrelated tables that =20= > contain rows and columns. Tables reference each other through =20 > foreign keys that are stored in columns as well. When looking up =20 > data, the desired information needs to be collected from many tables =20= > (often hundreds in today=92s enterprise applications) and combined =20 > before it can be provided to the application. Similarly, when =20 > writing data, the write needs to be coordinated and performed on =20 > many tables. > > > > > WebDNA has all the tools to build basic NoSQL databases: > > [appendfile], [deletefile], [writefile], [createfolder], [include] =20 > etc... > > Basically, storing data in "NoSQL format" writes XML or JSON (or =20 > not) formatted files, one file per record. If the files are text =20 > files, then they are fully transportable, whatever the platform, a =20 > cloud storage being ideal. WebDNA databases as we know them just =20 > record an index of these files and few more data, whatever we want, =20= > and the place of the file, whatever the disk, whatever the server. =20 > It is not even necessary to keep all the files on the same server or =20= > in the same data center. It is fully scalable. > > I built my first NoSQL database in 2000 with WebDNA, without even =20 > knowing how to name it. It was a invoicing system and customers had =20= > to be able to recover their invoices online. Invoices were just text =20= > files, included into a design frame, with an index in a WebDNA =20 > database. > > As of today, the frame design changed, the platform changed three =20 > times and is now hosted in a cloud, and there are 385,962 invoices =20 > devided in about 100 directories. WebDNA index keeps track of the =20 > files names and paths as well as few other informations, but the =20 > WebDNA indexing database takes less than 13MB. Searching for an old =20= > invoice takes miliseconds. The cloud offers high availability and =20 > load sharing=85 > > - chris > > Terry Wilson

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

no [search] with NT (1997) Not really WebCat- (1997) multiple search commands (1997) Modtime bug? (2002) [WebDNA] Lookup serial number of purchase? (2011) Re2: AAgghh!! Help, please. SSL strikes again. (1997) Frames and WebCat (1997) hidden databases (2000) More questions about serial number dishing (1997) Re:Change WebDNA-Talk Mail due to no digest for 1wk (1997) 4D Database (1997) Thanks Grant (1997) [WebDNA] 6.2 Monitor (2012) webcat NT (1998) apostrophe in search item (1997) Can I determine where they are coming from? (2000) Setting up WebCatalog with Retail Pro data (1996) [input] context (1999) Variables for chat (1997) Download Question (1997)