{"id":1934,"date":"2010-11-22T18:20:42","date_gmt":"2010-11-22T23:20:42","guid":{"rendered":"http:\/\/analystik.ca\/?p=1934"},"modified":"2017-02-08T09:35:53","modified_gmt":"2017-02-08T14:35:53","slug":"the-databases-heart-business-reality","status":"publish","type":"post","link":"https:\/\/analystik.ca\/blogue\/language\/en\/the-databases-heart-business-reality\/","title":{"rendered":"The Database \u2013 always at the heart of a company\u2019s business reality"},"content":{"rendered":"

Amazingly, 25 years ago, the only people who spoke of Databases (DB<\/strong>) were the IT<\/strong> folks. They were perceived within large enterprises, not just as geeks but as business gurus. They held the secret formulas, some sort of modern day sorcerers.<\/p>\n

Over time, the variety of databases<\/strong> available has diversified. Databases<\/strong> infiltrated the universe of many different departments of businesses; be it the Sales Force<\/em> with its CRM<\/strong>, Human Resources<\/em> (HR) with a homemade Access application, the Finance <\/em>department with their multitude of Excel<\/strong> sheets (even if strictly speaking, they\u2019re not really databases<\/strong>, it must be pointed out that Excel<\/strong> still manages the largest amount of data stored globally), Production<\/em> and Purchasing<\/em> with their ERP<\/strong>, etc. And that\u2019s without counting the best years of Visual FoxPro,\u00a0<\/strong>\u00a0which has been replaced by SQL<\/strong>, Oracle<\/strong> and many others\u2026<\/p>\n

Since that time, we have bandied about the term across levels of business, for example: \u201cI think we have that into our Database\u00a0\u00bb<\/p>\n

Good evening, tonight on Discovery: The Adventures of Databases\u2026<\/h2>\n

Strangely, although today data is utilised throughout all levels within a company. The sentiment still exists that only IT<\/strong> people really understand the importance of data, and yet, they don\u2019t necessarily see the potential because it\u2019s not their role or expertise: promoting the value of information<\/strong> within the company!<\/p>\n

These data warehouses, \u00a0built by anyone and everyone, are often poorly designed and difficult to maintain or evolve. A design error when creating your \u201cdata container\u201d may cost you thousands of dollars.<\/p>\n

Similarly, data security is extremely fragile in business, often at risk whether it be financial data or personal customer information, this information is often all too easily accessible by too great a number of employees within the company. Moreover, it\u2019s frequent for much of this data to end up on mobile devices, be it laptops or smartphones, which greatly increases the vulnerability of your business.<\/p>\n

Once again, over time, several systems have been created within companies, but they almost always work in isolation, no systemic integration is planned, nor is there functionally between systems. Therefore a company very often holds the same information in several places, which inevitably results in a problem of data integrity and consistency of information that could have expensive repercussions that can be difficult to evaluate.<\/p>\n

One example: the underutilization of data. It\u2019s not uncommon for a department to possess data of great value to a business at a policy level. But the lack of expertise \u00a0can leave this precious data dormant, never to be put to good use.<\/p>\n

The moral of the story<\/h2>\n

When you think about your business development through application development or optimization of your processes. You cannot neglect the backup data and must remember to plan for the integration of your data to capitalize on its usage.<\/p>\n

Conclusion<\/h2>\n

Remember that Databases are not just the core of your company\u2019s business reality and processes; they are the heart of it! Your productivity will always commence with a well-structured and well-designed database (or end with a bad…). Your applications will evolve, change, and migrate but your data, that\u2026 that will always remain.<\/p>\n

In short, applications come and go but the data remains the same\u2026 I think someone made a song about this?<\/p>\n

Have a great week,<\/p>\n

Denis<\/em><\/strong><\/a><\/p>\n

\n","protected":false},"excerpt":{"rendered":"

Amazingly, 25 years ago, the only people who spoke of Databases (DB) were the IT folks. They were perceived within large enterprises, not just as geeks but as business gurus. They held the secret formulas, some sort of modern day sorcerers. Over time, the variety of databases available has diversified. Databases infiltrated the universe of… Read more »<\/a><\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_seopress_robots_primary_cat":"","_seopress_titles_title":"The Databases \u2013 always at the heart of a company\u2019s business reality","_seopress_titles_desc":"Databases have diversified greatly, databases infiltrated the universe of many departments; be it the Sales Force with its CRM, Human Resources (HR)...","_seopress_robots_index":"","content-type":"","footnotes":""},"categories":[3423,3419,2579,3421,3425],"tags":[2972,2857,1245,1151,3056,3096],"better_featured_image":null,"_links":{"self":[{"href":"https:\/\/analystik.ca\/blogue\/wp-json\/wp\/v2\/posts\/1934"}],"collection":[{"href":"https:\/\/analystik.ca\/blogue\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/analystik.ca\/blogue\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/analystik.ca\/blogue\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/analystik.ca\/blogue\/wp-json\/wp\/v2\/comments?post=1934"}],"version-history":[{"count":3,"href":"https:\/\/analystik.ca\/blogue\/wp-json\/wp\/v2\/posts\/1934\/revisions"}],"predecessor-version":[{"id":11048,"href":"https:\/\/analystik.ca\/blogue\/wp-json\/wp\/v2\/posts\/1934\/revisions\/11048"}],"wp:attachment":[{"href":"https:\/\/analystik.ca\/blogue\/wp-json\/wp\/v2\/media?parent=1934"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/analystik.ca\/blogue\/wp-json\/wp\/v2\/categories?post=1934"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/analystik.ca\/blogue\/wp-json\/wp\/v2\/tags?post=1934"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}