Skip to main content

The New Computer Age: Office 365 Should Never be Compared to Google Apps or Dropbox.


Differences in File Storage

Office 365 with SharePoint on-line should never be compared to Dropbox, Google Apps, Google Docs, Amazon cloud offerings or Microsoft OneDrive Live. These are good products and competitive in the market place they serve, but they are just cloud storage. They all store files off-site in an NTFS type file store. SharePoint on-line stores files in a SQL database delivering huge advantages in security, file grouping, file analysis and file location.

What does this mean in practice? – If you consider a standard NTFS file storage system such as you would find on any computer.
 
 

When you create and save a file you are prompted to give the file a name so that you can find it again when it is needed. Most modern software will also be configured to save the file to a default location such as ‘documents’ or ‘my documents’. You can elect to modify the location by creating new sub-folders within the ‘documents’ folder. This way you can group similar files together, say by subject or function. So, a user’s documents area may have sub-folders like ‘invoices’, ‘orders’, Fred Blogs Ltd, etc. In addition, the NTFS file store will record ‘date created’, ‘date modified’ and ‘file size’ for each file. Standalone computers usually have the default ‘documents’ folder on a local hard disk drive or a cloud resource, but networked computers are often configured to default to a department, or team ‘documents’ area that is a network share on a server and all users store their documents here either in a personalised folder or in team folders where other users can access them as required. This practise makes it simpler for the IT team to copy the files to a backup device to protect against file loss or corruption.

This system works and has served well for decades, but it has weaknesses.

1.       File naming is open to each individual user preference. The human mind is individual and what may be obvious as to one individual as a distinctive file name is often confusing for other users. This can be overcome by enforcing a corporate ‘standardfor file naming, but that requires training for users in what they must, and must not, include in a file name.

2.       As users can create sub-folders within the storage area and files can end up being buried many layers deep in a file system.

3.       By default, the file search facility in a NTFS system searches file names, created date and modified date. This can be changed to enable indexing by metadata and even content search, but this slows the whole storage system down to a considerable degree. Additionally, file searches in NTFS systems usually take quite a long time, especially if the file resides in a storage area used by many people.

The SharePoint Alternative.
In Office 365 Library Files are saved into a SQL database which requires certain metadata for each item stored. Grouping of similar files is achieved by creating separate ‘Libraries’, which are effectively separate SQL tables in the database.

 
 
Configuration of ‘Librariesis a simple task that can be completed by a user, or restricted to a supervisor for more effective control. Alternatively, files can by grouped within a library by including a metadata column which identifies what category the file belongs to. To ensure that different users are consistent in categorisation this can be populated by use of drop list menus. For instance, a drop list can contain ‘invoices’, ‘orders’, ‘correspondence’, etc., if the file is an invoice, the user would simply select ‘invoice’ from the list.
The files are stored in a database along with the metadata that describes each entry. In addition to each file being searchable by looking through the list, each metadata column can be filtered and sorted to display only groups of files that are relevant to the search.

The above shows only documents with the word ‘business’ in the name, but the search could just have easily been on multiple columns to deliver such results as documents which contain particular words in the name and that were created after a particular date, or before a particular date, or between two dates, or indexed by a particular user.

Additionally, as the files are stored in a database they can be ‘crawled’ as a matter of routine. O365 SharePoint on line ‘crawls’ content every 15 minutes or so. Provided that the content of a file is of a type that is readable (Word, Excel, Power Point, HTML notepad, etc.) the entire content will be indexed and searchable.

This means that a short time after indexing a document into the library it will be findable with the use of the ‘Search’ option found just below the App Launcher icon on the library screen.

This means that a search, either on all documents in the library, or on the whole site (multiple libraries) will return all documents which contain the search string.


 




Comments

Popular posts from this blog

Electronic Document Storage and Management (EDMS)

EDMS is not just a means of storing computer files. A full EDMS system allows for the process of importing both paper and computer generated documents into a computer system and indexing the files for easy and swift retrieval. In effect you can dispose of your traditional paper filing system. No more gathering letters, invoices and orders into filing groups and no more slotting them into the correct folders. Of course, you only use a paper filing system because you know you may need that document again in the future. Equally, when you do want that document it's invariably missing, either misfiled, or on someone else's desk. With EDMS documents are where you placed them and they are available for you to use where ever you are. All you need is a computer, tablet or smart phone and an Internet connection.As most modern businesses already use the Internet for everyday interaction with banks, Inland Revenue, Companies House, insurance companies, suppliers and customers it no longer ...

Leadership: So you want to be Powerful?

Throughout my life, in both business and personal spheres I have found that individuals seeking answers invariably look for 'silver bullet' solutions.     In a recent post on LinkedIn a n Influencer wrote that she had been asked the question ' Who is the most powerful person you ever met? '     The question was posed by a 17 year old and the author guessed that the answer being sought was the name of some sort of X-Factor figure, This strikes a cord with me. Throughout my life, in both business and personal spheres I have found that individuals seeking answers invariably look for 'silver bullet' solutions. This applies to all generations, 'Boomer, X-Gen and Millennial, it applies to individuals of all levels of intelligence, and to individuals at all levels of authority.     The desire for someo ne to appear, like a genie from a lamp, wit h either ' the answer' to a problem , or ' the power' to solve the problem, or...

Law and Order: The Anonymous Text Tip-Off

The following article came out of an interview conducted with Max Doleh - Law enforcement organisations and Crime Stopper programs are turning to technology which enables text tip-off from the public to facilitate a police response. In September 2007 Master Sergeant Charles Phillips of the Oklahoma City Police Department published an item on the Oklahoma City Crime Stoppers web site (http://www.okccrimetips.com/ ) calling for increased resources to bring this technology to OKC. In November 2007 it was announced that Crime Stoppers of Oklahoma City have engaged technology company ProductiveT to develop an SMS system that is radically different to others in use in the country. Max Doleh, ProductiveT president and CEO answers questions – 1 . What makes the Oklahoma City system so different? The ProductiveT technology differs greatly from other offerings. The police department have their own dedicated number for receiving the messages and unlike most systems there is no need for the sender...