Development Architecture blog is designed for developers who have some troubles in their code.
This blog will be mainly on web development, though many of it's posts can be used also on software design.
I wish you nothing but the best,
Privacy and security issues in terms of ownership of data
Privacy and/or security
issues are inherent in large databases. Who owns the data about a particular
person: medical, credit, personal, financial, consumer information, etc.?
Support your position.
database is specialized to manage and handle data in a computer application
system. Data can be stored in many forms, like text, symbols, digital, images,
graphics, and even sound. Various sectors like government, public security,
finance, medical, energy, business, taxation, transportation, social,
education, corporate and other sectors have formed their own databases application
systems to store large amounts of information in the database, to handle and
use, in order to lead the society into this information era. With the advance
in internet applications, databases have a greater role to play (Ji 2011).
further goes on to say that while development of these database applications
systems has brought about social development and progress, it has also created
issues of security and privacy of the stored data. The potential safety hazards
for large databases are great, owing to their universality. One example is a
hospital database where illegal invasion leads to stealing of numerous
patients’ private information.
the question is who owns this data? Who is responsible for it? Data ownershipmeans both possession of and
responsibility for the data. Ownership refers to power and control both. (Loshlin
2001).Telling the consumer that he "owns" his corporate data is very
dangerous. If he tries to exercise his "rights" of ownership it could
have disastrous repercussions on the enterprise and its data. The term
"stewardship" is a better term to explain this. It involves a broader
responsibility and here where the user must consider the consequences of changing
"his" data (Scofield 1998).
about medical data? Who owns it? There was never a doubt when it was about
paper records. It was mainly the clinicians and insurers who owned the medical
records. But with the development of electronic health information, it becomes
problematic. The law gives patients the rights of privacy and access to their
own records but federal and state laws do not give property rights to patients.
Patients do not have the right to solely possess or destroy their original records
(Hall & Schulman 2009)
the enforcement of laws like Health Insurance Portability and Accountability
Act (HIPAA) and requirements of Sarbanes Oxley (SOX) auditors, organizations
are beginning to realize the importance of securing their data properly .First
of all, the data is classified into private, company confidential, company
restricted,and public. This
classification of data is done by the owner. Here the owner is the director or
head of the organization. For a financial organization it may be the CFO.
data owner is responsible for setting up a policy so that only authorized
people can access and see the data. The data owner must also determine who has
access to the data; how the data should be kept secure, for how long the data
must be retained, what the appropriate disposal methods are, and whether the
data should be encrypted.(Woodbury
is a complicating issue. What information should remain private, and in what
situations? Consider credit information. When someone applies for a credit card
it is considered private information, although in order to receive that credit,
a credit bureau is consulted. At that point, the fact that the credit card
application has been taken is now added to the credit record.
says that appropriate data ownership and data classification are key elements
in an organization’s security policy. Without these, it will be difficult to
implement a security policy. An organization, be it finance, medical, credit,
or consumer related, will not be able to meet the regulatory and internal
requirements regarding access control for its data, without this.
·Hall, M.A. and Schulman, K.A. (2009). Ownership of
Medical Information. The Journal of the
American Medical Association, 301 (12), p. 1282-1284.
·Ji, J. (2011). Security
Issues with Databases [Online]. Available at:
The only way to avoid the unfairness of a copyright tax that funds benefits for criminals is to decriminalize the benefit and make "piracy" legal for everyone. The public good provided by the tax then corresponds to the provision of free content for everyone. What are the advantages and disadvantages of decriminalizing piracy? Please see the following for a description of copyright tax: http://www.1729.com/ip/CopyrightLevies.html 8 Advantages and Disadvantages of Decriminalizing Privacy The intentional violation of the Copyrights Act, in relation to commercial products like music, software, and so on, is known as ‘privacy’. For instance, if you use a music recording or software without a license or make a copy of it to distribute without permission from the creator, you are violating the Copyright Act (Dorrel 2005). The main objective of copyrighting is for the creator to be able to recover all the costs he/she invested in producing the work. Thus copyrighting becomes
Split String in SQL Server. NVARCHAR and VARCHAR Split in MS SQL. For all of you there who wishes to preform a simple "split" on a varchar on nvarchar input in ms sql (sql server) this is for you: Basically, this post's gonna contain a Create Function Script which you will to execute in your server. It will also contain the simplest way to use it. There will be more examples in a different post I'll upload soon... CREATE FUNCTION dbo.Split ( @RowData nvarchar(2000), @SplitOn nvarchar(5) ) RETURNS @RtnValue table ( Id int identity(1,1), Data nvarchar(100) ) AS BEGIN Declare @Cnt int Set @Cnt = 1 While (Charindex(@SplitOn,@RowData)>0) Begin Insert Into @RtnValue (data) Select Data = ltrim(rtrim(Substring(@RowData,1,Charindex(@SplitOn,@RowData)-1))) Set @RowData = Substring(@RowData,Charindex(@SplitOn,@RowData)+1,len(@RowData)) Set @Cnt = @Cnt + 1 End