Data Storage Design Large Business

Data Storage Design

Large business organizations and even individuals with complex activities which require efficient and speedy processing of voluminous transactions resort to the adoption of a database management system (DBMS), where database is to be defined, constructed, and manipulated. Microsoft Access is one of the many products that can be classified as an end-user database. It provides a graphical user interface that makes it very easy to define and manipulate databases, without the need of writing a Structured Query Language (SQL). Like LEAP, it has been used by students, lecturers and by a number of establishments around the world to improve their understanding of relational theory and relational query languages. On the other hand, the CodeBase family is another product that can be classified as an enterprise database. It is best to use when you need database access locally, in a shared network environment, or over the Internet, at a very high speed. Major companies like IBM, Microsoft, Oracle, Sybase, and others provide both end-user and enterprise databases. These are described in accordance with the purpose of its use. A detailed manual is provided for each product, from installation up to operational process (e.g. how to list the attributes of a relation, how to update and delete tuples in a relationship, etc.) Generally, these are marketed in print, digital and broadcast media. Books and manuals are available in various establishments as well as in commercial websites. Lectures and conventions are also being held by various IT group to introduce the products. An organization may opt to implement an end-user database over an enterprise database because of the cost involved, the size of data to be handled and the simplicity of the requirements in maintaining the system. Aside from the files that are needed to support the end-user database, the latter might also require the use of a high performance, comprehensive SQL database solution together with other development tools and applications like Visual Basic, ADO, B.NET, ADO.NET, ODBC, ODBC.NET, C/C++, C++.NET, C# (Csharp), Visual C++, Delphi, Borland C++Builder, ASP.NET, PHP, Crystal Reports, and more.

In order to support the end-user database application, the user must maintain files like Adobe, Acrobat (pdf), PostScript, and FrameMaker to rapidly setup, test, modify, run, save and print database. Microsoft Excel files are also needed to enable information distribution in spreadsheet form and mark-up files (e.g., HTML, XML, etc.). There is no need to learn a programming language or meta-language and the setup can be accomplished by using a graphical user interface (GUI).