如何查看数据库？ [英] How is a database viewed?
问题描述
我是计算机编程的初学者，到目前为止我已经完成了Java和Android。我对数据库知之甚少。我有几个问题，以便清楚地了解数据库在基于计算机的应用程序开发中的位置。
1.谁创建数据库？它是如何创建的？它在哪里创建？它看起来像什么？
2.前端应用程序使用Java编码，后端数据库使用MySQL编码。使用什么过程将它们链接起来？
3.数据库创建后可以查看哪些方式？
谢谢！
我尝试了什么：
我查了在线教程，大量使用技术这些术语无法帮助我清楚地了解数据库的真实情况。
1。谁创建了数据库？它是如何创建的？它在哪里创建？它看起来像什么？
大多数开发人员 - 通常以数据管理员为幌子。基本上，我们这样做 - 因为虽然创建数据库实际上非常简单，但要做到正确却要困难得多。
我们如何创建它们？那么我们真的有很多选择。我们可以使用数据库前端程序，VS可以在紧急情况下使用，或者SSMS用于Sql服务器，或者MySQL Workbench用于MySql，甚至可以用于简单的单用户数据库。或者我们可以通过从我们的代码直接向数据库引擎发出适当的SQL命令来创建它们，就像我们的代码使用SELECT或INSERT命令来访问数据一样。
它在哪里创建？那么......
一根绳子有多长？这是同样的问题。如果您使用的是Access之类的东西，那么您可以指定首次保存文件时的位置 - 因此文件所在的位置取决于您。如果您使用像MySQL或SQL Server这样的管理系统，那么大部分时间我们都不知道，并且不关心它在哪里 - 管理系统将负责这一点。 （例外情况是我们将数据库附加到管理系统，但这只能用于开发，而不是生产）。
它看起来像什么？此：
<预郎= 文本> 0000000100001111000000000000000000001000000000100000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000100000000
0110001100000000000000000000000001100100000110111000001000010101
0000000000000000000000000000000000000001000000000000000000000000
0001100100000010000000000000000010101000000001000000000000000000
$ 0001100000000000000000000000000000000000000000000000000000000000 b $ b 0000000000000000000000000000000010010111111110111000100000100111
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
00110000000000000000000000000000000 ...这是电子二进制数据 - 它不看起来 就像任何事情一样，比你更重要r申请EXE文件呢！
2。使用Java编写前端应用程序时，使用MySQL编写后端数据库。使用什么过程来链接它们？
再次，这是一个字符串问题 - 它在很大程度上取决于服务器和客户端的确切位置，以及他们正在运行的系统。从理论上讲，它们之间可以有任何连接介质 - 包括 IPoAC [ ^ ]以及更传统的网络方法。说实话，你不需要知道这一点 - 你可以假设它完全是通过魔法完成的它也会起作用！这与你用于与打印机，互联网，电子邮件等交谈的东西是一样的......一旦你开始划清界面，它就会非常复杂！ ：笑：
3。创建数据库后，有哪些方法可以查看？
我们用来创建数据库的所有方法！但主要是通过自定义应用程序或网站。
Q1 。谁创建了数据库？它是如何创建的？它在哪里创建？它看起来像什么？
Q1.1 谁创建数据库？
答案：任何知道如何创建数据库的人都可以创建一个数据库，即使我妈妈可以在我指导她的情况下也可以。从IT角度来看，在企业软件开发期间，它通常是程序员，开发人员或DBA（数据库管理员）
Q1.2 它是如何创建的？
Ans ：可以通过以下方式创建数据库：
- 手动 - 由开发人员或DBA（数据库管理员）使用数据库管理工具，例如用于SQL Server数据库的SQL Server Management Studio
- 自动通过用C＃.Net编写的代码，例如通过ADO .Net或ORM（对象关系映射器），如实体框架
Q1.3 它在哪里创建？
Ans ：最终数据库驻留在您的硬盘上。
Q1.4 它是什么看起来像？
答案：在磁盘上它将是所有二进制文件，但当你通过数据库管理工具查看它时，你会看到表，行，列，之间的关系他们等等。
Q2 。使用Java编写前端应用程序时，使用MySQL编写后端数据库。使用什么过程将它们链接起来？
Ans ：数据库提供程序是前端java应用程序和后端数据库之间的粘合剂，例如： MySQL的。数据库提供程序最终是一个* .dll文件，其中包含与给定数据库进行交互的所有逻辑。例如对于SQL Server，有一个名为System.Data.SqlClient的着名提供程序。您将找到适用于您正在使用的Java或.Net编码环境的任何数据库（例如oracle，SQL Server，MySQL）的提供程序。
Q3 的。创建数据库后可以查看哪些方法？
Ans ：可以使用数据库管理工具查看数据库表，行，列等。用于SQL Server数据库的SQL Server Management Studio。
查看其在磁盘上存储数据库内容的文件（* .mdf，*。ldf等） - 您可以通过导航到这些文件所在的相应目录路径，通过简单的Windows资源管理器查看它们。
I'm a beginner in computer programming, and so far I've done Java and Android. I don't know much about databases. I have a few questions in order to get a clear picture of database's place in computer based application development.
1. Who creates a database? How is it created? Where is it created? And, what does it look like?
2. When a front end application is coded with Java, and a back end database is coded with MySQL. What process is used to interlink them?
3. What are the ways in which database can be viewed once they are created?
Thank you!
What I have tried:
I have checked online tutorials, which make vast use of technical terms that do not help me in getting a clear picture of what database really is.
1. Who creates a database? How is it created? Where is it created? And, what does it look like?
Developers, mostly - often in their guise as "data administrators". Basically, we do it - because while it's actually pretty simple to "create a database" getting it right is a lot harder.
How do we create them? Well we have a lot of choices really. We can use a database front end program and VS will do as that at a pinch, or SSMS for Sql server, or MySQL Workbench for MySql, or even Access for simple single-user databases. Or we can create them by issuing the appropriate SQL commands from our code directly into the database engine, in the same way that our code uses SELECT or INSERT commands to access the data.
Where is it created? Well...
How long is a piece of string? It's much the same question. If you are using something like Access then you specify where the file is when you first save it - so where the file is is up to you. If you use a management system like MySQL or SQL Server, then most of teh time we don't know, and don't care where it is - the management system will take care of that. (The exception being when we ATTACH a DB to the management system, but that's only available for development anyway, not production).
What does it look like? This:
0000000100001111000000000000000000001000000000100000000000000000 0000000000000000000000000000000000000000000000000000000000000000 0000000000000000000000000000000000000000000000000000000100000000 0110001100000000000000000000000001100100000110111000001000010101 0000000000000000000000000000000000000001000000000000000000000000 0001100100000010000000000000000010101000000001000000000000000000 0001100000000000000000000000000000000000000000000000000000000000 0000000000000000000000000000000010010111111110111000100000100111 0000000000000000000000000000000000000000000000000000000000000000 0000000000000000000000000000000000000000000000000000000000000000 0000000000000000000000000000000000000000000000000000000000000000 0000000000000000000000000000000000000000000000000000000000000000 00110000000000000000100000000000...It's electronic binary data - it doesn't "look" like anything, any more than your application EXE file does!
2. When a front end application is coded with Java, and a back end database is coded with MySQL. What process is used to interlink them?
Again, that's a "piece of string" question - it depends far too much on where exactly the server and client are, and what systems they are running. In theory, you could have any connection medium between them - including IPoAC[^] as well as more conventional networking methods. To be honest, you don't need to know this - you could assume it's "all done by magic" and it would work just as well! It's the same thing you use to talk to your printer, the internet, emails, ... and it's fiendishly complicated once you start to scratch the surface! :laugh:
3. What are the ways in which database can be viewed once they are created?
All the ways that we used to create them! But mostly via custom applications or web sites.
Q1. Who creates a database? How is it created? Where is it created? And, what does it look like?
Q1.1 Who creates a database?
Ans:Anyone who knows how to create a database can create a database, even my mom can do it if I guide her. From IT stand-point, during an enterprise software development it will typically be a programmer, developer or DBA (database administrator)
Q1.2 How is it created?
Ans:Database can be created in following ways:
- Manually - By Developer or DBA (Database administrator) using database management tools e.g. SQL Server Management Studio for SQL Server database
- Automatically through code written in C# .Net e.g. via ADO .Net or ORMs (Object Relational Mappers) like Entity Framework
Q1.3 Where is it created?
Ans:Ultimately database resides on your hard-disk.
Q1.4 what does it look like?
Ans:On disk it will be all binary stuff but when you look it through a database management tools you get to see tables, rows, columns, relationship between them etc.
Q2. When a front end application is coded with Java, and a back end database is coded with MySQL. What process is used to interlink them?
Ans: Database provider is the glue between your front end java application and the back end database e.g. MySQL. A database provider is ultimately a *.dll file which contains all the logic of doing the interaction with a given database. e.g. For SQL Server there is a famous provider named System.Data.SqlClient. You will find a provider for any database (e.g. oracle, SQL Server, MySQL) for the Java or .Net coding environment you are working upon.
Q3. What are the ways in which database can be viewed once they are created?
Ans: Database tables, rows, columns etc can be viewed using database management tools e.g. SQL Server Management Studio for SQL Server database.
To view its files (*.mdf,*.ldf etc in SQL Server) where it stores your database contents on disk - You can be view them through simple windows explorer by navigating to appropriate directory path where those files are located.
这篇关于如何查看数据库？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
