Database Architecture

Database systems atomic number 18 a way to collect and store large amounts of info. Essentially, database are electronic register systems that store raw data to be later retrieved as practicable information (Skillport, ). Using such a tool simplifies the filing and transshipment center of all sorts of information physical exertiond by businesses today. A common geek of database is a customer/inventory database. Different evades store customer information, bypast customer orders, inventory counts and distributor information and then this information stool be cross-referenced for following inventory pathways.For example, the customer table will have a bun in the oven a primary key which is individual for each(prenominal) customer. This key fuel then be referenced by the customer order table which maintains order history for all customers. The products table can use the alike(p) process to entree inventory counts and/or supplier information. All of this data is stored s eparately, but used in different ways. Its more streamlined and more secure than a normal filing system. According to Wingenious (2005),The database computer architecture is the set of specifications, rules, and processes that dictate how data is stored in a database and how data is admission feeed by comp peerlessnts of a system. It includes data types, relationships, and naming conventions. The database architecture describes the organization of all database objects and how they work at together. It affects integrity, reliability, scalability, and performance. The database architecture involves anything that defines the nature of the data, the structure of the data, or how the data flows (Introduction).Depending on the type of architecture you need, in that location are many pickaxes in software for your Database instruction System (DBMS). For small businesses where fewer than 50 users need to access the database and where data can be stored at a centralized location, the be st choice would be Microsoft Access. The program has an easy-to-use GUI interface and for designing tables within the database (Coronel, Morris, & Rob, 2013). For a larger businesses, or businesses where more than 50 users would need to access the database at the same time, a DBMS with more features is recommended.These DBMS programs usually alike have the option to have data stored at and accessed from more than one location, or a distributed database Microsoft SQL Server allows doubled users to access its databases and can flush be accessed from more than one location (Coronel, Morris, & Rob, 2013). Using Microsoft SQL Server Express, it is until now possible for data to be stored locally until the network can access the main server through the network, should network outages become a problem. With this tool, level with the servers go down, users can still input work locally and access the local entries .Jack Henry & Associates uses Microsoft SQL for some rather advanced data bases. Financial institutions use their software to enter and access large amounts pecuniary information, particularly transportation system items such as checks, draft slips and return items. These are worked at each branch then host exported into an AS/400 system to identify to individual accounts. The same information is also sent to another SQL database where files are imported and exported to the Federal Reserve Bank or other financial institutions.Many of our clients are small institutions where there are fewer than 50 users and exclusively one location. While these clients could use the smaller DBMS, such as Microsoft Access, there are larger clients to consider as well, who have more than 50 users on the system and significant amounts of data collected and transmitted to multiple locations, a larger DBMS is required. Previously, the databases were stored only on the main server, barely the newer versions of the software we use require distributed databases, by means of Microsoft SQL Server Express.